Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Currently HiveSemiJoin rule looks for pattern where group by is on right side.
We can convert joins which have group by on left side (assuming group by keys are same as join keys and none of the columns are being projected from left side) to LEFT SEMI JOIN by swapping the inputs. e.g. queries such as:
explain select pp.p_partkey from (select distinct p_name from part) p join part pp on pp.p_name = p.p_name;
Attachments
Attachments
Issue Links
- links to