"in query" is not yet supported

When I try to use sql API to do the following:

select name from school where name in ( select name from teachers ) ;

ES complains that "in query" is not yet supported. This means I need to do this in query DSL. What is the equivalent in DSL?


There isn't one at this stage sorry. I am not sure if there is something on the roadmap, as this essentially equates to 2 queries in the one request, which Elasticsearch currently doesn't handle.

Thanks for the response

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