# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1296 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1297 --- ## [Too\_many\_clauses: maxClauseCount is set to 1024 & index.query.bool.max\_clause\_count](https://discuss.elastic.co/t/too-many-clauses-maxclausecount-is-set-to-1024-index-query-bool-max-clause-count/181443)
**Author:** [@alexus](https://discuss.elastic.co/u/alexus)\ **Replies:** 3\ **Last updated:** [May 17, 2019, 9:30pm UTC](https://discuss.elastic.co/t/too-many-clauses-maxclausecount-is-set-to-1024-index-query-bool-max-clause-count/181443 "2019-05-17T21:30:15Z")
Hello World! I'm running into following error: { "type": "too\_many\_clauses", "reason": "too\_many\_clauses: maxClauseCount is set to 1024" }, I found index.query.bool.max\_clause\_count needs to be tweaked. … --- ## [Float numbers with comma as a decimal](https://discuss.elastic.co/t/float-numbers-with-comma-as-a-decimal/181619)
**Author:** [@humartinez](https://discuss.elastic.co/u/humartinez)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 8:58pm UTC](https://discuss.elastic.co/t/float-numbers-with-comma-as-a-decimal/181619 "2019-05-17T20:58:34Z")
Hi there, I've got an issue with elastic while ingesting some date. {"error":{"root\_cause":\[{"type":"mapper\_parsing\_exception","reason":"failed to parse field \[costo\_hora\_empleado\] of type \[integer\]"}\],"type":"mapper\_p… --- ## [Create table from jenkins logs](https://discuss.elastic.co/t/create-table-from-jenkins-logs/181587)
**Author:** [@MohanrajBabu](https://discuss.elastic.co/u/MohanrajBabu)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 8:49pm UTC](https://discuss.elastic.co/t/create-table-from-jenkins-logs/181587 "2019-05-17T20:49:04Z")
Hello Elasticsearch users, Just starting with elastic search! I am running a jenkins job in a server that access a network device and print various show commands as logs. I had gone through the manual and installed fi… --- ## [Restore a snapshot Error not\_x\_content\_exception](https://discuss.elastic.co/t/restore-a-snapshot-error-not-x-content-exception/180989)
**Author:** [@fim](https://discuss.elastic.co/u/fim)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 8:08pm UTC](https://discuss.elastic.co/t/restore-a-snapshot-error-not-x-content-exception/180989 "2019-05-17T20:08:26Z")
I've created the repo "restore". When I call: POST /\_snapshot/restore/connect/\_restore I'll get the following error: { "error": { "root\_cause": \[ { "type": "not\_x\_content\_exception", "re… --- ## [ES two node cluster doubt](https://discuss.elastic.co/t/es-two-node-cluster-doubt/181399)
**Author:** [@Suryadip\_Nag](https://discuss.elastic.co/u/Suryadip_Nag)\ **Replies:** 5\ **Last updated:** [May 17, 2019, 6:52pm UTC](https://discuss.elastic.co/t/es-two-node-cluster-doubt/181399 "2019-05-17T18:52:23Z")
If there is two node with two different ip in ES cluster setup then the indexing request will go to only master node and the data will be indexed to master node and not in the other node? If yes then how the other node … --- ## [Master not discovered yet, this node has not previously joined a bootstrapped (v7+) cluster](https://discuss.elastic.co/t/master-not-discovered-yet-this-node-has-not-previously-joined-a-bootstrapped-v7-cluster/176304)
**Author:** [@kyle\_che](https://discuss.elastic.co/u/kyle_che)\ **Replies:** 62\ **Last updated:** [May 17, 2019, 5:04pm UTC](https://discuss.elastic.co/t/master-not-discovered-yet-this-node-has-not-previously-joined-a-bootstrapped-v7-cluster/176304 "2019-05-17T17:04:57Z")
I'm trying to upgrade from 6.7.1 to 7.0.0 but getting the below error. I changed discovery.zen.ping.unicast.hosts to discovery.seed\_hosts and added also cluster.initial\_master\_nodes pointing to the same master nodes. W… --- ## [Elasticsearch Cluster help](https://discuss.elastic.co/t/elasticsearch-cluster-help/181033)
**Author:** [@HelpComputer](https://discuss.elastic.co/u/HelpComputer)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 4:54pm UTC](https://discuss.elastic.co/t/elasticsearch-cluster-help/181033 "2019-05-17T16:54:54Z")
Hello, I am having some difficulty building my cluster environment and was hoping someone could point me in the right direction. Right now the cluster status is red and Kibana is showing no results. The environment was … --- ## [ElasticSearch dedupe quarry/ Aggregation question (I am a noob)](https://discuss.elastic.co/t/elasticsearch-dedupe-quarry-aggregation-question-i-am-a-noob/181628)
**Author:** [@iukea](https://discuss.elastic.co/u/iukea)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 4:50pm UTC](https://discuss.elastic.co/t/elasticsearch-dedupe-quarry-aggregation-question-i-am-a-noob/181628 "2019-05-17T16:50:21Z")
sup my dudes, I am working on a search and I need some ElasticSearch Wisdom. Goal I am trying to get all the Src\_ip's along with, IP\_rep, and geoip.asn all in on search with no duplicates from an NGINX server that I … --- ## [Sum aggregation question](https://discuss.elastic.co/t/sum-aggregation-question/180885)
**Author:** [@tmerritt](https://discuss.elastic.co/u/tmerritt)\ **Replies:** 2\ **Last updated:** [May 17, 2019, 4:30pm UTC](https://discuss.elastic.co/t/sum-aggregation-question/180885 "2019-05-17T16:30:13Z")
I'm trying to use the elastic search integration in pcp to load metrics to ES and visualize them via grafana. It's mostly working except for some of the stats that pcp aggregates as associative arrays. Load averages are… --- ## [Store only index without a way to retrieve the actual indexed data](https://discuss.elastic.co/t/store-only-index-without-a-way-to-retrieve-the-actual-indexed-data/180998)
**Author:** [@Yaniv\_Hakim](https://discuss.elastic.co/u/Yaniv_Hakim)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 3:46pm UTC](https://discuss.elastic.co/t/store-only-index-without-a-way-to-retrieve-the-actual-indexed-data/180998 "2019-05-17T15:46:46Z")
Hi everyone, We're thinking to add elastic to our product stack and we want to use it as a full text search solution and aggregations. The problem is our data is very sensitive and our main data store is AWS MySQL RDS … --- ## [Elasticsearch Aggregation question](https://discuss.elastic.co/t/elasticsearch-aggregation-question/181289)
**Author:** [@xodn0812](https://discuss.elastic.co/u/xodn0812)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 3:41pm UTC](https://discuss.elastic.co/t/elasticsearch-aggregation-question/181289 "2019-05-17T15:41:38Z")
Can i implement the following mysql query with elasticsearch? select sum(column1)/sum(column2) v1, min(column3) v2, sum(column4) v3 from mytable group by column5, column6 Thank you for writing an example! --- ## [HTTP/1.1 500 Server Error{"message":null}](https://discuss.elastic.co/t/http-1-1-500-server-error-message-null/181598)
**Author:** [@lonzodc](https://discuss.elastic.co/u/lonzodc)\ **Replies:** 6\ **Last updated:** [May 17, 2019, 3:08pm UTC](https://discuss.elastic.co/t/http-1-1-500-server-error-message-null/181598 "2019-05-17T15:08:19Z")
Hi, I am encountering error from \_bulk endpoint but I can't solve since the error message sent by ES is null. I am calling the \_bulk endpoint via ES REST API. Here is a snippet of the stacktrace I am getting: HTTP/1.1 … --- ## [Multiple index is possible](https://discuss.elastic.co/t/multiple-index-is-possible/181097)
**Author:** [@elk3](https://discuss.elastic.co/u/elk3)\ **Replies:** 6\ **Last updated:** [May 17, 2019, 2:17pm UTC](https://discuss.elastic.co/t/multiple-index-is-possible/181097 "2019-05-17T14:17:05Z")
i have table like emp,dep so there is any possible to create two doc type in single index i.e Put index/emp/1 put index/dep/1 like this --- ## [Json Deserialize Exception coming while searching Elastic Search Indexes](https://discuss.elastic.co/t/json-deserialize-exception-coming-while-searching-elastic-search-indexes/180655)
**Author:** [@himanshum](https://discuss.elastic.co/u/himanshum)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 1:55pm UTC](https://discuss.elastic.co/t/json-deserialize-exception-coming-while-searching-elastic-search-indexes/180655 "2019-05-17T13:55:09Z")
Hi, I am using Elasticsearch.Net and Nest Nuget Packages. version 6.7.0 for both. I have configured the server at localhost:9200/#/ I have also created indexes. Now, while searching I am getting an exception. Elas… --- ## [ML is available but not enabled](https://discuss.elastic.co/t/ml-is-available-but-not-enabled/181357)
**Author:** [@robertvolkmann](https://discuss.elastic.co/u/robertvolkmann)\ **Replies:** 4\ **Last updated:** [May 17, 2019, 1:38pm UTC](https://discuss.elastic.co/t/ml-is-available-but-not-enabled/181357 "2019-05-17T13:38:39Z")
Hi everyone, we started with our trial licence to evaluate the machine learning features. But after following the elasticsearch documentation machine-learning remains disabled. Start point: Elasicsearch 6.6.2 xpack.m… --- ## [Curator don't delete indices](https://discuss.elastic.co/t/curator-dont-delete-indices/181335)
**Author:** [@colix](https://discuss.elastic.co/u/colix)\ **Replies:** 2\ **Last updated:** [May 17, 2019, 12:00pm UTC](https://discuss.elastic.co/t/curator-dont-delete-indices/181335 "2019-05-17T12:00:21Z")
Hi, I want to delete old indices in elastic. But it not working. Index dem.nisr-2019.05.13 is actionable and remains in the list. Remains in actionable list: Index "dem.nisr-2019.05.13" age (1557705600), direction: "old… --- ## [Connection to 127.0.0.1 Failed](https://discuss.elastic.co/t/connection-to-127-0-0-1-failed/181213)
**Author:** [@markov](https://discuss.elastic.co/u/markov)\ **Replies:** 1\ **Last updated:** [May 15, 2019, 2:30pm UTC](https://discuss.elastic.co/t/connection-to-127-0-0-1-failed/181213 "2019-05-15T14:30:34Z")
hello guys, i'm getting this error when i try the curl -X GET "localhost:9200/" on Centos. i'm using a proxy. # curl -X GET "localhost:9200" \ **Author:** [@suvarna](https://discuss.elastic.co/u/suvarna)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 10:10am UTC](https://discuss.elastic.co/t/how-to-find-the-field-store-is-yes-or-no/181502 "2019-05-17T10:10:07Z") Hi, We are using rally-eventdata-track as rally load generator for Elasticsearch6.6.2. Can you please let me know if the Field.Store is yes or no ..and how to check this configuration through curl command. --- ## [Snapshot and Restore in readable format](https://discuss.elastic.co/t/snapshot-and-restore-in-readable-format/180578)
**Author:** [@Jasonespo](https://discuss.elastic.co/u/Jasonespo)\ **Replies:** 12\ **Last updated:** [May 17, 2019, 9:32am UTC](https://discuss.elastic.co/t/snapshot-and-restore-in-readable-format/180578 "2019-05-17T09:32:33Z")
Hi all, I have configured an S3 bucket to push my snapshots to like the following: https://www.elastic.co/guide/en/cloud/current/ec-aws-custom-repository.html Is it possible out of the box to push the indexes in a rea… --- ## [Most performant way to filter for exceptions in log events?](https://discuss.elastic.co/t/most-performant-way-to-filter-for-exceptions-in-log-events/181551)
**Author:** [@asp](https://discuss.elastic.co/u/asp)\ **Replies:** 0\ **Last updated:** [May 17, 2019, 9:28am UTC](https://discuss.elastic.co/t/most-performant-way-to-filter-for-exceptions-in-log-events/181551 "2019-05-17T09:28:22Z")
Hi all, currently I have an event which my contain exceptions like nullpointerException or javax.ejb.EJBException or my.very.OwnException in one of it's field. The event itself can get quite big because of very long sta… --- ## [Limit on has child query?](https://discuss.elastic.co/t/limit-on-has-child-query/181540)
**Author:** [@Animesh\_singh](https://discuss.elastic.co/u/Animesh_singh)\ **Replies:** 0\ **Last updated:** [May 17, 2019, 8:09am UTC](https://discuss.elastic.co/t/limit-on-has-child-query/181540 "2019-05-17T08:09:41Z")
Hey , I have a requirement of that when i am performing has child query i want elastic search to take top ten hits of child document and then return their parents instead of returning all the parents of all the hits . A… --- ## [Docker Elasticsearch in Production](https://discuss.elastic.co/t/docker-elasticsearch-in-production/181096)
**Author:** [@merceskoba](https://discuss.elastic.co/u/merceskoba)\ **Replies:** 2\ **Last updated:** [May 17, 2019, 8:08am UTC](https://discuss.elastic.co/t/docker-elasticsearch-in-production/181096 "2019-05-17T08:08:37Z")
Hello Elastic members, I wanna ask you something that this is very important for my career LMAO :kidding: So, right now i have a elasticsearch cluster with 5 master nodes & 5 data nodes. In a day, my elasticsearch col… --- ## [Indexing MySQL data with ElasticSearch](https://discuss.elastic.co/t/indexing-mysql-data-with-elasticsearch/181506)
**Author:** [@Natasha96](https://discuss.elastic.co/u/Natasha96)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 8:03am UTC](https://discuss.elastic.co/t/indexing-mysql-data-with-elasticsearch/181506 "2019-05-17T08:03:11Z")
I would like to get some feedback from anyone who's had experience indexing MySQL data with ElasticSearch for full-text searching. How did you accomplish this? I've been researching this a bit and unfortunately I've noti… --- ## [I am not able to launch the elasticsearch in windows](https://discuss.elastic.co/t/i-am-not-able-to-launch-the-elasticsearch-in-windows/181537)
**Author:** [@dilipchiru](https://discuss.elastic.co/u/dilipchiru)\ **Replies:** 0\ **Last updated:** [May 17, 2019, 7:51am UTC](https://discuss.elastic.co/t/i-am-not-able-to-launch-the-elasticsearch-in-windows/181537 "2019-05-17T07:51:39Z")
Hi , i have tried to install the new version of elasticsearch in my laptop when i run the elasticsearch.bat file i am getting the below error it is windows version of zip i have downloaded Please help !!! D:\\ELK Stac… --- ## [Bit help against yellow cluster](https://discuss.elastic.co/t/bit-help-against-yellow-cluster/181517)
**Author:** [@Vikash\_Singh1](https://discuss.elastic.co/u/Vikash_Singh1)\ **Replies:** 1\ **Last updated:** [May 17, 2019, 7:49am UTC](https://discuss.elastic.co/t/bit-help-against-yellow-cluster/181517 "2019-05-17T07:49:16Z")
Every time I check the health of an index it show yellow. There are 5 primaries & 1 replicas I've also executed curl 10.1.109.5:9200/\_cat/indices?v & it's output was 5p 1r. Along with this also executed curl 10.1.109.5… --- ## [How to partial search(as done using prefix) in elastic on the basis of a field having datatype as long](https://discuss.elastic.co/t/how-to-partial-search-as-done-using-prefix-in-elastic-on-the-basis-of-a-field-having-datatype-as-long/181533)
**Author:** [@Vardhaman](https://discuss.elastic.co/u/Vardhaman)\ **Replies:** 0\ **Last updated:** [May 17, 2019, 7:39am UTC](https://discuss.elastic.co/t/how-to-partial-search-as-done-using-prefix-in-elastic-on-the-basis-of-a-field-having-datatype-as-long/181533 "2019-05-17T07:39:02Z")
Searching on the basis of a field having type as long --- ## [java.lang.OutOfMemoryError: Java heap space --------- with bad net work](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-with-bad-net-work/181355)
**Author:** [@chenchuangc](https://discuss.elastic.co/u/chenchuangc)\ **Replies:** 2\ **Last updated:** [May 17, 2019, 6:51am UTC](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-with-bad-net-work/181355 "2019-05-17T06:51:21Z")
Elasticsearch version bin/elasticsearch --version 6.3.2 Plugins installed bin/elasticsearch-plugin list analysis-ik JVM version java -version java version "1.8.0\_91" Java(TM) SE Runtime Environment (build 1.8.0\_91-… --- ## [How can I add a second exist query?](https://discuss.elastic.co/t/how-can-i-add-a-second-exist-query/181504)
**Author:** [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\ **Replies:** 2\ **Last updated:** [May 17, 2019, 6:43am UTC](https://discuss.elastic.co/t/how-can-i-add-a-second-exist-query/181504 "2019-05-17T06:43:24Z")
Hi, I got this query which is working fine but instead of only checking for the error field I want to check for error or warning so the documents where either the error field or warning field exists, are returned. GET … --- ## [Index template not updated](https://discuss.elastic.co/t/index-template-not-updated/181427)
**Author:** [@asp](https://discuss.elastic.co/u/asp)\ **Replies:** 2\ **Last updated:** [May 17, 2019, 6:39am UTC](https://discuss.elastic.co/t/index-template-not-updated/181427 "2019-05-17T06:39:22Z")
HI all, I have an index template which is defined to use only a single shard. GET \_template/plx { "plx" : { "order" : 0, "index\_patterns" : \[ "plx\*" \], "settings" : { "index" : { … --- ## [How to apply mappings just once?](https://discuss.elastic.co/t/how-to-apply-mappings-just-once/181280)
**Author:** [@jcaballero](https://discuss.elastic.co/u/jcaballero)\ **Replies:** 3\ **Last updated:** [May 17, 2019, 5:31am UTC](https://discuss.elastic.co/t/how-to-apply-mappings-just-once/181280 "2019-05-17T05:31:43Z")
Hello, maybe the subject is a little bit unclear... Sorry Elasticsearch 5.6.10 First time I tried to sort some field in the Kibana dashboard, I got an error message like "Fielddata is disabled on text fields by default… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1295) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1297)