# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1774 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1775 --- ## [Get times where document count = 0](https://discuss.elastic.co/t/get-times-where-document-count-0/121628)
**Author:** [@asp](https://discuss.elastic.co/u/asp)\ **Replies:** 2\ **Last updated:** [February 27, 2018, 10:45am UTC](https://discuss.elastic.co/t/get-times-where-document-count-0/121628 "2018-02-27T10:45:45Z")
Hi, We have a problem, that a part of our application stalls from time to time. This results in no log lines. Normally we have multiple entries per second. When it stalls there are none. Log lines are already indexed … --- ## [Upgrade from 5.6 to 6.2.1: Failed to read local state](https://discuss.elastic.co/t/upgrade-from-5-6-to-6-2-1-failed-to-read-local-state/121630)
**Author:** [@ocebeci](https://discuss.elastic.co/u/ocebeci)\ **Replies:** 0\ **Last updated:** [February 27, 2018, 10:39am UTC](https://discuss.elastic.co/t/upgrade-from-5-6-to-6-2-1-failed-to-read-local-state/121630 "2018-02-27T10:39:12Z")
Hello, I tried upgrading my Elasticsearch to 6.2.1 on Windows but everytime I start the service it fails with this exception: failed to read local state, exiting... org.elasticsearch.ElasticsearchException: java.io.IOE… --- ## [Query DSL C#, function "Documents" return issue](https://discuss.elastic.co/t/query-dsl-c-function-documents-return-issue/121470)
**Author:** [@DiSiZ](https://discuss.elastic.co/u/DiSiZ)\ **Replies:** 2\ **Last updated:** [February 27, 2018, 8:52am UTC](https://discuss.elastic.co/t/query-dsl-c-function-documents-return-issue/121470 "2018-02-27T08:52:45Z")
Hello, I'am trying to get to some data on a elastic uri. The thing is, when I do this : var searchResponse = client.Search\(s =\> s .Index("jam") .Type("jam") .From… --- ## [Cannot search long number field](https://discuss.elastic.co/t/cannot-search-long-number-field/121603)
**Author:** [@Khiem\_Tr\_n](https://discuss.elastic.co/u/Khiem_Tr_n)\ **Replies:** 1\ **Last updated:** [February 27, 2018, 8:44am UTC](https://discuss.elastic.co/t/cannot-search-long-number-field/121603 "2018-02-27T08:44:36Z")
Hi all, I have a problem with Elasticsearch. vid is a long field in my index. I try to search with: POST my-index/video/\_search { "query": { "term": { "vid": 6518061120253592000 } } } but get nothing… --- ## [Bug? Geo\_shape query not working for points\_only geo\_shape field in ES6.2.1](https://discuss.elastic.co/t/bug-geo-shape-query-not-working-for-points-only-geo-shape-field-in-es6-2-1/120009)
**Author:** [@oystein.elvik](https://discuss.elastic.co/u/oystein.elvik)\ **Replies:** 3\ **Last updated:** [February 27, 2018, 8:07am UTC](https://discuss.elastic.co/t/bug-geo-shape-query-not-working-for-points-only-geo-shape-field-in-es6-2-1/120009 "2018-02-27T08:07:06Z")
To reproduce: DELETE /example PUT /example { "mappings": { "\_doc": { "properties": { "location": { "type": "geo\_shape", "points\_only": tru… --- ## [Not able get data due to default monitoring index](https://discuss.elastic.co/t/not-able-get-data-due-to-default-monitoring-index/121383)
**Author:** [@Akib\_Ali](https://discuss.elastic.co/u/Akib_Ali)\ **Replies:** 0\ **Last updated:** [February 25, 2018, 1:30pm UTC](https://discuss.elastic.co/t/not-able-get-data-due-to-default-monitoring-index/121383 "2018-02-25T13:30:10Z")
I pull the docker image of elasticsearch and when brings it up there is one monitoring index gets created automatically. Now i create some indices and insert the data. But on searching something it does not give me any r… --- ## [No monitoring data found](https://discuss.elastic.co/t/no-monitoring-data-found/119516)
**Author:** [@alexvollmer](https://discuss.elastic.co/u/alexvollmer)\ **Replies:** 10\ **Last updated:** [February 27, 2018, 5:21am UTC](https://discuss.elastic.co/t/no-monitoring-data-found/119516 "2018-02-27T05:21:02Z")
We've been running Kibana and ES 5.6 with the basic license for quite a few months for the monitoring feature. For some reason now when I go to the monitoring section I get the dreaded "No monitoring data found" error. I… --- ## [Master node](https://discuss.elastic.co/t/master-node/121590)
**Author:** [@tek1969](https://discuss.elastic.co/u/tek1969)\ **Replies:** 2\ **Last updated:** [February 27, 2018, 4:54am UTC](https://discuss.elastic.co/t/master-node/121590 "2018-02-27T04:54:11Z")
Can a master node (or multiple master nodes) manage more then one cluster? --- ## [Save index on specific node](https://discuss.elastic.co/t/save-index-on-specific-node/121504)
**Author:** [@rmerkushin](https://discuss.elastic.co/u/rmerkushin)\ **Replies:** 1\ **Last updated:** [February 27, 2018, 3:30am UTC](https://discuss.elastic.co/t/save-index-on-specific-node/121504 "2018-02-27T03:30:34Z")
Hello all! Can i specify which indexes will be saved on specific node? Is this possible? P.S.: Sorry for my bad English :slight\_smile: --- ## [Error Running Curator Rollover method](https://discuss.elastic.co/t/error-running-curator-rollover-method/120719)
**Author:** [@hartfordfive](https://discuss.elastic.co/u/hartfordfive)\ **Replies:** 1\ **Last updated:** [February 27, 2018, 1:44am UTC](https://discuss.elastic.co/t/error-running-curator-rollover-method/120719 "2018-02-27T01:44:08Z")
I'm currently collecting metricbeat data from many systems that gets stored in an index with the format of 'metricbeat-YYYY.mm.dd'. When I attempt to test my curator action to run a rollover, I get the following error: … --- ## [Old indices wont delete](https://discuss.elastic.co/t/old-indices-wont-delete/120708)
**Author:** [@shri](https://discuss.elastic.co/u/shri)\ **Replies:** 1\ **Last updated:** [February 27, 2018, 1:42am UTC](https://discuss.elastic.co/t/old-indices-wont-delete/120708 "2018-02-27T01:42:00Z")
All, i'm trying to delete old indices but can't get it work. Please help me on this issue. Error: 2018-02-19 21:34:40,977 INFO Preparing Action ID: 1, "delete\_indices" 2018-02-19 21:34:40,997 INFO Trying Action ID: 1,… --- ## [Unable to delete indices using curator](https://discuss.elastic.co/t/unable-to-delete-indices-using-curator/120328)
**Author:** [@Nikhilpawar1985](https://discuss.elastic.co/u/Nikhilpawar1985)\ **Replies:** 8\ **Last updated:** [February 27, 2018, 1:40am UTC](https://discuss.elastic.co/t/unable-to-delete-indices-using-curator/120328 "2018-02-27T01:40:37Z")
Hi , Using curator but not performing any action . Can someone help \[root@iacapps-es-node1 elasticsearch-curator\]# curator --config curator.yml delete\_indices.yml 2018-02-18 00:10:01,892 DEBUG cur… --- ## [Payload in completion suggester in 6.2?](https://discuss.elastic.co/t/payload-in-completion-suggester-in-6-2/121579)
**Author:** [@Peter\_Chiu](https://discuss.elastic.co/u/Peter_Chiu)\ **Replies:** 0\ **Last updated:** [February 27, 2018, 12:22am UTC](https://discuss.elastic.co/t/payload-in-completion-suggester-in-6-2/121579 "2018-02-27T00:22:18Z")
hello all- may i know if payload has been removed from completion suggester in 6.2? --- ## [Nest Script Query example](https://discuss.elastic.co/t/nest-script-query-example/120718)
**Author:** [@ESCoder](https://discuss.elastic.co/u/ESCoder)\ **Replies:** 1\ **Last updated:** [February 26, 2018, 11:34pm UTC](https://discuss.elastic.co/t/nest-script-query-example/120718 "2018-02-26T23:34:43Z")
Hi, I came across script query topic in Nest https://www.elastic.co/guide/en/elasticsearch/client/net-api/6.x/script-query-usage.html I'm just looking for an example on how to use this. What would be an example \_templ… --- ## [Delete old indices from x-pack security enabled elasticsearch using curator](https://discuss.elastic.co/t/delete-old-indices-from-x-pack-security-enabled-elasticsearch-using-curator/121008)
**Author:** [@Chamika\_Vishmal](https://discuss.elastic.co/u/Chamika_Vishmal)\ **Replies:** 1\ **Last updated:** [February 26, 2018, 10:22pm UTC](https://discuss.elastic.co/t/delete-old-indices-from-x-pack-security-enabled-elasticsearch-using-curator/121008 "2018-02-26T22:22:25Z")
I'm trying to delete old indices from x-pack security enabled elasticsearch cluster. In curator config file I have added username and password options under client category. But I'm receiving this error when trying to de… --- ## [Trouble connecting to ElasticSearch Cloud via python library](https://discuss.elastic.co/t/trouble-connecting-to-elasticsearch-cloud-via-python-library/121568)
**Author:** [@David9](https://discuss.elastic.co/u/David9)\ **Replies:** 1\ **Last updated:** [February 26, 2018, 9:59pm UTC](https://discuss.elastic.co/t/trouble-connecting-to-elasticsearch-cloud-via-python-library/121568 "2018-02-26T21:59:35Z")
Using https://elasticsearch-py.readthedocs.io/en/master/ Can't connect, it's telling me "elasticsearch.exceptions.ImproperlyConfigured: Root certificates are missing for certificate validation. Either pass them in using… --- ## [Update data into elastic Search](https://discuss.elastic.co/t/update-data-into-elastic-search/121459)
**Author:** [@sivaavish](https://discuss.elastic.co/u/sivaavish)\ **Replies:** 1\ **Last updated:** [February 26, 2018, 9:56pm UTC](https://discuss.elastic.co/t/update-data-into-elastic-search/121459 "2018-02-26T21:56:35Z")
hi , i am new to elastic search . i imported data using log stash with MySQL. now i want update the some fields . here problem is after imported data through log stash id created automatically in elastic search. Upda… --- ## [Elasticsearch performance degraded after migration from 1.4 to 5.4](https://discuss.elastic.co/t/elasticsearch-performance-degraded-after-migration-from-1-4-to-5-4/120159)
**Author:** [@Nitish\_Goyal](https://discuss.elastic.co/u/Nitish_Goyal)\ **Replies:** 5\ **Last updated:** [February 26, 2018, 9:21pm UTC](https://discuss.elastic.co/t/elasticsearch-performance-degraded-after-migration-from-1-4-to-5-4/120159 "2018-02-26T21:21:38Z")
Hi, We have recently migrated our es clusters from 1.4 to 5.4 and seeing degradation in the performance. This query is taking around ~30-40 ms in es 5.4 If we execute the same query in es 1.4 , the same query takes ~8… --- ## [Elasticsearch-rest-high-level-client:6.2.2 will not run](https://discuss.elastic.co/t/elasticsearch-rest-high-level-client-6-2-2-will-not-run/121556)
**Author:** [@Michael\_Tang](https://discuss.elastic.co/u/Michael_Tang)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 7:44pm UTC](https://discuss.elastic.co/t/elasticsearch-rest-high-level-client-6-2-2-will-not-run/121556 "2018-02-26T19:44:42Z")
Hi I am trying to use elasticsearch in Android Studio and it's throwing TransformException on this dependency. I have the .jar file in my cache. I can even unzip it and look at the files. The exact error is com.android… --- ## [Reindexing from non-nested to nested](https://discuss.elastic.co/t/reindexing-from-non-nested-to-nested/121547)
**Author:** [@rishi\_upadhyay](https://discuss.elastic.co/u/rishi_upadhyay)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 6:28pm UTC](https://discuss.elastic.co/t/reindexing-from-non-nested-to-nested/121547 "2018-02-26T18:28:06Z")
I created an elastic document with dynamic mapping. As by default elastic does not take the json array as nested but i wanted the mapping to be nested. As a solution i had to create a new index with mapping changes to n… --- ## [Advice on large dataset query problem](https://discuss.elastic.co/t/advice-on-large-dataset-query-problem/121542)
**Author:** [@NAlTARAtc](https://discuss.elastic.co/u/NAlTARAtc)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 6:10pm UTC](https://discuss.elastic.co/t/advice-on-large-dataset-query-problem/121542 "2018-02-26T18:10:00Z")
Thanks to this community - so far I found lot's of great help here! I wanted some advice/hints into the right direction for this fun project I'm working on. I have \>10'000 inputs (each corresponds to 10-20 page written… --- ## [Substract values before applying aggregation](https://discuss.elastic.co/t/substract-values-before-applying-aggregation/121533)
**Author:** [@GuimRH](https://discuss.elastic.co/u/GuimRH)\ **Replies:** 1\ **Last updated:** [February 26, 2018, 5:40pm UTC](https://discuss.elastic.co/t/substract-values-before-applying-aggregation/121533 "2018-02-26T17:40:02Z")
Hello, we have an index with two fields (amount others) one is the scheduled time of one job, and the second one is the actual execution time, this second value is used as @timestamp. We'd like to have the delay betwee… --- ## [What is the purpose of using "ForceQueuePolicy"](https://discuss.elastic.co/t/what-is-the-purpose-of-using-forcequeuepolicy/121522)
**Author:** [@GingoBang](https://discuss.elastic.co/u/GingoBang)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 4:05pm UTC](https://discuss.elastic.co/t/what-is-the-purpose-of-using-forcequeuepolicy/121522 "2018-02-26T16:05:59Z")
Here is the code: It will be used if the ThreadPoolExecutor instance reject the task submitted. static class ForceQueuePolicy implements XRejectedExecutionHandler { @Override public void rejectedExecuti… --- ## [Split a document into several documents](https://discuss.elastic.co/t/split-a-document-into-several-documents/121506)
**Author:** [@Rym\_Guerbi\_Michaut](https://discuss.elastic.co/u/Rym_Guerbi_Michaut)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 2:31pm UTC](https://discuss.elastic.co/t/split-a-document-into-several-documents/121506 "2018-02-26T14:31:18Z")
Hi there, I have a single document loaded in elasticsearch and I'd like to split it into several documents on the "user" field. I've tried doing it with Logstash filters but it didn't work. The document contains a lot… --- ## [New to ES and need some help](https://discuss.elastic.co/t/new-to-es-and-need-some-help/121501)
**Author:** [@colonelrascals](https://discuss.elastic.co/u/colonelrascals)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 2:20pm UTC](https://discuss.elastic.co/t/new-to-es-and-need-some-help/121501 "2018-02-26T14:20:10Z")
Hey guys and gals, Django Dev here. I've currently inherited a project that is using ES, we sat down and did a rewrite of the queries and mapping, but now I'm unsure where to put the pieces. I've included a gist of the … --- ## [Transforming fields to date type](https://discuss.elastic.co/t/transforming-fields-to-date-type/121493)
**Author:** [@tomak](https://discuss.elastic.co/u/tomak)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 1:26pm UTC](https://discuss.elastic.co/t/transforming-fields-to-date-type/121493 "2018-02-26T13:26:26Z")
I have a database which I would like to add to Elasticsearch. In there, all documents have a field "date" however, it is not in a format that Elasticsearch considers as a date. It is of the form 01-2013 (for January 2013… --- ## [@Version mapping](https://discuss.elastic.co/t/version-mapping/121478)
**Author:** [@petegriggs](https://discuss.elastic.co/u/petegriggs)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 11:51am UTC](https://discuss.elastic.co/t/version-mapping/121478 "2018-02-26T11:51:14Z")
After updating to ElasticSearch 6 we are having problems inputting our logs. It appears the issue is down to the @version mapping being set to string and their being no handler to process this. I am guessing this is com… --- ## [(RE)Unable to Use the dynamic template,for short,byte & float](https://discuss.elastic.co/t/re-unable-to-use-the-dynamic-template-for-short-byte-float/121438)
**Author:** [@prasad\_kp](https://discuss.elastic.co/u/prasad_kp)\ **Replies:** 1\ **Last updated:** [February 26, 2018, 10:59am UTC](https://discuss.elastic.co/t/re-unable-to-use-the-dynamic-template-for-short-byte-float/121438 "2018-02-26T10:59:52Z")
I am trying to create a template, in my template m trying to achive the dynamic mapping Here is what i wrote,as in 6.2.1 the only boolean, date, double, long, object, string are automatically detected,facing issues for … --- ## [Cannot uninstall X-pack](https://discuss.elastic.co/t/cannot-uninstall-x-pack/121173)
**Author:** [@Suryakumar](https://discuss.elastic.co/u/Suryakumar)\ **Replies:** 4\ **Last updated:** [February 26, 2018, 10:38am UTC](https://discuss.elastic.co/t/cannot-uninstall-x-pack/121173 "2018-02-26T10:38:15Z")
Hi, I have installed X-Pack in a curiosity to know how it works. Now I want to uninstall it. But I cannot uninstall. When I try uninstalling with these commands: bin/elasticsearch-plugin remove x-pack I am getting a… --- ## [ElasticSearch mapping & cluster\_state](https://discuss.elastic.co/t/elasticsearch-mapping-cluster-state/121465)
**Author:** [@mjunaidmuzammil](https://discuss.elastic.co/u/mjunaidmuzammil)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 10:15am UTC](https://discuss.elastic.co/t/elasticsearch-mapping-cluster-state/121465 "2018-02-26T10:15:27Z")
Hi, One of the problems that we often hear with the elasticsearch community is huge cluster\_state. From my prior experience, I have noticed that in majority of the cases too many mapping field definitions is the cause o… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1773) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1775)