# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=916 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 917 --- ## [Only show most current docs in Dashboard or Visualization](https://discuss.elastic.co/t/only-show-most-current-docs-in-dashboard-or-visualization/230785)
**Author:** [@cglencr](https://discuss.elastic.co/u/cglencr)\ **Replies:** 3\ **Last updated:** [May 19, 2020, 11:46pm UTC](https://discuss.elastic.co/t/only-show-most-current-docs-in-dashboard-or-visualization/230785 "2020-05-19T23:46:31Z")
Here is an example of what I would like to do in Elastic Every 10 minutes temperatures from cities are sent to an Elastic index: citytemps Citytemps index Index \_id CityID CityName TemperatureDate Temperature jkskhj2… --- ## [Elastic Search - Lookup Nodes](https://discuss.elastic.co/t/elastic-search-lookup-nodes/233126)
**Author:** [@nages](https://discuss.elastic.co/u/nages)\ **Replies:** 5\ **Last updated:** [May 19, 2020, 11:43pm UTC](https://discuss.elastic.co/t/elastic-search-lookup-nodes/233126 "2020-05-19T23:43:25Z")
I am going through the documentation of network settings - I had few queries with respect to the best practices . Should the nodes be assigned static ip address for other nodes to reach out reliably or DNS lookup Doesn… --- ## [Streaming from elasticsearch to local file in java](https://discuss.elastic.co/t/streaming-from-elasticsearch-to-local-file-in-java/233330)
**Author:** [@Pankaj\_Kumar1](https://discuss.elastic.co/u/Pankaj_Kumar1)\ **Replies:** 12\ **Last updated:** [May 19, 2020, 11:42pm UTC](https://discuss.elastic.co/t/streaming-from-elasticsearch-to-local-file-in-java/233330 "2020-05-19T23:42:31Z")
I have a large Document in elasticsearch(deployed in server) and i want get that document and store in local file without give more load on JVM- using streaming. Is it doable or not, if yes how? for example- in elastic… --- ## [Index Life Cycle policy is not showing linked indices](https://discuss.elastic.co/t/index-life-cycle-policy-is-not-showing-linked-indices/233339)
**Author:** [@giridhar\_M](https://discuss.elastic.co/u/giridhar_M)\ **Replies:** 0\ **Last updated:** [May 19, 2020, 2:25pm UTC](https://discuss.elastic.co/t/index-life-cycle-policy-is-not-showing-linked-indices/233339 "2020-05-19T14:25:44Z")
The linked indices count is showing as '0' even though the life cycle policy name does appear under "settings" section for the index. Appreciate if anyone can help to resolve this issue. Thanks! --- ## [Unable start elasticsearch Unable to revive connection: https://1.1.1.1:9200](https://discuss.elastic.co/t/unable-start-elasticsearch-unable-to-revive-connection-https-1-1-1-1-9200/233312)
**Author:** [@tXambe](https://discuss.elastic.co/u/tXambe)\ **Replies:** 1\ **Last updated:** [May 19, 2020, 11:04pm UTC](https://discuss.elastic.co/t/unable-start-elasticsearch-unable-to-revive-connection-https-1-1-1-1-9200/233312 "2020-05-19T23:04:26Z")
Hello, I can't start the elasticsearch service , I have this error: Job for elasticsearch.service failed because a timeout was exceeded. Execute journalctl -xe and: \`\`\`may 19 14:02:52 spro kibana\[29316\]: {"type":"lo… --- ## [Update version](https://discuss.elastic.co/t/update-version/233393)
**Author:** [@Oscar\_Benitez](https://discuss.elastic.co/u/Oscar_Benitez)\ **Replies:** 1\ **Last updated:** [May 19, 2020, 10:51pm UTC](https://discuss.elastic.co/t/update-version/233393 "2020-05-19T22:51:11Z")
Good afternoon, I have installed elastic version 7.6 and I want to change to version 7.7, how can I do it? --- ## [How to enforce accepting one specific index mapping type?](https://discuss.elastic.co/t/how-to-enforce-accepting-one-specific-index-mapping-type/232522)
**Author:** [@jmong](https://discuss.elastic.co/u/jmong)\ **Replies:** 7\ **Last updated:** [May 19, 2020, 9:58pm UTC](https://discuss.elastic.co/t/how-to-enforce-accepting-one-specific-index-mapping-type/232522 "2020-05-19T21:58:30Z")
We have a daily generic logstash-YYYY.mm.dd index that many clients insert various documents into. However, one client was using meta-field “{\_type: posts}” while others' documents were being rejected because they used “… --- ## ["Could not get a Transport from the Transport Pool for host" error slows down spark job to dump data into ES clusters](https://discuss.elastic.co/t/could-not-get-a-transport-from-the-transport-pool-for-host-error-slows-down-spark-job-to-dump-data-into-es-clusters/233240)
**Author:** [@yuecong](https://discuss.elastic.co/u/yuecong)\ **Replies:** 0\ **Last updated:** [May 19, 2020, 4:28am UTC](https://discuss.elastic.co/t/could-not-get-a-transport-from-the-transport-pool-for-host-error-slows-down-spark-job-to-dump-data-into-es-clusters/233240 "2020-05-19T04:28:14Z")
I have one spark job to dump data into the ES cluster via wan mode, and we observed that when the doc is with some big size. like 150kb, it will have a lot of Could not get a Transport from the Transport Pool for host er… --- ## [Error setting up Dashboards](https://discuss.elastic.co/t/error-setting-up-dashboards/232887)
**Author:** [@eemtzc](https://discuss.elastic.co/u/eemtzc)\ **Replies:** 4\ **Last updated:** [May 19, 2020, 9:30pm UTC](https://discuss.elastic.co/t/error-setting-up-dashboards/232887 "2020-05-19T21:30:25Z")
Hello, I have a 7 node ES cluster based on 3 MN and 4 DN version 7.5, using TLS. The cluster has been working without a problem until this morning when I attempt to install auditbeat on one master node to start testing … --- ## [CORS issue when accessing REST Javascript API](https://discuss.elastic.co/t/cors-issue-when-accessing-rest-javascript-api/233401)
**Author:** [@SriKot](https://discuss.elastic.co/u/SriKot)\ **Replies:** 0\ **Last updated:** [May 19, 2020, 8:22pm UTC](https://discuss.elastic.co/t/cors-issue-when-accessing-rest-javascript-api/233401 "2020-05-19T20:22:30Z")
we are trying to access elastic search from a webpage, we are getting this error. i have made changes in apm-server.yml for APM cluster under "User Settings Override" section from elastic console is there a document whi… --- ## [Auto deployment of elasticsearch with Rancher2.x](https://discuss.elastic.co/t/auto-deployment-of-elasticsearch-with-rancher2-x/233399)
**Author:** [@chinmoy\_padhi](https://discuss.elastic.co/u/chinmoy_padhi)\ **Replies:** 0\ **Last updated:** [May 19, 2020, 8:03pm UTC](https://discuss.elastic.co/t/auto-deployment-of-elasticsearch-with-rancher2-x/233399 "2020-05-19T20:03:28Z")
Hi, I'm new to elasticsearch and looking for some automation approach to deploy the elasticsearch using Rancher 2.x. Preferably I'm looking on Python to implement some sort of auto deployment so that it will save deploy… --- ## [Painless Script: Splitting a string by '/'](https://discuss.elastic.co/t/painless-script-splitting-a-string-by/233379)
**Author:** [@Tim\_Estes](https://discuss.elastic.co/u/Tim_Estes)\ **Replies:** 1\ **Last updated:** [May 19, 2020, 6:13pm UTC](https://discuss.elastic.co/t/painless-script-splitting-a-string-by/233379 "2020-05-19T18:13:06Z")
Hello, Here's my scenario. I have an index full of documents. I'm trying to create a new field called parent\_folder\_path which will be based on the already existing path field. For example, if path is populated by exam… --- ## [Removing boost term from scoring or make it 1?](https://discuss.elastic.co/t/removing-boost-term-from-scoring-or-make-it-1/233347)
**Author:** [@divyanshumarwah](https://discuss.elastic.co/u/divyanshumarwah)\ **Replies:** 0\ **Last updated:** [May 19, 2020, 2:45pm UTC](https://discuss.elastic.co/t/removing-boost-term-from-scoring-or-make-it-1/233347 "2020-05-19T14:45:26Z")
Hi, Is there some way, that I can remove default boost term from elastic relevance scoring or make it 1(so it does not reflect in scoring). for example, input query is GET test\_index/\_search { "query": { "match"… --- ## [Possible to run a geohash query based on geo\_shape Point type?](https://discuss.elastic.co/t/possible-to-run-a-geohash-query-based-on-geo-shape-point-type/233375)
**Author:** [@corrigancd](https://discuss.elastic.co/u/corrigancd)\ **Replies:** 1\ **Last updated:** [May 19, 2020, 5:17pm UTC](https://discuss.elastic.co/t/possible-to-run-a-geohash-query-based-on-geo-shape-point-type/233375 "2020-05-19T17:17:38Z")
Hello Elasticsearch, I would like to get some clarification on the possibilities to use a geo\_shape point type for a geohash aggregation query? When I use the location field, i.e. a geo\_point field type, all is working… --- ## [Elasticsearch 7.7 Cluster Nodes](https://discuss.elastic.co/t/elasticsearch-7-7-cluster-nodes/232849)
**Author:** [@spike83](https://discuss.elastic.co/u/spike83)\ **Replies:** 4\ **Last updated:** [May 19, 2020, 5:15pm UTC](https://discuss.elastic.co/t/elasticsearch-7-7-cluster-nodes/232849 "2020-05-19T17:15:58Z")
Hi, Since upgrading to 7.7 I get the following Error when accessing the Nodes section in the Cluster Status screen. Can Anyone shed some light? I have xpack.monitoring.collection.enabled set to true Monitoring Request… --- ## [Need help with a select type field](https://discuss.elastic.co/t/need-help-with-a-select-type-field/233371)
**Author:** [@Change\_Shell](https://discuss.elastic.co/u/Change_Shell)\ **Replies:** 1\ **Last updated:** [May 19, 2020, 4:09pm UTC](https://discuss.elastic.co/t/need-help-with-a-select-type-field/233371 "2020-05-19T16:09:08Z")
Hello everyone, I will put a field to document in format UA-2020-1605-er. But users can search in a case insensitive like ua-2020-1605-er or UA-2020-1605-ER, length, and format always the same. If I try set type "UaId": … --- ## [Problem with ElasticSearch username and password using serilog](https://discuss.elastic.co/t/problem-with-elasticsearch-username-and-password-using-serilog/233364)
**Author:** [@Mahdieh\_Hosseini](https://discuss.elastic.co/u/Mahdieh_Hosseini)\ **Replies:** 0\ **Last updated:** [May 19, 2020, 3:45pm UTC](https://discuss.elastic.co/t/problem-with-elasticsearch-username-and-password-using-serilog/233364 "2020-05-19T15:45:00Z")
I'm using the serilog in my ASP.NET Core app to log data to Elasticsearch. My code was working fine when the xpack.security was disabled. I enabled the security and defined passwords for default users (elastic, apm\_syste… --- ## [Painless Script to Update Array](https://discuss.elastic.co/t/painless-script-to-update-array/233362)
**Author:** [@mrbarret](https://discuss.elastic.co/u/mrbarret)\ **Replies:** 0\ **Last updated:** [May 19, 2020, 3:43pm UTC](https://discuss.elastic.co/t/painless-script-to-update-array/233362 "2020-05-19T15:43:01Z")
I am using ELK 7.4.2 and need to write a script to update documents in my cluster. (We have about 20 TB of data so I also ask for advice about optimizations!) I have documents that look like { "owner": "Matt", "… --- ## [Okta Integration with elasticsearch](https://discuss.elastic.co/t/okta-integration-with-elasticsearch/233213)
**Author:** [@Gauti](https://discuss.elastic.co/u/Gauti)\ **Replies:** 4\ **Last updated:** [May 19, 2020, 2:41pm UTC](https://discuss.elastic.co/t/okta-integration-with-elasticsearch/233213 "2020-05-19T14:41:12Z")
Hi All, I'm trying to integrate Okta with elasticsearch in our environment, have configured all the details as per documentation. Now when i hit the kibana url its taking me to Okta page, after entering the credentials… --- ## [Error to integrate elastic high rest client on Weblogic](https://discuss.elastic.co/t/error-to-integrate-elastic-high-rest-client-on-weblogic/233323)
**Author:** [@famele3](https://discuss.elastic.co/u/famele3)\ **Replies:** 5\ **Last updated:** [May 19, 2020, 2:30pm UTC](https://discuss.elastic.co/t/error-to-integrate-elastic-high-rest-client-on-weblogic/233323 "2020-05-19T14:30:15Z")
Hello all, I should integrate the elastic search high rest client on my java web app. I put this dependecies on pom : \ \org.elasticsearch.client\ \elasticsearch-rest-c… --- ## [Index pattern fields - disk space cost?](https://discuss.elastic.co/t/index-pattern-fields-disk-space-cost/233067)
**Author:** [@vdelcampo](https://discuss.elastic.co/u/vdelcampo)\ **Replies:** 4\ **Last updated:** [May 19, 2020, 2:10pm UTC](https://discuss.elastic.co/t/index-pattern-fields-disk-space-cost/233067 "2020-05-19T14:10:17Z")
Hi. I´m using logstash to send to elastic all traffic that comes through my load balancer. With logstash, i´m parsing messages in this fields: I parse the http\_request field in other fields depending on the number of… --- ## [Restore not working on rollover Indices](https://discuss.elastic.co/t/restore-not-working-on-rollover-indices/232251)
**Author:** [@Konathala\_Naveen](https://discuss.elastic.co/u/Konathala_Naveen)\ **Replies:** 1\ **Last updated:** [May 19, 2020, 1:05pm UTC](https://discuss.elastic.co/t/restore-not-working-on-rollover-indices/232251 "2020-05-19T13:05:38Z")
I have two indices in my setup.(below indices are rolledover indices using ILM) 1."test\_syslogs\_1-000002" : { "aliases" : { "test\_syslogs\_1" : { "is\_write\_index" : false } } } 2. "test\_syslogs\_1-0… --- ## [FsCrawler - crypted file permissions](https://discuss.elastic.co/t/fscrawler-crypted-file-permissions/233229)
**Author:** [@Lisahtwy](https://discuss.elastic.co/u/Lisahtwy)\ **Replies:** 3\ **Last updated:** [May 19, 2020, 1:00pm UTC](https://discuss.elastic.co/t/fscrawler-crypted-file-permissions/233229 "2020-05-19T13:00:42Z")
Hi, I am trying to get the file permissions using FsCrawler - attributes\_support: true. But when I search, below are the file permissions that are appearing in the metadata. "attributes" : { "owner" : "100… --- ## [ML - Anomaly fresh data (high score)](https://discuss.elastic.co/t/ml-anomaly-fresh-data-high-score/233297)
**Author:** [@probson](https://discuss.elastic.co/u/probson)\ **Replies:** 1\ **Last updated:** [May 19, 2020, 12:41pm UTC](https://discuss.elastic.co/t/ml-anomaly-fresh-data-high-score/233297 "2020-05-19T12:41:40Z")
Hi, I am starting to play with ML, i have created a job to look for rare user name to soure country. Many people login from the UK, the issue is ingesting a new company leads to high scores for the new user names, orga… --- ## [Docker with elasticsearch xpack.notifications secure settings](https://discuss.elastic.co/t/docker-with-elasticsearch-xpack-notifications-secure-settings/233317)
**Author:** [@maadhav](https://discuss.elastic.co/u/maadhav)\ **Replies:** 0\ **Last updated:** [May 19, 2020, 12:37pm UTC](https://discuss.elastic.co/t/docker-with-elasticsearch-xpack-notifications-secure-settings/233317 "2020-05-19T12:37:51Z")
Hi Team I'm new to Elasticsearch and trying to configure Watcher using Slack notifications. We are using Docker based Elasticsearch cluster and all elasticsearch settings are added as environment keys inside docker-comp… --- ## [Does FSCRAWLER update rate include all documents or only those modified?](https://discuss.elastic.co/t/does-fscrawler-update-rate-include-all-documents-or-only-those-modified/233060)
**Author:** [@Denn](https://discuss.elastic.co/u/Denn)\ **Replies:** 4\ **Last updated:** [May 19, 2020, 11:59am UTC](https://discuss.elastic.co/t/does-fscrawler-update-rate-include-all-documents-or-only-those-modified/233060 "2020-05-19T11:59:56Z")
I have left the update rate to the default 15 in FSCRAWLER. name: "index" fs: update\_rate: "15m" Would like to know if the new scanning cycle after 15 min is for all documents or only for modified documents after the… --- ## [Add colonne with condition](https://discuss.elastic.co/t/add-colonne-with-condition/233308)
**Author:** [@Youssef\_SBAI](https://discuss.elastic.co/u/Youssef_SBAI)\ **Replies:** 0\ **Last updated:** [May 19, 2020, 11:52am UTC](https://discuss.elastic.co/t/add-colonne-with-condition/233308 "2020-05-19T11:52:12Z")
I use Logstash and file beat for ingestion of my two csv in elastic CSV 1: CSV2: It is possible to add the colonne date\_fraicheur in this position --- ## [Daily average over terms: how to handle "missing" terms](https://discuss.elastic.co/t/daily-average-over-terms-how-to-handle-missing-terms/233285)
**Author:** [@kenran](https://discuss.elastic.co/u/kenran)\ **Replies:** 1\ **Last updated:** [May 19, 2020, 11:41am UTC](https://discuss.elastic.co/t/daily-average-over-terms-how-to-handle-missing-terms/233285 "2020-05-19T11:41:33Z")
My logs contain information about machines and their production. Now I wish to know the average amount produced per day. I think I'd to that like this: { "size": 0, "aggs": { "per\_day": { "date\_histogram":… --- ## [Elastic data to Prometheus](https://discuss.elastic.co/t/elastic-data-to-prometheus/231920)
**Author:** [@Vinutha\_A\_H](https://discuss.elastic.co/u/Vinutha_A_H)\ **Replies:** 3\ **Last updated:** [May 19, 2020, 11:38am UTC](https://discuss.elastic.co/t/elastic-data-to-prometheus/231920 "2020-05-19T11:38:21Z")
Hi, We are looking to get metrics out of the data sent to elasticsearch via logstash & kafka. So, please let me know if we have an option for the same, where we can connect from Prometheus to elasticsearch. --- ## [Elasticsearch ODBC driver with SQL Linked Server](https://discuss.elastic.co/t/elasticsearch-odbc-driver-with-sql-linked-server/221144)
**Author:** [@hwtearsdigi](https://discuss.elastic.co/u/hwtearsdigi)\ **Replies:** 14\ **Last updated:** [May 19, 2020, 11:05am UTC](https://discuss.elastic.co/t/elasticsearch-odbc-driver-with-sql-linked-server/221144 "2020-05-19T11:05:29Z")
Hello, I am having trouble getting the ODBC driver to work with MS SQL Linked Server. I have added a System DSN under the ODBC Control Panel with the Elastic 7.6 ODBC driver connecting to an active trial of Elastic 7.6 … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=915) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=917)