# Elasticsearch

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

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

**Page:** 584

---

## [Painless pains: Weird behaviour with try-catch and dotProduct functions](https://discuss.elastic.co/t/painless-pains-weird-behaviour-with-try-catch-and-dotproduct-functions/282499)

<div class="topic-metadata">

**Author:** [@SKRYMr](https://discuss.elastic.co/u/SKRYMr)\
**Replies:** 1\
**Last updated:** [September 1, 2021, 6:34pm UTC](https://discuss.elastic.co/t/painless-pains-weird-behaviour-with-try-catch-and-dotproduct-functions/282499 "2021-09-01T18:34:48Z")

</div>

Hello, in our team we use painless scripting quite heavily and have come across some very weird behaviour from time to time, the latest having to do with the following piece of code: try { double test = dotProduct(k…

---

## [Purpose of State files](https://discuss.elastic.co/t/purpose-of-state-files/282849)

<div class="topic-metadata">

**Author:** [@hyadavalli](https://discuss.elastic.co/u/hyadavalli)\
**Replies:** 5\
**Last updated:** [September 1, 2021, 5:17pm UTC](https://discuss.elastic.co/t/purpose-of-state-files/282849 "2021-09-01T17:17:17Z")

</div>

Hello Everyone, After searching everywhere, I couldn't find the purpose of state files. We started off with version 2.2 and then went to 5.6 and then at 6.8 atm. Below is the scenario we frequently run into: Elastics…

---

## ["Required array length too large" error during reindex](https://discuss.elastic.co/t/required-array-length-too-large-error-during-reindex/283090)

<div class="topic-metadata">

**Author:** [@Richard\_Ney](https://discuss.elastic.co/u/Richard_Ney)\
**Replies:** 0\
**Last updated:** [September 1, 2021, 5:49pm UTC](https://discuss.elastic.co/t/required-array-length-too-large-error-during-reindex/283090 "2021-09-01T17:49:52Z")

</div>

I'm in the process of reindexing an index of large nested documents. During the reindex I'm using painless script to pull a couple nested documents up a level. For the most part the reindex is going fine but occasionally…

---

## [ES7 - HighLevelClient: QueryBuilder serialization / Licensing / performance single node](https://discuss.elastic.co/t/es7-highlevelclient-querybuilder-serialization-licensing-performance-single-node/282748)

<div class="topic-metadata">

**Author:** [@K\_B](https://discuss.elastic.co/u/K_B)\
**Replies:** 1\
**Last updated:** [September 1, 2021, 4:08pm UTC](https://discuss.elastic.co/t/es7-highlevelclient-querybuilder-serialization-licensing-performance-single-node/282748 "2021-09-01T16:08:06Z")

</div>

Hi, i moved our java application from 1.7 to 7.14 (kinda lot of work... much changed, steps were 1.3 -\> 1.7 -\> 2.0 -\> 2.4 -\> 5.6 -\> 6.18 -\> 7.14) and its now nearly working as expected. However, somewhere during the 2.x…

---

## [Applying aggregation to query results](https://discuss.elastic.co/t/applying-aggregation-to-query-results/283042)

<div class="topic-metadata">

**Author:** [@me.mohammed](https://discuss.elastic.co/u/me.mohammed)\
**Replies:** 1\
**Last updated:** [September 1, 2021, 2:52pm UTC](https://discuss.elastic.co/t/applying-aggregation-to-query-results/283042 "2021-09-01T14:52:22Z")

</div>

Hello everyone, I'm trying to apply an aggregation filter to my query, I basically have an array of objects which looks like this { "productDeals": \[ { "id": 1, "startAt": "2021-08-30T17:40:14.000Z", "end…

---

## [Two node cluster - Keep certain indexes on primary instance](https://discuss.elastic.co/t/two-node-cluster-keep-certain-indexes-on-primary-instance/283050)

<div class="topic-metadata">

**Author:** [@save4elastic](https://discuss.elastic.co/u/save4elastic)\
**Replies:** 1\
**Last updated:** [September 1, 2021, 2:29pm UTC](https://discuss.elastic.co/t/two-node-cluster-keep-certain-indexes-on-primary-instance/283050 "2021-09-01T14:29:51Z")

</div>

Is it possible to keep certain high usage indices on the more powerful instance and offload indexes that are older to a low power instance? I am hoping to keep all shards of new indexes on the primary instance to increas…

---

## [Is Update By Query API a good choice to update single document in elasticsearch?](https://discuss.elastic.co/t/is-update-by-query-api-a-good-choice-to-update-single-document-in-elasticsearch/283035)

<div class="topic-metadata">

**Author:** [@Karthikeyan\_Amaresan](https://discuss.elastic.co/u/Karthikeyan_Amaresan)\
**Replies:** 2\
**Last updated:** [September 1, 2021, 1:30pm UTC](https://discuss.elastic.co/t/is-update-by-query-api-a-good-choice-to-update-single-document-in-elasticsearch/283035 "2021-09-01T13:30:16Z")

</div>

I have a use case where i want to update the document without knowing its index. Currently i am querying by id and getting the index and then updating (2 operation). Update By Query API seems to perform this use case in …

---

## [ElasticSearch version 7.14.0 can't highlight with search\_as\_you\_type datatype subfield](https://discuss.elastic.co/t/elasticsearch-version-7-14-0-cant-highlight-with-search-as-you-type-datatype-subfield/283005)

<div class="topic-metadata">

**Author:** [@andrewbien](https://discuss.elastic.co/u/andrewbien)\
**Replies:** 1\
**Last updated:** [September 1, 2021, 1:17pm UTC](https://discuss.elastic.co/t/elasticsearch-version-7-14-0-cant-highlight-with-search-as-you-type-datatype-subfield/283005 "2021-09-01T13:17:05Z")

</div>

Here is my example to reproduce the problem: PUT mytest { "mappings": { "properties": { "title": { "type": "keyword", "fields": { "autocomplete": { "type": "search\_as\_y…

---

## [Unexpected "Nesting" for Single Property on IndexRequests Failing](https://discuss.elastic.co/t/unexpected-nesting-for-single-property-on-indexrequests-failing/282930)

<div class="topic-metadata">

**Author:** [@rionmonster](https://discuss.elastic.co/u/rionmonster)\
**Replies:** 1\
**Last updated:** [September 1, 2021, 8:49am UTC](https://discuss.elastic.co/t/unexpected-nesting-for-single-property-on-indexrequests-failing/282930 "2021-09-01T08:49:48Z")

</div>

Hi all, I recently started using Elasticsearch and I was a bit baffled when I tried to create an IndexRequest to one of my indices using the following payload and receiving a limit of mapping depth exceeded message: "st…

---

## [Combine Exact/phrase search and \* to get results starting with firstname lastname\* - Robert will\*](https://discuss.elastic.co/t/combine-exact-phrase-search-and-to-get-results-starting-with-firstname-lastname-robert-will/282962)

<div class="topic-metadata">

**Author:** [@lakshmiteja\_salapu](https://discuss.elastic.co/u/lakshmiteja_salapu)\
**Replies:** 1\
**Last updated:** [September 1, 2021, 8:48am UTC](https://discuss.elastic.co/t/combine-exact-phrase-search-and-to-get-results-starting-with-firstname-lastname-robert-will/282962 "2021-09-01T08:48:05Z")

</div>

I want to search for Robert Will\* and expecting results that include Robert willow , Robert wills But I am getting documents that contain Robert Smith with street address 18 willow street Question 1) How to get resul…

---

## [How to serialize SearchRequest?](https://discuss.elastic.co/t/how-to-serialize-searchrequest/282793)

<div class="topic-metadata">

**Author:** [@fatcloud](https://discuss.elastic.co/u/fatcloud)\
**Replies:** 6\
**Last updated:** [September 1, 2021, 8:33am UTC](https://discuss.elastic.co/t/how-to-serialize-searchrequest/282793 "2021-09-01T08:33:57Z")

</div>

Hi, I'm new to elastic search, I need to log SearchRequest and use them later for testing/analysis purpose, what's the best practice to serialize/deserialize a SearchRequest in Java? Thanks!

---

## [How to integrate elasticsearch with service now for auto ticketing](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-service-now-for-auto-ticketing/282996)

<div class="topic-metadata">

**Author:** [@tahseen\_fatima](https://discuss.elastic.co/u/tahseen_fatima)\
**Replies:** 0\
**Last updated:** [September 1, 2021, 6:49am UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-service-now-for-auto-ticketing/282996 "2021-09-01T06:49:32Z")

</div>

Hi Team, I have setup of a ELK with 3 node cluster. I want to integrate elastic with service now for auto ticketing. What will be the possible ways to do this? For this service now Integration can we use basic au…

---

## [GEO data losing definition after changing index name](https://discuss.elastic.co/t/geo-data-losing-definition-after-changing-index-name/282917)

<div class="topic-metadata">

**Author:** [@john12](https://discuss.elastic.co/u/john12)\
**Replies:** 2\
**Last updated:** [September 1, 2021, 5:17am UTC](https://discuss.elastic.co/t/geo-data-losing-definition-after-changing-index-name/282917 "2021-09-01T05:17:21Z")

</div>

Hello , i was having geo data with no problems and visualize it on maps, after changing the index name then it not appeared as geo data. would u help me solve this?

---

## [Making a new field indexable on a index under rollover policy](https://discuss.elastic.co/t/making-a-new-field-indexable-on-a-index-under-rollover-policy/282931)

<div class="topic-metadata">

**Author:** [@Baygon](https://discuss.elastic.co/u/Baygon)\
**Replies:** 3\
**Last updated:** [September 1, 2021, 2:07am UTC](https://discuss.elastic.co/t/making-a-new-field-indexable-on-a-index-under-rollover-policy/282931 "2021-09-01T02:07:13Z")

</div>

Hi, We have an index under rollover policy/index template for which we need to update the mapping to make a field searchable (initially set up to index: false but now needed). What would be the right process? I'm thin…

---

## [Simple full search](https://discuss.elastic.co/t/simple-full-search/282939)

<div class="topic-metadata">

**Author:** [@Chen\_Shacham](https://discuss.elastic.co/u/Chen_Shacham)\
**Replies:** 1\
**Last updated:** [September 1, 2021, 12:46am UTC](https://discuss.elastic.co/t/simple-full-search/282939 "2021-09-01T00:46:04Z")

</div>

Hi I am using REST api to search my index. How can i use search api to look for phrase: "My name" in all fields?

---

## [Cross Cluster Replication query](https://discuss.elastic.co/t/cross-cluster-replication-query/282906)

<div class="topic-metadata">

**Author:** [@Bryce\_Fernandes](https://discuss.elastic.co/u/Bryce_Fernandes)\
**Replies:** 1\
**Last updated:** [September 1, 2021, 12:45am UTC](https://discuss.elastic.co/t/cross-cluster-replication-query/282906 "2021-09-01T00:45:15Z")

</div>

Hi, For CCR when a leader index is created in cluster A will replica be created in cluster A as well as cluster B or only cluster B considering replicas set to 1. Regards, Bryce Fernandes.

---

## [Migrating indices after adding warm and cold nodes to an existing cluster](https://discuss.elastic.co/t/migrating-indices-after-adding-warm-and-cold-nodes-to-an-existing-cluster/282830)

<div class="topic-metadata">

**Author:** [@benvl](https://discuss.elastic.co/u/benvl)\
**Replies:** 3\
**Last updated:** [August 31, 2021, 10:15pm UTC](https://discuss.elastic.co/t/migrating-indices-after-adding-warm-and-cold-nodes-to-an-existing-cluster/282830 "2021-08-31T22:15:22Z")

</div>

Hi all, following situation : we have an existing 7.12 ES cluster in Elastic Cloud, with 2 hot data nodes. Multiple indices exist which were following an hot-warm-cold ILM policy and are already in a hot, warm or cold p…

---

## [Set ilm , rollup in curator](https://discuss.elastic.co/t/set-ilm-rollup-in-curator/282749)

<div class="topic-metadata">

**Author:** [@lstoneir](https://discuss.elastic.co/u/lstoneir)\
**Replies:** 5\
**Last updated:** [August 31, 2021, 9:47pm UTC](https://discuss.elastic.co/t/set-ilm-rollup-in-curator/282749 "2021-08-31T21:47:42Z")

</div>

I want to do some actions like: create ilm set ilm for indices create rollup jobs for indices Is this possible to do with elsaticsearch-curator?

---

## [How to change routing value for existed routed data?](https://discuss.elastic.co/t/how-to-change-routing-value-for-existed-routed-data/280689)

<div class="topic-metadata">

**Author:** [@judy\_gao](https://discuss.elastic.co/u/judy_gao)\
**Replies:** 4\
**Last updated:** [August 31, 2021, 8:00pm UTC](https://discuss.elastic.co/t/how-to-change-routing-value-for-existed-routed-data/280689 "2021-08-31T20:00:56Z")

</div>

I have an existed index which is "\_routing" required as true. So all data is already routed to particular shards based on "\_routing" value. Right now we're using a customized routing value like "organization id" to route…

---

## [Do I need to follow Full-cluster restart steps for 1 Node](https://discuss.elastic.co/t/do-i-need-to-follow-full-cluster-restart-steps-for-1-node/282269)

<div class="topic-metadata">

**Author:** [@Zabulon](https://discuss.elastic.co/u/Zabulon)\
**Replies:** 4\
**Last updated:** [August 31, 2021, 5:53pm UTC](https://discuss.elastic.co/t/do-i-need-to-follow-full-cluster-restart-steps-for-1-node/282269 "2021-08-31T17:53:37Z")

</div>

Hi everyone, We had some discussion at the office about restarting a node or service when there is 1 node only issue. Some people find that it is a bit awkwark to follow the step from "Full-cluster restart" document…

---

## [Configure certificate for repository-s3 with ceph](https://discuss.elastic.co/t/configure-certificate-for-repository-s3-with-ceph/282645)

<div class="topic-metadata">

**Author:** [@raphaelSeguin](https://discuss.elastic.co/u/raphaelSeguin)\
**Replies:** 5\
**Last updated:** [August 31, 2021, 5:24pm UTC](https://discuss.elastic.co/t/configure-certificate-for-repository-s3-with-ceph/282645 "2021-08-31T17:24:04Z")

</div>

Hi All, I'm having a hard time setting up a repository with repository-s3 plugin and a ceph object store. I'm using elasticsearch:7.13.2 I used the following configurations: in elasticsearch.yml: s3: client: d…

---

## [ES 6.8 issue with percolate search on documents with a join field](https://discuss.elastic.co/t/es-6-8-issue-with-percolate-search-on-documents-with-a-join-field/282851)

<div class="topic-metadata">

**Author:** [@noe](https://discuss.elastic.co/u/noe)\
**Replies:** 1\
**Last updated:** [August 31, 2021, 4:13pm UTC](https://discuss.elastic.co/t/es-6-8-issue-with-percolate-search-on-documents-with-a-join-field/282851 "2021-08-31T16:13:03Z")

</div>

I'm working on updating ES mappings and searching within an application from 5.6 to 6.8. The relevant change around this is that I merged multi-type mapping of an index into a single type and now use a custom 'type' fiel…

---

## [Why Rally extract 1001 docs in --test-mode?](https://discuss.elastic.co/t/why-rally-extract-1001-docs-in-test-mode/282836)

<div class="topic-metadata">

**Author:** [@rschirin](https://discuss.elastic.co/u/rschirin)\
**Replies:** 5\
**Last updated:** [August 31, 2021, 3:06pm UTC](https://discuss.elastic.co/t/why-rally-extract-1001-docs-in-test-mode/282836 "2021-08-31T15:06:08Z")

</div>

Hey there, extracting a custom track from an existing cluster I faced a strange behaviour. Rally extracts 1001 docs while it should extract exactly 1000 docs. When I try to import it with the flag --test-mode I get thi…

---

## [Elastic can not start because of memory issue](https://discuss.elastic.co/t/elastic-can-not-start-because-of-memory-issue/282711)

<div class="topic-metadata">

**Author:** [@Vladimir](https://discuss.elastic.co/u/Vladimir)\
**Replies:** 15\
**Last updated:** [August 31, 2021, 1:41pm UTC](https://discuss.elastic.co/t/elastic-can-not-start-because-of-memory-issue/282711 "2021-08-31T13:41:57Z")

</div>

Hi there, can somebody tell me please why my Elastic installation dont want to start? Log says it is out of memory. But it should contains only one index with about one million items. The server params are: 6vCPU, 16G RA…

---

## [Query to get percentiles of a calculated sum value](https://discuss.elastic.co/t/query-to-get-percentiles-of-a-calculated-sum-value/282800)

<div class="topic-metadata">

**Author:** [@ankitdevnalkar](https://discuss.elastic.co/u/ankitdevnalkar)\
**Replies:** 1\
**Last updated:** [August 31, 2021, 12:43pm UTC](https://discuss.elastic.co/t/query-to-get-percentiles-of-a-calculated-sum-value/282800 "2021-08-31T12:43:39Z")

</div>

Based on the query below, I want to find percentile bucket of the values I am getting from date\_histogram aggregation. Below is my working query to find the day-wise total for the last 7 days, I am not sure where should…

---

## [Is the document ID likely to change in Machine Learning result index](https://discuss.elastic.co/t/is-the-document-id-likely-to-change-in-machine-learning-result-index/282892)

<div class="topic-metadata">

**Author:** [@OmarDacca](https://discuss.elastic.co/u/OmarDacca)\
**Replies:** 4\
**Last updated:** [August 31, 2021, 12:16pm UTC](https://discuss.elastic.co/t/is-the-document-id-likely-to-change-in-machine-learning-result-index/282892 "2021-08-31T12:16:58Z")

</div>

Hi, Is the document ID likely to change in Machine Learning result index ? we have an anomaly alerting system, in the alerts I see document id that I can't find in the result index. so I guess I'm right ? if so then …

---

## [Restoring selected indexes from a snapshot using regex in Curator?](https://discuss.elastic.co/t/restoring-selected-indexes-from-a-snapshot-using-regex-in-curator/281951)

<div class="topic-metadata">

**Author:** [@pradeepgm](https://discuss.elastic.co/u/pradeepgm)\
**Replies:** 2\
**Last updated:** [August 31, 2021, 11:43am UTC](https://discuss.elastic.co/t/restoring-selected-indexes-from-a-snapshot-using-regex-in-curator/281951 "2021-08-31T11:43:53Z")

</div>

Hi, I would like to restore selected indexes based on regex from ElasticSearch Snapshot using Curator. For example while taking a snapshot of selected indexes we can mention the regex in filtertype as below filters: …

---

## [Question on Elasticsearch upgrade using Ansible](https://discuss.elastic.co/t/question-on-elasticsearch-upgrade-using-ansible/282519)

<div class="topic-metadata">

**Author:** [@Arunlal\_A](https://discuss.elastic.co/u/Arunlal_A)\
**Replies:** 4\
**Last updated:** [August 31, 2021, 10:49am UTC](https://discuss.elastic.co/t/question-on-elasticsearch-upgrade-using-ansible/282519 "2021-08-31T10:49:47Z")

</div>

Hi, A quick basic question to the community. I have one three node Elasticsearch cluster (version 7.6.2) which was setup using the official Ansible role GitHub - elastic/ansible-elasticsearch: Ansible playbook for Elas…

---

## [Elasticsearch worked and then stopped](https://discuss.elastic.co/t/elasticsearch-worked-and-then-stopped/282795)

<div class="topic-metadata">

**Author:** [@sasha198407](https://discuss.elastic.co/u/sasha198407)\
**Replies:** 11\
**Last updated:** [August 31, 2021, 9:20am UTC](https://discuss.elastic.co/t/elasticsearch-worked-and-then-stopped/282795 "2021-08-31T09:20:30Z")

</div>

Elasticsearch worked and then stopped. It starts, runs for a minute and falls. In the logs, this is what. "at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) ~\[?:?\]", "at java.util.concur…

---

## [Is Rally a good choice to create data lake?](https://discuss.elastic.co/t/is-rally-a-good-choice-to-create-data-lake/282826)

<div class="topic-metadata">

**Author:** [@rschirin](https://discuss.elastic.co/u/rschirin)\
**Replies:** 8\
**Last updated:** [August 31, 2021, 8:49am UTC](https://discuss.elastic.co/t/is-rally-a-good-choice-to-create-data-lake/282826 "2021-08-31T08:49:10Z")

</div>

hey there, regularly I have to create a clusters from scratch and test their performances when indices contain data at least from 20 days. The possibility to have a data lake will give me the chance to avoid to wait for…

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

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