# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1056 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1057 --- ## [Want to delete documents from elasticsearch which are deleted from database](https://discuss.elastic.co/t/want-to-delete-documents-from-elasticsearch-which-are-deleted-from-database/213334)
**Author:** [@milankamboya](https://discuss.elastic.co/u/milankamboya)\ **Replies:** 3\ **Last updated:** [December 31, 2019, 8:08am UTC](https://discuss.elastic.co/t/want-to-delete-documents-from-elasticsearch-which-are-deleted-from-database/213334 "2019-12-31T08:08:00Z")
Hi All, I want to delete records from Elasticsearch for below use-case. What are the possible resolutions? Fetching data from database through logstash and adding into Elasticsearch. document\_id is combination of key … --- ## [Duplicated Document Over All Nodes](https://discuss.elastic.co/t/duplicated-document-over-all-nodes/213415)
**Author:** [@ZeroPoint](https://discuss.elastic.co/u/ZeroPoint)\ **Replies:** 0\ **Last updated:** [December 31, 2019, 7:26am UTC](https://discuss.elastic.co/t/duplicated-document-over-all-nodes/213415 "2019-12-31T07:26:04Z")
Hi ALL Im new in elastic and i want to design a cluster for increase performance and horizontal scaling. also we have very stable and high failed system so i dont need any elastic high availability. Question: when i t… --- ## [Chained input query - looping over hits values in query](https://discuss.elastic.co/t/chained-input-query-looping-over-hits-values-in-query/212903)
**Author:** [@Inammathe\_Inna](https://discuss.elastic.co/u/Inammathe_Inna)\ **Replies:** 2\ **Last updated:** [December 31, 2019, 7:08am UTC](https://discuss.elastic.co/t/chained-input-query-looping-over-hits-values-in-query/212903 "2019-12-31T07:08:58Z")
Hello, So I am a little stuck with this one.. Following this example: https://github.com/elastic/examples/blob/master/Alerting/Sample%20Watches/ml\_examples/bucket\_record\_chain\_watch.json I've managed to successfully c… --- ## [Query does not support \[prefix\]](https://discuss.elastic.co/t/query-does-not-support-prefix/213261)
**Author:** [@finau](https://discuss.elastic.co/u/finau)\ **Replies:** 1\ **Last updated:** [December 31, 2019, 4:59am UTC](https://discuss.elastic.co/t/query-does-not-support-prefix/213261 "2019-12-31T04:59:15Z")
When I post the following query, I got an error response {"error":{"root\_cause":\[{"type":"parsing\_exception","reason":"\[prefix\] query does not support \[prefix\]","line":1,"col":119}\],"type":"parsing\_exception","reason":"… --- ## [Cloud.elastic.co customer, need to perform REST search queries](https://discuss.elastic.co/t/cloud-elastic-co-customer-need-to-perform-rest-search-queries/213402)
**Author:** [@Arman\_Sharafshahi](https://discuss.elastic.co/u/Arman_Sharafshahi)\ **Replies:** 1\ **Last updated:** [December 31, 2019, 3:24am UTC](https://discuss.elastic.co/t/cloud-elastic-co-customer-need-to-perform-rest-search-queries/213402 "2019-12-31T03:24:04Z")
Hi, I'm a user of Elastic and Kibana via the cloud.elastic.co service. I have an aggregation search query which works perfectly from the Kibana devtools console. I now need to perform this query via a REST HTTP call f… --- ## [Trying to figure out how to enable x-pack](https://discuss.elastic.co/t/trying-to-figure-out-how-to-enable-x-pack/213367)
**Author:** [@penguinairlines](https://discuss.elastic.co/u/penguinairlines)\ **Replies:** 1\ **Last updated:** [December 31, 2019, 12:09am UTC](https://discuss.elastic.co/t/trying-to-figure-out-how-to-enable-x-pack/213367 "2019-12-31T00:09:18Z")
I have been repeatedly failing to figure out how to properly enable x-pack. There's a lot of guides out there, but I still feel like I'm missing something. I built a new test machine to try to simplify this but am still … --- ## [Cluster rebalancing across AZs](https://discuss.elastic.co/t/cluster-rebalancing-across-azs/210946)
**Author:** [@dwilches](https://discuss.elastic.co/u/dwilches)\ **Replies:** 5\ **Last updated:** [December 31, 2019, 12:03am UTC](https://discuss.elastic.co/t/cluster-rebalancing-across-azs/210946 "2019-12-31T00:03:40Z")
We have a cluster with 6 warm data nodes per AZ in EC2, for a total of 18 nodes spread in 3 AZs. As they were getting full, we added 1 more node to each AZ, and enabled auto-balancing in the cluster. I expected some of… --- ## [Delete Elasticsearch Index Using Java Spring](https://discuss.elastic.co/t/delete-elasticsearch-index-using-java-spring/213383)
**Author:** [@Saif\_Ur\_Rehman](https://discuss.elastic.co/u/Saif_Ur_Rehman)\ **Replies:** 0\ **Last updated:** [December 30, 2019, 9:30pm UTC](https://discuss.elastic.co/t/delete-elasticsearch-index-using-java-spring/213383 "2019-12-30T21:30:52Z")
Hello. I am new to ELK and docker. I want to create a java spring application which i can integrate it with docker and ELK and through which, i can only delete the index of the Elasticsearch shown in kibana. I need help … --- ## [Proper locations for ansible-elasticsearch variables](https://discuss.elastic.co/t/proper-locations-for-ansible-elasticsearch-variables/213385)
**Author:** [@RLPowellJr](https://discuss.elastic.co/u/RLPowellJr)\ **Replies:** 1\ **Last updated:** [December 30, 2019, 10:13pm UTC](https://discuss.elastic.co/t/proper-locations-for-ansible-elasticsearch-variables/213385 "2019-12-30T22:13:03Z")
Greetings once again! When working with the ansible-elasticsearch playbook (from https://github.com/elastic/ansible-elasticsearch), is it acceptable for all of the Ansible variables to be defined in the same file? I’m … --- ## [Role API Usage ECE 2.4.3](https://discuss.elastic.co/t/role-api-usage-ece-2-4-3/213230)
**Author:** [@balogan](https://discuss.elastic.co/u/balogan)\ **Replies:** 2\ **Last updated:** [December 30, 2019, 8:22pm UTC](https://discuss.elastic.co/t/role-api-usage-ece-2-4-3/213230 "2019-12-30T20:22:51Z")
I'm having trouble using the API examples for ECE when viewing/creating roles found in this link https://www.elastic.co/guide/en/elasticsearch/reference/7.5/security-api-get-role.html To display all roles this should be… --- ## [ML Data visualizer](https://discuss.elastic.co/t/ml-data-visualizer/212961)
**Author:** [@mbee](https://discuss.elastic.co/u/mbee)\ **Replies:** 7\ **Last updated:** [December 30, 2019, 6:50pm UTC](https://discuss.elastic.co/t/ml-data-visualizer/212961 "2019-12-30T18:50:06Z")
Hello, I'm trying to upload a csv file using "Machine Learning" -\> "data visualizer" (a couple of octets for the size) so i selected my file. The issue is the upload task remains loading and showing the message : "Ana… --- ## [Rollover index based on index name](https://discuss.elastic.co/t/rollover-index-based-on-index-name/210210)
**Author:** [@victor.nilsson](https://discuss.elastic.co/u/victor.nilsson)\ **Replies:** 1\ **Last updated:** [December 2, 2019, 5:30pm UTC](https://discuss.elastic.co/t/rollover-index-based-on-index-name/210210 "2019-12-02T17:30:42Z")
Hi, We're creating weekly indices and want to rollover whenever there is a new week, using Curator. However, we see the only "age" based option is 'max\_age' which is not exactly what we want to do. If we set the max\_a… --- ## [How to update the column in a elasticsearch database using sql query](https://discuss.elastic.co/t/how-to-update-the-column-in-a-elasticsearch-database-using-sql-query/212889)
**Author:** [@Sreekanth3](https://discuss.elastic.co/u/Sreekanth3)\ **Replies:** 4\ **Last updated:** [December 30, 2019, 4:11pm UTC](https://discuss.elastic.co/t/how-to-update-the-column-in-a-elasticsearch-database-using-sql-query/212889 "2019-12-30T16:11:14Z")
Hi All, Can we update a column in a elasticsearch database using sql query. I have used this query 'UPDATE from duration\_17 SET delay\_sec = '12.20' WHERE dest\_ip=192.168.1.181;' but got this error Bad request \[line… --- ## [Elastic Migration from 1.x to 6.8](https://discuss.elastic.co/t/elastic-migration-from-1-x-to-6-8/213143)
**Author:** [@Nirmal\_Palani](https://discuss.elastic.co/u/Nirmal_Palani)\ **Replies:** 2\ **Last updated:** [December 30, 2019, 2:40pm UTC](https://discuss.elastic.co/t/elastic-migration-from-1-x-to-6-8/213143 "2019-12-30T14:40:44Z")
In our existing project which uses Elastic Migration 1.x version, we use nested parent child relation between different types in a single index and we did use has\_child and has\_parent in conjunction to fetch the data in … --- ## [Cross search with 2 indexes](https://discuss.elastic.co/t/cross-search-with-2-indexes/213349)
**Author:** [@Seb\_Coyote](https://discuss.elastic.co/u/Seb_Coyote)\ **Replies:** 3\ **Last updated:** [December 30, 2019, 2:25pm UTC](https://discuss.elastic.co/t/cross-search-with-2-indexes/213349 "2019-12-30T14:25:24Z")
Hi All, I have elasticsearch with 2 indexes and Kibana. (import from CSV) The first index contain data for different machines like IP address (type:IP). The second index contain CIDR and Network name We want to visua… --- ## [How to allocate node to index shards](https://discuss.elastic.co/t/how-to-allocate-node-to-index-shards/213330)
**Author:** [@adityaPsl](https://discuss.elastic.co/u/adityaPsl)\ **Replies:** 3\ **Last updated:** [December 30, 2019, 1:42pm UTC](https://discuss.elastic.co/t/how-to-allocate-node-to-index-shards/213330 "2019-12-30T13:42:15Z")
Hello Team, Can we allocate particular node and to an index so all the shards created for that index would get created to the defined node. I read about reroute API but could not find allocation option. can we define t… --- ## [Cannot apply multiply \[\*\] to types \[java.lang.Number\] and \[java.lang.Number\]](https://discuss.elastic.co/t/cannot-apply-multiply-to-types-java-lang-number-and-java-lang-number/213333)
**Author:** [@sidgate](https://discuss.elastic.co/u/sidgate)\ **Replies:** 1\ **Last updated:** [December 30, 2019, 12:08pm UTC](https://discuss.elastic.co/t/cannot-apply-multiply-to-types-java-lang-number-and-java-lang-number/213333 "2019-12-30T12:08:23Z")
I am migrating from Elasticsearch version 5.2.1 to latest 7.5.1. My query had special sub-aggregation where I used to multiple score "aggregations": { "max\_score": { "sum": { … --- ## [How to add node in Elastic search cluster](https://discuss.elastic.co/t/how-to-add-node-in-elastic-search-cluster/213311)
**Author:** [@krushnakantB](https://discuss.elastic.co/u/krushnakantB)\ **Replies:** 1\ **Last updated:** [December 30, 2019, 9:46am UTC](https://discuss.elastic.co/t/how-to-add-node-in-elastic-search-cluster/213311 "2019-12-30T09:46:25Z")
Hi All, I am using Elasticsearch 7.2.0 as a stand-alone machine. Now I have a requirement to make it as a cluster. How could I perform the same? To do the same I've perform below steps, but It doesn't work for me. Step… --- ## [Docker.elastic.co error](https://discuss.elastic.co/t/docker-elastic-co-error/213204)
**Author:** [@edwardsmit](https://discuss.elastic.co/u/edwardsmit)\ **Replies:** 4\ **Last updated:** [December 30, 2019, 9:33am UTC](https://discuss.elastic.co/t/docker-elastic-co-error/213204 "2019-12-30T09:33:54Z")
I get error messages from docker.elastic.co "503 Service Unavailable: Back-end server is at capacity" does anybody know who should be notified to get this resolved? Trying docker pull docker.elastic.co/elasticsearch/ela… --- ## [Enable security by setting \[xpack.security.enabled\] to \[true\] in the elasticsearch.yml file and restart the node.: Check the Elasticsearch Monitoring cluster network connection or the load level of the nodes](https://discuss.elastic.co/t/enable-security-by-setting-xpack-security-enabled-to-true-in-the-elasticsearch-yml-file-and-restart-the-node-check-the-elasticsearch-monitoring-cluster-network-connection-or-the-load-level-of-the-nodes/213316)
**Author:** [@Has\_Cape](https://discuss.elastic.co/u/Has_Cape)\ **Replies:** 0\ **Last updated:** [December 30, 2019, 7:16am UTC](https://discuss.elastic.co/t/enable-security-by-setting-xpack-security-enabled-to-true-in-the-elasticsearch-yml-file-and-restart-the-node-check-the-elasticsearch-monitoring-cluster-network-connection-or-the-load-level-of-the-nodes/213316 "2019-12-30T07:16:30Z")
Hello; How can I edit and apply elasticsearch.yaml file of a running ElasticSearch on Kubernetes? --- ## [NoSuchFileException of the "translog.ckp" file](https://discuss.elastic.co/t/nosuchfileexception-of-the-translog-ckp-file/212802)
**Author:** [@weiwei107](https://discuss.elastic.co/u/weiwei107)\ **Replies:** 14\ **Last updated:** [December 30, 2019, 6:56am UTC](https://discuss.elastic.co/t/nosuchfileexception-of-the-translog-ckp-file/212802 "2019-12-30T06:56:26Z")
I wrote a post several days before: https://discuss.elastic.co/t/help-all-shards-failed-regularly/211045. The problem still exists after I tried the methods mentioned in the replies. Can anyone help us solve this weird … --- ## [About "IndexNotFoundException" after replica set](https://discuss.elastic.co/t/about-indexnotfoundexception-after-replica-set/213303)
**Author:** [@Hyunsoo\_Shim](https://discuss.elastic.co/u/Hyunsoo_Shim)\ **Replies:** 1\ **Last updated:** [December 30, 2019, 6:24am UTC](https://discuss.elastic.co/t/about-indexnotfoundexception-after-replica-set/213303 "2019-12-30T06:24:52Z")
\[System Info\] instance : 6ea (node : 6ea) cpu : 16core ram : 64GB jvm heap : 16GB We have created one index and done full indexing like the below steps. \[Steps\] create index (refresh interval : -1, replica : 0) fu… --- ## [Elasticsearch index folder contains corrupted file](https://discuss.elastic.co/t/elasticsearch-index-folder-contains-corrupted-file/213309)
**Author:** [@dbakti7](https://discuss.elastic.co/u/dbakti7)\ **Replies:** 2\ **Last updated:** [December 30, 2019, 6:20am UTC](https://discuss.elastic.co/t/elasticsearch-index-folder-contains-corrupted-file/213309 "2019-12-30T06:20:03Z")
Recently we found out that some of our indexes are unable to get shards allocated (cluster state remains in Red state as the consequence). When we check the index files, we found a file named "corrupted\_SWN5k349Qx2lZY1f… --- ## [Date time error](https://discuss.elastic.co/t/date-time-error/213141)
**Author:** [@ashley11](https://discuss.elastic.co/u/ashley11)\ **Replies:** 3\ **Last updated:** [December 30, 2019, 6:17am UTC](https://discuss.elastic.co/t/date-time-error/213141 "2019-12-30T06:17:47Z")
Hi, I'm new to kibana. I did some visualizations too. But I'm facing below issue, my date time in json is but in kibana it is showing some different time like, can you pls help me out my time zone is India Stan… --- ## [Multinode cluster for elastic search](https://discuss.elastic.co/t/multinode-cluster-for-elastic-search/213187)
**Author:** [@abhishek1989](https://discuss.elastic.co/u/abhishek1989)\ **Replies:** 4\ **Last updated:** [December 30, 2019, 6:03am UTC](https://discuss.elastic.co/t/multinode-cluster-for-elastic-search/213187 "2019-12-30T06:03:39Z")
Hi , I have java application and i am using elastic search as data storage so previously i had HA configuration like one master node and two data nodes so in this case its like single point failure if master node is dow… --- ## [3 GB Shapefiles of the whole Earth. Can ES display this?](https://discuss.elastic.co/t/3-gb-shapefiles-of-the-whole-earth-can-es-display-this/213310)
**Author:** [@Paul\_Spedding](https://discuss.elastic.co/u/Paul_Spedding)\ **Replies:** 0\ **Last updated:** [December 30, 2019, 4:44am UTC](https://discuss.elastic.co/t/3-gb-shapefiles-of-the-whole-earth-can-es-display-this/213310 "2019-12-30T04:44:04Z")
So, I haven't used this shapefile yet as I was wondering if anyone else has attempted what I'm about to do. I'm on i57200 laptop with 32GB of RAM so I assume I have enough? What I was confused about is if I try to print… --- ## [Python: ES.cluster.health() returns a Failed to establish a new connection: \[Errno 11001\] getaddrinfo failed) everytime I run](https://discuss.elastic.co/t/python-es-cluster-health-returns-a-failed-to-establish-a-new-connection-errno-11001-getaddrinfo-failed-everytime-i-run/211850)
**Author:** [@Paul\_Spedding](https://discuss.elastic.co/u/Paul_Spedding)\ **Replies:** 2\ **Last updated:** [December 30, 2019, 4:36am UTC](https://discuss.elastic.co/t/python-es-cluster-health-returns-a-failed-to-establish-a-new-connection-errno-11001-getaddrinfo-failed-everytime-i-run/211850 "2019-12-30T04:36:42Z")
So I have the following code: self.es.cluster.health(wait\_for\_status='yellow', request\_timeout=1) It was running originally but for some reason it stoped and I can't work out why, but no matter if I restart the server … --- ## [The count of segments in nodes stats api and segment api](https://discuss.elastic.co/t/the-count-of-segments-in-nodes-stats-api-and-segment-api/213306)
**Author:** [@jinhaowen](https://discuss.elastic.co/u/jinhaowen)\ **Replies:** 0\ **Last updated:** [December 30, 2019, 3:35am UTC](https://discuss.elastic.co/t/the-count-of-segments-in-nodes-stats-api-and-segment-api/213306 "2019-12-30T03:35:30Z")
Hi, I had run the nodes stats api(\_nodes/stats) and get the count of segments of one node is 85, which is in nodes.indices.segments.count of response body. However when I run segments api(\_cat/segments) and filt by the i… --- ## [Configuring AD realm to authenticate to Elastic Search](https://discuss.elastic.co/t/configuring-ad-realm-to-authenticate-to-elastic-search/213218)
**Author:** [@rambaliga](https://discuss.elastic.co/u/rambaliga)\ **Replies:** 1\ **Last updated:** [December 29, 2019, 11:52pm UTC](https://discuss.elastic.co/t/configuring-ad-realm-to-authenticate-to-elastic-search/213218 "2019-12-29T23:52:24Z")
Hi, I am trying to configure AD realm inorder to authenticate to Elastic search ( version 6.6.1). My elasticsearch.yml and role\_mapping.yml looks like below. elasticsearch.yml: Xpack: security: authc: realms… --- ## [Addition of new elasticsearch nodes and security (SSL / TLS / HTTPS configuration)](https://discuss.elastic.co/t/addition-of-new-elasticsearch-nodes-and-security-ssl-tls-https-configuration/213285)
**Author:** [@Rysiu](https://discuss.elastic.co/u/Rysiu)\ **Replies:** 1\ **Last updated:** [December 29, 2019, 11:39pm UTC](https://discuss.elastic.co/t/addition-of-new-elasticsearch-nodes-and-security-ssl-tls-https-configuration/213285 "2019-12-29T23:39:13Z")
I have a question about configuring additional new Elasticsearch nodes (SSL / TLS / HTTPS issue) and adding them to an existing cluster. Earlier I secured the cluster according to the description: Is it enough to cr… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1055) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1057)