[ https://issues.apache.org/jira/browse/IMPALA-9924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-9924. ----------------------------------- Fix Version/s: Impala 4.0 Resolution: Fixed > 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 > Priority: Major > Labels: tpcds > Fix For: Impala 4.0 > > > 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)