Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Duplicate
-
2.1.1, 2.2.0, 2.3.6, 3.1.2
-
None
Description
Only one column will be retained when putting UDTFs with multiple aliases and a top-level UNION together.
For example, the result of the following SQL should have three columns, c1, c2 and c3.
SELECT stack(1, 'a', 'b', 'c') AS (c1, c2, c3) UNION ALL SELECT stack(1, 'd', 'e', 'f') AS (c1, c2, c3);
However, It's only the c3 column which I can get.
+---------+ | _u1.c3 | +---------+ | c | | f | +---------+
Attachments
Attachments
Issue Links
- is duplicated by
-
HIVE-25754 Fix column projection for union all queries with multiple aliases
- Resolved
- links to