Update using "join" with other index

Elastic Stack Elasticsearch
1

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?

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.

3

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