You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Tim Armstrong (Jira)" <ji...@apache.org> on 2020/07/08 00:24:00 UTC

[jira] [Created] (IMPALA-9924) Add support for single IN in disjunction

Tim Armstrong created IMPALA-9924:
-------------------------------------

             Summary: Add support for single IN in disjunction
                 Key: IMPALA-9924
                 URL: https://issues.apache.org/jira/browse/IMPALA-9924
             Project: IMPALA
          Issue Type: Sub-task
          Components: Frontend
            Reporter: Tim Armstrong
            Assignee: Tim Armstrong


A simple case of IMPALA-5226 with a simple rewrite is an IN predicate. We can directly rewrite it into a left outer join
{noformat}
WHERE  <condition> OR (x IN (select y ...))
{noformat}

Can be transformed into
{noformat}
LEFT OUTER JOIN (select distinct y ...) v on x = v.y
...
WHERE <condition> OR v.y IS NOT NULL
{noformat}

This pattern appears in TPC-DS query 45.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)