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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
