# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1178 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1179 --- ## [How to fetch all data from multiple index in single query through spring boot](https://discuss.elastic.co/t/how-to-fetch-all-data-from-multiple-index-in-single-query-through-spring-boot/196897)
**Author:** [@vishallodha84](https://discuss.elastic.co/u/vishallodha84)\ **Replies:** 3\ **Last updated:** [August 27, 2019, 11:52am UTC](https://discuss.elastic.co/t/how-to-fetch-all-data-from-multiple-index-in-single-query-through-spring-boot/196897 "2019-08-27T11:52:45Z")
Hi All, I have multiple indexes like store, sku, listing i want to search content in single query if any data match then get the response. I tried to check simple output from 2 indexes but its not showing simple query … --- ## [How to convert to JSON Query using Java HighlevelRestClient](https://discuss.elastic.co/t/how-to-convert-to-json-query-using-java-highlevelrestclient/196529)
**Author:** [@Sammeta\_David\_Raju](https://discuss.elastic.co/u/Sammeta_David_Raju)\ **Replies:** 8\ **Last updated:** [August 27, 2019, 9:41am UTC](https://discuss.elastic.co/t/how-to-convert-to-json-query-using-java-highlevelrestclient/196529 "2019-08-27T09:41:19Z")
ocalhost:9200/my\_index/\_mapping/doc { "properties": { "my\_field": { "type": "text", "fielddata": true } } } How to convert this to java API using HighLevelRestClient highlevelRestClient.se… --- ## [How to query array of keywords in elastic search filter with space?](https://discuss.elastic.co/t/how-to-query-array-of-keywords-in-elastic-search-filter-with-space/196894)
**Author:** [@kavaan](https://discuss.elastic.co/u/kavaan)\ **Replies:** 2\ **Last updated:** [August 27, 2019, 8:15am UTC](https://discuss.elastic.co/t/how-to-query-array-of-keywords-in-elastic-search-filter-with-space/196894 "2019-08-27T08:15:33Z")
I have a list of cities like this: \["New York","Bayern Munchen","Porto Alegre"\] I want to search some query in must or should section and use this cities keywords in filter section, but this cities have white space and… --- ## [JVM HEAP usage over 85% during snapshots](https://discuss.elastic.co/t/jvm-heap-usage-over-85-during-snapshots/194568)
**Author:** [@cyril.r](https://discuss.elastic.co/u/cyril.r)\ **Replies:** 4\ **Last updated:** [August 27, 2019, 7:28am UTC](https://discuss.elastic.co/t/jvm-heap-usage-over-85-during-snapshots/194568 "2019-08-27T07:28:00Z")
Hello :slight\_smile: I have an issue with elasticsearch and HEAP usage during snapshots. My cluster have 7 nodes (2cpu & 7.5G of RAM per node, local SSD storage), about 220 millions of documents for a total size of 377… --- ## [Loadbalancing with nginx not effective working](https://discuss.elastic.co/t/loadbalancing-with-nginx-not-effective-working/196889)
**Author:** [@khergner](https://discuss.elastic.co/u/khergner)\ **Replies:** 0\ **Last updated:** [August 27, 2019, 7:08am UTC](https://discuss.elastic.co/t/loadbalancing-with-nginx-not-effective-working/196889 "2019-08-27T07:08:48Z")
Hi, I want to use F5 load balance because ı have 2 nodes ı get the following error at nginx 2019/08/27 09:56:20 \[error\] 13388#11836: \*529 no live upstreams while connecting to upstream, client: 127.0.0.1, server: , r… --- ## [Voting Only Node](https://discuss.elastic.co/t/voting-only-node/196883)
**Author:** [@Prafull](https://discuss.elastic.co/u/Prafull)\ **Replies:** 1\ **Last updated:** [August 27, 2019, 6:57am UTC](https://discuss.elastic.co/t/voting-only-node/196883 "2019-08-27T06:57:43Z")
Hi, I am trying to create voting only node along with 2 master eligible node via docker. I am able to create master node but not able to create a voting only node. getting below error. Also, find docker-compose.yml bel… --- ## [Sync up with Oracle data with elastic search using jdbc input plugin](https://discuss.elastic.co/t/sync-up-with-oracle-data-with-elastic-search-using-jdbc-input-plugin/196869)
**Author:** [@shan\_usa](https://discuss.elastic.co/u/shan_usa)\ **Replies:** 2\ **Last updated:** [August 27, 2019, 6:48am UTC](https://discuss.elastic.co/t/sync-up-with-oracle-data-with-elastic-search-using-jdbc-input-plugin/196869 "2019-08-27T06:48:27Z")
Hi , I am using elastic search 7.2 and jdk1.8 . I want to sync up with my oracle data with elastic search and want to use JDBC input plugin . I don't want to use logstash for sync up. can i use jdbc input plugin alo… --- ## [Phrase Cloud](https://discuss.elastic.co/t/phrase-cloud/196702)
**Author:** [@danelowe](https://discuss.elastic.co/u/danelowe)\ **Replies:** 5\ **Last updated:** [August 27, 2019, 6:31am UTC](https://discuss.elastic.co/t/phrase-cloud/196702 "2019-08-27T06:31:31Z")
I've got an index of product reviews, in ES6.3 (can upgrade if necessary). I'd like to create a 'phrase cloud' of significant phrases found in the reviews. Similar to how it's done on Amazon product reviews I've starte… --- ## [Bitbucket-elastic connection problem](https://discuss.elastic.co/t/bitbucket-elastic-connection-problem/195935)
**Author:** [@konstantin-fch](https://discuss.elastic.co/u/konstantin-fch)\ **Replies:** 2\ **Last updated:** [August 27, 2019, 5:02am UTC](https://discuss.elastic.co/t/bitbucket-elastic-connection-problem/195935 "2019-08-27T05:02:29Z")
Hello, i have a next problem. Bitbucket instance during test displays: INFO \[I/O dispatcher 4\] c.a.b.s.s.t.DefaultElasticsearchConnectionTester Connected to Elasticsearch version 6.5.3 In browser when i go to the el… --- ## [Full text query using match\_phrase\_prefix configuration](https://discuss.elastic.co/t/full-text-query-using-match-phrase-prefix-configuration/196430)
**Author:** [@valentine-dev](https://discuss.elastic.co/u/valentine-dev)\ **Replies:** 3\ **Last updated:** [August 27, 2019, 3:25am UTC](https://discuss.elastic.co/t/full-text-query-using-match-phrase-prefix-configuration/196430 "2019-08-27T03:25:33Z")
I have a string "8102 heather street richmond BC V6Y2R1" in one document to search for. I use match\_phrase\_prefix full text query. I can find it using the following search strings: 8102 heather str 8102 heather stre … --- ## [Data Import Fail: Can't merge a non object mapping](https://discuss.elastic.co/t/data-import-fail-cant-merge-a-non-object-mapping/196545)
**Author:** [@0x00](https://discuss.elastic.co/u/0x00)\ **Replies:** 13\ **Last updated:** [August 27, 2019, 12:51am UTC](https://discuss.elastic.co/t/data-import-fail-cant-merge-a-non-object-mapping/196545 "2019-08-27T00:51:09Z")
First, apologies if this is a simple question, kinda new to this still. Help is greatly appreciated. I am attempting to import zeek/bro logs via the data visualizer and for the most part, most things seem to be going ok… --- ## [Search by max(time) possible?](https://discuss.elastic.co/t/search-by-max-time-possible/196084)
**Author:** [@Avinash\_D\_Silva](https://discuss.elastic.co/u/Avinash_D_Silva)\ **Replies:** 1\ **Last updated:** [August 26, 2019, 11:15pm UTC](https://discuss.elastic.co/t/search-by-max-time-possible/196084 "2019-08-26T23:15:30Z")
if parent(p) with id 1 has two children(c): 1,2 time 111 is the first logs for parent-1 whereas time 114 is the latest log values for parent-1 is there a way to get the latest log values for parent-1, records looks … --- ## [ScrollAll : .Net Framework versus .Net Core](https://discuss.elastic.co/t/scrollall-net-framework-versus-net-core/196847)
**Author:** [@Pascal62](https://discuss.elastic.co/u/Pascal62)\ **Replies:** 0\ **Last updated:** [August 26, 2019, 10:53pm UTC](https://discuss.elastic.co/t/scrollall-net-framework-versus-net-core/196847 "2019-08-26T22:53:35Z")
I have code performing scrolling query that works fine under .Net Framework 7.4.2 but when rebuild under .Net Core and executed in that environment raise an Elastic exception as shown below. Is there any dif… --- ## [Delta (Difference) of Count of each day from previous day](https://discuss.elastic.co/t/delta-difference-of-count-of-each-day-from-previous-day/195520)
**Author:** [@Yash40915](https://discuss.elastic.co/u/Yash40915)\ **Replies:** 1\ **Last updated:** [August 26, 2019, 8:32pm UTC](https://discuss.elastic.co/t/delta-difference-of-count-of-each-day-from-previous-day/195520 "2019-08-26T20:32:19Z")
Hey, I'm trying to find the delta(difference) of count of each day from previous day. Please see the screen shot for details! Annotation%202019-08-16%20114204|690x373 I'm new to ELK stack, any suggestion is welcomed. --- ## [How to keep on x no of recent documents based on field](https://discuss.elastic.co/t/how-to-keep-on-x-no-of-recent-documents-based-on-field/196822)
**Author:** [@saurabh\_baid](https://discuss.elastic.co/u/saurabh_baid)\ **Replies:** 1\ **Last updated:** [August 26, 2019, 8:15pm UTC](https://discuss.elastic.co/t/how-to-keep-on-x-no-of-recent-documents-based-on-field/196822 "2019-08-26T20:15:29Z")
We are trying to evaluate elasticsearch for keeping up our events and very impressed so far. Though there are two issues we need help with We need to only keep X no of events per MAC address and old events should be p… --- ## [Get document and term frequency for a term across all documents](https://discuss.elastic.co/t/get-document-and-term-frequency-for-a-term-across-all-documents/196837)
**Author:** [@peidaqi](https://discuss.elastic.co/u/peidaqi)\ **Replies:** 0\ **Last updated:** [August 26, 2019, 8:00pm UTC](https://discuss.elastic.co/t/get-document-and-term-frequency-for-a-term-across-all-documents/196837 "2019-08-26T20:00:43Z")
Is there a way to get document and term frequency for a given term across all documents? The termvectors API seems only return data for a single/a set of documents. Furthermore, is it possible to get positions and docum… --- ## [Best ES Configuration for my case](https://discuss.elastic.co/t/best-es-configuration-for-my-case/196816)
**Author:** [@Kevin\_Bourne](https://discuss.elastic.co/u/Kevin_Bourne)\ **Replies:** 1\ **Last updated:** [August 26, 2019, 7:13pm UTC](https://discuss.elastic.co/t/best-es-configuration-for-my-case/196816 "2019-08-26T19:13:44Z")
I am attempting to setup an ES Cluster that will store information from Filebeats (log files) and Metricbeats. I wanted to have an Ingest Node, Master Node(s) and Data Node(s). Eventually I would like to add more resourc… --- ## [How to join 2 indexes and the apply Machine LearningX-Pack?](https://discuss.elastic.co/t/how-to-join-2-indexes-and-the-apply-machine-learningx-pack/196786)
**Author:** [@Rosho](https://discuss.elastic.co/u/Rosho)\ **Replies:** 5\ **Last updated:** [August 26, 2019, 7:13pm UTC](https://discuss.elastic.co/t/how-to-join-2-indexes-and-the-apply-machine-learningx-pack/196786 "2019-08-26T19:13:10Z")
Hi I have a list of different indexes (see image). I would like to join 2 of them and then apply the Machine Learning algorithms. I want to join: "humhub-2019.04" with "humhub-2019.05" I thought of saving the search a… --- ## [Exact count and sum of fields](https://discuss.elastic.co/t/exact-count-and-sum-of-fields/196818)
**Author:** [@Wesley\_Acheson](https://discuss.elastic.co/u/Wesley_Acheson)\ **Replies:** 0\ **Last updated:** [August 26, 2019, 5:53pm UTC](https://discuss.elastic.co/t/exact-count-and-sum-of-fields/196818 "2019-08-26T17:53:01Z")
Hi, I want to query elasticsearch on data we have that is broken down into four distinct fields in a query. There is a time dimension a customer, a status and a currency and an amount. effectively what I want to do is… --- ## [Cannot downgrade a node from version \[7.3.0\] to version \[7.2.0\]](https://discuss.elastic.co/t/cannot-downgrade-a-node-from-version-7-3-0-to-version-7-2-0/196241)
**Author:** [@valentine-dev](https://discuss.elastic.co/u/valentine-dev)\ **Replies:** 2\ **Last updated:** [August 26, 2019, 5:30pm UTC](https://discuss.elastic.co/t/cannot-downgrade-a-node-from-version-7-3-0-to-version-7-2-0/196241 "2019-08-26T17:30:06Z")
I have such error when trying different configuration parameters for ES at GCP: org.elasticsearch.bootstrap.StartupException: java.lang.IllegalStateException: cannot downgrade a node from version \[7.3.0\] to version \[7.2… --- ## [Problem ingesting PDF](https://discuss.elastic.co/t/problem-ingesting-pdf/196811)
**Author:** [@jtgajda](https://discuss.elastic.co/u/jtgajda)\ **Replies:** 0\ **Last updated:** [August 26, 2019, 4:40pm UTC](https://discuss.elastic.co/t/problem-ingesting-pdf/196811 "2019-08-26T16:40:15Z")
I have installed Elasticsearch 7.3 and am trying to index pdf files using the ingest-attachement plug-in and python to convert the pdf to base64 and the request library to load the data. I am able to successfully create … --- ## [Performance optimisation for Time based indexes](https://discuss.elastic.co/t/performance-optimisation-for-time-based-indexes/196807)
**Author:** [@Vivek\_Vardhan](https://discuss.elastic.co/u/Vivek_Vardhan)\ **Replies:** 0\ **Last updated:** [August 26, 2019, 4:22pm UTC](https://discuss.elastic.co/t/performance-optimisation-for-time-based-indexes/196807 "2019-08-26T16:22:04Z")
Hi Team I am building an elastic search (6.6.1) cluster (deployed on Azure Kubernetes), with my current config is - Data Volume 25 GB per day (with 1 month of retention ) Search scenarios (dashboards only few aggregat… --- ## [ELK migration 6.8 to 7.3 lost daily index creation](https://discuss.elastic.co/t/elk-migration-6-8-to-7-3-lost-daily-index-creation/196784)
**Author:** [@tim](https://discuss.elastic.co/u/tim)\ **Replies:** 1\ **Last updated:** [August 26, 2019, 4:21pm UTC](https://discuss.elastic.co/t/elk-migration-6-8-to-7-3-lost-daily-index-creation/196784 "2019-08-26T16:21:19Z")
Prior to migration to 7.3, daily indexes were auto created. After migration to 7.3, my first week on 7.3 is in a single index. My logstash output file : output { elasticsearch { hosts =\> \["logstash-2.xxx.xxx:9200"\] … --- ## [Elasticsearch index policy no effect](https://discuss.elastic.co/t/elasticsearch-index-policy-no-effect/196548)
**Author:** [@rdpusc](https://discuss.elastic.co/u/rdpusc)\ **Replies:** 2\ **Last updated:** [August 26, 2019, 3:23pm UTC](https://discuss.elastic.co/t/elasticsearch-index-policy-no-effect/196548 "2019-08-26T15:23:11Z")
Elasticsearch index policy no effect index is days old and 5m docs. I checked and it looks like the policy is assigned to the index and I restarted the elasticsearch service --- ## [Understanding field limit across index pattern and solution to mapping explosion](https://discuss.elastic.co/t/understanding-field-limit-across-index-pattern-and-solution-to-mapping-explosion/196262)
**Author:** [@elk11](https://discuss.elastic.co/u/elk11)\ **Replies:** 4\ **Last updated:** [August 26, 2019, 3:22pm UTC](https://discuss.elastic.co/t/understanding-field-limit-across-index-pattern-and-solution-to-mapping-explosion/196262 "2019-08-26T15:22:20Z")
Hi, elasticsearch and kibana version: 7.0 We are experiencing mapping explosion with number of fields upto 4500 and increasing. Then the first thing which came to our mind was to implement nested fields to reduce the n… --- ## [Elastic in kubernetes - how to gracefully shutdown](https://discuss.elastic.co/t/elastic-in-kubernetes-how-to-gracefully-shutdown/196373)
**Author:** [@ethrbunny](https://discuss.elastic.co/u/ethrbunny)\ **Replies:** 3\ **Last updated:** [August 26, 2019, 3:20pm UTC](https://discuss.elastic.co/t/elastic-in-kubernetes-how-to-gracefully-shutdown/196373 "2019-08-26T15:20:56Z")
5 data nodes, 5 ingest nodes and a master (+ kibana) running in kubernetes. Looking for a way to tell elastic to close indexes and put away all of its stuff so I can work on k8. If I just kill it outright when it gets r… --- ## [Elastic search automatically stopped after](https://discuss.elastic.co/t/elastic-search-automatically-stopped-after/196797)
**Author:** [@Balaji\_Ramachandran](https://discuss.elastic.co/u/Balaji_Ramachandran)\ **Replies:** 2\ **Last updated:** [August 26, 2019, 3:05pm UTC](https://discuss.elastic.co/t/elastic-search-automatically-stopped-after/196797 "2019-08-26T15:05:44Z")
Hi, We are trying to enable elasticsearch 7.3 using ubuntu 16.04, but after 30 seconds, the service gets automatically stopped. This issue happens while setting up to a specific bind network address to 0.0.0.0. Here I h… --- ## [What happens if primary shard fail during publication?](https://discuss.elastic.co/t/what-happens-if-primary-shard-fail-during-publication/195599)
**Author:** [@lotabout](https://discuss.elastic.co/u/lotabout)\ **Replies:** 3\ **Last updated:** [August 26, 2019, 2:47pm UTC](https://discuss.elastic.co/t/what-happens-if-primary-shard-fail-during-publication/195599 "2019-08-26T14:47:17Z")
As I understand ES's synchronization is kind of like 2 Phase Commit(2PC) and the problem of 2PC is when the "master" node fails during commit. Quote from Github Reply: An indexing request goes through the following pr… --- ## [Optimize server performance](https://discuss.elastic.co/t/optimize-server-performance/195657)
**Author:** [@jgimenez](https://discuss.elastic.co/u/jgimenez)\ **Replies:** 2\ **Last updated:** [August 26, 2019, 2:18pm UTC](https://discuss.elastic.co/t/optimize-server-performance/195657 "2019-08-26T14:18:44Z")
Hi, I'm running an Elasticsearch cluster and I'm not sure we're maximizing the usage of server resources. When bulk-indexing at maximum speed, CPU, disk I/O and garbage collection seem all pretty low, yet Elasticsearch r… --- ## [Duplicate IDs across rollover indices](https://discuss.elastic.co/t/duplicate-ids-across-rollover-indices/196388)
**Author:** [@wwalker](https://discuss.elastic.co/u/wwalker)\ **Replies:** 5\ **Last updated:** [August 26, 2019, 2:18pm UTC](https://discuss.elastic.co/t/duplicate-ids-across-rollover-indices/196388 "2019-08-26T14:18:15Z")
I am ingesting data into a rollover index. The data comes from an API and gives updates on previously ingested events. Each event has a field that is unique and I am using this as the document ID. However, I've come a… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1177) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1179)