# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1456 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1457 --- ## [Cleaning up Indexes in cluster stuck in bad state](https://discuss.elastic.co/t/cleaning-up-indexes-in-cluster-stuck-in-bad-state/160396)
**Author:** [@TarunRamsinghani](https://discuss.elastic.co/u/TarunRamsinghani)\ **Replies:** 0\ **Last updated:** [December 11, 2018, 2:34pm UTC](https://discuss.elastic.co/t/cleaning-up-indexes-in-cluster-stuck-in-bad-state/160396 "2018-12-11T14:34:16Z")
Hi, We have cluster where due to provisioning bug we ended up creating large number of indexes with 100 shards each. The cluster is 48 data nodes, with shard count now at 120,000. At this state we are not able to delet… --- ## [RDBMS vs ES for list data](https://discuss.elastic.co/t/rdbms-vs-es-for-list-data/160385)
**Author:** [@PandKing](https://discuss.elastic.co/u/PandKing)\ **Replies:** 1\ **Last updated:** [December 11, 2018, 1:43pm UTC](https://discuss.elastic.co/t/rdbms-vs-es-for-list-data/160385 "2018-12-11T13:43:37Z")
Hi, I need to audit a list of billions of filenames from 2 sources that "should" have the same number and filenames. I originally thought of elastic but I'm beginning to think this job would be better suited for an RDB… --- ## [How to set boost using constant score](https://discuss.elastic.co/t/how-to-set-boost-using-constant-score/160258)
**Author:** [@CrinaGrigore](https://discuss.elastic.co/u/CrinaGrigore)\ **Replies:** 2\ **Last updated:** [December 11, 2018, 7:54am UTC](https://discuss.elastic.co/t/how-to-set-boost-using-constant-score/160258 "2018-12-11T07:54:45Z")
Hi, I have the ES info structured as below: One example: "\_index": "content-media", "\_type": "default", "\_id": "335", "\_score": 1.0, "\_source": { "id": 335, "type": "ALBUM", "title": "Brighter Wounds", "descri… --- ## [Oracle Java JRE/JDK SE Support](https://discuss.elastic.co/t/oracle-java-jre-jdk-se-support/160360)
**Author:** [@PolterFox](https://discuss.elastic.co/u/PolterFox)\ **Replies:** 1\ **Last updated:** [December 11, 2018, 1:16pm UTC](https://discuss.elastic.co/t/oracle-java-jre-jdk-se-support/160360 "2018-12-11T13:16:55Z")
Hello everybody, From 2019, Oracle will change there support for the releases (lower then JAVA SE 11). So is there a support (without X-Pack) that will secure the support down under JAVA SE 11 with the ELK-Stack? Are t… --- ## [Elasticsearch Docker internal indexes](https://discuss.elastic.co/t/elasticsearch-docker-internal-indexes/160368)
**Author:** [@s0r1n](https://discuss.elastic.co/u/s0r1n)\ **Replies:** 2\ **Last updated:** [December 11, 2018, 12:56pm UTC](https://discuss.elastic.co/t/elasticsearch-docker-internal-indexes/160368 "2018-12-11T12:56:30Z")
The Elasticsearch Docker container (https://hub.docker.com/\_/elasticsearch/) generates specific indexes like: .watches .triggered\_watches .monitoring-alerts-6 .watcher-history-6-\[date\] ( .watcher-history-6-2018.12.1… --- ## [Curator Restore action failure](https://discuss.elastic.co/t/curator-restore-action-failure/160188)
**Author:** [@rshetty](https://discuss.elastic.co/u/rshetty)\ **Replies:** 3\ **Last updated:** [December 11, 2018, 12:48pm UTC](https://discuss.elastic.co/t/curator-restore-action-failure/160188 "2018-12-11T12:48:24Z")
Hi, I have been using the Curator for restoring an entire cluster's data to a backup cluster. Below is the action file: actions: 1: action: close description: "Close indices before restoring snapshot" op… --- ## [Elasticsearch 6.4.1 index size reduce](https://discuss.elastic.co/t/elasticsearch-6-4-1-index-size-reduce/160332)
**Author:** [@byldozer](https://discuss.elastic.co/u/byldozer)\ **Replies:** 3\ **Last updated:** [December 11, 2018, 12:44pm UTC](https://discuss.elastic.co/t/elasticsearch-6-4-1-index-size-reduce/160332 "2018-12-11T12:44:52Z")
Hi Everyone, got a problem with index size reducing and data optimization. Problems for now: by default all text fields duplicated with fieldname and fieldname.keyword. How I can leave just fieldname ? without fie… --- ## [Prevent Elasticsearch go to a "stuck" state after heavy requests in Kibana](https://discuss.elastic.co/t/prevent-elasticsearch-go-to-a-stuck-state-after-heavy-requests-in-kibana/160343)
**Author:** [@Merclangrat](https://discuss.elastic.co/u/Merclangrat)\ **Replies:** 0\ **Last updated:** [December 11, 2018, 10:13am UTC](https://discuss.elastic.co/t/prevent-elasticsearch-go-to-a-stuck-state-after-heavy-requests-in-kibana/160343 "2018-12-11T10:13:59Z")
We use Elasticsearch and Kibana and have quite a lot of data (~1TB). Sometimes our users send very heavy request using Kibana (search/aggregations through 500GB of data) and Elasticsearch stops working at all. Only rest… --- ## [Does updating the synonyms list always need to have the complete list](https://discuss.elastic.co/t/does-updating-the-synonyms-list-always-need-to-have-the-complete-list/160149)
**Author:** [@mags107](https://discuss.elastic.co/u/mags107)\ **Replies:** 2\ **Last updated:** [December 11, 2018, 10:07am UTC](https://discuss.elastic.co/t/does-updating-the-synonyms-list-always-need-to-have-the-complete-list/160149 "2018-12-11T10:07:31Z")
We are working on a new ES project and need to be able to change the synonyms dynamically. For various reasons in our first instance we are not using a file. If we need to change the list do we always have to update th… --- ## [Testing error handlers in elasticsearch 6.5 (kafka to ES)](https://discuss.elastic.co/t/testing-error-handlers-in-elasticsearch-6-5-kafka-to-es/160340)
**Author:** [@anon17386273](https://discuss.elastic.co/u/anon17386273)\ **Replies:** 0\ **Last updated:** [December 11, 2018, 9:59am UTC](https://discuss.elastic.co/t/testing-error-handlers-in-elasticsearch-6-5-kafka-to-es/160340 "2018-12-11T09:59:52Z")
https://www.elastic.co/guide/en/elasticsearch/hadoop/current/errorhandlers.html Does anyone has working example of error handling for elasticsearch? I am exploring the elasticsearch 6.5 where error handlers are provided… --- ## [Elasticsearch cluster discovery.zen.ping.unicast.hosts settings](https://discuss.elastic.co/t/elasticsearch-cluster-discovery-zen-ping-unicast-hosts-settings/160328)
**Author:** [@supermario](https://discuss.elastic.co/u/supermario)\ **Replies:** 1\ **Last updated:** [December 11, 2018, 9:59am UTC](https://discuss.elastic.co/t/elasticsearch-cluster-discovery-zen-ping-unicast-hosts-settings/160328 "2018-12-11T09:59:04Z")
I have two es node,set discovery.zen.ping.unicast.hosts: \["192.168.117.1","192.168.117.2"\]. I set '192.168.117.1' xpack.security.enabled: true xpack.security.transport.ssl.enabled: true And change password. when i s… --- ## [Elasticsearch Nest Bulk Delete in C#](https://discuss.elastic.co/t/elasticsearch-nest-bulk-delete-in-c/160262)
**Author:** [@surajbs](https://discuss.elastic.co/u/surajbs)\ **Replies:** 1\ **Last updated:** [December 11, 2018, 9:57am UTC](https://discuss.elastic.co/t/elasticsearch-nest-bulk-delete-in-c/160262 "2018-12-11T09:57:49Z")
How can we do bulk delete comparing two (2) indexes/indices in C# ? --- ## [NEST/C#: Binary operation on \*QueryDescriptor\](https://discuss.elastic.co/t/nest-c-binary-operation-on-querydescriptor-t/160206)
**Author:** [@redX](https://discuss.elastic.co/u/redX)\ **Replies:** 1\ **Last updated:** [December 11, 2018, 9:23am UTC](https://discuss.elastic.co/t/nest-c-binary-operation-on-querydescriptor-t/160206 "2018-12-11T09:23:18Z")
I am creating dynamic ES query with NEST like this: var q1 = new MatchQuery() { Field = "similarto.keyword", Query = "55445" }; var q2 = new MatchQuery() { Field = "metatag.keyword", Query = "hot" }; var q3 = q1 || q2; … --- ## [Creation of indexes fail with a 404 because a PUT happens \_too soon\_ #36336](https://discuss.elastic.co/t/creation-of-indexes-fail-with-a-404-because-a-put-happens-too-soon-36336/160020)
**Author:** [@AlexisWilke](https://discuss.elastic.co/u/AlexisWilke)\ **Replies:** 8\ **Last updated:** [December 11, 2018, 7:39am UTC](https://discuss.elastic.co/t/creation-of-indexes-fail-with-a-404-because-a-put-happens-too-soon-36336/160020 "2018-12-11T07:39:18Z")
I have problems creating indexes using express-cassandra. It runs the CREATE INDEX alright, however, it then tries to add the mapping with a second PUT and that fails with a 404, saying that the index doesn't exist (yet)… --- ## [Start Elasticsearch in a Java process](https://discuss.elastic.co/t/start-elasticsearch-in-a-java-process/160283)
**Author:** [@jun.li](https://discuss.elastic.co/u/jun.li)\ **Replies:** 3\ **Last updated:** [December 11, 2018, 7:28am UTC](https://discuss.elastic.co/t/start-elasticsearch-in-a-java-process/160283 "2018-12-11T07:28:33Z")
Is it possible I can start/stop Elasticsearch within a Java process? The firm has an infra that can quickly manage any Java process start/stop and also monitor log. org.elasticsearch.client.Node node = new Node(...) n… --- ## [Is there some alternative way to load data from database to ES except for logstash jdbc-plugin?](https://discuss.elastic.co/t/is-there-some-alternative-way-to-load-data-from-database-to-es-except-for-logstash-jdbc-plugin/160309)
**Author:** [@groverjatin17](https://discuss.elastic.co/u/groverjatin17)\ **Replies:** 2\ **Last updated:** [December 11, 2018, 7:24am UTC](https://discuss.elastic.co/t/is-there-some-alternative-way-to-load-data-from-database-to-es-except-for-logstash-jdbc-plugin/160309 "2018-12-11T07:24:46Z")
Hi, I recently tried to load data from database to elasticsearch using Logstash jdbc-plugin and it worked perfectly fine. Even the scheduling part. But my team wants a non tech savvy option. where we do not have to wri… --- ## [Elastic Search stack is not working in azure platform](https://discuss.elastic.co/t/elastic-search-stack-is-not-working-in-azure-platform/159105)
**Author:** [@rahul.ranjan](https://discuss.elastic.co/u/rahul.ranjan)\ **Replies:** 12\ **Last updated:** [December 11, 2018, 7:09am UTC](https://discuss.elastic.co/t/elastic-search-stack-is-not-working-in-azure-platform/159105 "2018-12-11T07:09:59Z")
Elastic Search stack is not working in azure platform. --- ## [Is it possible to create term search from URI?](https://discuss.elastic.co/t/is-it-possible-to-create-term-search-from-uri/160280)
**Author:** [@okproject](https://discuss.elastic.co/u/okproject)\ **Replies:** 1\ **Last updated:** [December 11, 2018, 7:09am UTC](https://discuss.elastic.co/t/is-it-possible-to-create-term-search-from-uri/160280 "2018-12-11T07:09:37Z")
Hi. I know the term search faster than full text search. So i can create a full text search query like this : http://myserver:9200/myindex/\_doc/\_search/?\_source=false&request\_cache=true&q=kategori\_Id=12 But kategori\_… --- ## [Snapshot not Working](https://discuss.elastic.co/t/snapshot-not-working/160305)
**Author:** [@amit.patra](https://discuss.elastic.co/u/amit.patra)\ **Replies:** 4\ **Last updated:** [December 11, 2018, 7:07am UTC](https://discuss.elastic.co/t/snapshot-not-working/160305 "2018-12-11T07:07:24Z")
Hi @Christian\_Dahlqvist, Is there any elasticsearch document available for creating a shared file system for snapshot configuration. Please help me. Awaiting for your valuable response. Thanks, --- ## [Advice on cluster configuration](https://discuss.elastic.co/t/advice-on-cluster-configuration/159813)
**Author:** [@rpm1984](https://discuss.elastic.co/u/rpm1984)\ **Replies:** 9\ **Last updated:** [December 11, 2018, 6:18am UTC](https://discuss.elastic.co/t/advice-on-cluster-configuration/159813 "2018-12-11T06:18:36Z")
Hi there. I'm sure you've heard this question a million times, so apologies :slight\_smile: I've been reading day and night about indexes, shards, nodes, custom routing, ES metrics to monitor, etc. I'm still a bit stumpe… --- ## [Elasticsearch: changing bm25 params for more relevant documents](https://discuss.elastic.co/t/elasticsearch-changing-bm25-params-for-more-relevant-documents/160295)
**Author:** [@rahulnama](https://discuss.elastic.co/u/rahulnama)\ **Replies:** 0\ **Last updated:** [December 11, 2018, 6:15am UTC](https://discuss.elastic.co/t/elasticsearch-changing-bm25-params-for-more-relevant-documents/160295 "2018-12-11T06:15:29Z")
Hi team I've indexed few pdf files. And as you know elasticsearch uses bm25 by default. Lets suppose I have indexed 2 pdf files one regarding windows issues and the other file is linux issues. Now when I search for "Wi… --- ## [How to restrict timestamp field in multi layer JSON where field with same name but different data types are present in second layer of JSON](https://discuss.elastic.co/t/how-to-restrict-timestamp-field-in-multi-layer-json-where-field-with-same-name-but-different-data-types-are-present-in-second-layer-of-json/158878)
**Author:** [@sshekher](https://discuss.elastic.co/u/sshekher)\ **Replies:** 1\ **Last updated:** [December 11, 2018, 6:01am UTC](https://discuss.elastic.co/t/how-to-restrict-timestamp-field-in-multi-layer-json-where-field-with-same-name-but-different-data-types-are-present-in-second-layer-of-json/158878 "2018-12-11T06:01:31Z")
In my dynamic template I am adding field with name "timestamp" as of date type. It is later converted to epoch. now in a particular case there is one more field with name "timestamp" in second layer of multi layer JSON, … --- ## [Stored Procedure](https://discuss.elastic.co/t/stored-procedure/158519)
**Author:** [@Raghunadhan](https://discuss.elastic.co/u/Raghunadhan)\ **Replies:** 9\ **Last updated:** [December 11, 2018, 5:35am UTC](https://discuss.elastic.co/t/stored-procedure/158519 "2018-12-11T05:35:52Z")
I want to stored procedure in elastic search as in sql For example in sql stored procedure contains insert operations conditions insert operations based on conditions(like if condition). Example of Stored Procedure … --- ## [Merge policy and segments count](https://discuss.elastic.co/t/merge-policy-and-segments-count/159927)
**Author:** [@raulk89](https://discuss.elastic.co/u/raulk89)\ **Replies:** 7\ **Last updated:** [December 11, 2018, 5:57am UTC](https://discuss.elastic.co/t/merge-policy-and-segments-count/159927 "2018-12-11T05:57:41Z")
Hi Setting up 6.5.x cluster. So I need to index few million docs for this. I have disabled index refresh during initial indexing. All indices have 5 shards. Question: If doing inital indexing, without refresh, are the… --- ## [How to enable the security option on kibana under management](https://discuss.elastic.co/t/how-to-enable-the-security-option-on-kibana-under-management/159750)
**Author:** [@karthick\_tgi](https://discuss.elastic.co/u/karthick_tgi)\ **Replies:** 7\ **Last updated:** [December 11, 2018, 5:47am UTC](https://discuss.elastic.co/t/how-to-enable-the-security-option-on-kibana-under-management/159750 "2018-12-11T05:47:48Z")
Hi Team, I am using version details as ., ElasticSearch - 6.4.2 and Kibana - 6.4.2 Unable to see the security option on kibana under management which allows us to create users and roles How is possible to enable such … --- ## [Java Client encrypted communication Doc bug](https://discuss.elastic.co/t/java-client-encrypted-communication-doc-bug/160244)
**Author:** [@asidoren](https://discuss.elastic.co/u/asidoren)\ **Replies:** 2\ **Last updated:** [December 11, 2018, 5:37am UTC](https://discuss.elastic.co/t/java-client-encrypted-communication-doc-bug/160244 "2018-12-11T05:37:18Z")
The Encrypted communication example in Java REST Client section is completely wrong. The original ref: https://www.elastic.co/guide/en/elasticsearch/client/java-rest/current/\_encrypted\_communication.html Here is what … --- ## ["Existing column \[id\] type \[uuid\] mismatch with inferred type \[list\\]" -- Is that fixable?](https://discuss.elastic.co/t/existing-column-id-type-uuid-mismatch-with-inferred-type-list-text-is-that-fixable/160279)
**Author:** [@AlexisWilke](https://discuss.elastic.co/u/AlexisWilke)\ **Replies:** 1\ **Last updated:** [December 11, 2018, 3:40am UTC](https://discuss.elastic.co/t/existing-column-id-type-uuid-mismatch-with-inferred-type-list-text-is-that-fixable/160279 "2018-12-11T03:40:23Z")
I'm trying to create an Elasticsearch join between two tables using a UUID field. My main table looks something like this: CREATE TABLE main\_table ( id UUID PRIMARY KEY, ...other fields... ); The child table i… --- ## [Forgot to load new beats index template after upgrading Elastic Stack. Now I have double the number of fields](https://discuss.elastic.co/t/forgot-to-load-new-beats-index-template-after-upgrading-elastic-stack-now-i-have-double-the-number-of-fields/160277)
**Author:** [@popa](https://discuss.elastic.co/u/popa)\ **Replies:** 0\ **Last updated:** [December 11, 2018, 2:58am UTC](https://discuss.elastic.co/t/forgot-to-load-new-beats-index-template-after-upgrading-elastic-stack-now-i-have-double-the-number-of-fields/160277 "2018-12-11T02:58:47Z")
As the title goes, I wasn't aware that I was supposed to load in the "new" index template each time I upgrade the Elastic Stack. A normal amount of fields for winlogbeat in my environment was around 300-400 fields. Now … --- ## [Elastic Search Filter](https://discuss.elastic.co/t/elastic-search-filter/160234)
**Author:** [@anveshdd](https://discuss.elastic.co/u/anveshdd)\ **Replies:** 1\ **Last updated:** [December 11, 2018, 2:57am UTC](https://discuss.elastic.co/t/elastic-search-filter/160234 "2018-12-11T02:57:19Z")
Working on Elastic Search 6.5.x. I indexed the documents into ES index via external web crawler. Below is my Index. I want to get the records based on the filter. If I use the below query, Suppose if I use term query by h… --- ## [Regex query with ~ not working as expected](https://discuss.elastic.co/t/regex-query-with-not-working-as-expected/160273)
**Author:** [@sailorfina](https://discuss.elastic.co/u/sailorfina)\ **Replies:** 0\ **Last updated:** [December 11, 2018, 2:09am UTC](https://discuss.elastic.co/t/regex-query-with-not-working-as-expected/160273 "2018-12-11T02:09:36Z")
Hi, I have a keyword field, and the value is email address like: "21fd4444d3b0$28c042c9$ca123123$@abc.com" when I do prefix query, I can get the result: { "size": 10, "query": { "prefix": { "myfiel… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1455) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1457)