[
https://issues.apache.org/jira/browse/DRILL-6799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Boaz Ben-Zvi updated DRILL-6799:
--------------------------------
Fix Version/s: Future
> Enhance the Hash-Join Operator to perform Anti-Semi-Join
> --------------------------------------------------------
>
> Key: DRILL-6799
> URL: https://issues.apache.org/jira/browse/DRILL-6799
> Project: Apache Drill
> Issue Type: Improvement
> Components: Execution - Relational Operators, Query Planning &
> Optimization
> Affects Versions: 1.14.0
> Reporter: Boaz Ben-Zvi
> Assignee: Boaz Ben-Zvi
> Priority: Minor
> Fix For: Future
>
>
> Similar to handling Semi-Join (see DRILL-6735), the Anti-Semi-Join can be
> enhanced by eliminating the extra DISTINCT (i.e. Hash-Aggr) operator.
> Example (note the NOT IN):
> select c.c_first_name, c.c_last_name from dfs.`/data/json/s1/customer` c
> where c.c_customer_sk NOT IN (select s.ss_customer_sk from
> dfs.`/data/json/s1/store_sales` s) limit 4;
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
