Update using "join" with other index

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 = index_src.new_value. In databases it would be equivalent of UPADTE using JOIN.
Is such operation doable in the single Elasticsearch request?

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.