[jira] [Created] (HIVE-9743) incorrect result set for left outer join when executed with tez versus mapreduce

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created HIVE-9743:
--------------------------------

             Summary: incorrect result set for left outer join when executed with tez versus mapreduce
                 Key: HIVE-9743
                 URL: https://issues.apache.org/jira/browse/HIVE-9743
             Project: Hive
          Issue Type: Bug
          Components: SQL
    Affects Versions: 0.14.0
            Reporter: N Campbell


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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)