Essql join on canvas essql

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.

1 Like

Can you give me an example of enrich policy?

How can I add one field from a index to another index?

Thanks

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