# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=447 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 448 --- ## [Is there any tool which will create dummy document based on index mapping for testing?](https://discuss.elastic.co/t/is-there-any-tool-which-will-create-dummy-document-based-on-index-mapping-for-testing/279935)
**Author:** [@Nishikant\_Tayade](https://discuss.elastic.co/u/Nishikant_Tayade)\ **Replies:** 1\ **Last updated:** [May 3, 2022, 4:30pm UTC](https://discuss.elastic.co/t/is-there-any-tool-which-will-create-dummy-document-based-on-index-mapping-for-testing/279935 "2022-05-03T16:30:12Z")
I have created a wrapper around ES index bulk document API, I need to test the performance of it. I want to create at least, 1000 documents based on my index mapping, so that I can test the performance of my API. Is th… --- ## [How to download and install trial license of elasticsearch](https://discuss.elastic.co/t/how-to-download-and-install-trial-license-of-elasticsearch/303761)
**Author:** [@bhguo](https://discuss.elastic.co/u/bhguo)\ **Replies:** 2\ **Last updated:** [May 3, 2022, 4:19pm UTC](https://discuss.elastic.co/t/how-to-download-and-install-trial-license-of-elasticsearch/303761 "2022-05-03T16:19:09Z")
Dear sirs, I want to enable my application to connect Elasticsearch with ODBC, the elastic official say that ODBC client requires a Trial or Platinum license installed, here is the information source Download ODBC Clien… --- ## [How to get rid of deleted documents and reclaim disk space?](https://discuss.elastic.co/t/how-to-get-rid-of-deleted-documents-and-reclaim-disk-space/303184)
**Author:** [@rgelb](https://discuss.elastic.co/u/rgelb)\ **Replies:** 14\ **Last updated:** [May 3, 2022, 4:09pm UTC](https://discuss.elastic.co/t/how-to-get-rid-of-deleted-documents-and-reclaim-disk-space/303184 "2022-05-03T16:09:19Z")
I have a bunch of indexes with a massive amount of deleted documents. I've tried running POST /\_forcemerge?only\_expunge\_deletes=true multiple times, but it doesn't seem to do anything. The command returns Gateway Ti… --- ## [Official Puppet Forge Module Deprecation](https://discuss.elastic.co/t/official-puppet-forge-module-deprecation/303752)
**Author:** [@Arthur7868](https://discuss.elastic.co/u/Arthur7868)\ **Replies:** 2\ **Last updated:** [May 3, 2022, 3:11pm UTC](https://discuss.elastic.co/t/official-puppet-forge-module-deprecation/303752 "2022-05-03T15:11:31Z")
I noticed that the Puppet Forge Elasticsearch installation module provided by Elastic has been deprecated at the end of March 2022 (elastic/elasticsearch · Module for managing and configuring Elasticsearch nodes · Puppet… --- ## [Sorting by Relevance Score and Sold Counts](https://discuss.elastic.co/t/sorting-by-relevance-score-and-sold-counts/303810)
**Author:** [@icgncl](https://discuss.elastic.co/u/icgncl)\ **Replies:** 3\ **Last updated:** [May 3, 2022, 2:56pm UTC](https://discuss.elastic.co/t/sorting-by-relevance-score-and-sold-counts/303810 "2022-05-03T14:56:58Z")
Hello everyone, I want to sort results according to sold counts. However, the criteria should also include relevance score. For example, assume that for a "X" product, sold count is 100 and relevance score 3; for a "Y" … --- ## [Failed to initialize a TrustManager for the system keystore (using elasticsearch-oss; i.e. no XPack)](https://discuss.elastic.co/t/failed-to-initialize-a-trustmanager-for-the-system-keystore-using-elasticsearch-oss-i-e-no-xpack/303778)
**Author:** [@Alex\_Nelson](https://discuss.elastic.co/u/Alex_Nelson)\ **Replies:** 4\ **Last updated:** [May 3, 2022, 1:44pm UTC](https://discuss.elastic.co/t/failed-to-initialize-a-trustmanager-for-the-system-keystore-using-elasticsearch-oss-i-e-no-xpack/303778 "2022-05-03T13:44:42Z")
I manage Elasticsearch on multiple instances. One of my instances is having problems bringing up Elasticsearch. I am unable to determine why this one instance is having problems. All of my instances should have the sa… --- ## [Logstash Parsing error](https://discuss.elastic.co/t/logstash-parsing-error/302618)
**Author:** [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\ **Replies:** 2\ **Last updated:** [May 3, 2022, 12:31pm UTC](https://discuss.elastic.co/t/logstash-parsing-error/302618 "2022-05-03T12:31:50Z")
Hi Im getting below error while indexing to Elasticsearch \[2022-04-15T17:10:23,235\]\[WARN \]\[logstash.outputs.Elasticsearch\]\[events\]\[e1ee9c29fd20ba0c5ba383dd438a2c18f56af21d370e65cce136d247cd14831b\] Could not index event… --- ## [How does ES stores the data?](https://discuss.elastic.co/t/how-does-es-stores-the-data/303806)
**Author:** [@McLaine](https://discuss.elastic.co/u/McLaine)\ **Replies:** 3\ **Last updated:** [May 3, 2022, 10:35am UTC](https://discuss.elastic.co/t/how-does-es-stores-the-data/303806 "2022-05-03T10:35:09Z")
Hello! how does ES store in a cluster with 5 nodes? All data on 5 nodes or how is that distributed? --- ## [How to prooceed with a data node with corrupt disk file system](https://discuss.elastic.co/t/how-to-prooceed-with-a-data-node-with-corrupt-disk-file-system/303503)
**Author:** [@elaskibuser](https://discuss.elastic.co/u/elaskibuser)\ **Replies:** 3\ **Last updated:** [May 3, 2022, 10:32am UTC](https://discuss.elastic.co/t/how-to-prooceed-with-a-data-node-with-corrupt-disk-file-system/303503 "2022-05-03T10:32:50Z")
I would really appreciate help on the correct course of action. The setup is 3 ELK nodes which have all roles. No shard replication is done. Node 2 experienced a failure on the disk which contains the data folder. An o… --- ## [How to monitor indices (doc count, size...)](https://discuss.elastic.co/t/how-to-monitor-indices-doc-count-size/303713)
**Author:** [@ixperdomo](https://discuss.elastic.co/u/ixperdomo)\ **Replies:** 7\ **Last updated:** [May 3, 2022, 9:10am UTC](https://discuss.elastic.co/t/how-to-monitor-indices-doc-count-size/303713 "2022-05-03T09:10:17Z")
I'm trying to design a monitoring "architecture" (i.e. workaround) to monitor ES indices. The information of the indices themselves is being ingested by using a data stream, and here it comes why I want to monitor those … --- ## [Must\_not nested with should query not working (ES version 7.10.2) -- not countryiso OR not branch\_id](https://discuss.elastic.co/t/must-not-nested-with-should-query-not-working-es-version-7-10-2-not-countryiso-or-not-branch-id/303737)
**Author:** [@Udayaprakash\_S\_10d](https://discuss.elastic.co/u/Udayaprakash_S_10d)\ **Replies:** 13\ **Last updated:** [May 3, 2022, 8:59am UTC](https://discuss.elastic.co/t/must-not-nested-with-should-query-not-working-es-version-7-10-2-not-countryiso-or-not-branch-id/303737 "2022-05-03T08:59:54Z")
{ "size": 0, "query": { "bool": { "filter": \[ { "term": { "is\_reachable": { "value": "YES", "boost": 1 } } }, … --- ## [Optimization on search query when using alias name](https://discuss.elastic.co/t/optimization-on-search-query-when-using-alias-name/303808)
**Author:** [@shiranOren](https://discuss.elastic.co/u/shiranOren)\ **Replies:** 0\ **Last updated:** [May 3, 2022, 8:58am UTC](https://discuss.elastic.co/t/optimization-on-search-query-when-using-alias-name/303808 "2022-05-03T08:58:32Z")
Hello, I am using an alias name when writing data using Bulk Api. I have 2 questions: Can I get the index name after writing data using the alias name maybe as part of the response? Can I improve performance if I se… --- ## [Help on using suggestions on java client 8.1.3 search](https://discuss.elastic.co/t/help-on-using-suggestions-on-java-client-8-1-3-search/303744)
**Author:** [@mcremolini](https://discuss.elastic.co/u/mcremolini)\ **Replies:** 2\ **Last updated:** [May 3, 2022, 8:30am UTC](https://discuss.elastic.co/t/help-on-using-suggestions-on-java-client-8-1-3-search/303744 "2022-05-03T08:30:45Z")
Hello, I am trying to search with suggestion using the Java Client. In my first approach I write the code: client.search(request -\> request. index(indexName). suggest(suggest -\> suggest.suggesters("suggest", value… --- ## [Get Field Mapping request failing with UnexpectedJsonEventException using the Java API Client](https://discuss.elastic.co/t/get-field-mapping-request-failing-with-unexpectedjsoneventexception-using-the-java-api-client/303746)
**Author:** [@sbrunot](https://discuss.elastic.co/u/sbrunot)\ **Replies:** 4\ **Last updated:** [May 3, 2022, 7:30am UTC](https://discuss.elastic.co/t/get-field-mapping-request-failing-with-unexpectedjsoneventexception-using-the-java-api-client/303746 "2022-05-03T07:30:23Z")
Hello, during the process of migrating our code base from the Java High Level REST Client to the Java API Client, we are hitting an issue when trying to retrieve fields mappings. When running the following code (with a… --- ## [Howto connect Kibana 8 with ES8?](https://discuss.elastic.co/t/howto-connect-kibana-8-with-es8/303717)
**Author:** [@McLaine](https://discuss.elastic.co/u/McLaine)\ **Replies:** 12\ **Last updated:** [May 3, 2022, 7:30am UTC](https://discuss.elastic.co/t/howto-connect-kibana-8-with-es8/303717 "2022-05-03T07:30:16Z")
Hello! Es is running with: 128 \[::ffff:127.0.0.1\]:9200 : users:(("java",pid=43127,fd=463)) LISTEN 0 128 \[::1\]:9200 \[::\]… --- ## [Trouble with searchable snapshot](https://discuss.elastic.co/t/trouble-with-searchable-snapshot/303708)
**Author:** [@Nazarenko](https://discuss.elastic.co/u/Nazarenko)\ **Replies:** 2\ **Last updated:** [May 3, 2022, 7:27am UTC](https://discuss.elastic.co/t/trouble-with-searchable-snapshot/303708 "2022-05-03T07:27:43Z")
Hi everyone, I have a self-deployed Elasticsearch cluster, and I have some troubles with a searchable snapshot. I successfully mounted NFS to data nodes, and configure Index Lifecycle Policies I manually attach this… --- ## [Function Score Functions with Nested Objects and Score Replace](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081)
**Author:** [@terzano](https://discuss.elastic.co/u/terzano)\ **Replies:** 6\ **Last updated:** [May 3, 2022, 5:31am UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081 "2022-05-03T05:31:01Z")
I have tried various approaches to combine function\_score with a nested field inside "functions" in order to override the relevance \_score. The "query" within the function\_score works perfectly, as intended. However, th… --- ## [Unexpected error handling request. java.lang.RuntimeException: Fielddata is disabled on text fields by default. Set fielddata=true on \[traceId\] in order to load fielddata in memory by uninverting the inverted index](https://discuss.elastic.co/t/unexpected-error-handling-request-java-lang-runtimeexception-fielddata-is-disabled-on-text-fields-by-default-set-fielddata-true-on-traceid-in-order-to-load-fielddata-in-memory-by-uninverting-the-inverted-index/303776)
**Author:** [@Akhil\_Manepalli](https://discuss.elastic.co/u/Akhil_Manepalli)\ **Replies:** 2\ **Last updated:** [May 3, 2022, 2:31am UTC](https://discuss.elastic.co/t/unexpected-error-handling-request-java-lang-runtimeexception-fielddata-is-disabled-on-text-fields-by-default-set-fielddata-true-on-traceid-in-order-to-load-fielddata-in-memory-by-uninverting-the-inverted-index/303776 "2022-05-03T02:31:27Z")
My elastic deployments consist of es-data, ingest & master. These are deployed as deployments in Kubernetes. I have Zipkin which uses elastic and Zipkin log shows the above error: : Unexpected error handling request. j… --- ## [Applying platinum license in deployment config](https://discuss.elastic.co/t/applying-platinum-license-in-deployment-config/303743)
**Author:** [@seb.sch](https://discuss.elastic.co/u/seb.sch)\ **Replies:** 1\ **Last updated:** [May 3, 2022, 12:33am UTC](https://discuss.elastic.co/t/applying-platinum-license-in-deployment-config/303743 "2022-05-03T00:33:46Z")
Hello, as of December 2020, it was not possible to apply the license in the deployment on a OpenShift/Kubernetes cluster (see: Applying platinum license in Kubernetes - Elastic Stack / Elasticsearch - Discuss the Elasti… --- ## [Node not discovering master node properly, "Cluster state has not been recovered yet, cannot write to the \[null\] index" error \[503\]](https://discuss.elastic.co/t/node-not-discovering-master-node-properly-cluster-state-has-not-been-recovered-yet-cannot-write-to-the-null-index-error-503/303692)
**Author:** [@dheist](https://discuss.elastic.co/u/dheist)\ **Replies:** 3\ **Last updated:** [May 3, 2022, 12:32am UTC](https://discuss.elastic.co/t/node-not-discovering-master-node-properly-cluster-state-has-not-been-recovered-yet-cannot-write-to-the-null-index-error-503/303692 "2022-05-03T00:32:29Z")
Hello, I have 2 servers in 2 different locations I am trying to make into a cluster. Both are running Elasticsearch v8.1.3. I have the master server, which is configured like this: cluster.name: yyz-news-prod node.name… --- ## [Using a colon in a field name does not work?](https://discuss.elastic.co/t/using-a-colon-in-a-field-name-does-not-work/303143)
**Author:** [@johann-petrak](https://discuss.elastic.co/u/johann-petrak)\ **Replies:** 2\ **Last updated:** [May 3, 2022, 12:25am UTC](https://discuss.elastic.co/t/using-a-colon-in-a-field-name-does-not-work/303143 "2022-05-03T00:25:25Z")
I have the following as part of my mapping file: "entities.name1:Name2": { "type": "nested" }, But the field does not actually end up nested in the index. Is there a problem with the use of colons as part… --- ## [Retrieving DataStream list in Elasticsearch using python API](https://discuss.elastic.co/t/retrieving-datastream-list-in-elasticsearch-using-python-api/303705)
**Author:** [@curious\_ands](https://discuss.elastic.co/u/curious_ands)\ **Replies:** 1\ **Last updated:** [May 2, 2022, 7:36pm UTC](https://discuss.elastic.co/t/retrieving-datastream-list-in-elasticsearch-using-python-api/303705 "2022-05-02T19:36:17Z")
In Kibana dev tools, When I am using the API call GET /\_data\_stream/ I am getting the list of DataStream. In similar way I want to retrieve it using the Elasticsearch Python API, I am not able to find the way. Can anyone… --- ## [Data node CPU constantly 90-98% on one node](https://discuss.elastic.co/t/data-node-cpu-constantly-90-98-on-one-node/302720)
**Author:** [@Damelon](https://discuss.elastic.co/u/Damelon)\ **Replies:** 5\ **Last updated:** [May 2, 2022, 5:46pm UTC](https://discuss.elastic.co/t/data-node-cpu-constantly-90-98-on-one-node/302720 "2022-05-02T17:46:22Z")
I currently have an Elasticsearch cluster (7.15.1) Which has 3 masters, 6 data nodes, 2 ingest nodes which is deployed onto Kubernetes in AWS. Each data node is using an m5.2xlarge AWS instance and a 1.5TB storage volu… --- ## [\[NEST\] Bulk Ingest Not Utilizing Max System Resources](https://discuss.elastic.co/t/nest-bulk-ingest-not-utilizing-max-system-resources/303638)
**Author:** [@cj\_hillbrand](https://discuss.elastic.co/u/cj_hillbrand)\ **Replies:** 3\ **Last updated:** [May 2, 2022, 5:50pm UTC](https://discuss.elastic.co/t/nest-bulk-ingest-not-utilizing-max-system-resources/303638 "2022-05-02T17:50:23Z")
Hello Elastic Community, We have multiple environments set up for our Elasticsearch system, and I am experiencing some odd behavior. In the dev environment, when we perform a bulk update, the CPU utilization reaches to… --- ## [Using elasticsearch with remote storage](https://discuss.elastic.co/t/using-elasticsearch-with-remote-storage/303631)
**Author:** [@James\_Hsia](https://discuss.elastic.co/u/James_Hsia)\ **Replies:** 2\ **Last updated:** [May 2, 2022, 3:21pm UTC](https://discuss.elastic.co/t/using-elasticsearch-with-remote-storage/303631 "2022-05-02T15:21:13Z")
We have an AKS cluster in the US running an Elasticsearch pod (version 7.16.0) tied to an Azure File Share storage account in Europe. We are getting continuous issues in the Elasticsearch logs similar to the below upon … --- ## [I am trying to convert unix timestamp(string) coming from my dynamo db by using lambda function to date format to visualize in kibana](https://discuss.elastic.co/t/i-am-trying-to-convert-unix-timestamp-string-coming-from-my-dynamo-db-by-using-lambda-function-to-date-format-to-visualize-in-kibana/303622)
**Author:** [@Kedhar1006](https://discuss.elastic.co/u/Kedhar1006)\ **Replies:** 3\ **Last updated:** [May 2, 2022, 2:35pm UTC](https://discuss.elastic.co/t/i-am-trying-to-convert-unix-timestamp-string-coming-from-my-dynamo-db-by-using-lambda-function-to-date-format-to-visualize-in-kibana/303622 "2022-05-02T14:35:44Z")
'use strict'; var moment = require('moment'); //var Elasticsearch = require('Elasticsearch'); //var client = new Elasticsearch.Clinet({ // host: 'https://.us-east-2.es.amazonaws.com', // log: 'error' //}); const… --- ## [Error changing certificate in Elasticsearch](https://discuss.elastic.co/t/error-changing-certificate-in-elasticsearch/303675)
**Author:** [@jorge.visentini](https://discuss.elastic.co/u/jorge.visentini)\ **Replies:** 3\ **Last updated:** [May 2, 2022, 2:29pm UTC](https://discuss.elastic.co/t/error-changing-certificate-in-elasticsearch/303675 "2022-05-02T14:29:11Z")
I'm trying to change Elasticsearch SSL certificates but I'm getting some errors and it's not starting. I would like to change the CA and certificate to one generated by me, which I use for testing, to learn how to chang… --- ## [Redis Cache keyspace miss issue](https://discuss.elastic.co/t/redis-cache-keyspace-miss-issue/303584)
**Author:** [@nyquillus](https://discuss.elastic.co/u/nyquillus)\ **Replies:** 0\ **Last updated:** [April 29, 2022, 8:25am UTC](https://discuss.elastic.co/t/redis-cache-keyspace-miss-issue/303584 "2022-04-29T08:25:59Z")
Hi everyone, We're using an ELK stack with redis buffer on kubernetes. Lately there has been an increase in traffic and we've noticed that some logs are not registered to Elasticsearch. Redis-cli shows steadily increasi… --- ## [Derive index with reversed nesting](https://discuss.elastic.co/t/derive-index-with-reversed-nesting/303393)
**Author:** [@denbo](https://discuss.elastic.co/u/denbo)\ **Replies:** 5\ **Last updated:** [May 2, 2022, 12:24pm UTC](https://discuss.elastic.co/t/derive-index-with-reversed-nesting/303393 "2022-05-02T12:24:01Z")
I have an index of products with a (denormalized) m:n relationship to categories. My goal is to derive a categories index from it which contains the same information, but with the relationship reversed. What I have # … --- ## [Is it possible to calculate the number of results by grouping them by several criteria?](https://discuss.elastic.co/t/is-it-possible-to-calculate-the-number-of-results-by-grouping-them-by-several-criteria/303497)
**Author:** [@Denys\_Lukash](https://discuss.elastic.co/u/Denys_Lukash)\ **Replies:** 2\ **Last updated:** [May 2, 2022, 11:53am UTC](https://discuss.elastic.co/t/is-it-possible-to-calculate-the-number-of-results-by-grouping-them-by-several-criteria/303497 "2022-05-02T11:53:24Z")
Hi dear community. I'm a new user of elastic and I'm having trouble building a query, I don't know if it's possible to do what I want. My task is to get the number of products in each category. The problem is that the g… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=446) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=448)