# Elasticsearch

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

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

**Page:** 834

---

## [Rollup Jobs Performance](https://discuss.elastic.co/t/rollup-jobs-performance/245228)

<div class="topic-metadata">

**Author:** [@michaelpietzsch](https://discuss.elastic.co/u/michaelpietzsch)\
**Replies:** 0\
**Last updated:** [August 17, 2020, 11:45am UTC](https://discuss.elastic.co/t/rollup-jobs-performance/245228 "2020-08-17T11:45:53Z")

</div>

Hi Gals and Guys, i am having issues with Rollup Jobs on my system. The Data Quantity is quite large (100861815 Documents streched over 50gb per index) I am trying to run a job to roll up the information of the passt d…

---

## [Count unique values from the filter query result, taking two fields into account](https://discuss.elastic.co/t/count-unique-values-from-the-filter-query-result-taking-two-fields-into-account/245220)

<div class="topic-metadata">

**Author:** [@Miguel\_BA](https://discuss.elastic.co/u/Miguel_BA)\
**Replies:** 0\
**Last updated:** [August 17, 2020, 10:32am UTC](https://discuss.elastic.co/t/count-unique-values-from-the-filter-query-result-taking-two-fields-into-account/245220 "2020-08-17T10:32:05Z")

</div>

I have a query that filters the "desc = mls or door = 33". Next I want a count value with a agregations the unique values in two fields. "query": { "nested": { "path": "data.addresses", "inner\_hits": { …

---

## [How to get aggregation bucket keys in the term query block](https://discuss.elastic.co/t/how-to-get-aggregation-bucket-keys-in-the-term-query-block/245214)

<div class="topic-metadata">

**Author:** [@Shrikanth\_M](https://discuss.elastic.co/u/Shrikanth_M)\
**Replies:** 0\
**Last updated:** [August 17, 2020, 10:14am UTC](https://discuss.elastic.co/t/how-to-get-aggregation-bucket-keys-in-the-term-query-block/245214 "2020-08-17T10:14:47Z")

</div>

How to get aggregation bucket keys in the term query block in the same query? Query { "size": 0, "query": {....}, "aggs": { "customerId": { "composite": { "sources": \[ { "customerId": {…

---

## [Internode communication in ES](https://discuss.elastic.co/t/internode-communication-in-es/245207)

<div class="topic-metadata">

**Author:** [@baidwan007](https://discuss.elastic.co/u/baidwan007)\
**Replies:** 1\
**Last updated:** [August 17, 2020, 10:05am UTC](https://discuss.elastic.co/t/internode-communication-in-es/245207 "2020-08-17T10:05:30Z")

</div>

Is there any type of authentication that is required for ES nodes to communicate with each other? So in the communication between master nodes and data nodes is there any auth happening without which they wont be able t…

---

## [Delete data in index without deleting the data](https://discuss.elastic.co/t/delete-data-in-index-without-deleting-the-data/245116)

<div class="topic-metadata">

**Author:** [@vikramaddagulla](https://discuss.elastic.co/u/vikramaddagulla)\
**Replies:** 2\
**Last updated:** [August 17, 2020, 9:20am UTC](https://discuss.elastic.co/t/delete-data-in-index-without-deleting-the-data/245116 "2020-08-17T09:20:09Z")

</div>

Hello, Could you please share me steps on how to delete the index data without deleting the index itself ?? If yes, then is it possible to delete the data based on timeline ? For ex : Currently I have data from the l…

---

## [Acces to elastic cloud for managing deployments with multiple accounts](https://discuss.elastic.co/t/acces-to-elastic-cloud-for-managing-deployments-with-multiple-accounts/245204)

<div class="topic-metadata">

**Author:** [@ErwinEnableU](https://discuss.elastic.co/u/ErwinEnableU)\
**Replies:** 4\
**Last updated:** [August 17, 2020, 9:20am UTC](https://discuss.elastic.co/t/acces-to-elastic-cloud-for-managing-deployments-with-multiple-accounts/245204 "2020-08-17T09:20:00Z")

</div>

Dear community, Right now we have 2 cloud environments at Elastic (T and P). To manage these deployments we can now only have one account to login and manage these deployments. Is it possible to create more accounts wit…

---

## [Kibana dashboard for ES cluster monitoring](https://discuss.elastic.co/t/kibana-dashboard-for-es-cluster-monitoring/245036)

<div class="topic-metadata">

**Author:** [@dominique.bejean](https://discuss.elastic.co/u/dominique.bejean)\
**Replies:** 8\
**Last updated:** [August 17, 2020, 8:13am UTC](https://discuss.elastic.co/t/kibana-dashboard-for-es-cluster-monitoring/245036 "2020-08-17T08:13:28Z")

</div>

Hi, I have 2 separate ES clusters. One is dedicated to monitoring. I followed these instructions https://www.elastic.co/guide/en/elasticsearch/reference/current/monitoring-production.html On the monitoring cluster I h…

---

## [Can not find geoshape in aggregation of Nest 6.8 to 7.8.1](https://discuss.elastic.co/t/can-not-find-geoshape-in-aggregation-of-nest-6-8-to-7-8-1/245011)

<div class="topic-metadata">

**Author:** [@Dat\_Le\_Tien](https://discuss.elastic.co/u/Dat_Le_Tien)\
**Replies:** 2\
**Last updated:** [August 17, 2020, 7:44am UTC](https://discuss.elastic.co/t/can-not-find-geoshape-in-aggregation-of-nest-6-8-to-7-8-1/245011 "2020-08-17T07:44:51Z")

</div>

Hello. Can anyone help me to anwser the question. My below script can work in knibana. But when I convert it to c# code by Nest. I can not find GeoShape in Aggregation container. It's only available in query. Is it possi…

---

## [Heap (Shard Amount and Close Index)](https://discuss.elastic.co/t/heap-shard-amount-and-close-index/245073)

<div class="topic-metadata">

**Author:** [@gogi](https://discuss.elastic.co/u/gogi)\
**Replies:** 3\
**Last updated:** [August 17, 2020, 7:37am UTC](https://discuss.elastic.co/t/heap-shard-amount-and-close-index/245073 "2020-08-17T07:37:29Z")

</div>

Hi all, i have a question regarding saving Heap Space for the ES Nodes. As far as i know there is a shard Limit per Node due to heap usage / management. https://www.elastic.co/guide/en/elasticsearch/reference/current/a…

---

## [Index Memory issue](https://discuss.elastic.co/t/index-memory-issue/244976)

<div class="topic-metadata">

**Author:** [@KrishK](https://discuss.elastic.co/u/KrishK)\
**Replies:** 3\
**Last updated:** [August 17, 2020, 5:13am UTC](https://discuss.elastic.co/t/index-memory-issue/244976 "2020-08-17T05:13:22Z")

</div>

Hi Support, I checked with one of the elastic testing servers, I found some index memory difference. SS from the testing server - Heap Size: 3GB\[HDD 2TB\] SS from PROD server – Heap Size:30GB \[2TB\] Is there any co…

---

## [Does Elasticsearch Data Node full of replicas routing request to other nodes?](https://discuss.elastic.co/t/does-elasticsearch-data-node-full-of-replicas-routing-request-to-other-nodes/244987)

<div class="topic-metadata">

**Author:** [@vorapoap](https://discuss.elastic.co/u/vorapoap)\
**Replies:** 7\
**Last updated:** [August 17, 2020, 5:08am UTC](https://discuss.elastic.co/t/does-elasticsearch-data-node-full-of-replicas-routing-request-to-other-nodes/244987 "2020-08-17T05:08:58Z")

</div>

If the cluster has 4 nodes and the index has 4 primary shards. Each shard has 3 replicas, it means each node contains all shard data. When search query is sent to a node,. does it route query to other nodes? or it depe…

---

## [Unable to store binary in Elasticsearch through python REST API](https://discuss.elastic.co/t/unable-to-store-binary-in-elasticsearch-through-python-rest-api/245160)

<div class="topic-metadata">

**Author:** [@Dibyendu\_Dutta](https://discuss.elastic.co/u/Dibyendu_Dutta)\
**Replies:** 1\
**Last updated:** [August 17, 2020, 4:26am UTC](https://discuss.elastic.co/t/unable-to-store-binary-in-elasticsearch-through-python-rest-api/245160 "2020-08-17T04:26:59Z")

</div>

I have created a index like \> PUT new\_index\_blob \> { \> "mappings": { \> "properties": { \> "name": { \> "type": "text" \> }, \> "blob": { \> "type": "binary", \> "store": true \> …

---

## [Elastic Search Killed on start up!](https://discuss.elastic.co/t/elastic-search-killed-on-start-up/245162)

<div class="topic-metadata">

**Author:** [@carterdacat](https://discuss.elastic.co/u/carterdacat)\
**Replies:** 23\
**Last updated:** [August 17, 2020, 2:53am UTC](https://discuss.elastic.co/t/elastic-search-killed-on-start-up/245162 "2020-08-17T02:53:47Z")

</div>

Hi! I just installed elastic on my pi running ubuntu 20.06, i got v5.6, and when ever i run ./bin/elasticsearch it just returns "killed" ubuntu@ubuntu:~/elasticsearch-5.6.16$ sudo ES\_JAVA\_OPTS="-Xms2g -Xmx2g" ./bin/elas…

---

## [Is it possible to combine results for .DateRange and .QueryString using NEST client?](https://discuss.elastic.co/t/is-it-possible-to-combine-results-for-daterange-and-querystring-using-nest-client/244474)

<div class="topic-metadata">

**Author:** [@mccamike](https://discuss.elastic.co/u/mccamike)\
**Replies:** 1\
**Last updated:** [August 17, 2020, 1:16am UTC](https://discuss.elastic.co/t/is-it-possible-to-combine-results-for-daterange-and-querystring-using-nest-client/244474 "2020-08-17T01:16:54Z")

</div>

I currently have a query where I'd like to combine the free text nature of .QueryString with the range operations of .DateRange in the same resultset. I was looking at how to combine queries and it looks like you can u…

---

## [Possible bug in elasticsearch nuget package](https://discuss.elastic.co/t/possible-bug-in-elasticsearch-nuget-package/244568)

<div class="topic-metadata">

**Author:** [@vohanka](https://discuss.elastic.co/u/vohanka)\
**Replies:** 1\
**Last updated:** [August 17, 2020, 1:01am UTC](https://discuss.elastic.co/t/possible-bug-in-elasticsearch-nuget-package/244568 "2020-08-17T01:01:14Z")

</div>

Hi, I found that elastic maybe have error in requirements of his nuget package. On nuget store is: Dependencies: .NET Framework, Version=v4.6.1 System.Diagnostics.DiagnosticSource (\>= 4.5.1). But if I try to run que…

---

## [How do I get elasticsearch endpoint for 3 coordinating node setup in Azure?](https://discuss.elastic.co/t/how-do-i-get-elasticsearch-endpoint-for-3-coordinating-node-setup-in-azure/244646)

<div class="topic-metadata">

**Author:** [@jpatel](https://discuss.elastic.co/u/jpatel)\
**Replies:** 2\
**Last updated:** [August 17, 2020, 12:58am UTC](https://discuss.elastic.co/t/how-do-i-get-elasticsearch-endpoint-for-3-coordinating-node-setup-in-azure/244646 "2020-08-17T00:58:16Z")

</div>

I have installed 3 nodes of elastic search from Azure marketplace and any node can act as master node. Now how do I connect to the cluster ?

---

## [Facets performance: want to know just if has at least one item](https://discuss.elastic.co/t/facets-performance-want-to-know-just-if-has-at-least-one-item/245170)

<div class="topic-metadata">

**Author:** [@cristianossd](https://discuss.elastic.co/u/cristianossd)\
**Replies:** 0\
**Last updated:** [August 16, 2020, 11:30pm UTC](https://discuss.elastic.co/t/facets-performance-want-to-know-just-if-has-at-least-one-item/245170 "2020-08-16T23:30:50Z")

</div>

Hi, everyone! Consider that I have million of documents with its categories A, B and C. I am searching to show the query results and requesting the facets (for a filter) to know if these categories have documents. But, …

---

## [Access sharepoint file as input in Elasticsearch](https://discuss.elastic.co/t/access-sharepoint-file-as-input-in-elasticsearch/244961)

<div class="topic-metadata">

**Author:** [@ranu\_shekhar](https://discuss.elastic.co/u/ranu_shekhar)\
**Replies:** 1\
**Last updated:** [August 16, 2020, 10:03pm UTC](https://discuss.elastic.co/t/access-sharepoint-file-as-input-in-elasticsearch/244961 "2020-08-16T22:03:21Z")

</div>

Hi, I have an excel file which is stored in sharepoint. I want to ingest that file directly in elasticsearch via logstash input filter.But I am not finding any plugin in logstash to ingest the data through logstash.

---

## [Using Stack Monitoring for monitor multiple cluster](https://discuss.elastic.co/t/using-stack-monitoring-for-monitor-multiple-cluster/244824)

<div class="topic-metadata">

**Author:** [@redondoxx](https://discuss.elastic.co/u/redondoxx)\
**Replies:** 2\
**Last updated:** [August 16, 2020, 9:49pm UTC](https://discuss.elastic.co/t/using-stack-monitoring-for-monitor-multiple-cluster/244824 "2020-08-16T21:49:22Z")

</div>

Hi, i have 1 centralize cluster (Monitor Cluster) to storage log and metrics from multiple cluster (Env Cluster). My Monitor Cluster deploy using ECK version 1.2. And my Env Cluster is using Elasticsearch Cloud Service…

---

## [How can i use ELK Stack with Infra as code?](https://discuss.elastic.co/t/how-can-i-use-elk-stack-with-infra-as-code/245126)

<div class="topic-metadata">

**Author:** [@jonhmb](https://discuss.elastic.co/u/jonhmb)\
**Replies:** 0\
**Last updated:** [August 16, 2020, 7:10am UTC](https://discuss.elastic.co/t/how-can-i-use-elk-stack-with-infra-as-code/245126 "2020-08-16T07:10:50Z")

</div>

Hi, can anyone help me with an idea? I need to use elk stack with infra as code to not lose my data when something happens with my server..... can anyone give a idea on how can i do it ?

---

## [How to degrade Elastic License from platinum to Basic](https://discuss.elastic.co/t/how-to-degrade-elastic-license-from-platinum-to-basic/245121)

<div class="topic-metadata">

**Author:** [@Sandeep\_Reddy\_Gutha](https://discuss.elastic.co/u/Sandeep_Reddy_Gutha)\
**Replies:** 1\
**Last updated:** [August 16, 2020, 9:27pm UTC](https://discuss.elastic.co/t/how-to-degrade-elastic-license-from-platinum-to-basic/245121 "2020-08-16T21:27:58Z")

</div>

Hi, I am currently using 6.8.11 version for both elastic and kibana. I am planning to degrade ElasticSearch license from Platinum to Basic. Could you please help us on this. Thanks in advance.

---

## [Max aggregation in transforms](https://discuss.elastic.co/t/max-aggregation-in-transforms/245159)

<div class="topic-metadata">

**Author:** [@anjilinga](https://discuss.elastic.co/u/anjilinga)\
**Replies:** 0\
**Last updated:** [August 16, 2020, 6:45pm UTC](https://discuss.elastic.co/t/max-aggregation-in-transforms/245159 "2020-08-16T18:45:39Z")

</div>

Hi, In transform, i have created one max field with the below script, but when the documents are not present it is returning as null value and getting fail. can you please suggest how to handle it. "MaxHandlingDuratio…

---

## [ctx.containksKey is not working in 7.6 version](https://discuss.elastic.co/t/ctx-containkskey-is-not-working-in-7-6-version/244846)

<div class="topic-metadata">

**Author:** [@anjilinga](https://discuss.elastic.co/u/anjilinga)\
**Replies:** 4\
**Last updated:** [August 16, 2020, 6:43pm UTC](https://discuss.elastic.co/t/ctx-containkskey-is-not-working-in-7-6-version/244846 "2020-08-16T18:43:09Z")

</div>

Hi I am using ctx.containsKey in ingestpipeline, it is not working in 7.6.2 vesrsion. but it is working in 7.8 version. can you please help here is it expected behaviour in 7.6 versions

---

## [CompositeAggregation pagination's consistent behavior during indexing being frequently update period](https://discuss.elastic.co/t/compositeaggregation-paginations-consistent-behavior-during-indexing-being-frequently-update-period/245155)

<div class="topic-metadata">

**Author:** [@slodevppw](https://discuss.elastic.co/u/slodevppw)\
**Replies:** 0\
**Last updated:** [August 16, 2020, 4:01pm UTC](https://discuss.elastic.co/t/compositeaggregation-paginations-consistent-behavior-during-indexing-being-frequently-update-period/245155 "2020-08-16T16:01:58Z")

</div>

We recently use ES CompositeAggregation to generate a report, which requires sorting and the result (can up-to 1M records sometime) is large which requires pagination. However, duplicated records have been identified (…

---

## [java.io.IOException: listener timeout after waiting for \[90000\] ms](https://discuss.elastic.co/t/java-io-ioexception-listener-timeout-after-waiting-for-90000-ms/245153)

<div class="topic-metadata">

**Author:** [@itaydvir](https://discuss.elastic.co/u/itaydvir)\
**Replies:** 0\
**Last updated:** [August 16, 2020, 3:50pm UTC](https://discuss.elastic.co/t/java-io-ioexception-listener-timeout-after-waiting-for-90000-ms/245153 "2020-08-16T15:50:20Z")

</div>

Hello, I've upgraded to version 6.8 and using java RestHighLevelClient. Cluster is behind SearchGuard plugin and usually everything is working well. Sometimes (I assume when there are some network issues) i'm getting …

---

## [Filter on distinct count on aggregation result](https://discuss.elastic.co/t/filter-on-distinct-count-on-aggregation-result/245144)

<div class="topic-metadata">

**Author:** [@Bharat\_Data](https://discuss.elastic.co/u/Bharat_Data)\
**Replies:** 0\
**Last updated:** [August 16, 2020, 1:16pm UTC](https://discuss.elastic.co/t/filter-on-distinct-count-on-aggregation-result/245144 "2020-08-16T13:16:20Z")

</div>

I have a use case in which I want to filter the results which have the more than one distinct value. For example :- Query - Returns all the distinct models under each different category { "aggs": { "distinct\_cat…

---

## [Autocomplete for terms aggregations](https://discuss.elastic.co/t/autocomplete-for-terms-aggregations/244914)

<div class="topic-metadata">

**Author:** [@Peter\_Steenbergen](https://discuss.elastic.co/u/Peter_Steenbergen)\
**Replies:** 4\
**Last updated:** [August 16, 2020, 10:02am UTC](https://discuss.elastic.co/t/autocomplete-for-terms-aggregations/244914 "2020-08-16T10:02:28Z")

</div>

Hi, There is a search-as-you-type fields since 7.x but is it possible to get similar results for filtered aggregations for autocomplete? Example you have documents with categories on it: holiday vacation images Ther…

---

## [How to publish elasticsearch to remote maven repository](https://discuss.elastic.co/t/how-to-publish-elasticsearch-to-remote-maven-repository/245128)

<div class="topic-metadata">

**Author:** [@calm4wei](https://discuss.elastic.co/u/calm4wei)\
**Replies:** 0\
**Last updated:** [August 16, 2020, 8:53am UTC](https://discuss.elastic.co/t/how-to-publish-elasticsearch-to-remote-maven-repository/245128 "2020-08-16T08:53:17Z")

</div>

Recently, I made some changes to the elasticsearch source code, and plans to push it to the company's maven repository. The maven repository address has been modified to the company's maven address, but Using gradle publ…

---

## [Named queries confusion](https://discuss.elastic.co/t/named-queries-confusion/245122)

<div class="topic-metadata">

**Author:** [@liamwhite1](https://discuss.elastic.co/u/liamwhite1)\
**Replies:** 1\
**Last updated:** [August 16, 2020, 6:31am UTC](https://discuss.elastic.co/t/named-queries-confusion/245122 "2020-08-16T06:31:33Z")

</div>

After reading the documentation for named queries, and attempting to perform some myself, I am thoroughly confused on how to name queries. This doesn't work: { "term": { "tag\_id": 1, "\_name": "test"…

---

## [Kibana Discover problem, Two sources of data, one index](https://discuss.elastic.co/t/kibana-discover-problem-two-sources-of-data-one-index/245113)

<div class="topic-metadata">

**Author:** [@Incauto](https://discuss.elastic.co/u/Incauto)\
**Replies:** 0\
**Last updated:** [August 16, 2020, 3:44am UTC](https://discuss.elastic.co/t/kibana-discover-problem-two-sources-of-data-one-index/245113 "2020-08-16T03:44:52Z")

</div>

I create an index with data comming from a Database (network events) and data from UDP port (syslogs events), this logs have different numbers of fields and diferent names, but four in common (same name): timestamp, mess…

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

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