Below sql query should return 1 record but giving 0 records in TEZ but in MR we are getting 1 record Create table emp1 (id int,name STRING); Create table emp2 (id int,name STRING); Create table emp3 (id int,name STRING); Insert into emp1 values(1,'A'); Insert into emp1 values(2,'A'); Insert into emp2 values(1,'A'); Insert into emp3 values(4,'A'); Select * from emp1 Left outer join emp3 on emp1.id=emp3.id and emp3.id=5 inner join emp2 on emp1.id=emp2.id; ... View more