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;