[jira] [Created] (HIVE-18424) insert overwrite with union all get incorrect result when execution is tez

["Feng Liu (JIRA)" <ji...@apache.org>]

Feng Liu created HIVE-18424:
-------------------------------

             Summary: insert overwrite with union all get incorrect result when execution is tez  
                 Key: HIVE-18424
                 URL: https://issues.apache.org/jira/browse/HIVE-18424
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.2.1
         Environment: java1.8
hadoop-2.7.3
tez-0.8.5
hive-1.2.1

            Reporter: Feng Liu


when i use hive on tez execute insert overwrite with union all operations,the result i get is different .
1. mysql is :
     insert overwrite table test.dw_tra_code_map_da_test  partition(pt = '20171211000000')
select
     cast(t1.code as bigint) as code
    ,t1.data_type_code
    ,t1.te_code
from
(
    select
        code
        , 1 as data_type_code
        ,te_code as te_code
    from test.ods_fn_info_da
    where pt = '20171211000000'
    group by
        code
        ,te_code
union all
    select
        code
        ,2 as data_type_code
        ,xte_code_split as te_code
    from test.ods_fn_info_da
    lateral view explode(split(xte_code,'-')) t as xte_code_split
    where pt = '20171211000000'
)t1
;
select count(1) from test.dw_tra_code_map_da_test where pt= '20171211000000';
2. different results 
    the result of mr is :3517
    the result of tez is :1572 <--wrong result
3.i check the sql ,before insert overwrite ,the reuslt of mr and tez all 3517,after insert ,get the different result .




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)