# Elasticsearch

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

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

**Page:** 1182

---

## [Is Elasticsearch-JDBC preinstalled in the ES Docker Image?](https://discuss.elastic.co/t/is-elasticsearch-jdbc-preinstalled-in-the-es-docker-image/196386)

<div class="topic-metadata">

**Author:** [@redapplesonly](https://discuss.elastic.co/u/redapplesonly)\
**Replies:** 2\
**Last updated:** [August 23, 2019, 7:43pm UTC](https://discuss.elastic.co/t/is-elasticsearch-jdbc-preinstalled-in-the-es-docker-image/196386 "2019-08-23T19:43:49Z")

</div>

Hi everyone, I am running ES as a docker container, install sometime last month. I believe that puts me on version 7.3.1. I want to export my ES data to a MySQL databases, and a few Google searches suggest that I'll n…

---

## [CPUs at 100%, but no disk I/O - ES 7.3](https://discuss.elastic.co/t/cpus-at-100-but-no-disk-i-o-es-7-3/196408)

<div class="topic-metadata">

**Author:** [@Aharon](https://discuss.elastic.co/u/Aharon)\
**Replies:** 6\
**Last updated:** [August 23, 2019, 5:40pm UTC](https://discuss.elastic.co/t/cpus-at-100-but-no-disk-i-o-es-7-3/196408 "2019-08-23T17:40:50Z")

</div>

ES Version 7.3 Various node sizes (hot/warm) (25+ nodes) SSDs on all nodes JDK 11 X-Pack Document level security (thank you for fixing the bitset issue in 7.3) Periodically our warm nodes that are sitting at 0% CPU uti…

---

## [Position getting incremented in Synonym filter when used after edge\_ngram filter](https://discuss.elastic.co/t/position-getting-incremented-in-synonym-filter-when-used-after-edge-ngram-filter/196320)

<div class="topic-metadata">

**Author:** [@pappu1](https://discuss.elastic.co/u/pappu1)\
**Replies:** 2\
**Last updated:** [August 23, 2019, 5:29pm UTC](https://discuss.elastic.co/t/position-getting-incremented-in-synonym-filter-when-used-after-edge-ngram-filter/196320 "2019-08-23T17:29:09Z")

</div>

Hi All, I'm facing an issue understanding that sometimes synonym filter increments position and sometimes it doesn't. This is causing matching issues with match\_phrase queries. I've posted the entire details on this st…

---

## [Python API reindex issues](https://discuss.elastic.co/t/python-api-reindex-issues/196357)

<div class="topic-metadata">

**Author:** [@smhall316](https://discuss.elastic.co/u/smhall316)\
**Replies:** 3\
**Last updated:** [August 23, 2019, 5:17pm UTC](https://discuss.elastic.co/t/python-api-reindex-issues/196357 "2019-08-23T17:17:18Z")

</div>

I am relatively new to Elasticsearch so I have been playing with a bit using the Python API. I am using Elasticsearch service through AWS so I have been following its suggestions for restoring snapshots. Since AWS does…

---

## [Verify connection between hdfs and elasticsearch](https://discuss.elastic.co/t/verify-connection-between-hdfs-and-elasticsearch/196351)

<div class="topic-metadata">

**Author:** [@varunakuraju](https://discuss.elastic.co/u/varunakuraju)\
**Replies:** 1\
**Last updated:** [August 23, 2019, 5:01pm UTC](https://discuss.elastic.co/t/verify-connection-between-hdfs-and-elasticsearch/196351 "2019-08-23T17:01:03Z")

</div>

Hi, How to verify the connectivity between the hdfs and elasticsearch. Thanks

---

## [Added elasticsearch and hadoop and while creating external table getting error](https://discuss.elastic.co/t/added-elasticsearch-and-hadoop-and-while-creating-external-table-getting-error/195938)

<div class="topic-metadata">

**Author:** [@varunakuraju](https://discuss.elastic.co/u/varunakuraju)\
**Replies:** 1\
**Last updated:** [August 23, 2019, 4:34pm UTC](https://discuss.elastic.co/t/added-elasticsearch-and-hadoop-and-while-creating-external-table-getting-error/195938 "2019-08-23T16:34:33Z")

</div>

created table vgsale in hive after added es-hadoop connector successful and trying to create external table Added \[file:///home/saivarunakuraju/elasticsearch-hadoop-hive-7.3.0.jar\] to class path Added resources: \[file…

---

## [Manipulate source data using script](https://discuss.elastic.co/t/manipulate-source-data-using-script/196434)

<div class="topic-metadata">

**Author:** [@rmunnur](https://discuss.elastic.co/u/rmunnur)\
**Replies:** 2\
**Last updated:** [August 23, 2019, 4:32pm UTC](https://discuss.elastic.co/t/manipulate-source-data-using-script/196434 "2019-08-23T16:32:42Z")

</div>

Hi All, I want to check if there is a way to manipulate the response returned by elasticsearch. For ex: Below is the response and I would like replace the docdate field value based on user time zone. I don't want it as…

---

## [Edge NGram Tokenizer not Tokenizing Digits?](https://discuss.elastic.co/t/edge-ngram-tokenizer-not-tokenizing-digits/196521)

<div class="topic-metadata">

**Author:** [@cawoodm](https://discuss.elastic.co/u/cawoodm)\
**Replies:** 2\
**Last updated:** [August 23, 2019, 4:04pm UTC](https://discuss.elastic.co/t/edge-ngram-tokenizer-not-tokenizing-digits/196521 "2019-08-23T16:04:57Z")

</div>

We're using the Edge NGram tokenizer (ElasticSearch 7.3 Windows) on letters and digits from 3 to 10 characters. However when we upload a text test 11kw and search for text: test AND text: 11k we find nothing. Interestin…

---

## [Cross-cluster search fails with skip\_unavailable option](https://discuss.elastic.co/t/cross-cluster-search-fails-with-skip-unavailable-option/195863)

<div class="topic-metadata">

**Author:** [@prizov](https://discuss.elastic.co/u/prizov)\
**Replies:** 1\
**Last updated:** [August 23, 2019, 2:35pm UTC](https://discuss.elastic.co/t/cross-cluster-search-fails-with-skip-unavailable-option/195863 "2019-08-23T14:35:49Z")

</div>

Hi everyone! I have two remote clusters with skip\_unavailable option. Cross-cluster search works fine. But in case one of cluster is network unreachable I receive search timeout and don't get any response even from one…

---

## [Rollover Doesn't work](https://discuss.elastic.co/t/rollover-doesnt-work/196542)

<div class="topic-metadata">

**Author:** [@RSR\_PHANI\_KUMAR](https://discuss.elastic.co/u/RSR_PHANI_KUMAR)\
**Replies:** 0\
**Last updated:** [August 23, 2019, 1:51pm UTC](https://discuss.elastic.co/t/rollover-doesnt-work/196542 "2019-08-23T13:51:09Z")

</div>

Hello Forum, I'm New to the Elastic Stack, and have set up various indexes for Metricbeat,Auditbeat, etc. I have set up Index Rollover Policy for the respective Indexes to get rolled-over for every 10 days and get dele…

---

## [How to access Elasticsearch and Kibana from another machine within same network](https://discuss.elastic.co/t/how-to-access-elasticsearch-and-kibana-from-another-machine-within-same-network/196516)

<div class="topic-metadata">

**Author:** [@narasimhaes](https://discuss.elastic.co/u/narasimhaes)\
**Replies:** 2\
**Last updated:** [August 23, 2019, 1:49pm UTC](https://discuss.elastic.co/t/how-to-access-elasticsearch-and-kibana-from-another-machine-within-same-network/196516 "2019-08-23T13:49:23Z")

</div>

I installed Kibana and Elasticsearch, now I am able to access both with localhost. How to make it accessible from another machine within same network. is there any webserver like nginx/tomcat need to install? Please h…

---

## [Can't join hot node to master node](https://discuss.elastic.co/t/cant-join-hot-node-to-master-node/196540)

<div class="topic-metadata">

**Author:** [@Usama\_waqar](https://discuss.elastic.co/u/Usama_waqar)\
**Replies:** 0\
**Last updated:** [August 23, 2019, 1:36pm UTC](https://discuss.elastic.co/t/cant-join-hot-node-to-master-node/196540 "2019-08-23T13:36:47Z")

</div>

I want to make cluster of 3 master nodes and 6 hot nodes. So i want to join hot node with master node but i am facing following error. join validation on cluster state with a different cluster uuid el3dZYW5QDO0xmPQi6\_P8…

---

## [Date Histogram based on aggregate total values](https://discuss.elastic.co/t/date-histogram-based-on-aggregate-total-values/196505)

<div class="topic-metadata">

**Author:** [@ivoecpereira](https://discuss.elastic.co/u/ivoecpereira)\
**Replies:** 0\
**Last updated:** [August 23, 2019, 11:03am UTC](https://discuss.elastic.co/t/date-histogram-based-on-aggregate-total-values/196505 "2019-08-23T11:03:36Z")

</div>

Hello, I have an index that contains documents such as the follow: { "event" : "pageView", "owner" : "5dbec3a4-55bf-4c83-912e-6ddb56623bc4", "session" : "c17b4d6c-dfea-4ecb-8c6f-7401f8f8595a", "createdAt" : "20…

---

## [Histogram and calendar\_interval](https://discuss.elastic.co/t/histogram-and-calendar-interval/196407)

<div class="topic-metadata">

**Author:** [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Replies:** 3\
**Last updated:** [August 23, 2019, 1:30pm UTC](https://discuss.elastic.co/t/histogram-and-calendar-interval/196407 "2019-08-23T13:30:24Z")

</div>

I have sql with histogram and interval now after upgrade to 7.x it complains that it will be deprecated. select histogram(status\_achieved, INTERVAL 1 day) as d but when I type select histogram(status\_achieved, FIXED\_…

---

## [Datatype string to state/country type](https://discuss.elastic.co/t/datatype-string-to-state-country-type/196345)

<div class="topic-metadata">

**Author:** [@pathri](https://discuss.elastic.co/u/pathri)\
**Replies:** 2\
**Last updated:** [August 23, 2019, 12:55pm UTC](https://discuss.elastic.co/t/datatype-string-to-state-country-type/196345 "2019-08-23T12:55:34Z")

</div>

Hi all, i have a fields in the document with the type as string but it's actually city, state and country and now i want to create visualization based on map for the same. what should i do in order to get the desired r…

---

## [Elasticsearch Cluster and best setup](https://discuss.elastic.co/t/elasticsearch-cluster-and-best-setup/196517)

<div class="topic-metadata">

**Author:** [@Marcell0e](https://discuss.elastic.co/u/Marcell0e)\
**Replies:** 0\
**Last updated:** [August 23, 2019, 12:23pm UTC](https://discuss.elastic.co/t/elasticsearch-cluster-and-best-setup/196517 "2019-08-23T12:23:58Z")

</div>

I have 2 Windows servers with the following on each server. I have a couple of questions. Can and should Logstash send data to both Elasticsearch nodes for load balance? Should I put Logstash on a server by itself or …

---

## [Why inverted index is not good at Aggregation?](https://discuss.elastic.co/t/why-inverted-index-is-not-good-at-aggregation/196298)

<div class="topic-metadata">

**Author:** [@hackerwin7](https://discuss.elastic.co/u/hackerwin7)\
**Replies:** 11\
**Last updated:** [August 23, 2019, 11:21am UTC](https://discuss.elastic.co/t/why-inverted-index-is-not-good-at-aggregation/196298 "2019-08-23T11:21:56Z")

</div>

https://www.elastic.co/guide/en/elasticsearch/reference/current/fielddata.html#fielddata this section of docs say sort and aggregation is another pattern to search: search with inverted index: Which documents contain …

---

## [What about a min\_docs parameter for rollover action in Index lifecycle management?](https://discuss.elastic.co/t/what-about-a-min-docs-parameter-for-rollover-action-in-index-lifecycle-management/195242)

<div class="topic-metadata">

**Author:** [@rflores](https://discuss.elastic.co/u/rflores)\
**Replies:** 5\
**Last updated:** [August 23, 2019, 11:15am UTC](https://discuss.elastic.co/t/what-about-a-min-docs-parameter-for-rollover-action-in-index-lifecycle-management/195242 "2019-08-23T11:15:08Z")

</div>

Hi all, I've played with the Index Lifecycle Management aka ILM for indices not being time series, but more in a classical datastore fashion (ie, need to reindex data from scratch on a regular basis, with few changes ea…

---

## [Elasticsearch query like not working when search number and string in 1 words using wildcardquery and match\_phrase](https://discuss.elastic.co/t/elasticsearch-query-like-not-working-when-search-number-and-string-in-1-words-using-wildcardquery-and-match-phrase/196499)

<div class="topic-metadata">

**Author:** [@Asep\_Kusnandar](https://discuss.elastic.co/u/Asep_Kusnandar)\
**Replies:** 0\
**Last updated:** [August 23, 2019, 10:43am UTC](https://discuss.elastic.co/t/elasticsearch-query-like-not-working-when-search-number-and-string-in-1-words-using-wildcardquery-and-match-phrase/196499 "2019-08-23T10:43:36Z")

</div>

How can i search query like with match\_phrase query when i search key example : "50Fit bintaro" my mapping { "settings": { "analysis": { "analyzer": { "my\_analyzer": { "tokenizer": "standard", "filter": \[ "lowercase", …

---

## [ElasticSearch for the Log Search in Zipped Archives Usecase](https://discuss.elastic.co/t/elasticsearch-for-the-log-search-in-zipped-archives-usecase/191395)

<div class="topic-metadata">

**Author:** [@Manug](https://discuss.elastic.co/u/Manug)\
**Replies:** 3\
**Last updated:** [August 23, 2019, 10:53am UTC](https://discuss.elastic.co/t/elasticsearch-for-the-log-search-in-zipped-archives-usecase/191395 "2019-08-23T10:53:11Z")

</div>

Hi, I have the following usecase and I want to find out if I can use elasticsearch for it. If yes, then how can I implement it. Usecase: I want to search log archives for any kind of string. I have log archives from …

---

## [Master not discovered or elected yet in docker envirement](https://discuss.elastic.co/t/master-not-discovered-or-elected-yet-in-docker-envirement/196476)

<div class="topic-metadata">

**Author:** [@AhmedAkkarii](https://discuss.elastic.co/u/AhmedAkkarii)\
**Replies:** 2\
**Last updated:** [August 23, 2019, 10:40am UTC](https://discuss.elastic.co/t/master-not-discovered-or-elected-yet-in-docker-envirement/196476 "2019-08-23T10:40:14Z")

</div>

Hello, I'm in a strange problem as my Elasticsearch has produced this error: {"type": "server", "timestamp": "2019-08-23T09:16:03,122+0000", "level": "WARN", "component": "o.e.c.c.ClusterFormationFailureHelper", "clust…

---

## [Login and pwd kibana interface](https://discuss.elastic.co/t/login-and-pwd-kibana-interface/196336)

<div class="topic-metadata">

**Author:** [@zmira\_meriem](https://discuss.elastic.co/u/zmira_meriem)\
**Replies:** 6\
**Last updated:** [August 23, 2019, 9:54am UTC](https://discuss.elastic.co/t/login-and-pwd-kibana-interface/196336 "2019-08-23T09:54:02Z")

</div>

plz how can i configure login and password for kibana interface????

---

## [Ingesting pdf in angular 7](https://discuss.elastic.co/t/ingesting-pdf-in-angular-7/196065)

<div class="topic-metadata">

**Author:** [@nijanthan0](https://discuss.elastic.co/u/nijanthan0)\
**Replies:** 3\
**Last updated:** [August 23, 2019, 9:53am UTC](https://discuss.elastic.co/t/ingesting-pdf-in-angular-7/196065 "2019-08-23T09:53:08Z")

</div>

Can I ingest directly a document inside the angular (without parsing it) ?

---

## [Compile error when using sparse vector and cosine similarity](https://discuss.elastic.co/t/compile-error-when-using-sparse-vector-and-cosine-similarity/196474)

<div class="topic-metadata">

**Author:** [@Pablo\_gps](https://discuss.elastic.co/u/Pablo_gps)\
**Replies:** 2\
**Last updated:** [August 23, 2019, 9:30am UTC](https://discuss.elastic.co/t/compile-error-when-using-sparse-vector-and-cosine-similarity/196474 "2019-08-23T09:30:47Z")

</div>

I am trying to use the new functionality for vector fields, but I am running into problems. Let me break down the problem for you: My documents are json files, with this structure: {"name": "doc\_name", "field\_1": "doc\_…

---

## [ILM error on index name](https://discuss.elastic.co/t/ilm-error-on-index-name/196276)

<div class="topic-metadata">

**Author:** [@jof300](https://discuss.elastic.co/u/jof300)\
**Replies:** 1\
**Last updated:** [August 23, 2019, 9:30am UTC](https://discuss.elastic.co/t/ilm-error-on-index-name/196276 "2019-08-23T09:30:12Z")

</div>

Hi, I am trying to implement ILM for my indexes. Some context : Architecture of the solution is: logstash (shipper) or beats ==\> kafka ==\> logstash (indexer) ==\> elasticsearch \<== kibana Index seggregation is done b…

---

## [Parse json with mapper\_parsing\_exception](https://discuss.elastic.co/t/parse-json-with-mapper-parsing-exception/196344)

<div class="topic-metadata">

**Author:** [@thwint](https://discuss.elastic.co/u/thwint)\
**Replies:** 2\
**Last updated:** [August 23, 2019, 9:26am UTC](https://discuss.elastic.co/t/parse-json-with-mapper-parsing-exception/196344 "2019-08-23T09:26:19Z")

</div>

Hello, We are indexing and parsing logfiles containing JSON requests (one per line). We have multiple, completely different request. Most of them can be indexed without any problems. But we have some requests which incl…

---

## [Periodic ES ReadTimeout Error](https://discuss.elastic.co/t/periodic-es-readtimeout-error/195341)

<div class="topic-metadata">

**Author:** [@Ritesh\_Agrawal](https://discuss.elastic.co/u/Ritesh_Agrawal)\
**Replies:** 1\
**Last updated:** [August 23, 2019, 9:19am UTC](https://discuss.elastic.co/t/periodic-es-readtimeout-error/195341 "2019-08-23T09:19:47Z")

</div>

I have a 2 node es cluster (4 core 16GB) config. I am getting read timeout error on 10th minute of every hour. All the scheduled processes from the application is stopped. So nothing scheduled from application side. So I…

---

## [Question about adding geo\_point and updating mappings in general](https://discuss.elastic.co/t/question-about-adding-geo-point-and-updating-mappings-in-general/196265)

<div class="topic-metadata">

**Author:** [@Sempiterna](https://discuss.elastic.co/u/Sempiterna)\
**Replies:** 4\
**Last updated:** [August 22, 2019, 3:35pm UTC](https://discuss.elastic.co/t/question-about-adding-geo-point-and-updating-mappings-in-general/196265 "2019-08-22T15:35:37Z")

</div>

I've been trying for a few days now to add custom mapping (geo\_point) to my elasticsearch server. This server has daily created indices "filebeat-2019.08.22". However, all documentation tells me I need to update the tem…

---

## [java.lang.IllegalStateException: Failed to close the XContentBuilder (Elasticsearch 6.8.1)](https://discuss.elastic.co/t/java-lang-illegalstateexception-failed-to-close-the-xcontentbuilder-elasticsearch-6-8-1/195431)

<div class="topic-metadata">

**Author:** [@aditshrimal7](https://discuss.elastic.co/u/aditshrimal7)\
**Replies:** 1\
**Last updated:** [August 23, 2019, 9:09am UTC](https://discuss.elastic.co/t/java-lang-illegalstateexception-failed-to-close-the-xcontentbuilder-elasticsearch-6-8-1/195431 "2019-08-23T09:09:10Z")

</div>

Hi, I am consuming data from Apache Kafka and transforming it with Apache Flink, and then inserting it in Elasticsearch. But I get the following errors and my flink job fails. Please can someone tell me why am I facing t…

---

## [Elasticsearch Deleting a field in an index](https://discuss.elastic.co/t/elasticsearch-deleting-a-field-in-an-index/196329)

<div class="topic-metadata">

**Author:** [@astrobalaji](https://discuss.elastic.co/u/astrobalaji)\
**Replies:** 4\
**Last updated:** [August 23, 2019, 8:53am UTC](https://discuss.elastic.co/t/elasticsearch-deleting-a-field-in-an-index/196329 "2019-08-23T08:53:21Z")

</div>

Hi, I have an index that is being populated in realtime. However, I have one field in the index which I don't need anymore. Is there anyway to delete just one field from an index for all documents? Thanks in advance. …

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

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