# Elasticsearch

**URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1165

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 1166

---

## [Elasticsearch bulk load data with multiple spaces](https://discuss.elastic.co/t/elasticsearch-bulk-load-data-with-multiple-spaces/198052)

<div class="topic-metadata">

**Author:** [@jkimrey](https://discuss.elastic.co/u/jkimrey)\
**Replies:** 1\
**Last updated:** [September 7, 2019, 10:57am UTC](https://discuss.elastic.co/t/elasticsearch-bulk-load-data-with-multiple-spaces/198052 "2019-09-07T10:57:30Z")

</div>

I'm trying to bulk load data into elasticsearch v6.5.4 local (docker) with the following command: curl -XPOST -H "Content-Type: application/json" "http://localhost:9200/\_bulk?refresh=true" --data-binary @$filename An e…

---

## [How to search users by first, last name](https://discuss.elastic.co/t/how-to-search-users-by-first-last-name/198489)

<div class="topic-metadata">

**Author:** [@undefinedman](https://discuss.elastic.co/u/undefinedman)\
**Replies:** 1\
**Last updated:** [September 7, 2019, 2:57am UTC](https://discuss.elastic.co/t/how-to-search-users-by-first-last-name/198489 "2019-09-07T02:57:53Z")

</div>

Hey Elasticsearch, a year ago I wrote a topic here https://discuss.elastic.co/t/what-is-the-best-way-to-query-first-and-last-name/136142 to help me out with searching users in my database. At that time, I partially reso…

---

## [java.lang.IllegalException: failed to obtain node locks](https://discuss.elastic.co/t/java-lang-illegalexception-failed-to-obtain-node-locks/198463)

<div class="topic-metadata">

**Author:** [@Matthew\_Graville](https://discuss.elastic.co/u/Matthew_Graville)\
**Replies:** 7\
**Last updated:** [September 6, 2019, 8:48pm UTC](https://discuss.elastic.co/t/java-lang-illegalexception-failed-to-obtain-node-locks/198463 "2019-09-06T20:48:57Z")

</div>

I am setting up ELK stack for the first time on 3 different servers respectively. Elasticsearch + Kibana are good (I think), and now onto logstash I am Parsing Logs following the guide: https://www.elastic.co/guide/en/l…

---

## [Can anyone guide me to videos/blogs/tutorials to start using the GeoIP capabilities?](https://discuss.elastic.co/t/can-anyone-guide-me-to-videos-blogs-tutorials-to-start-using-the-geoip-capabilities/198471)

<div class="topic-metadata">

**Author:** [@Rosho](https://discuss.elastic.co/u/Rosho)\
**Replies:** 1\
**Last updated:** [September 6, 2019, 8:12pm UTC](https://discuss.elastic.co/t/can-anyone-guide-me-to-videos-blogs-tutorials-to-start-using-the-geoip-capabilities/198471 "2019-09-06T20:12:44Z")

</div>

Hi I have to implement a use case using GeoIP for a telecom company. An idea is to track employees. Like in the banking system. Can anyone guide me to relevant videos/blogs/tutorials? Thank you

---

## [Reindex whitelist on the fly?](https://discuss.elastic.co/t/reindex-whitelist-on-the-fly/198470)

<div class="topic-metadata">

**Author:** [@linkerc](https://discuss.elastic.co/u/linkerc)\
**Replies:** 0\
**Last updated:** [September 6, 2019, 6:44pm UTC](https://discuss.elastic.co/t/reindex-whitelist-on-the-fly/198470 "2019-09-06T18:44:13Z")

</div>

I know there was a closed thread discussing this already, but I still want to make a feature request for this. The problem with having it in yml file is it'll stay with the new cluster forever unless I restart the new …

---

## [Elasticsearch support for spark 2.4.2 with scala 2.12](https://discuss.elastic.co/t/elasticsearch-support-for-spark-2-4-2-with-scala-2-12/197810)

<div class="topic-metadata">

**Author:** [@Gokul\_Raj](https://discuss.elastic.co/u/Gokul_Raj)\
**Replies:** 1\
**Last updated:** [September 6, 2019, 4:25pm UTC](https://discuss.elastic.co/t/elasticsearch-support-for-spark-2-4-2-with-scala-2-12/197810 "2019-09-06T16:25:18Z")

</div>

I'm not able to find any ES 6.7.1 supporting jar for spark 2.4.2 with scala 2.12 In maven repo only scala 2.11 and 2.10 is supported for the jar \<dependency\> \<groupId\>org.elasticsearch\</groupId\> \<artifactId\>ela…

---

## [Es-hadoop with TLS](https://discuss.elastic.co/t/es-hadoop-with-tls/197417)

<div class="topic-metadata">

**Author:** [@mstarensier](https://discuss.elastic.co/u/mstarensier)\
**Replies:** 1\
**Last updated:** [September 6, 2019, 4:22pm UTC](https://discuss.elastic.co/t/es-hadoop-with-tls/197417 "2019-09-06T16:22:52Z")

</div>

Has anybody been able to use es-hadoop connector with an Es cluster where TLS is enabled? If so, what configuration params did you use, and what kind of certificate? I'm trying to connect to a 7.e ES cluster with xpack…

---

## [Trying to insert data into the external table](https://discuss.elastic.co/t/trying-to-insert-data-into-the-external-table/197368)

<div class="topic-metadata">

**Author:** [@varunakuraju](https://discuss.elastic.co/u/varunakuraju)\
**Replies:** 1\
**Last updated:** [September 6, 2019, 4:18pm UTC](https://discuss.elastic.co/t/trying-to-insert-data-into-the-external-table/197368 "2019-09-06T16:18:37Z")

</div>

Hi, Using hadoop and elasticsearch on cloud created external table but getting some errors while inserting the data into the external table set hive.execution.engine=mr hive\> insert overwrite table vgsale5es select \*…

---

## [Unable to use es-hadoop with TLS enabled on my ES cluster](https://discuss.elastic.co/t/unable-to-use-es-hadoop-with-tls-enabled-on-my-es-cluster/197225)

<div class="topic-metadata">

**Author:** [@mstarensier](https://discuss.elastic.co/u/mstarensier)\
**Replies:** 1\
**Last updated:** [September 6, 2019, 4:16pm UTC](https://discuss.elastic.co/t/unable-to-use-es-hadoop-with-tls-enabled-on-my-es-cluster/197225 "2019-09-06T16:16:38Z")

</div>

I'm having trouble configuring TLS for es-hadoop. Running 7.2 Elasticsearch in a 3 node cluster (1 data, 1 master, 1 coordinating which hosts kibana). Running Spark on an EMR cluster in the same vpn. Before enabling xp…

---

## [Could not communicate if i add one more Public IP ssl comunication error](https://discuss.elastic.co/t/could-not-communicate-if-i-add-one-more-public-ip-ssl-comunication-error/197727)

<div class="topic-metadata">

**Author:** [@cbeprem](https://discuss.elastic.co/u/cbeprem)\
**Replies:** 2\
**Last updated:** [September 6, 2019, 3:54pm UTC](https://discuss.elastic.co/t/could-not-communicate-if-i-add-one-more-public-ip-ssl-comunication-error/197727 "2019-09-06T15:54:21Z")

</div>

Hi ALL, The cluster has one master and three nodes configured via SSL and is working fine , with the below is the config . cluster.name: techElasticlusterdata node.name: elastciclustermaster-01 cluster.name: tech…

---

## [Can I set built-in users passwords in elasticsearch-keystore?](https://discuss.elastic.co/t/can-i-set-built-in-users-passwords-in-elasticsearch-keystore/197540)

<div class="topic-metadata">

**Author:** [@JanKowalik](https://discuss.elastic.co/u/JanKowalik)\
**Replies:** 2\
**Last updated:** [September 6, 2019, 2:54pm UTC](https://discuss.elastic.co/t/can-i-set-built-in-users-passwords-in-elasticsearch-keystore/197540 "2019-09-06T14:54:26Z")

</div>

Hi, Is it possible to set built-in user passwords in elasticsearch-keystore before ES starts up? I know one can set the bootstrap.password in the keystore but what about passwords for elastic, kibana and other built-in…

---

## [Is the anyway to store SSL keys in HashiCorp Vault and refer them in elastic configuration files?](https://discuss.elastic.co/t/is-the-anyway-to-store-ssl-keys-in-hashicorp-vault-and-refer-them-in-elastic-configuration-files/197926)

<div class="topic-metadata">

**Author:** [@mhsh64](https://discuss.elastic.co/u/mhsh64)\
**Replies:** 1\
**Last updated:** [September 6, 2019, 2:39pm UTC](https://discuss.elastic.co/t/is-the-anyway-to-store-ssl-keys-in-hashicorp-vault-and-refer-them-in-elastic-configuration-files/197926 "2019-09-06T14:39:01Z")

</div>

Hello, Is there anyway to store SSL keys in HashiCorp Vault and refer them in elastic configuration files (yml)?

---

## [How can I remove/delete a custom analyzer from an index?](https://discuss.elastic.co/t/how-can-i-remove-delete-a-custom-analyzer-from-an-index/198417)

<div class="topic-metadata">

**Author:** [@mwills](https://discuss.elastic.co/u/mwills)\
**Replies:** 2\
**Last updated:** [September 6, 2019, 2:03pm UTC](https://discuss.elastic.co/t/how-can-i-remove-delete-a-custom-analyzer-from-an-index/198417 "2019-09-06T14:03:27Z")

</div>

I created a analyzer that works on my index. I wondering if I can delete the custom analyzer that I created? Thanks, Mike

---

## [FS Crawler exception "Error while crawling - Connection Closed"](https://discuss.elastic.co/t/fs-crawler-exception-error-while-crawling-connection-closed/198259)

<div class="topic-metadata">

**Author:** [@Danilo\_Felix](https://discuss.elastic.co/u/Danilo_Felix)\
**Replies:** 4\
**Last updated:** [September 6, 2019, 1:51pm UTC](https://discuss.elastic.co/t/fs-crawler-exception-error-while-crawling-connection-closed/198259 "2019-09-06T13:51:24Z")

</div>

Hello, I'm trying to use FS Crawler 2.6 in a Windows Server machine to index a huge number of files in my company. It's a very large Windows folders tree in a network drive: 14,92 Tb size, 7,2M files in 2,3M folders. Da…

---

## [I have issues with my cluster and I want to re-build it. Need advices!](https://discuss.elastic.co/t/i-have-issues-with-my-cluster-and-i-want-to-re-build-it-need-advices/198190)

<div class="topic-metadata">

**Author:** [@andrewKode](https://discuss.elastic.co/u/andrewKode)\
**Replies:** 4\
**Last updated:** [September 6, 2019, 1:25pm UTC](https://discuss.elastic.co/t/i-have-issues-with-my-cluster-and-i-want-to-re-build-it-need-advices/198190 "2019-09-06T13:25:40Z")

</div>

Hello everyone, I'm currently using a cluster for keeping metadata about some files which are stored in some locations. There are 3 nodes and Kibana is installed on another machine. Someone else did this configuration …

---

## [Yellow Status- Unassigned Shards](https://discuss.elastic.co/t/yellow-status-unassigned-shards/198272)

<div class="topic-metadata">

**Author:** [@antonopo](https://discuss.elastic.co/u/antonopo)\
**Replies:** 10\
**Last updated:** [September 6, 2019, 1:21pm UTC](https://discuss.elastic.co/t/yellow-status-unassigned-shards/198272 "2019-09-06T13:21:17Z")

</div>

Hi, I have many indices with yellow status and Unassigned Shards. How i can fixed that? Is this related that my nodes are on different countries and there is delay on network or it's something else?

---

## [How can we convert join query into elastic search](https://discuss.elastic.co/t/how-can-we-convert-join-query-into-elastic-search/197783)

<div class="topic-metadata">

**Author:** [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)\
**Replies:** 10\
**Last updated:** [September 6, 2019, 1:11pm UTC](https://discuss.elastic.co/t/how-can-we-convert-join-query-into-elastic-search/197783 "2019-09-06T13:11:53Z")

</div>

Dear All. i having problem with below query :-1: Please help me to convert into Elastic-search query:- { "query":"SELECT \* FROM dbdataindex\_join\_allcolumns\_qa INNER JOIN dbdataindex\_join\_allcolumns\_qa\_added\_benefic…

---

## [Categorize products using significant\_text of previously categorized ones](https://discuss.elastic.co/t/categorize-products-using-significant-text-of-previously-categorized-ones/198414)

<div class="topic-metadata">

**Author:** [@ffknob](https://discuss.elastic.co/u/ffknob)\
**Replies:** 3\
**Last updated:** [September 6, 2019, 12:48pm UTC](https://discuss.elastic.co/t/categorize-products-using-significant-text-of-previously-categorized-ones/198414 "2019-09-06T12:48:06Z")

</div>

Hello I need a little help on how to approach a problem I'm facing right now. Imagine I have "categorized-products" index where I store a bunch of products, each one containing a description and a manually selected ca…

---

## [Basic security without xpack](https://discuss.elastic.co/t/basic-security-without-xpack/198349)

<div class="topic-metadata">

**Author:** [@O\_K](https://discuss.elastic.co/u/O_K)\
**Replies:** 5\
**Last updated:** [September 6, 2019, 12:40pm UTC](https://discuss.elastic.co/t/basic-security-without-xpack/198349 "2019-09-06T12:40:55Z")

</div>

Is there an option to have login/password connectivity(tls is optional) to elasticsearch and authentication enabled on kibana without xpack installation?

---

## [Adding a field by merging existing field while reindexing](https://discuss.elastic.co/t/adding-a-field-by-merging-existing-field-while-reindexing/197994)

<div class="topic-metadata">

**Author:** [@rahul\_raj](https://discuss.elastic.co/u/rahul_raj)\
**Replies:** 2\
**Last updated:** [September 6, 2019, 12:19pm UTC](https://discuss.elastic.co/t/adding-a-field-by-merging-existing-field-while-reindexing/197994 "2019-09-06T12:19:19Z")

</div>

I have an index to which i need to add a field which will merge three existing fields from the same index. Example field1, field2, field3 so unique\_field=field1,field2,field3. I am trying below script along with reindex…

---

## [Pros and cons of higher cluster\_concurrent\_rebalance](https://discuss.elastic.co/t/pros-and-cons-of-higher-cluster-concurrent-rebalance/198418)

<div class="topic-metadata">

**Author:** [@ld\_pvl](https://discuss.elastic.co/u/ld_pvl)\
**Replies:** 0\
**Last updated:** [September 6, 2019, 12:11pm UTC](https://discuss.elastic.co/t/pros-and-cons-of-higher-cluster-concurrent-rebalance/198418 "2019-09-06T12:11:17Z")

</div>

Hi Team, I'm trying to understand better how shard relocations due to imbalances work. I assume, if one has good network bandwidth and good disk IO read and write speeds, then one might benefit from setting a higher se…

---

## [Export kibana visualizations to csv or json file using python script](https://discuss.elastic.co/t/export-kibana-visualizations-to-csv-or-json-file-using-python-script/198411)

<div class="topic-metadata">

**Author:** [@Vikash\_Singh1](https://discuss.elastic.co/u/Vikash_Singh1)\
**Replies:** 0\
**Last updated:** [September 6, 2019, 11:35am UTC](https://discuss.elastic.co/t/export-kibana-visualizations-to-csv-or-json-file-using-python-script/198411 "2019-09-06T11:35:47Z")

</div>

Hi Is there a way through which I can export my kibana visualization into a json/csv or ant file using python script and if there is any changes in the visualization then it should append in that file. Thanks in Advanc…

---

## [IS there a way to search on parent fields from a nested query?](https://discuss.elastic.co/t/is-there-a-way-to-search-on-parent-fields-from-a-nested-query/198385)

<div class="topic-metadata">

**Author:** [@manish\_kakoti](https://discuss.elastic.co/u/manish_kakoti)\
**Replies:** 2\
**Last updated:** [September 6, 2019, 10:53am UTC](https://discuss.elastic.co/t/is-there-a-way-to-search-on-parent-fields-from-a-nested-query/198385 "2019-09-06T10:53:48Z")

</div>

I wrote a query which works well on nested fields, but also wanted to add a functionality where it can search on the parent fields as well. Here is the mapping: mapping: { doc: { properties: { "name" : …

---

## [How to achieve bulk indexing "asynchronously" through REST API (not through RestHighClient)](https://discuss.elastic.co/t/how-to-achieve-bulk-indexing-asynchronously-through-rest-api-not-through-resthighclient/198381)

<div class="topic-metadata">

**Author:** [@Antriksh\_Jain](https://discuss.elastic.co/u/Antriksh_Jain)\
**Replies:** 0\
**Last updated:** [September 6, 2019, 9:11am UTC](https://discuss.elastic.co/t/how-to-achieve-bulk-indexing-asynchronously-through-rest-api-not-through-resthighclient/198381 "2019-09-06T09:11:02Z")

</div>

One can achieve bulk indexing "Asynchronously" through REST Java High Client. As mentioned here: https://www.elastic.co/guide/en/elasticsearch/client/java-rest/master/java-rest-high-document-bulk.html But do anyone kno…

---

## [\[Resolved\]Join data cross two index based on common field](https://discuss.elastic.co/t/resolved-join-data-cross-two-index-based-on-common-field/195458)

<div class="topic-metadata">

**Author:** [@cheriemilk](https://discuss.elastic.co/u/cheriemilk)\
**Replies:** 7\
**Last updated:** [August 22, 2019, 6:59am UTC](https://discuss.elastic.co/t/resolved-join-data-cross-two-index-based-on-common-field/195458 "2019-08-22T06:59:32Z")

</div>

Hi Team, In my local elk stack, below two index are created. kvaudit\* This one is index customer behavior data. Example data: \` module=SCM fa=TS at=SCM.TS.MODIFY\_SEARCH si=4C3D8709E51DDC4EE879A9E30729B512.mo-569…

---

## [Elasticsearch won't index logs while cluster is red](https://discuss.elastic.co/t/elasticsearch-wont-index-logs-while-cluster-is-red/198265)

<div class="topic-metadata">

**Author:** [@hunsw](https://discuss.elastic.co/u/hunsw)\
**Replies:** 7\
**Last updated:** [September 6, 2019, 8:24am UTC](https://discuss.elastic.co/t/elasticsearch-wont-index-logs-while-cluster-is-red/198265 "2019-09-06T08:24:04Z")

</div>

Elasticsearch version: 6.6 Logstash version: 6.6 SSL is on After restarting the cluster or even a single node that has some indices with primary 1 replica 0 shard setting, Logstash starts to accumulate events and it l…

---

## [Elastic search authentiation Invalid NEST response built from a unsuccessful low level call](https://discuss.elastic.co/t/elastic-search-authentiation-invalid-nest-response-built-from-a-unsuccessful-low-level-call/198312)

<div class="topic-metadata">

**Author:** [@Bidzina\_Goginashvili](https://discuss.elastic.co/u/Bidzina_Goginashvili)\
**Replies:** 6\
**Last updated:** [September 6, 2019, 8:06am UTC](https://discuss.elastic.co/t/elastic-search-authentiation-invalid-nest-response-built-from-a-unsuccessful-low-level-call/198312 "2019-09-06T08:06:18Z")

</div>

public ElasticClient EsClient() { var nodes = new Uri { new Uri($"{\_config.ElasticUrl}"), }; var connectionPool = new StaticConnectionPool(nodes); var connectionSettings = new ConnectionSettings(co…

---

## [Match query which matches exactly to a field with shuffling](https://discuss.elastic.co/t/match-query-which-matches-exactly-to-a-field-with-shuffling/198357)

<div class="topic-metadata">

**Author:** [@sangam0707](https://discuss.elastic.co/u/sangam0707)\
**Replies:** 0\
**Last updated:** [September 6, 2019, 6:54am UTC](https://discuss.elastic.co/t/match-query-which-matches-exactly-to-a-field-with-shuffling/198357 "2019-09-06T06:54:43Z")

</div>

Hi, I have a field in Elasticsearch which has array of string. This field has standard analyzer. e.g Document 1 { field:\["a b c d", "a b c x", "b a c y"\]} Document 2 { field:\["a b c"\]} Now I am searching "b c a" …

---

## [Can i install in elasticsearch and kibana both on same machine](https://discuss.elastic.co/t/can-i-install-in-elasticsearch-and-kibana-both-on-same-machine/198351)

<div class="topic-metadata">

**Author:** [@Ayush\_Verma](https://discuss.elastic.co/u/Ayush_Verma)\
**Replies:** 4\
**Last updated:** [September 6, 2019, 6:32am UTC](https://discuss.elastic.co/t/can-i-install-in-elasticsearch-and-kibana-both-on-same-machine/198351 "2019-09-06T06:32:12Z")

</div>

I have 4 nodes cluster in elasticsearch ie. 2 master only nodes and 2 data only nodes and all nodes are installed in google cloud instance machine type is g1-small (1 vCPU, 1.7 GB memory) for all four nodes, now i have s…

---

## [Monitor Elasticsearch with another tool](https://discuss.elastic.co/t/monitor-elasticsearch-with-another-tool/198198)

<div class="topic-metadata">

**Author:** [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\
**Replies:** 3\
**Last updated:** [September 6, 2019, 6:03am UTC](https://discuss.elastic.co/t/monitor-elasticsearch-with-another-tool/198198 "2019-09-06T06:03:07Z")

</div>

Hello, I want to monitor elasticsearch but not in kibana. how to monitor ? i want to know from where to collect data of elasticsearch? any leads would be appreciated Regards

[Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1164)

[Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1166)
