[IMPALA-11687] Select * with EXPAND_COMPLEX_TYPES=1 and explicit complex types fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: Frontend
• Epic Link: Display complex types
• Target Version: Impala 4.2.0
• Epic Color: ghx-label-2

Language

Java

• Assignee: Daniel Becker
• Reporter: Daniel Becker
• Created: 27/Oct/22 09:54
• Updated: 04/Nov/22 12:09
• Resolved: 04/Nov/22 11:55

Description

If EXPAND_COMPLEX_TYPES is set to true, some queries that combine star expressions and explicitly given complex columns fail:

select outer_struct, * from functional_orc_def.complextypes_nested_structs;
ERROR: IllegalStateException: Illegal reference to non-materialized slot: tid=1 sid=1

select *, outer_struct.str from functional_orc_def.complextypes_nested_structs;
ERROR: IllegalStateException: null

Having two stars in a table with complex columns also fails.

select *, * from functional_orc_def.complextypes_nested_structs;
ERROR: IllegalStateException: Illegal reference to non-materialized slot: tid=6 sid=13

Issue Links

• is related to: IMPALA-10838 Error when struct returned from WITH() and used in an ORDER BY
• is related to: IMPALA-9499 Display support for all complex types in a SELECT * query