HIVE MR VS TEZ difference result

[#1]

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]

wo can help ?

[#3]

@Fan WeiWen

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