| -- SORT_QUERY_RESULTS |
| |
| set hive.support.concurrency=true; |
| set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; |
| set hive.strict.checks.cartesian.product=false; |
| set hive.stats.fetch.column.stats=true; |
| set hive.materializedview.rewriting=true; |
| |
| drop materialized view if exists mv_rebuild; |
| drop table if exists basetable_rebuild; |
| |
| create table basetable_rebuild (a int, b varchar(256), c decimal(10,2)) |
| stored as orc TBLPROPERTIES ('transactional'='true'); |
| |
| insert into basetable_rebuild values (1, 'alfred', 10.30),(2, 'bob', 3.14),(2, 'bonnie', 172342.2),(3, 'calvin', 978.76),(3, 'charlie', 9.8); |
| |
| create materialized view mv_rebuild as select a, b, sum(a) from basetable_rebuild group by a,b; |
| |
| select * from mv_rebuild; |
| |
| insert into basetable_rebuild values (4, 'amia', 7.5); |
| |
| select * from mv_rebuild; |
| |
| alter materialized view mv_rebuild rebuild; |
| |
| select * from mv_rebuild; |
| |
| drop materialized view mv_rebuild; |
| drop table basetable_rebuild; |