# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=341 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 342 --- ## [Error creating a new index : validation failed maximum shards open](https://discuss.elastic.co/t/error-creating-a-new-index-validation-failed-maximum-shards-open/318564)
**Author:** [@mpniel](https://discuss.elastic.co/u/mpniel)\ **Replies:** 3\ **Last updated:** [November 20, 2022, 5:32pm UTC](https://discuss.elastic.co/t/error-creating-a-new-index-validation-failed-maximum-shards-open/318564 "2022-11-20T17:32:39Z")
Hi, I need to create a new index and get the following error: Could you please help? command: POST /myindex1213/\_doc error message: validatiion failed 1: this action would add \[2\] total shards, but this cluster cur… --- ## [Where can I see my Certificate Fingerprint?](https://discuss.elastic.co/t/where-can-i-see-my-certificate-fingerprint/319335)
**Author:** [@asd11](https://discuss.elastic.co/u/asd11)\ **Replies:** 6\ **Last updated:** [November 20, 2022, 3:50pm UTC](https://discuss.elastic.co/t/where-can-i-see-my-certificate-fingerprint/319335 "2022-11-20T15:50:20Z")
The documentation says: the CA fingerprint logged by the server at initial startup. However I can't find it. Is it in security -\> CA certificates? If yes, than I can download that file, but how can I get the fingerpr… --- ## [Spark use both sql and dsl to query](https://discuss.elastic.co/t/spark-use-both-sql-and-dsl-to-query/319068)
**Author:** [@robocon20x](https://discuss.elastic.co/u/robocon20x)\ **Replies:** 2\ **Last updated:** [November 20, 2022, 1:55am UTC](https://discuss.elastic.co/t/spark-use-both-sql-and-dsl-to-query/319068 "2022-11-20T01:55:13Z")
i can use API to call endpoint SQL combine both SQL query and dsl follow this doc link . my question is how can I use this query by spark-elasticsearch? Thanks and best regards --- ## [Is reindexing to a new index necessary after updating settings and mappings to support a multi-field in elasticsearch?](https://discuss.elastic.co/t/is-reindexing-to-a-new-index-necessary-after-updating-settings-and-mappings-to-support-a-multi-field-in-elasticsearch/319260)
**Author:** [@Karthik\_Amar](https://discuss.elastic.co/u/Karthik_Amar)\ **Replies:** 4\ **Last updated:** [November 20, 2022, 12:57am UTC](https://discuss.elastic.co/t/is-reindexing-to-a-new-index-necessary-after-updating-settings-and-mappings-to-support-a-multi-field-in-elasticsearch/319260 "2022-11-20T00:57:21Z")
Please consider the scenario. Existing System I have an index named contacts\_index with 100 documents. Each document has property named city with some text value in it. Index has settings as the following { … --- ## [Sort products by ids stored in product\_cat index](https://discuss.elastic.co/t/sort-products-by-ids-stored-in-product-cat-index/318772)
**Author:** [@kiko](https://discuss.elastic.co/u/kiko)\ **Replies:** 5\ **Last updated:** [November 19, 2022, 1:49pm UTC](https://discuss.elastic.co/t/sort-products-by-ids-stored-in-product-cat-index/318772 "2022-11-19T13:49:29Z")
I have a products index which I now need to sort using ordered list of IDs stored in each product category document (in product\_categories index), like so: // product index { id:1, name: "coco" }, { id:2, name: "hazel" … --- ## [Java access denied when starting elasticsearch](https://discuss.elastic.co/t/java-access-denied-when-starting-elasticsearch/319333)
**Author:** [@johnny1891](https://discuss.elastic.co/u/johnny1891)\ **Replies:** 2\ **Last updated:** [November 19, 2022, 11:08am UTC](https://discuss.elastic.co/t/java-access-denied-when-starting-elasticsearch/319333 "2022-11-19T11:08:49Z")
Hi, I'm following this tutorial to install ELK stack How to install Elastic SIEM and Elastic EDR - On The Hunt but after adding certificates, I try to restart the service but I get this: I downloaded elastic today o… --- ## [Elasticsearch Fails to Start Java Lang Illegal State Exception: No match found](https://discuss.elastic.co/t/elasticsearch-fails-to-start-java-lang-illegal-state-exception-no-match-found/319239)
**Author:** [@D3epDiv3r](https://discuss.elastic.co/u/D3epDiv3r)\ **Replies:** 7\ **Last updated:** [November 19, 2022, 1:00am UTC](https://discuss.elastic.co/t/elasticsearch-fails-to-start-java-lang-illegal-state-exception-no-match-found/319239 "2022-11-19T01:00:32Z")
Hello folks, I have been trying to get Elastic Stack to run for at least 2 days now, I have been given a project in school that requires me to use Elasticsearch 5.2.0 specifically (Logstash 5.2.0, and Kibana 5.2.0) I hav… --- ## [Filtering aggregation results based on nested objects in ElasticSearch](https://discuss.elastic.co/t/filtering-aggregation-results-based-on-nested-objects-in-elasticsearch/319313)
**Author:** [@kornikopic](https://discuss.elastic.co/u/kornikopic)\ **Replies:** 0\ **Last updated:** [November 18, 2022, 3:11pm UTC](https://discuss.elastic.co/t/filtering-aggregation-results-based-on-nested-objects-in-elasticsearch/319313 "2022-11-18T15:11:59Z")
In my database, I have 2 tables such as: +------------+ +-------------+ | Project | | Deliverable | +------------+ +-------------+ | id +----------+ project\_id | | |1 … --- ## [Roadmap for the Elastic Stack Subscription model](https://discuss.elastic.co/t/roadmap-for-the-elastic-stack-subscription-model/319302)
**Author:** [@hanna](https://discuss.elastic.co/u/hanna)\ **Replies:** 1\ **Last updated:** [November 18, 2022, 9:23pm UTC](https://discuss.elastic.co/t/roadmap-for-the-elastic-stack-subscription-model/319302 "2022-11-18T21:23:21Z")
what are the plans in the future regarding the Elastic Stack subscriptions? Can I be sure that the features of the basic subscription will remain available free of charge in the future? I would like to avoid unexpected c… --- ## [How can I edit "network.host" from cloud.elastic.co?](https://discuss.elastic.co/t/how-can-i-edit-network-host-from-cloud-elastic-co/319327)
**Author:** [@asd11](https://discuss.elastic.co/u/asd11)\ **Replies:** 1\ **Last updated:** [November 18, 2022, 7:26pm UTC](https://discuss.elastic.co/t/how-can-i-edit-network-host-from-cloud-elastic-co/319327 "2022-11-18T19:26:45Z")
I know that I have to edit elasticsearch.yml. I tried it from Manage user settings and extensions but the user setting is not supported... I also tried it from the API console, but it says: "persistent setting \[network… --- ## [Snapshot and restore](https://discuss.elastic.co/t/snapshot-and-restore/319134)
**Author:** [@Harper\_S1](https://discuss.elastic.co/u/Harper_S1)\ **Replies:** 4\ **Last updated:** [November 18, 2022, 3:54pm UTC](https://discuss.elastic.co/t/snapshot-and-restore/319134 "2022-11-18T15:54:29Z")
Hi, We are planning to upgrade our ELK stack from 6.8 to 8.2. We are trying to take the snapshot and it is working fine but, wondering if there are any api to restore so we can test all the breaking changes before movi… --- ## [Clarification on base dependencies](https://discuss.elastic.co/t/clarification-on-base-dependencies/319146)
**Author:** [@chitralverma](https://discuss.elastic.co/u/chitralverma)\ **Replies:** 1\ **Last updated:** [November 18, 2022, 2:26pm UTC](https://discuss.elastic.co/t/clarification-on-base-dependencies/319146 "2022-11-18T14:26:08Z")
Do we use the new elasticsearch-java client mentioned below in es-hadoop and es-spark ? https://mvnrepository.com/artifact/co.elastic.clients/elasticsearch-java/8.5.0 --- ## [Optimizing single-node search performance](https://discuss.elastic.co/t/optimizing-single-node-search-performance/319292)
**Author:** [@Jozef](https://discuss.elastic.co/u/Jozef)\ **Replies:** 3\ **Last updated:** [November 18, 2022, 2:13pm UTC](https://discuss.elastic.co/t/optimizing-single-node-search-performance/319292 "2022-11-18T14:13:20Z")
Hello all, I am relatively new to Elasticsearch, and am currently trying to optimize a single-node ES instance. I am trying to understand a concept, which seems to have conflicting information. First of all, the data I… --- ## [How can I know kibana dashboard latency, max indexing tps, data volume queried per time etc](https://discuss.elastic.co/t/how-can-i-know-kibana-dashboard-latency-max-indexing-tps-data-volume-queried-per-time-etc/319306)
**Author:** [@qksjdhi1212](https://discuss.elastic.co/u/qksjdhi1212)\ **Replies:** 1\ **Last updated:** [November 18, 2022, 1:47pm UTC](https://discuss.elastic.co/t/how-can-i-know-kibana-dashboard-latency-max-indexing-tps-data-volume-queried-per-time-etc/319306 "2022-11-18T13:47:32Z")
I wanted to test my es to find ideal cluster volume in my production level (the number of shards and their size etc) I watched one video Quantitative Cluster Sizing and decided to follow steps in the video (Quantitati… --- ## [What is the approach for edge\_ngram search query to have a correct word slop count?](https://discuss.elastic.co/t/what-is-the-approach-for-edge-ngram-search-query-to-have-a-correct-word-slop-count/319301)
**Author:** [@orange.cold256](https://discuss.elastic.co/u/orange.cold256)\ **Replies:** 0\ **Last updated:** [November 18, 2022, 12:59pm UTC](https://discuss.elastic.co/t/what-is-the-approach-for-edge-ngram-search-query-to-have-a-correct-word-slop-count/319301 "2022-11-18T12:59:57Z")
I'm trying to make a soft prefix-search within n fields. Also the distance between tokens is a must. so I've decided to use edge\_ngrams with a bool query. But as far the tokens are edge\_ngrams the slop is calculated in t… --- ## [Connection exception during geoip database \[ERROR\]\[o.e.i.g.GeoIpDownloader \]\[WUWVC0ASX02\]](https://discuss.elastic.co/t/connection-exception-during-geoip-database-error-o-e-i-g-geoipdownloader-wuwvc0asx02/318942)
**Author:** [@Kamil\_BdBelfort](https://discuss.elastic.co/u/Kamil_BdBelfort)\ **Replies:** 4\ **Last updated:** [November 18, 2022, 9:45am UTC](https://discuss.elastic.co/t/connection-exception-during-geoip-database-error-o-e-i-g-geoipdownloader-wuwvc0asx02/318942 "2022-11-18T09:45:36Z")
Hi there, I've downloaded the latest version of elasticsearch 8.5.1 and when I try to run it (bin\\elasticsearch.bat) I get this error: \[2022-11-15T01:08:55,761\]\[ERROR\]\[o.e.i.g.GeoIpDownloader \] \[WUWVC0ASX02\] exception… --- ## [Getting empty response from server](https://discuss.elastic.co/t/getting-empty-response-from-server/319175)
**Author:** [@Neelam\_Zanvar](https://discuss.elastic.co/u/Neelam_Zanvar)\ **Replies:** 9\ **Last updated:** [November 18, 2022, 4:42am UTC](https://discuss.elastic.co/t/getting-empty-response-from-server/319175 "2022-11-18T04:42:00Z")
Hi I've installed elk stack of version 8.5.1. All services are active. But when i try to access curl http://localhost:9200 or publicip:9200 getting empty response error path.data: /var/lib/elasticsearch path.logs: /var… --- ## [Is there a way to combine BM25 lexical search score with dense vector score to interpolate them together?](https://discuss.elastic.co/t/is-there-a-way-to-combine-bm25-lexical-search-score-with-dense-vector-score-to-interpolate-them-together/319243)
**Author:** [@Scott\_M](https://discuss.elastic.co/u/Scott_M)\ **Replies:** 0\ **Last updated:** [November 17, 2022, 9:54pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-combine-bm25-lexical-search-score-with-dense-vector-score-to-interpolate-them-together/319243 "2022-11-17T21:54:49Z")
Hello, this is related to the closed topic here: Sorry to make new topic but that one is closed. I created a query based on the answer there, and it runs fine but gives only the bm25 answers, none of the vector-based … --- ## [Is possible to extract \_id doc with Rally and custom track?](https://discuss.elastic.co/t/is-possible-to-extract-id-doc-with-rally-and-custom-track/319070)
**Author:** [@rschirin](https://discuss.elastic.co/u/rschirin)\ **Replies:** 5\ **Last updated:** [November 17, 2022, 6:41pm UTC](https://discuss.elastic.co/t/is-possible-to-extract-id-doc-with-rally-and-custom-track/319070 "2022-11-17T18:41:53Z")
Hey there, I would like to know if could be possible to extract the \_id document when creating a custom-track with Rally. The goal is to test write performance when the \_id is provided and not thanks --- ## [Has anybody run ES cluster on AWS using either is4gen or im4gn? vs say i4i?](https://discuss.elastic.co/t/has-anybody-run-es-cluster-on-aws-using-either-is4gen-or-im4gn-vs-say-i4i/319249)
**Author:** [@linkerc](https://discuss.elastic.co/u/linkerc)\ **Replies:** 0\ **Last updated:** [November 17, 2022, 11:06pm UTC](https://discuss.elastic.co/t/has-anybody-run-es-cluster-on-aws-using-either-is4gen-or-im4gn-vs-say-i4i/319249 "2022-11-17T23:06:55Z")
I'm curious if there's any performance difference. Since these are all storage optimized instance. I'm mainly curious about ARM vs Intel performance delta. We are mostly write heavy. Something like 80+% write vs read… --- ## [The client is unable to verify that the server is Elasticsearch due security privileges on the server side](https://discuss.elastic.co/t/the-client-is-unable-to-verify-that-the-server-is-elasticsearch-due-security-privileges-on-the-server-side/319015)
**Author:** [@Vasuji](https://discuss.elastic.co/u/Vasuji)\ **Replies:** 4\ **Last updated:** [November 17, 2022, 8:23pm UTC](https://discuss.elastic.co/t/the-client-is-unable-to-verify-that-the-server-is-elasticsearch-due-security-privileges-on-the-server-side/319015 "2022-11-17T20:23:05Z")
Why am I getting this error in my Mac with Elasticsearch 8.5.1 running in Docker and Jupyter notebook is supposed to communicate with Elasticsearch through port 9200? The client is unable to verify that the server is El… --- ## [Impossible query response?](https://discuss.elastic.co/t/impossible-query-response/319236)
**Author:** [@iamthealex1](https://discuss.elastic.co/u/iamthealex1)\ **Replies:** 3\ **Last updated:** [November 17, 2022, 7:50pm UTC](https://discuss.elastic.co/t/impossible-query-response/319236 "2022-11-17T19:50:35Z")
POST /metricbeat-2022.11.17/\_search { "size": 2, "\_source": \["system.process.cpu.total.pct"\], "query": { "bool": { "must": \[ {"match": { "event.dataset": "system.process" }}, {"range": {… --- ## [Create some tasks that may never finish](https://discuss.elastic.co/t/create-some-tasks-that-may-never-finish/318990)
**Author:** [@Sunt-ing](https://discuss.elastic.co/u/Sunt-ing)\ **Replies:** 6\ **Last updated:** [November 17, 2022, 6:50pm UTC](https://discuss.elastic.co/t/create-some-tasks-that-may-never-finish/318990 "2022-11-17T18:50:34Z")
In order to create a testbed for anomaly detection, I need to create some tasks that may never finish (unless you manually kill them) in ES. Is there any way to do that? I do find some problems with storage hardware may … --- ## [Python api client connection with proxy](https://discuss.elastic.co/t/python-api-client-connection-with-proxy/319232)
**Author:** [@lucas.queiroz](https://discuss.elastic.co/u/lucas.queiroz)\ **Replies:** 1\ **Last updated:** [November 17, 2022, 5:46pm UTC](https://discuss.elastic.co/t/python-api-client-connection-with-proxy/319232 "2022-11-17T17:46:17Z")
Hi use the following class to connect the client to Elastic Cloud running in Azure. The job runs in kubernetes updating my index with some data in a daily basis, and I need to setup the proxy from my organization in orde… --- ## [How can I sort strings with numbers alphabetically?](https://discuss.elastic.co/t/how-can-i-sort-strings-with-numbers-alphabetically/319088)
**Author:** [@Michal\_Stefaniuk](https://discuss.elastic.co/u/Michal_Stefaniuk)\ **Replies:** 9\ **Last updated:** [November 17, 2022, 5:11pm UTC](https://discuss.elastic.co/t/how-can-i-sort-strings-with-numbers-alphabetically/319088 "2022-11-17T17:11:04Z")
Hey guys, one quick question. I have a set of example records: Test 123 sesi 501 Alva rout and I want those to be sorted in asc/desc order in case insensitive and alphabeticall order, just like this: 501 Alva rout 12… --- ## [Elasticsearch isn't allowed to allocate this shard to any of the nodes in the cluster](https://discuss.elastic.co/t/elasticsearch-isnt-allowed-to-allocate-this-shard-to-any-of-the-nodes-in-the-cluster/319085)
**Author:** [@sunil\_s](https://discuss.elastic.co/u/sunil_s)\ **Replies:** 11\ **Last updated:** [November 17, 2022, 3:14pm UTC](https://discuss.elastic.co/t/elasticsearch-isnt-allowed-to-allocate-this-shard-to-any-of-the-nodes-in-the-cluster/319085 "2022-11-17T15:14:58Z")
Shards are unassigned s&pretty" { "persistent" : { "cluster.routing.allocation.enable" : "all", "indices.recovery.max\_bytes\_per\_sec" : "50mb" }, "transient" : { "cluster.routing.allocation.enable" : "… --- ## [Winlogbeat not sending logs after xpack.security was enabled](https://discuss.elastic.co/t/winlogbeat-not-sending-logs-after-xpack-security-was-enabled/319213)
**Author:** [@Tucker\_Green](https://discuss.elastic.co/u/Tucker_Green)\ **Replies:** 0\ **Last updated:** [November 17, 2022, 2:48pm UTC](https://discuss.elastic.co/t/winlogbeat-not-sending-logs-after-xpack-security-was-enabled/319213 "2022-11-17T14:48:06Z")
Hey guys! I had the stack running, winlogbeats were sending logs to elastic and I could view them in kibana. I then enabled security so we could have accounts and logins for different users, and it broke everything. I … --- ## [Does Elasticsearch Java API Client \[7.17\] support elasticsearch version 7.10?](https://discuss.elastic.co/t/does-elasticsearch-java-api-client-7-17-support-elasticsearch-version-7-10/319203)
**Author:** [@Aniruddh\_Dandotiya](https://discuss.elastic.co/u/Aniruddh_Dandotiya)\ **Replies:** 2\ **Last updated:** [November 17, 2022, 2:27pm UTC](https://discuss.elastic.co/t/does-elasticsearch-java-api-client-7-17-support-elasticsearch-version-7-10/319203 "2022-11-17T14:27:32Z")
I am using elasticsearch version 7.10 and trying to migrate from JestClient to Elasticsearch Java API Client \[7.17\]. Does Does Elasticsearch Java API Client \[7.17\] support previous versions of Elasticsearch? --- ## [Elasticsearch readiness probe failing on enabling xpack](https://discuss.elastic.co/t/elasticsearch-readiness-probe-failing-on-enabling-xpack/319198)
**Author:** [@yasin\_mohammed](https://discuss.elastic.co/u/yasin_mohammed)\ **Replies:** 0\ **Last updated:** [November 17, 2022, 1:33pm UTC](https://discuss.elastic.co/t/elasticsearch-readiness-probe-failing-on-enabling-xpack/319198 "2022-11-17T13:33:24Z")
We have Elastic search 7.17.6 basic version running on our Azure kubernetes cluster. The stack comes up when xpack is disabled. Once we enable xpack the readiness probe fails and there are no error messages in the logs t… --- ## [Query\_string search is not working correctly when field value contains dots](https://discuss.elastic.co/t/query-string-search-is-not-working-correctly-when-field-value-contains-dots/318860)
**Author:** [@DarwinGoyal](https://discuss.elastic.co/u/DarwinGoyal)\ **Replies:** 8\ **Last updated:** [November 17, 2022, 1:07pm UTC](https://discuss.elastic.co/t/query-string-search-is-not-working-correctly-when-field-value-contains-dots/318860 "2022-11-17T13:07:16Z")
Hi. An index contains a text property named description. Value of the description is "2:1.9.4" When I try to search using below query GET finding-index/\_search { "query": { "bool" : { "must" : \[ { … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=340) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=342)