# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=153 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 154 --- ## [Default search timeout doesn't work](https://discuss.elastic.co/t/default-search-timeout-doesnt-work/350726)
**Author:** [@anon90868141](https://discuss.elastic.co/u/anon90868141)\ **Replies:** 3\ **Last updated:** [January 29, 2024, 7:44am UTC](https://discuss.elastic.co/t/default-search-timeout-doesnt-work/350726 "2024-01-29T07:44:39Z")
Hello, it seems like the following settings do not work for elasticsearch 7.17.10: PUT \_cluster/settings { "persistent": { "search.default\_search\_timeout": "300s", "search.low\_level\_cancellation": "true" } … --- ## [Sort terms aggregation by totla sum of 2 nested sum aggregations](https://discuss.elastic.co/t/sort-terms-aggregation-by-totla-sum-of-2-nested-sum-aggregations/351915)
**Author:** [@Assaf\_Cohen](https://discuss.elastic.co/u/Assaf_Cohen)\ **Replies:** 2\ **Last updated:** [January 28, 2024, 7:12pm UTC](https://discuss.elastic.co/t/sort-terms-aggregation-by-totla-sum-of-2-nested-sum-aggregations/351915 "2024-01-28T19:12:04Z")
I have an index which stores all the books and articles read by users. The books and articles are of nested type. I am trying to get the top x users who read the highest number of books and articles which match the speci… --- ## [Contains query in elastic search](https://discuss.elastic.co/t/contains-query-in-elastic-search/351932)
**Author:** [@post90](https://discuss.elastic.co/u/post90)\ **Replies:** 3\ **Last updated:** [January 28, 2024, 12:28pm UTC](https://discuss.elastic.co/t/contains-query-in-elastic-search/351932 "2024-01-28T12:28:43Z")
How do we do a contains string search in elasticsearch in more than 1 field efficiently e.g text "denis tomas" should be searchable by query "tom". I stumbled upon query\_string query but usage of wildcards make it ineffi… --- ## [Using one index and constantly removing from it would lead to a problem?](https://discuss.elastic.co/t/using-one-index-and-constantly-removing-from-it-would-lead-to-a-problem/351907)
**Author:** [@m4kkur0](https://discuss.elastic.co/u/m4kkur0)\ **Replies:** 0\ **Last updated:** [January 27, 2024, 6:20am UTC](https://discuss.elastic.co/t/using-one-index-and-constantly-removing-from-it-would-lead-to-a-problem/351907 "2024-01-27T06:20:46Z")
Hello, I wonder if using an index and constantly removing documents from it leads to problems? I upsert, daily, around 10 millions of documents so, there is a chance of removing 10 millions of documents. Why I am doing… --- ## [Deletion of data within frozen tier](https://discuss.elastic.co/t/deletion-of-data-within-frozen-tier/351828)
**Author:** [@Steven\_Richards](https://discuss.elastic.co/u/Steven_Richards)\ **Replies:** 2\ **Last updated:** [January 26, 2024, 9:30pm UTC](https://discuss.elastic.co/t/deletion-of-data-within-frozen-tier/351828 "2024-01-26T21:30:42Z")
Hello, I realize this question goes a bit counter to the usage of a frozen tier, but I'll outline our use-case. We have an ILM policy of 10 days hot, 80 days frozen. Some of our customers have the need to remove data w… --- ## [Generating same token for related words](https://discuss.elastic.co/t/generating-same-token-for-related-words/351902)
**Author:** [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\ **Replies:** 0\ **Last updated:** [January 26, 2024, 9:15pm UTC](https://discuss.elastic.co/t/generating-same-token-for-related-words/351902 "2024-01-26T21:15:51Z")
Hello everybody. I would like to know if it is possible using analyzer to generate the same token for the following words: "bronzeadora", "bronze", "bronzeado". The token I need for the three words would be "bronz". I … --- ## [Daily schedule transform from different indices](https://discuss.elastic.co/t/daily-schedule-transform-from-different-indices/351718)
**Author:** [@tmslara.a](https://discuss.elastic.co/u/tmslara.a)\ **Replies:** 2\ **Last updated:** [January 26, 2024, 7:13pm UTC](https://discuss.elastic.co/t/daily-schedule-transform-from-different-indices/351718 "2024-01-26T19:13:31Z")
Hello, We are currently ingesting data to an Elasticsearch cluster using Filebeat. We have configured Filebeat to create a new index every day, so the index template has the form index\_{+yyyymmdd}. We want to schedule … --- ## [Executing JSON query directly using Java API ignore the query algother](https://discuss.elastic.co/t/executing-json-query-directly-using-java-api-ignore-the-query-algother/351897)
**Author:** [@vinitp](https://discuss.elastic.co/u/vinitp)\ **Replies:** 0\ **Last updated:** [January 26, 2024, 6:25pm UTC](https://discuss.elastic.co/t/executing-json-query-directly-using-java-api-ignore-the-query-algother/351897 "2024-01-26T18:25:23Z")
In my application, we build the search query in JSON format.e.g { "query": { "bool": { "must": \[ { "term": { "officeCode.keyword": { "value": "410" } … --- ## [Fuzziness and Levenstein distance](https://discuss.elastic.co/t/fuzziness-and-levenstein-distance/351885)
**Author:** [@alba](https://discuss.elastic.co/u/alba)\ **Replies:** 2\ **Last updated:** [January 26, 2024, 5:46pm UTC](https://discuss.elastic.co/t/fuzziness-and-levenstein-distance/351885 "2024-01-26T17:46:15Z")
Hi guys, I have a multi\_match query with "fuzziness" : 2. When I search for "mexico" I get results with "medical" which have Levenstein distance 3 to "mexico". Could somebody explain it to me? --- ## [Set up remote cluster CA certificate in Elasticsearch 8.8.1](https://discuss.elastic.co/t/set-up-remote-cluster-ca-certificate-in-elasticsearch-8-8-1/351889)
**Author:** [@rachelyang](https://discuss.elastic.co/u/rachelyang)\ **Replies:** 0\ **Last updated:** [January 26, 2024, 2:53pm UTC](https://discuss.elastic.co/t/set-up-remote-cluster-ca-certificate-in-elasticsearch-8-8-1/351889 "2024-01-26T14:53:03Z")
I have a local cluster. Now I would like to set up a remote cluster to connect to the local cluster. How do I set up the CA certificate on the remote cluster node to make these two cluster to trust each other? Here is … --- ## [Manage of very updated index through auto force segments](https://discuss.elastic.co/t/manage-of-very-updated-index-through-auto-force-segments/351883)
**Author:** [@INS](https://discuss.elastic.co/u/INS)\ **Replies:** 0\ **Last updated:** [January 26, 2024, 1:48pm UTC](https://discuss.elastic.co/t/manage-of-very-updated-index-through-auto-force-segments/351883 "2024-01-26T13:48:34Z")
Hi is it possible to set the permanent value for max\_merged\_segment for internal auto force mode in elasticsearch? --- ## [Bucket script aggregation, do not return parameter values](https://discuss.elastic.co/t/bucket-script-aggregation-do-not-return-parameter-values/351872)
**Author:** [@Mert\_Uygur](https://discuss.elastic.co/u/Mert_Uygur)\ **Replies:** 0\ **Last updated:** [January 26, 2024, 11:26am UTC](https://discuss.elastic.co/t/bucket-script-aggregation-do-not-return-parameter-values/351872 "2024-01-26T11:26:23Z")
Hi, I am running Elasticsearch version 7.10, and I use Elasticsearch Java Client version 8. I basically run some aggregations to calculate a bucket script. I have defined scripts on elasticsearch, and use them in my requ… --- ## [Shrink operation in ILM is unusable when same\_shard is set in multinode cluster](https://discuss.elastic.co/t/shrink-operation-in-ilm-is-unusable-when-same-shard-is-set-in-multinode-cluster/351869)
**Author:** [@john90](https://discuss.elastic.co/u/john90)\ **Replies:** 3\ **Last updated:** [January 26, 2024, 11:45am UTC](https://discuss.elastic.co/t/shrink-operation-in-ilm-is-unusable-when-same-shard-is-set-in-multinode-cluster/351869 "2024-01-26T11:45:41Z")
Hi, I am trying to find out if this is really the case: shrink operation via API or ILM is unusable or at least unreliable when when both these conditions apply: cluster.routing.allocation.same\_shard.host is set to tru… --- ## [FSCrawler - Folder index is not getting created in the latest version](https://discuss.elastic.co/t/fscrawler-folder-index-is-not-getting-created-in-the-latest-version/351544)
**Author:** [@kamalsharma](https://discuss.elastic.co/u/kamalsharma)\ **Replies:** 8\ **Last updated:** [January 26, 2024, 9:46am UTC](https://discuss.elastic.co/t/fscrawler-folder-index-is-not-getting-created-in-the-latest-version/351544 "2024-01-26T09:46:28Z")
The index name is fs-test-001 (Example) in the \_settings.json file. After running the FsCrawler, Template is automatically added in the Elastic. I am able to see the Templates for the index as well as for the folders alo… --- ## [How to invoke custom rescorer plugin using elasticsearch-java 8 client](https://discuss.elastic.co/t/how-to-invoke-custom-rescorer-plugin-using-elasticsearch-java-8-client/351868)
**Author:** [@baji](https://discuss.elastic.co/u/baji)\ **Replies:** 0\ **Last updated:** [January 26, 2024, 9:27am UTC](https://discuss.elastic.co/t/how-to-invoke-custom-rescorer-plugin-using-elasticsearch-java-8-client/351868 "2024-01-26T09:27:49Z")
Hi, I have migrated a custom rescorer plugin from Elasticsearch version 7 to 8. I can invoke the plugin using the following request. However, I am unable to generate a similar request using elasticsearch-java 8.10.4. I … --- ## [I have installed Elasticsearch 7.17.17 version. i am doing semantic search, but at final search it give me the error which is give below:BadRequestError(400, 'illegal\_argument\_exception', 'Invalid type: expecting \[\_doc\] but got \[\_knn\_search\]')](https://discuss.elastic.co/t/i-have-installed-elasticsearch-7-17-17-version-i-am-doing-semantic-search-but-at-final-search-it-give-me-the-error-which-is-give-below-badrequesterror-400-illegal-argument-exception-invalid-type-expecting-doc-but-got-knn-search/351853)
**Author:** [@Muhammad\_Adnan1](https://discuss.elastic.co/u/Muhammad_Adnan1)\ **Replies:** 2\ **Last updated:** [January 26, 2024, 6:46am UTC](https://discuss.elastic.co/t/i-have-installed-elasticsearch-7-17-17-version-i-am-doing-semantic-search-but-at-final-search-it-give-me-the-error-which-is-give-below-badrequesterror-400-illegal-argument-exception-invalid-type-expecting-doc-but-got-knn-search/351853 "2024-01-26T06:46:07Z")
BadRequestError(400, 'illegal\_argument\_exception', 'Invalid type: expecting \[\_doc\] but got \[\_knn\_search\]') --- ## [Maintaining @timestamp order of docs when using the reindex api](https://discuss.elastic.co/t/maintaining-timestamp-order-of-docs-when-using-the-reindex-api/351318)
**Author:** [@petlit2049](https://discuss.elastic.co/u/petlit2049)\ **Replies:** 1\ **Last updated:** [January 26, 2024, 1:36am UTC](https://discuss.elastic.co/t/maintaining-timestamp-order-of-docs-when-using-the-reindex-api/351318 "2024-01-26T01:36:06Z")
There's a deprecated feature in the reindex api which makes (made?) it possible to maintain the timestamp order between docs being reindexed using the reindex api. However, the documentation states that this is a depreca… --- ## [Basic Setup failures joining an existing cluster](https://discuss.elastic.co/t/basic-setup-failures-joining-an-existing-cluster/351830)
**Author:** [@bryanrood](https://discuss.elastic.co/u/bryanrood)\ **Replies:** 0\ **Last updated:** [January 25, 2024, 7:53pm UTC](https://discuss.elastic.co/t/basic-setup-failures-joining-an-existing-cluster/351830 "2024-01-25T19:53:41Z")
Hi there, I have been beating my head against a tree trying to get nodes added to my new ES cluster. I'm trying to build a 6 node ES cluster. I got the first node working and I'm trying to add the second node. I can ge… --- ## [How to test or check Connection of my Java application to Elasticsearch?](https://discuss.elastic.co/t/how-to-test-or-check-connection-of-my-java-application-to-elasticsearch/351821)
**Author:** [@unknownuser](https://discuss.elastic.co/u/unknownuser)\ **Replies:** 1\ **Last updated:** [January 25, 2024, 5:43pm UTC](https://discuss.elastic.co/t/how-to-test-or-check-connection-of-my-java-application-to-elasticsearch/351821 "2024-01-25T17:43:45Z")
Hi Everyone! :slight\_smile: Can you help me to know how to check the connection between my java application to Elasticsearch? Btw, I am using the Elasticsearch version 8.11. I see the documentation Connecting | Elastics… --- ## [Elastic artifacts repository missing last release](https://discuss.elastic.co/t/elastic-artifacts-repository-missing-last-release/350367)
**Author:** [@nisow95612](https://discuss.elastic.co/u/nisow95612)\ **Replies:** 3\ **Last updated:** [January 25, 2024, 4:05pm UTC](https://discuss.elastic.co/t/elastic-artifacts-repository-missing-last-release/350367 "2024-01-25T16:05:49Z")
Hello, I again notice new elastic version is released - Release notes | Elasticsearch Guide \[7.17\] | Elastic, now also with security fixes (Elasticsearch 8.11.2, 7.17.16 Security Update (ESA-2023-29)), but it is not ava… --- ## [How often a shard is actually refreshing](https://discuss.elastic.co/t/how-often-a-shard-is-actually-refreshing/351801)
**Author:** [@ktech007](https://discuss.elastic.co/u/ktech007)\ **Replies:** 3\ **Last updated:** [January 25, 2024, 2:31pm UTC](https://discuss.elastic.co/t/how-often-a-shard-is-actually-refreshing/351801 "2024-01-25T14:31:31Z")
Hi, I am trying to better understand how often a shard is refreshed in comparison to the refresh interval. For some context: We are trying to calculate the indexing lag in our indexing pipeline and refresh interval is … --- ## [Terms aggregation is slow, setting eager\_global\_ordinals to True did not work](https://discuss.elastic.co/t/terms-aggregation-is-slow-setting-eager-global-ordinals-to-true-did-not-work/350550)
**Author:** [@rupesh.yadav](https://discuss.elastic.co/u/rupesh.yadav)\ **Replies:** 1\ **Last updated:** [January 25, 2024, 2:10pm UTC](https://discuss.elastic.co/t/terms-aggregation-is-slow-setting-eager-global-ordinals-to-true-did-not-work/350550 "2024-01-25T14:10:56Z")
I am quite new to ES so I might not know a few things. I have an Elasticsearch query\_string query and with that I have an aggregate query, I am trying to get the results as fast as I can. Currently, it is taking 20s to 2… --- ## [Can ELSER be used with languages other than English](https://discuss.elastic.co/t/can-elser-be-used-with-languages-other-than-english/351186)
**Author:** [@Chenko](https://discuss.elastic.co/u/Chenko)\ **Replies:** 11\ **Last updated:** [January 25, 2024, 1:02pm UTC](https://discuss.elastic.co/t/can-elser-be-used-with-languages-other-than-english/351186 "2024-01-25T13:02:19Z")
Hello, I'm posting to gather insights about ELSER's language capabilities, particularly its support for languages other than English. My interest lies in understanding how well ELSER handles the following languages: D… --- ## [Ingest pipeline ELSER embedding fails with more than 1 ML node](https://discuss.elastic.co/t/ingest-pipeline-elser-embedding-fails-with-more-than-1-ml-node/351673)
**Author:** [@Rakesh\_Nayak](https://discuss.elastic.co/u/Rakesh_Nayak)\ **Replies:** 1\ **Last updated:** [January 25, 2024, 11:25am UTC](https://discuss.elastic.co/t/ingest-pipeline-elser-embedding-fails-with-more-than-1-ml-node/351673 "2024-01-25T11:25:01Z")
Hello Team, We can create embeddings using a pipeline with 1 ML node. But, when we add another node, it seems like none of the documents gets ingested through the pipeline. Attached is the reference. note: using simula… --- ## [Elk 7.5 How to show all indexes having storage\_term as cold](https://discuss.elastic.co/t/elk-7-5-how-to-show-all-indexes-having-storage-term-as-cold/351377)
**Author:** [@mpniel](https://discuss.elastic.co/u/mpniel)\ **Replies:** 5\ **Last updated:** [January 25, 2024, 11:16am UTC](https://discuss.elastic.co/t/elk-7-5-how-to-show-all-indexes-having-storage-term-as-cold/351377 "2024-01-25T11:16:38Z")
How to show all indexes having storage\_term as cold? Why are there indexes with this cold parameter? --- ## [Delete index after 1 day if empty and after n days if not empty](https://discuss.elastic.co/t/delete-index-after-1-day-if-empty-and-after-n-days-if-not-empty/351741)
**Author:** [@elastico23](https://discuss.elastic.co/u/elastico23)\ **Replies:** 2\ **Last updated:** [January 25, 2024, 9:44am UTC](https://discuss.elastic.co/t/delete-index-after-1-day-if-empty-and-after-n-days-if-not-empty/351741 "2024-01-25T09:44:55Z")
Hi, we use daily indices and currently use an ILM policy to delete indices after n days. However, we have some indices each day that don't end up having documents and would like to delete those after 1 day instead of kee… --- ## [Trying to find the path to the nested found text](https://discuss.elastic.co/t/trying-to-find-the-path-to-the-nested-found-text/351752)
**Author:** [@warrengoldman](https://discuss.elastic.co/u/warrengoldman)\ **Replies:** 1\ **Last updated:** [January 24, 2024, 9:50pm UTC](https://discuss.elastic.co/t/trying-to-find-the-path-to-the-nested-found-text/351752 "2024-01-24T21:50:15Z")
What I need that I have NOT figured out I would like to get the path(s) to the found text. Where the path would be book name -\> chapter number -\> verse number (which is a sibling to verses.text) What I did figure out … --- ## [How to define tags and ignore\_failure on Java API Client PutPipelineRequest](https://discuss.elastic.co/t/how-to-define-tags-and-ignore-failure-on-java-api-client-putpipelinerequest/351292)
**Author:** [@afzm4](https://discuss.elastic.co/u/afzm4)\ **Replies:** 3\ **Last updated:** [January 24, 2024, 5:21pm UTC](https://discuss.elastic.co/t/how-to-define-tags-and-ignore-failure-on-java-api-client-putpipelinerequest/351292 "2024-01-24T17:21:54Z")
We are in the process of upgrading to the new Java API client and are running into some problems regarding using PutPipelineRequest. This is how we're defining a PutPipelineRequest: PutPipelineRequest putPipelineRequest… --- ## [How to get only matched value for field that has multiple values](https://discuss.elastic.co/t/how-to-get-only-matched-value-for-field-that-has-multiple-values/351667)
**Author:** [@elasticfan1](https://discuss.elastic.co/u/elasticfan1)\ **Replies:** 2\ **Last updated:** [January 24, 2024, 4:57pm UTC](https://discuss.elastic.co/t/how-to-get-only-matched-value-for-field-that-has-multiple-values/351667 "2024-01-24T16:57:29Z")
Let's say I have a document with a type as you go field that has multiple values. tags : \["cool beans", "great job", hello there"\] I do a phrase prefix search with the term "coo". I want to display the user "cool beans… --- ## [Data not getting synced properly from SQL to elastic](https://discuss.elastic.co/t/data-not-getting-synced-properly-from-sql-to-elastic/351722)
**Author:** [@abhishek\_agarwal](https://discuss.elastic.co/u/abhishek_agarwal)\ **Replies:** 1\ **Last updated:** [January 24, 2024, 3:52pm UTC](https://discuss.elastic.co/t/data-not-getting-synced-properly-from-sql-to-elastic/351722 "2024-01-24T15:52:58Z")
I am syncing data from sql to elastic and in filter in the code block I am appending to map eg features but what is happening is that when I am running the bulk sql query ,not all features are getting appended to each in… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=152) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=154)