# Elasticsearch

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

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

**Page:** 1372

---

## [Deleted .tasks Index; Will that create a problem?](https://discuss.elastic.co/t/deleted-tasks-index-will-that-create-a-problem/170598)

<div class="topic-metadata">

**Author:** [@Paul\_Ainslie](https://discuss.elastic.co/u/Paul_Ainslie)\
**Replies:** 1\
**Last updated:** [March 8, 2019, 6:39pm UTC](https://discuss.elastic.co/t/deleted-tasks-index-will-that-create-a-problem/170598 "2019-03-08T18:39:44Z")

</div>

The " 7.0 Upgrade Assistant" was complaining about the .tasks index which was created in an older version 5.4 or around there. I assumed it was one of those system indexes that, if deleted, would be automatically recrea…

---

## [UPDATEs/GETs against same index and document/id guaranteed?](https://discuss.elastic.co/t/updates-gets-against-same-index-and-document-id-guaranteed/171424)

<div class="topic-metadata">

**Author:** [@tregoning](https://discuss.elastic.co/u/tregoning)\
**Replies:** 2\
**Last updated:** [March 8, 2019, 5:36pm UTC](https://discuss.elastic.co/t/updates-gets-against-same-index-and-document-id-guaranteed/171424 "2019-03-08T17:36:43Z")

</div>

Hi, after a lot of reading I am still not 100% clear about the following two questions: is the order of "update" requests (against the same index and document/id) guaranteed? is the order between updates/gets reque…

---

## [How max expansion works?](https://discuss.elastic.co/t/how-max-expansion-works/171534)

<div class="topic-metadata">

**Author:** [@c\_sharper](https://discuss.elastic.co/u/c_sharper)\
**Replies:** 0\
**Last updated:** [March 8, 2019, 5:12pm UTC](https://discuss.elastic.co/t/how-max-expansion-works/171534 "2019-03-08T17:12:17Z")

</div>

Hi, I faced the same problem as discussed here: How exactly works "max\_expansions" in match\_phrase\_prefix query? - #2 by Clinton\_Gormley But this is still not answered. I'm testing how match\_phrase\_prefix and max expan…

---

## [Managed ES Cloud on Azure](https://discuss.elastic.co/t/managed-es-cloud-on-azure/171527)

<div class="topic-metadata">

**Author:** [@brolly759](https://discuss.elastic.co/u/brolly759)\
**Replies:** 1\
**Last updated:** [March 8, 2019, 4:29pm UTC](https://discuss.elastic.co/t/managed-es-cloud-on-azure/171527 "2019-03-08T16:29:10Z")

</div>

Is there an option to host a managed Elastic Cloud instance on Azure instead of AWS / Google? Thanks!

---

## [Elasticsearch - connector ODBC](https://discuss.elastic.co/t/elasticsearch-connector-odbc/171519)

<div class="topic-metadata">

**Author:** [@Francisca\_Lima](https://discuss.elastic.co/u/Francisca_Lima)\
**Replies:** 3\
**Last updated:** [March 8, 2019, 4:27pm UTC](https://discuss.elastic.co/t/elasticsearch-connector-odbc/171519 "2019-03-08T16:27:41Z")

</div>

Hello, I installed Elasticsearch and I am doing some experiments with the technology. Is it possible in any way to use a connector odbc to elasticsearch without having X-Pack installed? Thank you, Francisca

---

## [Related search in elasticsearch](https://discuss.elastic.co/t/related-search-in-elasticsearch/171469)

<div class="topic-metadata">

**Author:** [@anasbk](https://discuss.elastic.co/u/anasbk)\
**Replies:** 7\
**Last updated:** [March 8, 2019, 4:11pm UTC](https://discuss.elastic.co/t/related-search-in-elasticsearch/171469 "2019-03-08T16:11:51Z")

</div>

I'm looking for a convenient way to search for related words to a term. For example, If I search for the word "washer", I should be getting related search terms like "dryer" with the lower score thank washer results, It …

---

## [How to put Geo\_type mapping with JsonObject](https://discuss.elastic.co/t/how-to-put-geo-type-mapping-with-jsonobject/171045)

<div class="topic-metadata">

**Author:** [@ChenSijia](https://discuss.elastic.co/u/ChenSijia)\
**Replies:** 10\
**Last updated:** [March 8, 2019, 4:11pm UTC](https://discuss.elastic.co/t/how-to-put-geo-type-mapping-with-jsonobject/171045 "2019-03-08T16:11:06Z")

</div>

Hi all ,does everyone knows how to use : IndexResponse createData(Client client, String jsonObject, String index, String type, String id); to put Geo\_type and other mappings? I used Map resolve this issue,but I also …

---

## [How to debug elastic search in an IDE](https://discuss.elastic.co/t/how-to-debug-elastic-search-in-an-ide/53159)

<div class="topic-metadata">

**Author:** [@adityasinghraghav](https://discuss.elastic.co/u/adityasinghraghav)\
**Replies:** 5\
**Last updated:** [March 8, 2019, 2:50pm UTC](https://discuss.elastic.co/t/how-to-debug-elastic-search-in-an-ide/53159 "2019-03-08T14:50:41Z")

</div>

I'm trying to learn the internal workings of ES. How can I get ES running on the IDEA ide ?

---

## [Supress the Watcher alerts for some time](https://discuss.elastic.co/t/supress-the-watcher-alerts-for-some-time/171517)

<div class="topic-metadata">

**Author:** [@chandra0651](https://discuss.elastic.co/u/chandra0651)\
**Replies:** 0\
**Last updated:** [March 8, 2019, 2:48pm UTC](https://discuss.elastic.co/t/supress-the-watcher-alerts-for-some-time/171517 "2019-03-08T14:48:05Z")

</div>

Hello , I am not sure if it question under elastic search category but i didn't find any category for watchers or X pack. We have a watcher setup for CPU utilization based up on the metric beat. Every day a job runs on …

---

## [Encryption general questions](https://discuss.elastic.co/t/encryption-general-questions/171012)

<div class="topic-metadata">

**Author:** [@rugenl](https://discuss.elastic.co/u/rugenl)\
**Replies:** 2\
**Last updated:** [March 8, 2019, 2:08pm UTC](https://discuss.elastic.co/t/encryption-general-questions/171012 "2019-03-08T14:08:35Z")

</div>

I'm working on a stack design and have some questions about various ways others have setup encryption. We are an .edu, so we can get unlimited InCommon certificates for no additional cost. For node-to-node encryption…

---

## [Sending multiple \_count requests in one go](https://discuss.elastic.co/t/sending-multiple-count-requests-in-one-go/171456)

<div class="topic-metadata">

**Author:** [@Yuval\_Khalifa](https://discuss.elastic.co/u/Yuval_Khalifa)\
**Replies:** 16\
**Last updated:** [March 8, 2019, 1:43pm UTC](https://discuss.elastic.co/t/sending-multiple-count-requests-in-one-go/171456 "2019-03-08T13:43:48Z")

</div>

Is it possible to send multiple requests to the \_count API in one go? I saw this post https://discuss.elastic.co/t/does-count-api-support-searching-by-multiple-terms-and-return-multiple-counts/10183/2 but from what I can…

---

## [Dynamic mapping all fields as string](https://discuss.elastic.co/t/dynamic-mapping-all-fields-as-string/171490)

<div class="topic-metadata">

**Author:** [@srikanthkadem](https://discuss.elastic.co/u/srikanthkadem)\
**Replies:** 1\
**Last updated:** [March 8, 2019, 1:18pm UTC](https://discuss.elastic.co/t/dynamic-mapping-all-fields-as-string/171490 "2019-03-08T13:18:03Z")

</div>

Hi, I am using dynamic mapping, to enable partial search I am adding \* at end of user entered keyword. the problem is this approach is only searching in string/keyword fields. to overcome this limitation, i want to stor…

---

## [How to integrate Elasticsearch and PgSQL?](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-and-pgsql/171494)

<div class="topic-metadata">

**Author:** [@Danyal\_Tarik](https://discuss.elastic.co/u/Danyal_Tarik)\
**Replies:** 1\
**Last updated:** [March 8, 2019, 1:16pm UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-and-pgsql/171494 "2019-03-08T13:16:30Z")

</div>

I have to push data from PgSQL to Elasticsearch? Any other method than CLI for indexing

---

## [Exact term count search help needed](https://discuss.elastic.co/t/exact-term-count-search-help-needed/171225)

<div class="topic-metadata">

**Author:** [@Teddis](https://discuss.elastic.co/u/Teddis)\
**Replies:** 6\
**Last updated:** [March 8, 2019, 12:34pm UTC](https://discuss.elastic.co/t/exact-term-count-search-help-needed/171225 "2019-03-08T12:34:05Z")

</div>

I need to be able to find exact text matches, not raw matches so I can take advantage of fuzzy matching. For example, consider these documents: doc1.name = "cheese pizza" doc2.name = "kid's cheese pizza" doc3.name = "…

---

## [Elasticsearch Bulk Update API failing due to wrong input](https://discuss.elastic.co/t/elasticsearch-bulk-update-api-failing-due-to-wrong-input/171462)

<div class="topic-metadata">

**Author:** [@prasad.ram1431](https://discuss.elastic.co/u/prasad.ram1431)\
**Replies:** 3\
**Last updated:** [March 8, 2019, 12:49pm UTC](https://discuss.elastic.co/t/elasticsearch-bulk-update-api-failing-due-to-wrong-input/171462 "2019-03-08T12:49:18Z")

</div>

Hi All, Could you please let me if the below scenario is whether expected behaviour. Scenario: POST \_bulk { "update" : { "\_index" : "test", "\_type" : "\_doc", "\_id" : "2" } } { "doc" : {"field2" : "value2"} } { "update…

---

## [Pointing index name to alias](https://discuss.elastic.co/t/pointing-index-name-to-alias/171267)

<div class="topic-metadata">

**Author:** [@Chelambarasan\_CR](https://discuss.elastic.co/u/Chelambarasan_CR)\
**Replies:** 17\
**Last updated:** [March 8, 2019, 12:25pm UTC](https://discuss.elastic.co/t/pointing-index-name-to-alias/171267 "2019-03-08T12:25:20Z")

</div>

Hi, I would like to point alias name in indexing to update a document in multiple daily indices using logstash with the id of the document. But when i provide the alias name it throws error and when i give index name w…

---

## [Elasticsearch status is going to be red status when i add index](https://discuss.elastic.co/t/elasticsearch-status-is-going-to-be-red-status-when-i-add-index/170587)

<div class="topic-metadata">

**Author:** [@dev1](https://discuss.elastic.co/u/dev1)\
**Replies:** 2\
**Last updated:** [March 8, 2019, 12:16pm UTC](https://discuss.elastic.co/t/elasticsearch-status-is-going-to-be-red-status-when-i-add-index/170587 "2019-03-08T12:16:19Z")

</div>

i use this api for check http://localhost:9200/\_cluster/health?pretty Output: { "cluster\_name" : "elasticsearch", "status" : "red", "timed\_out" : false, "number\_of\_nodes" : 1, "number\_of\_data\_nodes" : 1, "active…

---

## [Scroll in top hits aggregation](https://discuss.elastic.co/t/scroll-in-top-hits-aggregation/171468)

<div class="topic-metadata">

**Author:** [@bard0x](https://discuss.elastic.co/u/bard0x)\
**Replies:** 2\
**Last updated:** [March 8, 2019, 12:10pm UTC](https://discuss.elastic.co/t/scroll-in-top-hits-aggregation/171468 "2019-03-08T12:10:07Z")

</div>

Hi everyone, I have a question: it's possible to use the scroll feature in a top hits aggregation? I have many documents and I would to load its with a pagination. Thank's in advance for the replies

---

## [Elasticsearch cluster redundancy](https://discuss.elastic.co/t/elasticsearch-cluster-redundancy/171409)

<div class="topic-metadata">

**Author:** [@neven.trelec](https://discuss.elastic.co/u/neven.trelec)\
**Replies:** 2\
**Last updated:** [March 8, 2019, 11:33am UTC](https://discuss.elastic.co/t/elasticsearch-cluster-redundancy/171409 "2019-03-08T11:33:09Z")

</div>

Hello, we are facing a challenge with the redundancy of elasticsearch cluster. Our cluster consists of 2 VNFs where each VNF consists of 3 master elasticsearch VMs, 6 data elasticsearch VMs and 3 ingest elasticsearch VM…

---

## [Deprecated setting, where is it?](https://discuss.elastic.co/t/deprecated-setting-where-is-it/171336)

<div class="topic-metadata">

**Author:** [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Replies:** 13\
**Last updated:** [March 8, 2019, 11:16am UTC](https://discuss.elastic.co/t/deprecated-setting-where-is-it/171336 "2019-03-08T11:16:35Z")

</div>

I never had 5.x version. started from 6.2. now I am on 6.6.1 I still get following in my log "deprecation.log" Deprecated field \[template\] used, replaced by \[index\_patterns\] Where do I fix this?

---

## [Elasticsearch.esplugin - ES Gradle Build Tools: integTestRunner failing](https://discuss.elastic.co/t/elasticsearch-esplugin-es-gradle-build-tools-integtestrunner-failing/168899)

<div class="topic-metadata">

**Author:** [@Thales\_Valias](https://discuss.elastic.co/u/Thales_Valias)\
**Replies:** 3\
**Last updated:** [March 8, 2019, 11:10am UTC](https://discuss.elastic.co/t/elasticsearch-esplugin-es-gradle-build-tools-integtestrunner-failing/168899 "2019-03-08T11:10:29Z")

</div>

Context: I'm trying to implement an ES Ingest Processor plugin through this cookiecutter template: GitHub - spinscale/cookiecutter-elasticsearch-ingest-processor: A cookiecutter template for an elasticsearch ingest proc…

---

## [Elasticsearch - How to find similarity between 2 arrays?](https://discuss.elastic.co/t/elasticsearch-how-to-find-similarity-between-2-arrays/171239)

<div class="topic-metadata">

**Author:** [@aditisrinivas97](https://discuss.elastic.co/u/aditisrinivas97)\
**Replies:** 4\
**Last updated:** [March 8, 2019, 10:46am UTC](https://discuss.elastic.co/t/elasticsearch-how-to-find-similarity-between-2-arrays/171239 "2019-03-08T10:46:07Z")

</div>

I have an array of integers stored in ES say : \[1,2,3,4,5\] Now my query array is \[1,2,3,7,8\] I want to be able to get a score of how similar the two arrays are. For example, Array in ES - \[1,2,3,4,5\] Query 1 - \[1,2,…

---

## [Does the performance increases when Rollover API is used?](https://discuss.elastic.co/t/does-the-performance-increases-when-rollover-api-is-used/171467)

<div class="topic-metadata">

**Author:** [@nikhil.k](https://discuss.elastic.co/u/nikhil.k)\
**Replies:** 1\
**Last updated:** [March 8, 2019, 10:37am UTC](https://discuss.elastic.co/t/does-the-performance-increases-when-rollover-api-is-used/171467 "2019-03-08T10:37:04Z")

</div>

Hi, I want to know whether the performance is increased or decreased when rollover API is used. Regards Nikhil Kapoor

---

## [Nested Type in Kibana](https://discuss.elastic.co/t/nested-type-in-kibana/169980)

<div class="topic-metadata">

**Author:** [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\
**Replies:** 8\
**Last updated:** [March 8, 2019, 9:26am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980 "2019-03-08T09:26:50Z")

</div>

Hi I'm using Kibana 5.6.13 and I'm having nested type as below { "test": { "mappings": { "sessions": { "properties": { "appdata": { "type": "nested", "properties": { "accessType": {…

---

## [How to take JMap dump inside elasticsearch docker container?](https://discuss.elastic.co/t/how-to-take-jmap-dump-inside-elasticsearch-docker-container/171363)

<div class="topic-metadata">

**Author:** [@karthikeayan](https://discuss.elastic.co/u/karthikeayan)\
**Replies:** 3\
**Last updated:** [March 8, 2019, 9:21am UTC](https://discuss.elastic.co/t/how-to-take-jmap-dump-inside-elasticsearch-docker-container/171363 "2019-03-08T09:21:56Z")

</div>

I am running elasticsearch using docker container, and i want to take the heap dump of the elasticsearch. When I exec inside the container, I couldn't find jmap inside it. I tried installing openjdk8 package since the …

---

## [Aggregation based on Groups of Data](https://discuss.elastic.co/t/aggregation-based-on-groups-of-data/171440)

<div class="topic-metadata">

**Author:** [@vkandiva](https://discuss.elastic.co/u/vkandiva)\
**Replies:** 1\
**Last updated:** [March 8, 2019, 9:18am UTC](https://discuss.elastic.co/t/aggregation-based-on-groups-of-data/171440 "2019-03-08T09:18:44Z")

</div>

Suppose I have a field with values like: Junior Developer Senior Developer Database Developer Product Manager Senior Manager Scrum Manager And say if I have virtual groups based on this data like Developer: (Jun…

---

## [\[NodeJS\] Error socket hang up, No Living connections](https://discuss.elastic.co/t/nodejs-error-socket-hang-up-no-living-connections/170025)

<div class="topic-metadata">

**Author:** [@lfallet](https://discuss.elastic.co/u/lfallet)\
**Replies:** 1\
**Last updated:** [March 8, 2019, 9:05am UTC](https://discuss.elastic.co/t/nodejs-error-socket-hang-up-no-living-connections/170025 "2019-03-08T09:05:01Z")

</div>

Elasticsearch version : 6.4.3, deployed in ElasticCloud Elasticsearch Node package version : 15.2.0 We're experiencing recurring errors: Elasticsearch ERROR: 2019-02-26T13:31:11Z Error: Request error, retrying POS…

---

## [How can i retrive value in milliseconds format on range filter?](https://discuss.elastic.co/t/how-can-i-retrive-value-in-milliseconds-format-on-range-filter/171420)

<div class="topic-metadata">

**Author:** [@matheuslins](https://discuss.elastic.co/u/matheuslins)\
**Replies:** 1\
**Last updated:** [March 8, 2019, 8:51am UTC](https://discuss.elastic.co/t/how-can-i-retrive-value-in-milliseconds-format-on-range-filter/171420 "2019-03-08T08:51:01Z")

</div>

I have this example, where I'm trying to get a doc value inside a range filter. Someone can help me? ...filter('range', \*\*{ 'debts.ocurrenceDate': { 'gte': "doc\['eventDate…

---

## [What is the usage of translate API?](https://discuss.elastic.co/t/what-is-the-usage-of-translate-api/171428)

<div class="topic-metadata">

**Author:** [@nikhil.k](https://discuss.elastic.co/u/nikhil.k)\
**Replies:** 2\
**Last updated:** [March 8, 2019, 8:43am UTC](https://discuss.elastic.co/t/what-is-the-usage-of-translate-api/171428 "2019-03-08T08:43:00Z")

</div>

Hi All, Can anyone let me know what is proper usage of SQL Translate API. I am following the below given link: https://www.elastic.co/guide/en/elasticsearch/reference/6.4/sql-translate.html#sql-translate Regards Nik…

---

## [Creating a High Throughput Elasticsearch cluster](https://discuss.elastic.co/t/creating-a-high-throughput-elasticsearch-cluster/171449)

<div class="topic-metadata">

**Author:** [@kaysush](https://discuss.elastic.co/u/kaysush)\
**Replies:** 0\
**Last updated:** [March 8, 2019, 8:10am UTC](https://discuss.elastic.co/t/creating-a-high-throughput-elasticsearch-cluster/171449 "2019-03-08T08:10:46Z")

</div>

We are in process of implementing Elasticsearch as a search solution in our organization. For the POC we implemented a 3-Node cluster ( each node with 16 VCores and 60 GB RAM and 6 \* 375GB SSDs) with all the nodes acting…

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

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