hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "wenhe li (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-14529) Union All query returns incorrect results.
Date Fri, 12 Aug 2016 08:17:20 GMT
wenhe li created HIVE-14529:
-------------------------------

             Summary: Union All query returns incorrect results.
                 Key: HIVE-14529
                 URL: https://issues.apache.org/jira/browse/HIVE-14529
             Project: Hive
          Issue Type: Bug
          Components: Query Planning
    Affects Versions: 2.1.0
         Environment: Hadoop 2.6
Hive 2.1
            Reporter: wenhe li



create table dw_tmp.l_test1 (id bigint,val string,trans_date string) row format delimited
fields terminated by ' ' ;

create table dw_tmp.l_test2 (id bigint,val string,trans_date string) row format delimited
fields terminated by ' ' ;  


select * from dw_tmp.l_test1;

1       table_1      2016-08-11


select * from dw_tmp.l_test2;

2       table_2      2016-08-11


-- right like this

select 
    id,
    'table_1' ,
    trans_date
from dw_tmp.l_test1
union all
select 
    id,
    val,
    trans_date
from dw_tmp.l_test2 ;

1       table_1     2016-08-11
2       table_2     2016-08-11

-- incorrect

select 
    id,
    999,
    'table_1' ,
    trans_date
from dw_tmp.l_test1
union all
select 
    id,
    999,
    val,
    trans_date
from dw_tmp.l_test2 ;

1       999     table_1     2016-08-11
2       999     table_1     2016-08-11     <-- here is wrong

-- incorrect

select 
    id,
    999,
    666,
    'table_1' ,
    trans_date
from dw_tmp.l_test1
union all
select 
    id,
    999,
    666,
    val,
    trans_date
from dw_tmp.l_test2 ;

1       999     666     table_1 2016-08-11
2       999     666     table_1 2016-08-11     <-- here is wrong

-- right

select 
    id,
    999,
    'table_1' ,
    trans_date,
    '2016-11-11'
from dw_tmp.l_test1
union all
select 
    id,
    999,
    val,
    trans_date,
    trans_date
from dw_tmp.l_test2 ;

1       999     table_1 2016-08-11      2016-11-11
2       999     table_2 2016-08-11      2016-08-11




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message