Hi committers,

Could someone please review this ticket and my colleague's patch?
https://issues.apache.org/jira/browse/HIVE-22601

The following query produces a wrong result in the current stable
release of Hive (2.3.6 and 3.1.2).

SELECT stack(1, 'a', 'b', 'c') AS (c1, c2, c3)
UNION ALL
SELECT stack(1, 'd', 'e', 'f') AS (c1, c2, c3);

+---------+
| _u1.c3  |
+---------+
| c       |
| f       |
+---------+

The same issue happened for

select
 posexplode(split('1,4', ',')) as (seq, col)
union all
select
 posexplode(split('2,6', ',')) as (seq, col)

_u1.col
1
4
2
6

Thanks,
Makoto

Reply via email to