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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 4.1.0
• Fix Version/s: Impala 4.2.0, Impala 4.1.1
• Component/s: Frontend
• Labels: complextype
• Epic Color: ghx-label-13
• Assignee: Csaba Ringhofer
• Reporter: Csaba Ringhofer
• Created: 08/Sep/22 13:31
• Updated: 13/Oct/22 05:39
• Resolved: 13/Sep/22 07:45

Description

repro in Impala dev env:

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}

The error comes from here:
https://github.com/apache/impala/blob/37f44a58f3f9d515e9c74455037c654542ac6566/fe/src/main/java/org/apache/impala/analysis/TupleIsNullPredicate.java#L165