# Elasticsearch

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

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

**Page:** 1504

---

## [Error jar hell in installing my own elastic plugin](https://discuss.elastic.co/t/error-jar-hell-in-installing-my-own-elastic-plugin/152664)

<div class="topic-metadata">

**Author:** [@Vahid\_Mouasvi](https://discuss.elastic.co/u/Vahid_Mouasvi)\
**Replies:** 5\
**Last updated:** [October 28, 2018, 10:46am UTC](https://discuss.elastic.co/t/error-jar-hell-in-installing-my-own-elastic-plugin/152664 "2018-10-28T10:46:47Z")

</div>

Hi! I have a problem while installing my authentication plugin on elasticsearch. I get below error: thanks for helping me! @elastic

---

## [Elasticsearch and sql tables](https://discuss.elastic.co/t/elasticsearch-and-sql-tables/154261)

<div class="topic-metadata">

**Author:** [@Garry](https://discuss.elastic.co/u/Garry)\
**Replies:** 6\
**Last updated:** [October 28, 2018, 9:59am UTC](https://discuss.elastic.co/t/elasticsearch-and-sql-tables/154261 "2018-10-28T09:59:20Z")

</div>

I have data stored in a sql table that i would like to load into elasticsearch. What would be the best way to do this. The table is updated frequently and i need elasticsearch to reflect this. Garry

---

## [Can’t access es instances from outside network](https://discuss.elastic.co/t/can-t-access-es-instances-from-outside-network/154326)

<div class="topic-metadata">

**Author:** [@Guy\_Barnea](https://discuss.elastic.co/u/Guy_Barnea)\
**Replies:** 1\
**Last updated:** [October 28, 2018, 9:20am UTC](https://discuss.elastic.co/t/can-t-access-es-instances-from-outside-network/154326 "2018-10-28T09:20:20Z")

</div>

Hello, I have 3 es instances on my company server,on ports 9200,9201,9203 from my company network i can access all of them, but from outside network (via wifi for example) I can access to instance on port 9200 only, b…

---

## [XPack license invalid](https://discuss.elastic.co/t/xpack-license-invalid/154276)

<div class="topic-metadata">

**Author:** [@horaceli](https://discuss.elastic.co/u/horaceli)\
**Replies:** 1\
**Last updated:** [October 28, 2018, 7:59am UTC](https://discuss.elastic.co/t/xpack-license-invalid/154276 "2018-10-28T07:59:47Z")

</div>

my xpack trail license is invalid,but it's still in the valid time { "license": { "status": "invalid", "uid": "02f12e61-d377-4bb8-a127-18fe160ade64", "type": "trial", "issue\_date": "2018-10-27T06:20:24.844Z", "iss…

---

## [Logging all queries to the cluster](https://discuss.elastic.co/t/logging-all-queries-to-the-cluster/153826)

<div class="topic-metadata">

**Author:** [@AvivCohn](https://discuss.elastic.co/u/AvivCohn)\
**Replies:** 4\
**Last updated:** [October 28, 2018, 7:57am UTC](https://discuss.elastic.co/t/logging-all-queries-to-the-cluster/153826 "2018-10-28T07:57:34Z")

</div>

Hello everyone, In our organization we have a major use case of identifying who is querying the cluster, and how. This is because we often have problems with clusters that often turn out to result from a user sending a…

---

## [Import large number of json documents failing via bulk import with no error message](https://discuss.elastic.co/t/import-large-number-of-json-documents-failing-via-bulk-import-with-no-error-message/154300)

<div class="topic-metadata">

**Author:** [@BinaryIsPrimary](https://discuss.elastic.co/u/BinaryIsPrimary)\
**Replies:** 3\
**Last updated:** [October 28, 2018, 7:17am UTC](https://discuss.elastic.co/t/import-large-number-of-json-documents-failing-via-bulk-import-with-no-error-message/154300 "2018-10-28T07:17:21Z")

</div>

I am trying to import documents stored in a json file (1.4GB) via the bulk api with the following command: curl -s -H "Content-Type: application/x-ndjson" -XPOST localhost:9200/{index}/\_bulk --data-binary "@\<filename\>.…

---

## [Queries regarding precision\_threshold setting in cardinality aggregation](https://discuss.elastic.co/t/queries-regarding-precision-threshold-setting-in-cardinality-aggregation/153258)

<div class="topic-metadata">

**Author:** [@Shailesh\_Vaidya](https://discuss.elastic.co/u/Shailesh_Vaidya)\
**Replies:** 2\
**Last updated:** [October 27, 2018, 10:31pm UTC](https://discuss.elastic.co/t/queries-regarding-precision-threshold-setting-in-cardinality-aggregation/153258 "2018-10-27T22:31:39Z")

</div>

Hello, We are using cardinality aggregation in our project. We have around 1400000 documents each document consist filed named url. I want to count unique url wise document count. Hence I am using term aggregation along…

---

## [How to map MySQL query to elasticsearch in node.js?](https://discuss.elastic.co/t/how-to-map-mysql-query-to-elasticsearch-in-node-js/154299)

<div class="topic-metadata">

**Author:** [@Tushar\_Mudgal](https://discuss.elastic.co/u/Tushar_Mudgal)\
**Replies:** 3\
**Last updated:** [October 27, 2018, 9:13pm UTC](https://discuss.elastic.co/t/how-to-map-mysql-query-to-elasticsearch-in-node-js/154299 "2018-10-27T21:13:56Z")

</div>

I am facing an issue with querying. Precisely, I want to extract the results that match my query (astro-ph). How can I query this? It exists in \<primary\_category\> col name in SQL. Column may contain (astro-ph, astro-ph.G…

---

## [How to access Elasticsearch Cluster in VPN with Spring Boot](https://discuss.elastic.co/t/how-to-access-elasticsearch-cluster-in-vpn-with-spring-boot/154279)

<div class="topic-metadata">

**Author:** [@BinaryIsPrimary](https://discuss.elastic.co/u/BinaryIsPrimary)\
**Replies:** 4\
**Last updated:** [October 27, 2018, 6:52pm UTC](https://discuss.elastic.co/t/how-to-access-elasticsearch-cluster-in-vpn-with-spring-boot/154279 "2018-10-27T18:52:55Z")

</div>

I have an Elasticsearch cluster in a VPN. How can my Spring Boot application access the cluster securely if it is located on a separate server outside of the VPN and how can I configure it in the Spring boot configurati…

---

## [How to sum the results of multiple buckets](https://discuss.elastic.co/t/how-to-sum-the-results-of-multiple-buckets/153438)

<div class="topic-metadata">

**Author:** [@KatrinaQ999](https://discuss.elastic.co/u/KatrinaQ999)\
**Replies:** 1\
**Last updated:** [October 27, 2018, 6:03pm UTC](https://discuss.elastic.co/t/how-to-sum-the-results-of-multiple-buckets/153438 "2018-10-27T18:03:50Z")

</div>

I have data like: Name Update\_Date Amount AAA 2001-08-28T16:21:46 60 BBB 2001-08-27T06:11:52 50 CCC …

---

## [Hot to update single doc without id?](https://discuss.elastic.co/t/hot-to-update-single-doc-without-id/154087)

<div class="topic-metadata">

**Author:** [@john4](https://discuss.elastic.co/u/john4)\
**Replies:** 4\
**Last updated:** [October 27, 2018, 3:29pm UTC](https://discuss.elastic.co/t/hot-to-update-single-doc-without-id/154087 "2018-10-27T15:29:34Z")

</div>

Ok, this might sound strange but i can´t do that simple task: I just want to update one document which has an unique identifier. I don´t know the ID and don´t want to get the id first. Using '\_update\_by\_query' i get dow…

---

## [\[FORBIDDEN\\/12\\/index read-only \\/ allow delete (api)](https://discuss.elastic.co/t/forbidden-12-index-read-only-allow-delete-api/154269)

<div class="topic-metadata">

**Author:** [@vll\_genius](https://discuss.elastic.co/u/vll_genius)\
**Replies:** 1\
**Last updated:** [October 27, 2018, 9:49am UTC](https://discuss.elastic.co/t/forbidden-12-index-read-only-allow-delete-api/154269 "2018-10-27T09:49:12Z")

</div>

Dear, i have installed elasticsearch on the server and also installed addon for elasticsearch in cs-cart website. i have facing while indexing data , some indexing are correct but some give an error result:- "index": { …

---

## [ElasticSearch unexpected crash](https://discuss.elastic.co/t/elasticsearch-unexpected-crash/154270)

<div class="topic-metadata">

**Author:** [@jsyu32](https://discuss.elastic.co/u/jsyu32)\
**Replies:** 0\
**Last updated:** [October 27, 2018, 7:42am UTC](https://discuss.elastic.co/t/elasticsearch-unexpected-crash/154270 "2018-10-27T07:42:35Z")

</div>

The following is the log. Here are my questions. What's the cause of the crash. After crash, I restart the server, it can't use the historical data, instead, it only use the new disk. Can it recover from history data? I…

---

## [Class not found exception for org.apache.lucene.util.Version](https://discuss.elastic.co/t/class-not-found-exception-for-org-apache-lucene-util-version/153729)

<div class="topic-metadata">

**Author:** [@Sanjaybg](https://discuss.elastic.co/u/Sanjaybg)\
**Replies:** 11\
**Last updated:** [October 27, 2018, 5:37am UTC](https://discuss.elastic.co/t/class-not-found-exception-for-org-apache-lucene-util-version/153729 "2018-10-27T05:37:21Z")

</div>

I am using Elasticsearch6.4 Java High Level REST Client. I am using lucene-core-7.4.0.jar and lucene-queryparser-7.4.0.jar, but im getting the following exception. 24-Oct-2018 11:43:31.164 SEVERE \[http-nio-8080-exec-9…

---

## [Snapshot restore hanging on 6.4](https://discuss.elastic.co/t/snapshot-restore-hanging-on-6-4/154104)

<div class="topic-metadata">

**Author:** [@mgvarley](https://discuss.elastic.co/u/mgvarley)\
**Replies:** 6\
**Last updated:** [October 27, 2018, 4:35am UTC](https://discuss.elastic.co/t/snapshot-restore-hanging-on-6-4/154104 "2018-10-27T04:35:49Z")

</div>

I have a clean install of 6.4.2 (OSS), I have create a new index (single shard), load data into it (~800mb), then force a merge to optimize and finally snapshot to S3. When I try to restore the index into a different cl…

---

## [Source Nakisa Database refreshed](https://discuss.elastic.co/t/source-nakisa-database-refreshed/154251)

<div class="topic-metadata">

**Author:** [@Doug.Meyer](https://discuss.elastic.co/u/Doug.Meyer)\
**Replies:** 1\
**Last updated:** [October 27, 2018, 12:43am UTC](https://discuss.elastic.co/t/source-nakisa-database-refreshed/154251 "2018-10-27T00:43:00Z")

</div>

We are implementing the Nakisa Licensing application which uses ElasticSearch. The developers encountered an issue that led to the restore of the database from a time before the problem. As this is new to us I do not b…

---

## [Refresh interval setting on old indices](https://discuss.elastic.co/t/refresh-interval-setting-on-old-indices/154075)

<div class="topic-metadata">

**Author:** [@ben5556](https://discuss.elastic.co/u/ben5556)\
**Replies:** 6\
**Last updated:** [October 27, 2018, 12:38am UTC](https://discuss.elastic.co/t/refresh-interval-setting-on-old-indices/154075 "2018-10-27T00:38:17Z")

</div>

Hi, If refresh interval on an old unchanging index/ indices is set to 5s, does refresh still happen for the index/ indices every 5 seconds ? Will changing the refresh interval setting to 30s on old indices improve perfo…

---

## [How to GET xml field data from Elasticsearch using Elasticsearch\_DSL?](https://discuss.elastic.co/t/how-to-get-xml-field-data-from-elasticsearch-using-elasticsearch-dsl/154254)

<div class="topic-metadata">

**Author:** [@Samvid\_Kulkarni](https://discuss.elastic.co/u/Samvid_Kulkarni)\
**Replies:** 1\
**Last updated:** [October 27, 2018, 12:03am UTC](https://discuss.elastic.co/t/how-to-get-xml-field-data-from-elasticsearch-using-elasticsearch-dsl/154254 "2018-10-27T00:03:28Z")

</div>

I have log file which has XML data and I am using XML filter to insert it into Elasticsearch. Now i want to retrieve data from Elasticsearch using Elasticsearch\_DSL python library. I am not able to retrieve it. The JSON …

---

## [How to get counts of root level (parent) documents for indices?](https://discuss.elastic.co/t/how-to-get-counts-of-root-level-parent-documents-for-indices/154258)

<div class="topic-metadata">

**Author:** [@Teddis](https://discuss.elastic.co/u/Teddis)\
**Replies:** 0\
**Last updated:** [October 26, 2018, 9:53pm UTC](https://discuss.elastic.co/t/how-to-get-counts-of-root-level-parent-documents-for-indices/154258 "2018-10-26T21:53:14Z")

</div>

I'm presently using this to get a high-level snapshot of index counts: GET /\_cat/indices?v&s=docs.count:desc But it's displaying all documents included nested documents. I can't find any documentation on whether possib…

---

## [Lucene Field Attributes](https://discuss.elastic.co/t/lucene-field-attributes/153378)

<div class="topic-metadata">

**Author:** [@ananth](https://discuss.elastic.co/u/ananth)\
**Replies:** 1\
**Last updated:** [October 26, 2018, 8:44pm UTC](https://discuss.elastic.co/t/lucene-field-attributes/153378 "2018-10-26T20:44:52Z")

</div>

Hi, I would like to use the attributes map in lucene FieldInfo to handle some custom properties. Is there any way to do it in Elasticsearch ? Is there any plans to support bitmap as a datatype in ES/lucene so that one …

---

## [CSV parsed data showing different date than received](https://discuss.elastic.co/t/csv-parsed-data-showing-different-date-than-received/154241)

<div class="topic-metadata">

**Author:** [@motts](https://discuss.elastic.co/u/motts)\
**Replies:** 4\
**Last updated:** [October 26, 2018, 8:44pm UTC](https://discuss.elastic.co/t/csv-parsed-data-showing-different-date-than-received/154241 "2018-10-26T20:44:46Z")

</div>

Hello, I am looking at some data in Kibana. I am importing a CSV, but parsed data is showing a different date than the date in the message. Input data Data in the Date field Here is my logstash filter conf: csv …

---

## [How to: function\_score + script\_score + nested doc field?](https://discuss.elastic.co/t/how-to-function-score-script-score-nested-doc-field/153070)

<div class="topic-metadata">

**Author:** [@jaddison](https://discuss.elastic.co/u/jaddison)\
**Replies:** 1\
**Last updated:** [October 26, 2018, 8:22pm UTC](https://discuss.elastic.co/t/how-to-function-score-script-score-nested-doc-field/153070 "2018-10-26T20:22:48Z")

</div>

Hey! It's nearing the end of 2018, and I'm wondering if there's a way to accomplish the following with ES 6.4. I've got a function\_score query with n script\_score functions targeting top-level document fields and 1 scri…

---

## [Elasticsearch Reindex to New map \[6.2\]](https://discuss.elastic.co/t/elasticsearch-reindex-to-new-map-6-2/153912)

<div class="topic-metadata">

**Author:** [@trust](https://discuss.elastic.co/u/trust)\
**Replies:** 1\
**Last updated:** [October 26, 2018, 6:58pm UTC](https://discuss.elastic.co/t/elasticsearch-reindex-to-new-map-6-2/153912 "2018-10-26T18:58:32Z")

</div>

Hello, I'm looking for a solution to reindex to new mapping. My old map look like this { "user": { "id": 1, "email": "example@mail.com", "role": "ROLE", } } how can I achieve and change it too { "userId": 1 …

---

## [\_score doesn't update in a function score query with script](https://discuss.elastic.co/t/score-doesnt-update-in-a-function-score-query-with-script/153998)

<div class="topic-metadata">

**Author:** [@Maarten\_Koopmans](https://discuss.elastic.co/u/Maarten_Koopmans)\
**Replies:** 10\
**Last updated:** [October 26, 2018, 6:41pm UTC](https://discuss.elastic.co/t/score-doesnt-update-in-a-function-score-query-with-script/153998 "2018-10-26T18:41:16Z")

</div>

I'm trying to get some basic working by setting the \_score of a document, using function scores and/or painless scripts. I plan to use the basic block to find the mechanism to build out my final use case. Sadly it alread…

---

## [Trying to understand query\_string\_query behavior change](https://discuss.elastic.co/t/trying-to-understand-query-string-query-behavior-change/154242)

<div class="topic-metadata">

**Author:** [@ditch182](https://discuss.elastic.co/u/ditch182)\
**Replies:** 0\
**Last updated:** [October 26, 2018, 5:14pm UTC](https://discuss.elastic.co/t/trying-to-understand-query-string-query-behavior-change/154242 "2018-10-26T17:14:37Z")

</div>

Hello all, I'm in the process of upgrading from 5.5 to 6.3, using the AWS ElasticSearchService. I've run into a behavior change between the two, and while I understand the underlying reason, I'm unsure as to why the be…

---

## [Sum of shards on one node](https://discuss.elastic.co/t/sum-of-shards-on-one-node/154199)

<div class="topic-metadata">

**Author:** [@ArunANayagam](https://discuss.elastic.co/u/ArunANayagam)\
**Replies:** 1\
**Last updated:** [October 26, 2018, 4:26pm UTC](https://discuss.elastic.co/t/sum-of-shards-on-one-node/154199 "2018-10-26T16:26:47Z")

</div>

Hi, I have a 6.3.0 - 3 node cluster collecting logs with default number of shards and replicas. Each node is associated with a 300GB external disk. Is it by design that one node will have the sum of shards? I would ha…

---

## [Timestamp discrepancy / Date Processor](https://discuss.elastic.co/t/timestamp-discrepancy-date-processor/154077)

<div class="topic-metadata">

**Author:** [@lukes](https://discuss.elastic.co/u/lukes)\
**Replies:** 3\
**Last updated:** [October 26, 2018, 4:24pm UTC](https://discuss.elastic.co/t/timestamp-discrepancy-date-processor/154077 "2018-10-26T16:24:53Z")

</div>

Hi, I am using date processor to parse and convert the date from a custom field which is string. Date processor parses the date correctly, but storing in @timestamp incorrectly. It parses AM/PM format correctly. But whe…

---

## [Elasticsearch watcher to send Prediction data](https://discuss.elastic.co/t/elasticsearch-watcher-to-send-prediction-data/154004)

<div class="topic-metadata">

**Author:** [@Kathir\_J](https://discuss.elastic.co/u/Kathir_J)\
**Replies:** 3\
**Last updated:** [October 26, 2018, 4:08pm UTC](https://discuss.elastic.co/t/elasticsearch-watcher-to-send-prediction-data/154004 "2018-10-26T16:08:24Z")

</div>

Elasticsearch watcher to send prediction data. In this above screenshot, I have the prediction value as 32192. So, is it possible to alert the user (by using watcher) with the prediction value? My watcher configura…

---

## ["No query registered for \[filter\]"](https://discuss.elastic.co/t/no-query-registered-for-filter/49602)

<div class="topic-metadata">

**Author:** [@Mike\_Wurtz](https://discuss.elastic.co/u/Mike_Wurtz)\
**Replies:** 3\
**Last updated:** [October 26, 2018, 3:50pm UTC](https://discuss.elastic.co/t/no-query-registered-for-filter/49602 "2018-10-26T15:50:43Z")

</div>

I can't figure out why I'm getting this response.. I'm pretty much taking this example from the documentation.. Why am I getting, "No query registered for \[filter\]" ? Here's my request: { "trigger" : { "schedule" :…

---

## [Murmur3 values differ between ES 1.7 and 6.4](https://discuss.elastic.co/t/murmur3-values-differ-between-es-1-7-and-6-4/154223)

<div class="topic-metadata">

**Author:** [@dan-blanchard](https://discuss.elastic.co/u/dan-blanchard)\
**Replies:** 8\
**Last updated:** [October 26, 2018, 3:40pm UTC](https://discuss.elastic.co/t/murmur3-values-differ-between-es-1-7-and-6-4/154223 "2018-10-26T15:40:01Z")

</div>

We're in the process of finally migrating from ES 1.7, and I noticed a strange inconsistency between the hashed values of Murmur3 fields between the two versions. Specifically, the hashes do not match in the last byte. T…

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

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