# Elasticsearch

**URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1430

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 1431

---

## [Unable to retrieve all documents from elastic](https://discuss.elastic.co/t/unable-to-retrieve-all-documents-from-elastic/163653)

<div class="topic-metadata">

**Author:** [@Oddo\_Da](https://discuss.elastic.co/u/Oddo_Da)\
**Replies:** 1\
**Last updated:** [January 10, 2019, 6:02am UTC](https://discuss.elastic.co/t/unable-to-retrieve-all-documents-from-elastic/163653 "2019-01-10T06:02:29Z")

</div>

Hello, I am fairly new to elastic. As a test, I loaded 500 documents into elasticsearch (6.4.2) via a bulk query. When I run a query/match\_all to see them (e.g. in Kibana) I only get 10 - like so (excerpt below). Why am …

---

## [\[Parent-child deletion\] documentation says routing is required but without routing it works. \[ES 6.5v\]](https://discuss.elastic.co/t/parent-child-deletion-documentation-says-routing-is-required-but-without-routing-it-works-es-6-5v/163290)

<div class="topic-metadata">

**Author:** [@mashhur](https://discuss.elastic.co/u/mashhur)\
**Replies:** 1\
**Last updated:** [January 10, 2019, 4:49am UTC](https://discuss.elastic.co/t/parent-child-deletion-documentation-says-routing-is-required-but-without-routing-it-works-es-6-5v/163290 "2019-01-10T04:49:24Z")

</div>

Hi there, I have started using Elasticsearch 6.5 version with parent-child actions (mapping, indexing, updating, deleting). In case of delete, documentation says ROUTING value is required. In a reality ROUTING value is …

---

## [How can i compare the fields between index OR compare fields between the result hit?](https://discuss.elastic.co/t/how-can-i-compare-the-fields-between-index-or-compare-fields-between-the-result-hit/161953)

<div class="topic-metadata">

**Author:** [@Sky\_Iprd](https://discuss.elastic.co/u/Sky_Iprd)\
**Replies:** 18\
**Last updated:** [January 10, 2019, 3:44am UTC](https://discuss.elastic.co/t/how-can-i-compare-the-fields-between-index-or-compare-fields-between-the-result-hit/161953 "2019-01-10T03:44:02Z")

</div>

Hi, is anyone can point me a right direction for the subject ? I've try long time ( i.e scripted\_metric , bucket\_path ) and didn't find anything can help. Can someone know how can I able to do such thing in elasticsearch…

---

## [How to combine Elasticsearch function score query and text proximity scoring with weight?](https://discuss.elastic.co/t/how-to-combine-elasticsearch-function-score-query-and-text-proximity-scoring-with-weight/163651)

<div class="topic-metadata">

**Author:** [@evalphobia](https://discuss.elastic.co/u/evalphobia)\
**Replies:** 0\
**Last updated:** [January 10, 2019, 3:36am UTC](https://discuss.elastic.co/t/how-to-combine-elasticsearch-function-score-query-and-text-proximity-scoring-with-weight/163651 "2019-01-10T03:36:16Z")

</div>

This question is originally from StackOverflow's post. I've not been got any response, so I'm reposting here. I'd like to use function score query and text proximity with weight. But the query does not correctly calcu…

---

## [Parent-child-grandchild relationship in Elasticsearch6](https://discuss.elastic.co/t/parent-child-grandchild-relationship-in-elasticsearch6/163638)

<div class="topic-metadata">

**Author:** [@srividya](https://discuss.elastic.co/u/srividya)\
**Replies:** 0\
**Last updated:** [January 10, 2019, 1:04am UTC](https://discuss.elastic.co/t/parent-child-grandchild-relationship-in-elasticsearch6/163638 "2019-01-10T01:04:34Z")

</div>

Is there any way that we can implement the below mappings/scenario in elasticsearch 6? A {id} B (Child of A){id, parentid} C (Child of B){id, parentid} D(Child of A){id, parentid} Since types are deprecated from ve…

---

## [Ho to create single index for logs coming through fluentd, filebeat and logstash together?](https://discuss.elastic.co/t/ho-to-create-single-index-for-logs-coming-through-fluentd-filebeat-and-logstash-together/163631)

<div class="topic-metadata">

**Author:** [@vijayakrishna.rg](https://discuss.elastic.co/u/vijayakrishna.rg)\
**Replies:** 4\
**Last updated:** [January 9, 2019, 11:42pm UTC](https://discuss.elastic.co/t/ho-to-create-single-index-for-logs-coming-through-fluentd-filebeat-and-logstash-together/163631 "2019-01-09T23:42:53Z")

</div>

Hi, I have logs coming from kubernetes, nginx and jenkins machines. i have configured fluentd on kubernetes to get logs and filebeat on nginx to get access logs and logstash on jenkins machine, i want all these logs to…

---

## [How do inner hits work inside filtered aliases?](https://discuss.elastic.co/t/how-do-inner-hits-work-inside-filtered-aliases/163630)

<div class="topic-metadata">

**Author:** [@loren](https://discuss.elastic.co/u/loren)\
**Replies:** 0\
**Last updated:** [January 9, 2019, 11:04pm UTC](https://discuss.elastic.co/t/how-do-inner-hits-work-inside-filtered-aliases/163630 "2019-01-09T23:04:32Z")

</div>

I want to create a filtered alias that contains a nested query with inner\_hits. I'd like to then run a more-specific nested query with inner\_hits against that filtered alias. The inner hits from the filtered alias seem …

---

## [Watcher - check if string contains word](https://discuss.elastic.co/t/watcher-check-if-string-contains-word/163620)

<div class="topic-metadata">

**Author:** [@adminek83](https://discuss.elastic.co/u/adminek83)\
**Replies:** 1\
**Last updated:** [January 9, 2019, 10:04pm UTC](https://discuss.elastic.co/t/watcher-check-if-string-contains-word/163620 "2019-01-09T22:04:08Z")

</div>

Hello everyone. It is possible to check if some field contains word inside input string? using instruction contains() I have this: { "script": { "script": { "source": "i…

---

## [Result window is too large, from + size must be less than or equal to: \[1000\] but was \[1025\]](https://discuss.elastic.co/t/result-window-is-too-large-from-size-must-be-less-than-or-equal-to-1000-but-was-1025/163615)

<div class="topic-metadata">

**Author:** [@arunics](https://discuss.elastic.co/u/arunics)\
**Replies:** 2\
**Last updated:** [January 9, 2019, 8:34pm UTC](https://discuss.elastic.co/t/result-window-is-too-large-from-size-must-be-less-than-or-equal-to-1000-but-was-1025/163615 "2019-01-09T20:34:21Z")

</div>

I am seeing the above error when Application Searches from ES cluster. I wonder how it shows as 1000 when the default seems to be 10K. ES Version: "number" : "5.5.3", "build\_hash" : "9305a5e", "build\_date" : "2017-09…

---

## [Rejoin master-data node back to cluster](https://discuss.elastic.co/t/rejoin-master-data-node-back-to-cluster/163608)

<div class="topic-metadata">

**Author:** [@sohit\_keshri](https://discuss.elastic.co/u/sohit_keshri)\
**Replies:** 1\
**Last updated:** [January 9, 2019, 6:57pm UTC](https://discuss.elastic.co/t/rejoin-master-data-node-back-to-cluster/163608 "2019-01-09T18:57:30Z")

</div>

I have 3 nodes of elasticsearch all of them act as master-data node. Due to connectivity issue one node leaves the cluster and promotes itself as master.Now i have two cluster first one with two nodes and other with one …

---

## [Monitoring Not works after some time](https://discuss.elastic.co/t/monitoring-not-works-after-some-time/163550)

<div class="topic-metadata">

**Author:** [@rijinmp](https://discuss.elastic.co/u/rijinmp)\
**Replies:** 2\
**Last updated:** [January 9, 2019, 6:53pm UTC](https://discuss.elastic.co/t/monitoring-not-works-after-some-time/163550 "2019-01-09T18:53:35Z")

</div>

Hi All , My 5 elasticsearch cluster sending monitoring data to another elasticsearch(monitorin server) machine. Kibana is using to visualize 5 node elasticsearch cluster and monioring data. All configurations are wor…

---

## [Stats for a query?](https://discuss.elastic.co/t/stats-for-a-query/163606)

<div class="topic-metadata">

**Author:** [@elkusr](https://discuss.elastic.co/u/elkusr)\
**Replies:** 0\
**Last updated:** [January 9, 2019, 6:38pm UTC](https://discuss.elastic.co/t/stats-for-a-query/163606 "2019-01-09T18:38:52Z")

</div>

Hi all, new to Elasticsearch, primarily use Splunk. I'm looking to generate stats for some queries. For example: EVENTNAME:"Prevent DLLs from jumping over rainbows" In Splunk if I wanted to see all event names captured…

---

## [Replica can exist in single node setup?](https://discuss.elastic.co/t/replica-can-exist-in-single-node-setup/163446)

<div class="topic-metadata">

**Author:** [@Suryadip\_Nag](https://discuss.elastic.co/u/Suryadip_Nag)\
**Replies:** 2\
**Last updated:** [January 9, 2019, 6:31pm UTC](https://discuss.elastic.co/t/replica-can-exist-in-single-node-setup/163446 "2019-01-09T18:31:49Z")

</div>

If I have a single node setup and for each index say I have mentioned 2 shards and 1 replica in index settings. As it’s a single node there wouldn’t be any replica right? Only primary shards. Please tell me if my unders…

---

## [Search Cancellation mechanism on timeout before v.6.4.0](https://discuss.elastic.co/t/search-cancellation-mechanism-on-timeout-before-v-6-4-0/163559)

<div class="topic-metadata">

**Author:** [@Ivan\_Bokii](https://discuss.elastic.co/u/Ivan_Bokii)\
**Replies:** 4\
**Last updated:** [January 9, 2019, 6:22pm UTC](https://discuss.elastic.co/t/search-cancellation-mechanism-on-timeout-before-v-6-4-0/163559 "2019-01-09T18:22:36Z")

</div>

The 6.4.0 version of "Search Request Body" reference (https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-body.html#\_parameters\_4) says that "Search Cancellation" mechanism is used on search t…

---

## [Problem with maxThreadCount and maxMergeCount](https://discuss.elastic.co/t/problem-with-maxthreadcount-and-maxmergecount/163599)

<div class="topic-metadata">

**Author:** [@willyaranda\_vonage](https://discuss.elastic.co/u/willyaranda_vonage)\
**Replies:** 4\
**Last updated:** [January 9, 2019, 6:21pm UTC](https://discuss.elastic.co/t/problem-with-maxthreadcount-and-maxmergecount/163599 "2019-01-09T18:21:54Z")

</div>

Hi! We are using curator to change the maxMergeCount to 1 when our indexes are in warm (spinning disks) machines. Today, I've seen that we have an error: 2019-01-09 09:34:41,478 DEBUG elasticsearch …

---

## [ES 6.5.2 Shards on the same physical server do not automatically relocate to another server after cluster.routing.allocation.same\_shard.host is set to true](https://discuss.elastic.co/t/es-6-5-2-shards-on-the-same-physical-server-do-not-automatically-relocate-to-another-server-after-cluster-routing-allocation-same-shard-host-is-set-to-true/161543)

<div class="topic-metadata">

**Author:** [@ld\_pvl](https://discuss.elastic.co/u/ld_pvl)\
**Replies:** 10\
**Last updated:** [January 9, 2019, 5:34pm UTC](https://discuss.elastic.co/t/es-6-5-2-shards-on-the-same-physical-server-do-not-automatically-relocate-to-another-server-after-cluster-routing-allocation-same-shard-host-is-set-to-true/161543 "2019-01-09T17:34:36Z")

</div>

Hi Elastic Team, I have got a number of physical servers, on each of which I run multiple ES data nodes. Because of this setup, sometimes there would be same replica shards on the same physical server. I have set the c…

---

## [Could not export table on to ElasticSearch](https://discuss.elastic.co/t/could-not-export-table-on-to-elasticsearch/163595)

<div class="topic-metadata">

**Author:** [@nara](https://discuss.elastic.co/u/nara)\
**Replies:** 0\
**Last updated:** [January 9, 2019, 5:28pm UTC](https://discuss.elastic.co/t/could-not-export-table-on-to-elasticsearch/163595 "2019-01-09T17:28:17Z")

</div>

Hi, I am using Spark 2.2.0, Hadoop distribution:Amazon 2.7.3, Hail 0.2. I am trying to export a table on to ElasticSearch and I am experiencing this error. (Note: Both EMR and ES are hosted on Amazon) \>\>\> mt=l.export\_…

---

## [Python elasticsearch performance](https://discuss.elastic.co/t/python-elasticsearch-performance/163587)

<div class="topic-metadata">

**Author:** [@revelc33](https://discuss.elastic.co/u/revelc33)\
**Replies:** 2\
**Last updated:** [January 9, 2019, 5:13pm UTC](https://discuss.elastic.co/t/python-elasticsearch-performance/163587 "2019-01-09T17:13:11Z")

</div>

i am trying to make 300 queries per second to my Elasticsearch from my script, but i am not very sure how can i make in an optimal way reusing the connections. \` from elasticsearch import Elasticsearch import \_thread …

---

## [ES 6.5.2 Numeric range query returning results out of range](https://discuss.elastic.co/t/es-6-5-2-numeric-range-query-returning-results-out-of-range/162983)

<div class="topic-metadata">

**Author:** [@ld\_pvl](https://discuss.elastic.co/u/ld_pvl)\
**Replies:** 5\
**Last updated:** [January 9, 2019, 5:04pm UTC](https://discuss.elastic.co/t/es-6-5-2-numeric-range-query-returning-results-out-of-range/162983 "2019-01-09T17:04:04Z")

</div>

Hi Team, The field is definitely of the expected type which is float - this is the mapping of the index: ... "properties" : { .... "utc\_ts" : { "type" : "float" } } } }, The field values…

---

## [Debugging Partially Complete Reindexing Task?](https://discuss.elastic.co/t/debugging-partially-complete-reindexing-task/163272)

<div class="topic-metadata">

**Author:** [@micah.williamson](https://discuss.elastic.co/u/micah.williamson)\
**Replies:** 1\
**Last updated:** [January 9, 2019, 4:51pm UTC](https://discuss.elastic.co/t/debugging-partially-complete-reindexing-task/163272 "2019-01-09T16:51:15Z")

</div>

I am currently trying to reindex an existing index into a new index with an updated schema. The issue i'm having is that the reindexing process gives up reindexing my ~2.5m index after about ~0.5m (give or take. it's inc…

---

## [Debugging unit tests in elasticsearch](https://discuss.elastic.co/t/debugging-unit-tests-in-elasticsearch/50634)

<div class="topic-metadata">

**Author:** [@rbellamy](https://discuss.elastic.co/u/rbellamy)\
**Replies:** 1\
**Last updated:** [January 9, 2019, 4:48pm UTC](https://discuss.elastic.co/t/debugging-unit-tests-in-elasticsearch/50634 "2019-01-09T16:48:22Z")

</div>

I'm interested in attaching a debugger to the unit tests in Elasticsearch. In the TESTING document, it mentions that I can attach a debugger to the running version of Elasticsearch launched via Gradle (e.g. gradle run --…

---

## [Trim the Content after applying highlight funciton](https://discuss.elastic.co/t/trim-the-content-after-applying-highlight-funciton/163578)

<div class="topic-metadata">

**Author:** [@anveshdd](https://discuss.elastic.co/u/anveshdd)\
**Replies:** 0\
**Last updated:** [January 9, 2019, 4:22pm UTC](https://discuss.elastic.co/t/trim-the-content-after-applying-highlight-funciton/163578 "2019-01-09T16:22:39Z")

</div>

Working on Elastic Search 6.5.2. Need to trim the content field to 300 characters after applying highlighting. I don't want to increase the number of fragments. Any suggestions. { "query":{ "multi\_match" : { …

---

## [\[PHP\] Bulk-indexing works, add/update single document fails with remote\_transport\_exception](https://discuss.elastic.co/t/php-bulk-indexing-works-add-update-single-document-fails-with-remote-transport-exception/163096)

<div class="topic-metadata">

**Author:** [@radonthetyrant](https://discuss.elastic.co/u/radonthetyrant)\
**Replies:** 0\
**Last updated:** [January 6, 2019, 8:32pm UTC](https://discuss.elastic.co/t/php-bulk-indexing-works-add-update-single-document-fails-with-remote-transport-exception/163096 "2019-01-06T20:32:04Z")

</div>

Hello, I am on ES Version 6.5.4 I use this code to batch-index all documents (start fresh) $params = \['body' =\> \[\]\]; for ($i = 0, $n = count($user\_data); $i \< $n; $i++) { $user = $user\_data\[$i\]; $p…

---

## [ES Plugin to log rest requests](https://discuss.elastic.co/t/es-plugin-to-log-rest-requests/162836)

<div class="topic-metadata">

**Author:** [@saikettewary](https://discuss.elastic.co/u/saikettewary)\
**Replies:** 5\
**Last updated:** [January 9, 2019, 3:36pm UTC](https://discuss.elastic.co/t/es-plugin-to-log-rest-requests/162836 "2019-01-09T15:36:39Z")

</div>

Hi, I have a plugin that logs all rest requests . Currently this is implemented using getRestHandlerWrapper with my plugins RestHandler. What is other way i can achieve the same without using getRestHandlerWrapper as …

---

## [Index data to elasticsearch from SQL Server](https://discuss.elastic.co/t/index-data-to-elasticsearch-from-sql-server/163553)

<div class="topic-metadata">

**Author:** [@itsron143](https://discuss.elastic.co/u/itsron143)\
**Replies:** 3\
**Last updated:** [January 9, 2019, 3:06pm UTC](https://discuss.elastic.co/t/index-data-to-elasticsearch-from-sql-server/163553 "2019-01-09T15:06:25Z")

</div>

I have a database in my SQL Server which has multiple tables and the size of the database is around 25 GB. I want to index this data to Elasticsearch 5.6 (As it supports mapping of multiple types). However the column na…

---

## [How to deal with nested fields limit](https://discuss.elastic.co/t/how-to-deal-with-nested-fields-limit/163544)

<div class="topic-metadata">

**Author:** [@alex\_b](https://discuss.elastic.co/u/alex_b)\
**Replies:** 2\
**Last updated:** [January 9, 2019, 2:15pm UTC](https://discuss.elastic.co/t/how-to-deal-with-nested-fields-limit/163544 "2019-01-09T14:15:29Z")

</div>

Hi, ES sets 50 as a limit of nested fields, as explained here: https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping.html#mapping-limit-settings As we plan to store potentially large objects in ES, we…

---

## [Query\_string with wildcard and whitespace or dash](https://discuss.elastic.co/t/query-string-with-wildcard-and-whitespace-or-dash/163545)

<div class="topic-metadata">

**Author:** [@kmprr](https://discuss.elastic.co/u/kmprr)\
**Replies:** 0\
**Last updated:** [January 9, 2019, 1:58pm UTC](https://discuss.elastic.co/t/query-string-with-wildcard-and-whitespace-or-dash/163545 "2019-01-09T13:58:43Z")

</div>

Hello, I have problem with creating query\_string with wildcard and some special characters (whitespace, dash etc.) I have field myText (type text), which can be pretty long. And it can contains something like this - Na…

---

## [How to solve json\_e\_o\_f\_exception on \_msearch /template](https://discuss.elastic.co/t/how-to-solve-json-e-o-f-exception-on-msearch-template/163514)

<div class="topic-metadata">

**Author:** [@Nico92](https://discuss.elastic.co/u/Nico92)\
**Replies:** 2\
**Last updated:** [January 9, 2019, 1:00pm UTC](https://discuss.elastic.co/t/how-to-solve-json-e-o-f-exception-on-msearch-template/163514 "2019-01-09T13:00:39Z")

</div>

Hey guys, I'm trying so use Multisearch API. But I got an bad json eof exception. Here is my case: How I build my template: POST \_scripts/t1 { "script": { "lang": "mustache", "source": { "query": { …

---

## [Disable dynamic mapping for index except for 1 field](https://discuss.elastic.co/t/disable-dynamic-mapping-for-index-except-for-1-field/163531)

<div class="topic-metadata">

**Author:** [@Keff](https://discuss.elastic.co/u/Keff)\
**Replies:** 0\
**Last updated:** [January 9, 2019, 12:48pm UTC](https://discuss.elastic.co/t/disable-dynamic-mapping-for-index-except-for-1-field/163531 "2019-01-09T12:48:21Z")

</div>

I want to index documents where same fields can have different data types. My documents look like this: { "user": "testuser", "field1": "arbitraryDataTypeValue", "field2": "arbitraryDataTypeValue" ...n fields...…

---

## [After Create My ES cluster included only 3 nodes each of nodes is "master and data node" , when trying to check cluster health using "9200/\_cluster/health?pretty'" getting an error](https://discuss.elastic.co/t/after-create-my-es-cluster-included-only-3-nodes-each-of-nodes-is-master-and-data-node-when-trying-to-check-cluster-health-using-9200-cluster-health-pretty-getting-an-error/163528)

<div class="topic-metadata">

**Author:** [@m\_5amy](https://discuss.elastic.co/u/m_5amy)\
**Replies:** 0\
**Last updated:** [January 9, 2019, 12:35pm UTC](https://discuss.elastic.co/t/after-create-my-es-cluster-included-only-3-nodes-each-of-nodes-is-master-and-data-node-when-trying-to-check-cluster-health-using-9200-cluster-health-pretty-getting-an-error/163528 "2019-01-09T12:35:12Z")

</div>

This is the error returned after check cluster health { "error" : { "root\_cause" : \[ { "type" : "master\_not\_discovered\_exception", "reason" : null } \], "type" : "master\_not\_disc…

[Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1429)

[Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1431)
