Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

HIVE MR VS TEZ difference result

Explorer

use tez and mr join self output difference result

example

sql

select * from (
select a,b form a
) t1 left join (
select b,c from a
) t2 on t1.b = t2.b
where t1.a = "300"

mr result : 0

tez result : 1

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

but my hive.enforce.bucketing is true

hdp 2.3.4

hive 1.2.1

tez 0.7

how can help ?

2 REPLIES 2

Explorer

wo can help ?

@Fan WeiWen

Could you paste the complete DDL of the table which you are querying?