-- Calcite based automatic query rewrite should be disabled inside view creation
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.materializedview.rewriting.sql=false;

create table t1(col0 int) STORED AS ORC TBLPROPERTIES ('transactional'='true');

insert into t1(col0) values (1),(3),(10),(NULL);

create materialized view mv1 as
select * from t1 where col0 > 2;

explain cbo
create view v1 as
select sub.* from (select * from t1 where col0 > 2) sub
where sub.col0 = 10;

create view v1 as
select sub.* from (select * from t1 where col0 > 2) sub
where sub.col0 = 10;

explain cbo
select * from v1;

select * from v1;