# Elasticsearch

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

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

**Page:** 630

---

## [Unassigned shards of index - not permitted by any node](https://discuss.elastic.co/t/unassigned-shards-of-index-not-permitted-by-any-node/275766)

<div class="topic-metadata">

**Author:** [@Roy\_Levy](https://discuss.elastic.co/u/Roy_Levy)\
**Replies:** 1\
**Last updated:** [June 14, 2021, 4:01am UTC](https://discuss.elastic.co/t/unassigned-shards-of-index-not-permitted-by-any-node/275766 "2021-06-14T04:01:07Z")

</div>

Hey, I'm trying to understand how to fix this issue of unassigned shards in my index: When running the explain API - I'm getting "no" for allocation: "can\_allocate" : "no" And in each node (9 of them), the decider…

---

## ["All fetched documents included fields with arrays of values and cannot be visualized."](https://discuss.elastic.co/t/all-fetched-documents-included-fields-with-arrays-of-values-and-cannot-be-visualized/275774)

<div class="topic-metadata">

**Author:** [@pkward](https://discuss.elastic.co/u/pkward)\
**Replies:** 0\
**Last updated:** [June 13, 2021, 8:14pm UTC](https://discuss.elastic.co/t/all-fetched-documents-included-fields-with-arrays-of-values-and-cannot-be-visualized/275774 "2021-06-13T20:14:39Z")

</div>

Hello, I'm trying to create a data frame analytics ML job, and I have two fields that have an array of numbers. The issue is that the analytics job cannot visualize these arrays. Is there any work around or fix? The err…

---

## [Sorting on Nested array object within the same json file](https://discuss.elastic.co/t/sorting-on-nested-array-object-within-the-same-json-file/275767)

<div class="topic-metadata">

**Author:** [@madhan88](https://discuss.elastic.co/u/madhan88)\
**Replies:** 1\
**Last updated:** [June 13, 2021, 7:03pm UTC](https://discuss.elastic.co/t/sorting-on-nested-array-object-within-the-same-json-file/275767 "2021-06-13T19:03:47Z")

</div>

Hi, I'm trying to sort the fields present within an array which is of type nested. My data : { "name" : "abc", "shipping":\[ { "shipmentcode" : 5, "shipmentstatus" : "resolved", "shipmentorderid": "12345" }, { …

---

## [Nested queries don't work as documented](https://discuss.elastic.co/t/nested-queries-dont-work-as-documented/275737)

<div class="topic-metadata">

**Author:** [@titani0us](https://discuss.elastic.co/u/titani0us)\
**Replies:** 2\
**Last updated:** [June 13, 2021, 4:45pm UTC](https://discuss.elastic.co/t/nested-queries-dont-work-as-documented/275737 "2021-06-13T16:45:55Z")

</div>

Hello, As documented in your documentation here, the documentation shows using dot-notation to traverse a nested field (user -\> id). However, when using the query dsl this way, no results are returned. Instead, you mus…

---

## [Find contact with aggs terms and date range and use the found contacts for another aggs with date\_histogram](https://discuss.elastic.co/t/find-contact-with-aggs-terms-and-date-range-and-use-the-found-contacts-for-another-aggs-with-date-histogram/275762)

<div class="topic-metadata">

**Author:** [@gregoire\_Tarres](https://discuss.elastic.co/u/gregoire_Tarres)\
**Replies:** 0\
**Last updated:** [June 13, 2021, 12:25pm UTC](https://discuss.elastic.co/t/find-contact-with-aggs-terms-and-date-range-and-use-the-found-contacts-for-another-aggs-with-date-histogram/275762 "2021-06-13T12:25:13Z")

</div>

Hi, i'm new with Elaticsearch and I need some help for a search query.... Thanks in advance ! I've an index with docs between 2021-02-01 and 2021-04-01. I make a search query like this to retrieve phone numbers that app…

---

## [Node memory](https://discuss.elastic.co/t/node-memory/275634)

<div class="topic-metadata">

**Author:** [@bevano](https://discuss.elastic.co/u/bevano)\
**Replies:** 2\
**Last updated:** [June 12, 2021, 4:50pm UTC](https://discuss.elastic.co/t/node-memory/275634 "2021-06-12T16:50:14Z")

</div>

Hi All, Currently on our nodes we have 64GB RAM, with 30GB allocated to the heap, and the other 34GB for OS. I understand that I shouldn't allocate more then 30GB to the heap, but will ES/OS benefit from 128GB or 256GB…

---

## [Need Suggestion on match\_phrase\_prefix and field priority result top to bottom order](https://discuss.elastic.co/t/need-suggestion-on-match-phrase-prefix-and-field-priority-result-top-to-bottom-order/275728)

<div class="topic-metadata">

**Author:** [@bikashelastic](https://discuss.elastic.co/u/bikashelastic)\
**Replies:** 0\
**Last updated:** [June 12, 2021, 9:47am UTC](https://discuss.elastic.co/t/need-suggestion-on-match-phrase-prefix-and-field-priority-result-top-to-bottom-order/275728 "2021-06-12T09:47:48Z")

</div>

Hy Team, I have implemented the bool query "match\_phrase\_prefix" with "slop" in my search functionality and the query is giving me the result as expected. but the order of the result is not giving the field priority. W…

---

## [All Nodes Failed Exception](https://discuss.elastic.co/t/all-nodes-failed-exception/275627)

<div class="topic-metadata">

**Author:** [@NLSVTN](https://discuss.elastic.co/u/NLSVTN)\
**Replies:** 15\
**Last updated:** [June 12, 2021, 5:43am UTC](https://discuss.elastic.co/t/all-nodes-failed-exception/275627 "2021-06-12T05:43:39Z")

</div>

Hi, We are getting the following error: Error summary: EsHadoopNoNodesLeftException: Connection error (check network and/or proxy settings)- all nodes failed; tried \[\[https://search-seqr-gris-prod-65wdlm6cncfxo5d326vkd…

---

## [Indices not rolling over](https://discuss.elastic.co/t/indices-not-rolling-over/275640)

<div class="topic-metadata">

**Author:** [@lchan](https://discuss.elastic.co/u/lchan)\
**Replies:** 2\
**Last updated:** [June 12, 2021, 4:55am UTC](https://discuss.elastic.co/t/indices-not-rolling-over/275640 "2021-06-12T04:55:14Z")

</div>

I am troubleshooting an issue where my indices (filebeats\*) are not rolling from hot to warm. I changed rollover max\_age=30d to max\_age=1d. However, the indices of the ILM action is "completed" and looks like they won't…

---

## [Join the result of two different queries indices](https://discuss.elastic.co/t/join-the-result-of-two-different-queries-indices/275470)

<div class="topic-metadata">

**Author:** [@Walter\_Jimenez](https://discuss.elastic.co/u/Walter_Jimenez)\
**Replies:** 3\
**Last updated:** [June 11, 2021, 9:53pm UTC](https://discuss.elastic.co/t/join-the-result-of-two-different-queries-indices/275470 "2021-06-11T21:53:38Z")

</div>

Good morning, excuse my English. I am new to elastic and I am doing some tests with the queries, I have the following case: I have two indeces, metrics and a custom one of my own, I was able to make each one a separate …

---

## [Limiting dynamic properties/fields indexed](https://discuss.elastic.co/t/limiting-dynamic-properties-fields-indexed/275585)

<div class="topic-metadata">

**Author:** [@ronchalant](https://discuss.elastic.co/u/ronchalant)\
**Replies:** 3\
**Last updated:** [June 11, 2021, 9:48pm UTC](https://discuss.elastic.co/t/limiting-dynamic-properties-fields-indexed/275585 "2021-06-11T21:48:47Z")

</div>

We're migrating to ES7, and for one of our indexes which stores email data we are hitting the "Limit of total fields \[1000\]" error. The reason for this is we're indexing all headers, and for some emails the number of he…

---

## [Aggregration Filter doesnt seem to work](https://discuss.elastic.co/t/aggregration-filter-doesnt-seem-to-work/275182)

<div class="topic-metadata">

**Author:** [@kapso](https://discuss.elastic.co/u/kapso)\
**Replies:** 1\
**Last updated:** [June 11, 2021, 8:58pm UTC](https://discuss.elastic.co/t/aggregration-filter-doesnt-seem-to-work/275182 "2021-06-11T20:58:30Z")

</div>

I have document of type blog posts, here's what an example looks like Input: \[ { "id": 1, "post\_title": "Title 1", "published\_on": "2021-06-07", "tag\_ids": \[1, 2\], "authors": \[ { "id…

---

## [Possible bug in completion context suggester (6.8 and 7.10)](https://discuss.elastic.co/t/possible-bug-in-completion-context-suggester-6-8-and-7-10/275718)

<div class="topic-metadata">

**Author:** [@bklippel](https://discuss.elastic.co/u/bklippel)\
**Replies:** 0\
**Last updated:** [June 11, 2021, 8:10pm UTC](https://discuss.elastic.co/t/possible-bug-in-completion-context-suggester-6-8-and-7-10/275718 "2021-06-11T20:10:22Z")

</div>

Hi, I've come across some strange behavior using the completion suggest. In my scenario it seems that inputs over ~34 characters are ignored. I have steps to reproduce. Create this index, post this doc then try the qu…

---

## [Cannot start elastic search server](https://discuss.elastic.co/t/cannot-start-elastic-search-server/275700)

<div class="topic-metadata">

**Author:** [@elastic0](https://discuss.elastic.co/u/elastic0)\
**Replies:** 1\
**Last updated:** [June 11, 2021, 8:08pm UTC](https://discuss.elastic.co/t/cannot-start-elastic-search-server/275700 "2021-06-11T20:08:02Z")

</div>

I downloaded elasticsearch-7.13.1-windows-x86\_64.zip, but when I run elasticsearch-service-x64.exe it immediately crashes briefly flashing a blank window. If I run elasticsearch.bat, it gets the following exception. un…

---

## [How do I read data from influxdb](https://discuss.elastic.co/t/how-do-i-read-data-from-influxdb/275711)

<div class="topic-metadata">

**Author:** [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Replies:** 1\
**Last updated:** [June 11, 2021, 7:22pm UTC](https://discuss.elastic.co/t/how-do-i-read-data-from-influxdb/275711 "2021-06-11T19:22:52Z")

</div>

I have a need to read data from influxdb. anyone has done this before can you give me example of input plugin for that?

---

## [Ingest Pipeline for routing data into 2 different indexes](https://discuss.elastic.co/t/ingest-pipeline-for-routing-data-into-2-different-indexes/228189)

<div class="topic-metadata">

**Author:** [@Mack\_rogers](https://discuss.elastic.co/u/Mack_rogers)\
**Replies:** 3\
**Last updated:** [June 11, 2021, 7:13pm UTC](https://discuss.elastic.co/t/ingest-pipeline-for-routing-data-into-2-different-indexes/228189 "2021-06-11T19:13:38Z")

</div>

How can you write into 2 different indexes using a ingest pipeline? Example. a single doc with fields a , b, c, and d ? index A will receive fields A & B index B will receive fields C & D How can I accomplish this wi…

---

## [Shards](https://discuss.elastic.co/t/shards/275554)

<div class="topic-metadata">

**Author:** [@Abhishek\_Shinde](https://discuss.elastic.co/u/Abhishek_Shinde)\
**Replies:** 3\
**Last updated:** [June 11, 2021, 6:14pm UTC](https://discuss.elastic.co/t/shards/275554 "2021-06-11T18:14:23Z")

</div>

I was referring to following for sizing the shards, I referred the following sections in the article, #Aim for shard sizes between 10GB and 50GB #Aim for 20 shards or fewer per GB of heap memory I wanted to understa…

---

## [How to pass user credential to REST api?](https://discuss.elastic.co/t/how-to-pass-user-credential-to-rest-api/275562)

<div class="topic-metadata">

**Author:** [@Ashwin\_Srivastav](https://discuss.elastic.co/u/Ashwin_Srivastav)\
**Replies:** 5\
**Last updated:** [June 11, 2021, 4:44pm UTC](https://discuss.elastic.co/t/how-to-pass-user-credential-to-rest-api/275562 "2021-06-11T16:44:56Z")

</div>

I have coded a REST api which basically inserts, gets and updates the data from Elasticsearch. After implementing the basic security when I pass a curl command to the api providing credentials along with it (using -u), I…

---

## [Filtering Index or custom rules for Elastic ML anomaly detection](https://discuss.elastic.co/t/filtering-index-or-custom-rules-for-elastic-ml-anomaly-detection/275326)

<div class="topic-metadata">

**Author:** [@elizobee](https://discuss.elastic.co/u/elizobee)\
**Replies:** 5\
**Last updated:** [June 11, 2021, 4:22pm UTC](https://discuss.elastic.co/t/filtering-index-or-custom-rules-for-elastic-ml-anomaly-detection/275326 "2021-06-11T16:22:32Z")

</div>

I would like to run anomaly detection on a subset of an index. It looks like I am supposed to set up a filter list containing the values I wish to select, and then create a custom rule to associate a field with a filter…

---

## [Cannot merge \[properties\] mappings error](https://discuss.elastic.co/t/cannot-merge-properties-mappings-error/275506)

<div class="topic-metadata">

**Author:** [@pkward](https://discuss.elastic.co/u/pkward)\
**Replies:** 0\
**Last updated:** [June 9, 2021, 10:26pm UTC](https://discuss.elastic.co/t/cannot-merge-properties-mappings-error/275506 "2021-06-09T22:26:37Z")

</div>

Hello, I'm having a hard time with my running my ML Job due to my fields. Can I correct this by modifying my mappings? I've pasted my error below: "statusCode": 400, "error": "Bad Request", "message": "\[status\_exce…

---

## [FTP repository](https://discuss.elastic.co/t/ftp-repository/274508)

<div class="topic-metadata">

**Author:** [@Chinedum\_Nwuzor](https://discuss.elastic.co/u/Chinedum_Nwuzor)\
**Replies:** 4\
**Last updated:** [June 11, 2021, 11:53am UTC](https://discuss.elastic.co/t/ftp-repository/274508 "2021-06-11T11:53:36Z")

</div>

Hello, I am trying to setup an FTP repository for my snapshots. However, it fails with an access denied error message. Please the ftp url I used ftp://username:password@host/ Kindly assist.

---

## [Is there a way of preventing all primary shards of an idex to be placed on the same ES node](https://discuss.elastic.co/t/is-there-a-way-of-preventing-all-primary-shards-of-an-idex-to-be-placed-on-the-same-es-node/275555)

<div class="topic-metadata">

**Author:** [@A\_B](https://discuss.elastic.co/u/A_B)\
**Replies:** 2\
**Last updated:** [June 11, 2021, 10:52am UTC](https://discuss.elastic.co/t/is-there-a-way-of-preventing-all-primary-shards-of-an-idex-to-be-placed-on-the-same-es-node/275555 "2021-06-11T10:52:06Z")

</div>

Hello, I have a 49 node ES cluster with roughly the same size storage on each node (900GB). Most indices have 3-5 primary shards. Indices and shards can be of very variable size. Every so often, all primary shards of o…

---

## [Rook ceph for Elastic Search](https://discuss.elastic.co/t/rook-ceph-for-elastic-search/275647)

<div class="topic-metadata">

**Author:** [@Sangamesh\_Patil](https://discuss.elastic.co/u/Sangamesh_Patil)\
**Replies:** 1\
**Last updated:** [June 11, 2021, 9:50am UTC](https://discuss.elastic.co/t/rook-ceph-for-elastic-search/275647 "2021-06-11T09:50:19Z")

</div>

Hello, We are deploying elastic search on kubernetes farm and we have rook ceph as our distributed storage. I was going through earlier topic and there was enough reason than with ES being heavy used for File system. Bu…

---

## [Top-hits on aggregations](https://discuss.elastic.co/t/top-hits-on-aggregations/274959)

<div class="topic-metadata">

**Author:** [@romathonat](https://discuss.elastic.co/u/romathonat)\
**Replies:** 1\
**Last updated:** [June 11, 2021, 7:25am UTC](https://discuss.elastic.co/t/top-hits-on-aggregations/274959 "2021-06-11T07:25:19Z")

</div>

Hello, I need to get the top-hits over an aggregation. In my use case I store SQL queries as documents (with different statistics like the time it tooks). Each querie is hashed, so that I can make an aggregation term o…

---

## [What is the price of Elasticsearch licence](https://discuss.elastic.co/t/what-is-the-price-of-elasticsearch-licence/275636)

<div class="topic-metadata">

**Author:** [@sudo-ranjith](https://discuss.elastic.co/u/sudo-ranjith)\
**Replies:** 5\
**Last updated:** [June 11, 2021, 7:01am UTC](https://discuss.elastic.co/t/what-is-the-price-of-elasticsearch-licence/275636 "2021-06-11T07:01:51Z")

</div>

Hello Folks, I have planned to setup ELK stack on-premise, I checked Subscriptions | Elastic Stack Products & Support | Elastic, they have mentioned Basic - free and open 2. I would like to know is really Elasticsearc…

---

## [Facing issue on kibana](https://discuss.elastic.co/t/facing-issue-on-kibana/275652)

<div class="topic-metadata">

**Author:** [@SHRIANSH\_RASEKAR](https://discuss.elastic.co/u/SHRIANSH_RASEKAR)\
**Replies:** 0\
**Last updated:** [June 11, 2021, 7:02am UTC](https://discuss.elastic.co/t/facing-issue-on-kibana/275652 "2021-06-11T07:02:32Z")

</div>

HI, I am facing issue on kibana dashboard, charts are blank , also from 1 week data is not coming, can anyone help to get cause. Error: Too Many Requests at Fetch.\_callee3$ (http://1\*\*.\*\*\*.\*\*.\*\*:5601/31997/bundles/commo…

---

## [Watcher does not get triggered properly](https://discuss.elastic.co/t/watcher-does-not-get-triggered-properly/275630)

<div class="topic-metadata">

**Author:** [@mhmtsvr](https://discuss.elastic.co/u/mhmtsvr)\
**Replies:** 0\
**Last updated:** [June 10, 2021, 10:45pm UTC](https://discuss.elastic.co/t/watcher-does-not-get-triggered-properly/275630 "2021-06-10T22:45:49Z")

</div>

Hi, I have a watcher notifying the slack channel once elastic receives any logs regarding the query I set. It usually triggers, but I sometimes observe that the watcher does not get triggered even though logs are availa…

---

## [Is it possible to do combSum in similarity?](https://discuss.elastic.co/t/is-it-possible-to-do-combsum-in-similarity/275040)

<div class="topic-metadata">

**Author:** [@rabbit0v0](https://discuss.elastic.co/u/rabbit0v0)\
**Replies:** 1\
**Last updated:** [June 10, 2021, 9:08pm UTC](https://discuss.elastic.co/t/is-it-possible-to-do-combsum-in-similarity/275040 "2021-06-10T21:08:56Z")

</div>

I wonder if I can calculate the similarity by adding up tf-idf score and BM25 score, is there a way to do it?

---

## [Mapping for versioned K,V pairs](https://discuss.elastic.co/t/mapping-for-versioned-k-v-pairs/275354)

<div class="topic-metadata">

**Author:** [@abhishekc92](https://discuss.elastic.co/u/abhishekc92)\
**Replies:** 1\
**Last updated:** [June 10, 2021, 9:06pm UTC](https://discuss.elastic.co/t/mapping-for-versioned-k-v-pairs/275354 "2021-06-10T21:06:17Z")

</div>

Hi, I'm trying to come up with a mapping for a document storing versioned custom key value pairs. Eg. version : "1" =\> \[{key : "customkey1", value : "val1"}, {key : "customkey2", value : "val2"}..\] version: "2" =\> \[{k…

---

## [Count the chattiest server](https://discuss.elastic.co/t/count-the-chattiest-server/275412)

<div class="topic-metadata">

**Author:** [@A\_Mightiev](https://discuss.elastic.co/u/A_Mightiev)\
**Replies:** 1\
**Last updated:** [June 10, 2021, 8:59pm UTC](https://discuss.elastic.co/t/count-the-chattiest-server/275412 "2021-06-10T20:59:59Z")

</div>

Hi I am getting logs from different servers and I would like to get a watcher where it will count the number of errors reported and trigger a response after certain threshold. I have it worked but it counts all errors o…

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

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