# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1694 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1695 --- ## [Aggregation with terms and cardinality deliver different results](https://discuss.elastic.co/t/aggregation-with-terms-and-cardinality-deliver-different-results/131155)
**Author:** [@Alexander\_Zerr](https://discuss.elastic.co/u/Alexander_Zerr)\ **Replies:** 1\ **Last updated:** [May 9, 2018, 11:11am UTC](https://discuss.elastic.co/t/aggregation-with-terms-and-cardinality-deliver-different-results/131155 "2018-05-09T11:11:20Z")
I have big trouble with cardinality and term aggregation. Different aggregation over my index with 2700k entries deliver me diverse count/sum. Is it possible to get the correct count from ES like MySql or is ES not the b… --- ## [Running Elasticsearch in Windows PS](https://discuss.elastic.co/t/running-elasticsearch-in-windows-ps/130953)
**Author:** [@rodel](https://discuss.elastic.co/u/rodel)\ **Replies:** 2\ **Last updated:** [May 9, 2018, 11:01am UTC](https://discuss.elastic.co/t/running-elasticsearch-in-windows-ps/130953 "2018-05-09T11:01:30Z")
Hi guys! I'm running ES using Windows PS. Executing the basic .\\bin\\elasticsearch.bat is working fine. But when I try to run it with configuration using -E syntax, I'm getting an error. \[image\] --- ## [Security without x-pack (on windows)](https://discuss.elastic.co/t/security-without-x-pack-on-windows/131161)
**Author:** [@CCCowboy](https://discuss.elastic.co/u/CCCowboy)\ **Replies:** 0\ **Last updated:** [May 9, 2018, 10:44am UTC](https://discuss.elastic.co/t/security-without-x-pack-on-windows/131161 "2018-05-09T10:44:52Z")
Hi, I am going to set up a 6.2 ES cluster spanning over three data centers in a Windows environment. I am concerned about the security. I know how to use IIS to set up https between the clients and the cluster. But is … --- ## [Elasticsearch 6.2.4 not working when using OpenJDK 9](https://discuss.elastic.co/t/elasticsearch-6-2-4-not-working-when-using-openjdk-9/131108)
**Author:** [@Rajeshg007](https://discuss.elastic.co/u/Rajeshg007)\ **Replies:** 8\ **Last updated:** [May 9, 2018, 10:34am UTC](https://discuss.elastic.co/t/elasticsearch-6-2-4-not-working-when-using-openjdk-9/131108 "2018-05-09T10:34:05Z")
Hi, I am Trying to Run Elasticsearch 6.2.4 on OpenJdk 9, But when ever i try to start elasticsearch, i get the below error, May 09 06:37:03 ip-172-31-48-228 systemd\[1\]: Started Elasticsearch. May 09 06:37:09 ip-172-… --- ## [How to resolve Dangling indices error on each Index](https://discuss.elastic.co/t/how-to-resolve-dangling-indices-error-on-each-index/130609)
**Author:** [@PinkiMondal](https://discuss.elastic.co/u/PinkiMondal)\ **Replies:** 10\ **Last updated:** [May 9, 2018, 9:56am UTC](https://discuss.elastic.co/t/how-to-resolve-dangling-indices-error-on-each-index/130609 "2018-05-09T09:56:11Z")
Hi All, I am getting "can not be imported as a dangling index, as index with same name already exists in cluster metadata" message for each index Please help how to resolve it --- ## [Es node failed to send join request to each other，how to solve it？](https://discuss.elastic.co/t/es-node-failed-to-send-join-request-to-each-other-how-to-solve-it/130242)
**Author:** [@forestfantacy](https://discuss.elastic.co/u/forestfantacy)\ **Replies:** 3\ **Last updated:** [May 9, 2018, 9:31am UTC](https://discuss.elastic.co/t/es-node-failed-to-send-join-request-to-each-other-how-to-solve-it/130242 "2018-05-09T09:31:22Z")
this problem happened in es5.x & netty4, it can solving by downgrading to netty3, but es6.x is no longer support netty3, and netty4 don't work still, so how can i do --- ## [Counting distinct on multiple columns](https://discuss.elastic.co/t/counting-distinct-on-multiple-columns/131132)
**Author:** [@devil\_srj7](https://discuss.elastic.co/u/devil_srj7)\ **Replies:** 1\ **Last updated:** [May 9, 2018, 9:23am UTC](https://discuss.elastic.co/t/counting-distinct-on-multiple-columns/131132 "2018-05-09T09:23:01Z")
I need to get the count on distinct multiple columns like : count( distinct column1, column 2 ) --- ## [Elastic aggregation, how does it works?](https://discuss.elastic.co/t/elastic-aggregation-how-does-it-works/131114)
**Author:** [@vikas1994](https://discuss.elastic.co/u/vikas1994)\ **Replies:** 4\ **Last updated:** [May 9, 2018, 8:49am UTC](https://discuss.elastic.co/t/elastic-aggregation-how-does-it-works/131114 "2018-05-09T08:49:38Z")
Please tell the how the aggregation query works in elasticsearch. please tell the steps which aggregation will execute first in sub aggregation.? --- ## [Elasticsearch high latency](https://discuss.elastic.co/t/elasticsearch-high-latency/130179)
**Author:** [@arun\_kishore](https://discuss.elastic.co/u/arun_kishore)\ **Replies:** 18\ **Last updated:** [May 9, 2018, 8:47am UTC](https://discuss.elastic.co/t/elasticsearch-high-latency/130179 "2018-05-09T08:47:32Z")
Hey guys, we have been using Elasticsearch 1.7.4 for over 3 years now, and we just upgraded to 6.1.1 version, We have completed our data backfill and start testing our queries. But unfortunately we are seeing really hig… --- ## [User dictionary file support for AWS Elasticsearch Service?](https://discuss.elastic.co/t/user-dictionary-file-support-for-aws-elasticsearch-service/130245)
**Author:** [@Boney\_Jacob](https://discuss.elastic.co/u/Boney_Jacob)\ **Replies:** 4\ **Last updated:** [May 9, 2018, 7:52am UTC](https://discuss.elastic.co/t/user-dictionary-file-support-for-aws-elasticsearch-service/130245 "2018-05-09T07:52:32Z")
I'm using AWS Elasticsearch Service6.2 with kuromoji plugin. Is it support user\_dictionary file? How to create it in aws elasticsearch? kuromoji\_tokenizer --- ## [How to store a geo point csv file (contents) in elasticsearch and use it in a query filter against a field in an index](https://discuss.elastic.co/t/how-to-store-a-geo-point-csv-file-contents-in-elasticsearch-and-use-it-in-a-query-filter-against-a-field-in-an-index/131111)
**Author:** [@frehman\_pk](https://discuss.elastic.co/u/frehman_pk)\ **Replies:** 8\ **Last updated:** [May 9, 2018, 7:39am UTC](https://discuss.elastic.co/t/how-to-store-a-geo-point-csv-file-contents-in-elasticsearch-and-use-it-in-a-query-filter-against-a-field-in-an-index/131111 "2018-05-09T07:39:04Z")
I am new to ES. I have an index of user profiles, index contains geo point data of users along with the other fields. we upload a csv file containing geo points and i need to write a query to filter user based on the geo… --- ## [Elk stack node number](https://discuss.elastic.co/t/elk-stack-node-number/131027)
**Author:** [@mkemalm](https://discuss.elastic.co/u/mkemalm)\ **Replies:** 2\ **Last updated:** [May 9, 2018, 7:13am UTC](https://discuss.elastic.co/t/elk-stack-node-number/131027 "2018-05-09T07:13:02Z")
Hi, I am curious about how can I decide number of nodes for a production elk stack cluster. My questions are below; How can I decide; -How many data nodes do I need? (how many of them are for hot data, how many of the… --- ## [Ingest Json File into Elasticsearch](https://discuss.elastic.co/t/ingest-json-file-into-elasticsearch/130871)
**Author:** [@Mahroon](https://discuss.elastic.co/u/Mahroon)\ **Replies:** 2\ **Last updated:** [May 9, 2018, 7:03am UTC](https://discuss.elastic.co/t/ingest-json-file-into-elasticsearch/130871 "2018-05-09T07:03:18Z")
Dear Elasticer, The main question is how to ingest the json file into ES? Should I create an index and after that mapping then I can Ingest the data. Look forward to hearing from you soon. Thanks, --- ## [Cannot Build Using Gradle; JAVA\_HOME Not found](https://discuss.elastic.co/t/cannot-build-using-gradle-java-home-not-found/131062)
**Author:** [@\_mni](https://discuss.elastic.co/u/_mni)\ **Replies:** 8\ **Last updated:** [May 9, 2018, 6:55am UTC](https://discuss.elastic.co/t/cannot-build-using-gradle-java-home-not-found/131062 "2018-05-09T06:55:43Z")
I am trying to build on the custom-realm-example as published on github. However, no matter what I do I am unable to build the project. Here's some details on what's going on: ➜ shield-custom-realm-example git:(master)… --- ## [This version of Kibana requires Elasticsearch v6.2.3 on all nodes](https://discuss.elastic.co/t/this-version-of-kibana-requires-elasticsearch-v6-2-3-on-all-nodes/131024)
**Author:** [@randomuser](https://discuss.elastic.co/u/randomuser)\ **Replies:** 7\ **Last updated:** [May 9, 2018, 6:41am UTC](https://discuss.elastic.co/t/this-version-of-kibana-requires-elasticsearch-v6-2-3-on-all-nodes/131024 "2018-05-09T06:41:32Z")
Hello, Still new to the Elastic stack, investigating, learning.. but occasionally I run into problems which take me hours without any sight of a solution, but in the end it's always some minor bug (yeah, I might have th… --- ## [Error "Path does not chain with any of the trust anchors" when enabling TSL between nodes](https://discuss.elastic.co/t/error-path-does-not-chain-with-any-of-the-trust-anchors-when-enabling-tsl-between-nodes/131078)
**Author:** [@mlemartien](https://discuss.elastic.co/u/mlemartien)\ **Replies:** 4\ **Last updated:** [May 9, 2018, 4:04am UTC](https://discuss.elastic.co/t/error-path-does-not-chain-with-any-of-the-trust-anchors-when-enabling-tsl-between-nodes/131078 "2018-05-09T04:04:21Z")
Hi, I have been trying to enable TLS encryption between my nodes. I have followed the instructions of the documentation and generated p12-format certificates for each node and configured my cluster like this (the certif… --- ## [Dependency Error while using Java High Level Rest Client](https://discuss.elastic.co/t/dependency-error-while-using-java-high-level-rest-client/131088)
**Author:** [@Littlestay](https://discuss.elastic.co/u/Littlestay)\ **Replies:** 2\ **Last updated:** [May 9, 2018, 3:46am UTC](https://discuss.elastic.co/t/dependency-error-while-using-java-high-level-rest-client/131088 "2018-05-09T03:46:40Z")
Hi, I am trying to develop a spring boot based elasticsearch project and I am trying to use Java High Level Rest Client in the same. I am initializing the client like this: Caused by: java.lang.BootstrapMethodError: … --- ## [Phantom Index](https://discuss.elastic.co/t/phantom-index/130680)
**Author:** [@dalamar666](https://discuss.elastic.co/u/dalamar666)\ **Replies:** 3\ **Last updated:** [May 9, 2018, 3:39am UTC](https://discuss.elastic.co/t/phantom-index/130680 "2018-05-09T03:39:23Z")
Hi, I have discovered a phantom index starting. I have been through my conf file and I cannot find any reference to this index. Is there any command etc. I can use to find what configuration file is creating this inde… --- ## [Nested become array object after re-indexing?](https://discuss.elastic.co/t/nested-become-array-object-after-re-indexing/130980)
**Author:** [@yanwiii](https://discuss.elastic.co/u/yanwiii)\ **Replies:** 3\ **Last updated:** [May 9, 2018, 2:21am UTC](https://discuss.elastic.co/t/nested-become-array-object-after-re-indexing/130980 "2018-05-09T02:21:59Z")
my mappings: { "mappings":{ "test":{ "properties":{ "date":{ "type":"nested", "properties":{....} } } … --- ## [Migrating from ES 2.4 to 6.2, best approach?](https://discuss.elastic.co/t/migrating-from-es-2-4-to-6-2-best-approach/130764)
**Author:** [@ahbruinsma](https://discuss.elastic.co/u/ahbruinsma)\ **Replies:** 2\ **Last updated:** [May 9, 2018, 12:51am UTC](https://discuss.elastic.co/t/migrating-from-es-2-4-to-6-2-best-approach/130764 "2018-05-09T00:51:41Z")
Hello, I'm fairly new to EleasticSearch, but we've got 2 clusters already. A 2.4 cluster running on 2 nodes and a 6.2 cluster running on 4 nodes. Now we want to migrate the data on the 2.4 cluster to the 6.2 cluster, bu… --- ## [Installed x-pack - discover shows no results found](https://discuss.elastic.co/t/installed-x-pack-discover-shows-no-results-found/130896)
**Author:** [@irb7501](https://discuss.elastic.co/u/irb7501)\ **Replies:** 14\ **Last updated:** [May 9, 2018, 12:42am UTC](https://discuss.elastic.co/t/installed-x-pack-discover-shows-no-results-found/130896 "2018-05-09T00:42:18Z")
I have (finally) successfully installed x-pack...so it seems. The current issue is I get no results under kibana's discover tab. I have the following alerts: Medium 17 min ago Elasticsearch cluster nodes have changed… --- ## [Upgrade to x-pack failure, cannot set passwords](https://discuss.elastic.co/t/upgrade-to-x-pack-failure-cannot-set-passwords/130880)
**Author:** [@rmac](https://discuss.elastic.co/u/rmac)\ **Replies:** 4\ **Last updated:** [May 9, 2018, 12:40am UTC](https://discuss.elastic.co/t/upgrade-to-x-pack-failure-cannot-set-passwords/130880 "2018-05-09T00:40:20Z")
Per the opening of x-pack, I've tried to upgrade to it with my current cluster. I perhaps did not do enough research into what's involved but here I am. I have a trial license and ES version 6.1. Here's what I did: D… --- ## [How to recover elasticsearch cluster login](https://discuss.elastic.co/t/how-to-recover-elasticsearch-cluster-login/131068)
**Author:** [@Yipeng](https://discuss.elastic.co/u/Yipeng)\ **Replies:** 2\ **Last updated:** [May 8, 2018, 10:20pm UTC](https://discuss.elastic.co/t/how-to-recover-elasticsearch-cluster-login/131068 "2018-05-08T22:20:21Z")
I am using elastic.co cloud service. I have two clusters, one for elasticsearch and the other for kibana. Sadly I forgot the login information for the elasticsearch (dab615002f1f0e4533dfffad060755dc). Any way to recover … --- ## [Reduce data paths on running cluster](https://discuss.elastic.co/t/reduce-data-paths-on-running-cluster/130997)
**Author:** [@imehl](https://discuss.elastic.co/u/imehl)\ **Replies:** 1\ **Last updated:** [May 8, 2018, 10:05pm UTC](https://discuss.elastic.co/t/reduce-data-paths-on-running-cluster/130997 "2018-05-08T22:05:11Z")
Hi, we want to change the storage layer of our Elasticsearch Cluster (6.2.4). It would be necessary to reduce the "path.data" paths on each node from 6 to 4. Is this even possible? if yes also without downtime (rolling)… --- ## [Authentication with JWT and FallBack on Basic](https://discuss.elastic.co/t/authentication-with-jwt-and-fallback-on-basic/131038)
**Author:** [@\_mni](https://discuss.elastic.co/u/_mni)\ **Replies:** 1\ **Last updated:** [May 8, 2018, 10:00pm UTC](https://discuss.elastic.co/t/authentication-with-jwt-and-fallback-on-basic/131038 "2018-05-08T22:00:34Z")
Hi, I am investigating a use case where my users could provide auth params and ES should first try doing a JWT auth; if that fails, it should fall back on Basic auth. I have read through that this might be possible usi… --- ## [Unable to create elasticserach backup on glusterfs](https://discuss.elastic.co/t/unable-to-create-elasticserach-backup-on-glusterfs/131065)
**Author:** [@Snehit\_Gajjar](https://discuss.elastic.co/u/Snehit_Gajjar)\ **Replies:** 0\ **Last updated:** [May 8, 2018, 8:56pm UTC](https://discuss.elastic.co/t/unable-to-create-elasticserach-backup-on-glusterfs/131065 "2018-05-08T20:56:44Z")
I have 3-node elasticsearch cluster. I had issue where snapshots were not created. At that time I did not have shared filesystem across all three nodes. So I went ahead and used glusterfs to create shared filesystem. Now… --- ## [Trying to upload data via bulk apis as per tutorial- not working](https://discuss.elastic.co/t/trying-to-upload-data-via-bulk-apis-as-per-tutorial-not-working/130072)
**Author:** [@rbradley](https://discuss.elastic.co/u/rbradley)\ **Replies:** 2\ **Last updated:** [May 8, 2018, 8:55pm UTC](https://discuss.elastic.co/t/trying-to-upload-data-via-bulk-apis-as-per-tutorial-not-working/130072 "2018-05-08T20:55:06Z")
as per this tutorial: https://www.elastic.co/guide/en/kibana/6.x/tutorial-load-dataset.html I am trying to upload data from downloaded files in bulk using the following links but it isnt working curl -H 'Content-Type: … --- ## [Elasticsearch Field Preference for result sequence](https://discuss.elastic.co/t/elasticsearch-field-preference-for-result-sequence/131051)
**Author:** [@surajdalvi](https://discuss.elastic.co/u/surajdalvi)\ **Replies:** 0\ **Last updated:** [May 8, 2018, 7:13pm UTC](https://discuss.elastic.co/t/elasticsearch-field-preference-for-result-sequence/131051 "2018-05-08T19:13:19Z")
I have created the index in elasticsearch with the following mapping: { "test": { "mappings": { "documents": { "properties": { "fields": { … --- ## [Elasticsearch indexing error](https://discuss.elastic.co/t/elasticsearch-indexing-error/130981)
**Author:** [@cybersecc](https://discuss.elastic.co/u/cybersecc)\ **Replies:** 11\ **Last updated:** [May 8, 2018, 6:30pm UTC](https://discuss.elastic.co/t/elasticsearch-indexing-error/130981 "2018-05-08T18:30:55Z")
\[2018-05-08T08:28:00,038\]\[WARN \]\[logstash.outputs.elasticsearch\] Could not index event to Elasticsearch. {:status=\>400, :action=\>\["index", {:\_id=\>"02b93158-3f9e-4931-8e2c-1c8186aed688", :\_index=\>"aa-2018-05-08", :\_type=\>"… --- ## [Puzzled about message: Configuring TLS will be required to apply a Gold or Platinum license when security is enabled](https://discuss.elastic.co/t/puzzled-about-message-configuring-tls-will-be-required-to-apply-a-gold-or-platinum-license-when-security-is-enabled/130520)
**Author:** [@mlemartien](https://discuss.elastic.co/u/mlemartien)\ **Replies:** 3\ **Last updated:** [May 8, 2018, 6:17pm UTC](https://discuss.elastic.co/t/puzzled-about-message-configuring-tls-will-be-required-to-apply-a-gold-or-platinum-license-when-security-is-enabled/130520 "2018-05-08T18:17:38Z")
Hi, I am trying Elasticsearch and Kibana 6.2.4 with X-Pack. I have successfully configured TLS at all levels (node, kibana to cluster, browser to Kibana). I am puzzled by the cluster alert that remains visible in Kiban… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1693) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1695)