I am using Elasticsearch 6.5. Let's say that I have index_trg, that has fields: id, value, and some additional fields. I also have index_src with fields id and new_value, that is subset id ids from index_trg. What I want to do is: for every id from index_src update index_trg, so index_trg.value =…

Update using "join" with other index

inhinyera16 (Archelle Pagapulan) January 29, 2020, 2:09pm 2

Unfortunately can't do joins in elasticsearch. You need to reindex the data with parent/child relationship. Or you can read this related topic.

Topic		Replies	Views
Elasticsearch parent child mergin two tables together Elasticsearch	6	601	March 9, 2017
How to fetch data from multiple index using join like sql Elasticsearch	18	88182	December 4, 2017
Joining Two Indexes with common field values Elasticsearch	9	3472	June 8, 2023
Join queries or filter queries across indices Elasticsearch	13	766	February 28, 2023
Migration from mysql to elasticsearch Elasticsearch migration	4	517	July 11, 2023

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.

Update using "join" with other index

Related Topics