Is there support for nested queries within a single index.
I'll try to explain in SQL terms what I am trying to achieve in Elasticsearch:
Say mytable has these columns: name, type, value fields in it. There can be multiple types with their own values for one name. I am trying to query:
select name, type, value from mytable where type='someType' and name in (select name from mytable where type='someOtherType')
Note that I am not worried about performance as the data set I am dealing with is fairly small.
Thanks for help.