# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1253 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1254 --- ## [Cannot figure out how to set a username and password with X-Pack in docker](https://discuss.elastic.co/t/cannot-figure-out-how-to-set-a-username-and-password-with-x-pack-in-docker/186145)
**Author:** [@weskerfoot](https://discuss.elastic.co/u/weskerfoot)\ **Replies:** 4\ **Last updated:** [June 24, 2019, 12:11pm UTC](https://discuss.elastic.co/t/cannot-figure-out-how-to-set-a-username-and-password-with-x-pack-in-docker/186145 "2019-06-24T12:11:06Z")
The documentation here https://www.elastic.co/guide/en/x-pack/current/setting-up-authentication.html#set-built-in-user-passwords States that we can use "bin/x-pack/setup-passwords interactive" to set a password. I am t… --- ## [Unable to add a new node on my elasticsearch cluster](https://discuss.elastic.co/t/unable-to-add-a-new-node-on-my-elasticsearch-cluster/186900)
**Author:** [@Mickael\_Bellengier](https://discuss.elastic.co/u/Mickael_Bellengier)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 12:06pm UTC](https://discuss.elastic.co/t/unable-to-add-a-new-node-on-my-elasticsearch-cluster/186900 "2019-06-24T12:06:34Z")
Hi, I have an elasticsearch cluster (v 1.7.6) with 18 nodes (16 data nodes on 4 physical hosts (CentOS)). Each host have 128 GB of RAM and each data node have 16 GB of JVM HEAP. I want to add a new data node on each p… --- ## [Curator age filter not matcing all indices](https://discuss.elastic.co/t/curator-age-filter-not-matcing-all-indices/187083)
**Author:** [@victor.nilsson](https://discuss.elastic.co/u/victor.nilsson)\ **Replies:** 11\ **Last updated:** [June 24, 2019, 11:31am UTC](https://discuss.elastic.co/t/curator-age-filter-not-matcing-all-indices/187083 "2019-06-24T11:31:00Z")
Hi, We are creating daily indices and have a need of automatically closing them when they get older than 3 months. I have the following in my Curator action file: 14: action: close description: \>- Close i… --- ## [Any one setup 3 node cluster with elasticsearch v 7](https://discuss.elastic.co/t/any-one-setup-3-node-cluster-with-elasticsearch-v-7/187109)
**Author:** [@nuwan](https://discuss.elastic.co/u/nuwan)\ **Replies:** 0\ **Last updated:** [June 24, 2019, 11:23am UTC](https://discuss.elastic.co/t/any-one-setup-3-node-cluster-with-elasticsearch-v-7/187109 "2019-06-24T11:23:04Z")
Hi Anyone setup 3 node cluster with elasticsearch v 7 . Please help me with a sample configuration for elasticsearch and kibana --- ## [Sort by driving distance](https://discuss.elastic.co/t/sort-by-driving-distance/187108)
**Author:** [@SandeepSatheesh](https://discuss.elastic.co/u/SandeepSatheesh)\ **Replies:** 0\ **Last updated:** [June 24, 2019, 11:17am UTC](https://discuss.elastic.co/t/sort-by-driving-distance/187108 "2019-06-24T11:17:26Z")
Apart from the approaches mentioned in the above post, what alternatives are there? Is it possible to write a plugin (distance will be calculated using google maps api) to implement this? --- ## [How to indexing primary key column datatype is String](https://discuss.elastic.co/t/how-to-indexing-primary-key-column-datatype-is-string/187099)
**Author:** [@gorrela\_lokesh](https://discuss.elastic.co/u/gorrela_lokesh)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 10:53am UTC](https://discuss.elastic.co/t/how-to-indexing-primary-key-column-datatype-is-string/187099 "2019-06-24T10:53:41Z")
In my application I have a one Entity class , In that class Primary Key column datatype is String. I am trying to indexing that Entity but it is not indexing. If anyone know about this please give me a suggestions… --- ## [Compare oracle data elastic-search data](https://discuss.elastic.co/t/compare-oracle-data-elastic-search-data/186525)
**Author:** [@elk3](https://discuss.elastic.co/u/elk3)\ **Replies:** 4\ **Last updated:** [June 24, 2019, 10:52am UTC](https://discuss.elastic.co/t/compare-oracle-data-elastic-search-data/186525 "2019-06-24T10:52:39Z")
i have oracle output and elasticsearch output so i want compare both data ,but i did manually ,know i am planing to automate the process which automatically compare data and through error ,whether its possible --- ## [HTTP Delete request takes forever](https://discuss.elastic.co/t/http-delete-request-takes-forever/186450)
**Author:** [@Miao](https://discuss.elastic.co/u/Miao)\ **Replies:** 7\ **Last updated:** [June 24, 2019, 10:40am UTC](https://discuss.elastic.co/t/http-delete-request-takes-forever/186450 "2019-06-24T10:40:41Z")
I am currently using the Insomnia REST client. When I make GET requests to my ElasticSearch server, I receive HTTP responses very promptly. However, DELETE requests take forever, and never actually finish: The index… --- ## [Is there any way to use one query aggregation result as the filter for other query](https://discuss.elastic.co/t/is-there-any-way-to-use-one-query-aggregation-result-as-the-filter-for-other-query/187095)
**Author:** [@BleedCode](https://discuss.elastic.co/u/BleedCode)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 9:47am UTC](https://discuss.elastic.co/t/is-there-any-way-to-use-one-query-aggregation-result-as-the-filter-for-other-query/187095 "2019-06-24T09:47:04Z")
Is there any approach by using which i can pass the aggregation result as the input for other query. By aggregation result i mean the buckets key value. I want to use the "key" field value as the filter for other query. … --- ## [The usefulness of indexing images in ES](https://discuss.elastic.co/t/the-usefulness-of-indexing-images-in-es/187085)
**Author:** [@kumar4](https://discuss.elastic.co/u/kumar4)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 9:32am UTC](https://discuss.elastic.co/t/the-usefulness-of-indexing-images-in-es/187085 "2019-06-24T09:32:59Z")
hello, I want to know the utility of indexing images in ES, why indexing images and pdf in ES, is it possible to recover this images unsing ES in case of damage --- ## [Basic license - some xpack options seem to be wrongfully not available?](https://discuss.elastic.co/t/basic-license-some-xpack-options-seem-to-be-wrongfully-not-available/187076)
**Author:** [@bezopaznosti](https://discuss.elastic.co/u/bezopaznosti)\ **Replies:** 4\ **Last updated:** [June 24, 2019, 9:30am UTC](https://discuss.elastic.co/t/basic-license-some-xpack-options-seem-to-be-wrongfully-not-available/187076 "2019-06-24T09:30:18Z")
Hey all, When reading the subscriptions page, it seemed to me as if some xpack security options would be available for a basic license. The subscription page mentions that following options should be available: Encrypte… --- ## [Accesing ES database to build cutomuize queries](https://discuss.elastic.co/t/accesing-es-database-to-build-cutomuize-queries/187086)
**Author:** [@kumar4](https://discuss.elastic.co/u/kumar4)\ **Replies:** 0\ **Last updated:** [June 24, 2019, 9:00am UTC](https://discuss.elastic.co/t/accesing-es-database-to-build-cutomuize-queries/187086 "2019-06-24T09:00:33Z")
I am using logstash to collect data and using Kibana to visulaize it, but i foud that some feature are not available in KIbana so i want to know how to acces the data collected to perpare somme querts and graphical chart… --- ## [Is there a configuration in esrally to replicate the track data X times or run index-append for a specific period of time?](https://discuss.elastic.co/t/is-there-a-configuration-in-esrally-to-replicate-the-track-data-x-times-or-run-index-append-for-a-specific-period-of-time/186999)
**Author:** [@Ali\_Reza\_Haghighat](https://discuss.elastic.co/u/Ali_Reza_Haghighat)\ **Replies:** 7\ **Last updated:** [June 24, 2019, 8:04am UTC](https://discuss.elastic.co/t/is-there-a-configuration-in-esrally-to-replicate-the-track-data-x-times-or-run-index-append-for-a-specific-period-of-time/186999 "2019-06-24T08:04:20Z")
Hello, I'm a newbie to elastic and esrally. I'm using esrally to benchmark our elastic cluster. Currently, I want to measure the index-append rate of our cluster using our sample data. With the default configuration, th… --- ## [Special case of aggregate query](https://discuss.elastic.co/t/special-case-of-aggregate-query/186668)
**Author:** [@Pavan\_Kundgol](https://discuss.elastic.co/u/Pavan_Kundgol)\ **Replies:** 0\ **Last updated:** [June 20, 2019, 11:30am UTC](https://discuss.elastic.co/t/special-case-of-aggregate-query/186668 "2019-06-20T11:30:18Z")
Hi Team , I have documents stored in ES with below structure : Column1 | Column2 | Column3 Doc1 | P1 | T1 Doc2 | P1 | Doc3 | P1 | Doc4 | P2 … --- ## [Master not discovered or elected yet, an election requires a node with id](https://discuss.elastic.co/t/master-not-discovered-or-elected-yet-an-election-requires-a-node-with-id/186704)
**Author:** [@SukeshGupta](https://discuss.elastic.co/u/SukeshGupta)\ **Replies:** 8\ **Last updated:** [June 24, 2019, 7:04am UTC](https://discuss.elastic.co/t/master-not-discovered-or-elected-yet-an-election-requires-a-node-with-id/186704 "2019-06-24T07:04:19Z")
Hi, version: 7.0.1 I have 2 nodes in my local with the following configuration: First one yml details : node.max\_local\_storage\_nodes: 10 node.name: node-1 node.data: true node.master: true transport.tcp.port: 930… --- ## [New cluster best practice - discovery.zen.ping.unicast.hosts:](https://discuss.elastic.co/t/new-cluster-best-practice-discovery-zen-ping-unicast-hosts/186964)
**Author:** [@jamesp220291](https://discuss.elastic.co/u/jamesp220291)\ **Replies:** 9\ **Last updated:** [June 24, 2019, 6:40am UTC](https://discuss.elastic.co/t/new-cluster-best-practice-discovery-zen-ping-unicast-hosts/186964 "2019-06-24T06:40:08Z")
Hi I am building the below cluster 3x dedicated masters 3x dedicated data nodes 1x coordinator node In the setting - discovery.zen.ping.unicast.hosts: Do I only put the 3x dedicated masters, or shall I put the IP's… --- ## [Add external libraries to elasticsearch](https://discuss.elastic.co/t/add-external-libraries-to-elasticsearch/186845)
**Author:** [@MKU](https://discuss.elastic.co/u/MKU)\ **Replies:** 9\ **Last updated:** [June 24, 2019, 5:32am UTC](https://discuss.elastic.co/t/add-external-libraries-to-elasticsearch/186845 "2019-06-24T05:32:32Z")
I would want to add org.apache.http libraries to the gradle file .how do i do that thanks --- ## [How are keywords indexed](https://discuss.elastic.co/t/how-are-keywords-indexed/187025)
**Author:** [@shekharshan](https://discuss.elastic.co/u/shekharshan)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 5:29am UTC](https://discuss.elastic.co/t/how-are-keywords-indexed/187025 "2019-06-24T05:29:21Z")
I am new to this topic of text searching so I have some confusions. I understand that full text data goes through the analyzer that does the following processing: Tokenizes the full text into individual words Throws aw… --- ## [Translog Reader](https://discuss.elastic.co/t/translog-reader/187038)
**Author:** [@Saravanan\_Kandasamy](https://discuss.elastic.co/u/Saravanan_Kandasamy)\ **Replies:** 0\ **Last updated:** [June 24, 2019, 4:21am UTC](https://discuss.elastic.co/t/translog-reader/187038 "2019-06-24T04:21:42Z")
Is there any tool or an API available to read Elastic Search translog? --- ## [Support for Aggregations in Spark](https://discuss.elastic.co/t/support-for-aggregations-in-spark/182251)
**Author:** [@angelazhao](https://discuss.elastic.co/u/angelazhao)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 3:14am UTC](https://discuss.elastic.co/t/support-for-aggregations-in-spark/182251 "2019-06-24T03:14:35Z")
Is it now possible to perform ES aggregations using Spark? An earlier post from March 2016 says the functionality isn't available yet but is on the roadmap. Can you please give me an update on its status? Thanks! --- ## [ES+Hadoop+Spark 6.6 securable keystore](https://discuss.elastic.co/t/es-hadoop-spark-6-6-securable-keystore/184634)
**Author:** [@Miguel\_Oliveira](https://discuss.elastic.co/u/Miguel_Oliveira)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 3:06am UTC](https://discuss.elastic.co/t/es-hadoop-spark-6-6-securable-keystore/184634 "2019-06-24T03:06:54Z")
Hello all, Following the instructions on https://www.elastic.co/guide/en/elasticsearch/hadoop/6.6/security.html#keystore, we have successfully created a keystore. So far we added to it the key="es.net.http.auth.pass" w… --- ## [Loading csv hdfs to ES](https://discuss.elastic.co/t/loading-csv-hdfs-to-es/184992)
**Author:** [@genesis](https://discuss.elastic.co/u/genesis)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 2:56am UTC](https://discuss.elastic.co/t/loading-csv-hdfs-to-es/184992 "2019-06-24T02:56:04Z")
I am trying to load cvs files that are in HDFS into ElasticSearch, can someone please guide me the best way to accomplish this task hdfs cvs files: /user/xxxxx/mpc.db/ ES: http:elasticsearch.pulse.prod:9200 --- ## [Hive ES issue](https://discuss.elastic.co/t/hive-es-issue/183659)
**Author:** [@manoj\_kumar3](https://discuss.elastic.co/u/manoj_kumar3)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 2:55am UTC](https://discuss.elastic.co/t/hive-es-issue/183659 "2019-06-24T02:55:08Z")
Anyone of you please help me in solving this problem. I'm trying to create a hive table on elasticsearch 6.2 where ssl is enabled.but not able to create the table, getting "Execution Error, return code 1 from org.apache.… --- ## [Curl works but Hive can't connect to ES](https://discuss.elastic.co/t/curl-works-but-hive-cant-connect-to-es/186760)
**Author:** [@A\_Felgueiras](https://discuss.elastic.co/u/A_Felgueiras)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 1:51am UTC](https://discuss.elastic.co/t/curl-works-but-hive-cant-connect-to-es/186760 "2019-06-24T01:51:22Z")
Hi, From an Hadoop cluster I can request my index using curl, like this : curl -u user:pwd -X GET http://mynode:9020/myindex, it works, but when I try to request using Hive (Beeline) I have the famous exception "Cannot… --- ## [Expose API to loopback address in a cluster](https://discuss.elastic.co/t/expose-api-to-loopback-address-in-a-cluster/186364)
**Author:** [@rossbrigoli](https://discuss.elastic.co/u/rossbrigoli)\ **Replies:** 1\ **Last updated:** [June 24, 2019, 12:53am UTC](https://discuss.elastic.co/t/expose-api-to-loopback-address-in-a-cluster/186364 "2019-06-24T00:53:03Z")
Hello, Has this been solved? I wanted to implement the same thing but it doesn't seem to work. I wanted to expose the API to localhost only, but i want to the use the real IP for clustering/discovery. The reason is t… --- ## [Can a DL be configured in email alert from watcher?](https://discuss.elastic.co/t/can-a-dl-be-configured-in-email-alert-from-watcher/186799)
**Author:** [@chintan.rami](https://discuss.elastic.co/u/chintan.rami)\ **Replies:** 2\ **Last updated:** [June 24, 2019, 12:38am UTC](https://discuss.elastic.co/t/can-a-dl-be-configured-in-email-alert-from-watcher/186799 "2019-06-24T00:38:47Z")
I am trying to add a DL into whitelist on my cloud instance and UI suggests that It has sent email for the approval. However, never received an email from elastic to confirm the email subscription. I tried to find if th… --- ## [Problem with mustache on watcher action](https://discuss.elastic.co/t/problem-with-mustache-on-watcher-action/184745)
**Author:** [@franco.federico](https://discuss.elastic.co/u/franco.federico)\ **Replies:** 26\ **Last updated:** [June 23, 2019, 9:01pm UTC](https://discuss.elastic.co/t/problem-with-mustache-on-watcher-action/184745 "2019-06-23T21:01:41Z")
Hi all I'm trying to do this action (a webhook) "hook-tornado2": { "webhook": { "scheme": "http", "host": "localhost", "port": 8080, "method": "post", "path": "/event/failed-passwords", "param… --- ## [Nest elasticsearch 7 Geolocation indexing](https://discuss.elastic.co/t/nest-elasticsearch-7-geolocation-indexing/184307)
**Author:** [@Ilyoskhuja](https://discuss.elastic.co/u/Ilyoskhuja)\ **Replies:** 15\ **Last updated:** [June 23, 2019, 6:34pm UTC](https://discuss.elastic.co/t/nest-elasticsearch-7-geolocation-indexing/184307 "2019-06-23T18:34:24Z")
Please help me with indexing geolocation in nest elastic search 7, this is my code Model public class ElasticSearchModel : Model\ { public ElasticSearchModel() { BuildingRooms … --- ## [New Homebrew Tap - how to migrate to full version](https://discuss.elastic.co/t/new-homebrew-tap-how-to-migrate-to-full-version/186779)
**Author:** [@yehosef](https://discuss.elastic.co/u/yehosef)\ **Replies:** 1\ **Last updated:** [June 23, 2019, 3:26pm UTC](https://discuss.elastic.co/t/new-homebrew-tap-how-to-migrate-to-full-version/186779 "2019-06-23T15:26:53Z")
First - thank you so much for making this. I understand and support the movements made by Elastic around the OSS/free features - but it was hard not having access to the full free stack on my Mac. I have elasticsearch … --- ## [Elasticsearch crash unassigned all shards](https://discuss.elastic.co/t/elasticsearch-crash-unassigned-all-shards/186972)
**Author:** [@mao](https://discuss.elastic.co/u/mao)\ **Replies:** 3\ **Last updated:** [June 23, 2019, 2:54pm UTC](https://discuss.elastic.co/t/elasticsearch-crash-unassigned-all-shards/186972 "2019-06-23T14:54:50Z")
Hello. I manage a cluster of 3 data nodes and 1 master. Today the master have crashed with several exceptions: a network issue ("fatal error on the network layer"). a StackOverflow: null I was bulk inserting a few h… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1252) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1254)