Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Fri, 12 Aug 2016 08:17:20 +0000 (UTC)
From: "wenhe li (JIRA)" <jira@apache.org>
To: dev@hive.apache.org
Message-ID: <JIRA.12996873.1470989834000.290178.1470989840787@Atlassian.JIRA>
In-Reply-To: <JIRA.12996873.1470989834000@Atlassian.JIRA>
References: <JIRA.12996873.1470989834000@Atlassian.JIRA> <JIRA.12996873.1470989834648@arcas>
Subject: [jira] [Created] (HIVE-14530) Union All query returns incorrect
 results.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 12 Aug 2016 08:17:23 -0000

wenhe li created HIVE-14530:
-------------------------------

             Summary: Union All query returns incorrect results.
                 Key: HIVE-14530
                 URL: https://issues.apache.org/jira/browse/HIVE-14530
             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)