# Elasticsearch

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

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

**Page:** 1242

---

## [Elasticsearch Certificate Requirements](https://discuss.elastic.co/t/elasticsearch-certificate-requirements/188143)

<div class="topic-metadata">

**Author:** [@wwalker](https://discuss.elastic.co/u/wwalker)\
**Replies:** 6\
**Last updated:** [July 3, 2019, 2:14pm UTC](https://discuss.elastic.co/t/elasticsearch-certificate-requirements/188143 "2019-07-03T14:14:12Z")

</div>

I'm trying to figure out what types of certificates Elasticsearch will work with. I'd like to minimize the number of certs and the process for maintaining those certs for the Elastic Stack. I see that pem and PKCS12 ar…

---

## [Dynamic\_templates](https://discuss.elastic.co/t/dynamic-templates/188687)

<div class="topic-metadata">

**Author:** [@wagoon](https://discuss.elastic.co/u/wagoon)\
**Replies:** 1\
**Last updated:** [July 3, 2019, 2:07pm UTC](https://discuss.elastic.co/t/dynamic-templates/188687 "2019-07-03T14:07:25Z")

</div>

I want to create dynamic\_template mapping for this document: { "COUNT:integer":1, "one":{ "COUNT:integer":1, "two":{ "COUNT:integer":1, "three":{ "COUNT:integer":1, } } } } My goal is to create som…

---

## [Java Client API to check the size of bulk queue](https://discuss.elastic.co/t/java-client-api-to-check-the-size-of-bulk-queue/188520)

<div class="topic-metadata">

**Author:** [@Prashant\_Rana](https://discuss.elastic.co/u/Prashant_Rana)\
**Replies:** 7\
**Last updated:** [July 3, 2019, 1:46pm UTC](https://discuss.elastic.co/t/java-client-api-to-check-the-size-of-bulk-queue/188520 "2019-07-03T13:46:25Z")

</div>

Hi, I am getting EsRejectedExecutionException after sending the logs to the bulkprocessor. I know the queue size defaults to 200. Is there any Java API with which I can check the current queue size and handle the addit…

---

## [How to capture slow running queries (SQL Query) using elastic search with .net web form applications?](https://discuss.elastic.co/t/how-to-capture-slow-running-queries-sql-query-using-elastic-search-with-net-web-form-applications/188722)

<div class="topic-metadata">

**Author:** [@Vignesh\_S2](https://discuss.elastic.co/u/Vignesh_S2)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 1:26pm UTC](https://discuss.elastic.co/t/how-to-capture-slow-running-queries-sql-query-using-elastic-search-with-net-web-form-applications/188722 "2019-07-03T13:26:18Z")

</div>

Can anyone provide sample example for .net web form application to capture slow running query

---

## [Any functional Tutorial about GetRequest and GetResponse Elasticsearch Version 6.3.1 ClientAPI Java](https://discuss.elastic.co/t/any-functional-tutorial-about-getrequest-and-getresponse-elasticsearch-version-6-3-1-clientapi-java/188055)

<div class="topic-metadata">

**Author:** [@samyo](https://discuss.elastic.co/u/samyo)\
**Replies:** 13\
**Last updated:** [July 3, 2019, 1:25pm UTC](https://discuss.elastic.co/t/any-functional-tutorial-about-getrequest-and-getresponse-elasticsearch-version-6-3-1-clientapi-java/188055 "2019-07-03T13:25:34Z")

</div>

Hello Folks, i am looking for a good Tutorial about GetRequest ,GetResponse and check Exists Field in JSON Data . I am using Elasticsearch 6.3.1 and Java 8.0 , i found this Page about Request and Response in Elasticse…

---

## [Continuously getting - java.lang.IllegalArgumentException: Limit of total fields \[1000\] in index has been exceeded error](https://discuss.elastic.co/t/continuously-getting-java-lang-illegalargumentexception-limit-of-total-fields-1000-in-index-has-been-exceeded-error/187982)

<div class="topic-metadata">

**Author:** [@Nishant\_Hurnekar](https://discuss.elastic.co/u/Nishant_Hurnekar)\
**Replies:** 9\
**Last updated:** [July 3, 2019, 1:23pm UTC](https://discuss.elastic.co/t/continuously-getting-java-lang-illegalargumentexception-limit-of-total-fields-1000-in-index-has-been-exceeded-error/187982 "2019-07-03T13:23:49Z")

</div>

I am running with ELK cluster 5.6.16. I am getting continuously below error into elasticsearch logs since quite some time for only one index. Is there any method reduce no of fields Or I will have to increase no of fie…

---

## [Upgrade to 7.2 causes shards failed due to painless script error](https://discuss.elastic.co/t/upgrade-to-7-2-causes-shards-failed-due-to-painless-script-error/188650)

<div class="topic-metadata">

**Author:** [@C\_J](https://discuss.elastic.co/u/C_J)\
**Replies:** 2\
**Last updated:** [July 3, 2019, 1:17pm UTC](https://discuss.elastic.co/t/upgrade-to-7-2-causes-shards-failed-due-to-painless-script-error/188650 "2019-07-03T13:17:40Z")

</div>

Could anyone with more knowledge of painless could help me with a problem I have right now: After upgrading Stack to 7.2, in one of the visualization that is using Scripted field, I get shards failed error, it used to …

---

## [Issue in solving nested aggregation](https://discuss.elastic.co/t/issue-in-solving-nested-aggregation/188713)

<div class="topic-metadata">

**Author:** [@elasticpatrick](https://discuss.elastic.co/u/elasticpatrick)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 12:54pm UTC](https://discuss.elastic.co/t/issue-in-solving-nested-aggregation/188713 "2019-07-03T12:54:17Z")

</div>

Hello, I have a "PRODUCT\_SUPPLIER" index in which I have a documents of products with its suppliers, having fields name "product\_name" and "product\_supplier". "mappings" : { "properties" : { "product\_name"…

---

## [Malformed \[mappings\] section for type \[dynamic\_templates\],](https://discuss.elastic.co/t/malformed-mappings-section-for-type-dynamic-templates/188428)

<div class="topic-metadata">

**Author:** [@iukea](https://discuss.elastic.co/u/iukea)\
**Replies:** 2\
**Last updated:** [July 3, 2019, 12:50pm UTC](https://discuss.elastic.co/t/malformed-mappings-section-for-type-dynamic-templates/188428 "2019-07-03T12:50:02Z")

</div>

Hello I am trying to add the following mapping to my index ELK 6.8.0 PUT \_template/logstash-\* { "template" : "logstash-\*", "version" : 60001, "settings" : { "index.refresh\_interval" : "5s", "index.number\_…

---

## [Can not disable \_all field](https://discuss.elastic.co/t/can-not-disable-all-field/188673)

<div class="topic-metadata">

**Author:** [@yeziblo](https://discuss.elastic.co/u/yeziblo)\
**Replies:** 3\
**Last updated:** [July 3, 2019, 11:25am UTC](https://discuss.elastic.co/t/can-not-disable-all-field/188673 "2019-07-03T11:25:40Z")

</div>

Hi, everyone I upgrade ES from 5.4.0 to 6.8.0. Now I want to disable \_all field in my index and I get a error: curl -XPUT 172.16.3.81:9200/human -d' { "mappings": { "human": { "\_all": { "enabled": false } } } …

---

## [Appending a table in Index](https://discuss.elastic.co/t/appending-a-table-in-index/188660)

<div class="topic-metadata">

**Author:** [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\
**Replies:** 3\
**Last updated:** [July 3, 2019, 10:26am UTC](https://discuss.elastic.co/t/appending-a-table-in-index/188660 "2019-07-03T10:26:43Z")

</div>

Hello, I want to add a data in the already created index. I dont want to reindex the I want to append a field and add data to the field. Any idea how toadd Regards

---

## [Reindex monitoring Node JS](https://discuss.elastic.co/t/reindex-monitoring-node-js/188679)

<div class="topic-metadata">

**Author:** [@Gregoire\_Rouet](https://discuss.elastic.co/u/Gregoire_Rouet)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 10:00am UTC](https://discuss.elastic.co/t/reindex-monitoring-node-js/188679 "2019-07-03T10:00:15Z")

</div>

Hello, I'm trying to develop a Kibana plugin. I want to reindex, which works fine. But I'd like to monitor the reindexing. I have found the query for it : GET \_tasks?detailed=true&actions=\*reindex But the task api se…

---

## [Getting version conflict even while updating sequentially using update\_by\_query](https://discuss.elastic.co/t/getting-version-conflict-even-while-updating-sequentially-using-update-by-query/188657)

<div class="topic-metadata">

**Author:** [@Prakash\_Sharma1](https://discuss.elastic.co/u/Prakash_Sharma1)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 9:00am UTC](https://discuss.elastic.co/t/getting-version-conflict-even-while-updating-sequentially-using-update-by-query/188657 "2019-07-03T09:00:51Z")

</div>

I am trying to update a document's nested type field using painless script by \_update\_by\_query. The script is executing sequentially that means the next \_update\_by\_query is run only when the previous one has successfully…

---

## [Query + Aggregations Driven From Query Response](https://discuss.elastic.co/t/query-aggregations-driven-from-query-response/188597)

<div class="topic-metadata">

**Author:** [@thegrif](https://discuss.elastic.co/u/thegrif)\
**Replies:** 2\
**Last updated:** [July 3, 2019, 9:06am UTC](https://discuss.elastic.co/t/query-aggregations-driven-from-query-response/188597 "2019-07-03T09:06:10Z")

</div>

I am hoping the community can point me in the right direction regarding options for performing what I'd describe as a multistep query. The first "step" of the query is a regular boolean search. Results come back somethi…

---

## [Refresh parameter in reindex api](https://discuss.elastic.co/t/refresh-parameter-in-reindex-api/188552)

<div class="topic-metadata">

**Author:** [@zatom](https://discuss.elastic.co/u/zatom)\
**Replies:** 1\
**Last updated:** [July 3, 2019, 8:41am UTC](https://discuss.elastic.co/t/refresh-parameter-in-reindex-api/188552 "2019-07-03T08:41:11Z")

</div>

Hi, I want to understand what 'refresh' parameter do in reindex api, how it helps while reindexing huge index. Can you please clarify using examples how it is different from the 'refresh' used in Bulk Indexing. Followi…

---

## [Error message when trying to simulate new Watch](https://discuss.elastic.co/t/error-message-when-trying-to-simulate-new-watch/188593)

<div class="topic-metadata">

**Author:** [@AMiura](https://discuss.elastic.co/u/AMiura)\
**Replies:** 1\
**Last updated:** [July 3, 2019, 8:32am UTC](https://discuss.elastic.co/t/error-message-when-trying-to-simulate-new-watch/188593 "2019-07-03T08:32:52Z")

</div>

I'm trying to write a Watch that sends an email alert if the hard drive on the system I have metricbeat installed on starts getting full. I'm new to writing Watches and am struggling to decipher the error messages. At be…

---

## [Yum install: unexpected nothing to do while upgrading elasticsearch](https://discuss.elastic.co/t/yum-install-unexpected-nothing-to-do-while-upgrading-elasticsearch/188646)

<div class="topic-metadata">

**Author:** [@grg121](https://discuss.elastic.co/u/grg121)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 8:19am UTC](https://discuss.elastic.co/t/yum-install-unexpected-nothing-to-do-while-upgrading-elasticsearch/188646 "2019-07-03T08:19:52Z")

</div>

I'm experimenting something estrange with yum in centos7, lets see If someone understands what's happening: Usually, I upgrade packages using sudo yum install \<package\_name\>-\<version\_info\>, for example, right now, I'm t…

---

## [Modify query to get 1 unique document per index?](https://discuss.elastic.co/t/modify-query-to-get-1-unique-document-per-index/188452)

<div class="topic-metadata">

**Author:** [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\
**Replies:** 2\
**Last updated:** [July 3, 2019, 7:47am UTC](https://discuss.elastic.co/t/modify-query-to-get-1-unique-document-per-index/188452 "2019-07-03T07:47:08Z")

</div>

Hi, I have the following query to pull some data from Elastic. The query works fine however I want to extend it a little bit by making sure I get the latest record per device per index. The current query will simply get…

---

## [The entries in elasticsearch-Keystore is causing the elastic cluster to go DOWN](https://discuss.elastic.co/t/the-entries-in-elasticsearch-keystore-is-causing-the-elastic-cluster-to-go-down/188386)

<div class="topic-metadata">

**Author:** [@Giridhar\_kailasam](https://discuss.elastic.co/u/Giridhar_kailasam)\
**Replies:** 4\
**Last updated:** [July 3, 2019, 7:40am UTC](https://discuss.elastic.co/t/the-entries-in-elasticsearch-keystore-is-causing-the-elastic-cluster-to-go-down/188386 "2019-07-03T07:40:33Z")

</div>

My undetstanding is, any missing entries (like passwords) in the yml will be retrieved from the keystore. Having an entry in the keystore should not cause the cluster failure. Eg: Having a "xpack.security.authc.realm…

---

## [Failed to get local cluster state Critical issue](https://discuss.elastic.co/t/failed-to-get-local-cluster-state-critical-issue/188205)

<div class="topic-metadata">

**Author:** [@jiouser](https://discuss.elastic.co/u/jiouser)\
**Replies:** 8\
**Last updated:** [July 3, 2019, 7:37am UTC](https://discuss.elastic.co/t/failed-to-get-local-cluster-state-critical-issue/188205 "2019-07-03T07:37:36Z")

</div>

I have 30+ client putting data in 60 data node ES cluster all running on physical machine. Around 15tb data get inserted daily in ES with retention of 2 days. Heavy indexing happens on 3 main indexes which are roll over …

---

## [NodeNotAvailable Exception leads to duplicate or Missing Data in BulkProcessor](https://discuss.elastic.co/t/nodenotavailable-exception-leads-to-duplicate-or-missing-data-in-bulkprocessor/188632)

<div class="topic-metadata">

**Author:** [@jiouser](https://discuss.elastic.co/u/jiouser)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 7:34am UTC](https://discuss.elastic.co/t/nodenotavailable-exception-leads-to-duplicate-or-missing-data-in-bulkprocessor/188632 "2019-07-03T07:34:21Z")

</div>

Hi, We are using BulkProcessor to insert huge amount of data in a big cluster comprising of 50+ data nodes. Our BulkProcessor setting is set to 4 Concurrent actions with our servers having 80 vcpus. What we observe is …

---

## [Elasticsearch spark connection for Structured Streaming](https://discuss.elastic.co/t/elasticsearch-spark-connection-for-structured-streaming/188225)

<div class="topic-metadata">

**Author:** [@Gokul\_Raj](https://discuss.elastic.co/u/Gokul_Raj)\
**Replies:** 1\
**Last updated:** [July 3, 2019, 7:22am UTC](https://discuss.elastic.co/t/elasticsearch-spark-connection-for-structured-streaming/188225 "2019-07-03T07:22:47Z")

</div>

I'm trying to make a connection to elasticsearch from my spark program. My elasticsearch host is https and found no connection property for that. We are using spark structred streaming Java API and the connection detai…

---

## [Significant Terms query with conditions in filter context](https://discuss.elastic.co/t/significant-terms-query-with-conditions-in-filter-context/188343)

<div class="topic-metadata">

**Author:** [@Yonatan\_Omer](https://discuss.elastic.co/u/Yonatan_Omer)\
**Replies:** 4\
**Last updated:** [July 3, 2019, 7:05am UTC](https://discuss.elastic.co/t/significant-terms-query-with-conditions-in-filter-context/188343 "2019-07-03T07:05:08Z")

</div>

Is it possible to use significant terms query to answer queries that require to apply conditions in the filter context? I'm trying to answer typical questions such as : "For people with event A find unusual event which…

---

## [Setting Up Users](https://discuss.elastic.co/t/setting-up-users/188277)

<div class="topic-metadata">

**Author:** [@Jeniffer](https://discuss.elastic.co/u/Jeniffer)\
**Replies:** 2\
**Last updated:** [July 2, 2019, 3:06am UTC](https://discuss.elastic.co/t/setting-up-users/188277 "2019-07-02T03:06:47Z")

</div>

Im trying to setup users in elasticsearch, I downloaded elasticsearch dpkg packege. I cant find the elastic setup-password. When I try to configure the elasticsearch in elasticsearch.yml i didnt see any xpack.security …

---

## [Remote Reindex not importing data](https://discuss.elastic.co/t/remote-reindex-not-importing-data/188619)

<div class="topic-metadata">

**Author:** [@NiteeshR](https://discuss.elastic.co/u/NiteeshR)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 6:31am UTC](https://discuss.elastic.co/t/remote-reindex-not-importing-data/188619 "2019-07-03T06:31:29Z")

</div>

Hi, I'm using below re-index query for copying data from remote ES host (For selected epoch date range). Query finished, but it is not displaying proper count in result. When I verified if the data is copied using quer…

---

## [Query time concatenation](https://discuss.elastic.co/t/query-time-concatenation/188590)

<div class="topic-metadata">

**Author:** [@chung](https://discuss.elastic.co/u/chung)\
**Replies:** 1\
**Last updated:** [July 3, 2019, 6:30am UTC](https://discuss.elastic.co/t/query-time-concatenation/188590 "2019-07-03T06:30:06Z")

</div>

Given a doc bowing is great and a query bow ing How can I make bow ing match with the indexed doc? This is what I am using at this moment and of course it is not working as expected. { "query": { "bool": { …

---

## [Out of memory after bulk rejection](https://discuss.elastic.co/t/out-of-memory-after-bulk-rejection/188618)

<div class="topic-metadata">

**Author:** [@Prashant\_Rana](https://discuss.elastic.co/u/Prashant_Rana)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 6:20am UTC](https://discuss.elastic.co/t/out-of-memory-after-bulk-rejection/188618 "2019-07-03T06:20:36Z")

</div>

I have a setup in which I am sending request to ES (5.6.4) using bulkProcessor. The problem is that the requests sent to es are more than it can process and the queue is getting full. The rejected requests are still in…

---

## [Auditbeat data minimize](https://discuss.elastic.co/t/auditbeat-data-minimize/188615)

<div class="topic-metadata">

**Author:** [@nandha\_88](https://discuss.elastic.co/u/nandha_88)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 6:14am UTC](https://discuss.elastic.co/t/auditbeat-data-minimize/188615 "2019-07-03T06:14:31Z")

</div>

Hi All, I have installed the auditbeat around 100 servers and everydata it creates around 30 GB of data which is forwarded to elasticsearch. I cant retain the data more than 10 days. Please share the possible ways to de…

---

## [Multi Master configuration](https://discuss.elastic.co/t/multi-master-configuration/188612)

<div class="topic-metadata">

**Author:** [@stalinbritto](https://discuss.elastic.co/u/stalinbritto)\
**Replies:** 1\
**Last updated:** [July 3, 2019, 6:06am UTC](https://discuss.elastic.co/t/multi-master-configuration/188612 "2019-07-03T06:06:27Z")

</div>

Hi Team, I'm currently trying to configure an elastic search cluster with 2 masters and 3 data nodes My cluster is working 1 Master and 3 data Node. root@ELK-Master1:~# curl http://IP:9200/\_cat/nodes?v ip …

---

## [Deprecation Log =\> Show Query](https://discuss.elastic.co/t/deprecation-log-show-query/188601)

<div class="topic-metadata">

**Author:** [@bastimm](https://discuss.elastic.co/u/bastimm)\
**Replies:** 0\
**Last updated:** [July 3, 2019, 3:57am UTC](https://discuss.elastic.co/t/deprecation-log-show-query/188601 "2019-07-03T03:57:53Z")

</div>

Hello, just updated my old ES Server from 5.6 to 6.8 and i want to go to 7.2. But I have some deprecated queries. "Found extra tokens after the \_search request body, an error will be thrown in the next major version" …

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

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