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)