# Elasticsearch

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

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

**Page:** 874

---

## [I upgraded elasticsearch to 7.8.0 version but I got "java.lang.NoClassDefFoundError: Could not initialize class org.elasticsearch.http.netty4.Netty4HttpServerTransport" error](https://discuss.elastic.co/t/i-upgraded-elasticsearch-to-7-8-0-version-but-i-got-java-lang-noclassdeffounderror-could-not-initialize-class-org-elasticsearch-http-netty4-netty4httpservertransport-error/239621)

<div class="topic-metadata">

**Author:** [@aysnur](https://discuss.elastic.co/u/aysnur)\
**Replies:** 5\
**Last updated:** [July 2, 2020, 4:13pm UTC](https://discuss.elastic.co/t/i-upgraded-elasticsearch-to-7-8-0-version-but-i-got-java-lang-noclassdeffounderror-could-not-initialize-class-org-elasticsearch-http-netty4-netty4httpservertransport-error/239621 "2020-07-02T16:13:12Z")

</div>

I upgraded elasticsearch to 7.8.0 version my dependencies like \` \<dependency\> \<groupId\>org.elasticsearch\</groupId\> \<artifactId\>elasticsearch\</artifactId\> \<version\>7.8.0\</version\> …

---

## [Highlighting with edge ngram token + synonym filter](https://discuss.elastic.co/t/highlighting-with-edge-ngram-token-synonym-filter/239600)

<div class="topic-metadata">

**Author:** [@b\_b\_inc](https://discuss.elastic.co/u/b_b_inc)\
**Replies:** 0\
**Last updated:** [July 2, 2020, 9:36am UTC](https://discuss.elastic.co/t/highlighting-with-edge-ngram-token-synonym-filter/239600 "2020-07-02T09:36:16Z")

</div>

Hi, For my use case I need to use both an edge-ngram token filter and a synonym filter, and then highlight the appropriate token in the result using highlight. Considering I've to use both edge-ngram and synonym, I've …

---

## [Help to increase number of shards on active index running close to 2B records](https://discuss.elastic.co/t/help-to-increase-number-of-shards-on-active-index-running-close-to-2b-records/239560)

<div class="topic-metadata">

**Author:** [@saiguru](https://discuss.elastic.co/u/saiguru)\
**Replies:** 9\
**Last updated:** [July 2, 2020, 2:53pm UTC](https://discuss.elastic.co/t/help-to-increase-number-of-shards-on-active-index-running-close-to-2b-records/239560 "2020-07-02T14:53:54Z")

</div>

I have 3 master and 2 data node with each 1TB cluster. I build a production index and it is reaching limit of 2B, how to increase # of shards to 10 on running index. ip heap.percent ram.percent cpu load\_1m load…

---

## [What causes "no route host" error while trying to Reindex from a remote cluster?](https://discuss.elastic.co/t/what-causes-no-route-host-error-while-trying-to-reindex-from-a-remote-cluster/239652)

<div class="topic-metadata">

**Author:** [@Yotam\_Levy](https://discuss.elastic.co/u/Yotam_Levy)\
**Replies:** 0\
**Last updated:** [July 2, 2020, 2:15pm UTC](https://discuss.elastic.co/t/what-causes-no-route-host-error-while-trying-to-reindex-from-a-remote-cluster/239652 "2020-07-02T14:15:11Z")

</div>

I'm trying to do a \_reindex API request from cluster A to cluster B, and I noticed some times I an error response that says: "no route host". this gets solved by restarting my cluster's es client nodes, then re-doing t…

---

## [Retry interval on failed shard allocation attempts](https://discuss.elastic.co/t/retry-interval-on-failed-shard-allocation-attempts/239646)

<div class="topic-metadata">

**Author:** [@Barak](https://discuss.elastic.co/u/Barak)\
**Replies:** 1\
**Last updated:** [July 2, 2020, 2:14pm UTC](https://discuss.elastic.co/t/retry-interval-on-failed-shard-allocation-attempts/239646 "2020-07-02T14:14:06Z")

</div>

I couldn't find any information about it, is there (or will there be) an option to set the interval between each shard allocation retry attempt? I am asking because even though I raised the retry limit to 20 or 30 on s…

---

## [GROUP BY SQL returns no data](https://discuss.elastic.co/t/group-by-sql-returns-no-data/239347)

<div class="topic-metadata">

**Author:** [@dbuzz](https://discuss.elastic.co/u/dbuzz)\
**Replies:** 1\
**Last updated:** [July 2, 2020, 1:38pm UTC](https://discuss.elastic.co/t/group-by-sql-returns-no-data/239347 "2020-07-02T13:38:30Z")

</div>

Hey ALL, I am running simple SQL in the Kibana SQL workspace and getting no data back. Appreciate for any clues! select status, count(\*) as status\_cnt from my-index4 group by status Thanks, Dimon.

---

## [Java.lang.illegalstateexception: unexpected byte \[0x02\] elasticsearch](https://discuss.elastic.co/t/java-lang-illegalstateexception-unexpected-byte-0x02-elasticsearch/239571)

<div class="topic-metadata">

**Author:** [@vikrammazakindia](https://discuss.elastic.co/u/vikrammazakindia)\
**Replies:** 5\
**Last updated:** [July 2, 2020, 12:57pm UTC](https://discuss.elastic.co/t/java-lang-illegalstateexception-unexpected-byte-0x02-elasticsearch/239571 "2020-07-02T12:57:54Z")

</div>

I am facing above error in spring data elastic search . how to parse simple query string in query builder? my code is final QueryBuilder searchquery = QueryBuilders.boolQuery() .should(QueryBuilders.simpleQueryStringQ…

---

## [Data type - array, flattened or nested?](https://discuss.elastic.co/t/data-type-array-flattened-or-nested/239283)

<div class="topic-metadata">

**Author:** [@rd8388](https://discuss.elastic.co/u/rd8388)\
**Replies:** 0\
**Last updated:** [June 30, 2020, 11:31am UTC](https://discuss.elastic.co/t/data-type-array-flattened-or-nested/239283 "2020-06-30T11:31:15Z")

</div>

We are indexing records that may have one or more full names and one or more full addresses. We want to be able to search against those without getting cross matches so a simple JSON array or delimited concatenation wil…

---

## [Upgrading elasticsearch from 6.8 to 7.7.1](https://discuss.elastic.co/t/upgrading-elasticsearch-from-6-8-to-7-7-1/239620)

<div class="topic-metadata">

**Author:** [@zozo6015](https://discuss.elastic.co/u/zozo6015)\
**Replies:** 8\
**Last updated:** [July 2, 2020, 11:28am UTC](https://discuss.elastic.co/t/upgrading-elasticsearch-from-6-8-to-7-7-1/239620 "2020-07-02T11:28:42Z")

</div>

Hello, We are about to upgrade elasticserch from 6.8 to 7.7.1 is there anything special that needs to be done so that the indexes would be compatible? I know that beats has some option to migrate 6 to 7 and that is why …

---

## [Unable to Access Elasticsearch using http://localhost:9200. Also on the last install page I dont see "open elastic search in the browser"](https://discuss.elastic.co/t/unable-to-access-elasticsearch-using-http-localhost-9200-also-on-the-last-install-page-i-dont-see-open-elastic-search-in-the-browser/239538)

<div class="topic-metadata">

**Author:** [@pasta80](https://discuss.elastic.co/u/pasta80)\
**Replies:** 6\
**Last updated:** [July 2, 2020, 10:56am UTC](https://discuss.elastic.co/t/unable-to-access-elasticsearch-using-http-localhost-9200-also-on-the-last-install-page-i-dont-see-open-elastic-search-in-the-browser/239538 "2020-07-02T10:56:44Z")

</div>

Hi, As you can see in my title, i am unable to access elasticsearch after finishing the install using http://localhost:9200. it says this site cant be reached and local host refued to connect. I have already installed j…

---

## [Add data to elastic search and join records](https://discuss.elastic.co/t/add-data-to-elastic-search-and-join-records/239232)

<div class="topic-metadata">

**Author:** [@kate\_c](https://discuss.elastic.co/u/kate_c)\
**Replies:** 2\
**Last updated:** [July 2, 2020, 10:31am UTC](https://discuss.elastic.co/t/add-data-to-elastic-search-and-join-records/239232 "2020-07-02T10:31:16Z")

</div>

Hi, I have some questions I am new to elasticsearch. 1. I have a data file I would like to add it to elasticsearch how can I do it? Create a database first? The file is in csv. Do you have any guides for doing this or so…

---

## [Boost value on a boolean field](https://discuss.elastic.co/t/boost-value-on-a-boolean-field/238869)

<div class="topic-metadata">

**Author:** [@djean](https://discuss.elastic.co/u/djean)\
**Replies:** 3\
**Last updated:** [July 2, 2020, 10:17am UTC](https://discuss.elastic.co/t/boost-value-on-a-boolean-field/238869 "2020-07-02T10:17:05Z")

</div>

Hello, I have a field indexed as a boolean. I wonder if there is a way to boost the document when this value is true and not boost it when the value is false. I can't find a way to do it. Thanks.

---

## [QueryStringQuery for date range and integers](https://discuss.elastic.co/t/querystringquery-for-date-range-and-integers/239189)

<div class="topic-metadata">

**Author:** [@shahab78](https://discuss.elastic.co/u/shahab78)\
**Replies:** 3\
**Last updated:** [July 2, 2020, 9:37am UTC](https://discuss.elastic.co/t/querystringquery-for-date-range-and-integers/239189 "2020-07-02T09:37:23Z")

</div>

Hi, I have some Java code like this: SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder(); QueryBuilder stringQuery = QueryBuilders.queryStringQuery(query); searchSourceBuilder.query(stringQuery); I have…

---

## [Securing users on elasticsearch-oss](https://discuss.elastic.co/t/securing-users-on-elasticsearch-oss/239599)

<div class="topic-metadata">

**Author:** [@thegreatpeepee](https://discuss.elastic.co/u/thegreatpeepee)\
**Replies:** 2\
**Last updated:** [July 2, 2020, 9:26am UTC](https://discuss.elastic.co/t/securing-users-on-elasticsearch-oss/239599 "2020-07-02T09:26:38Z")

</div>

I've combed the docs, but I can't figure out how to secure the default elastic (or any other users) using the elasticsearch-oss install (I'm using 7.6.1) According to https://www.elastic.co/what-is/open-x-pack, x-pack i…

---

## [How to combine Terms and Match query](https://discuss.elastic.co/t/how-to-combine-terms-and-match-query/239591)

<div class="topic-metadata">

**Author:** [@defalt](https://discuss.elastic.co/u/defalt)\
**Replies:** 1\
**Last updated:** [July 2, 2020, 9:22am UTC](https://discuss.elastic.co/t/how-to-combine-terms-and-match-query/239591 "2020-07-02T09:22:53Z")

</div>

Hi, is there a way to combine a term and a match query? I have data with categorys A,B,C,D... which contains extra field which can vary. \_source: category: A value: 3 \_source: category: A value:2 \_source: category: A…

---

## [\[TOO\_MANY\_REQUESTS/12/index read-only / allow delete (api)\]](https://discuss.elastic.co/t/too-many-requests-12-index-read-only-allow-delete-api/236718)

<div class="topic-metadata">

**Author:** [@ewolfman](https://discuss.elastic.co/u/ewolfman)\
**Replies:** 4\
**Last updated:** [July 2, 2020, 9:00am UTC](https://discuss.elastic.co/t/too-many-requests-12-index-read-only-allow-delete-api/236718 "2020-07-02T09:00:57Z")

</div>

Hi, I too am receiving this error like others. I know that I can fix it via the \_settings endpoint: PUT /\_all/\_settings {"index.blocks.read\_only\_allow\_delete": false} But, I have not run out of diskspace. I have lots …

---

## [Performing sum after terms aggregation for 1.5m buckets](https://discuss.elastic.co/t/performing-sum-after-terms-aggregation-for-1-5m-buckets/239594)

<div class="topic-metadata">

**Author:** [@darshan\_ambre](https://discuss.elastic.co/u/darshan_ambre)\
**Replies:** 0\
**Last updated:** [July 2, 2020, 8:37am UTC](https://discuss.elastic.co/t/performing-sum-after-terms-aggregation-for-1-5m-buckets/239594 "2020-07-02T08:37:39Z")

</div>

Hello Team, I am performing a terms aggregation on two fields i.e EntityCode and ItemNumber as shown in the example below. And over that I'm calculating sum on few fields and then applying a formula to the sum fields us…

---

## [Incorrect number of shard, what is the possible reason?](https://discuss.elastic.co/t/incorrect-number-of-shard-what-is-the-possible-reason/239582)

<div class="topic-metadata">

**Author:** [@mmk1995](https://discuss.elastic.co/u/mmk1995)\
**Replies:** 6\
**Last updated:** [July 2, 2020, 8:36am UTC](https://discuss.elastic.co/t/incorrect-number-of-shard-what-is-the-possible-reason/239582 "2020-07-02T08:36:23Z")

</div>

Hello, The default number of shard is 5 in the yml setting. I also didn't specify any template for all logstash config. Most of the index are with correct number of shards, However, some index appears to be only 1 pri…

---

## [Disk full, cannot add more disk, snapshot needs space](https://discuss.elastic.co/t/disk-full-cannot-add-more-disk-snapshot-needs-space/239373)

<div class="topic-metadata">

**Author:** [@dhruv2204](https://discuss.elastic.co/u/dhruv2204)\
**Replies:** 7\
**Last updated:** [July 2, 2020, 8:27am UTC](https://discuss.elastic.co/t/disk-full-cannot-add-more-disk-snapshot-needs-space/239373 "2020-07-02T08:27:45Z")

</div>

Hi Team We have some 1.8TB data in a single index. The disk storage on this machine is 2TB and already reached 95%. We have increased the flood limit to 98%, but that will only allow for 3-4 days of data more. We cann…

---

## [Elastic Search 7.8 installation with XPACK](https://discuss.elastic.co/t/elastic-search-7-8-installation-with-xpack/239315)

<div class="topic-metadata">

**Author:** [@Harsha7071](https://discuss.elastic.co/u/Harsha7071)\
**Replies:** 4\
**Last updated:** [July 2, 2020, 6:53am UTC](https://discuss.elastic.co/t/elastic-search-7-8-installation-with-xpack/239315 "2020-07-02T06:53:34Z")

</div>

Hello Team, We had Elastic search version 7.6 installed on the server and was working well with the Wazuh perfectly and then we tried to install the XPACK and Kibana was not starting at all. ● elasticsearch.service - E…

---

## [Bulk Partial Update in elasticsearch with Python](https://discuss.elastic.co/t/bulk-partial-update-in-elasticsearch-with-python/239575)

<div class="topic-metadata">

**Author:** [@johnny1](https://discuss.elastic.co/u/johnny1)\
**Replies:** 1\
**Last updated:** [July 2, 2020, 6:33am UTC](https://discuss.elastic.co/t/bulk-partial-update-in-elasticsearch-with-python/239575 "2020-07-02T06:33:30Z")

</div>

I want to perform a bulk partial update in python for elasticsearch because I don't want to update the whole documents but only specific fields. Can you please give an example? Best thanks in advance.

---

## [java.lang.IllegalStateException: unexpected byte \[0x02\]](https://discuss.elastic.co/t/java-lang-illegalstateexception-unexpected-byte-0x02/239569)

<div class="topic-metadata">

**Author:** [@vikrammazakindia](https://discuss.elastic.co/u/vikrammazakindia)\
**Replies:** 1\
**Last updated:** [July 2, 2020, 6:25am UTC](https://discuss.elastic.co/t/java-lang-illegalstateexception-unexpected-byte-0x02/239569 "2020-07-02T06:25:36Z")

</div>

Hi, i am using query builder with simple query string to search data using elastic search template iam facing above error my code is final QueryBuilder searchquery = QueryBuilders.boolQuery() .should…

---

## [How to get and create users in elasticsearch with API by using python](https://discuss.elastic.co/t/how-to-get-and-create-users-in-elasticsearch-with-api-by-using-python/239565)

<div class="topic-metadata">

**Author:** [@Mahathir\_Mohammad](https://discuss.elastic.co/u/Mahathir_Mohammad)\
**Replies:** 2\
**Last updated:** [July 2, 2020, 5:51am UTC](https://discuss.elastic.co/t/how-to-get-and-create-users-in-elasticsearch-with-api-by-using-python/239565 "2020-07-02T05:51:33Z")

</div>

I want to get and create users in elasticsearch with python. I'm trying to use API. I'm following this documentation. I send a get request with Postman in this URL: http://localhost:9200/\_opendistro/\_security/api/intern…

---

## [Is it viable to create a ElasticSearch user for each customer? And indexes?](https://discuss.elastic.co/t/is-it-viable-to-create-a-elasticsearch-user-for-each-customer-and-indexes/239539)

<div class="topic-metadata">

**Author:** [@jodinathan](https://discuss.elastic.co/u/jodinathan)\
**Replies:** 3\
**Last updated:** [July 2, 2020, 5:03am UTC](https://discuss.elastic.co/t/is-it-viable-to-create-a-elasticsearch-user-for-each-customer-and-indexes/239539 "2020-07-02T05:03:49Z")

</div>

We are pondering in creating one user in elasticsearch & kibana for each of our customers through the api and also creating a unique index for them, ie: somedata12345, somedata54321, where the 12345 would be the user ID …

---

## [Hide space for user](https://discuss.elastic.co/t/hide-space-for-user/239327)

<div class="topic-metadata">

**Author:** [@igarci](https://discuss.elastic.co/u/igarci)\
**Replies:** 4\
**Last updated:** [July 2, 2020, 4:54am UTC](https://discuss.elastic.co/t/hide-space-for-user/239327 "2020-07-02T04:54:30Z")

</div>

Hello I have kibana 7.2 and basic license I am trying to hide or not allow any user to access some space, but there is no documentation to do it. I just want to create a user who can access to different workspaces wit…

---

## [Cannot see user "id" in slowlogs (X-Opaque-ID)](https://discuss.elastic.co/t/cannot-see-user-id-in-slowlogs-x-opaque-id/239555)

<div class="topic-metadata">

**Author:** [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Replies:** 0\
**Last updated:** [July 2, 2020, 12:15am UTC](https://discuss.elastic.co/t/cannot-see-user-id-in-slowlogs-x-opaque-id/239555 "2020-07-02T00:15:48Z")

</div>

Hello According to this post Identifying search slow log origin It is often useful to identify what triggered a slow running query. If a call was initiated with an X-Opaque-ID header, then the user ID is included i…

---

## [How can i pinned the documents in elastic search?](https://discuss.elastic.co/t/how-can-i-pinned-the-documents-in-elastic-search/239285)

<div class="topic-metadata">

**Author:** [@Sagar\_jain](https://discuss.elastic.co/u/Sagar_jain)\
**Replies:** 27\
**Last updated:** [July 1, 2020, 11:42pm UTC](https://discuss.elastic.co/t/how-can-i-pinned-the-documents-in-elastic-search/239285 "2020-07-01T23:42:08Z")

</div>

How can i pinned the documents in elastic search?

---

## [Aggregation to count parent documents by field in their children?](https://discuss.elastic.co/t/aggregation-to-count-parent-documents-by-field-in-their-children/239550)

<div class="topic-metadata">

**Author:** [@bobbyi](https://discuss.elastic.co/u/bobbyi)\
**Replies:** 0\
**Last updated:** [July 1, 2020, 11:03pm UTC](https://discuss.elastic.co/t/aggregation-to-count-parent-documents-by-field-in-their-children/239550 "2020-07-01T23:03:29Z")

</div>

I have an index that contains parent documents and child documents using the join datatype. I have a field on the child documents and for each unique value that appears in that field I would like to answer this question:…

---

## [Any plans to upgrade the Http Client to 5.x on the Java Rest Client?](https://discuss.elastic.co/t/any-plans-to-upgrade-the-http-client-to-5-x-on-the-java-rest-client/239540)

<div class="topic-metadata">

**Author:** [@Aquilino\_Viveiros](https://discuss.elastic.co/u/Aquilino_Viveiros)\
**Replies:** 0\
**Last updated:** [July 1, 2020, 7:41pm UTC](https://discuss.elastic.co/t/any-plans-to-upgrade-the-http-client-to-5-x-on-the-java-rest-client/239540 "2020-07-01T19:41:34Z")

</div>

The RestClient holds a reference to a CloseableHttpAsyncClient which under version 4.x does not support retry mechanism. Any plans to upgrade the rest client to use Http Client 5.x? The new version seems to support this. …

---

## [Custom Similarity Not Respected In Percolate Query](https://discuss.elastic.co/t/custom-similarity-not-respected-in-percolate-query/239541)

<div class="topic-metadata">

**Author:** [@vp\_tech](https://discuss.elastic.co/u/vp_tech)\
**Replies:** 0\
**Last updated:** [July 1, 2020, 8:06pm UTC](https://discuss.elastic.co/t/custom-similarity-not-respected-in-percolate-query/239541 "2020-07-01T20:06:07Z")

</div>

I have a percolation index with a custom similarity (to ignore idf) and a mapping to use this custom similarity: { "my-index": { "settings": { "index": { "similarity": { "idfless": { …

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

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