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)