[jira] [Created] (HIVE-19863) UNION query produce wrong results

[Vineet Garg (JIRA)]

Vineet Garg created HIVE-19863:
----------------------------------

             Summary: UNION query produce wrong results
                 Key: HIVE-19863
                 URL: https://issues.apache.org/jira/browse/HIVE-19863
             Project: Hive
          Issue Type: Bug
          Components: Query Planning
            Reporter: Vineet Garg
            Assignee: Vineet Garg


*Reproducer*
{code:sql}
SET hive.vectorized.execution.enabled=false;
set hive.map.aggr=false;

set hive.strict.checks.bucketing=false;
set hive.explain.user=true;

CREATE TABLE src1 (key STRING COMMENT 'default', value STRING COMMENT 
'default') STORED AS TEXTFILE;

LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv3.txt" INTO TABLE src1;

ANALYZE TABLE src1 COMPUTE STATISTICS;

ANALYZE TABLE src1 COMPUTE STATISTICS FOR COLUMNS key,value;


CREATE TABLE src (key STRING COMMENT 'default', value STRING COMMENT 'default') 
STORED AS TEXTFILE;

LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt" INTO TABLE src;

ANALYZE TABLE src COMPUTE STATISTICS;

ANALYZE TABLE src COMPUTE STATISTICS FOR COLUMNS key,value;

SELECT x.key, z.value, y.value
FROM src1 x JOIN src y ON (x.key = y.key) 
JOIN (select * from src1 union select * from src)z ON (x.value = z.value)
union
SELECT x.key, z.value, y.value
FROM src1 x JOIN src y ON (x.key = y.key) 
JOIN (select * from src1 union select * from src)z ON (x.value = z.value);
{code}

*Expected Result*
{code:sql}
128             val_128
146     val_146 val_146
150     val_150 val_150
213     val_213 val_213
224             val_224
238     val_238 val_238
255     val_255 val_255
273     val_273 val_273
278     val_278 val_278
311     val_311 val_311
369             val_369
401     val_401 val_401
406     val_406 val_406
66      val_66  val_66
98      val_98  val_98
{code}

*Actual Result*
{code:sql}
128
146     val_146
150     val_150
213     val_213
224
238     val_238
255     val_255
273     val_273
278     val_278
311     val_311
369
401     val_401
406     val_406
66      val_66
98      val_98
{code}

One whole column is missing from the result




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)