I have used parent & child mapping to normalize data but as far as I understand there is no way to get any fields from _parent document. Here is the mapping of my index: { "mappings": { "building": { "properties": { "name": { "type": "string" } } }, "flat": { "_parent": { "type": "buil…

Hello, Assuming you don't have to update rooms and flats too often, you might be better off with nested documents. Back to your original question, you could store the ID of the parent in the child when you insert it. Then, you could use the GET or Multi Get[0] API to retrieve the parents once y…

Hi again :slight_smile: Actually, you don't need to filter to find the parent, since you have the parent IDs when you search for children. You just have to add "_parent" to the list of fields you want to be returned when you search. For example: curl -XPOST localhost:9200/test/room/_search?prett…

Discuss the Elastic Stack

How can I handle duplicate data in Elasticsearch?

Elastic Stack Elasticsearch

Topic		Replies	Views
Any suggestion for duplicate data? Elasticsearch	2	370	July 6, 2017
I have about 500,000 children for each parent Elasticsearch	5	425	March 13, 2021
Parent/Child functionality Elasticsearch	7	1639	July 6, 2017
Maintaining consistency across denormalized data Elasticsearch	1	677	July 5, 2017
Multiple parents in parent/child mapping Elasticsearch	6	9588	July 5, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

How can I handle duplicate data in Elasticsearch?

Related topics