[HIVE-28489] Partitioning the input data of Grouping Set GroupBy operator

• Type: New Feature
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Component/s: Physical Optimizer
• Labels: hive-4.1.0-must pull-request-available
• Target Version/s: 4.1.0
• Assignee: Seonggon Namgung
• Reporter: Seonggon Namgung
• Created: 29/Aug/24 11:11
• Updated: 3 days ago 11:48

Description

GroupBy operator with grouping sets often emits too many rows, which becomes the bottleneck of query execution. To reduce the number output rows, this JIRA proposes partitioning the input data of such GroupBy operator.

Please check out the attached slides for detailed explanation.

Issue Links

• links to: GitHub Pull Request #5424