Update by Query

Elastic Stack Elasticsearch
1

Hi All,

How can I do an update by query in Elasticsearch what looks performs like this SQL:
UPDATE index1 a SET a.filed1 = (SELECT b.filed2 FROM index2 b WHERE b.filed3 = a.filed4)

I'm using ES 6.8.
Thanks,
Peter

2

You can't.
You can't join indices which is what you are trying to do here I believe.

You need to run 2 different queries.

3

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