# Elasticsearch

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

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

**Page:** 1931

---

## [How to handle many indices?](https://discuss.elastic.co/t/how-to-handle-many-indices/102803)

<div class="topic-metadata">

**Author:** [@wyukawa](https://discuss.elastic.co/u/wyukawa)\
**Replies:** 7\
**Last updated:** [October 5, 2017, 10:37am UTC](https://discuss.elastic.co/t/how-to-handle-many-indices/102803 "2017-10-05T10:37:49Z")

</div>

Hello, I'm using Elasticsearch 5.6.2 which has 16 nodes and more than 800 indices and 20,000 shards. If I change configuration and restart elasticsearch, the following log continues for a long time(more than 2 hours) …

---

## [No more local transport on 6.0.x](https://discuss.elastic.co/t/no-more-local-transport-on-6-0-x/102416)

<div class="topic-metadata">

**Author:** [@Simone\_Scarduzio](https://discuss.elastic.co/u/Simone_Scarduzio)\
**Replies:** 3\
**Last updated:** [October 5, 2017, 10:31am UTC](https://discuss.elastic.co/t/no-more-local-transport-on-6-0-x/102416 "2017-10-05T10:31:59Z")

</div>

Hi, I'm trying to run ES from my IDE. Everything is fine with 5.x using transport.type: local setting. But as soon as I change to 6.0.0-beta2 I get this exception: \[2017-10-02T10:43:49,295\]\[INFO \]\[o.e.n.Node …

---

## [Need to index filesever info into the elasticsearch](https://discuss.elastic.co/t/need-to-index-filesever-info-into-the-elasticsearch/102794)

<div class="topic-metadata">

**Author:** [@RohanKumbhar](https://discuss.elastic.co/u/RohanKumbhar)\
**Replies:** 3\
**Last updated:** [October 5, 2017, 10:25am UTC](https://discuss.elastic.co/t/need-to-index-filesever-info-into-the-elasticsearch/102794 "2017-10-05T10:25:46Z")

</div>

Hi Team, I have one use case where i want to collect the fileserver information like Number of Unique Files, File Meta data (like file size, creation\_date , modified time etc) and number of users etc. Is there any way…

---

## [Use filter\_path in High Level Rest API](https://discuss.elastic.co/t/use-filter-path-in-high-level-rest-api/102657)

<div class="topic-metadata">

**Author:** [@hatim.stovewala](https://discuss.elastic.co/u/hatim.stovewala)\
**Replies:** 4\
**Last updated:** [October 5, 2017, 10:12am UTC](https://discuss.elastic.co/t/use-filter-path-in-high-level-rest-api/102657 "2017-10-05T10:12:13Z")

</div>

Saw this post regarding filter\_path. I'm aware that Java API does not support Response filtering because it is done on Rest layer and Java API use transport layer. So my question is does High level Rest API support this …

---

## [How to use VisualVM remote moniter Es 5.5](https://discuss.elastic.co/t/how-to-use-visualvm-remote-moniter-es-5-5/101284)

<div class="topic-metadata">

**Author:** [@zhongyi8307](https://discuss.elastic.co/u/zhongyi8307)\
**Replies:** 1\
**Last updated:** [October 5, 2017, 9:40am UTC](https://discuss.elastic.co/t/how-to-use-visualvm-remote-moniter-es-5-5/101284 "2017-10-05T09:40:01Z")

</div>

in my jvm.option -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=8105 -Dcom.sun.management.jmxremote.authenticate=false #-Dcom.sun.management.jmxremote.local.only=false -Dcom.sun.management.jmxrem…

---

## [Delete all indices with specific pre-fix using JAVA APIs](https://discuss.elastic.co/t/delete-all-indices-with-specific-pre-fix-using-java-apis/102738)

<div class="topic-metadata">

**Author:** [@hitesh-inbetween](https://discuss.elastic.co/u/hitesh-inbetween)\
**Replies:** 6\
**Last updated:** [October 5, 2017, 9:14am UTC](https://discuss.elastic.co/t/delete-all-indices-with-specific-pre-fix-using-java-apis/102738 "2017-10-05T09:14:26Z")

</div>

Hi all, Does anyone know how to perform curl -XDELETE "http://localhost:9200/test\_\*;" via JAVA APIs? I found the way to delete a particular index, but I have multiple indices with a particular prefix and a special ev…

---

## [Elasticsearch indices closed?](https://discuss.elastic.co/t/elasticsearch-indices-closed/102790)

<div class="topic-metadata">

**Author:** [@varundbest](https://discuss.elastic.co/u/varundbest)\
**Replies:** 3\
**Last updated:** [October 5, 2017, 7:12am UTC](https://discuss.elastic.co/t/elasticsearch-indices-closed/102790 "2017-10-05T07:12:41Z")

</div>

curl http://localhost:9200/\_cat/indices close .kibana a5uRVhCtRnWFGbTCKh7AyA close report 4b4yfjgsRfKDZ7a5kz2X4g close varun v392Yg4LRcCx7VBkpNhb9A close myindex e8f-VNuWSRKfXJag0oshLw …

---

## [Reindex changing types](https://discuss.elastic.co/t/reindex-changing-types/102808)

<div class="topic-metadata">

**Author:** [@Alejandro\_Arrojo](https://discuss.elastic.co/u/Alejandro_Arrojo)\
**Replies:** 4\
**Last updated:** [October 5, 2017, 8:56am UTC](https://discuss.elastic.co/t/reindex-changing-types/102808 "2017-10-05T08:56:42Z")

</div>

Hello! It's possible to reindex, changing datatype of a field? Or it's not possible and I have to delete bad fields and reindex without them? Thanks so much.

---

## [Elastic 2.2.0 how to find the query](https://discuss.elastic.co/t/elastic-2-2-0-how-to-find-the-query/102555)

<div class="topic-metadata">

**Author:** [@jeannot](https://discuss.elastic.co/u/jeannot)\
**Replies:** 6\
**Last updated:** [October 5, 2017, 7:44am UTC](https://discuss.elastic.co/t/elastic-2-2-0-how-to-find-the-query/102555 "2017-10-05T07:44:41Z")

</div>

Hi all, When looking to slow query logs, I found some binary. I try to find in documentation how to make a link between a query and this binary. Any idea? regards Jean-Luc Example: \[2016-12-22 08:53:35,630\]\[TRACE\]…

---

## [API changes report for Elasticsearch](https://discuss.elastic.co/t/api-changes-report-for-elasticsearch/102647)

<div class="topic-metadata">

**Author:** [@lvc](https://discuss.elastic.co/u/lvc)\
**Replies:** 4\
**Last updated:** [October 5, 2017, 7:35am UTC](https://discuss.elastic.co/t/api-changes-report-for-elasticsearch/102647 "2017-10-05T07:35:48Z")

</div>

Hi, I'd like to share my results on API changes analysis for the library: https://abi-laboratory.pro/java/tracker/timeline/elasticsearch/ The report is generated by the https://github.com/lvc/japi-compliance-checker to…

---

## [How to search keyword fields with case insensitive](https://discuss.elastic.co/t/how-to-search-keyword-fields-with-case-insensitive/101704)

<div class="topic-metadata">

**Author:** [@ajit](https://discuss.elastic.co/u/ajit)\
**Replies:** 1\
**Last updated:** [October 5, 2017, 6:47am UTC](https://discuss.elastic.co/t/how-to-search-keyword-fields-with-case-insensitive/101704 "2017-10-05T06:47:25Z")

</div>

Please provide me solution for case insensitive search on keyword field. Like if I am searching for ajit it should display AJIT and all ajit available in elasticsearch data. Currently it giving me exact match.

---

## [Where does Elastic search stores the data in windows machine](https://discuss.elastic.co/t/where-does-elastic-search-stores-the-data-in-windows-machine/102064)

<div class="topic-metadata">

**Author:** [@Thiyagarajan](https://discuss.elastic.co/u/Thiyagarajan)\
**Replies:** 8\
**Last updated:** [October 5, 2017, 5:37am UTC](https://discuss.elastic.co/t/where-does-elastic-search-stores-the-data-in-windows-machine/102064 "2017-10-05T05:37:39Z")

</div>

Hi, We have downloaded ELK and unzipped them under c:\\Softwares in windows machine. We have started the Elasticsearch, Kibana and Logstash with respective .bat files in bin directory. Filebeat is installed in our SIT s…

---

## [Geo Bounding Box Filter](https://discuss.elastic.co/t/geo-bounding-box-filter/102785)

<div class="topic-metadata">

**Author:** [@Atul\_Harsha](https://discuss.elastic.co/u/Atul_Harsha)\
**Replies:** 4\
**Last updated:** [October 5, 2017, 5:36am UTC](https://discuss.elastic.co/t/geo-bounding-box-filter/102785 "2017-10-05T05:36:52Z")

</div>

Hi , While trying geo\_bounding\_box following error is generated. Can you please help me out in resolving the error Code: GET /attractions/restaurant/\_search { "query": { "filtered": { "filt…

---

## [Compare solr generated index with elastic](https://discuss.elastic.co/t/compare-solr-generated-index-with-elastic/102707)

<div class="topic-metadata">

**Author:** [@abhishekash](https://discuss.elastic.co/u/abhishekash)\
**Replies:** 3\
**Last updated:** [October 5, 2017, 5:33am UTC](https://discuss.elastic.co/t/compare-solr-generated-index-with-elastic/102707 "2017-10-05T05:33:57Z")

</div>

Hello, We had solr as our search back end and have been moving towards elastic search . Now, while generating index on a dataset with elastic 5.2.2 generated index of size 17 GB solr on lucene 4.7.x generated index …

---

## [Is it possible to customize length of suggested options\[n\].text for completion suggestor?](https://discuss.elastic.co/t/is-it-possible-to-customize-length-of-suggested-options-n-text-for-completion-suggestor/102762)

<div class="topic-metadata">

**Author:** [@Jaspreet\_Singh](https://discuss.elastic.co/u/Jaspreet_Singh)\
**Replies:** 1\
**Last updated:** [October 5, 2017, 4:43am UTC](https://discuss.elastic.co/t/is-it-possible-to-customize-length-of-suggested-options-n-text-for-completion-suggestor/102762 "2017-10-05T04:43:44Z")

</div>

While using the completion suggestor, Im noticing the length in chars of options\[n\].text is limited to 50 chars. If im doing autocomplete on Titles field, I need the suggester to return the ENTIRE title field not truncat…

---

## [Polygon geo\_shape filter error question InvalidShapeException\[Self-intersection at or near point](https://discuss.elastic.co/t/polygon-geo-shape-filter-error-question-invalidshapeexception-self-intersection-at-or-near-point/102781)

<div class="topic-metadata">

**Author:** [@Richard\_Scott](https://discuss.elastic.co/u/Richard_Scott)\
**Replies:** 0\
**Last updated:** [October 5, 2017, 1:18am UTC](https://discuss.elastic.co/t/polygon-geo-shape-filter-error-question-invalidshapeexception-self-intersection-at-or-near-point/102781 "2017-10-05T01:18:31Z")

</div>

Hi, I have been trying to use a polygon query. Elasticsearch 1.5 on AWS. The mapping is :- Mappings customer shiptostring sitegeo\_shape client.search({ index: 'ramcar', type: 'customer', body: { "query":{ …

---

## [Trouble with AuthenticationService between es nodes](https://discuss.elastic.co/t/trouble-with-authenticationservice-between-es-nodes/102685)

<div class="topic-metadata">

**Author:** [@111126](https://discuss.elastic.co/u/111126)\
**Replies:** 3\
**Last updated:** [October 4, 2017, 11:24pm UTC](https://discuss.elastic.co/t/trouble-with-authenticationservice-between-es-nodes/102685 "2017-10-04T23:24:48Z")

</div>

I have two server. First server: I fresh install es 5.6.2. with next config: cluster.name: rsl-es-clucter node.name: es-vm01.siem-node1-master path.data: /opt/elasticsearch/es-vm01.siem-node1-master n…

---

## [Number of upsert operations per minute](https://discuss.elastic.co/t/number-of-upsert-operations-per-minute/102768)

<div class="topic-metadata">

**Author:** [@revanthsegu](https://discuss.elastic.co/u/revanthsegu)\
**Replies:** 1\
**Last updated:** [October 4, 2017, 10:37pm UTC](https://discuss.elastic.co/t/number-of-upsert-operations-per-minute/102768 "2017-10-04T22:37:38Z")

</div>

Hi, I am working on Elastic Search version 5.1.2, I wanted to find number of upsert operations processed by my Elastic Search per minute Is there anyone who has done something similar ? Thanks, Revanth.

---

## [ES 1.7.3 Docker Swarm publish\_host binding to wrong address](https://discuss.elastic.co/t/es-1-7-3-docker-swarm-publish-host-binding-to-wrong-address/102770)

<div class="topic-metadata">

**Author:** [@tapuzzo](https://discuss.elastic.co/u/tapuzzo)\
**Replies:** 0\
**Last updated:** [October 4, 2017, 10:30pm UTC](https://discuss.elastic.co/t/es-1-7-3-docker-swarm-publish-host-binding-to-wrong-address/102770 "2017-10-04T22:30:10Z")

</div>

Not too sure if anyone will have anything for this, but I'm trying to get ES 1.7.3 running in a single-node cluster with Activiti (workflow engine) and am having trouble. The vendor (Alfresco) doesn't yet support a newe…

---

## [Elastic Search Cluster deployment failure on Azure](https://discuss.elastic.co/t/elastic-search-cluster-deployment-failure-on-azure/102617)

<div class="topic-metadata">

**Author:** [@rangv](https://discuss.elastic.co/u/rangv)\
**Replies:** 1\
**Last updated:** [October 4, 2017, 10:17pm UTC](https://discuss.elastic.co/t/elastic-search-cluster-deployment-failure-on-azure/102617 "2017-10-04T22:17:54Z")

</div>

We are seeing the following error creating ES cluster on Azure in a VNET with Express route. Cluster was deployed using azure market place : https://azuremarketplace.microsoft.com/en-us/marketplace/apps/elastic.elasticse…

---

## [BulkProcessor Indexing Performance](https://discuss.elastic.co/t/bulkprocessor-indexing-performance/102761)

<div class="topic-metadata">

**Author:** [@Sahibdeep\_Singh](https://discuss.elastic.co/u/Sahibdeep_Singh)\
**Replies:** 0\
**Last updated:** [October 4, 2017, 8:57pm UTC](https://discuss.elastic.co/t/bulkprocessor-indexing-performance/102761 "2017-10-04T20:57:58Z")

</div>

Hi, We are scheduling ES BulkUpsert using the ES 5.6 RESTHighLevel client to index documents every hour. Approximate total bulk size is 36k every hour. This is the configuration i am using:CONCURRENT\_REQUESTS = 30,BULK…

---

## [Watcher action - Dynamic index creation](https://discuss.elastic.co/t/watcher-action-dynamic-index-creation/101759)

<div class="topic-metadata">

**Author:** [@santhosh](https://discuss.elastic.co/u/santhosh)\
**Replies:** 3\
**Last updated:** [October 4, 2017, 8:39pm UTC](https://discuss.elastic.co/t/watcher-action-dynamic-index-creation/101759 "2017-10-04T20:39:37Z")

</div>

I have a watcher that sends output to another index named "newindex". How can I set the dynamic value to target index such as date? Following approach doesn't work. "actions": { "index\_payload": { "index": { …

---

## [Download the contents of es index to csv](https://discuss.elastic.co/t/download-the-contents-of-es-index-to-csv/102741)

<div class="topic-metadata">

**Author:** [@elkuserh](https://discuss.elastic.co/u/elkuserh)\
**Replies:** 1\
**Last updated:** [October 4, 2017, 6:34pm UTC](https://discuss.elastic.co/t/download-the-contents-of-es-index-to-csv/102741 "2017-10-04T18:34:05Z")

</div>

Hi Team, Is there a plugin, which can assist me in downloading the contents of an elasticsearch index into a csv file?. We currently are at elk stack 5.5.0.

---

## [ES-Hadoop overwrite the external table](https://discuss.elastic.co/t/es-hadoop-overwrite-the-external-table/101540)

<div class="topic-metadata">

**Author:** [@EvelynC](https://discuss.elastic.co/u/EvelynC)\
**Replies:** 4\
**Last updated:** [October 4, 2017, 6:21pm UTC](https://discuss.elastic.co/t/es-hadoop-overwrite-the-external-table/101540 "2017-10-04T18:21:27Z")

</div>

Hi everyone, According to all I know, the external table which is just a link to the data stored in ES, and we can only insert appendant data or delete all of them. Is there any way to overwrite the data? such as just d…

---

## [Not able to see Kibana Dashboard Locally using kibana 5.5.1](https://discuss.elastic.co/t/not-able-to-see-kibana-dashboard-locally-using-kibana-5-5-1/102743)

<div class="topic-metadata">

**Author:** [@Rohit\_Dogra](https://discuss.elastic.co/u/Rohit_Dogra)\
**Replies:** 0\
**Last updated:** [October 4, 2017, 5:54pm UTC](https://discuss.elastic.co/t/not-able-to-see-kibana-dashboard-locally-using-kibana-5-5-1/102743 "2017-10-04T17:54:14Z")

</div>

Hi I'm trying to run kibana 5.5.1 docker image locally i have done docker pull docker.elastic.co/kibana/kibana:5.5.1 To run this docker image i'm doing docker run --name dev-kibana -e ELASTICSEARCH\_URL=http://10.0.32…

---

## [SQL-Querys](https://discuss.elastic.co/t/sql-querys/102620)

<div class="topic-metadata">

**Author:** [@seb\_ma](https://discuss.elastic.co/u/seb_ma)\
**Replies:** 2\
**Last updated:** [October 4, 2017, 4:31pm UTC](https://discuss.elastic.co/t/sql-querys/102620 "2017-10-04T16:31:37Z")

</div>

Hey Guys, for a project in university we like to benchmark ES with TPC-DS. I know its a tool for RDMS, but we still want to try. So it is necessary to run SQL-Querys on EL. In the past many people asked when this futu…

---

## [Spark code to get select firelds from ES](https://discuss.elastic.co/t/spark-code-to-get-select-firelds-from-es/101179)

<div class="topic-metadata">

**Author:** [@kedarsdixit](https://discuss.elastic.co/u/kedarsdixit)\
**Replies:** 2\
**Last updated:** [October 4, 2017, 4:13pm UTC](https://discuss.elastic.co/t/spark-code-to-get-select-firelds-from-es/101179 "2017-10-04T16:13:21Z")

</div>

Hi, I want to get only select fields from ES using Spark ES connector. I have done some code which is fetching all the documents matching given index as below: JavaPairRDD\<String, Map\<String, Object\>\> esRDD = JavaEsSp…

---

## [Query Syntax question](https://discuss.elastic.co/t/query-syntax-question/102728)

<div class="topic-metadata">

**Author:** [@ajay\_bh111](https://discuss.elastic.co/u/ajay_bh111)\
**Replies:** 0\
**Last updated:** [October 4, 2017, 3:34pm UTC](https://discuss.elastic.co/t/query-syntax-question/102728 "2017-10-04T15:34:58Z")

</div>

I have index with following info as seen in Kibana query json: { "\_index": "es5dbmon\_10", "\_type": "metrics", "\_id": "AV7nxxU3nLFmflBF65oY", "\_version": 1, "\_score": null, "\_source": { "@timestamp": "2017-10-04T…

---

## [.keyword empty](https://discuss.elastic.co/t/keyword-empty/100363)

<div class="topic-metadata">

**Author:** [@surj08](https://discuss.elastic.co/u/surj08)\
**Replies:** 4\
**Last updated:** [October 4, 2017, 3:03pm UTC](https://discuss.elastic.co/t/keyword-empty/100363 "2017-10-04T15:03:59Z")

</div>

I'm having an issue with something related to this but, they get off that topic. I'm using the logstash default template and have the .keyword field but, it's empty and I'd like to visualize on the data. The documentatio…

---

## [Script Based Sorting & query-based score](https://discuss.elastic.co/t/script-based-sorting-query-based-score/102677)

<div class="topic-metadata">

**Author:** [@Pyppe](https://discuss.elastic.co/u/Pyppe)\
**Replies:** 1\
**Last updated:** [October 4, 2017, 3:00pm UTC](https://discuss.elastic.co/t/script-based-sorting-query-based-score/102677 "2017-10-04T15:00:29Z")

</div>

Hi. Is it possible to combine painless script-based sorting with default query-based score? What I'm after is this: { "query": { "simple\_query\_string": { "fields": \["name"\], "query": "foobar\*" } …

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

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