# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1713 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1714 --- ## [How to calculate number of data node requirement in a cluster](https://discuss.elastic.co/t/how-to-calculate-number-of-data-node-requirement-in-a-cluster/128879)
**Author:** [@Jayakrishnan\_Nair](https://discuss.elastic.co/u/Jayakrishnan_Nair)\ **Replies:** 1\ **Last updated:** [April 20, 2018, 12:54pm UTC](https://discuss.elastic.co/t/how-to-calculate-number-of-data-node-requirement-in-a-cluster/128879 "2018-04-20T12:54:33Z")
How to calculate number of data only node required in a cluster. Calculating it in terms of number of shards, indexes or size of shards, indexes. Can any give some pointer or limits that provides pointer to add more d… --- ## [High Cpu utilization](https://discuss.elastic.co/t/high-cpu-utilization/128794)
**Author:** [@gangireddy\_l](https://discuss.elastic.co/u/gangireddy_l)\ **Replies:** 5\ **Last updated:** [April 20, 2018, 12:53pm UTC](https://discuss.elastic.co/t/high-cpu-utilization/128794 "2018-04-20T12:53:39Z")
Hi, Logstash and Elasticsearch are utilizing high cpu. \[image\] \[image\] --- ## [\[ Frequent OOME on coordinator node \]](https://discuss.elastic.co/t/frequent-oome-on-coordinator-node/128539)
**Author:** [@jerome831361](https://discuss.elastic.co/u/jerome831361)\ **Replies:** 7\ **Last updated:** [April 20, 2018, 12:51pm UTC](https://discuss.elastic.co/t/frequent-oome-on-coordinator-node/128539 "2018-04-20T12:51:15Z")
Hi, Since some 5 days, my coordinating nodes are both crashing frequenty with a OOME. I have tried to gather some usefull information to help investigating the problem; but I can't figure out what is wrong. I'm not re… --- ## [Filter field by length](https://discuss.elastic.co/t/filter-field-by-length/128745)
**Author:** [@tim99](https://discuss.elastic.co/u/tim99)\ **Replies:** 4\ **Last updated:** [April 20, 2018, 12:50pm UTC](https://discuss.elastic.co/t/filter-field-by-length/128745 "2018-04-20T12:50:37Z")
hi there, i tried to select data in condition to have only values with length \<= 4 in the feild "src". elasticsearch version : 6.2.3 kibana version : 6.2.3 that's my script : ( i'm working on kibana ) { "query": { … --- ## [Ingest-attachment how to use analysis-ik as analyzer?](https://discuss.elastic.co/t/ingest-attachment-how-to-use-analysis-ik-as-analyzer/128812)
**Author:** [@lxiaoixi](https://discuss.elastic.co/u/lxiaoixi)\ **Replies:** 1\ **Last updated:** [April 20, 2018, 12:47pm UTC](https://discuss.elastic.co/t/ingest-attachment-how-to-use-analysis-ik-as-analyzer/128812 "2018-04-20T12:47:20Z")
I want to search file 'attachment.content' use analysis-ik,what should I do? "data": { //必须同管道的field 字段值相同 "type": "text", "analyzer": "ik\_max\_word" // } Is this right? --- ## [Service starts but connections refused on public IP and localhost](https://discuss.elastic.co/t/service-starts-but-connections-refused-on-public-ip-and-localhost/128851)
**Author:** [@Ant](https://discuss.elastic.co/u/Ant)\ **Replies:** 2\ **Last updated:** [April 20, 2018, 12:36pm UTC](https://discuss.elastic.co/t/service-starts-but-connections-refused-on-public-ip-and-localhost/128851 "2018-04-20T12:36:08Z")
OK the story so far: upgraded dev box from 5.6.6 to 6.2.4 for more info see FYI this is a 1 node cluster, prod is 3 nodes but I need to get dev done first. I've now got the elastic service to start, if I use the elas… --- ## [When the featur of Index Sorting will become official GA features?](https://discuss.elastic.co/t/when-the-featur-of-index-sorting-will-become-official-ga-features/127938)
**Author:** [@hellokitty](https://discuss.elastic.co/u/hellokitty)\ **Replies:** 1\ **Last updated:** [April 20, 2018, 12:35pm UTC](https://discuss.elastic.co/t/when-the-featur-of-index-sorting-will-become-official-ga-features/127938 "2018-04-20T12:35:42Z")
https://www.elastic.co/guide/en/elasticsearch/reference/current/index-modules-index-sorting.html As we know, Index Sorting is an important feature in some case like query top records order by some field(create\_time etc)… --- ## [Question about setup Elasticsearch with Loadbalancing](https://discuss.elastic.co/t/question-about-setup-elasticsearch-with-loadbalancing/128865)
**Author:** [@Edouard\_Fazenda](https://discuss.elastic.co/u/Edouard_Fazenda)\ **Replies:** 2\ **Last updated:** [April 20, 2018, 12:26pm UTC](https://discuss.elastic.co/t/question-about-setup-elasticsearch-with-loadbalancing/128865 "2018-04-20T12:26:36Z")
Dear Community, I want to put in place a kind of redundant loadbalancing setup with 2 ElasticSearch nodes + 2 Kibana Nodes with Elasticsearch Coordinated Only node role. Here a picture of the setup \[Capture\] I will g… --- ## [Introduction to machine learning](https://discuss.elastic.co/t/introduction-to-machine-learning/128859)
**Author:** [@1862347ba9566e72a47d](https://discuss.elastic.co/u/1862347ba9566e72a47d)\ **Replies:** 1\ **Last updated:** [April 20, 2018, 11:20am UTC](https://discuss.elastic.co/t/introduction-to-machine-learning/128859 "2018-04-20T11:20:37Z")
Tell me please, I'm interested in machine learning. Where can I get acquainted with the material on machine learning, which contains details of ML, then it is created, technical documentation, what neural networks are us… --- ## [Bulk import unbalanced](https://discuss.elastic.co/t/bulk-import-unbalanced/128818)
**Author:** [@JackFazackerley](https://discuss.elastic.co/u/JackFazackerley)\ **Replies:** 11\ **Last updated:** [April 20, 2018, 11:01am UTC](https://discuss.elastic.co/t/bulk-import-unbalanced/128818 "2018-04-20T11:01:58Z")
Elasticsearch version: 6.2.3 JVM version: openjdk version "1.8.0\_162" OpenJDK Runtime Environment (build 1.8.0\_162-8u162-b12-0ubuntu0.16.04.2-b12) OpenJDK 64-Bit Server VM (build 25.162-b12, mixed mode OS version L… --- ## [Upgrade from 5.6.6 to 6.2.4, elastic failed to start](https://discuss.elastic.co/t/upgrade-from-5-6-6-to-6-2-4-elastic-failed-to-start/128741)
**Author:** [@Ant](https://discuss.elastic.co/u/Ant)\ **Replies:** 1\ **Last updated:** [April 20, 2018, 10:04am UTC](https://discuss.elastic.co/t/upgrade-from-5-6-6-to-6-2-4-elastic-failed-to-start/128741 "2018-04-20T10:04:45Z")
Continuing the discussion from Elasticsearch Service won't start after full cluster upgrade from 5.4 to 6.0: I'm mid upgrade from 5.6.6. to 6.2.4 and haivng an issue getting elastic to start, if I look in /usr/lib/syst… --- ## [Searchguard issue with sgadmin script log](https://discuss.elastic.co/t/searchguard-issue-with-sgadmin-script-log/128791)
**Author:** [@Aparneswara\_Raju](https://discuss.elastic.co/u/Aparneswara_Raju)\ **Replies:** 2\ **Last updated:** [April 20, 2018, 9:53am UTC](https://discuss.elastic.co/t/searchguard-issue-with-sgadmin-script-log/128791 "2018-04-20T09:53:33Z")
Hi , Am facing issue while executing the below command not sure what am missing in this. Can some please help me out on this. ./sgadmin.sh -cd ../sgconfig -icl -nhnv -ts /etc/elasticsearch/truststore.jks -tspass change… --- ## [Elasticsearch cluster of 4 nodes has "master not discovered exception"](https://discuss.elastic.co/t/elasticsearch-cluster-of-4-nodes-has-master-not-discovered-exception/124984)
**Author:** [@minidan](https://discuss.elastic.co/u/minidan)\ **Replies:** 17\ **Last updated:** [April 20, 2018, 9:38am UTC](https://discuss.elastic.co/t/elasticsearch-cluster-of-4-nodes-has-master-not-discovered-exception/124984 "2018-04-20T09:38:37Z")
Hi, I had an error last week, seemed to be RAM in Java that parked my install on the first node (where Kibana role was installed). Ever since then I cannot get the cluster back operational. When it is all restarted, al… --- ## [Position as result, instead of highlighting](https://discuss.elastic.co/t/position-as-result-instead-of-highlighting/128820)
**Author:** [@Despotis](https://discuss.elastic.co/u/Despotis)\ **Replies:** 0\ **Last updated:** [April 20, 2018, 8:00am UTC](https://discuss.elastic.co/t/position-as-result-instead-of-highlighting/128820 "2018-04-20T08:00:10Z")
I try to get positions instead of highlighted text as the result of elasticsearch query. Create the index: PUT /test/ { "mappings": { "article": { "properties": { "text": { "type": "text",… --- ## [Any better way to manage everything related to Elastic search / ELK](https://discuss.elastic.co/t/any-better-way-to-manage-everything-related-to-elastic-search-elk/128835)
**Author:** [@N0rbis](https://discuss.elastic.co/u/N0rbis)\ **Replies:** 2\ **Last updated:** [April 20, 2018, 9:09am UTC](https://discuss.elastic.co/t/any-better-way-to-manage-everything-related-to-elastic-search-elk/128835 "2018-04-20T09:09:50Z")
Does anyone have a better way to manage everything related to ELK? I mean something similar to IDE where everything is easily manageable (For example using sublime text you can edit almost all documents in one place, do… --- ## [SQL to ES Query](https://discuss.elastic.co/t/sql-to-es-query/128821)
**Author:** [@swolfo](https://discuss.elastic.co/u/swolfo)\ **Replies:** 2\ **Last updated:** [April 20, 2018, 8:30am UTC](https://discuss.elastic.co/t/sql-to-es-query/128821 "2018-04-20T08:30:09Z")
Hi all, I'm pretty new to Elastic, and I'm struggling in writing the right ES Query, corresponding to this simple SQL query: select \* from TABLE where ID in (select ID from TABLE where 'level'='ERROR'); Actually, what… --- ## [Centralized logging with ELK Stack - Sizing question](https://discuss.elastic.co/t/centralized-logging-with-elk-stack-sizing-question/128777)
**Author:** [@rinderbe](https://discuss.elastic.co/u/rinderbe)\ **Replies:** 2\ **Last updated:** [April 20, 2018, 8:02am UTC](https://discuss.elastic.co/t/centralized-logging-with-elk-stack-sizing-question/128777 "2018-04-20T08:02:09Z")
Hi, I am very new to the fantastic world of Elastic and the whole ELK Stack, so sorry for any dumb question that might pop up in this post. I am right now working on a project where we are looking into replacing our ex… --- ## [Stuck doctype in elasticsearch 6.2.3](https://discuss.elastic.co/t/stuck-doctype-in-elasticsearch-6-2-3/128700)
**Author:** [@kehu](https://discuss.elastic.co/u/kehu)\ **Replies:** 4\ **Last updated:** [April 20, 2018, 7:03am UTC](https://discuss.elastic.co/t/stuck-doctype-in-elasticsearch-6-2-3/128700 "2018-04-20T07:03:12Z")
Hello. I'm having some problems with the doc\_type in elasticsearch. The doctype in my index used to be "doc" like it's supposed to be by default, but it got changed to something else. This leads to errors when trying to… --- ## [Elasticsearch stopped working](https://discuss.elastic.co/t/elasticsearch-stopped-working/128501)
**Author:** [@rahulnama](https://discuss.elastic.co/u/rahulnama)\ **Replies:** 13\ **Last updated:** [April 20, 2018, 6:38am UTC](https://discuss.elastic.co/t/elasticsearch-stopped-working/128501 "2018-04-20T06:38:34Z")
Hello Team Unfortunately, my elasticsearch stopped working. and I'm not sure what to do. Please have a look at my logs org.elasticsearch.action.NoShardAvailableActionException: No shard available for \[get \[.kibana\]\[doc… --- ## [Painless null pointer exception](https://discuss.elastic.co/t/painless-null-pointer-exception/128245)
**Author:** [@Syed\_ali\_abbas\_shah](https://discuss.elastic.co/u/Syed_ali_abbas_shah)\ **Replies:** 5\ **Last updated:** [April 20, 2018, 5:47am UTC](https://discuss.elastic.co/t/painless-null-pointer-exception/128245 "2018-04-20T05:47:20Z")
Here is My query , I am using elastic search 6.2 and my java version is 1.9 GET /users\_small/user/\_search { "\_source": \[ "id", "username", "full\_name", "picture", "message\_privacy" \], "from": 0… --- ## [Query ElasticSearch for documents with terms matching exclusively](https://discuss.elastic.co/t/query-elasticsearch-for-documents-with-terms-matching-exclusively/128424)
**Author:** [@dierre](https://discuss.elastic.co/u/dierre)\ **Replies:** 3\ **Last updated:** [April 20, 2018, 5:42am UTC](https://discuss.elastic.co/t/query-elasticsearch-for-documents-with-terms-matching-exclusively/128424 "2018-04-20T05:42:56Z")
I was porting a SQL query on ElasticSearch. The query needs to substitute an IN clause. Following this link I implemented the IN this way: { "size": 1, "query": { "constant\_score": { "filter": { … --- ## [Multi-node setup: Do they need same specs?](https://discuss.elastic.co/t/multi-node-setup-do-they-need-same-specs/128650)
**Author:** [@smlbiobot](https://discuss.elastic.co/u/smlbiobot)\ **Replies:** 2\ **Last updated:** [April 20, 2018, 5:27am UTC](https://discuss.elastic.co/t/multi-node-setup-do-they-need-same-specs/128650 "2018-04-20T05:27:32Z")
First question: I have been running ES on a single node (mostly because of budgetary constraints). Right now it has reached its full capacity and I am looking into adding nodes to it. However, again, because of budgetary… --- ## [Save field as float instead of String](https://discuss.elastic.co/t/save-field-as-float-instead-of-string/128674)
**Author:** [@Abhilash\_Sathe](https://discuss.elastic.co/u/Abhilash_Sathe)\ **Replies:** 13\ **Last updated:** [April 20, 2018, 4:13am UTC](https://discuss.elastic.co/t/save-field-as-float-instead-of-string/128674 "2018-04-20T04:13:04Z")
So basically, I'm doing a bulk insert for a huge amount of data. There is a field in that data called price which is of String data type by default. However, what I want is to save that field in ES as a float data type.… --- ## [PostMan query vs Kibana Query](https://discuss.elastic.co/t/postman-query-vs-kibana-query/128613)
**Author:** [@naveenchitluri](https://discuss.elastic.co/u/naveenchitluri)\ **Replies:** 2\ **Last updated:** [April 20, 2018, 3:51am UTC](https://discuss.elastic.co/t/postman-query-vs-kibana-query/128613 "2018-04-20T03:51:36Z")
Hi I am trying to call RESTful service by sending "POST" request to the following URL using postman...please see the request and response below. The response has no results returned...but when I try same query in Kiban… --- ## [Confusion in using synonym token filter in elasticsearch 6.x](https://discuss.elastic.co/t/confusion-in-using-synonym-token-filter-in-elasticsearch-6-x/128454)
**Author:** [@nishant.saini](https://discuss.elastic.co/u/nishant.saini)\ **Replies:** 7\ **Last updated:** [April 20, 2018, 3:46am UTC](https://discuss.elastic.co/t/confusion-in-using-synonym-token-filter-in-elasticsearch-6-x/128454 "2018-04-20T03:46:34Z")
Synonym token in elasticsearch v2.4 supports tokenizer parameter. Hence token filter could have its own tokenizer (here "keyword") different from that is being used in custom analyser (here "whitespace") as in below sett… --- ## [Read timeout error after setting the request\_timeout](https://discuss.elastic.co/t/read-timeout-error-after-setting-the-request-timeout/128626)
**Author:** [@niraj\_pandey](https://discuss.elastic.co/u/niraj_pandey)\ **Replies:** 3\ **Last updated:** [April 20, 2018, 3:09am UTC](https://discuss.elastic.co/t/read-timeout-error-after-setting-the-request-timeout/128626 "2018-04-20T03:09:38Z")
Hi , I am feteching the data via python script and getting the following error: elasticsearch.exceptions.ConnectionTimeout: ConnectionTimeout caused by - ReadTimeoutError(HTTPConnectionPool(host='hnode07', port=9200): … --- ## [Elastic mapping for nested directories](https://discuss.elastic.co/t/elastic-mapping-for-nested-directories/128476)
**Author:** [@Fabiano](https://discuss.elastic.co/u/Fabiano)\ **Replies:** 1\ **Last updated:** [April 20, 2018, 2:19am UTC](https://discuss.elastic.co/t/elastic-mapping-for-nested-directories/128476 "2018-04-20T02:19:08Z")
I want to store files and directories in this manner \[new\] I am new to elastic.Can someone show links with examples? --- ## [Document Size Limit to 2kb while indexing document](https://discuss.elastic.co/t/document-size-limit-to-2kb-while-indexing-document/128337)
**Author:** [@Nitin\_Gupta2](https://discuss.elastic.co/u/Nitin_Gupta2)\ **Replies:** 7\ **Last updated:** [April 20, 2018, 2:14am UTC](https://discuss.elastic.co/t/document-size-limit-to-2kb-while-indexing-document/128337 "2018-04-20T02:14:21Z")
Hello team, I'm facing a serious issue while trying to index a document. I've simple java object "Country" which contains simple fields. Shown below; @JsonProperty("country") private String countryName; @JsonPro… --- ## [HighLevelRest java client : Search query returning zero hits despite the equivalent HTTP curl call returning results (hits\> 0)](https://discuss.elastic.co/t/highlevelrest-java-client-search-query-returning-zero-hits-despite-the-equivalent-http-curl-call-returning-results-hits-0/128727)
**Author:** [@Gemma\_Cabero](https://discuss.elastic.co/u/Gemma_Cabero)\ **Replies:** 1\ **Last updated:** [April 20, 2018, 2:08am UTC](https://discuss.elastic.co/t/highlevelrest-java-client-search-query-returning-zero-hits-despite-the-equivalent-http-curl-call-returning-results-hits-0/128727 "2018-04-20T02:08:00Z")
I'm currently migrating all our elastic search client code (both in Java and python) to 6.2. The index and data creation works well but searches/queries on elastic search using the java client are now failing by either r… --- ## [Curator "allocated" filtertype does not seem to work](https://discuss.elastic.co/t/curator-allocated-filtertype-does-not-seem-to-work/118899)
**Author:** [@oododa](https://discuss.elastic.co/u/oododa)\ **Replies:** 8\ **Last updated:** [April 20, 2018, 1:53am UTC](https://discuss.elastic.co/t/curator-allocated-filtertype-does-not-seem-to-work/118899 "2018-04-20T01:53:19Z")
In my hot/warm/cold ES setup (ES 5.6.6, Curator 5.4.1), I've got a curator action file designed to target indexes on the single-disk warm nodes for shrinking. Curator seems to ignore the 'allocated' filtertype, and the f… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1712) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1714)