[
https://issues.apache.org/jira/browse/DRILL-402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-402.
----------------------------------
Resolution: Fixed
> Add support for semi-join and anti semi-join
> --------------------------------------------
>
> Key: DRILL-402
> URL: https://issues.apache.org/jira/browse/DRILL-402
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Aman Sinha
>
> Semi-join queries of the type
> SELECT ... FROM t1 WHERE a1 IN (SELECT a2 FROM t2 WHERE...);
> need to be supported end-to-end.
> Anti-semi-join queries of the type
> SELECT ... FROM t1 WHERE a1 NOT IN (SELECT a2 FROM t2 WHERE...);
> need to be supported end-to-end.
> In general, the number of columns on the left and right side of the IN or NOT
> IN can be more than 1. So we should either handle that or throw an error if
> not supported.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
