[ https://issues.apache.org/jira/browse/HIVE-18769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16372516#comment-16372516 ]
Matt McCline edited comment on HIVE-18769 at 2/22/18 8:07 AM: -------------------------------------------------------------- NOTE: This patch does have a new Q file vector_outer_join_no_keys.q which is the query from the description but it needs tweaking so it demonstrates the problem. was (Author: mmccline): NOTE: This patch does not have a Q file that demonstrates the fix. > Vectorization: Disable vectorization of key-less outer joins > ------------------------------------------------------------ > > Key: HIVE-18769 > URL: https://issues.apache.org/jira/browse/HIVE-18769 > Project: Hive > Issue Type: Bug > Components: Vectorization > Affects Versions: 3.0.0 > Reporter: Gopal V > Assignee: Matt McCline > Priority: Major > Attachments: HIVE-18769.01.patch > > > Left & Right outer joins without keys are valid in SQL and they have > different semantics from cross-products > {code} > create temporary table foo(x int) stored as orc; > insert into foo values(1),(2); > create temporary table bar(y int) stored as orc; > select count(*) from bar right outer join foo; -- = 2 > select count(*) from bar, foo; -- = 0 > {code} > canSpecializeMapJoin should bail on these cases. -- This message was sent by Atlassian JIRA (v7.6.3#76005)