Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Duplicate
-
2.3.9, 3.1.2
-
None
-
None
Description
// 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' ;
The script above does not produce data in partition dt='1221'
Attachments
Issue Links
- duplicates
-
HIVE-21660 Wrong result when union all and later view with explode is used
- Closed