[jira] [Created] (HIVE-26497) Support materialized views on Iceberg source tables

[Krisztian Kasa (Jira)]

Krisztian Kasa created HIVE-26497:
-

 Summary: Support materialized views on Iceberg source tables
 Key: HIVE-26497
 URL: https://issues.apache.org/jira/browse/HIVE-26497
 Project: Hive
  Issue Type: New Feature
  Components: Materialized views
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa


{code}
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;
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (HIVE-26498) Implement MV maintenance with Iceberg sources using full rebuild

[Krisztian Kasa (Jira)]

Krisztian Kasa created HIVE-26498:
-

 Summary: Implement MV maintenance with Iceberg sources using full 
rebuild
 Key: HIVE-26498
 URL: https://issues.apache.org/jira/browse/HIVE-26498
 Project: Hive
  Issue Type: Sub-task
  Components: Materialized views
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa


{code}
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;
{code}
MV full rebuild plan
{code}
CBO PLAN:
HiveProject(b=[$1], c=[$2])
  HiveFilter(condition=[>($2, 52)])
HiveTableScan(table=[[default, tbl_ice]], table:alias=[tbl_ice])
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)