# Elasticsearch

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

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

**Page:** 1275

---

## [Official blog broken link and language selection menu does NOT work](https://discuss.elastic.co/t/official-blog-broken-link-and-language-selection-menu-does-not-work/184324)

<div class="topic-metadata">

**Author:** [@byronhe](https://discuss.elastic.co/u/byronhe)\
**Replies:** 1\
**Last updated:** [June 5, 2019, 10:14am UTC](https://discuss.elastic.co/t/official-blog-broken-link-and-language-selection-menu-does-not-work/184324 "2019-06-05T10:14:40Z")

</div>

hi all, on this page : when i click the author , it shows ' 404 Well, That about Wraps It Up for This Page ' ALL English blog posts has similar problem. I use latest Chrome browser with Chinese language. thi…

---

## [What is the max limit number of ids?](https://discuss.elastic.co/t/what-is-the-max-limit-number-of-ids/182545)

<div class="topic-metadata">

**Author:** [@k1832](https://discuss.elastic.co/u/k1832)\
**Replies:** 0\
**Last updated:** [May 24, 2019, 3:18am UTC](https://discuss.elastic.co/t/what-is-the-max-limit-number-of-ids/182545 "2019-05-24T03:18:44Z")

</div>

Hi. I'm trying to use ids query in Elasticsearch and wondering if there is any maximum limit for number of values? If there is, what is it? Although I found some articles like this, I'm not quite sure if it's corr…

---

## [How can I Exclude indices from elasticsearch snapshots](https://discuss.elastic.co/t/how-can-i-exclude-indices-from-elasticsearch-snapshots/184317)

<div class="topic-metadata">

**Author:** [@nuwan](https://discuss.elastic.co/u/nuwan)\
**Replies:** 5\
**Last updated:** [June 5, 2019, 10:04am UTC](https://discuss.elastic.co/t/how-can-i-exclude-indices-from-elasticsearch-snapshots/184317 "2019-06-05T10:04:30Z")

</div>

I need to exclude a few indices from an elastic snapshot, in the documentation for snapshots , they mention you can include what indices you need, but I need it another way around because I need to snapshot all indices e…

---

## [What is difference in Basic and open source type license?](https://discuss.elastic.co/t/what-is-difference-in-basic-and-open-source-type-license/184313)

<div class="topic-metadata">

**Author:** [@sanntosh](https://discuss.elastic.co/u/sanntosh)\
**Replies:** 1\
**Last updated:** [June 5, 2019, 9:33am UTC](https://discuss.elastic.co/t/what-is-difference-in-basic-and-open-source-type-license/184313 "2019-06-05T09:33:44Z")

</div>

What is difference between Basic and Open Source type license ? Why Basic license when Open Source is there ? Can we deploy commercially using open source license ? And will security be free with that starting 7.1.1 ev…

---

## [Bulk API to Elastic Cloud write: connection reset by peer](https://discuss.elastic.co/t/bulk-api-to-elastic-cloud-write-connection-reset-by-peer/184304)

<div class="topic-metadata">

**Author:** [@werowe](https://discuss.elastic.co/u/werowe)\
**Replies:** 5\
**Last updated:** [June 5, 2019, 8:49am UTC](https://discuss.elastic.co/t/bulk-api-to-elastic-cloud-write-connection-reset-by-peer/184304 "2019-06-05T08:49:38Z")

</div>

I am trying to bulk load to elastic cloud and get connection reset by peer error. Looks like it is getting trying to write back to my server using a 10.\* IP address. I'm not supposed to log into the command line shell …

---

## [Compare field values but not in the same document](https://discuss.elastic.co/t/compare-field-values-but-not-in-the-same-document/184309)

<div class="topic-metadata">

**Author:** [@jasony](https://discuss.elastic.co/u/jasony)\
**Replies:** 0\
**Last updated:** [June 5, 2019, 8:47am UTC](https://discuss.elastic.co/t/compare-field-values-but-not-in-the-same-document/184309 "2019-06-05T08:47:18Z")

</div>

Hello, I am trying to compare 2 field values (not in the same documents but in the same index) then perform MINUS operation with other field values. My data looks below. As you see, "UUID" and "tx\_id" have the same val…

---

## [How to map two Analyzers to a same field in an index?](https://discuss.elastic.co/t/how-to-map-two-analyzers-to-a-same-field-in-an-index/184248)

<div class="topic-metadata">

**Author:** [@gauresh\_chavan](https://discuss.elastic.co/u/gauresh_chavan)\
**Replies:** 1\
**Last updated:** [June 5, 2019, 8:41am UTC](https://discuss.elastic.co/t/how-to-map-two-analyzers-to-a-same-field-in-an-index/184248 "2019-06-05T08:41:24Z")

</div>

I am indexing the documents from a SQL table and there are two fields 'parent\_sentence' and 'parent\_context' which are primarily used for search. I am building synonym and 'search-as-you-type'/Partial search on both of …

---

## [Get the corresponding document from a min aggregation](https://discuss.elastic.co/t/get-the-corresponding-document-from-a-min-aggregation/184156)

<div class="topic-metadata">

**Author:** [@Toast](https://discuss.elastic.co/u/Toast)\
**Replies:** 1\
**Last updated:** [June 5, 2019, 8:20am UTC](https://discuss.elastic.co/t/get-the-corresponding-document-from-a-min-aggregation/184156 "2019-06-05T08:20:44Z")

</div>

Hello, i'm querying an aggregation for the minimum and maximum price in an index, like this: "aggregations": { "PriceMin": { "min": {"field": "PriceProduct"} }, "PriceMax": { "max": {"field": "P…

---

## [Combining Multiple Function Scores](https://discuss.elastic.co/t/combining-multiple-function-scores/183857)

<div class="topic-metadata">

**Author:** [@gidgid](https://discuss.elastic.co/u/gidgid)\
**Replies:** 3\
**Last updated:** [June 5, 2019, 7:46am UTC](https://discuss.elastic.co/t/combining-multiple-function-scores/183857 "2019-06-05T07:46:15Z")

</div>

I've got several different Elasticsearch function\_score but I'm not sure how to combine them This is the test set I'm looking at (I added comments to be able to refer to specific items in the question, these comments ar…

---

## [How can take Elasticsearch snapshot expect some index](https://discuss.elastic.co/t/how-can-take-elasticsearch-snapshot-expect-some-index/184289)

<div class="topic-metadata">

**Author:** [@nuwan](https://discuss.elastic.co/u/nuwan)\
**Replies:** 0\
**Last updated:** [June 5, 2019, 7:09am UTC](https://discuss.elastic.co/t/how-can-take-elasticsearch-snapshot-expect-some-index/184289 "2019-06-05T07:09:52Z")

</div>

Hi Team. How can I take the Elasticsearch snapshot to exclude some index like ".monitoring-es-6-2019.06.05", .monitoring-kibana-6-2019.06.04 and etc Thank you, Nuwan

---

## [How to query more then 10k items without using the helpers.scan?](https://discuss.elastic.co/t/how-to-query-more-then-10k-items-without-using-the-helpers-scan/184287)

<div class="topic-metadata">

**Author:** [@zarka](https://discuss.elastic.co/u/zarka)\
**Replies:** 0\
**Last updated:** [June 5, 2019, 6:48am UTC](https://discuss.elastic.co/t/how-to-query-more-then-10k-items-without-using-the-helpers-scan/184287 "2019-06-05T06:48:09Z")

</div>

Hello all, i'm sure these topic was discussed in the past but i still didn't find the answer. How do i query more then 10k fields without using the helpers.scan? The reason i want to use the 'es.search' method and not …

---

## [Facing the cause "cannot evaluate script for expression StringQueryPredicate"](https://discuss.elastic.co/t/facing-the-cause-cannot-evaluate-script-for-expression-stringquerypredicate/183567)

<div class="topic-metadata">

**Author:** [@shubham-agarwal-ngi](https://discuss.elastic.co/u/shubham-agarwal-ngi)\
**Replies:** 1\
**Last updated:** [June 5, 2019, 5:57am UTC](https://discuss.elastic.co/t/facing-the-cause-cannot-evaluate-script-for-expression-stringquerypredicate/183567 "2019-06-05T05:57:07Z")

</div>

Elasticsearch version - 6.6.0 JVM version -1.8 OS version window server 2012 R2 I am running the below query using the xpack api { "query":"Select role as "role" , sum(customerincome ) as "sum\_customerincome" FRO…

---

## [Index\_out\_of\_bounds\_exception](https://discuss.elastic.co/t/index-out-of-bounds-exception/184173)

<div class="topic-metadata">

**Author:** [@darshansh](https://discuss.elastic.co/u/darshansh)\
**Replies:** 1\
**Last updated:** [June 5, 2019, 5:54am UTC](https://discuss.elastic.co/t/index-out-of-bounds-exception/184173 "2019-06-05T05:54:06Z")

</div>

Hi, getting below error while running painless script in elasticsearch 6.7. Any hint or fix ? "failures": \[ { "shard": 2, "index": "mpis\_test", "node": "qYRoYv39RZqGrP7iAhukcQ", "reason": { "type": "script\_excep…

---

## [How to use store comma separated values in elastic search column?](https://discuss.elastic.co/t/how-to-use-store-comma-separated-values-in-elastic-search-column/183956)

<div class="topic-metadata">

**Author:** [@KrishK](https://discuss.elastic.co/u/KrishK)\
**Replies:** 1\
**Last updated:** [June 5, 2019, 5:32am UTC](https://discuss.elastic.co/t/how-to-use-store-comma-separated-values-in-elastic-search-column/183956 "2019-06-05T05:32:07Z")

</div>

I have comma separated values in one column and i want to use that column in elastic search. Mapping created with Nested type. Below is mapping : e.g "mapping": { "doctype": { "type": "nested", "properties": { "d…

---

## [Elastic search BulkAsync after Reindex is overwriting the documents](https://discuss.elastic.co/t/elastic-search-bulkasync-after-reindex-is-overwriting-the-documents/184273)

<div class="topic-metadata">

**Author:** [@SudevPK](https://discuss.elastic.co/u/SudevPK)\
**Replies:** 0\
**Last updated:** [June 5, 2019, 4:27am UTC](https://discuss.elastic.co/t/elastic-search-bulkasync-after-reindex-is-overwriting-the-documents/184273 "2019-06-05T04:27:03Z")

</div>

Hi everyone, I am having an Elastic search node(Elastic search 7.0.1).I have created an index called "property\_autocomplete" and pushed data from SQL to "property\_autocomplete" index. I forgot to add some fields.So i h…

---

## [Alter the template for system indices](https://discuss.elastic.co/t/alter-the-template-for-system-indices/183883)

<div class="topic-metadata">

**Author:** [@victor.nilsson](https://discuss.elastic.co/u/victor.nilsson)\
**Replies:** 7\
**Last updated:** [June 5, 2019, 4:09am UTC](https://discuss.elastic.co/t/alter-the-template-for-system-indices/183883 "2019-06-05T04:09:05Z")

</div>

Hi, We want to reduce the amount of shards that each .security\_audit\_log template is generating on a daily basis. At the moment it is creating 5 shards each day and we want to reduce it to 1 primary and 1 replica. Does…

---

## [./kibana\_task\_manager/\_search, params: {ignore\_unavailable=true, index=.kibana\_task\_manager} all shards failed](https://discuss.elastic.co/t/kibana-task-manager-search-params-ignore-unavailable-true-index-kibana-task-manager-all-shards-failed/184272)

<div class="topic-metadata">

**Author:** [@Hengheng1](https://discuss.elastic.co/u/Hengheng1)\
**Replies:** 0\
**Last updated:** [June 5, 2019, 4:01am UTC](https://discuss.elastic.co/t/kibana-task-manager-search-params-ignore-unavailable-true-index-kibana-task-manager-all-shards-failed/184272 "2019-06-05T04:01:07Z")

</div>

What happened to me when I restarted the cluster ./kibana\_task\_manager/\_search, params: {ignore\_unavailable=true, index=.kibana\_task\_manager} SearchPhaseExecutionException: all shards failed

---

## [Watcher email html body passed as a stored script](https://discuss.elastic.co/t/watcher-email-html-body-passed-as-a-stored-script/183449)

<div class="topic-metadata">

**Author:** [@NidOf3lp](https://discuss.elastic.co/u/NidOf3lp)\
**Replies:** 2\
**Last updated:** [June 5, 2019, 3:47am UTC](https://discuss.elastic.co/t/watcher-email-html-body-passed-as-a-stored-script/183449 "2019-06-05T03:47:46Z")

</div>

Hi, I'd like to have my email action to retrieve the email body stored as a mustache script. Currently the email get sent with "mem-watch-warning" as a text instead of the html content stored in \_scripts/mem-watch-warni…

---

## [Elasticsearch-setup-passwords interactive fails on a new cluster](https://discuss.elastic.co/t/elasticsearch-setup-passwords-interactive-fails-on-a-new-cluster/184250)

<div class="topic-metadata">

**Author:** [@o1o1o11o1](https://discuss.elastic.co/u/o1o1o11o1)\
**Replies:** 1\
**Last updated:** [June 4, 2019, 11:51pm UTC](https://discuss.elastic.co/t/elasticsearch-setup-passwords-interactive-fails-on-a-new-cluster/184250 "2019-06-04T23:51:50Z")

</div>

Trying to provision a new cluster, currently two master nodes on 7.1.0. When I try to setup the initial passwords for the built-in users I get the following error: root@master-node-1:~# /usr/share/elasticsearch/bin/ela…

---

## [How to Increase number of shards of an existing Index](https://discuss.elastic.co/t/how-to-increase-number-of-shards-of-an-existing-index/183886)

<div class="topic-metadata">

**Author:** [@Shivendra\_Singh](https://discuss.elastic.co/u/Shivendra_Singh)\
**Replies:** 6\
**Last updated:** [June 4, 2019, 10:19pm UTC](https://discuss.elastic.co/t/how-to-increase-number-of-shards-of-an-existing-index/183886 "2019-06-04T22:19:35Z")

</div>

Hi All, I am new to ES stack. I have a question related to reindexing- I have created an index with default option(5 shards and 1 replica). Can I increase number of shards for my index if data size of my index increase…

---

## [Issue with bulk index performance](https://discuss.elastic.co/t/issue-with-bulk-index-performance/184253)

<div class="topic-metadata">

**Author:** [@opak](https://discuss.elastic.co/u/opak)\
**Replies:** 0\
**Last updated:** [June 4, 2019, 9:05pm UTC](https://discuss.elastic.co/t/issue-with-bulk-index-performance/184253 "2019-06-04T21:05:13Z")

</div>

Hello, we have issue with our ES cluster 6.6.2 while we try to index 1m documents. our index: {"settings":{"index":{"number\_of\_shards":"5","provided\_name":"org220\_dev\_1559679865\_elixir","creation\_date":"1559679865761",…

---

## [3 node ES cluster on single vm](https://discuss.elastic.co/t/3-node-es-cluster-on-single-vm/180266)

<div class="topic-metadata">

**Author:** [@syedsfayaz](https://discuss.elastic.co/u/syedsfayaz)\
**Replies:** 9\
**Last updated:** [June 4, 2019, 7:39pm UTC](https://discuss.elastic.co/t/3-node-es-cluster-on-single-vm/180266 "2019-06-04T19:39:15Z")

</div>

HI I want to setup a 3 node ES cluster on one VM. I tried to install and configure but seeing issues. I installed ES to two different directories and configured it . But I am seeing error. My elasticsearch.yml file .…

---

## [Aggregation by names of the days](https://discuss.elastic.co/t/aggregation-by-names-of-the-days/184232)

<div class="topic-metadata">

**Author:** [@jpaz93](https://discuss.elastic.co/u/jpaz93)\
**Replies:** 0\
**Last updated:** [June 4, 2019, 5:06pm UTC](https://discuss.elastic.co/t/aggregation-by-names-of-the-days/184232 "2019-06-04T17:06:24Z")

</div>

Hi, I need help with the following: I need to make an aggregation to group by the names of the days I have tried the following: GET evento/\_search { "size": 0, "query": { "range": { "datetime1": {…

---

## [Percentile with inline script](https://discuss.elastic.co/t/percentile-with-inline-script/184244)

<div class="topic-metadata">

**Author:** [@aniaks](https://discuss.elastic.co/u/aniaks)\
**Replies:** 0\
**Last updated:** [June 4, 2019, 7:06pm UTC](https://discuss.elastic.co/t/percentile-with-inline-script/184244 "2019-06-04T19:06:40Z")

</div>

is there a way to get the percentile values for the custom calculation instead of passing just the field to the percentile function?

---

## [Kubernetes elasticsearch operator not scaling down](https://discuss.elastic.co/t/kubernetes-elasticsearch-operator-not-scaling-down/183933)

<div class="topic-metadata">

**Author:** [@vicmarbev](https://discuss.elastic.co/u/vicmarbev)\
**Replies:** 0\
**Last updated:** [June 3, 2019, 10:19am UTC](https://discuss.elastic.co/t/kubernetes-elasticsearch-operator-not-scaling-down/183933 "2019-06-03T10:19:04Z")

</div>

Hi, I'm trying the kubernetes elasticsearch operator, and I have defined an EDS with the following scaling attributes: scaling: enabled: true minReplicas: 1 maxReplicas: 4 minIndexReplicas: 0 m…

---

## [Expected database \[GeoLite2-ASN.mmdb\] to not exist in](https://discuss.elastic.co/t/expected-database-geolite2-asn-mmdb-to-not-exist-in/183999)

<div class="topic-metadata">

**Author:** [@pjanzen](https://discuss.elastic.co/u/pjanzen)\
**Replies:** 2\
**Last updated:** [June 4, 2019, 6:13pm UTC](https://discuss.elastic.co/t/expected-database-geolite2-asn-mmdb-to-not-exist-in/183999 "2019-06-04T18:13:15Z")

</div>

HI All, Is it me or is this a very confusing error message? Caused by: java.lang.RuntimeException: java.io.IOException: expected database \[GeoLite2-ASN.mmdb\] to not exist in \[/etc/elasticsearch/ingest-geoip\] Should th…

---

## [Weird behavior using norms with nested type](https://discuss.elastic.co/t/weird-behavior-using-norms-with-nested-type/182684)

<div class="topic-metadata">

**Author:** [@kailoofi](https://discuss.elastic.co/u/kailoofi)\
**Replies:** 2\
**Last updated:** [June 4, 2019, 5:38pm UTC](https://discuss.elastic.co/t/weird-behavior-using-norms-with-nested-type/182684 "2019-06-04T17:38:01Z")

</div>

Hello, I am observing inexplicable behavior and looking to reconcile that with my understanding of norms and nested types. I am using ES 5.6 as of now and not sure if this can be observed in more recent versions. I hav…

---

## [Elasticsearch 7.1.x fails to start with security enabled](https://discuss.elastic.co/t/elasticsearch-7-1-x-fails-to-start-with-security-enabled/183542)

<div class="topic-metadata">

**Author:** [@nobound](https://discuss.elastic.co/u/nobound)\
**Replies:** 7\
**Last updated:** [June 4, 2019, 5:20pm UTC](https://discuss.elastic.co/t/elasticsearch-7-1-x-fails-to-start-with-security-enabled/183542 "2019-06-04T17:20:52Z")

</div>

Trying to follow the instructions from After editing the config/elasticsearch.yaml xpack.security.enabled: true xpack.security.transport.ssl.enabled: true xpack.security.transport.ssl.verification\_mode: certificate …

---

## [Node failing to join cluster](https://discuss.elastic.co/t/node-failing-to-join-cluster/184051)

<div class="topic-metadata">

**Author:** [@bkasrai](https://discuss.elastic.co/u/bkasrai)\
**Replies:** 2\
**Last updated:** [June 4, 2019, 4:58pm UTC](https://discuss.elastic.co/t/node-failing-to-join-cluster/184051 "2019-06-04T16:58:19Z")

</div>

Good afternoon-I am looking to add a second node to my cluster and I am not seeing the node join and after reviewing the logs, I am seeing a unknown\_ca cert error. (attached below) My ES yml file mimics the original node…

---

## [Filebeat Not Pushing Python Logging Messages](https://discuss.elastic.co/t/filebeat-not-pushing-python-logging-messages/184227)

<div class="topic-metadata">

**Author:** [@ryh](https://discuss.elastic.co/u/ryh)\
**Replies:** 0\
**Last updated:** [June 4, 2019, 4:27pm UTC](https://discuss.elastic.co/t/filebeat-not-pushing-python-logging-messages/184227 "2019-06-04T16:27:36Z")

</div>

Hi All, Thanks in advance. I'm having issues with filebeat not pushing my Python logging messages to Logstash (not visible in Kibana). Here is my logging config. def get\_module\_logger(mod\_name): """ To use th…

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

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