[
https://issues.apache.org/jira/browse/HIVE-9743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14528920#comment-14528920
]
Vikram Dixit K commented on HIVE-9743:
--------------------------------------
[~mmccline] I checked the output of the test and it looks like queries have
hints added to them and the explain outputs have gone missing? In tez, the
equivalent for the Sort Merge Bucket Map Join Operator would be the Merge Join
Operator in the MapOperator. Can you remove hints and enable auto conversion to
smb join so that I can verify the plans.
> Incorrect result set for vectorized left outer join
> ---------------------------------------------------
>
> 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
> Assignee: Matt McCline
> Attachments: HIVE-9743.01.patch, HIVE-9743.02.patch,
> HIVE-9743.03.patch, HIVE-9743.04.patch, HIVE-9743.05.patch,
> HIVE-9743.06.patch, HIVE-9743.07.patch
>
>
> 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)
