[ https://issues.apache.org/jira/browse/HIVE-26872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
FangBO resolved HIVE-26872. --------------------------- Resolution: Duplicate > INSERT UNION with LATERAL VIEW does not produce data > ----------------------------------------------------- > > Key: HIVE-26872 > URL: https://issues.apache.org/jira/browse/HIVE-26872 > Project: Hive > Issue Type: Bug > Components: Tez > Affects Versions: 2.3.9, 3.1.2 > Reporter: FangBO > Priority: Major > > {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)