# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1318 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1319 --- ## [Unable to connect to elasticstack from other machines](https://discuss.elastic.co/t/unable-to-connect-to-elasticstack-from-other-machines/178520)
**Author:** [@Dhulem](https://discuss.elastic.co/u/Dhulem)\ **Replies:** 7\ **Last updated:** [April 26, 2019, 8:26pm UTC](https://discuss.elastic.co/t/unable-to-connect-to-elasticstack-from-other-machines/178520 "2019-04-26T20:26:30Z")
I am an elasticstack noob so sorry for the noob question. As the title says I am unable to connect to my elasticstack machine remotely, on the same subnet. I can open port 9200 locally on the machine but the server is r… --- ## [Getting error org.elasticsearch.common.util.concurrent.EsRejectedExecutionException: rejected execution of org.elasticsearch.transport.TransportService$4@2397ca1d on EsThreadPoolExecutor\[index, queue capacity = 200](https://discuss.elastic.co/t/getting-error-org-elasticsearch-common-util-concurrent-esrejectedexecutionexception-rejected-execution-of-org-elasticsearch-transport-transportservice-4-2397ca1d-on-esthreadpoolexecutor-index-queue-capacity-200/178622)
**Author:** [@pribal](https://discuss.elastic.co/u/pribal)\ **Replies:** 1\ **Last updated:** [April 26, 2019, 7:52pm UTC](https://discuss.elastic.co/t/getting-error-org-elasticsearch-common-util-concurrent-esrejectedexecutionexception-rejected-execution-of-org-elasticsearch-transport-transportservice-4-2397ca1d-on-esthreadpoolexecutor-index-queue-capacity-200/178622 "2019-04-26T19:52:25Z")
We are getting error in elasticsearch org.elasticsearch.common.util.concurrent.EsRejectedExecutionException: rejected execution of org.elasticsearch.transport.TransportService$4@2397ca1d on EsThreadPoolExecutor\[index, q… --- ## [Weird Results with Pattern Analyzer](https://discuss.elastic.co/t/weird-results-with-pattern-analyzer/178718)
**Author:** [@vveluchamy](https://discuss.elastic.co/u/vveluchamy)\ **Replies:** 0\ **Last updated:** [April 26, 2019, 7:49pm UTC](https://discuss.elastic.co/t/weird-results-with-pattern-analyzer/178718 "2019-04-26T19:49:14Z")
Hello, We have the following Tokenizers "tokenizer": { "starts\_with\_tokenizer": { "type": "edge\_ngram", "min\_gram": "1", "max\_gram": "10" }, "ngrams\_tokenizer": { "token\_chars": \[ "letter", "digit" \], "min\_g… --- ## [Can I create SQL based query in Kibana provided by AWS Elastic Cluster](https://discuss.elastic.co/t/can-i-create-sql-based-query-in-kibana-provided-by-aws-elastic-cluster/178710)
**Author:** [@Tanuj\_Nayanam](https://discuss.elastic.co/u/Tanuj_Nayanam)\ **Replies:** 1\ **Last updated:** [April 26, 2019, 7:37pm UTC](https://discuss.elastic.co/t/can-i-create-sql-based-query-in-kibana-provided-by-aws-elastic-cluster/178710 "2019-04-26T19:37:02Z")
I have created AWS ES Cluster and I want to be able to query the data using SQL Type syntax using X-Pack. Does AWS ES cluster has this capability? --- ## [Upsert](https://discuss.elastic.co/t/upsert/178709)
**Author:** [@aniaks](https://discuss.elastic.co/u/aniaks)\ **Replies:** 1\ **Last updated:** [April 26, 2019, 6:56pm UTC](https://discuss.elastic.co/t/upsert/178709 "2019-04-26T18:56:56Z")
Using java api ... is there a way to get details like how many docs updated as part of that upsert how many docs inserted as part of the upsert let me know if we can get these details --- ## [Get only one row of nested object in a filter query](https://discuss.elastic.co/t/get-only-one-row-of-nested-object-in-a-filter-query/178696)
**Author:** [@adriamuixi](https://discuss.elastic.co/u/adriamuixi)\ **Replies:** 0\ **Last updated:** [April 26, 2019, 5:06pm UTC](https://discuss.elastic.co/t/get-only-one-row-of-nested-object-in-a-filter-query/178696 "2019-04-26T17:06:16Z")
Hi With ElasticSearch 6.5 I have this document product data mapped with nested Objects (variants and price) : { "name": "Test", "variants": \[{ "id": 767898, "sku\_variant": "HK-334455-NSO", "visibility": "… --- ## [Elastic Cloud Snapshot to AWS S3](https://discuss.elastic.co/t/elastic-cloud-snapshot-to-aws-s3/178000)
**Author:** [@Robin\_Guo](https://discuss.elastic.co/u/Robin_Guo)\ **Replies:** 6\ **Last updated:** [April 26, 2019, 4:29pm UTC](https://discuss.elastic.co/t/elastic-cloud-snapshot-to-aws-s3/178000 "2019-04-26T16:29:57Z")
Hi Elastic Members, I Have a question of Elastic Cloud index snapshot, As I know if we want to send index snapshots to AWS s3 in terms of on-premise ELK solution, We need to install repository-s3 plugin on each of ES … --- ## [Is there any observability into ingest pipelines?](https://discuss.elastic.co/t/is-there-any-observability-into-ingest-pipelines/176130)
**Author:** [@RamblingCookieMonste](https://discuss.elastic.co/u/RamblingCookieMonste)\ **Replies:** 1\ **Last updated:** [April 26, 2019, 4:13pm UTC](https://discuss.elastic.co/t/is-there-any-observability-into-ingest-pipelines/176130 "2019-04-26T16:13:10Z")
Hi! So! Logstash has a pipeline viewer, which gives a nice visualization and some performance data on pipelines and their individual components. My google-fu may be failing, but is this not a thing for Elasticsearch i… --- ## [Running ES 6.7 viewing the kibana upgrade assistant has warnings](https://discuss.elastic.co/t/running-es-6-7-viewing-the-kibana-upgrade-assistant-has-warnings/177357)
**Author:** [@Reedler](https://discuss.elastic.co/u/Reedler)\ **Replies:** 2\ **Last updated:** [April 26, 2019, 4:08pm UTC](https://discuss.elastic.co/t/running-es-6-7-viewing-the-kibana-upgrade-assistant-has-warnings/177357 "2019-04-26T16:08:32Z")
Want to upgrade to v7x In the kibana upgrade assistant i have warnings. Fields in index template exceed automatic field expansion limit I've tried to research and resolve this warning but not sure where to begin. Any … --- ## [Reloading elasticsearch.yml on ELK Stack](https://discuss.elastic.co/t/reloading-elasticsearch-yml-on-elk-stack/178649)
**Author:** [@Johnnie843](https://discuss.elastic.co/u/Johnnie843)\ **Replies:** 1\ **Last updated:** [April 26, 2019, 3:24pm UTC](https://discuss.elastic.co/t/reloading-elasticsearch-yml-on-elk-stack/178649 "2019-04-26T15:24:06Z")
I made a change to my configuration on the elastic search side of the ELK stack. What is the proper sequence of events to reload the configuration without causing issues to the stack? Far as downtime, I need to keep it m… --- ## [Reindexing to apply logic to existing data?](https://discuss.elastic.co/t/reindexing-to-apply-logic-to-existing-data/177921)
**Author:** [@T\_way](https://discuss.elastic.co/u/T_way)\ **Replies:** 4\ **Last updated:** [April 26, 2019, 2:26pm UTC](https://discuss.elastic.co/t/reindexing-to-apply-logic-to-existing-data/177921 "2019-04-26T14:26:52Z")
Hi experts, I'm indexing Netflow data via logstash that does the logic to create new fields. However If the data already exists in ES is there a way to reindex it in order to create these new fields based on the same co… --- ## [Index Lifecycle dilemma](https://discuss.elastic.co/t/index-lifecycle-dilemma/177598)
**Author:** [@Mesmer](https://discuss.elastic.co/u/Mesmer)\ **Replies:** 1\ **Last updated:** [April 26, 2019, 2:03pm UTC](https://discuss.elastic.co/t/index-lifecycle-dilemma/177598 "2019-04-26T14:03:41Z")
Hello, Trying to get my head around how ILM works. I have logstash creating these daily indices: and want to implement a simple ILM. output { elasticsearch { hosts =\> \["http://localhost:9200"\] index =\> "depo… --- ## [Elasticsearch IIS on a subpath](https://discuss.elastic.co/t/elasticsearch-iis-on-a-subpath/178650)
**Author:** [@Lorenzo\_De\_Francesco](https://discuss.elastic.co/u/Lorenzo_De_Francesco)\ **Replies:** 0\ **Last updated:** [April 26, 2019, 1:23pm UTC](https://discuss.elastic.co/t/elasticsearch-iis-on-a-subpath/178650 "2019-04-26T13:23:13Z")
Hi guys! I have an issue involving elasticsearch and the Node client (https://github.com/elastic/elasticsearch-js-legacy). I binded on IIS with a revese proxy the path http://host/elasticsearch with http://localhost:92… --- ## [Elasticsearch could not find Java and now won't start](https://discuss.elastic.co/t/elasticsearch-could-not-find-java-and-now-wont-start/173973)
**Author:** [@sc1](https://discuss.elastic.co/u/sc1)\ **Replies:** 20\ **Last updated:** [April 26, 2019, 12:40pm UTC](https://discuss.elastic.co/t/elasticsearch-could-not-find-java-and-now-wont-start/173973 "2019-04-26T12:40:56Z")
Hello, I recently updated 4 Elasticsearch nodes and I now have an error on 2 nodes, I have looked online about how to resolve it or specify but I can't find anything on the specific problem I am having (perhaps I am sea… --- ## [Minimum cluster config on the same machine for test](https://discuss.elastic.co/t/minimum-cluster-config-on-the-same-machine-for-test/178404)
**Author:** [@icirco](https://discuss.elastic.co/u/icirco)\ **Replies:** 9\ **Last updated:** [April 26, 2019, 12:24pm UTC](https://discuss.elastic.co/t/minimum-cluster-config-on-the-same-machine-for-test/178404 "2019-04-26T12:24:09Z")
hi, I tried to explore the cluster config and I can't configure the minimum config to run 2 nodes on the same machine (only for testing of course !) so, what is the minimum config for cluster config (ES 5) elasticsear… --- ## [Elasticsearch Log directory permission overriding with setgid](https://discuss.elastic.co/t/elasticsearch-log-directory-permission-overriding-with-setgid/178635)
**Author:** [@Hazoopr](https://discuss.elastic.co/u/Hazoopr)\ **Replies:** 0\ **Last updated:** [April 26, 2019, 11:35am UTC](https://discuss.elastic.co/t/elasticsearch-log-directory-permission-overriding-with-setgid/178635 "2019-04-26T11:35:38Z")
Elasticsearch Log directory permission overriding with setgid as given \*\*\[root@abcabc ~\]# ll /var/log/ | grep elasticsearch\*\* \*\*drwxr-s--- 2 elasticsearch elasticsearch 4096 Apr 22 10:07 elasticsearch\*\* Due to t… --- ## [How to configure elasticsearch on ec2 of aws for a single node?](https://discuss.elastic.co/t/how-to-configure-elasticsearch-on-ec2-of-aws-for-a-single-node/178616)
**Author:** [@Mohammed\_khan](https://discuss.elastic.co/u/Mohammed_khan)\ **Replies:** 3\ **Last updated:** [April 26, 2019, 10:59am UTC](https://discuss.elastic.co/t/how-to-configure-elasticsearch-on-ec2-of-aws-for-a-single-node/178616 "2019-04-26T10:59:10Z")
I saw many tutorials online for elasticsearch setup on ec2, they were for cluster setup. I want only one instance of elasticsearch. Hence i did the basic setup and changed network.host to "localhost", i was able to see o… --- ## [ELK Stack Community version](https://discuss.elastic.co/t/elk-stack-community-version/178223)
**Author:** [@nagr](https://discuss.elastic.co/u/nagr)\ **Replies:** 4\ **Last updated:** [April 26, 2019, 10:54am UTC](https://discuss.elastic.co/t/elk-stack-community-version/178223 "2019-04-26T10:54:47Z")
Hi All, Is this ELK stack community version available anywhere? We are working some AIops activities, so need to check the communities package version, Please help me with your input, Thanks, Nagaraj, --- ## [Bootstrapping a new cluster failed with ES7.0](https://discuss.elastic.co/t/bootstrapping-a-new-cluster-failed-with-es7-0/178610)
**Author:** [@LoadingZhang](https://discuss.elastic.co/u/LoadingZhang)\ **Replies:** 7\ **Last updated:** [April 26, 2019, 10:35am UTC](https://discuss.elastic.co/t/bootstrapping-a-new-cluster-failed-with-es7-0/178610 "2019-04-26T10:35:40Z")
I have setdiscovery.seed\_hosts and cluster.initial\_master\_nodes with three master node. ES outputs this message in log: \[WARN \]\[o.e.c.c.ClusterFormationFailureHelper\] \[c3-bigdata-es-master02.bj\] master not discovered y… --- ## [Unable to use coordinates map](https://discuss.elastic.co/t/unable-to-use-coordinates-map/177609)
**Author:** [@Vikash\_Singh1](https://discuss.elastic.co/u/Vikash_Singh1)\ **Replies:** 35\ **Last updated:** [April 26, 2019, 10:18am UTC](https://discuss.elastic.co/t/unable-to-use-coordinates-map/177609 "2019-04-26T10:18:59Z")
Although I am having all the information regarding geo locations but when I am trying to visualize it in kibana it says: No Compatible Fields: The logstash\_apchelogs index pattern does not contain any of the following … --- ## [Store Indexes on multiple drives](https://discuss.elastic.co/t/store-indexes-on-multiple-drives/178568)
**Author:** [@dheeraj\_kumar](https://discuss.elastic.co/u/dheeraj_kumar)\ **Replies:** 10\ **Last updated:** [April 26, 2019, 10:18am UTC](https://discuss.elastic.co/t/store-indexes-on-multiple-drives/178568 "2019-04-26T10:18:26Z")
I am new to ES ,I have single node ES instance on a Windows machine, i was trying to find a way to where i can point my new index on a new drive but i could not find any way of handling that. Even adding multiple path i… --- ## [ElasticSearch Index Mapping with Java Client](https://discuss.elastic.co/t/elasticsearch-index-mapping-with-java-client/177993)
**Author:** [@thebuleon29](https://discuss.elastic.co/u/thebuleon29)\ **Replies:** 3\ **Last updated:** [April 26, 2019, 10:12am UTC](https://discuss.elastic.co/t/elasticsearch-index-mapping-with-java-client/177993 "2019-04-26T10:12:42Z")
Hi, I want to use ElasticSearch 6.6 as a Time Series Database and need to map the timestamp as a date to plot the data in Grafana. I am stuck at the index creation because Java keeps throwing the same exception : org.e… --- ## [Inaccuracy for Geo Centroid Aggregation and Geo Bounds Aggregation](https://discuss.elastic.co/t/inaccuracy-for-geo-centroid-aggregation-and-geo-bounds-aggregation/175839)
**Author:** [@gemo1011](https://discuss.elastic.co/u/gemo1011)\ **Replies:** 6\ **Last updated:** [April 26, 2019, 10:04am UTC](https://discuss.elastic.co/t/inaccuracy-for-geo-centroid-aggregation-and-geo-bounds-aggregation/175839 "2019-04-26T10:04:34Z")
Hello, while testing some geo functions for Elasticsearch I discovered an inacurracy for the Geo Centroid Aggregation and the Geo Bounds Aggregation. For test purpose I'm using the geonames dataset. An collection of ar… --- ## [Get duplicate documents based on duplicate nested type](https://discuss.elastic.co/t/get-duplicate-documents-based-on-duplicate-nested-type/178613)
**Author:** [@Q.S](https://discuss.elastic.co/u/Q.S)\ **Replies:** 0\ **Last updated:** [April 26, 2019, 9:53am UTC](https://discuss.elastic.co/t/get-duplicate-documents-based-on-duplicate-nested-type/178613 "2019-04-26T09:53:44Z")
Good day guys. I have a document type "generalTask" with an array of nested documents called "completeUser". Here is the mapping : { "generalTask": { "properties": { "id": { "ty… --- ## [Failed to start Machine Learning on Elasticsearch 7.0.0](https://discuss.elastic.co/t/failed-to-start-machine-learning-on-elasticsearch-7-0-0/178216)
**Author:** [@JoseLuis](https://discuss.elastic.co/u/JoseLuis)\ **Replies:** 8\ **Last updated:** [April 26, 2019, 9:36am UTC](https://discuss.elastic.co/t/failed-to-start-machine-learning-on-elasticsearch-7-0-0/178216 "2019-04-26T09:36:00Z")
Hello, today I installed the new version 7.0.0 to probe it on a new machine (with Centos 7) and see what is new respect other versions but when i turn on elasticsearch i receive the next error: \[2019-04-24T10:17:33,270\]… --- ## [Elasticsearch sql problem](https://discuss.elastic.co/t/elasticsearch-sql-problem/178349)
**Author:** [@zhang\_yue](https://discuss.elastic.co/u/zhang_yue)\ **Replies:** 2\ **Last updated:** [April 26, 2019, 9:09am UTC](https://discuss.elastic.co/t/elasticsearch-sql-problem/178349 "2019-04-26T09:09:16Z")
--- ## [Sum() in elastic search Using SQL Plugin](https://discuss.elastic.co/t/sum-in-elastic-search-using-sql-plugin/178511)
**Author:** [@shrutip](https://discuss.elastic.co/u/shrutip)\ **Replies:** 1\ **Last updated:** [April 26, 2019, 9:07am UTC](https://discuss.elastic.co/t/sum-in-elastic-search-using-sql-plugin/178511 "2019-04-26T09:07:42Z")
Hello , I am running a sql query on elastic sql plugin but the sum which I am getting is not correct ... Query is - SELECT Field1,Field2,SUM(Field3) st FROM XXX where Field4='ZZZ' and Field5= 'YYY' GROUP BY Field… --- ## [Elasticsearch index name is ".kibana" instead of "filebeat-\*"](https://discuss.elastic.co/t/elasticsearch-index-name-is-kibana-instead-of-filebeat/178308)
**Author:** [@telkhayat](https://discuss.elastic.co/u/telkhayat)\ **Replies:** 8\ **Last updated:** [April 26, 2019, 9:07am UTC](https://discuss.elastic.co/t/elasticsearch-index-name-is-kibana-instead-of-filebeat/178308 "2019-04-26T09:07:41Z")
Hi, I've just setup Elasticsearch (6.0.0), Filebeat(6.0.1) and Kibana(6.0.0) under java8. Kibana seems to look after an index named "filebeat-\*", but when I check the index name in elasticsearch it shows something like… --- ## [Elasticsearch | Relationships based index](https://discuss.elastic.co/t/elasticsearch-relationships-based-index/176058)
**Author:** [@Nikesh](https://discuss.elastic.co/u/Nikesh)\ **Replies:** 17\ **Last updated:** [April 26, 2019, 9:06am UTC](https://discuss.elastic.co/t/elasticsearch-relationships-based-index/176058 "2019-04-26T09:06:54Z")
As asked in this link I need to provide relationship based search. Let's consider the same scenario. Team and Players would contain similar fields. A single team can have multiple players. Having a Single Index for… --- ## [How to add contexts to Suggestion Builder in java](https://discuss.elastic.co/t/how-to-add-contexts-to-suggestion-builder-in-java/178595)
**Author:** [@pkaul](https://discuss.elastic.co/u/pkaul)\ **Replies:** 0\ **Last updated:** [April 26, 2019, 8:58am UTC](https://discuss.elastic.co/t/how-to-add-contexts-to-suggestion-builder-in-java/178595 "2019-04-26T08:58:04Z")
SuggestionBuilder suggestionBuilder = SuggestBuilders.completionSuggestion("suggest").prefix("test").contexts(Collections.singletonMap("cat", Collections.singletonList(CategoryQueryContext.builder().setCategory("cat0").b… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1317) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1319)