I am using HDP: 2.5.
My view is a combination of ORC + txt tables
We are doing inner join and then left join
select t.x , t4.y from (select x from table1 t1 join table2 t2 on t1.pp=t2.yy )t left join table4 t4 on t.xx=t4.yy
we are getting different result for MR and Tez(two termianl also shows difrant result )
Tried with enabling following properties :
by using property 1 : 2 terminal shows same result if i ran same command in different terminal in tez mode
but Mr and Tez shows different result
1) why execution engine differ in result ?
2) which result is accurate ?
3) how to solve this issue ?
I have follow
(hive.enforce.bucketing = true) by default
Can you provide the explain plan for your query with the two execution engines?