# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1432 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1433 --- ## [To access the parent fields using ES query](https://discuss.elastic.co/t/to-access-the-parent-fields-using-es-query/163391)
**Author:** [@Naveena](https://discuss.elastic.co/u/Naveena)\ **Replies:** 0\ **Last updated:** [January 8, 2019, 3:36pm UTC](https://discuss.elastic.co/t/to-access-the-parent-fields-using-es-query/163391 "2019-01-08T15:36:27Z")
Hi, I have created a parent - child relationship between employee and address. PUT my\_index10 { "mappings": { "doc": { "properties": { "my\_join\_field": { "type": "join", "relations": { "employee": "address" } … --- ## [Data Replication](https://discuss.elastic.co/t/data-replication/163249)
**Author:** [@amarender](https://discuss.elastic.co/u/amarender)\ **Replies:** 8\ **Last updated:** [January 8, 2019, 3:25pm UTC](https://discuss.elastic.co/t/data-replication/163249 "2019-01-08T15:25:43Z")
I have a three node cluster as master and data nodes. I need help in uderstanding the below situation. A repo is created when node 1 is running and node2,3 are shutdown. What happens when node2/node 3 becomes active and… --- ## [Synonym analyser not working in general term search across fields](https://discuss.elastic.co/t/synonym-analyser-not-working-in-general-term-search-across-fields/162649)
**Author:** [@jkhere](https://discuss.elastic.co/u/jkhere)\ **Replies:** 4\ **Last updated:** [January 8, 2019, 3:20pm UTC](https://discuss.elastic.co/t/synonym-analyser-not-working-in-general-term-search-across-fields/162649 "2019-01-08T15:20:14Z")
I have added synonym mapping as per the given format. It is added on the settings. The mapping has "universe" mapped to "cosmos". The below URI search gives me a match \_localhost:9200/indexname/search?q=data.summary… --- ## [How to transfer index from 1 node to a different node](https://discuss.elastic.co/t/how-to-transfer-index-from-1-node-to-a-different-node/162917)
**Author:** [@PolterFox](https://discuss.elastic.co/u/PolterFox)\ **Replies:** 25\ **Last updated:** [January 8, 2019, 2:49pm UTC](https://discuss.elastic.co/t/how-to-transfer-index-from-1-node-to-a-different-node/162917 "2019-01-08T14:49:25Z")
Hey guys, I want to transfer specified indices from source node to a different node (they are not in the same cluster!!!). How can I do this? Best regards, PolterFox --- ## [Sizing documentation for a New Installation](https://discuss.elastic.co/t/sizing-documentation-for-a-new-installation/163358)
**Author:** [@Gustavo\_Passini](https://discuss.elastic.co/u/Gustavo_Passini)\ **Replies:** 1\ **Last updated:** [January 8, 2019, 2:06pm UTC](https://discuss.elastic.co/t/sizing-documentation-for-a-new-installation/163358 "2019-01-08T14:06:40Z")
I have a new project with Elasticsearch and I need a sizing (Disk Space, Virtual Memory...) documentation to install the tool in a server. Someone help me? --- ## [Hot/warm data idempotency and vertical scaled ES infrastructure using Curator](https://discuss.elastic.co/t/hot-warm-data-idempotency-and-vertical-scaled-es-infrastructure-using-curator/162613)
**Author:** [@kodo65](https://discuss.elastic.co/u/kodo65)\ **Replies:** 18\ **Last updated:** [January 8, 2019, 11:45am UTC](https://discuss.elastic.co/t/hot-warm-data-idempotency-and-vertical-scaled-es-infrastructure-using-curator/162613 "2019-01-08T11:45:23Z")
I have a hot/warm implementation which is orchestrated with Curator and it works really well. However, I have a thought, a design-related thought, which has been bogging me for a while and I'd like to discuss this with y… --- ## [Elasticsearch query on date?](https://discuss.elastic.co/t/elasticsearch-query-on-date/163343)
**Author:** [@inandi](https://discuss.elastic.co/u/inandi)\ **Replies:** 6\ **Last updated:** [January 8, 2019, 11:30am UTC](https://discuss.elastic.co/t/elasticsearch-query-on-date/163343 "2019-01-08T11:30:43Z")
I have an index where DateTime field is there in this format 2018-01-02T18:24:39.379Z. now this is date and time both, I want to get query where I am able to get the group by data on only date filter. sample data { … --- ## [Why does es node auto down itself](https://discuss.elastic.co/t/why-does-es-node-auto-down-itself/163194)
**Author:** [@iamazy](https://discuss.elastic.co/u/iamazy)\ **Replies:** 2\ **Last updated:** [January 8, 2019, 10:39am UTC](https://discuss.elastic.co/t/why-does-es-node-auto-down-itself/163194 "2019-01-08T10:39:05Z")
there's the logs that the down node print \] \[10.10.2.221\_node2\] loaded plugin \[analysis-ik\] \[2019-01-07T19:22:25,406\]\[INFO \]\[o.e.d.DiscoveryModule \] \[10.10.2.221\_node2\] using discovery type \[zen\] \[2019-01-07T19:22:27… --- ## [Scroll to random page](https://discuss.elastic.co/t/scroll-to-random-page/163262)
**Author:** [@danielpjs](https://discuss.elastic.co/u/danielpjs)\ **Replies:** 0\ **Last updated:** [January 7, 2019, 7:24pm UTC](https://discuss.elastic.co/t/scroll-to-random-page/163262 "2019-01-07T19:24:30Z")
Hi, I've been developing a solution using ElastiSearch and I am stuck into pagination over more than 10.000 records. Okay, I know that there is at least 2 available solutions, being one of them using Scroll instead of a… --- ## [How to remove the default January 1st 1970 in time](https://discuss.elastic.co/t/how-to-remove-the-default-january-1st-1970-in-time/163159)
**Author:** [@talon](https://discuss.elastic.co/u/talon)\ **Replies:** 5\ **Last updated:** [January 8, 2019, 9:45am UTC](https://discuss.elastic.co/t/how-to-remove-the-default-january-1st-1970-in-time/163159 "2019-01-08T09:45:03Z")
HI How to remove the default January 1st 1970 in time. PUT range\_index { "settings": { "number\_of\_shards": 2 }, "mappings": { "\_doc": { "properties": { "expected\_attendees": { "typ… --- ## [Elasticsearch multidimensional points and nearest neighbour sorting](https://discuss.elastic.co/t/elasticsearch-multidimensional-points-and-nearest-neighbour-sorting/161373)
**Author:** [@Spansh](https://discuss.elastic.co/u/Spansh)\ **Replies:** 2\ **Last updated:** [January 8, 2019, 9:18am UTC](https://discuss.elastic.co/t/elasticsearch-multidimensional-points-and-nearest-neighbour-sorting/161373 "2019-01-08T09:18:21Z")
I've been using Elasticsearch for quite a few years now and it powers one of my sites which deals with 3d points in space (effectively solar systems in the galaxy and the bodies within those solar systems). It works mos… --- ## [How can we eliminate the root structure for nested elements in the query result in Elasticsearch?](https://discuss.elastic.co/t/how-can-we-eliminate-the-root-structure-for-nested-elements-in-the-query-result-in-elasticsearch/163308)
**Author:** [@vinodanumarla](https://discuss.elastic.co/u/vinodanumarla)\ **Replies:** 9\ **Last updated:** [January 8, 2019, 9:01am UTC](https://discuss.elastic.co/t/how-can-we-eliminate-the-root-structure-for-nested-elements-in-the-query-result-in-elasticsearch/163308 "2019-01-08T09:01:44Z")
How to write a query to eliminate nested elements "results" and "lines" from the below document. { "\_id": "0048160a463a73faaa6c90f5af027772", "\_rev": "1-ff6255309f1b873a4e482310843a8a15", "timestamp": 1496275536… --- ## [Self-host Elasticsearch VS. Cloud](https://discuss.elastic.co/t/self-host-elasticsearch-vs-cloud/163293)
**Author:** [@Anson1](https://discuss.elastic.co/u/Anson1)\ **Replies:** 1\ **Last updated:** [January 8, 2019, 9:00am UTC](https://discuss.elastic.co/t/self-host-elasticsearch-vs-cloud/163293 "2019-01-08T09:00:23Z")
Hi, I have got a single ELK stack with a single node running in a vagrant virtual box on my machine. It has 3 indexes which are 90mb, 3.6gb, and 38gb. At the same time, I have also got a Javascript application running … --- ## [Very large segments - Do I need to worry?](https://discuss.elastic.co/t/very-large-segments-do-i-need-to-worry/163317)
**Author:** [@Martin\_Becker](https://discuss.elastic.co/u/Martin_Becker)\ **Replies:** 2\ **Last updated:** [January 8, 2019, 8:59am UTC](https://discuss.elastic.co/t/very-large-segments-do-i-need-to-worry/163317 "2019-01-08T08:59:52Z")
We run many dashboards based on our data. As requests were getting slow a year ago we came up with the idea of merging segments in our indices and had a performance boost of around 20%. After visiting an Elastic training… --- ## [High CPU usage / load average while no running queries](https://discuss.elastic.co/t/high-cpu-usage-load-average-while-no-running-queries/162569)
**Author:** [@ES-beginner](https://discuss.elastic.co/u/ES-beginner)\ **Replies:** 15\ **Last updated:** [January 8, 2019, 8:51am UTC](https://discuss.elastic.co/t/high-cpu-usage-load-average-while-no-running-queries/162569 "2019-01-08T08:51:37Z")
Hello everyone! I am a beginner with ES, and I am encountering my first performance issue. Setup: Hardware: 2 vCore, 8 GB RAM, 80 GB SSD Ubuntu 18.04 Java 1.8.0\_191 ElasticSearch 6.5.1 Default ES configuration 1 clu… --- ## [Question on how to edit timestamp](https://discuss.elastic.co/t/question-on-how-to-edit-timestamp/163275)
**Author:** [@dvandyk](https://discuss.elastic.co/u/dvandyk)\ **Replies:** 1\ **Last updated:** [January 8, 2019, 8:47am UTC](https://discuss.elastic.co/t/question-on-how-to-edit-timestamp/163275 "2019-01-08T08:47:15Z")
Hello, What is the easiest method that I can edit the time stamp so that logs don't report on the second? I have logs that trigger every second and I want to combine them into minutes. I would like to output the follow… --- ## [Is edgegram\_analyzer predefined analyzer?](https://discuss.elastic.co/t/is-edgegram-analyzer-predefined-analyzer/163310)
**Author:** [@Suryadip\_Nag](https://discuss.elastic.co/u/Suryadip_Nag)\ **Replies:** 2\ **Last updated:** [January 8, 2019, 8:09am UTC](https://discuss.elastic.co/t/is-edgegram-analyzer-predefined-analyzer/163310 "2019-01-08T08:09:19Z")
In our project we have used "analyzer": "edgegram\_analyzer" for one property in mapping template. But in elastic search website I can't see any reference for that analyzer. When I am searching it in goggle with 'edgegr… --- ## [Elasticsearch - Highlight fragments containing unique search terms](https://discuss.elastic.co/t/elasticsearch-highlight-fragments-containing-unique-search-terms/163314)
**Author:** [@Nikesh](https://discuss.elastic.co/u/Nikesh)\ **Replies:** 0\ **Last updated:** [January 8, 2019, 8:06am UTC](https://discuss.elastic.co/t/elasticsearch-highlight-fragments-containing-unique-search-terms/163314 "2019-01-08T08:06:12Z")
Hi, I am looking for a Elasticsearch Highlight feature where each highlight term is unique. One of my fields contains over 3000 words. When I search over this field using multiple words in a single search query, it hig… --- ## [How to disable automatic creating monitoring file](https://discuss.elastic.co/t/how-to-disable-automatic-creating-monitoring-file/163180)
**Author:** [@Vasudevantgi](https://discuss.elastic.co/u/Vasudevantgi)\ **Replies:** 5\ **Last updated:** [January 8, 2019, 6:18am UTC](https://discuss.elastic.co/t/how-to-disable-automatic-creating-monitoring-file/163180 "2019-01-08T06:18:37Z")
Hi Team, I have an issue when i start the Elasticsearch its automatically created the (dot) monitoring file daily .. This issue is come from last month . i dont know how this index is created and i am not enable anythin… --- ## [How to do operation on SQL result](https://discuss.elastic.co/t/how-to-do-operation-on-sql-result/163305)
**Author:** [@examin](https://discuss.elastic.co/u/examin)\ **Replies:** 0\ **Last updated:** [January 8, 2019, 5:36am UTC](https://discuss.elastic.co/t/how-to-do-operation-on-sql-result/163305 "2019-01-08T05:36:00Z")
I have query like SELECT(SELECT COUNT() FROM index\_!)/(SELECT COUNT() FROM index\_! where age is 10). how can i get same result from elasticsearch --- ## [Java 1.7 and ElasticSearch 6.5](https://discuss.elastic.co/t/java-1-7-and-elasticsearch-6-5/162990)
**Author:** [@Suryadip\_Nag](https://discuss.elastic.co/u/Suryadip_Nag)\ **Replies:** 6\ **Last updated:** [January 8, 2019, 5:34am UTC](https://discuss.elastic.co/t/java-1-7-and-elasticsearch-6-5/162990 "2019-01-08T05:34:49Z")
We have an application which runs on java 1.7 and we can’t upgrade now to 1.8 due to some limitations, I want to use ElasticSearch 6.5.4 Can we use java 1.7 any chance? We are gonna use the \_bulk, \_search api etc to stor… --- ## [GET \_node/hot\_threads result shown warm nodes are doing flush forever](https://discuss.elastic.co/t/get-node-hot-threads-result-shown-warm-nodes-are-doing-flush-forever/163292)
**Author:** [@jasony](https://discuss.elastic.co/u/jasony)\ **Replies:** 0\ **Last updated:** [January 8, 2019, 2:49am UTC](https://discuss.elastic.co/t/get-node-hot-threads-result-shown-warm-nodes-are-doing-flush-forever/163292 "2019-01-08T02:49:20Z")
hello, i am using hot-warm architecture in a single cluster. i have posted before but couldn’t find satisfied answer yet so i am posting this again here. my indices being allocated from hot to warm node daily bases (us… --- ## [Confirming that the completion suggester can only match prefix phrases](https://discuss.elastic.co/t/confirming-that-the-completion-suggester-can-only-match-prefix-phrases/163284)
**Author:** [@Simon\_Tower](https://discuss.elastic.co/u/Simon_Tower)\ **Replies:** 0\ **Last updated:** [January 7, 2019, 11:56pm UTC](https://discuss.elastic.co/t/confirming-that-the-completion-suggester-can-only-match-prefix-phrases/163284 "2019-01-07T23:56:21Z")
I'm new to ElasticSearch and I've been tasked with replacing our n-gram autocomplete implementation with the completion suggester. I have read The ES blog on completion suggesters as well as various other implementation… --- ## [After Create ElasticSearch Cluster with 3 nodes as master and data nodes , how to access apis of elasticssearch to aggregate , insert and update?](https://discuss.elastic.co/t/after-create-elasticsearch-cluster-with-3-nodes-as-master-and-data-nodes-how-to-access-apis-of-elasticssearch-to-aggregate-insert-and-update/163245)
**Author:** [@m\_5amy](https://discuss.elastic.co/u/m_5amy)\ **Replies:** 4\ **Last updated:** [January 7, 2019, 9:25pm UTC](https://discuss.elastic.co/t/after-create-elasticsearch-cluster-with-3-nodes-as-master-and-data-nodes-how-to-access-apis-of-elasticssearch-to-aggregate-insert-and-update/163245 "2019-01-07T21:25:00Z")
After Create ElasticSearch Cluster with 3 nodes as master and data nodes , how to access apis of elasticssearch to aggregate , insert and update? --- ## [Migrate elasticsearch tar.gz based instance to new debian package based instance](https://discuss.elastic.co/t/migrate-elasticsearch-tar-gz-based-instance-to-new-debian-package-based-instance/163268)
**Author:** [@Manuel\_Polonio](https://discuss.elastic.co/u/Manuel_Polonio)\ **Replies:** 1\ **Last updated:** [January 7, 2019, 9:23pm UTC](https://discuss.elastic.co/t/migrate-elasticsearch-tar-gz-based-instance-to-new-debian-package-based-instance/163268 "2019-01-07T21:23:40Z")
Hello. I've an ES tar.gz based instance running and I would like to migrate it to an ES debian package installation (same version to avoid problems: 6.5.3) in the same machine. Both instance would run as single-node (exc… --- ## [Trying to pass params to elasticsearch getting null\_pointer\_exception](https://discuss.elastic.co/t/trying-to-pass-params-to-elasticsearch-getting-null-pointer-exception/163230)
**Author:** [@qballer](https://discuss.elastic.co/u/qballer)\ **Replies:** 2\ **Last updated:** [January 7, 2019, 6:42pm UTC](https://discuss.elastic.co/t/trying-to-pass-params-to-elasticsearch-getting-null-pointer-exception/163230 "2019-01-07T18:42:44Z")
I'm trying to send to Elasticsearch the following query. Here is the most minimal update by query which gives me the exception. Lets name it Query1: { "id": "someID", "script": { "lang": "painless", "source… --- ## [Best way to update dynamic field from DB](https://discuss.elastic.co/t/best-way-to-update-dynamic-field-from-db/163167)
**Author:** [@Ragnar](https://discuss.elastic.co/u/Ragnar)\ **Replies:** 3\ **Last updated:** [January 7, 2019, 6:07pm UTC](https://discuss.elastic.co/t/best-way-to-update-dynamic-field-from-db/163167 "2019-01-07T18:07:19Z")
We started to use Elastic stats for metrics purpose and now we plan to do some analytics on our data. I plan to index our "company" table to ES and denormalize some data with it. One a this new field is going to be upda… --- ## [AlreadyClosedException: engine is closed during cluster stats](https://discuss.elastic.co/t/alreadyclosedexception-engine-is-closed-during-cluster-stats/163238)
**Author:** [@katre](https://discuss.elastic.co/u/katre)\ **Replies:** 3\ **Last updated:** [January 7, 2019, 4:35pm UTC](https://discuss.elastic.co/t/alreadyclosedexception-engine-is-closed-during-cluster-stats/163238 "2019-01-07T16:35:04Z")
We monitor elasticsearch by using -cluster/stats. However it seems to give false alerts or we have some underlying issue to be solved. Cluster contains of 3 nodes. We use curator to periodically delete old indexes and r… --- ## [Reindex data of size 24GB](https://discuss.elastic.co/t/reindex-data-of-size-24gb/163185)
**Author:** [@itsron143](https://discuss.elastic.co/u/itsron143)\ **Replies:** 3\ **Last updated:** [January 7, 2019, 4:24pm UTC](https://discuss.elastic.co/t/reindex-data-of-size-24gb/163185 "2019-01-07T16:24:06Z")
I have an index in ES 1.7 which has around 24 GB of data. I'd like to reindex that to ES 5.0.0. Can I do that in one go? Also the mapping of the 1.7 version is causing errors (empty string field names). How do I fix that… --- ## [TTL Documents](https://discuss.elastic.co/t/ttl-documents/162712)
**Author:** [@alexus](https://discuss.elastic.co/u/alexus)\ **Replies:** 8\ **Last updated:** [January 7, 2019, 4:19pm UTC](https://discuss.elastic.co/t/ttl-documents/162712 "2019-01-07T16:19:51Z")
Per TTL Documents, Shield and Found | Elastic: Note that in the current version of Elasticsearch, \_ttl is deprecated. What is the approach for modern elasticsearch 6.5+ (in terms of documents that needs to be expire… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1431) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1433)