Krisztian Kasa created HIVE-30261:
-------------------------------------
Summary: Push a partial aggregation below an inner join
Key: HIVE-30261
URL: https://issues.apache.org/jira/browse/HIVE-30261
Project: Hive
Issue Type: Improvement
Components: Physical Optimizer
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa
In a star join followed by a GROUP BY, the fact table rows go through the
shuffle and the join before any aggregation happens. When the join keys and the
GROUP BY keys have few distinct values on the fact side, the rows could be
partially aggregated below the join first. Then far fewer rows are shuffled,
joined and aggregated.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)