# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1846 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1847 --- ## [Elastic Runetime Error ScriptException](https://discuss.elastic.co/t/elastic-runetime-error-scriptexception/112880)
**Author:** [@Ricigliano](https://discuss.elastic.co/u/Ricigliano)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 7:24pm UTC](https://discuss.elastic.co/t/elastic-runetime-error-scriptexception/112880 "2017-12-21T19:24:49Z")
I am getting this error in the Elasticsearch logs, does anyone what this is from: \[2017-12-21T10:57:21,040\]\[ERROR\]\[o.e.x.w.t.s.ExecutableScriptTransform\] \[4mjFsbb\] failed to execute \[script\] transform for \[v4VKEfxATo-5d… --- ## [Filter by \_score in aggregation](https://discuss.elastic.co/t/filter-by-score-in-aggregation/112881)
**Author:** [@Luke\_Gilson](https://discuss.elastic.co/u/Luke_Gilson)\ **Replies:** 0\ **Last updated:** [December 21, 2017, 7:03pm UTC](https://discuss.elastic.co/t/filter-by-score-in-aggregation/112881 "2017-12-21T19:03:37Z")
ES Version: 2.3 elasticsearch-py: 2.3.0 Currently, I am using the min\_score attribute to remove the lower cruft of search results. e.g.: { "query": {"filtered": { "query": {"bool": { "must": {"… --- ## [Downloaded Basic License and received message below on install](https://discuss.elastic.co/t/downloaded-basic-license-and-received-message-below-on-install/112872)
**Author:** [@charwill621](https://discuss.elastic.co/u/charwill621)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 6:56pm UTC](https://discuss.elastic.co/t/downloaded-basic-license-and-received-message-below-on-install/112872 "2017-12-21T18:56:36Z")
roacamu01:/home/kibana: curl -XPUT -u elastic 'http://roacamu01:9200/\_xpack/license' -H "Content-Type: application/json" "acknowledge=true\> Enter host password for user 'elastic': {"acknowledged":false,"license\_status… --- ## [Indexing Rate Watch](https://discuss.elastic.co/t/indexing-rate-watch/110544)
**Author:** [@acchaulk](https://discuss.elastic.co/u/acchaulk)\ **Replies:** 7\ **Last updated:** [December 21, 2017, 6:03pm UTC](https://discuss.elastic.co/t/indexing-rate-watch/110544 "2017-12-21T18:03:45Z")
I would like to create a Watch for when the indexing rate for a specific index is 0 /s. How does the default monitoring dashboard Indexing Rate graph pull the data in? I am having trouble finding an API to call in the wa… --- ## [Queue not getting created in rabbit mq panel after creating river](https://discuss.elastic.co/t/queue-not-getting-created-in-rabbit-mq-panel-after-creating-river/112860)
**Author:** [@lalitupad](https://discuss.elastic.co/u/lalitupad)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 4:55pm UTC](https://discuss.elastic.co/t/queue-not-getting-created-in-rabbit-mq-panel-after-creating-river/112860 "2017-12-21T16:55:29Z")
I am creating a rabbitmq river and its went successful but in my rabbit mq panel there is no queue what i have mentioned in river data. Please find below my river details. Please let me know what i am wrong here or skipp… --- ## [Exclude a Index from Elasticsearch cluster](https://discuss.elastic.co/t/exclude-a-index-from-elasticsearch-cluster/112848)
**Author:** [@vishal\_kumar](https://discuss.elastic.co/u/vishal_kumar)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 4:09pm UTC](https://discuss.elastic.co/t/exclude-a-index-from-elasticsearch-cluster/112848 "2017-12-21T16:09:03Z")
If I have Elastic search cluster and the DB contains more than one index. I want to exclude 1 index in each node from cluster sync, means that table is local to each node. How can I do this? --- ## [High Java CPU usage with fresh elasticsearch install](https://discuss.elastic.co/t/high-java-cpu-usage-with-fresh-elasticsearch-install/112809)
**Author:** [@Andrew\_Jones](https://discuss.elastic.co/u/Andrew_Jones)\ **Replies:** 3\ **Last updated:** [December 21, 2017, 3:17pm UTC](https://discuss.elastic.co/t/high-java-cpu-usage-with-fresh-elasticsearch-install/112809 "2017-12-21T15:17:01Z")
Hi, I'm testing out / learning the ELK stack in our simple environment. I have followed the simple guide here https://www.digitalocean.com/community/tutorials/how-to-install-elasticsearch-logstash-and-kibana-elk-stack-on… --- ## [How to disable \_all field in production mode?](https://discuss.elastic.co/t/how-to-disable-all-field-in-production-mode/110945)
**Author:** [@majid\_zarrin](https://discuss.elastic.co/u/majid_zarrin)\ **Replies:** 4\ **Last updated:** [December 21, 2017, 2:51pm UTC](https://discuss.elastic.co/t/how-to-disable-all-field-in-production-mode/110945 "2017-12-21T14:51:06Z")
Hello I had Elasticsearh v5.6.2 and I do upgrade to v6.0.1. I expected Elasticsearch removes \_all field because I didn't explicitly declare it as true on the mapping but it didn't. Is there any way that I disable \_all… --- ## [Sampler aggregation performance vs 2 queries](https://discuss.elastic.co/t/sampler-aggregation-performance-vs-2-queries/112690)
**Author:** [@adam3](https://discuss.elastic.co/u/adam3)\ **Replies:** 4\ **Last updated:** [December 21, 2017, 2:50pm UTC](https://discuss.elastic.co/t/sampler-aggregation-performance-vs-2-queries/112690 "2017-12-21T14:50:05Z")
Ok so I am trying to increase performance of an Elasticsearch application. For this case there is a single Elasticsearch node (non-sharded) with about 7M docs (index is like 40G). We were doing a query to get top docs … --- ## [Elasticsearch 5.6 shows duplicate suggest result](https://discuss.elastic.co/t/elasticsearch-5-6-shows-duplicate-suggest-result/112802)
**Author:** [@Vinish\_Soman](https://discuss.elastic.co/u/Vinish_Soman)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 2:37pm UTC](https://discuss.elastic.co/t/elasticsearch-5-6-shows-duplicate-suggest-result/112802 "2017-12-21T14:37:55Z")
Hello Team, I am using elasticsearch 5.6 cluster and when I try to perform suggest query it is giving duplicate results. As data in the field contain duplicate data but I need a unique suggest result. Mapping -- \> { … --- ## [Uneven Shard Distribution](https://discuss.elastic.co/t/uneven-shard-distribution/112824)
**Author:** [@a99lex](https://discuss.elastic.co/u/a99lex)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 2:20pm UTC](https://discuss.elastic.co/t/uneven-shard-distribution/112824 "2017-12-21T14:20:57Z")
Hi,need some help with uneven shard distribution. I have 5 data nodes and one node have 1 TB more than the rest. It has fever shards but more data? shards disk.indices disk.used disk.avail disk.total disk.percent host … --- ## [Thanks to everyone, but another question](https://discuss.elastic.co/t/thanks-to-everyone-but-another-question/112818)
**Author:** [@negroan](https://discuss.elastic.co/u/negroan)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 2:18pm UTC](https://discuss.elastic.co/t/thanks-to-everyone-but-another-question/112818 "2017-12-21T14:18:11Z")
Hello, good day to everyone. reading documentation and doing tests I could get to do a mini aggregate but I would like to see if anyone can give me a hand with the following. This is my little script of which I have som… --- ## [Need to implement a if then do this kind of query on elastic search](https://discuss.elastic.co/t/need-to-implement-a-if-then-do-this-kind-of-query-on-elastic-search/112829)
**Author:** [@Shashank\_Paliwal](https://discuss.elastic.co/u/Shashank_Paliwal)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 2:13pm UTC](https://discuss.elastic.co/t/need-to-implement-a-if-then-do-this-kind-of-query-on-elastic-search/112829 "2017-12-21T14:13:27Z")
I have an elastic search structure like below { "\_source": { "@timestamp": "2017-12-08T16:31:27.106Z", "@version": "1", "doc": { "core": { "type": "admin", "component": { … --- ## [CPU High load](https://discuss.elastic.co/t/cpu-high-load/111916)
**Author:** [@sivakaran](https://discuss.elastic.co/u/sivakaran)\ **Replies:** 7\ **Last updated:** [December 21, 2017, 12:44pm UTC](https://discuss.elastic.co/t/cpu-high-load/111916 "2017-12-21T12:44:09Z")
Hi Team, I am using ES-1.3.7(version) In sometimes it causes very high load on particular node what can we do for this type of issue. I Checked with logs too there is no abnormal logs at all. Please help on this.Thank… --- ## [Datanodes cant see each other using EC2 Discovery Plugin](https://discuss.elastic.co/t/datanodes-cant-see-each-other-using-ec2-discovery-plugin/112086)
**Author:** [@cloud\_sora](https://discuss.elastic.co/u/cloud_sora)\ **Replies:** 15\ **Last updated:** [December 21, 2017, 12:40pm UTC](https://discuss.elastic.co/t/datanodes-cant-see-each-other-using-ec2-discovery-plugin/112086 "2017-12-21T12:40:11Z")
hello guys, im currently having an issue after configuring the elasticsearch to see the other ec2 datanodes note that im using elasticsearch-6.0.1-1 the below is my configuration ##################### cluster.name:… --- ## [Different responses between Kibana and REST](https://discuss.elastic.co/t/different-responses-between-kibana-and-rest/111558)
**Author:** [@heilaaks](https://discuss.elastic.co/u/heilaaks)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 12:26pm UTC](https://discuss.elastic.co/t/different-responses-between-kibana-and-rest/111558 "2017-12-21T12:26:01Z")
I am trying to use the below defined query to filter out data that I do not need and select only specific documents that contain specific fields. The problem is that when I run the below defined example from Kibana Dev T… --- ## [How to convert string field to number and then apply rang](https://discuss.elastic.co/t/how-to-convert-string-field-to-number-and-then-apply-rang/112785)
**Author:** [@joe\_print](https://discuss.elastic.co/u/joe_print)\ **Replies:** 7\ **Last updated:** [December 21, 2017, 11:31am UTC](https://discuss.elastic.co/t/how-to-convert-string-field-to-number-and-then-apply-rang/112785 "2017-12-21T11:31:18Z")
Hi, I have a field in Elastic that its type is number but its saved as string, now I want to know is it possible to treat it as number and apply range operation on that? --- ## [Getting NPE while delete a type in index](https://discuss.elastic.co/t/getting-npe-while-delete-a-type-in-index/112786)
**Author:** [@vidyapati](https://discuss.elastic.co/u/vidyapati)\ **Replies:** 3\ **Last updated:** [December 21, 2017, 10:24am UTC](https://discuss.elastic.co/t/getting-npe-while-delete-a-type-in-index/112786 "2017-12-21T10:24:01Z")
DeleteByQueryResponse response1 = new DeleteByQueryRequestBuilder(client, DeleteByQueryAction.INSTANCE) .setIndices(AppConstants.ASSET\_ATTRIBUTOR\_INDEX).setTypes(AppConstants.MNM\_TYPE) .setSource(deleteByQuery)… --- ## [customBoostFactorQuery v0.9 to v6.0](https://discuss.elastic.co/t/customboostfactorquery-v0-9-to-v6-0/112632)
**Author:** [@satyarajp](https://discuss.elastic.co/u/satyarajp)\ **Replies:** 2\ **Last updated:** [December 20, 2017, 1:23pm UTC](https://discuss.elastic.co/t/customboostfactorquery-v0-9-to-v6-0/112632 "2017-12-20T13:23:09Z")
Hi Team, Here are few more classes I need help with upgrading. queryBuilder.should(QueryBuilders.customBoostFactorQuery(qs).boostFactor(queryBoost)); OrFilterBuilder or = QueryBuilders.orFilter(); FacetHelper All the… --- ## [ELK 6.0 read Microsoft Access Database (.mdb) file](https://discuss.elastic.co/t/elk-6-0-read-microsoft-access-database-mdb-file/111701)
**Author:** [@pengran93](https://discuss.elastic.co/u/pengran93)\ **Replies:** 2\ **Last updated:** [December 21, 2017, 8:48am UTC](https://discuss.elastic.co/t/elk-6-0-read-microsoft-access-database-mdb-file/111701 "2017-12-21T08:48:37Z")
Hello I am quite new to ELK, just started to use it 3rd quater of this year. Soo my question is, can ELK read Microsoft Access Database (.mdb) file? If so, is there any tutorial on how to do it? I would like to know if… --- ## [How to find count of inner hits?](https://discuss.elastic.co/t/how-to-find-count-of-inner-hits/112761)
**Author:** [@oguz](https://discuss.elastic.co/u/oguz)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 8:06am UTC](https://discuss.elastic.co/t/how-to-find-count-of-inner-hits/112761 "2017-12-21T08:06:03Z")
Hi all, is it possible to get the count of all inner hits in a paginated query? If not, is there any alternative solution you can direct me to? I want to get the count of all items (segment.item) in the inner hits on th… --- ## [Authentication problem after setting up native realm](https://discuss.elastic.co/t/authentication-problem-after-setting-up-native-realm/112647)
**Author:** [@TimTim](https://discuss.elastic.co/u/TimTim)\ **Replies:** 2\ **Last updated:** [December 21, 2017, 8:04am UTC](https://discuss.elastic.co/t/authentication-problem-after-setting-up-native-realm/112647 "2017-12-21T08:04:39Z")
So I have the following setup where i run Elasticsearch, Logstash and Kibana all on their own server in a Docker container. It all works fine and I used the latest version 6.1.1 (X-Pack pre-installed). Then I fixed the … --- ## [Nested field score problem](https://discuss.elastic.co/t/nested-field-score-problem/112759)
**Author:** [@HilalB](https://discuss.elastic.co/u/HilalB)\ **Replies:** 0\ **Last updated:** [December 21, 2017, 7:20am UTC](https://discuss.elastic.co/t/nested-field-score-problem/112759 "2017-12-21T07:20:23Z")
I have an index: PUT my\_index2 { "mappings": { "my\_type": { "properties": { "user": { "type": "nested" } } } } } I added : POST my\_index2/my\_type/ { "user" : \[ { "name" : "Alice Don" },{ "name" : "Don… --- ## [Elasticsearch V5 is looking for cluster\_name folder for data path](https://discuss.elastic.co/t/elasticsearch-v5-is-looking-for-cluster-name-folder-for-data-path/111244)
**Author:** [@gayathri](https://discuss.elastic.co/u/gayathri)\ **Replies:** 2\ **Last updated:** [December 21, 2017, 7:01am UTC](https://discuss.elastic.co/t/elasticsearch-v5-is-looking-for-cluster-name-folder-for-data-path/111244 "2017-12-21T07:01:32Z")
Hi Team, As per: https://www.elastic.co/guide/en/elasticsearch/reference/5.2/\_path\_to\_data\_on\_disk.html#\_local\_files Our elasticsearch was working fine and it was storing index on path: $DATA\_DIR/nodes/$nodeOrdinal Bu… --- ## [Elasticsearch score of the array item](https://discuss.elastic.co/t/elasticsearch-score-of-the-array-item/112752)
**Author:** [@HilalB](https://discuss.elastic.co/u/HilalB)\ **Replies:** 0\ **Last updated:** [December 21, 2017, 6:01am UTC](https://discuss.elastic.co/t/elasticsearch-score-of-the-array-item/112752 "2017-12-21T06:01:43Z")
I have a field "clour" : \["pink","blue"\]. When I want to search it, I want to match the max relevant one because sometimes I have docs like "clour" : \["pink","pink"\] so it should score each element of the array and take… --- ## [Shards will be relocated away from this node in ES](https://discuss.elastic.co/t/shards-will-be-relocated-away-from-this-node-in-es/112745)
**Author:** [@narasiman1986](https://discuss.elastic.co/u/narasiman1986)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 5:40am UTC](https://discuss.elastic.co/t/shards-will-be-relocated-away-from-this-node-in-es/112745 "2017-12-21T05:40:17Z")
i am displaying the records from mysql to elastic search through logstash and GUI kibana In logstash config file code as follows input { jdbc { jdbc\_driver\_library =\> "D:\\mysql-connector-java-5.1.44\\mysql-connector-j… --- ## [How to backup particular index and restore if needed?](https://discuss.elastic.co/t/how-to-backup-particular-index-and-restore-if-needed/112746)
**Author:** [@Blason](https://discuss.elastic.co/u/Blason)\ **Replies:** 1\ **Last updated:** [December 21, 2017, 5:38am UTC](https://discuss.elastic.co/t/how-to-backup-particular-index-and-restore-if-needed/112746 "2017-12-21T05:38:06Z")
Hi Guys, How do I take a backup of particular index say logstash-bl-2017-12-11 and move off to other location? Plus how do I restore later on that index if I wanted to query it? Can someone please help? --- ## [ES 6.0 timeout on cluster](https://discuss.elastic.co/t/es-6-0-timeout-on-cluster/112434)
**Author:** [@Rakotobe](https://discuss.elastic.co/u/Rakotobe)\ **Replies:** 8\ **Last updated:** [December 21, 2017, 3:37am UTC](https://discuss.elastic.co/t/es-6-0-timeout-on-cluster/112434 "2017-12-21T03:37:20Z")
Hello, I've 3 differents server with 1 instance of ES 6.0 on each and another server with nodejs, to query on. On each server I just changed : discovery.zen.ping.unicast.hosts : \[ LIST\_ES\_IP \] discovery.zen.minimum\_m… --- ## [How do I parse json term query using TermQueryBuilder.fromXContent()?](https://discuss.elastic.co/t/how-do-i-parse-json-term-query-using-termquerybuilder-fromxcontent/112552)
**Author:** [@lks21c](https://discuss.elastic.co/u/lks21c)\ **Replies:** 5\ **Last updated:** [December 21, 2017, 3:09am UTC](https://discuss.elastic.co/t/how-do-i-parse-json-term-query-using-termquerybuilder-fromxcontent/112552 "2017-12-21T03:09:31Z")
Hi, I'm trying to parse "term query" as JSON string into TermQueryBuilder using TermQueryBuilder.fromXContent(); I looked up Java codes and tried to figure out the way I can parse Json string into TermQueryBuilder. My … --- ## [Failed to load xpackplugin, please help, urgent](https://discuss.elastic.co/t/failed-to-load-xpackplugin-please-help-urgent/112719)
**Author:** [@Derrick](https://discuss.elastic.co/u/Derrick)\ **Replies:** 10\ **Last updated:** [December 21, 2017, 1:57am UTC](https://discuss.elastic.co/t/failed-to-load-xpackplugin-please-help-urgent/112719 "2017-12-21T01:57:47Z")
\[2017-12-20T20:55:32,603\]\[WARN \]\[o.e.d.c.s.Settings \] \[keystore.password\] setting was deprecated in Elasticsearch and will be removed in a future release! See the breaking changes documentation for the next major v… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1845) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1847)