FangBO created HIVE-26872:
-----------------------------
Summary: INSERT UNION with LATERAL VIEW does not produce result
Key: HIVE-26872
URL: https://issues.apache.org/jira/browse/HIVE-26872
Project: Hive
Issue Type: Bug
Components: Tez
Affects Versions: 3.1.2, 2.3.9
Reporter: FangBO
{code:java}
// code placeholder
DROP TABLE union_test;
CREATE TABLE union_test(id INT) PARTITIONED BY (`dt` STRING);
DROP TABLE json_src;
CREATE TABLE json_src(message STRING) PARTITIONED BY (`dt` STRING);
INSERT OVERWRITE TABLE json_src PARTITION(dt='1219') VALUES('{"id":1}');
INSERT OVERWRITE TABLE json_src PARTITION(dt='1220') VALUES('{"id":2}');
INSERT OVERWRITE TABLE union_test PARTITION (dt='1221')
SELECT id FROM json_src LATERAL VIEW json_tuple(message, 'id') b AS id WHERE
dt='1219'
UNION ALL
SELECT id FROM json_src LATERAL VIEW json_tuple(message, 'id') b AS id WHERE
dt='1220'
; {code}
The script above does not produce data in partition dt='1221'
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
