"in query" is not yet supported

Elastic Stack Elasticsearch
1

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?

Thanks!

2

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.

3

Thanks for the response