Support Questions

Find answers, ask questions, and share your expertise

Hive Left Join with Inner join giving wrong results in tez but works perfectly in MR,WHY?

avatar
New Contributor

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;

1 REPLY 1

avatar
Master Guru

What version of Apache Hive? What version of HDP?