drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-402) Add support for semi-join and anti semi-join
Date Mon, 09 Jun 2014 05:35:05 GMT

     [ 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)

Mime
View raw message