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.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.