# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1127 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1128 --- ## [Setting timezone in painless source](https://discuss.elastic.co/t/setting-timezone-in-painless-source/203278)
**Author:** [@jwallace](https://discuss.elastic.co/u/jwallace)\ **Replies:** 1\ **Last updated:** [October 12, 2019, 6:47pm UTC](https://discuss.elastic.co/t/setting-timezone-in-painless-source/203278 "2019-10-12T18:47:02Z")
I am having trouble setting timezone in a query. I am attempting to group data into day of the week over a time period of a month (so all mondays, tuesdays, etc would be grouped). I am doing this by doing a query for the… --- ## [What's the difference between accessing a document field via .value/.values or not in painless script?](https://discuss.elastic.co/t/whats-the-difference-between-accessing-a-document-field-via-value-values-or-not-in-painless-script/203306)
**Author:** [@wusongchao](https://discuss.elastic.co/u/wusongchao)\ **Replies:** 1\ **Last updated:** [October 12, 2019, 6:42pm UTC](https://discuss.elastic.co/t/whats-the-difference-between-accessing-a-document-field-via-value-values-or-not-in-painless-script/203306 "2019-10-12T18:42:12Z")
Suppose that i have a doc mapping field like below { "template": { "mappings":{ "template":{ "properties": { "sth": { "type": "long" … --- ## [Date histogram doesn't give proper data](https://discuss.elastic.co/t/date-histogram-doesnt-give-proper-data/203305)
**Author:** [@Nikhil04](https://discuss.elastic.co/u/Nikhil04)\ **Replies:** 2\ **Last updated:** [October 12, 2019, 1:43pm UTC](https://discuss.elastic.co/t/date-histogram-doesnt-give-proper-data/203305 "2019-10-12T13:43:31Z")
Hi, I have used date histogram with 5m interval starting for the last 10 minutes as below: There is no data before 17:36:45 in my index. GET metricbeat-7.3.2/\_search { "size": 0, "query": { "bool": { "f… --- ## [Migrating data from Elastic Cloud Elasticsearch to Amazon Elasticsearch Service](https://discuss.elastic.co/t/migrating-data-from-elastic-cloud-elasticsearch-to-amazon-elasticsearch-service/203297)
**Author:** [@EZprogramming](https://discuss.elastic.co/u/EZprogramming)\ **Replies:** 1\ **Last updated:** [October 12, 2019, 7:20am UTC](https://discuss.elastic.co/t/migrating-data-from-elastic-cloud-elasticsearch-to-amazon-elasticsearch-service/203297 "2019-10-12T07:20:36Z")
Is it possible to migrate my data from Elastic Cloud Elasticsearch to Amazon Elasticsearch Service? I know I can transfer my data to a remote Elasticsearch endpoint, but I don't know if it the documentation is talking … --- ## [Verision roll back](https://discuss.elastic.co/t/verision-roll-back/203301)
**Author:** [@cigarl](https://discuss.elastic.co/u/cigarl)\ **Replies:** 1\ **Last updated:** [October 12, 2019, 4:36am UTC](https://discuss.elastic.co/t/verision-roll-back/203301 "2019-10-12T04:36:50Z")
Updated Elasticsearch v6.1.3 to v6.7.1，data files can be identified automatically.Unfortunately,when i want to roll back, elasticsearch v6.1.3 can not identify the modified data files.It told me there was an illegalArgum… --- ## [Distributed Tracing, OpenTracing and Elastic APM](https://discuss.elastic.co/t/distributed-tracing-opentracing-and-elastic-apm/203280)
**Author:** [@anjana1](https://discuss.elastic.co/u/anjana1)\ **Replies:** 0\ **Last updated:** [October 11, 2019, 6:36pm UTC](https://discuss.elastic.co/t/distributed-tracing-opentracing-and-elastic-apm/203280 "2019-10-11T18:36:51Z")
Hi I am trying to use open tracing API in my application to trace events. Can Kibana visualize the events captured by the open API spans ? I was able to trace my application using the native elastic API , but I want to … --- ## [Auth and load balance](https://discuss.elastic.co/t/auth-and-load-balance/203262)
**Author:** [@SirJune](https://discuss.elastic.co/u/SirJune)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 7:38pm UTC](https://discuss.elastic.co/t/auth-and-load-balance/203262 "2019-10-11T19:38:15Z")
Hi, I have 4 nodes: host1,host2,host3 = master,data,ingest (all true) host4 = data,ingest (all true) enable auth (local) start elasticsearch on all nodes do i need to run "bin/elasticsearch-setup-passwords intera… --- ## [Reducing disk space](https://discuss.elastic.co/t/reducing-disk-space/202593)
**Author:** [@NateC](https://discuss.elastic.co/u/NateC)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 7:16pm UTC](https://discuss.elastic.co/t/reducing-disk-space/202593 "2019-10-11T19:16:26Z")
Is there a way to reduce the amount of storage is that is used by ES? Right now I have about 30-ish servers using winlogbeat to send to logstash then to ES. An index pattern gets generated each day and by the end, each i… --- ## [Date aggregation in ES](https://discuss.elastic.co/t/date-aggregation-in-es/202344)
**Author:** [@avinsahlg](https://discuss.elastic.co/u/avinsahlg)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 7:02pm UTC](https://discuss.elastic.co/t/date-aggregation-in-es/202344 "2019-10-11T19:02:31Z")
I am new to elastic search, would someone kind enough to provide me a jason query to search last two months documents based on below data "\_source":{"date":"2016-08-01T10:24:29+0000","clientCode":"xxxx","countryCode":"… --- ## [How i can increase the thread\_pool.index.size in 6.6.1](https://discuss.elastic.co/t/how-i-can-increase-the-thread-pool-index-size-in-6-6-1/202288)
**Author:** [@Kamal\_Ambati](https://discuss.elastic.co/u/Kamal_Ambati)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 6:57pm UTC](https://discuss.elastic.co/t/how-i-can-increase-the-thread-pool-index-size-in-6-6-1/202288 "2019-10-11T18:57:36Z")
Hi With the reference to Elasticsearch document forv6.6.1, i am trying to increase the thread\_pool index/write size to number of cores times 5 (4\*5=20)in elasticsearch.yml file and but getting exceptions during startup.… --- ## [Query Order of Execution](https://discuss.elastic.co/t/query-order-of-execution/203273)
**Author:** [@jaharsh93](https://discuss.elastic.co/u/jaharsh93)\ **Replies:** 0\ **Last updated:** [October 11, 2019, 5:36pm UTC](https://discuss.elastic.co/t/query-order-of-execution/203273 "2019-10-11T17:36:23Z")
What is the order of execution of all the clauses inside the Bool clause , are they executed in parallel by elastic search and then aggregated or are they executed sequentially one after another ? POST \_search { "quer… --- ## [Watcher on ECE - Comparing an Aggs result to a threshold](https://discuss.elastic.co/t/watcher-on-ece-comparing-an-aggs-result-to-a-threshold/203081)
**Author:** [@andrezenun](https://discuss.elastic.co/u/andrezenun)\ **Replies:** 3\ **Last updated:** [October 11, 2019, 4:56pm UTC](https://discuss.elastic.co/t/watcher-on-ece-comparing-an-aggs-result-to-a-threshold/203081 "2019-10-11T16:56:07Z")
Hi, I'm starting with ECE/Elastic in general, and now I'm trying to create a watcher to send an e-mail based on a query that aggregates me a metric coming from APM. This watcher runs but never is triggered. { "trigge… --- ## [Querying on a field that does not exist will return results](https://discuss.elastic.co/t/querying-on-a-field-that-does-not-exist-will-return-results/203240)
**Author:** [@aaron.horst](https://discuss.elastic.co/u/aaron.horst)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 4:43pm UTC](https://discuss.elastic.co/t/querying-on-a-field-that-does-not-exist-will-return-results/203240 "2019-10-11T16:43:14Z")
When querying on a property that does not exist in ES 6.4 I notice that documents are returned despite the fact it is not in the mappings. See the below example. The name property exists however aklsdfkljasdf does not ex… --- ## [Lifecycle Policies two index templates](https://discuss.elastic.co/t/lifecycle-policies-two-index-templates/203254)
**Author:** [@kdotson](https://discuss.elastic.co/u/kdotson)\ **Replies:** 0\ **Last updated:** [October 11, 2019, 3:05pm UTC](https://discuss.elastic.co/t/lifecycle-policies-two-index-templates/203254 "2019-10-11T15:05:11Z")
I have two very similar index templates with the same mappings but changes in replications and Lifecycle policies. See templates below, INDEX 1 has "template": "bwlog\*" with "order": 5 and a Lifecycle management. INDEX … --- ## [Is the 7.x Elasticsearch APT repository down?](https://discuss.elastic.co/t/is-the-7-x-elasticsearch-apt-repository-down/203071)
**Author:** [@eype69](https://discuss.elastic.co/u/eype69)\ **Replies:** 2\ **Last updated:** [October 11, 2019, 1:33pm UTC](https://discuss.elastic.co/t/is-the-7-x-elasticsearch-apt-repository-down/203071 "2019-10-11T13:33:58Z")
I am trying to install Elasticsearch from the APT repositories as per Elasticsearch Reference \[7.4\] and I am getting an error. See below for the commands issued. Are the Elastic APT repositories up at the moment because … --- ## [Hot and cold data nodes](https://discuss.elastic.co/t/hot-and-cold-data-nodes/203191)
**Author:** [@Ant](https://discuss.elastic.co/u/Ant)\ **Replies:** 2\ **Last updated:** [October 11, 2019, 12:49pm UTC](https://discuss.elastic.co/t/hot-and-cold-data-nodes/203191 "2019-10-11T12:49:53Z")
hello, I've got 2 clusters one is nice and fast with SSD storage, lean indexes (although many of them) and if I cycle a node in that cluster it will recover from yellow back to green in about 30 mins. The other uses spin… --- ## [Problem with average response time](https://discuss.elastic.co/t/problem-with-average-response-time/202839)
**Author:** [@AKSHAY\_R](https://discuss.elastic.co/u/AKSHAY_R)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 12:41pm UTC](https://discuss.elastic.co/t/problem-with-average-response-time/202839 "2019-10-11T12:41:38Z")
We are trying to execute below query but unable to get the average of a specific field , but if we use only the "app\_id" we get the average response time , and if we use "app\_id" and "contaner\_url" we get the result but … --- ## [Pagerduty action not working using watcher](https://discuss.elastic.co/t/pagerduty-action-not-working-using-watcher/202811)
**Author:** [@Sumit\_Kumar1](https://discuss.elastic.co/u/Sumit_Kumar1)\ **Replies:** 5\ **Last updated:** [October 11, 2019, 12:39pm UTC](https://discuss.elastic.co/t/pagerduty-action-not-working-using-watcher/202811 "2019-10-11T12:39:13Z")
Pagerduty action not working using watcher --- ## [Can we implement Soundex in Thai language?](https://discuss.elastic.co/t/can-we-implement-soundex-in-thai-language/202138)
**Author:** [@WinEisEis](https://discuss.elastic.co/u/WinEisEis)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 12:26pm UTC](https://discuss.elastic.co/t/can-we-implement-soundex-in-thai-language/202138 "2019-10-11T12:26:30Z")
Hi, I want to search for a Thai name (first name and last name), which can be spelled in many forms but has the same phonetic. Is there any Soundex plugin for Thai language? Thank you in advance :slight\_smile: --- ## [Watcher alert not functioning with Time range for no activity](https://discuss.elastic.co/t/watcher-alert-not-functioning-with-time-range-for-no-activity/202959)
**Author:** [@satishbaratam](https://discuss.elastic.co/u/satishbaratam)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 11:58am UTC](https://discuss.elastic.co/t/watcher-alert-not-functioning-with-time-range-for-no-activity/202959 "2019-10-11T11:58:33Z")
i am looking to create a watcher alert where i am alerted if there is no activity or logs for a service with in a time range . i have tried my bit but ending up with errors . here is the code for watcher alert { "trig… --- ## [While doing REINDEX API we are getting Runtime Exception](https://discuss.elastic.co/t/while-doing-reindex-api-we-are-getting-runtime-exception/202207)
**Author:** [@Siva\_Karan](https://discuss.elastic.co/u/Siva_Karan)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 11:20am UTC](https://discuss.elastic.co/t/while-doing-reindex-api-we-are-getting-runtime-exception/202207 "2019-10-11T11:20:07Z")
Hi Team, we are getting runtime Exception in Elasticsearch while using REINDEX API "bulk" : 0, "search" : 0 }, "throttled\_millis" : 0, "requests\_per\_second" : -1.0, "throttled\_until\_millis" : 0, "failures" : \[ { … --- ## [What data is stored in global\_ordinal , in case of parent\_child relationship data?](https://discuss.elastic.co/t/what-data-is-stored-in-global-ordinal-in-case-of-parent-child-relationship-data/203220)
**Author:** [@pksinghal](https://discuss.elastic.co/u/pksinghal)\ **Replies:** 0\ **Last updated:** [October 11, 2019, 11:08am UTC](https://discuss.elastic.co/t/what-data-is-stored-in-global-ordinal-in-case-of-parent-child-relationship-data/203220 "2019-10-11T11:08:55Z")
I want to know what data is stored in global\_ordinal in case of parent-child relation(Join type) and work queries work in parent-child data. --- ## [How to manually update policy or proceed in phase](https://discuss.elastic.co/t/how-to-manually-update-policy-or-proceed-in-phase/202622)
**Author:** [@rmadisonhaynie](https://discuss.elastic.co/u/rmadisonhaynie)\ **Replies:** 2\ **Last updated:** [October 11, 2019, 11:08am UTC](https://discuss.elastic.co/t/how-to-manually-update-policy-or-proceed-in-phase/202622 "2019-10-11T11:08:14Z")
Hello, I have several times an index will get stuck due to mis-configuration or get an error while testing out the ILM API. I should hopefully get this all resolved but what bothers me is once an index gets stuck like th… --- ## [Get error when indexing parent / child nodes in ElasticSearch.Net](https://discuss.elastic.co/t/get-error-when-indexing-parent-child-nodes-in-elasticsearch-net/203218)
**Author:** [@Steztric](https://discuss.elastic.co/u/Steztric)\ **Replies:** 0\ **Last updated:** [October 11, 2019, 11:03am UTC](https://discuss.elastic.co/t/get-error-when-indexing-parent-child-nodes-in-elasticsearch-net/203218 "2019-10-11T11:03:52Z")
Hi! I am trying to follow this tutorial on creating parent-child relationships between items; https://www.elastic.co/guide/en/elasticsearch/client/net-api/master/parent-child-relationships.html My use-case is slightly … --- ## [Can't get n-grams and synonyms to work together](https://discuss.elastic.co/t/cant-get-n-grams-and-synonyms-to-work-together/203073)
**Author:** [@iuzzino](https://discuss.elastic.co/u/iuzzino)\ **Replies:** 3\ **Last updated:** [October 11, 2019, 10:16am UTC](https://discuss.elastic.co/t/cant-get-n-grams-and-synonyms-to-work-together/203073 "2019-10-11T10:16:24Z")
I'm trying to create an index for an e-commerce site an would like my index to work for typo/mispellings and for synonyms. Actually I am testing with these settings. { "settings": { "index" : { "analysis" : { "analy… --- ## [Enable geo\_shape in ElasticSearch v5.6 (Drupal 8)](https://discuss.elastic.co/t/enable-geo-shape-in-elasticsearch-v5-6-drupal-8/198927)
**Author:** [@vensires](https://discuss.elastic.co/u/vensires)\ **Replies:** 2\ **Last updated:** [October 11, 2019, 9:58am UTC](https://discuss.elastic.co/t/enable-geo-shape-in-elasticsearch-v5-6-drupal-8/198927 "2019-10-11T09:58:45Z")
Hello, I am trying to connect a Drupal 8 website with an ElasticSearch index. The mapping is created by Drupal itself. No matter what I do though, Drupal complains that geo\_shape type is not supported. Do I have to do an… --- ## [How to increase shard count for existing indices](https://discuss.elastic.co/t/how-to-increase-shard-count-for-existing-indices/203172)
**Author:** [@Anikesh\_Paul](https://discuss.elastic.co/u/Anikesh_Paul)\ **Replies:** 2\ **Last updated:** [October 11, 2019, 9:58am UTC](https://discuss.elastic.co/t/how-to-increase-shard-count-for-existing-indices/203172 "2019-10-11T09:58:37Z")
Hi, I want to increase the shard count of my indices. Is that possible to do that? I researched and found there is a possibilities to achieve the same using template, but as per my understanding we can do that only for… --- ## [How to update refresh interval for all existing indices](https://discuss.elastic.co/t/how-to-update-refresh-interval-for-all-existing-indices/203174)
**Author:** [@Anikesh\_Paul](https://discuss.elastic.co/u/Anikesh_Paul)\ **Replies:** 2\ **Last updated:** [October 11, 2019, 9:55am UTC](https://discuss.elastic.co/t/how-to-update-refresh-interval-for-all-existing-indices/203174 "2019-10-11T09:55:53Z")
Hi, I want to update the refresh interval for all my existing indices(approx 200-300 indices) to 60s. Though I know we can achieve it using template, but per my understanding that template will be effective only for ne… --- ## [Percolator java API](https://discuss.elastic.co/t/percolator-java-api/203202)
**Author:** [@Victor\_Caldentey\_Aya](https://discuss.elastic.co/u/Victor_Caldentey_Aya)\ **Replies:** 0\ **Last updated:** [October 11, 2019, 9:36am UTC](https://discuss.elastic.co/t/percolator-java-api/203202 "2019-10-11T09:36:46Z")
Hi, I'm trying to use the Percolator feature as documentation says here https://www.elastic.co/guide/en/elasticsearch/client/java-api/current/java-specialized-queries.html#java-query-percolate-query But using the High l… --- ## [Index prefixes on fields](https://discuss.elastic.co/t/index-prefixes-on-fields/202165)
**Author:** [@Sune\_Debel](https://discuss.elastic.co/u/Sune_Debel)\ **Replies:** 1\ **Last updated:** [October 11, 2019, 9:17am UTC](https://discuss.elastic.co/t/index-prefixes-on-fields/202165 "2019-10-11T09:17:34Z")
We have a setup where some fields are analyzed in multiple ways: with the standard analyzer and a custom analyzer my\_analyzer that preserves punctuation and capitalisation. We want to be able to perform prefix search on … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1126) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1128)