[DRILL-6799] Enhance the Hash-Join Operator to perform Anti-Semi-Join

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.14.0
• Fix Version/s: 1.17.0
• Component/s: Execution - Relational Operators, Query Planning & Optimization
• Assignee: Boaz Ben-Zvi
• Reporter: Boaz Ben-Zvi
• Created: 17/Oct/18 01:37
• Updated: 26/Feb/19 02:15

Description

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;

Issue Links

• is related to: DRILL-6735 Enhance the Hash-Join Operator to perform Semi-Join