# Elasticsearch

**URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1417

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 1418

---

## [There is no listed indices, but kibana lists](https://discuss.elastic.co/t/there-is-no-listed-indices-but-kibana-lists/165422)

<div class="topic-metadata">

**Author:** [@databees\_test](https://discuss.elastic.co/u/databees_test)\
**Replies:** 0\
**Last updated:** [January 23, 2019, 1:46pm UTC](https://discuss.elastic.co/t/there-is-no-listed-indices-but-kibana-lists/165422 "2019-01-23T13:46:34Z")

</div>

I am new on ES. When I am trying to list indices with curl -XGET localhost:9200/\_cat/indices , there is no indices. It returns just \[1\]+ Exit 1, but I can list all the indices in kibana. I was also trying to create ne…

---

## [Es\_rejected\_execution exception with index failure changing](https://discuss.elastic.co/t/es-rejected-execution-exception-with-index-failure-changing/165375)

<div class="topic-metadata">

**Author:** [@Santi](https://discuss.elastic.co/u/Santi)\
**Replies:** 6\
**Last updated:** [January 23, 2019, 2:26pm UTC](https://discuss.elastic.co/t/es-rejected-execution-exception-with-index-failure-changing/165375 "2019-01-23T14:26:14Z")

</div>

Hello team, After restarting the Elasticsearch service several time, and increasing the thread\_pool.bulk.queue\_size, when I try to interact with Elasticsearch with the following query : q = { "query": { "match\_al…

---

## [Elasticsearch on AKS](https://discuss.elastic.co/t/elasticsearch-on-aks/165008)

<div class="topic-metadata">

**Author:** [@krzysztoftorunski](https://discuss.elastic.co/u/krzysztoftorunski)\
**Replies:** 10\
**Last updated:** [January 23, 2019, 2:25pm UTC](https://discuss.elastic.co/t/elasticsearch-on-aks/165008 "2019-01-23T14:25:13Z")

</div>

Hi, I'm testing Elasticsearch cluster on Azure AKS environment. I'm using 5 nodes AKS cluster (Standard E8s v3). Three nodes are dedicated for Elastic cluster. Three nodes data + master. All pods have additional persis…

---

## [Elasticsearch Automatic Snapshots - Curator?](https://discuss.elastic.co/t/elasticsearch-automatic-snapshots-curator/165382)

<div class="topic-metadata">

**Author:** [@Nikesh](https://discuss.elastic.co/u/Nikesh)\
**Replies:** 3\
**Last updated:** [January 23, 2019, 2:10pm UTC](https://discuss.elastic.co/t/elasticsearch-automatic-snapshots-curator/165382 "2019-01-23T14:10:19Z")

</div>

Hi, I'm looking to snapshot indexes on my local windows system(single node). I am capable of creating snapshots based on indexes and restore them after deleting. Although, this is done manually using Snapshot and Rest…

---

## [Nested: MustacheException\[3 @\[query-template:5\]\]; nested: IndexOutOfBoundsException\[3\]](https://discuss.elastic.co/t/nested-mustacheexception-3-query-template-5-nested-indexoutofboundsexception-3/165423)

<div class="topic-metadata">

**Author:** [@balamelangi](https://discuss.elastic.co/u/balamelangi)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 1:52pm UTC](https://discuss.elastic.co/t/nested-mustacheexception-3-query-template-5-nested-indexoutofboundsexception-3/165423 "2019-01-23T13:52:59Z")

</div>

{ "watch\_id": "platform.wavespot.net", "state": "execution\_not\_needed", "status": { "state": { "active": true, "timestamp": "2019-01-23T13:39:36.359Z" }, "last\_checked": "2019-01-23T13:45:37.506Z", "last\_met\_con…

---

## [Circuit Breaker not stopping my search query even though my heap size crosses](https://discuss.elastic.co/t/circuit-breaker-not-stopping-my-search-query-even-though-my-heap-size-crosses/165353)

<div class="topic-metadata">

**Author:** [@Nikesh](https://discuss.elastic.co/u/Nikesh)\
**Replies:** 2\
**Last updated:** [January 23, 2019, 1:23pm UTC](https://discuss.elastic.co/t/circuit-breaker-not-stopping-my-search-query-even-though-my-heap-size-crosses/165353 "2019-01-23T13:23:31Z")

</div>

Hi, I am trying to understand the working of circuit breaker. I see the default value of "parent-level breaker" is 70% of JVM Heap. I have set "in flight requests circuit breaker" and "accounting circuit breaker " to…

---

## [Search documents with array elements matching two conditions](https://discuss.elastic.co/t/search-documents-with-array-elements-matching-two-conditions/165409)

<div class="topic-metadata">

**Author:** [@mvienne](https://discuss.elastic.co/u/mvienne)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 1:00pm UTC](https://discuss.elastic.co/t/search-documents-with-array-elements-matching-two-conditions/165409 "2019-01-23T13:00:40Z")

</div>

Hi, I want to search documents in an index which contains an array type with two documents : PUT my\_index/doc/1 { "message": "some arrays in this document...", "tags": \[ "elasticsearch", "wow" \], "lists":…

---

## [Elasticsearch painless updating List\<String\> in JAVA not working](https://discuss.elastic.co/t/elasticsearch-painless-updating-list-string-in-java-not-working/162232)

<div class="topic-metadata">

**Author:** [@Rashid\_Yes](https://discuss.elastic.co/u/Rashid_Yes)\
**Replies:** 8\
**Last updated:** [January 23, 2019, 12:58pm UTC](https://discuss.elastic.co/t/elasticsearch-painless-updating-list-string-in-java-not-working/162232 "2019-01-23T12:58:47Z")

</div>

When I am updating the single String in painless, its working fine. But when updating List in painless is not working. Any help would be appreciated. Regards

---

## [How to use NOT operator in watcher](https://discuss.elastic.co/t/how-to-use-not-operator-in-watcher/165398)

<div class="topic-metadata">

**Author:** [@balamelangi](https://discuss.elastic.co/u/balamelangi)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 12:12pm UTC](https://discuss.elastic.co/t/how-to-use-not-operator-in-watcher/165398 "2019-01-23T12:12:14Z")

</div>

Hi, Is there any other way to get notification containing "match": \["error" NOT "org.apache"\] Thanks.

---

## [Any queay like "like %sth%" in Mysql?](https://discuss.elastic.co/t/any-queay-like-like-sth-in-mysql/165389)

<div class="topic-metadata">

**Author:** [@Kent-Deng](https://discuss.elastic.co/u/Kent-Deng)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 12:05pm UTC](https://discuss.elastic.co/t/any-queay-like-like-sth-in-mysql/165389 "2019-01-23T12:05:21Z")

</div>

In Title. Thank you.

---

## [How to escape forward slashes in a query\_string query?](https://discuss.elastic.co/t/how-to-escape-forward-slashes-in-a-query-string-query/165397)

<div class="topic-metadata">

**Author:** [@gchermennov](https://discuss.elastic.co/u/gchermennov)\
**Replies:** 0\
**Last updated:** [January 23, 2019, 11:56am UTC](https://discuss.elastic.co/t/how-to-escape-forward-slashes-in-a-query-string-query/165397 "2019-01-23T11:56:24Z")

</div>

Can't seem to get easy query to work, I assume it's due to slashes in the url: { "size": 100, "query": { "bool": { "must": \[ { "range" : { "@timestamp" : { "gte": "01-07-2018", "lt": "31-12-2018", "format": "dd-MM-…

---

## [Index.refresh\_interval:-1 does not appear to effect searching](https://discuss.elastic.co/t/index-refresh-interval-1-does-not-appear-to-effect-searching/165381)

<div class="topic-metadata">

**Author:** [@matthew.whill](https://discuss.elastic.co/u/matthew.whill)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 11:50am UTC](https://discuss.elastic.co/t/index-refresh-interval-1-does-not-appear-to-effect-searching/165381 "2019-01-23T11:50:49Z")

</div>

I have recently setup Elastic Cloud using the offered AWS implementation. I am adding a large amount of documents to the cluster at present so I thought that I would set the index.refresh\_interval to -1 to improve the d…

---

## [Using JNA in a custom plugin](https://discuss.elastic.co/t/using-jna-in-a-custom-plugin/165393)

<div class="topic-metadata">

**Author:** [@ninesalt](https://discuss.elastic.co/u/ninesalt)\
**Replies:** 0\
**Last updated:** [January 23, 2019, 11:46am UTC](https://discuss.elastic.co/t/using-jna-in-a-custom-plugin/165393 "2019-01-23T11:46:04Z")

</div>

I'm trying to build a plugin that uses JNA and I noticed that ES already has JNA as a dependency so I excluded it from my build configuration and the installation works. However during runtime I keep getting an error say…

---

## [Elastic Cloud AWS: Storage Size Drops after Reboot of entire cluster](https://discuss.elastic.co/t/elastic-cloud-aws-storage-size-drops-after-reboot-of-entire-cluster/165383)

<div class="topic-metadata">

**Author:** [@matthew.whill](https://discuss.elastic.co/u/matthew.whill)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 11:31am UTC](https://discuss.elastic.co/t/elastic-cloud-aws-storage-size-drops-after-reboot-of-entire-cluster/165383 "2019-01-23T11:31:31Z")

</div>

I am running an instance of Elastic Cloud via the offered AWS facility. I am saving a large amount of documents to the cluster and starting to reach the max capacity for storage. When I reach a certain point the indexe…

---

## [Question about nested top\_hits aggregation results \_score](https://discuss.elastic.co/t/question-about-nested-top-hits-aggregation-results-score/165376)

<div class="topic-metadata">

**Author:** [@Slade](https://discuss.elastic.co/u/Slade)\
**Replies:** 0\
**Last updated:** [January 23, 2019, 10:21am UTC](https://discuss.elastic.co/t/question-about-nested-top-hits-aggregation-results-score/165376 "2019-01-23T10:21:33Z")

</div>

I'm trying to get nested top\_hits results to receive a score which I can then sort by but it seems that all of the results always have \_score 1 PUT /item { "mappings": { "\_doc" : { "properties"…

---

## [Xml tags logstah](https://discuss.elastic.co/t/xml-tags-logstah/165247)

<div class="topic-metadata">

**Author:** [@Alaoui](https://discuss.elastic.co/u/Alaoui)\
**Replies:** 0\
**Last updated:** [January 22, 2019, 2:06pm UTC](https://discuss.elastic.co/t/xml-tags-logstah/165247 "2019-01-22T14:06:38Z")

</div>

hi , it s normal to have your xml file in the same line like this : \<?xml version="1.0" encoding="UTF-8"?\> \<tns:Invoicing xmlns:tns="xxxxxxx"\>\<tns:FileNumber\>20180919093512\</tns:FileNumber\>\<tns:FileDate\>2018-09-19\</tns…

---

## [Question about Wildcard Query](https://discuss.elastic.co/t/question-about-wildcard-query/165327)

<div class="topic-metadata">

**Author:** [@Oscar\_Sanchez\_Sanche](https://discuss.elastic.co/u/Oscar_Sanchez_Sanche)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 10:05am UTC](https://discuss.elastic.co/t/question-about-wildcard-query/165327 "2019-01-23T10:05:54Z")

</div>

Hello! There's a question I have with regards of using a wildcard query. So I have a set of values on a field "meta.test\_key.value" Let's say I have these values: 1.- Alice 2.- alICe 3.- AlIcE 4.- Aliceee Now I d…

---

## [How to do elastic search for selected pdf file](https://discuss.elastic.co/t/how-to-do-elastic-search-for-selected-pdf-file/164980)

<div class="topic-metadata">

**Author:** [@Niranjan\_Sourabh](https://discuss.elastic.co/u/Niranjan_Sourabh)\
**Replies:** 4\
**Last updated:** [January 23, 2019, 9:45am UTC](https://discuss.elastic.co/t/how-to-do-elastic-search-for-selected-pdf-file/164980 "2019-01-23T09:45:16Z")

</div>

I have requirement that to do elastic search for particular word/text/sentences in selected pdf file not for all present in specific folder. using elasticsearch fs crawler and kibana . Any idea guyz???????

---

## [How to get nested inner objects total count in elasticsearch query](https://discuss.elastic.co/t/how-to-get-nested-inner-objects-total-count-in-elasticsearch-query/165276)

<div class="topic-metadata">

**Author:** [@r.ganeshbabu](https://discuss.elastic.co/u/r.ganeshbabu)\
**Replies:** 2\
**Last updated:** [January 23, 2019, 9:33am UTC](https://discuss.elastic.co/t/how-to-get-nested-inner-objects-total-count-in-elasticsearch-query/165276 "2019-01-23T09:33:56Z")

</div>

Hi All, I am trying to get total count of nested inner objects using elasticsearch query and below is the query I tried, POST transaction\*/\_search { "size": 0, "query": { "bool": { "must": \[ { …

---

## [How to find the difference between current time and firsteventdetected time using scripting](https://discuss.elastic.co/t/how-to-find-the-difference-between-current-time-and-firsteventdetected-time-using-scripting/164895)

<div class="topic-metadata">

**Author:** [@r.ganeshbabu](https://discuss.elastic.co/u/r.ganeshbabu)\
**Replies:** 2\
**Last updated:** [January 23, 2019, 9:25am UTC](https://discuss.elastic.co/t/how-to-find-the-difference-between-current-time-and-firsteventdetected-time-using-scripting/164895 "2019-01-23T09:25:50Z")

</div>

Hi All, I am trying to find the difference between the current time and firsteventdetected time from the index and below is the query, POST transaction\*/\_search { "query": { "match\_all": {} }, "script\_fields"…

---

## [Filter each bucket based on previous buckets](https://discuss.elastic.co/t/filter-each-bucket-based-on-previous-buckets/165280)

<div class="topic-metadata">

**Author:** [@Wassim\_Ben\_Amor](https://discuss.elastic.co/u/Wassim_Ben_Amor)\
**Replies:** 2\
**Last updated:** [January 23, 2019, 9:02am UTC](https://discuss.elastic.co/t/filter-each-bucket-based-on-previous-buckets/165280 "2019-01-23T09:02:01Z")

</div>

Hello, I have documents representing user requests, each document contains user\_id and timestamp. A simple date histogram aggregation generates the number of daily users like this { "aggs": { "2": { "date\_histogra…

---

## [Es6.5.4 Distance is an aggregate index. How is it sorted](https://discuss.elastic.co/t/es6-5-4-distance-is-an-aggregate-index-how-is-it-sorted/165355)

<div class="topic-metadata">

**Author:** [@fuhaoliang](https://discuss.elastic.co/u/fuhaoliang)\
**Replies:** 0\
**Last updated:** [January 23, 2019, 8:04am UTC](https://discuss.elastic.co/t/es6-5-4-distance-is-an-aggregate-index-how-is-it-sorted/165355 "2019-01-23T08:04:40Z")

</div>

POST dw\_vehicle\_mileage3/\_search {"from":2,"size":1,"\_source":false,"stored\_fields":"none","aggregations":{"groupby":{"composite":{"size":1000,"sources":\[{"862":{"terms":{"field":"vehicleid","missing\_bucket":true,"order…

---

## [Distinct result in elasticsearch](https://discuss.elastic.co/t/distinct-result-in-elasticsearch/165342)

<div class="topic-metadata">

**Author:** [@Shubham\_Najardhane](https://discuss.elastic.co/u/Shubham_Najardhane)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 7:33am UTC](https://discuss.elastic.co/t/distinct-result-in-elasticsearch/165342 "2019-01-23T07:33:30Z")

</div>

Hi I want to get the list of all the user's email from the elasticsearch. Like in mongo engine we can query user\_emails = User.objects().distinct("user\_email") This results in list like this = \['email1@email.com', 'e…

---

## [Elastic 6.5 sql](https://discuss.elastic.co/t/elastic-6-5-sql/165346)

<div class="topic-metadata">

**Author:** [@fuhaoliang](https://discuss.elastic.co/u/fuhaoliang)\
**Replies:** 0\
**Last updated:** [January 23, 2019, 7:07am UTC](https://discuss.elastic.co/t/elastic-6-5-sql/165346 "2019-01-23T07:07:31Z")

</div>

elastic 6.5.4 SELECT vehicleid,sum(distance) as distance,sum(duration) as duration where beginTime \>= 20181201 and endTime \< 20190101 FROM dw\_vehicle\_mileage3 group by vehicleid order by distance error:Cannot order by …

---

## [Global Search in Elastic Search](https://discuss.elastic.co/t/global-search-in-elastic-search/165331)

<div class="topic-metadata">

**Author:** [@Irvine456](https://discuss.elastic.co/u/Irvine456)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 7:02am UTC](https://discuss.elastic.co/t/global-search-in-elastic-search/165331 "2019-01-23T07:02:40Z")

</div>

Working on Elasticsearch, my use case is very straight forward. When a user types in a search box I want to search all of my data set irrespective of field or column or any condition (search all data and provide all occu…

---

## [Unique Keys For Large Corpus Of Data](https://discuss.elastic.co/t/unique-keys-for-large-corpus-of-data/162200)

<div class="topic-metadata">

**Author:** [@Rashmi\_Nagpal](https://discuss.elastic.co/u/Rashmi_Nagpal)\
**Replies:** 2\
**Last updated:** [January 23, 2019, 5:26am UTC](https://discuss.elastic.co/t/unique-keys-for-large-corpus-of-data/162200 "2019-01-23T05:26:29Z")

</div>

Can someone suggest me how to save large corpus of data pertaining to a single user at single index in elasticsearch, i.e. I want to save person wise data in elasticsearch. For example, person\_name1 : { "Aadhar card" …

---

## [Match synonyms and match exact word get different scores](https://discuss.elastic.co/t/match-synonyms-and-match-exact-word-get-different-scores/165329)

<div class="topic-metadata">

**Author:** [@Heather\_Lau](https://discuss.elastic.co/u/Heather_Lau)\
**Replies:** 0\
**Last updated:** [January 23, 2019, 4:13am UTC](https://discuss.elastic.co/t/match-synonyms-and-match-exact-word-get-different-scores/165329 "2019-01-23T04:13:16Z")

</div>

Hi, I created a multiple analyzers for keyword field and I want to do the following: If the words matched keyword.exact, the score of the words will multiply by 1.2 If some other words matched keyword.synonym, the scor…

---

## [Automate rollover index](https://discuss.elastic.co/t/automate-rollover-index/165311)

<div class="topic-metadata">

**Author:** [@Yasmeenc](https://discuss.elastic.co/u/Yasmeenc)\
**Replies:** 8\
**Last updated:** [January 23, 2019, 4:04am UTC](https://discuss.elastic.co/t/automate-rollover-index/165311 "2019-01-23T04:04:37Z")

</div>

Hi Team, Does Elasticsearch rollover index automatically each time the rollover condition is true or it only do it once ? If once so how do I automate it, Please help

---

## [While query time and collector time bigger than request took time when profiling?](https://discuss.elastic.co/t/while-query-time-and-collector-time-bigger-than-request-took-time-when-profiling/164885)

<div class="topic-metadata">

**Author:** [@saiergon](https://discuss.elastic.co/u/saiergon)\
**Replies:** 4\
**Last updated:** [January 23, 2019, 2:33am UTC](https://discuss.elastic.co/t/while-query-time-and-collector-time-bigger-than-request-took-time-when-profiling/164885 "2019-01-23T02:33:10Z")

</div>

the search is very simple { "profile": true, "size": 0, "query": { "bool": { "must": \[ { "match": { "appid": "300047" } } \] } } } and the resp…

---

## [Accessing unindexed fields in script\_score](https://discuss.elastic.co/t/accessing-unindexed-fields-in-script-score/165248)

<div class="topic-metadata">

**Author:** [@halaei](https://discuss.elastic.co/u/halaei)\
**Replies:** 1\
**Last updated:** [January 23, 2019, 1:19am UTC](https://discuss.elastic.co/t/accessing-unindexed-fields-in-script-score/165248 "2019-01-23T01:19:18Z")

</div>

Does accessing fields that are not indexed in script\_score imposes extra time penalty? In other words, should I index all the fields that my script access, even if they are not queried? Sample part of my schema: { .…

[Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1416)

[Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1418)
