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

["Tim Armstrong (Jira)" <ji...@apache.org>]

     [ 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)