Frédéric ESCANDELL created HIVE-19756: -----------------------------------------
Summary: Insert request with UNION ALL and lateral view explode Key: HIVE-19756 URL: https://issues.apache.org/jira/browse/HIVE-19756 Project: Hive Issue Type: Bug Environment: HDP 2.6.4 Reporter: Frédéric ESCANDELL Hi, While executing this code snippet, no data is inserted in the final table t3. By replacing UNION ALL by UNION or the "lateral view explode" the code works properly. {code:sql} DROP table t1; DROP table t2; DROP table t3; CREATE TABLE t1(cle string,valeur array<struct<v:string>>) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'; INSERT INTO table t1 select * from (select "a",array(named_struct('v','x'), named_struct('v','y'))) tmp; CREATE TABLE t2(cle string,valeur array<struct<v:string>>) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'; INSERT INTO table t2 select * from (select "b",array(named_struct('v','z'), named_struct('v','w'))) tmp; DROP view v1; DROP table t3; CREATE VIEW v1 (cle,valeur) AS select base.cle,val.v from (select cle,valeur from t1) as base lateral view explode(base.valeur) a as val union select base1.cle,val.v from (select cle,valeur from t2) as base1 lateral view explode(base1.valeur) a as val; CREATE TABLE t3(cle string,valeur string) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'; insert into t3 select * from v1; {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)