Nested query within single index

[j3grewal (Jas)]

Hi,

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.

-Jas

[Christian_Dahlqvist]

What you are showing is a subselect, which is a type of join. Joins are not supported by Elasticsearch so I do not think what you are trying to achieve is possible within a single request.