Details
-
Improvement
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
1.14.0
-
None
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;
Attachments
Issue Links
- is related to
-
DRILL-6735 Enhance the Hash-Join Operator to perform Semi-Join
- Resolved