Major Description
This query is supposed to return 3 rows and will when run without Tez but returns 2 rows when run with Tez.
select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 )
tjoin1.rnum tjoin1.c1 tjoin1.c2 c2j2
1 20 25 <null>
2 <null> 50 <null>
instead of
tjoin1.rnum tjoin1.c1 tjoin1.c2 c2j2
0 10 15 <null>
1 20 25 <null>
2 <null> 50 <null>
create table if not exists TJOIN1 (RNUM int , C1 int, C2 int)
STORED AS orc ;
0|10|15
1|20|25
2|\N|50
create table if not exists TJOIN2 (RNUM int , C1 int, C2 char(2))
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
STORED AS TEXTFILE ;
0|10|BB
1|15|DD
2|\N|EE
3|10|FF