| set hive.support.concurrency=true; |
| set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; |
| |
| create table t1(col0 int, col1 int) stored as orc TBLPROPERTIES ('transactional'='true'); |
| |
| insert into t1(col0, col1) values |
| (1,1), |
| (2,1), |
| (2,2); |
| |
| create materialized view mat1 as |
| select col0, sum(col1) from t1 group by col0; |
| |
| explain |
| alter materialized view mat1 rebuild; |
| |
| alter materialized view mat1 rebuild; |
| |
| insert into t1(col0, col1) values(1,10); |
| |
| explain |
| alter materialized view mat1 rebuild; |
| |
| alter materialized view mat1 rebuild; |
| |
| drop materialized view mat1; |