[jira] [Updated] (HIVE-26872) INSERT UNION with LATERAL VIEW does not produce data

["FangBO (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-26872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

FangBO updated HIVE-26872:
--------------------------
    Summary: INSERT UNION with LATERAL  VIEW does not produce data  (was: INSERT UNION with LATERAL  VIEW does not produce result)

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