# Elasticsearch

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

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

**Page:** 1669

---

## [How to improve search performance](https://discuss.elastic.co/t/how-to-improve-search-performance/133949)

<div class="topic-metadata">

**Author:** [@khubacher](https://discuss.elastic.co/u/khubacher)\
**Replies:** 2\
**Last updated:** [June 1, 2018, 1:14pm UTC](https://discuss.elastic.co/t/how-to-improve-search-performance/133949 "2018-06-01T13:14:29Z")

</div>

I have 200m documents where half are marked (with a field) src = 1 and the other src = 2. When searching, on multiple fields (usually 6-8), the search time differs dramatically if the src is included. I realize that al…

---

## [Migration to ElasticSearch: Advices on how many shards, replicas and instance size](https://discuss.elastic.co/t/migration-to-elasticsearch-advices-on-how-many-shards-replicas-and-instance-size/133901)

<div class="topic-metadata">

**Author:** [@ViniciusSPaiva](https://discuss.elastic.co/u/ViniciusSPaiva)\
**Replies:** 4\
**Last updated:** [June 1, 2018, 1:02pm UTC](https://discuss.elastic.co/t/migration-to-elasticsearch-advices-on-how-many-shards-replicas-and-instance-size/133901 "2018-06-01T13:02:35Z")

</div>

Hello there! This is my first post on the forums and I'll be working with Elastic Search also for the first time, so bear with me a little :slight\_smile: We have a cloud application that indexes and searches file conte…

---

## [Elasticsearch.NET Disable ID inference](https://discuss.elastic.co/t/elasticsearch-net-disable-id-inference/133228)

<div class="topic-metadata">

**Author:** [@jeremysmith1](https://discuss.elastic.co/u/jeremysmith1)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 12:58pm UTC](https://discuss.elastic.co/t/elasticsearch-net-disable-id-inference/133228 "2018-06-01T12:58:26Z")

</div>

I have a collection of c# POCOs that I cannot modify. Some of them have a field called "id" that gets picked up as the \_id in the mapping. These obj have duplicate id, which causes the last inserted obj to upsert over th…

---

## [Requested Address Cannot Bind](https://discuss.elastic.co/t/requested-address-cannot-bind/134067)

<div class="topic-metadata">

**Author:** [@sunil\_sunny](https://discuss.elastic.co/u/sunil_sunny)\
**Replies:** 5\
**Last updated:** [June 1, 2018, 11:34am UTC](https://discuss.elastic.co/t/requested-address-cannot-bind/134067 "2018-06-01T11:34:06Z")

</div>

Hi team, When I am configuring network.host property in the elasticsearch.yml ,my es is not starting and i am getting below exceptions " Requested Address Cannot Bind." When i am commenting that line it was working …

---

## [Unhealthy cluster](https://discuss.elastic.co/t/unhealthy-cluster/132664)

<div class="topic-metadata">

**Author:** [@hummingbirb](https://discuss.elastic.co/u/hummingbirb)\
**Replies:** 1\
**Last updated:** [May 21, 2018, 2:07pm UTC](https://discuss.elastic.co/t/unhealthy-cluster/132664 "2018-05-21T14:07:46Z")

</div>

Hi, recently I've inherited elk stack which seems to be in unhealthy condition. There's only one node with all unassigned shards for which I'll be thankful if someone can tell me how to recover. Here's some info I've m…

---

## [Using Elastic Search Stack for monitoring Mbeans](https://discuss.elastic.co/t/using-elastic-search-stack-for-monitoring-mbeans/134194)

<div class="topic-metadata">

**Author:** [@vishnu.kumar](https://discuss.elastic.co/u/vishnu.kumar)\
**Replies:** 0\
**Last updated:** [June 1, 2018, 10:05am UTC](https://discuss.elastic.co/t/using-elastic-search-stack-for-monitoring-mbeans/134194 "2018-06-01T10:05:41Z")

</div>

Hello All, I am very new to elastic search. We are using IBM Applications (IBM Rational collaborative lifecycle management). IBM started to offer JMX and Mbeans within the applications for performance monitoring. these …

---

## [Connecting ES using RestHighLevelClient](https://discuss.elastic.co/t/connecting-es-using-resthighlevelclient/133970)

<div class="topic-metadata">

**Author:** [@psramkumar](https://discuss.elastic.co/u/psramkumar)\
**Replies:** 2\
**Last updated:** [June 1, 2018, 10:00am UTC](https://discuss.elastic.co/t/connecting-es-using-resthighlevelclient/133970 "2018-06-01T10:00:18Z")

</div>

for (int i = 0; i \< hostNames.length; i++) { HttpHost host = new HttpHost(hostNames\[i\] , 9200, "index\_name"); hosts\[i\] = host; } RestHighLevelClient client = new RestHighLevelClient(RestClient.builder(h…

---

## [Fuzzines AUTO](https://discuss.elastic.co/t/fuzzines-auto/134192)

<div class="topic-metadata">

**Author:** [@Vadim\_Klimenko](https://discuss.elastic.co/u/Vadim_Klimenko)\
**Replies:** 0\
**Last updated:** [June 1, 2018, 9:50am UTC](https://discuss.elastic.co/t/fuzzines-auto/134192 "2018-06-01T09:50:31Z")

</div>

fuzzines AUTO error massage. Elasticsearch 6.2.4 \[Selection\_005\]

---

## [Search field with special characters, reserved characters](https://discuss.elastic.co/t/search-field-with-special-characters-reserved-characters/133445)

<div class="topic-metadata">

**Author:** [@amanvermagbst](https://discuss.elastic.co/u/amanvermagbst)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 9:34am UTC](https://discuss.elastic.co/t/search-field-with-special-characters-reserved-characters/133445 "2018-06-01T09:34:54Z")

</div>

Client is having the elastic instance version 5.4.3 and we are restricted to the standard analyzer he is using. We need to query such that we get exact match for ex: if data has following business\_name: Soup Unlimited …

---

## [How to make a full text-query on date attribute in Elastic Search](https://discuss.elastic.co/t/how-to-make-a-full-text-query-on-date-attribute-in-elastic-search/133278)

<div class="topic-metadata">

**Author:** [@simonepontz](https://discuss.elastic.co/u/simonepontz)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 9:29am UTC](https://discuss.elastic.co/t/how-to-make-a-full-text-query-on-date-attribute-in-elastic-search/133278 "2018-06-01T09:29:09Z")

</div>

I have a document with a date type attribute (like the following) { "releaseDate": { "time": "1990-02-01T00:00:00+0000", } } I'm confident in doing some range query (date-math etc) so that if I'm looking for all…

---

## [ElasticSearch 6.2](https://discuss.elastic.co/t/elasticsearch-6-2/133108)

<div class="topic-metadata">

**Author:** [@neelam.mamtani](https://discuss.elastic.co/u/neelam.mamtani)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 9:24am UTC](https://discuss.elastic.co/t/elasticsearch-6-2/133108 "2018-06-01T09:24:44Z")

</div>

How can I update existing index mapping/settings by java high level rest client. I do not see PutMapping is released yet. Any pointer how to do that with current version. I tried to use lowlevel client with PUT method, …

---

## [Optimized keyword fields that only have integers](https://discuss.elastic.co/t/optimized-keyword-fields-that-only-have-integers/130612)

<div class="topic-metadata">

**Author:** [@ddorian43](https://discuss.elastic.co/u/ddorian43)\
**Replies:** 6\
**Last updated:** [June 1, 2018, 9:12am UTC](https://discuss.elastic.co/t/optimized-keyword-fields-that-only-have-integers/130612 "2018-06-01T09:12:59Z")

</div>

Hi, Does lucene / es optimize (or is there a way to config) keyword fields that are guaranteed to have only numbers and only need equality filtering (for inverted-index, doc-values, term dictionary etc) ? I remember \_i…

---

## [Elastica script isn't performing division](https://discuss.elastic.co/t/elastica-script-isnt-performing-division/134175)

<div class="topic-metadata">

**Author:** [@Islam\_Elshobokshy](https://discuss.elastic.co/u/Islam_Elshobokshy)\
**Replies:** 0\
**Last updated:** [June 1, 2018, 8:49am UTC](https://discuss.elastic.co/t/elastica-script-isnt-performing-division/134175 "2018-06-01T08:49:57Z")

</div>

I've got a script (Elastica) : $agg\_car-\>setScript(" doc\['field'\].value / doc\['field'\].size() "); that isn't performing the division. If I setScript as doc\['field'\].value it gives me 20, if I set it as doc\['field'\].s…

---

## [Setup-password file is not available upon new install](https://discuss.elastic.co/t/setup-password-file-is-not-available-upon-new-install/132086)

<div class="topic-metadata">

**Author:** [@skyluke.1987](https://discuss.elastic.co/u/skyluke.1987)\
**Replies:** 11\
**Last updated:** [June 1, 2018, 8:52am UTC](https://discuss.elastic.co/t/setup-password-file-is-not-available-upon-new-install/132086 "2018-06-01T08:52:26Z")

</div>

When I initially install x-pack, there is no "setup-password" file to set the password. Then I gotten a guide, trying to uninstall the package, and reinstall, it still not there. May I know is there any solution to it?

---

## [Use one aggregation to calculate another and return only the required aggregation](https://discuss.elastic.co/t/use-one-aggregation-to-calculate-another-and-return-only-the-required-aggregation/134171)

<div class="topic-metadata">

**Author:** [@siddharth\_jain](https://discuss.elastic.co/u/siddharth_jain)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 8:45am UTC](https://discuss.elastic.co/t/use-one-aggregation-to-calculate-another-and-return-only-the-required-aggregation/134171 "2018-06-01T08:45:49Z")

</div>

I am using a sum aggregation to find the minimum of all the sums. GET /prod\*/\_search { "size": 0, "aggs": { "buckets": { "terms": { "field": "city.keyword", "size": 10 }, "aggs…

---

## [Nested Array in Array](https://discuss.elastic.co/t/nested-array-in-array/134159)

<div class="topic-metadata">

**Author:** [@ktsigkounis](https://discuss.elastic.co/u/ktsigkounis)\
**Replies:** 2\
**Last updated:** [June 1, 2018, 8:31am UTC](https://discuss.elastic.co/t/nested-array-in-array/134159 "2018-06-01T08:31:57Z")

</div>

Hello all, I have to index a json to Elastic which look like the below format. My problem is that the key "variable" is array that contains json objects (I thought about "nested" datatype of Elastic) but some of those o…

---

## [Demo.elastic.co is dead?](https://discuss.elastic.co/t/demo-elastic-co-is-dead/134131)

<div class="topic-metadata">

**Author:** [@br14nb0](https://discuss.elastic.co/u/br14nb0)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 8:31am UTC](https://discuss.elastic.co/t/demo-elastic-co-is-dead/134131 "2018-06-01T08:31:02Z")

</div>

Do you have any other URLs that I can use for demo purpose with my company ? Thanks

---

## [Is there an error in this Elastic blog post on common terms?](https://discuss.elastic.co/t/is-there-an-error-in-this-elastic-blog-post-on-common-terms/133830)

<div class="topic-metadata">

**Author:** [@davidefiocco](https://discuss.elastic.co/u/davidefiocco)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 8:27am UTC](https://discuss.elastic.co/t/is-there-an-error-in-this-elastic-blog-post-on-common-terms/133830 "2018-06-01T08:27:22Z")

</div>

Hi! I was reading the post at Stop Stopping Stop Words: a Look at Common Terms Query | Elastic Blog In the blog, there's this sentence The “low frequency” list is rewritten into a Boolean Should clause (logical OR). …

---

## [Elasticsearch not showing filebeat index template](https://discuss.elastic.co/t/elasticsearch-not-showing-filebeat-index-template/134139)

<div class="topic-metadata">

**Author:** [@Meghna\_Mane](https://discuss.elastic.co/u/Meghna_Mane)\
**Replies:** 5\
**Last updated:** [June 1, 2018, 8:04am UTC](https://discuss.elastic.co/t/elasticsearch-not-showing-filebeat-index-template/134139 "2018-06-01T08:04:22Z")

</div>

Hi, I have just setup filebeat, ELK for prod. I have load filebeat manually using following command and it acknowledges true: curl -H 'Content-Type: application/json' -XPUT 'http://\<ES\_IP\>:9200/\_template/filebeat' -d…

---

## [JSON parsing errors when using Mustache Conditional](https://discuss.elastic.co/t/json-parsing-errors-when-using-mustache-conditional/134109)

<div class="topic-metadata">

**Author:** [@dmbaughman](https://discuss.elastic.co/u/dmbaughman)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 7:45am UTC](https://discuss.elastic.co/t/json-parsing-errors-when-using-mustache-conditional/134109 "2018-06-01T07:45:51Z")

</div>

Hey everyone. I'm new to Elasticsearch, and am trying to figure out how to use Search Templates. They seem like a very promising way to simplify client-size search requests. But when I try to upload a template that us…

---

## [Matchquery is unable to sort based on query](https://discuss.elastic.co/t/matchquery-is-unable-to-sort-based-on-query/134034)

<div class="topic-metadata">

**Author:** [@kish](https://discuss.elastic.co/u/kish)\
**Replies:** 3\
**Last updated:** [June 1, 2018, 7:32am UTC](https://discuss.elastic.co/t/matchquery-is-unable-to-sort-based-on-query/134034 "2018-06-01T07:32:03Z")

</div>

Hello - I am trying to execute a query which has match query (nodeid)+ sort(with date) + size(1). I am trying to get the out N curries the latest requried nodeid details. And this cscfcounter index will be getting upda…

---

## [Node unable to join elasticsearch cluster](https://discuss.elastic.co/t/node-unable-to-join-elasticsearch-cluster/134157)

<div class="topic-metadata">

**Author:** [@Bleyc](https://discuss.elastic.co/u/Bleyc)\
**Replies:** 4\
**Last updated:** [June 1, 2018, 7:30am UTC](https://discuss.elastic.co/t/node-unable-to-join-elasticsearch-cluster/134157 "2018-06-01T07:30:39Z")

</div>

Hello Folks! am kinda new to elastic to forgive me if i have asked something that is obvious, i am trying to set up a cluster on windows, i tried with two nodes of elastic version elasticsearch-6.2.3, all was well and …

---

## [A agg query?](https://discuss.elastic.co/t/a-agg-query/133844)

<div class="topic-metadata">

**Author:** [@TianYongwei](https://discuss.elastic.co/u/TianYongwei)\
**Replies:** 2\
**Last updated:** [June 1, 2018, 7:28am UTC](https://discuss.elastic.co/t/a-agg-query/133844 "2018-06-01T07:28:49Z")

</div>

i have some Social Data, such as weibo, twitter, they have same mapping. for example: { text:" i am a weibo", type:"weibo",name:"name1",fans:"1000" } { text:" i am a weibo 2", type:"weibo",name:"name2",fans:"10" } …

---

## [Difference between sqto and sfto](https://discuss.elastic.co/t/difference-between-sqto-and-sfto/133890)

<div class="topic-metadata">

**Author:** [@pratik.tari](https://discuss.elastic.co/u/pratik.tari)\
**Replies:** 5\
**Last updated:** [June 1, 2018, 7:00am UTC](https://discuss.elastic.co/t/difference-between-sqto-and-sfto/133890 "2018-06-01T07:00:45Z")

</div>

What is the difference between sqto and sfto. I assume sqto is search query operation per shard and sfto is fetching source of the document once we have document ids from search query operations. I cannot find anything …

---

## [Changing type for existed field](https://discuss.elastic.co/t/changing-type-for-existed-field/134141)

<div class="topic-metadata">

**Author:** [@oms1226](https://discuss.elastic.co/u/oms1226)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 5:59am UTC](https://discuss.elastic.co/t/changing-type-for-existed-field/134141 "2018-06-01T05:59:42Z")

</div>

I want to know how to change type for a existed field. But I have not found resolution. So, I add the new field to \_index as well as change from existed field name to new field name. But, that is not able to aggregate…

---

## [Various questions about an Elastic cluster](https://discuss.elastic.co/t/various-questions-about-an-elastic-cluster/134136)

<div class="topic-metadata">

**Author:** [@koko191](https://discuss.elastic.co/u/koko191)\
**Replies:** 2\
**Last updated:** [June 1, 2018, 5:27am UTC](https://discuss.elastic.co/t/various-questions-about-an-elastic-cluster/134136 "2018-06-01T05:27:11Z")

</div>

I have successfully set up an Elastic cluster with X-Pack and various Beats to simulate a production setting. However, I encountered some issues/questions while I was playing with the cluster. My setup is like this: O…

---

## [Performance of filtered wildcard queries](https://discuss.elastic.co/t/performance-of-filtered-wildcard-queries/133841)

<div class="topic-metadata">

**Author:** [@tobstarr](https://discuss.elastic.co/u/tobstarr)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 3:07am UTC](https://discuss.elastic.co/t/performance-of-filtered-wildcard-queries/133841 "2018-06-01T03:07:43Z")

</div>

Hi all, I have a very simple index structure only containing the fields (project\_id:int and name:string). What I want to do is a wildcard (infix) query on the name field and that scoped with the project\_id. What I am us…

---

## [Elasticsearch Cloud Cluster went in maintenance mode](https://discuss.elastic.co/t/elasticsearch-cloud-cluster-went-in-maintenance-mode/134116)

<div class="topic-metadata">

**Author:** [@Wayne\_Taylor](https://discuss.elastic.co/u/Wayne_Taylor)\
**Replies:** 1\
**Last updated:** [June 1, 2018, 12:13am UTC](https://discuss.elastic.co/t/elasticsearch-cloud-cluster-went-in-maintenance-mode/134116 "2018-06-01T00:13:23Z")

</div>

Hi Team, During some recent elasticsearch maintenance one of our clusters went into maintenance mode and never came back (maybe coincidence). I've done a lot of searching to find out about maintenance mode but since we…

---

## [Update "timestamp" field by query (subtract time from the original field and reindex)](https://discuss.elastic.co/t/update-timestamp-field-by-query-subtract-time-from-the-original-field-and-reindex/133851)

<div class="topic-metadata">

**Author:** [@dboss101](https://discuss.elastic.co/u/dboss101)\
**Replies:** 4\
**Last updated:** [May 31, 2018, 8:19pm UTC](https://discuss.elastic.co/t/update-timestamp-field-by-query-subtract-time-from-the-original-field-and-reindex/133851 "2018-05-31T20:19:03Z")

</div>

Hi, I'm trying to create a rest call that will perform the following. find all documents that match a simple query of field:value. in those documents, update the value of the "timestamp" field to be timestamp - 1 minu…

---

## [How to apply fuzzy prefix matching on not\_analyzed child field](https://discuss.elastic.co/t/how-to-apply-fuzzy-prefix-matching-on-not-analyzed-child-field/134097)

<div class="topic-metadata">

**Author:** [@Krishnapriya\_Mahajan](https://discuss.elastic.co/u/Krishnapriya_Mahajan)\
**Replies:** 0\
**Last updated:** [May 31, 2018, 6:25pm UTC](https://discuss.elastic.co/t/how-to-apply-fuzzy-prefix-matching-on-not-analyzed-child-field/134097 "2018-05-31T18:25:35Z")

</div>

Hi All, I am new to elasticsearch. I am having difficulty in construction of query that will do prefix match along with fuzziness on non-analyzed field that is a child field. i have mapping like A has property B. B has…

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

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