# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1763 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1764 --- ## [Nested bool queries return an error](https://discuss.elastic.co/t/nested-bool-queries-return-an-error/122531)
**Author:** [@WoJ](https://discuss.elastic.co/u/WoJ)\ **Replies:** 1\ **Last updated:** [March 7, 2018, 11:45am UTC](https://discuss.elastic.co/t/nested-bool-queries-return-an-error/122531 "2018-03-07T11:45:54Z")
Hello everyone, I am building a search query which dynamically adds a set of constraints (bool) to the query. The general expected structure is as follows OR ( AND ( condition condition ... ) AND ( co… --- ## [Using painless to calculate durations](https://discuss.elastic.co/t/using-painless-to-calculate-durations/119495)
**Author:** [@crazyphil](https://discuss.elastic.co/u/crazyphil)\ **Replies:** 18\ **Last updated:** [March 7, 2018, 11:02am UTC](https://discuss.elastic.co/t/using-painless-to-calculate-durations/119495 "2018-03-07T11:02:54Z")
I have several different indices grabbing events that have definitive start and stop points (I have an eventKey field that says "started" or "ended"). Each field also has a unique eventId field so that all things that h… --- ## [Use \_score as tiebreaker only for function\_score query](https://discuss.elastic.co/t/use-score-as-tiebreaker-only-for-function-score-query/122847)
**Author:** [@masterada](https://discuss.elastic.co/u/masterada)\ **Replies:** 0\ **Last updated:** [March 7, 2018, 8:56am UTC](https://discuss.elastic.co/t/use-score-as-tiebreaker-only-for-function-score-query/122847 "2018-03-07T08:56:15Z")
I would like to use the score from full text search as a tie-breaker only for my calculated score. In other words, I would like to sort by a custom script, and if the score returned by that script is equal for two docum… --- ## [Timestamp of index](https://discuss.elastic.co/t/timestamp-of-index/122860)
**Author:** [@Steve\_Stevens](https://discuss.elastic.co/u/Steve_Stevens)\ **Replies:** 0\ **Last updated:** [March 7, 2018, 10:35am UTC](https://discuss.elastic.co/t/timestamp-of-index/122860 "2018-03-07T10:35:15Z")
Given there is a time delay between a message being logged at source and the message being submitted into elasticsearch, is there a mechanism for identifying the time that the log was stored in elasticsearch. ie, is ther… --- ## [Data types(Map\) in templates](https://discuss.elastic.co/t/data-types-map-object-object-in-templates/122856)
**Author:** [@Nikita\_Krasnov](https://discuss.elastic.co/u/Nikita_Krasnov)\ **Replies:** 0\ **Last updated:** [March 7, 2018, 9:57am UTC](https://discuss.elastic.co/t/data-types-map-object-object-in-templates/122856 "2018-03-07T09:57:43Z")
Hello to everyone. I want to create template for indexing. I don't know how to put Map\ (Java) in such templete. I have right know: PUT \_template/portal-user { "index\_patterns": "portal-user-\*", "s… --- ## [Query help: get distinct Search base on created\_at](https://discuss.elastic.co/t/query-help-get-distinct-search-base-on-created-at/122830)
**Author:** [@mohammad\_S07](https://discuss.elastic.co/u/mohammad_S07)\ **Replies:** 0\ **Last updated:** [March 7, 2018, 6:42am UTC](https://discuss.elastic.co/t/query-help-get-distinct-search-base-on-created-at/122830 "2018-03-07T06:42:53Z")
hi first, I have apologized for my weak English, I store data in the elastic search like this { "\_index": "my\_index", "\_type": "doc", "\_id": "6lDquGEBFRQVe0x93eHk", "\_version": 1, "\_score"… --- ## [ElasticSearch cluster restarting/adding node(s)](https://discuss.elastic.co/t/elasticsearch-cluster-restarting-adding-node-s/122249)
**Author:** [@szymon](https://discuss.elastic.co/u/szymon)\ **Replies:** 10\ **Last updated:** [March 7, 2018, 9:16am UTC](https://discuss.elastic.co/t/elasticsearch-cluster-restarting-adding-node-s/122249 "2018-03-07T09:16:03Z")
Hello, i have some questions about how ES should behave while restarting or adding nodes. CASE 1: I have 4 nodes in a cluster (every node can be elected as a master and also is a data node). Number of replicas is set… --- ## [The problem about ordering in terms](https://discuss.elastic.co/t/the-problem-about-ordering-in-terms/122840)
**Author:** [@PENG\_ZHANG](https://discuss.elastic.co/u/PENG_ZHANG)\ **Replies:** 0\ **Last updated:** [March 7, 2018, 7:42am UTC](https://discuss.elastic.co/t/the-problem-about-ordering-in-terms/122840 "2018-03-07T07:42:15Z")
1. FunctionDescription Use terms to generate multiple buckets. Sort the buckets using the aggregated result. 2. My Previous Solution At first, I use terms-\>order to sort buckets. Then, part of the aggregate resu… --- ## [Upgrade Elasticsearch on Windows Server](https://discuss.elastic.co/t/upgrade-elasticsearch-on-windows-server/122846)
**Author:** [@Hanen](https://discuss.elastic.co/u/Hanen)\ **Replies:** 0\ **Last updated:** [March 7, 2018, 8:32am UTC](https://discuss.elastic.co/t/upgrade-elasticsearch-on-windows-server/122846 "2018-03-07T08:32:41Z")
Hi, I installed Elasticsearch version 6.1.1 on windows server 2012 R2, and I would like to upgrade it to version 6.2. Can you mention the different steps to follow please. Many thanks for your support and help. --- ## [How to Check whether the data has been loaded into Elastic Search or Not?](https://discuss.elastic.co/t/how-to-check-whether-the-data-has-been-loaded-into-elastic-search-or-not/122640)
**Author:** [@bpk](https://discuss.elastic.co/u/bpk)\ **Replies:** 2\ **Last updated:** [March 7, 2018, 7:00am UTC](https://discuss.elastic.co/t/how-to-check-whether-the-data-has-been-loaded-into-elastic-search-or-not/122640 "2018-03-07T07:00:34Z")
I have loaded the csv into Logstash and fed into Elastic Search. Now how can I check or see the data, which I have loaded ? One way is connecting the datasource to Grafana, we can find. Is there any other way to see ? --- ## [Failing to start elasticsearch versions 6.x on Mac due to java.security.\* access denied](https://discuss.elastic.co/t/failing-to-start-elasticsearch-versions-6-x-on-mac-due-to-java-security-access-denied/119953)
**Author:** [@ryemyer](https://discuss.elastic.co/u/ryemyer)\ **Replies:** 2\ **Last updated:** [March 7, 2018, 6:58am UTC](https://discuss.elastic.co/t/failing-to-start-elasticsearch-versions-6-x-on-mac-due-to-java-security-access-denied/119953 "2018-03-07T06:58:33Z")
Hi, I installed elasticsearch 6.2.1 (also tried 6.1.2) on my mac, and I am getting various exceptions due to Java security issues. Searching google I found very few suggestions, all of them pointing to the Java policy … --- ## [Configuring ES issues](https://discuss.elastic.co/t/configuring-es-issues/122705)
**Author:** [@Developer1](https://discuss.elastic.co/u/Developer1)\ **Replies:** 3\ **Last updated:** [March 7, 2018, 6:55am UTC](https://discuss.elastic.co/t/configuring-es-issues/122705 "2018-03-07T06:55:26Z")
Hi, I have the following questions related to ES: the ES config is set up to localhost. The web app is called via localhost and in this case we can create the logs. But we don't get the logs If the web app is called v… --- ## [How to find which template indice is created with?](https://discuss.elastic.co/t/how-to-find-which-template-indice-is-created-with/122802)
**Author:** [@Karthik\_Ramachandran](https://discuss.elastic.co/u/Karthik_Ramachandran)\ **Replies:** 1\ **Last updated:** [March 7, 2018, 6:53am UTC](https://discuss.elastic.co/t/how-to-find-which-template-indice-is-created-with/122802 "2018-03-07T06:53:36Z")
I'm trying to find a way to identify which version/template an indice is applied with during creation. We can look at the template itself and look for index\_patterns, but what if the template is deleted or template is m… --- ## [RestClient 6.1 getting Connection reset by peer error while querying ES](https://discuss.elastic.co/t/restclient-6-1-getting-connection-reset-by-peer-error-while-querying-es/122824)
**Author:** [@Arun\_Kumar1](https://discuss.elastic.co/u/Arun_Kumar1)\ **Replies:** 0\ **Last updated:** [March 7, 2018, 6:13am UTC](https://discuss.elastic.co/t/restclient-6-1-getting-connection-reset-by-peer-error-while-querying-es/122824 "2018-03-07T06:13:40Z")
I am getting " Connection reset by peer" error while querying ES. after few re-tries its working fine. private static RestHighLevelClient client; RestClientBuilder builder = RestClient.builder(new HttpHost(hostna… --- ## [Undesired Stopwords in Elastic Search](https://discuss.elastic.co/t/undesired-stopwords-in-elastic-search/122807)
**Author:** [@jack1234](https://discuss.elastic.co/u/jack1234)\ **Replies:** 0\ **Last updated:** [March 7, 2018, 2:30am UTC](https://discuss.elastic.co/t/undesired-stopwords-in-elastic-search/122807 "2018-03-07T02:30:26Z")
I am using Elastic Search 6.This is query PUT /semtesttest { "settings": { "index" : { "analysis" : { "filter": { "my\_stop": { "type": "stop", … --- ## [Enforce minimum hit count on all queries by default](https://discuss.elastic.co/t/enforce-minimum-hit-count-on-all-queries-by-default/121754)
**Author:** [@s\_mp](https://discuss.elastic.co/u/s_mp)\ **Replies:** 3\ **Last updated:** [March 6, 2018, 10:49pm UTC](https://discuss.elastic.co/t/enforce-minimum-hit-count-on-all-queries-by-default/121754 "2018-03-06T22:49:45Z")
Hi, Our ES index consists of user records with "Personally identifiable information"(PII). And all the data is supposed to be queried only at the aggregated level. We currently ask all our clients to include min\_doc\_co… --- ## [Dynamic Nested Objects Mapping](https://discuss.elastic.co/t/dynamic-nested-objects-mapping/122167)
**Author:** [@samdash](https://discuss.elastic.co/u/samdash)\ **Replies:** 5\ **Last updated:** [March 6, 2018, 10:36pm UTC](https://discuss.elastic.co/t/dynamic-nested-objects-mapping/122167 "2018-03-06T22:36:24Z")
Hi, I need help with Dynamic deeply nested Objects mapping , below is my example, the nesting can go very deep as the level attribute indicates. "sections" \[ { "level" : "1", "text" : "", … --- ## [Email "From" setting](https://discuss.elastic.co/t/email-from-setting/121171)
**Author:** [@Pororo](https://discuss.elastic.co/u/Pororo)\ **Replies:** 2\ **Last updated:** [March 6, 2018, 10:03pm UTC](https://discuss.elastic.co/t/email-from-setting/121171 "2018-03-06T22:03:08Z")
I am wondering if there is any way to edit the display name of the "from" email when it actually sends the email notification. What I want is like for "from" when the user receives the notification.For now, the display … --- ## [Transport SSL must be enabled for setups with production licenses. Please set \[xpack.security.transport.ssl.enabled\] to \[true\] or disable security by setting \[xpack.security.enabled\] to \[false\]](https://discuss.elastic.co/t/transport-ssl-must-be-enabled-for-setups-with-production-licenses-please-set-xpack-security-transport-ssl-enabled-to-true-or-disable-security-by-setting-xpack-security-enabled-to-false/121152)
**Author:** [@rippfx](https://discuss.elastic.co/u/rippfx)\ **Replies:** 1\ **Last updated:** [March 6, 2018, 9:51pm UTC](https://discuss.elastic.co/t/transport-ssl-must-be-enabled-for-setups-with-production-licenses-please-set-xpack-security-transport-ssl-enabled-to-true-or-disable-security-by-setting-xpack-security-enabled-to-false/121152 "2018-03-06T21:51:38Z")
Transport SSL must be enabled for setups with production licenses. Please set \[xpack.security.transport.ssl.enabled\] to \[true\] or disable security by setting \[xpack.security.enabled\] to \[false\] I upgraded the pre-prod e… --- ## [Assign boost to document at index time](https://discuss.elastic.co/t/assign-boost-to-document-at-index-time/122690)
**Author:** [@Kurzer\_Patrick](https://discuss.elastic.co/u/Kurzer_Patrick)\ **Replies:** 6\ **Last updated:** [March 6, 2018, 9:50pm UTC](https://discuss.elastic.co/t/assign-boost-to-document-at-index-time/122690 "2018-03-06T21:50:28Z")
I just read much documents regarding to assign a static boost to a specific document at index time. Some of the docs and function are deprecated. So I am not sure what to use for this particular use case: I index two si… --- ## [Query Help: must\_not keeps matching document](https://discuss.elastic.co/t/query-help-must-not-keeps-matching-document/122762)
**Author:** [@aaronloesattv](https://discuss.elastic.co/u/aaronloesattv)\ **Replies:** 3\ **Last updated:** [March 6, 2018, 9:17pm UTC](https://discuss.elastic.co/t/query-help-must-not-keeps-matching-document/122762 "2018-03-06T21:17:33Z")
I'm trying to write a watcher alert that triggers when any other watcher alert fails to execute. However, due to a bug, we're getting a lot of failed watch executions because a given watch is executed at the same time by… --- ## [Semantic knowledge graph](https://discuss.elastic.co/t/semantic-knowledge-graph/122615)
**Author:** [@mattkallo](https://discuss.elastic.co/u/mattkallo)\ **Replies:** 1\ **Last updated:** [March 6, 2018, 8:41pm UTC](https://discuss.elastic.co/t/semantic-knowledge-graph/122615 "2018-03-06T20:41:17Z")
Hi, Is there an equivalent of Solr Semantic Knowledge Graph in ES? I did search the forum, and google in general but could not find any reference. Thanks ! --- ## [Strange shard routing behavior with index templates and shrink in a hot/warm architecture](https://discuss.elastic.co/t/strange-shard-routing-behavior-with-index-templates-and-shrink-in-a-hot-warm-architecture/122401)
**Author:** [@Kim-Kruse-Hansen](https://discuss.elastic.co/u/Kim-Kruse-Hansen)\ **Replies:** 3\ **Last updated:** [March 6, 2018, 6:20pm UTC](https://discuss.elastic.co/t/strange-shard-routing-behavior-with-index-templates-and-shrink-in-a-hot-warm-architecture/122401 "2018-03-06T18:20:33Z")
Hi I have an issue with Curator that I would like an opinion on. This is elk 6.2.0 with curator 5.4, but also happens on 6.1.2. I hope I am missing somethng obvious. I have a cluster , that implements the hot/warm arch… --- ## [Deduplication of records with deletion code](https://discuss.elastic.co/t/deduplication-of-records-with-deletion-code/122750)
**Author:** [@Jeremy\_Foran](https://discuss.elastic.co/u/Jeremy_Foran)\ **Replies:** 0\ **Last updated:** [March 6, 2018, 5:00pm UTC](https://discuss.elastic.co/t/deduplication-of-records-with-deletion-code/122750 "2018-03-06T17:00:35Z")
Hey Folks, I recently had an issue with an AWS load balancer with resulted in getting millions of duplicated documents. I found some resources that helped with writing the query to find duplicates (here) but nothing to… --- ## [Size query performance problems](https://discuss.elastic.co/t/size-query-performance-problems/122637)
**Author:** [@Rotem\_Shriki](https://discuss.elastic.co/u/Rotem_Shriki)\ **Replies:** 1\ **Last updated:** [March 6, 2018, 4:34pm UTC](https://discuss.elastic.co/t/size-query-performance-problems/122637 "2018-03-06T16:34:30Z")
Hi all, I have 3 nodes clusters on aws (c4 instances) and 245 docs in my elastic, when i try to limit the results to 50 using size:50, my performance degraded from 300ms to 2800ms ( without even using search\_after or f… --- ## [XML output from elastic](https://discuss.elastic.co/t/xml-output-from-elastic/122451)
**Author:** [@rpc29y](https://discuss.elastic.co/u/rpc29y)\ **Replies:** 4\ **Last updated:** [March 6, 2018, 4:30pm UTC](https://discuss.elastic.co/t/xml-output-from-elastic/122451 "2018-03-06T16:30:15Z")
Hello: I wanted to ask if it is possible with elastic 5.6 to generate xml as an output format. For me it is much faster to deal with the XML response in java. Thank you. --- ## [Elasticsearch install ik error](https://discuss.elastic.co/t/elasticsearch-install-ik-error/122666)
**Author:** [@abc965432](https://discuss.elastic.co/u/abc965432)\ **Replies:** 2\ **Last updated:** [March 6, 2018, 4:02pm UTC](https://discuss.elastic.co/t/elasticsearch-install-ik-error/122666 "2018-03-06T16:02:27Z")
\[image\] implement: mvn package Install the IK participle failed --- ## [Use ElasticSearch 6.2 without upgrade](https://discuss.elastic.co/t/use-elasticsearch-6-2-without-upgrade/122736)
**Author:** [@akml\_kk](https://discuss.elastic.co/u/akml_kk)\ **Replies:** 0\ **Last updated:** [March 6, 2018, 3:41pm UTC](https://discuss.elastic.co/t/use-elasticsearch-6-2-without-upgrade/122736 "2018-03-06T15:41:11Z")
Hello , Recently,I' have worked with elasticsearch 6.1.3. Now , I' need to use elasticsearch 6.2.2 to be able to use OpenNLP plugin. My question can i just download the 6.2.2 version along side to 6.1.3 and use them s… --- ## [Sort Based on Subfield Omits Results](https://discuss.elastic.co/t/sort-based-on-subfield-omits-results/122566)
**Author:** [@amirklick](https://discuss.elastic.co/u/amirklick)\ **Replies:** 0\ **Last updated:** [March 5, 2018, 4:51pm UTC](https://discuss.elastic.co/t/sort-based-on-subfield-omits-results/122566 "2018-03-05T16:51:15Z")
Hi. I'm using the JavaScript SDK and when I sort results based on a subfield, if I don't specify a "size" greater than or equal to total number of records, some are omitted and not returned. Is this a bug? How can this b… --- ## [Elasticsearch client defaulting to http](https://discuss.elastic.co/t/elasticsearch-client-defaulting-to-http/122732)
**Author:** [@wandermonk](https://discuss.elastic.co/u/wandermonk)\ **Replies:** 1\ **Last updated:** [March 6, 2018, 3:29pm UTC](https://discuss.elastic.co/t/elasticsearch-client-defaulting-to-http/122732 "2018-03-06T15:29:48Z")
We hosted our elasticsearch cluster in AWS. We do not have port number exposed to the clients using elastic datastore. Whenever we instantiate the RestClient using the hostname, the client is defaulting to 'HTTP' rather … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1762) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1764)