Support Questions
Find answers, ask questions, and share your expertise

Mr and Tez give different results (joining ORC and normal txt tables )

Mr and Tez give different results (joining ORC and normal txt tables )

Explorer

I am using HDP: 2.5.

My view is a combination of ORC + txt tables

We are doing inner join and then left join

ex:

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 :

1)set hive.execution.engine=mr;

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

Properties

Questions:

1) why execution engine differ in result ?

2) which result is accurate ?

3) how to solve this issue ?

I have follow

https://community.hortonworks.com/questions/62918/hive-mr-vs-tez-difference-in-output-hi.html

(hive.enforce.bucketing = true) by default

3 REPLIES 3

Re: Mr and Tez give different results (joining ORC and normal txt tables )

Super Guru

Is this a new cluster using hdp 2.5 or upgraded from 2.3.x?

Re: Mr and Tez give different results (joining ORC and normal txt tables )

Explorer

Its a new cluster

Re: Mr and Tez give different results (joining ORC and normal txt tables )

Master Collaborator

Can you provide the explain plan for your query with the two execution engines?