-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/32549/
-----------------------------------------------------------
Review request for hive, Gunther Hagleitner and Vikram Dixit Kumaraswamy.
Repository: hive-git
Description
-------
In q.test environment with src table, execute the following query:
{code}
CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE;
CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE;
FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION all
select s2.key as key, s2.value as value from src s2) unionsrc
INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, COUNT(DISTINCT
SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key
INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value,
COUNT(DISTINCT SUBSTR(unionsrc.value,5))
GROUP BY unionsrc.key, unionsrc.value;
select * from DEST1;
select * from DEST2;
{code}
DEST1 and DEST2 should both have 310 rows. However, DEST2 only has 1 row "tst1
500 1"
Diffs
-----
itests/src/test/resources/testconfiguration.properties 288270e
ql/src/java/org/apache/hadoop/hive/ql/parse/GenTezWork.java e67d98b
ql/src/test/queries/clientpositive/tez_union_multiinsert.q PRE-CREATION
ql/src/test/results/clientpositive/tez/tez_union_multiinsert.q.out
PRE-CREATION
Diff: https://reviews.apache.org/r/32549/diff/
Testing
-------
Thanks,
pengcheng xiong
