# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1757 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1758 --- ## [Buckets size filter](https://discuss.elastic.co/t/buckets-size-filter/123520)
**Author:** [@cekeriya](https://discuss.elastic.co/u/cekeriya)\ **Replies:** 0\ **Last updated:** [March 12, 2018, 9:58am UTC](https://discuss.elastic.co/t/buckets-size-filter/123520 "2018-03-12T09:58:42Z")
Hi everybody I want my query to return only bucket\[\].size \> 0 How can I do this? Thanks Here is my query result { "took": 3, "timed\_out": false, "\_shards": { "total": 5, "successful": 5, "failed": … --- ## [Getting authentication error](https://discuss.elastic.co/t/getting-authentication-error/123258)
**Author:** [@Bharathkumarraju](https://discuss.elastic.co/u/Bharathkumarraju)\ **Replies:** 8\ **Last updated:** [March 12, 2018, 9:35am UTC](https://discuss.elastic.co/t/getting-authentication-error/123258 "2018-03-12T09:35:05Z")
I am installing elasticsearch freshly and installed x-pack as well. It is elasticsearch6.2.1 test@test\[~\] $ curl -XPOST -u elastic -ks 'https://10.192.87.187:9200/\_xpack/security/user/elastic/\_password' -H 'Content-Type… --- ## [Unable to connect ES cloud](https://discuss.elastic.co/t/unable-to-connect-es-cloud/121160)
**Author:** [@chhavi\_bahekar](https://discuss.elastic.co/u/chhavi_bahekar)\ **Replies:** 5\ **Last updated:** [March 12, 2018, 9:34am UTC](https://discuss.elastic.co/t/unable-to-connect-es-cloud/121160 "2018-03-12T09:34:26Z")
Hi All, I am unable to connect ES cloud using transport client with below code.I have created transport\_client user using kibana but application throwing exception shown below. Could you please help me to resolve th… --- ## [Implementing many to many relations with elastic](https://discuss.elastic.co/t/implementing-many-to-many-relations-with-elastic/123423)
**Author:** [@sepide\_mahmoodi](https://discuss.elastic.co/u/sepide_mahmoodi)\ **Replies:** 5\ **Last updated:** [March 12, 2018, 9:31am UTC](https://discuss.elastic.co/t/implementing-many-to-many-relations-with-elastic/123423 "2018-03-12T09:31:00Z")
Hi. i have news, category and news\_category\_relation tables in mysql and i use logstash to import these data to elastic. i want to get relational data of news and its categoies in one query that have output like below: … --- ## [X-Pack security issue Realm Oauth2](https://discuss.elastic.co/t/x-pack-security-issue-realm-oauth2/121466)
**Author:** [@PinkiMondal](https://discuss.elastic.co/u/PinkiMondal)\ **Replies:** 4\ **Last updated:** [March 12, 2018, 9:25am UTC](https://discuss.elastic.co/t/x-pack-security-issue-realm-oauth2/121466 "2018-03-12T09:25:15Z")
Hi I am using xpack 5.5.0. I am implementing oauth realm security and installed it as an extension inside elasticsearch xpack plugin. Now I have a Java application which uses spring security. I want to access kibana fr… --- ## [Executer/worker closing connection before trying to write, causing a SSLHandshakeException](https://discuss.elastic.co/t/executer-worker-closing-connection-before-trying-to-write-causing-a-sslhandshakeexception/123114)
**Author:** [@viktorqt](https://discuss.elastic.co/u/viktorqt)\ **Replies:** 1\ **Last updated:** [March 12, 2018, 9:24am UTC](https://discuss.elastic.co/t/executer-worker-closing-connection-before-trying-to-write-causing-a-sslhandshakeexception/123114 "2018-03-12T09:24:41Z")
Hello, around 1/3 of our files fail to write a DataFrame into Elasticsearch from our Spark-Application while using the ElasticSearch-Spark-Connector due to the following exception: org.elasticsearch.hadoop.rest.EsHadoo… --- ## [X-Pack extension Custom Realm Error](https://discuss.elastic.co/t/x-pack-extension-custom-realm-error/122047)
**Author:** [@PinkiMondal](https://discuss.elastic.co/u/PinkiMondal)\ **Replies:** 2\ **Last updated:** [March 12, 2018, 9:22am UTC](https://discuss.elastic.co/t/x-pack-extension-custom-realm-error/122047 "2018-03-12T09:22:29Z")
Hi All I am getting below exception: D: /..elasticsearch-5.5.1\\bin\\x-pack\>extension install file:///D:/.../spring-security-x-pack-realm.zip -\> Downloading file:///D:/.../spring-security-x-pack-realm.zip Exception in … --- ## [ES6.2.2 cannot initialize, allocate physical memory very slow](https://discuss.elastic.co/t/es6-2-2-cannot-initialize-allocate-physical-memory-very-slow/123502)
**Author:** [@jinleileiking](https://discuss.elastic.co/u/jinleileiking)\ **Replies:** 1\ **Last updated:** [March 12, 2018, 9:05am UTC](https://discuss.elastic.co/t/es6-2-2-cannot-initialize-allocate-physical-memory-very-slow/123502 "2018-03-12T09:05:55Z")
Describe the feature: Elasticsearch version (bin/elasticsearch --version): 6.2.2 Plugins installed: \[no plugin\] JVM version (java -version): 1.8.0 OS version (uname -a if on a Unix-like system): inux tjwq01-ibu-vide… --- ## [Script groovy may cause memory leak in elastic v5.4](https://discuss.elastic.co/t/script-groovy-may-cause-memory-leak-in-elastic-v5-4/119407)
**Author:** [@1222kkk](https://discuss.elastic.co/u/1222kkk)\ **Replies:** 4\ **Last updated:** [March 12, 2018, 8:43am UTC](https://discuss.elastic.co/t/script-groovy-may-cause-memory-leak-in-elastic-v5-4/119407 "2018-03-12T08:43:26Z")
Recently, I found my elasticsearch cluster always get full gc every two days. Cluster settings are as follows: es version: v2.3.2 2 \* node, every node set 8G for es data size is just 500MB+ with 5 indices I recogniz… --- ## [Watchers Issue(S)](https://discuss.elastic.co/t/watchers-issue-s/123232)
**Author:** [@kamandohl](https://discuss.elastic.co/u/kamandohl)\ **Replies:** 2\ **Last updated:** [March 12, 2018, 8:28am UTC](https://discuss.elastic.co/t/watchers-issue-s/123232 "2018-03-12T08:28:11Z")
While attempting to setup Watchers received a 500 error in Kibana. Log entry from Kibana: Mar 09 08:36:58 kibana\[8532\]: {"type":"response","@timestamp":"2018-03-09T08:36:58Z","tags": ,"pid":8532,"method":"get","status… --- ## [How to setup Three Machines with different IP Address?](https://discuss.elastic.co/t/how-to-setup-three-machines-with-different-ip-address/123008)
**Author:** [@Karthik\_Saravanan](https://discuss.elastic.co/u/Karthik_Saravanan)\ **Replies:** 3\ **Last updated:** [March 12, 2018, 8:08am UTC](https://discuss.elastic.co/t/how-to-setup-three-machines-with-different-ip-address/123008 "2018-03-12T08:08:37Z")
I have three machines, installed same ELK(6.2.2) version in all machine Now, I have to connect all node, One is master and another two's are client node, \*\* Each machine is the different IP address I have tried like t… --- ## [Return array element with a matching id](https://discuss.elastic.co/t/return-array-element-with-a-matching-id/123494)
**Author:** [@Abhilash\_Sathe](https://discuss.elastic.co/u/Abhilash_Sathe)\ **Replies:** 1\ **Last updated:** [March 12, 2018, 8:06am UTC](https://discuss.elastic.co/t/return-array-element-with-a-matching-id/123494 "2018-03-12T08:06:12Z")
Request: { "query": { "match": { "id": "Z2lkOi8vc2hvcGlmeS9Qcm9kdWN0LzIyODA5MjA1MTQ4NQ==" } } } Response: { "took": 2, "timed\_out": false, "\_shards": { "total": 5, "successful": 5, "skipped": 0, "failed":… --- ## [Hi guys I have problem with elasticsearch Java its stopping, please see logs below](https://discuss.elastic.co/t/hi-guys-i-have-problem-with-elasticsearch-java-its-stopping-please-see-logs-below/123417)
**Author:** [@mabialakienda](https://discuss.elastic.co/u/mabialakienda)\ **Replies:** 17\ **Last updated:** [March 12, 2018, 7:38am UTC](https://discuss.elastic.co/t/hi-guys-i-have-problem-with-elasticsearch-java-its-stopping-please-see-logs-below/123417 "2018-03-12T07:38:51Z")
org.apache.lucene.codecs.blocktree.BlockTreeTermsWriter$TermsWriter.write(BlockTreeTermsWriter.java:869) ~\[lucene-core-7.2.1.jar:7.2.1 b2b6438b37073bee1fca40374e85bf91aa457c0b - ubuntu - 2018-01-10 00:48:43\] at org.apac… --- ## [Percolator type : Why fields are not part of the percolator type settings?](https://discuss.elastic.co/t/percolator-type-why-fields-are-not-part-of-the-percolator-type-settings/121697)
**Author:** [@pulse14](https://discuss.elastic.co/u/pulse14)\ **Replies:** 2\ **Last updated:** [March 12, 2018, 7:05am UTC](https://discuss.elastic.co/t/percolator-type-why-fields-are-not-part-of-the-percolator-type-settings/121697 "2018-03-12T07:05:18Z")
I don't understand why we need to define fields of the percolated document on the same mapping of the percolate type. If these fields are just used to "preprocess the document defined in the percolator query ", Why t… --- ## [Delete by query - Error invalid\_type\_name\_exception](https://discuss.elastic.co/t/delete-by-query-error-invalid-type-name-exception/119629)
**Author:** [@abdujaparov](https://discuss.elastic.co/u/abdujaparov)\ **Replies:** 1\ **Last updated:** [March 12, 2018, 6:38am UTC](https://discuss.elastic.co/t/delete-by-query-error-invalid-type-name-exception/119629 "2018-03-12T06:38:59Z")
Hi, I am trying to delete some elements with delete\_by\_query. I should remove 5 elements: curl -XGET 'localhost:9200/product\_metadata/\_count?pretty' -d '{"query": {"match":{"type.identifier": "plastic"}}}' If I execu… --- ## [How to use regexp query filter in ElasticSearch Source Filtering?](https://discuss.elastic.co/t/how-to-use-regexp-query-filter-in-elasticsearch-source-filtering/123326)
**Author:** [@srikanth539](https://discuss.elastic.co/u/srikanth539)\ **Replies:** 7\ **Last updated:** [March 12, 2018, 6:30am UTC](https://discuss.elastic.co/t/how-to-use-regexp-query-filter-in-elasticsearch-source-filtering/123326 "2018-03-12T06:30:24Z")
For given below test data of ElasticSearch index, how do we eliminate the field name(s) containing UUID? Can we make use of regular expressions here? Per my understanding, regexp will match the values but not keys. { … --- ## [Setup Authentication and Authorization WITHOUT X-Pack?](https://discuss.elastic.co/t/setup-authentication-and-authorization-without-x-pack/123458)
**Author:** [@titan1978](https://discuss.elastic.co/u/titan1978)\ **Replies:** 3\ **Last updated:** [March 12, 2018, 6:28am UTC](https://discuss.elastic.co/t/setup-authentication-and-authorization-without-x-pack/123458 "2018-03-12T06:28:10Z")
Am part of a small enterprise and unfortuntely we cannot afford the licensing model to leverage X-PACK. In light of this, I was wondering what is considered a robust open source authentication and authorization setup to… --- ## [Unable to get elasticsearch work with camel](https://discuss.elastic.co/t/unable-to-get-elasticsearch-work-with-camel/123248)
**Author:** [@dvkawa](https://discuss.elastic.co/u/dvkawa)\ **Replies:** 5\ **Last updated:** [March 12, 2018, 6:26am UTC](https://discuss.elastic.co/t/unable-to-get-elasticsearch-work-with-camel/123248 "2018-03-12T06:26:29Z")
Hi Team, I am doing a very small POC on camel-elasticsearch. Things look smooth as i debug through and there are no error or exceptions seen on the camel side. Even after code execution complete, i do not see the json … --- ## [Transport Client issue with ES cloud](https://discuss.elastic.co/t/transport-client-issue-with-es-cloud/123210)
**Author:** [@chhavi\_bahekar](https://discuss.elastic.co/u/chhavi_bahekar)\ **Replies:** 5\ **Last updated:** [March 12, 2018, 6:22am UTC](https://discuss.elastic.co/t/transport-client-issue-with-es-cloud/123210 "2018-03-12T06:22:17Z")
Hi All, I am unable to connect ES cloud with transport client version(5.6.8).Its showing error as None of the configured nodes are available. Here is the my java Example which I have taken from github(https://github.co… --- ## [How to run elastic search commands on RHEL Redhat Linux 6.6](https://discuss.elastic.co/t/how-to-run-elastic-search-commands-on-rhel-redhat-linux-6-6/123472)
**Author:** [@rohanparikh](https://discuss.elastic.co/u/rohanparikh)\ **Replies:** 5\ **Last updated:** [March 12, 2018, 5:05am UTC](https://discuss.elastic.co/t/how-to-run-elastic-search-commands-on-rhel-redhat-linux-6-6/123472 "2018-03-12T05:05:18Z")
Hello I am having an ubuntu 16.04 system and I can find all the commands that works for elastic search but when it comes to RHEL I am not able to find any good tutorial Please help --- ## [Very slow query](https://discuss.elastic.co/t/very-slow-query/123414)
**Author:** [@sasankvemuri](https://discuss.elastic.co/u/sasankvemuri)\ **Replies:** 7\ **Last updated:** [March 12, 2018, 3:34am UTC](https://discuss.elastic.co/t/very-slow-query/123414 "2018-03-12T03:34:16Z")
I have been trying to search and retrieve results based on 3 user input values and find the closest value that satisfies these three conditions. The doc has about 30 million rows and the query takes about 10 seconds to e… --- ## ["curl (56) Failure" for alias PUT call](https://discuss.elastic.co/t/curl-56-failure-for-alias-put-call/123466)
**Author:** [@jihun](https://discuss.elastic.co/u/jihun)\ **Replies:** 0\ **Last updated:** [March 12, 2018, 2:07am UTC](https://discuss.elastic.co/t/curl-56-failure-for-alias-put-call/123466 "2018-03-12T02:07:57Z")
Recently, curl for ES cluster sometimes fails with "curl: (56) Failure when receiving data from the peer" For example today a curl job run by Jenkins failed like below. ( removing alias succeed but adding alias failed) … --- ## [Best practices around moving documents between indices](https://discuss.elastic.co/t/best-practices-around-moving-documents-between-indices/123321)
**Author:** [@Andrew\_Leary](https://discuss.elastic.co/u/Andrew_Leary)\ **Replies:** 1\ **Last updated:** [March 11, 2018, 8:49pm UTC](https://discuss.elastic.co/t/best-practices-around-moving-documents-between-indices/123321 "2018-03-11T20:49:37Z")
Hi all, I have a question about the best approach to move data between indices when the mapping needs to be updated--I'm working with version 5.5. As an example, let's say I have my\_index\_v1 setup like this: my\_index\_v… --- ## [Understanding docker and memory settings](https://discuss.elastic.co/t/understanding-docker-and-memory-settings/123336)
**Author:** [@javadevmtl](https://discuss.elastic.co/u/javadevmtl)\ **Replies:** 2\ **Last updated:** [March 11, 2018, 2:58pm UTC](https://discuss.elastic.co/t/understanding-docker-and-memory-settings/123336 "2018-03-11T14:58:36Z")
Hi, running 6.2.2. By default docker does not restrain the memory settings. If we launch with... ES\_JAVA\_OPTS=-Xms20480m -Xmx20480m bootstrap.memory\_lock=true On a host with 128GB RAM will Elasticsearch running insi… --- ## [Search and get distenic result base on create\_at in elasticsearch](https://discuss.elastic.co/t/search-and-get-distenic-result-base-on-create-at-in-elasticsearch/123408)
**Author:** [@mohammad\_S07](https://discuss.elastic.co/u/mohammad_S07)\ **Replies:** 7\ **Last updated:** [March 11, 2018, 2:04pm UTC](https://discuss.elastic.co/t/search-and-get-distenic-result-base-on-create-at-in-elasticsearch/123408 "2018-03-11T14:04:15Z")
I store data in the Elasticsearch like this: { "\_index": "my\_index", "\_type": "doc", "\_id": "6lDquGEBFRQVe0x93eHk", "\_version": 1, "\_score": 1, "\_source": { "Barcode": "6947503728601", … --- ## [PHP Search entries according to year indexed](https://discuss.elastic.co/t/php-search-entries-according-to-year-indexed/122409)
**Author:** [@syiannop](https://discuss.elastic.co/u/syiannop)\ **Replies:** 1\ **Last updated:** [March 11, 2018, 11:25am UTC](https://discuss.elastic.co/t/php-search-entries-according-to-year-indexed/122409 "2018-03-11T11:25:19Z")
I am using the PHP client to search and index documents into ES. I created a button with different values (2018, 2017, 2016) so that a user can find entries according to the date the entries were made (for example: view … --- ## [Find by query and push to array in Elastic search](https://discuss.elastic.co/t/find-by-query-and-push-to-array-in-elastic-search/123372)
**Author:** [@mohammad\_S07](https://discuss.elastic.co/u/mohammad_S07)\ **Replies:** 2\ **Last updated:** [March 11, 2018, 5:39am UTC](https://discuss.elastic.co/t/find-by-query-and-push-to-array-in-elastic-search/123372 "2018-03-11T05:39:17Z")
I store data in the elastic search like this: { "\_index": "my\_index", "\_type": "doc", "\_id": "6lDquGEBFRQVe0x93eHk", "\_version": 1, "\_score": 1, "\_source": { "ID\_Number": "6947503728601", "Userrname":"Jack.m07", "name":… --- ## [Exception during create index operation using java high level rest client](https://discuss.elastic.co/t/exception-during-create-index-operation-using-java-high-level-rest-client/123108)
**Author:** [@AshutoshB](https://discuss.elastic.co/u/AshutoshB)\ **Replies:** 2\ **Last updated:** [March 10, 2018, 8:32pm UTC](https://discuss.elastic.co/t/exception-during-create-index-operation-using-java-high-level-rest-client/123108 "2018-03-10T20:32:50Z")
Hi, I am using java high level rest client v6.2.2 to connect es cluster v5.3.1. The create index api creates the index successfully but throws the exception: Exception in thread "main" java.io.IOException: Unable to pa… --- ## [Use latest NLPIR/ICTCLAS for Chinese Word Segmentation](https://discuss.elastic.co/t/use-latest-nlpir-ictclas-for-chinese-word-segmentation/123396)
**Author:** [@zoellner](https://discuss.elastic.co/u/zoellner)\ **Replies:** 1\ **Last updated:** [March 10, 2018, 7:57pm UTC](https://discuss.elastic.co/t/use-latest-nlpir-ictclas-for-chinese-word-segmentation/123396 "2018-03-10T19:57:11Z")
My understanding is that the Smart Chinese Analysis plugin (analysis-smartcn) uses the underlying Lucene plugin org.apache.lucene.analysis.cn.smart which, according to its documentation, is based on dictionary data from … --- ## [Inter index operation](https://discuss.elastic.co/t/inter-index-operation/121845)
**Author:** [@devil\_srj7](https://discuss.elastic.co/u/devil_srj7)\ **Replies:** 7\ **Last updated:** [March 10, 2018, 5:06pm UTC](https://discuss.elastic.co/t/inter-index-operation/121845 "2018-03-10T17:06:59Z")
Lets say, I have 2 indices. IndexA and IndexB. IndexA has: name and id. IndexB has: id and salary I need to have name and corresponding salary to the same ID. [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1756) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1758)