Hi,
is it possible to write an essql query with join inside?
I have a field in one index and I would to compare that to another field in another index and extract some value.
I need this value in canvas.
How can I do?
Hi there!
Due to Elasticsearch's nature as a distributed document store, full joins across separate indices is not currently possible. You can read more about this limitation here.
We do have an alternative option which allows you to enrich new documents in one index with data from another index when the documents are ingested into Elasticsearch. For this option, see the Enrich processor documentation.
Can you give me an example of enrich policy?
How can I add one field from a index to another index?
Thanks