Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
3.0.0
-
None
-
None
Description
Left & Right outer joins without keys are valid in SQL and they have different semantics from cross-products
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
canSpecializeMapJoin should bail on these cases.