How to fetch data from multiple index using join like sql

[dadoonet (David Pilato)]

You can’t do joins with elasticsearch.

Better to think your model differently and denormalize your data.

Parent/child feature is kind of 1-n relationship but I’d only use it if absolutely necessary.