# Elasticsearch

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

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

**Page:** 971

---

## [Not able to set index.mapping.single\_type: true on an index](https://discuss.elastic.co/t/not-able-to-set-index-mapping-single-type-true-on-an-index/225967)

<div class="topic-metadata">

**Author:** [@nages](https://discuss.elastic.co/u/nages)\
**Replies:** 7\
**Last updated:** [April 1, 2020, 9:27am UTC](https://discuss.elastic.co/t/not-able-to-set-index-mapping-single-type-true-on-an-index/225967 "2020-04-01T09:27:18Z")

</div>

I had an index that had single type. Now, I am planning to enable "index.mapping.single\_type" and I triggered the following API to make it happen, got the following error. BTW, I closed the index before applying the ab…

---

## [When I tried to upsert using UpdateRequest object with type as "UPDATE", I met reject message](https://discuss.elastic.co/t/when-i-tried-to-upsert-using-updaterequest-object-with-type-as-update-i-met-reject-message/225826)

<div class="topic-metadata">

**Author:** [@Kooin-Shin](https://discuss.elastic.co/u/Kooin-Shin)\
**Replies:** 7\
**Last updated:** [April 1, 2020, 9:25am UTC](https://discuss.elastic.co/t/when-i-tried-to-upsert-using-updaterequest-object-with-type-as-update-i-met-reject-message/225826 "2020-04-01T09:25:39Z")

</div>

First of all, I did tried to upsert to Elastic Search with document. So I used org.elasticsearch.action.update.UpdateRequest object to upsert process. The code is blow. String type = map.remove("\<%=UPDATE%\>")+""; Strin…

---

## [Synonym token filter question](https://discuss.elastic.co/t/synonym-token-filter-question/225892)

<div class="topic-metadata">

**Author:** [@nages](https://discuss.elastic.co/u/nages)\
**Replies:** 2\
**Last updated:** [April 1, 2020, 9:03am UTC](https://discuss.elastic.co/t/synonym-token-filter-question/225892 "2020-04-01T09:03:43Z")

</div>

I created a test index with synonym token filter \> PUT /synonyms-index { "settings": { "analysis": { "filter": { "my\_synonym\_filter": { "type": "synonym", "synonyms": \[ "shares","equity","stock" \] } }, "ana…

---

## [Search using term on Next 7.6.1 not returning any result](https://discuss.elastic.co/t/search-using-term-on-next-7-6-1-not-returning-any-result/225687)

<div class="topic-metadata">

**Author:** [@Shahed\_Aziz](https://discuss.elastic.co/u/Shahed_Aziz)\
**Replies:** 5\
**Last updated:** [April 1, 2020, 8:58am UTC](https://discuss.elastic.co/t/search-using-term-on-next-7-6-1-not-returning-any-result/225687 "2020-04-01T08:58:18Z")

</div>

Hi, I inserted some data to an index. To search on that, when I use match all, I can see my data. var temp = \_elasticClient.SearchAsync\<MyDocument\>(s =\> s.MatchAll(), cancellationToken); But when I sea…

---

## [This writer hit an unrecoverable error; cannot merge](https://discuss.elastic.co/t/this-writer-hit-an-unrecoverable-error-cannot-merge/226009)

<div class="topic-metadata">

**Author:** [@tonysangyeop](https://discuss.elastic.co/u/tonysangyeop)\
**Replies:** 0\
**Last updated:** [April 1, 2020, 8:47am UTC](https://discuss.elastic.co/t/this-writer-hit-an-unrecoverable-error-cannot-merge/226009 "2020-04-01T08:47:07Z")

</div>

Elasticsearch version : 6.1.1 mapping =\> "\_routing" : { "required" : true } "join\_field" : { "type" : "join", "eager\_global\_ordinals": true, "relations": { "ques…

---

## [Why is docvalue\_fields much faster than source.includes?](https://discuss.elastic.co/t/why-is-docvalue-fields-much-faster-than-source-includes/225972)

<div class="topic-metadata">

**Author:** [@G-K-Patel](https://discuss.elastic.co/u/G-K-Patel)\
**Replies:** 2\
**Last updated:** [April 1, 2020, 8:44am UTC](https://discuss.elastic.co/t/why-is-docvalue-fields-much-faster-than-source-includes/225972 "2020-04-01T08:44:12Z")

</div>

Hi Elastic Community, I have seen drastic change in retrival speed when using docvalue\_fields instead of source.includes, as speficied in the documentation. Can someone explain to me what is the different between the t…

---

## [Parent-Child Relationship while upgrading ES 2.4 to 7.6](https://discuss.elastic.co/t/parent-child-relationship-while-upgrading-es-2-4-to-7-6/226008)

<div class="topic-metadata">

**Author:** [@Prasiddha](https://discuss.elastic.co/u/Prasiddha)\
**Replies:** 0\
**Last updated:** [April 1, 2020, 8:43am UTC](https://discuss.elastic.co/t/parent-child-relationship-while-upgrading-es-2-4-to-7-6/226008 "2020-04-01T08:43:51Z")

</div>

I am upgrading ES 2.4 to 7.6. Previously I had two different types in ES 2.4, say A and B. 'A' was parent and 'B' was child. Now, what would be the best way maintain this relationship in ES 7.6? Possibilities I came t…

---

## [Snapshot restore is very slow to get started](https://discuss.elastic.co/t/snapshot-restore-is-very-slow-to-get-started/225840)

<div class="topic-metadata">

**Author:** [@Guilherme\_Vieira](https://discuss.elastic.co/u/Guilherme_Vieira)\
**Replies:** 12\
**Last updated:** [April 1, 2020, 8:40am UTC](https://discuss.elastic.co/t/snapshot-restore-is-very-slow-to-get-started/225840 "2020-04-01T08:40:20Z")

</div>

I have been observing really slow start up times for restoring snapshots in elasticsearch. I am using graphana as a tool to monitor the cluster. As you can see the snapshot was started around 17:15 and only saw significa…

---

## [Why node uuid replace by {bootstrap-placeholder}-{NodeName}](https://discuss.elastic.co/t/why-node-uuid-replace-by-bootstrap-placeholder-nodename/225869)

<div class="topic-metadata">

**Author:** [@yc1024](https://discuss.elastic.co/u/yc1024)\
**Replies:** 5\
**Last updated:** [April 1, 2020, 7:58am UTC](https://discuss.elastic.co/t/why-node-uuid-replace-by-bootstrap-placeholder-nodename/225869 "2020-04-01T07:58:12Z")

</div>

ES version: 7.6.0 I have 3 master and 3 node in my cluster. This is the first time i start the cluster,i have configed discovery.seed\_hosts and cluster.initial\_master\_nodes as follow: discovery.seed\_hosts: ipOfMaster1…

---

## [New indices created via rollover don't automatically inherit the policy used by the old index](https://discuss.elastic.co/t/new-indices-created-via-rollover-dont-automatically-inherit-the-policy-used-by-the-old-index/225996)

<div class="topic-metadata">

**Author:** [@prs](https://discuss.elastic.co/u/prs)\
**Replies:** 0\
**Last updated:** [April 1, 2020, 7:40am UTC](https://discuss.elastic.co/t/new-indices-created-via-rollover-dont-automatically-inherit-the-policy-used-by-the-old-index/225996 "2020-04-01T07:40:55Z")

</div>

Hi friends, I use Es, Logstash and Kibana on a VM and I receive Logs from filebeat on a few VMs. ES, Logstash and kibana version 7.3.0 and filebeat in 2 version 7.5.2 and 7.6.1 . I use filebeat Modules like apache and…

---

## [Why Composite Aggregation In Java make getBuckets() not public while another agg type is public](https://discuss.elastic.co/t/why-composite-aggregation-in-java-make-getbuckets-not-public-while-another-agg-type-is-public/225997)

<div class="topic-metadata">

**Author:** [@Hi\_u\_Nguy\_n](https://discuss.elastic.co/u/Hi_u_Nguy_n)\
**Replies:** 0\
**Last updated:** [April 1, 2020, 7:41am UTC](https://discuss.elastic.co/t/why-composite-aggregation-in-java-make-getbuckets-not-public-while-another-agg-type-is-public/225997 "2020-04-01T07:41:31Z")

</div>

Why Composite Aggregation In Java make InternalBucket not public ? So, I can't get buckets for my purporse ?? The class InternalBucket inside InternalComposite class (Result Aggration of the CompositeAggragation query …

---

## [Question regarding "current" columns in cat nodes API](https://discuss.elastic.co/t/question-regarding-current-columns-in-cat-nodes-api/225959)

<div class="topic-metadata">

**Author:** [@surilshah](https://discuss.elastic.co/u/surilshah)\
**Replies:** 1\
**Last updated:** [April 1, 2020, 7:27am UTC](https://discuss.elastic.co/t/question-regarding-current-columns-in-cat-nodes-api/225959 "2020-04-01T07:27:03Z")

</div>

Are the values that we receive from current columns like indexing.index\_current and search.query\_current, giving instantaneous or per second values?

---

## [ESrally with dedicated master](https://discuss.elastic.co/t/esrally-with-dedicated-master/225961)

<div class="topic-metadata">

**Author:** [@kinlee](https://discuss.elastic.co/u/kinlee)\
**Replies:** 1\
**Last updated:** [April 1, 2020, 7:13am UTC](https://discuss.elastic.co/t/esrally-with-dedicated-master/225961 "2020-04-01T07:13:03Z")

</div>

I have a cluster with three nodes and three dedicated masters. I want to run esrally esrally --track=pmc --target-hosts=(node address 1):9200,(node address 2):9200,(node address3) --pipeline=benchmark-only --client opti…

---

## [Regarding Cluster State](https://discuss.elastic.co/t/regarding-cluster-state/225810)

<div class="topic-metadata">

**Author:** [@dawiro](https://discuss.elastic.co/u/dawiro)\
**Replies:** 4\
**Last updated:** [April 1, 2020, 6:54am UTC](https://discuss.elastic.co/t/regarding-cluster-state/225810 "2020-04-01T06:54:36Z")

</div>

Hi, Can I ask, is there a metric which tell me the size of the cluster state? And how long it takes to be updated? And if there isn't, how might I go about measuring that? Thx D

---

## [SQL Handle for Elastic Search](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226)

<div class="topic-metadata">

**Author:** [@Basil\_Paul](https://discuss.elastic.co/u/Basil_Paul)\
**Replies:** 8\
**Last updated:** [April 1, 2020, 6:39am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226 "2020-04-01T06:39:36Z")

</div>

Hello guys, Iam unable to query data residing in Elastic. I need to install SQL for querying the data residing in Elastic search. Please let me know whether it is possible to install SQL handle for Kibana or Elastic sea…

---

## [Elasticsearch support on Centos 8](https://discuss.elastic.co/t/elasticsearch-support-on-centos-8/223253)

<div class="topic-metadata">

**Author:** [@shivani\_aggarwal](https://discuss.elastic.co/u/shivani_aggarwal)\
**Replies:** 2\
**Last updated:** [April 1, 2020, 6:32am UTC](https://discuss.elastic.co/t/elasticsearch-support-on-centos-8/223253 "2020-04-01T06:32:02Z")

</div>

Hello, Does ELK stack support Centos 8.1? If yes, from which ELK version is this support available? I have checked the support matrix https://www.elastic.co/support/matrix but there is no mention of Centos 8. Regards, …

---

## [Apply Composite Aggregation on Filtered Data](https://discuss.elastic.co/t/apply-composite-aggregation-on-filtered-data/225790)

<div class="topic-metadata">

**Author:** [@Srinivas\_AR](https://discuss.elastic.co/u/Srinivas_AR)\
**Replies:** 1\
**Last updated:** [April 1, 2020, 6:01am UTC](https://discuss.elastic.co/t/apply-composite-aggregation-on-filtered-data/225790 "2020-04-01T06:01:10Z")

</div>

I'm using "Composite Aggregation" as my use case requires "Pagination" on buckets returned by Aggregation, as the number of returned buckets could be huge. I also need to run "Composite aggregation" on a specific time r…

---

## [Getting Alias definition for most recent index when index name is unknown](https://discuss.elastic.co/t/getting-alias-definition-for-most-recent-index-when-index-name-is-unknown/225968)

<div class="topic-metadata">

**Author:** [@lmit](https://discuss.elastic.co/u/lmit)\
**Replies:** 0\
**Last updated:** [April 1, 2020, 3:37am UTC](https://discuss.elastic.co/t/getting-alias-definition-for-most-recent-index-when-index-name-is-unknown/225968 "2020-04-01T03:37:25Z")

</div>

I am trying to write a single query to retrieve the most recent Alias definition , where I do NOT know the name of the most recent index ( because index names include a date stamp, e.g. canpi-v1-2020.03.02 ) The API doc…

---

## [Failed to create filtered alias with terms lookup](https://discuss.elastic.co/t/failed-to-create-filtered-alias-with-terms-lookup/225531)

<div class="topic-metadata">

**Author:** [@Junjun\_Zhang](https://discuss.elastic.co/u/Junjun_Zhang)\
**Replies:** 3\
**Last updated:** [April 1, 2020, 1:16am UTC](https://discuss.elastic.co/t/failed-to-create-filtered-alias-with-terms-lookup/225531 "2020-04-01T01:16:02Z")

</div>

Hello, I have run into exactly the same problem reported in this closed topic: https://discuss.elastic.co/t/terms-lookup-in-a-filtered-alias/206838. Since it's not been answered, I am posting it again. Much appreciated…

---

## [Best queue for devices that are mostly offline](https://discuss.elastic.co/t/best-queue-for-devices-that-are-mostly-offline/225835)

<div class="topic-metadata">

**Author:** [@dreamspy](https://discuss.elastic.co/u/dreamspy)\
**Replies:** 4\
**Last updated:** [March 31, 2020, 10:36pm UTC](https://discuss.elastic.co/t/best-queue-for-devices-that-are-mostly-offline/225835 "2020-03-31T22:36:45Z")

</div>

I'm wondering what would be the best queue option for computers that are mostly offline. Logstash, Redis, Kafka, RabbitMQ? I need to pump logs/metrics from those devices to the ES cloud. But the devices are online maybe…

---

## [Compound words handling](https://discuss.elastic.co/t/compound-words-handling/225453)

<div class="topic-metadata">

**Author:** [@chari](https://discuss.elastic.co/u/chari)\
**Replies:** 3\
**Last updated:** [March 31, 2020, 9:14pm UTC](https://discuss.elastic.co/t/compound-words-handling/225453 "2020-03-31T21:14:58Z")

</div>

How can I get ES to search for the words "data base" and "database" in the index when the query word is "database" or "data base"? another example : when the user queries the word "clean up" or "cleanup", ES should sear…

---

## [Need help with performance](https://discuss.elastic.co/t/need-help-with-performance/225910)

<div class="topic-metadata">

**Author:** [@Felipe](https://discuss.elastic.co/u/Felipe)\
**Replies:** 1\
**Last updated:** [March 31, 2020, 7:56pm UTC](https://discuss.elastic.co/t/need-help-with-performance/225910 "2020-03-31T19:56:53Z")

</div>

Hey guys, i have been trying to make some improvements on my elasticsearch to make my graylog answer quickly with searchs and queries, but i'm having troubles with my index and shards sizes. I saw the video and the old a…

---

## [Min\_gram option for search\_as\_you\_type](https://discuss.elastic.co/t/min-gram-option-for-search-as-you-type/225940)

<div class="topic-metadata">

**Author:** [@mgvarley](https://discuss.elastic.co/u/mgvarley)\
**Replies:** 0\
**Last updated:** [March 31, 2020, 7:18pm UTC](https://discuss.elastic.co/t/min-gram-option-for-search-as-you-type/225940 "2020-03-31T19:18:19Z")

</div>

I have been experimenting with the search\_as\_you\_type type which looks great however my use case is autocompleting addresses and I am getting suggestions when I type 1 for 10, 11, 12, 100, 101 etc which are not appropria…

---

## [Elasticsearch Query optimization](https://discuss.elastic.co/t/elasticsearch-query-optimization/222650)

<div class="topic-metadata">

**Author:** [@shikjind](https://discuss.elastic.co/u/shikjind)\
**Replies:** 12\
**Last updated:** [March 31, 2020, 7:07pm UTC](https://discuss.elastic.co/t/elasticsearch-query-optimization/222650 "2020-03-31T19:07:43Z")

</div>

We have the 780 GB of data at the elastic index, when triggering the below query :- { "query": { "function\_score": { "query": { "bool": { "must": \[ { "query\_string…

---

## [Authentication issue with S3 Repository in EKS](https://discuss.elastic.co/t/authentication-issue-with-s3-repository-in-eks/225412)

<div class="topic-metadata">

**Author:** [@asipe](https://discuss.elastic.co/u/asipe)\
**Replies:** 3\
**Last updated:** [March 31, 2020, 4:52pm UTC](https://discuss.elastic.co/t/authentication-issue-with-s3-repository-in-eks/225412 "2020-03-31T16:52:31Z")

</div>

I am having an issue attempting to setup a S3 snapshot repository for a cluster running in EKS. The serviceaccount is setup to use a role as detailed in https://docs.aws.amazon.com/eks/latest/userguide/iam-roles-for-ser…

---

## [How to retrieve index template version number](https://discuss.elastic.co/t/how-to-retrieve-index-template-version-number/225913)

<div class="topic-metadata">

**Author:** [@Cat](https://discuss.elastic.co/u/Cat)\
**Replies:** 0\
**Last updated:** [March 31, 2020, 4:25pm UTC](https://discuss.elastic.co/t/how-to-retrieve-index-template-version-number/225913 "2020-03-31T16:25:01Z")

</div>

I am new to elasticsearch. I am looking for example how to retrieve index template version using HLRest API. I saw some posts indicating that this is not possible. Do you have example of retrieving any fields using eithe…

---

## [Native approach to search similar documents using Minhash token filter](https://discuss.elastic.co/t/native-approach-to-search-similar-documents-using-minhash-token-filter/225909)

<div class="topic-metadata">

**Author:** [@Or\_Chen](https://discuss.elastic.co/u/Or_Chen)\
**Replies:** 0\
**Last updated:** [March 31, 2020, 4:16pm UTC](https://discuss.elastic.co/t/native-approach-to-search-similar-documents-using-minhash-token-filter/225909 "2020-03-31T16:16:26Z")

</div>

I want to implement Minhash-LSH completly on ElasticSearch. It is an algorithm for detecting near-duplicates. The process for each indexed document is as follows: Tokenize the text into shingles (Shingle Filter) Turn …

---

## [Is it possible to parametrize index in rally?](https://discuss.elastic.co/t/is-it-possible-to-parametrize-index-in-rally/225097)

<div class="topic-metadata">

**Author:** [@vrozov](https://discuss.elastic.co/u/vrozov)\
**Replies:** 4\
**Last updated:** [March 31, 2020, 3:52pm UTC](https://discuss.elastic.co/t/is-it-possible-to-parametrize-index-in-rally/225097 "2020-03-31T15:52:50Z")

</div>

Does Rally allow to parametrize index creation? I'd like to create a large number of indexes like index\_001 - index\_100 in a track.

---

## [Snapshot Repository - Cannot find files](https://discuss.elastic.co/t/snapshot-repository-cannot-find-files/225781)

<div class="topic-metadata">

**Author:** [@Artistan](https://discuss.elastic.co/u/Artistan)\
**Replies:** 2\
**Last updated:** [March 31, 2020, 2:50pm UTC](https://discuss.elastic.co/t/snapshot-repository-cannot-find-files/225781 "2020-03-31T14:50:43Z")

</div>

I have a snapshot repository setup and I can see the snapshot via the API but I cannot see the files. Here are the details... elastic.local?9200 { "name": "r7Zx\_d6", "cluster\_name": "homestead", "cluster\_uu…

---

## [Timestamp convert](https://discuss.elastic.co/t/timestamp-convert/225089)

<div class="topic-metadata">

**Author:** [@edkash](https://discuss.elastic.co/u/edkash)\
**Replies:** 4\
**Last updated:** [March 31, 2020, 2:22pm UTC](https://discuss.elastic.co/t/timestamp-convert/225089 "2020-03-31T14:22:05Z")

</div>

Hello dear, I want to understand, why kibana or elasticsearch is converting time. I attached an image with json inserted on elastic with a date (datetime correct), and datetime showed by kibaba -3). My time is GMT -3, …

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

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