Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6799

Enhance the Hash-Join Operator to perform Anti-Semi-Join

    XMLWordPrintableJSON

Details

    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

          Activity

            People

              ben-zvi Boaz Ben-Zvi
              ben-zvi Boaz Ben-Zvi
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: