[IMPALA-11148] Unnesting from views work only when alias is provided

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 4.1.0
• Component/s: Frontend
• Labels: complextype
• Epic Link: Fix complex type related issues
• Epic Color: ghx-label-3
• Assignee: Unassigned
• Reporter: Gabor Kaszab
• Created: 22/Feb/22 16:14
• Updated: 04/Nov/22 15:31

Description

With IMPALA-9498 it is now possible to provide arrays in the select list. However, with that change some existing functionality seems broken. When doing a regular (joining) unnest from views we get an error:

> select id, arr1.item from view_arrays va, va.arr1;
ERROR: AnalysisException: Illegal column/field reference 'arr1.item' with intermediate collection 'arr1' of type 'ARRAY<INT>'

Meanwhile when doing the same with regular tables it works:

> select id, arr1.item from functional_orc_def.complextypes_arrays va, va.arr1;
+----+------+
| id | item |
+----+------+
| 1  | 1    |
| 1  | 2    |
| 1  | 3    |
| 1  | 4    |
| 1  | 5    |
| 2  | 1    |
| 2  | NULL |
| 2  | 3    |
| 2  | 4    |
| 2  | 5    |
| 3  | 10   |
| 3  | 9    |
| 3  | 8    |
| 4  | 10   |
| 5  | 10   |
| 5  | NULL |
| 5  | 12   |
| 7  | 1    |
| 7  | 2    |
| 10 | 1    |
| 10 | 2    |
| 10 | 3    |
+----+------+
Fetched 22 row(s) in 3.70s

Also, with the "query from view approach" it works if we provide an alias explicitly for the array:

select id, arr1.item from view_arrays va, va.arr1 arr1; 

Issue Links

• is related to: IMPALA-11452 Improve alias handling in CollectionTableRef
• relates to: IMPALA-9494 Support displaying complex types