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)

Reply via email to