[
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)
