[jira] [Resolved] (IMPALA-11567) Error in left outer join if the right side is a subquery with complex types

["Csaba Ringhofer (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-11567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Csaba Ringhofer resolved IMPALA-11567.
--------------------------------------
    Fix Version/s: Impala 4.2.0
       Resolution: Fixed

> Error in left outer join if the right side is a subquery with complex types
> ---------------------------------------------------------------------------
>
>                 Key: IMPALA-11567
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11567
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>    Affects Versions: Impala 4.1.0
>            Reporter: Csaba Ringhofer
>            Assignee: Csaba Ringhofer
>            Priority: Major
>              Labels: complextype
>             Fix For: Impala 4.2.0
>
>
> repro in Impala dev env:
> {code}
> use functional_parquet;
> select a.id, a.int_1d, b.int_1d from (select id, unnest(int_1d) as int_1d from array_tbl) a left outer join (select id, int_1d from array_tbl) b on a.id = b.id;
> ERROR: IllegalStateException: Should not evaluate on complex type: SlotRef{label=int_1d, path=int_1d, type=ARRAY<INT>, id=6}
> {code}
> The error comes from here:
> https://github.com/apache/impala/blob/37f44a58f3f9d515e9c74455037c654542ac6566/fe/src/main/java/org/apache/impala/analysis/TupleIsNullPredicate.java#L165



--
This message was sent by Atlassian Jira
(v8.20.10#820010)