Can we join two indexes.?


(ajit) #1

Hi,
While fetching data from elasticsearch can we join two indexes in query. Is it possible?


(Christian Dahlqvist) #2

No, Elasticsearch does not support joins between indices. There is some limited join-like behaviour within an index, but this comes with a number of restrictions so it is generally recommended to denormalise your data for best performance.


(Michael Ben-David) #3

Yes, if you create an index alias that covers both indexes and then search against the alias.

https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-aliases.html


(system) #4

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