Nested query within single index

Elastic Stack Elasticsearch
1

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

2

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.

3

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