[jira] [Assigned] (HIVE-18769) Vectorization: Disable vectorization of key-less outer joins
[ https://issues.apache.org/jira/browse/HIVE-18769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Matt McCline reassigned HIVE-18769: --- Assignee: Matt McCline (was: Gopal V) > 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)
[jira] [Assigned] (HIVE-18769) Vectorization: Disable vectorization of key-less outer joins
[ https://issues.apache.org/jira/browse/HIVE-18769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Matt McCline reassigned HIVE-18769: --- Assignee: Gopal V (was: Matt McCline) > 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: Gopal V >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)
[jira] [Assigned] (HIVE-18769) Vectorization: Disable vectorization of key-less outer joins
[ https://issues.apache.org/jira/browse/HIVE-18769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Matt McCline reassigned HIVE-18769: --- Assignee: Matt McCline (was: Gopal V) > 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 > > 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)
[jira] [Assigned] (HIVE-18769) Vectorization: Disable vectorization of key-less outer joins
[ https://issues.apache.org/jira/browse/HIVE-18769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gopal V reassigned HIVE-18769: -- Assignee: Gopal V > 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: Gopal V >Priority: Major > > 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)