[HIVE-26498] Implement MV maintenance with Iceberg sources using full rebuild

• Type: Sub-task
• 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: 25/Aug/22 13:06
• Updated: 12/Sep/22 16:07
• Resolved: 12/Sep/22 16:07

Description

set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;

create external table tbl_ice(a int, b string, c int) stored by iceberg stored as orc tblproperties ('format-version'='2');

insert into tbl_ice values (1, 'one', 50), (2, 'two', 51), (3, 'three', 52), (4, 'four', 53), (5, 'five', 54);

create materialized view mat1 as
select b, c from tbl_ice where c > 52;

insert into tbl_ice values (111, 'one', 55), (333, 'two', 56);

explain cbo
alter materialized view mat1 rebuild;

alter materialized view mat1 rebuild;

MV full rebuild plan

CBO PLAN:
HiveProject(b=[$1], c=[$2])
  HiveFilter(condition=[>($2, 52)])
    HiveTableScan(table=[[default, tbl_ice]], table:alias=[tbl_ice])

Issue Links

• links to: GitHub Pull Request #3552