[HIVE-24992] Incremental rebuild of MV having aggregate in presence of delete operation

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: Materialized views
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 08/Apr/21 05:18
• Updated: 28/Apr/21 15:28
• Resolved: 28/Apr/21 15:28

Description

Extension of HIVE-24854: handle cases when the Materialized view definition has aggregation like

CREATE MATERIALIZED VIEW cmv_mat_view_n5 DISABLE REWRITE TBLPROPERTIES ('transactional'='true') AS
  SELECT cmv_basetable_n5.a, cmv_basetable_2_n2.c, sum(cmv_basetable_2_n2.d)
  FROM cmv_basetable_n5 JOIN cmv_basetable_2_n2 ON (cmv_basetable_n5.a = cmv_basetable_2_n2.a)
  WHERE cmv_basetable_2_n2.c > 10.0
  GROUP BY cmv_basetable_n5.a, cmv_basetable_2_n2.c;

Issue Links

• is related to: HIVE-24854 Incremental Materialized view refresh in presence of update/delete operations
• links to: GitHub Pull Request #2196