# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1086 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1087 --- ## [Is this valid this link regard elastic search](https://discuss.elastic.co/t/is-this-valid-this-link-regard-elastic-search/208924)
**Author:** [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)\ **Replies:** 3\ **Last updated:** [November 22, 2019, 9:20am UTC](https://discuss.elastic.co/t/is-this-valid-this-link-regard-elastic-search/208924 "2019-11-22T09:20:12Z")
Dear all. i have a some issue with below link : in this link documentation say join support for SQL please correct me! Link :- joins supported or not? --- ## [Master not discovered or elected yet (elastic search 7.4)](https://discuss.elastic.co/t/master-not-discovered-or-elected-yet-elastic-search-7-4/208892)
**Author:** [@Alejandro\_Calvo](https://discuss.elastic.co/u/Alejandro_Calvo)\ **Replies:** 2\ **Last updated:** [November 22, 2019, 8:34am UTC](https://discuss.elastic.co/t/master-not-discovered-or-elected-yet-elastic-search-7-4/208892 "2019-11-22T08:34:49Z")
Hello, I am trying to do a install test of elasticsearc 7.4 en RedHat. As configuration file elasticsearch.yml use: cluster.name: my-application node.name: node-1 path.data: /var/lib/elasticsearch path.lo… --- ## [Error : There are no external requests known to support wildcards that don't support replacing their indices](https://discuss.elastic.co/t/error-there-are-no-external-requests-known-to-support-wildcards-that-dont-support-replacing-their-indices/208881)
**Author:** [@shahab](https://discuss.elastic.co/u/shahab)\ **Replies:** 2\ **Last updated:** [November 22, 2019, 8:28am UTC](https://discuss.elastic.co/t/error-there-are-no-external-requests-known-to-support-wildcards-that-dont-support-replacing-their-indices/208881 "2019-11-22T08:28:34Z")
Hi, I was wondering if anyone could help me with my problem: I have a template and number of indices are mapped using the template. i.e. cdr\_xyz\_1234 cdr\_xyz\_5689 cdr\_xyz\_9876 I run a search query on all the indi… --- ## [Hive read es data slow](https://discuss.elastic.co/t/hive-read-es-data-slow/208670)
**Author:** [@yousanghz](https://discuss.elastic.co/u/yousanghz)\ **Replies:** 4\ **Last updated:** [November 22, 2019, 7:51am UTC](https://discuss.elastic.co/t/hive-read-es-data-slow/208670 "2019-11-22T07:51:17Z")
hive version 1.2.1 es version 5.5.0 hadoop-elasticsearch-5.5.0.jar es.index: data\_monthly 10 shard this is hsql CREATE EXTERNAL TABLE es\_test5( id string, uid string, wb\_name string, platform string, comment\_… --- ## [Update part of a document existing field](https://discuss.elastic.co/t/update-part-of-a-document-existing-field/209017)
**Author:** [@ohoroyoi](https://discuss.elastic.co/u/ohoroyoi)\ **Replies:** 1\ **Last updated:** [November 22, 2019, 7:28am UTC](https://discuss.elastic.co/t/update-part-of-a-document-existing-field/209017 "2019-11-22T07:28:15Z")
https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-update.html#\_update\_part\_of\_a\_document according to this documents, I can update partial documents. but is it not. it change whole documents. and th… --- ## [Getting error when installing elasticsearch](https://discuss.elastic.co/t/getting-error-when-installing-elasticsearch/209024)
**Author:** [@Oliver\_Russell](https://discuss.elastic.co/u/Oliver_Russell)\ **Replies:** 0\ **Last updated:** [November 22, 2019, 7:17am UTC](https://discuss.elastic.co/t/getting-error-when-installing-elasticsearch/209024 "2019-11-22T07:17:22Z")
I am trying to configure my site with elasticsearch. Since the platform I am using has elasticsearch php client by default, the user just need to configure it. I was following their guide, but got this error: Fatal error… --- ## [Trying to create too many scroll contexts. Must be less than or equal to: \[500\]. This limit can be set by changing the \[search.max\_open\_scroll\_context\] setting](https://discuss.elastic.co/t/trying-to-create-too-many-scroll-contexts-must-be-less-than-or-equal-to-500-this-limit-can-be-set-by-changing-the-search-max-open-scroll-context-setting/208884)
**Author:** [@Gokulnath](https://discuss.elastic.co/u/Gokulnath)\ **Replies:** 5\ **Last updated:** [November 22, 2019, 6:54am UTC](https://discuss.elastic.co/t/trying-to-create-too-many-scroll-contexts-must-be-less-than-or-equal-to-500-this-limit-can-be-set-by-changing-the-search-max-open-scroll-context-setting/208884 "2019-11-22T06:54:53Z")
Hey Team, Greetings...I am new to elasticsearch. Im getting this error."Trying to create too many scroll contexts. Must be less than or equal to: \[500\]. This limit can be set by changing the \[search.max\_open\_scroll\_cont… --- ## [NodeJS client unable to connect to Elasticsearch deployed in the same docker stack](https://discuss.elastic.co/t/nodejs-client-unable-to-connect-to-elasticsearch-deployed-in-the-same-docker-stack/209013)
**Author:** [@Anish\_Kumar](https://discuss.elastic.co/u/Anish_Kumar)\ **Replies:** 0\ **Last updated:** [November 22, 2019, 6:12am UTC](https://discuss.elastic.co/t/nodejs-client-unable-to-connect-to-elasticsearch-deployed-in-the-same-docker-stack/209013 "2019-11-22T06:12:33Z")
I have a docker stack deployment inside which I have elastic search deployed as a service. Now I have another NodeJS application inside the same docker stack deployed as service. I am using the Official elastic search Cl… --- ## [Create document via bulk vs index api](https://discuss.elastic.co/t/create-document-via-bulk-vs-index-api/208994)
**Author:** [@hjj1000](https://discuss.elastic.co/u/hjj1000)\ **Replies:** 1\ **Last updated:** [November 22, 2019, 6:08am UTC](https://discuss.elastic.co/t/create-document-via-bulk-vs-index-api/208994 "2019-11-22T06:08:05Z")
I'd like to know. Which is better performance using between bulk load and index? It is clearly that it has better performance we index some/many documents from bulk api. How about index 1 document from using bulk and i… --- ## [Getting the count of filtered buckets in elasticsearch](https://discuss.elastic.co/t/getting-the-count-of-filtered-buckets-in-elasticsearch/209000)
**Author:** [@Rahul\_Jhawar1](https://discuss.elastic.co/u/Rahul_Jhawar1)\ **Replies:** 0\ **Last updated:** [November 22, 2019, 3:34am UTC](https://discuss.elastic.co/t/getting-the-count-of-filtered-buckets-in-elasticsearch/209000 "2019-11-22T03:34:22Z")
Hi,I want to get the count of the buckets array after applying bucket\_filter in the aggregated bucket.This is how my document looks like- { "cdid" : "CD1234", "transactionid" : "000000261119929", … --- ## [Sort fieldname](https://discuss.elastic.co/t/sort-fieldname/208709)
**Author:** [@inhinyera16](https://discuss.elastic.co/u/inhinyera16)\ **Replies:** 2\ **Last updated:** [November 22, 2019, 3:31am UTC](https://discuss.elastic.co/t/sort-fieldname/208709 "2019-11-22T03:31:23Z")
Are there some mechanism how we can sort the fields in the query? Same as below. { field1 =\> "" field2 =\> "" field3 =\> "" } In sql command, it is equivalent to "Order by field1,field2,field3" --- ## [Watcher Unable to Alert via Email and Webhook](https://discuss.elastic.co/t/watcher-unable-to-alert-via-email-and-webhook/208001)
**Author:** [@lynkle](https://discuss.elastic.co/u/lynkle)\ **Replies:** 2\ **Last updated:** [November 22, 2019, 2:37am UTC](https://discuss.elastic.co/t/watcher-unable-to-alert-via-email-and-webhook/208001 "2019-11-22T02:37:56Z")
Hi! I have created a webhook to test out altering using some of the new machine learning features and run into some issues when attempting to send test alerts from the Kibana UI. Currently I am not concerned with alerti… --- ## [Grok pattern query for access logs](https://discuss.elastic.co/t/grok-pattern-query-for-access-logs/208413)
**Author:** [@Mehak\_Bhargava](https://discuss.elastic.co/u/Mehak_Bhargava)\ **Replies:** 9\ **Last updated:** [November 22, 2019, 1:58am UTC](https://discuss.elastic.co/t/grok-pattern-query-for-access-logs/208413 "2019-11-22T01:58:56Z")
I am using the below query to extract IP address, timestamp and such from an access log like this below: 192.168.10.182 - - - 18/Nov/2019:13:42:14 -0800 "GET /xxxx-xxxx-xxxx/xxxxxxxxxx/xxx/xxxx/xxxxxxxxxx HTTP/1.1" 200 … --- ## [Esrally failed to show result (Cannot race. Load generator \[14\] has exited prematurely.)](https://discuss.elastic.co/t/esrally-failed-to-show-result-cannot-race-load-generator-14-has-exited-prematurely/208415)
**Author:** [@Jinlian\_Chen](https://discuss.elastic.co/u/Jinlian_Chen)\ **Replies:** 2\ **Last updated:** [November 22, 2019, 1:24am UTC](https://discuss.elastic.co/t/esrally-failed-to-show-result-cannot-race-load-generator-14-has-exited-prematurely/208415 "2019-11-22T01:24:40Z")
All tasks shows done 100%, but failed to show the result. Is it the memory problem? It happens when run large number of iterations to build index. Parameters: bulk\_indexing\_clients:32,iterations:250000 The rally log sh… --- ## [Multi words synonym query issues](https://discuss.elastic.co/t/multi-words-synonym-query-issues/208679)
**Author:** [@jasoncodingguru](https://discuss.elastic.co/u/jasoncodingguru)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 9:31pm UTC](https://discuss.elastic.co/t/multi-words-synonym-query-issues/208679 "2019-11-21T21:31:10Z")
Hi guys, I am having a challenge with multi words synonym related queries. E.g I have the following format of synonym: Spanish onion, red onion I have a document which contains words “onion red”. When I use multi matc… --- ## [SQL for parent-child relationships](https://discuss.elastic.co/t/sql-for-parent-child-relationships/208963)
**Author:** [@Balu\_P](https://discuss.elastic.co/u/Balu_P)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 9:16pm UTC](https://discuss.elastic.co/t/sql-for-parent-child-relationships/208963 "2019-11-21T21:16:00Z")
Can I use elastic SQL for quering parent-child relationships --- ## [A Question on whether to use a Nested Datatype](https://discuss.elastic.co/t/a-question-on-whether-to-use-a-nested-datatype/208394)
**Author:** [@matthew.whill](https://discuss.elastic.co/u/matthew.whill)\ **Replies:** 4\ **Last updated:** [November 21, 2019, 8:36pm UTC](https://discuss.elastic.co/t/a-question-on-whether-to-use-a-nested-datatype/208394 "2019-11-21T20:36:46Z")
Hello All. I wanted to ask for peoples thoughts around whether to use nested datatypes in a particular scenario. The scenario: I am wanting to store into an index the contents of files and each file contains reference… --- ## [Can't take Elastic 6.8.0 snapshot](https://discuss.elastic.co/t/cant-take-elastic-6-8-0-snapshot/208171)
**Author:** [@tfe2012](https://discuss.elastic.co/u/tfe2012)\ **Replies:** 3\ **Last updated:** [November 21, 2019, 8:18pm UTC](https://discuss.elastic.co/t/cant-take-elastic-6-8-0-snapshot/208171 "2019-11-21T20:18:10Z")
Hi, Try to make a snapshot of the cluster PUT /\_snapshot/my\_backup/pre\_prod\_2 It works for 3-4 hours and after struggling on this state: "snapshot" : "pre\_prod\_2", "repository" : "my\_backup", "uuid" : "YhlA8Ke9Rlu34… --- ## [Query string with AND operator in nested query not working. Any idea?](https://discuss.elastic.co/t/query-string-with-and-operator-in-nested-query-not-working-any-idea/208630)
**Author:** [@Devang\_Prajapati](https://discuss.elastic.co/u/Devang_Prajapati)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 7:28pm UTC](https://discuss.elastic.co/t/query-string-with-and-operator-in-nested-query-not-working-any-idea/208630 "2019-11-21T19:28:10Z")
I want to get the document in which nested child contains both words Mifune AND Miller-Meteor. For more detail of nested, I've gone through Nested query | Elasticsearch Guide \[8.11\] | Elastic here are the mappings { … --- ## [Frequent young GC loop crashing nodes](https://discuss.elastic.co/t/frequent-young-gc-loop-crashing-nodes/208955)
**Author:** [@adam.wight](https://discuss.elastic.co/u/adam.wight)\ **Replies:** 0\ **Last updated:** [November 21, 2019, 5:58pm UTC](https://discuss.elastic.co/t/frequent-young-gc-loop-crashing-nodes/208955 "2019-11-21T17:58:30Z")
Running ES 6.8.4 on a cluster with heavy search activity, for the past few weeks we're seeing nodes go into a continuous garbage collection loop, and eventually crash the ES process. Is triggered by spike in search acti… --- ## [How to make elasticsearch synchronous call in ActionListner response](https://discuss.elastic.co/t/how-to-make-elasticsearch-synchronous-call-in-actionlistner-response/208945)
**Author:** [@developer\_apk](https://discuss.elastic.co/u/developer_apk)\ **Replies:** 0\ **Last updated:** [November 21, 2019, 5:23pm UTC](https://discuss.elastic.co/t/how-to-make-elasticsearch-synchronous-call-in-actionlistner-response/208945 "2019-11-21T17:23:37Z")
I am using Elasticsearch java high level rest client and synchronous API calls are hanging forever in onResponse method public String indexDocument(String document) throws Exception { IndexRequest indexRequest = new Ind… --- ## [httpAddresses of TestCluster (ES 7.0)](https://discuss.elastic.co/t/httpaddresses-of-testcluster-es-7-0/206697)
**Author:** [@zhongchen](https://discuss.elastic.co/u/zhongchen)\ **Replies:** 6\ **Last updated:** [November 21, 2019, 4:43pm UTC](https://discuss.elastic.co/t/httpaddresses-of-testcluster-es-7-0/206697 "2019-11-21T16:43:21Z")
the cluster method from ESIntegTestCase.java returns a TestCluster. It seems that the behavior of the output of httpAddresses of cluster() is different between 7.0 and 6.0. In the 7.0 version cluster().httpAddresses()… --- ## [Phrase\_prefix search issue with single character](https://discuss.elastic.co/t/phrase-prefix-search-issue-with-single-character/208860)
**Author:** [@dipanshu\_sharma](https://discuss.elastic.co/u/dipanshu_sharma)\ **Replies:** 4\ **Last updated:** [November 21, 2019, 4:41pm UTC](https://discuss.elastic.co/t/phrase-prefix-search-issue-with-single-character/208860 "2019-11-21T16:41:45Z")
I have a data like 'Dipanshu S', 'Mohit Sharma' and 'Mohit Shakya' in my database and when i do a ES search query like :- "multi\_match": { "query": "Mohit S", "type": "phrase\_prefix", "fields": \[ "name", "nickname" … --- ## [Incorporating pseudo relevance feedback](https://discuss.elastic.co/t/incorporating-pseudo-relevance-feedback/208936)
**Author:** [@dwaipayan](https://discuss.elastic.co/u/dwaipayan)\ **Replies:** 0\ **Last updated:** [November 21, 2019, 4:36pm UTC](https://discuss.elastic.co/t/incorporating-pseudo-relevance-feedback/208936 "2019-11-21T16:36:00Z")
Hi, I want to implement some pseudo-relevance feedback (something like: Relevance Based Language Model - Lavrenko, Croft, SIGIR 2001) mechanism in the Elasticsearch. I already have an implementation in Lucene, tested wi… --- ## [Painless scripts don't work the same in filter and field contexts](https://discuss.elastic.co/t/painless-scripts-dont-work-the-same-in-filter-and-field-contexts/208932)
**Author:** [@eacosta](https://discuss.elastic.co/u/eacosta)\ **Replies:** 0\ **Last updated:** [November 21, 2019, 4:19pm UTC](https://discuss.elastic.co/t/painless-scripts-dont-work-the-same-in-filter-and-field-contexts/208932 "2019-11-21T16:19:04Z")
We created a scripted field, we debugged it until it returns the correct value (true or false). It was extremely hard to discover things, e.g. the documentation never specifies how to access the data in a scripted field… --- ## [Elastic Cluster node problem](https://discuss.elastic.co/t/elastic-cluster-node-problem/208915)
**Author:** [@naqib](https://discuss.elastic.co/u/naqib)\ **Replies:** 1\ **Last updated:** [November 21, 2019, 3:54pm UTC](https://discuss.elastic.co/t/elastic-cluster-node-problem/208915 "2019-11-21T15:54:28Z")
Hi, I am new to elsticsearch. I just downloaded the free version of elasticsearch. I have installed them in two servers: node1 and node 2. I have same elasticConfig the only difference is the node as following: node1: … --- ## [Elastic Query Type Casting Error](https://discuss.elastic.co/t/elastic-query-type-casting-error/208587)
**Author:** [@akrauss](https://discuss.elastic.co/u/akrauss)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 3:40pm UTC](https://discuss.elastic.co/t/elastic-query-type-casting-error/208587 "2019-11-21T15:40:00Z")
I have this index which all the mappings are long type. I have a query with a structure works with all my other indices: GET dqs\_profgen\_\*/\_search { "query": { "bool": { "filter": { "range": { … --- ## [How to combine multiple fields values within single field](https://discuss.elastic.co/t/how-to-combine-multiple-fields-values-within-single-field/208826)
**Author:** [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)\ **Replies:** 3\ **Last updated:** [November 21, 2019, 3:26pm UTC](https://discuss.elastic.co/t/how-to-combine-multiple-fields-values-within-single-field/208826 "2019-11-21T15:26:18Z")
Dear All. again i came here from long time with some issue. i have data inside elastic search like below:- id name cnt marks 101 ram ind 80.32 101 ram ...... null 101 … --- ## [Search performance improovment by adding replicas shards](https://discuss.elastic.co/t/search-performance-improovment-by-adding-replicas-shards/208732)
**Author:** [@Loris](https://discuss.elastic.co/u/Loris)\ **Replies:** 3\ **Last updated:** [November 21, 2019, 3:23pm UTC](https://discuss.elastic.co/t/search-performance-improovment-by-adding-replicas-shards/208732 "2019-11-21T15:23:42Z")
Hi, Elasticsearch documentation reports that increasing the number of replicas shards will lead to search and read performance improvements. Can you, please, explain it better? According to the following scenarios, I ha… --- ## [Metricbeat index lifecycle policy (ILM) not rolling over](https://discuss.elastic.co/t/metricbeat-index-lifecycle-policy-ilm-not-rolling-over/207173)
**Author:** [@Ryan\_Downey](https://discuss.elastic.co/u/Ryan_Downey)\ **Replies:** 2\ **Last updated:** [November 21, 2019, 2:31pm UTC](https://discuss.elastic.co/t/metricbeat-index-lifecycle-policy-ilm-not-rolling-over/207173 "2019-11-21T14:31:30Z")
ECE 2.3 ES and Kibana v7.3.0 I'm having trouble getting an index lifecycle policy to rollover. I currently have an index called metricbeat-7.0.0-2019.10.21-000001 that has an alias of metricbeat-7.0.0. The index has … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1085) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1087)