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)

Reply via email to