Update using "join" with other index

[MMH]

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?

[inhinyera16 (Archelle Pagapulan)]

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

How to fetch data from multiple index using join like sql

Hi David, I prefer this example of normalization. PUT /my_index/user/1 { "name": "John Smith", "email": "john@smith.com", "dob": "1970/10/24" } PUT /my_index/blogpost/2 { "title": "Relationships", "body": "It's complicated...", "user": { "id": 1, "name": "John Smith" } } for fetching records used: GET /my_index/blogpost/_search { "query": { "bool": { "must": [ { "match": { "title": "relationships" }}, { "…