Csaba Ringhofer created IMPALA-11567:
----------------------------------------

             Summary: 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


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)

Reply via email to