[HIVE-22253] General task tracking improvements for materialized views

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Materialized views
• Assignee: Unassigned
• Reporter: Steve Carlin
• Created: 27/Sep/19 20:34
• Updated: 20/Jul/20 13:30

Description

We have a whole lot of tests from a different system that created and tested materialized views.

This Jira serves as the parent task for all the shortcomings that were found when running these tests on Hive

Issue Links

• is related to: HIVE-23884 SemanticAnalyzer exception when addressing field with table name in group by

Sub-Tasks

• Aggregate pushdown through join may generate additional rewriting opportunities: Open
• Ordinals in view are not being picked up in materialized view: Open
• Materialized view rewriting does not support `UNION` operator, exact match can work under view: Open
• Degenerate case where mv not being used: computing aggregate on group by field: Open