I am new to ES and trying to build a query.
I have tried 5-6 options but not getting desired result.Just want to make sure whether joins can be achieved in ES.Thanks for help.
SQL will be like this
select symbol from stocks where stocks.industry == (select industry from stocks where symbol == 'XYZ')
I will be passing symbol at run time.