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

["Vineet Garg (JIRA)" <ji...@apache.org>]

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

Vineet Garg reassigned HIVE-19863:
----------------------------------


> 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
>            Priority: Major
>
> *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)