[HIVE-21634] Materialized view rewriting over aggregate operators containing with grouping sets

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Materialized views
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 19/Apr/19 00:01
• Updated: 27/Feb/24 22:24
• Resolved: 24/Apr/19 15:54

Description

A possible approach to support rewriting queries with an aggregate with grouping sets is implementing a rule that splits the aggregate in the query into an aggregate without grouping sets (bottom) and an aggregate with grouping sets (top). Then the materialized view rewriting rule will trigger on the former.

Issue Links

• links to: GitHub Pull Request #602