ql/src/test/queries/clientpositive/materialized_view_partitioned_create_rewrite_agg_2.q

set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;

CREATE TABLE t1(a int, b int, c int, d string, e float) STORED AS ORC TBLPROPERTIES ('transactional' = 'true');

INSERT INTO t1(a, b, c, d, e) VALUES
(1, 1, 1, 'one', 1.1),
(1, 4, 1, 'one', 4.2),
(2, 2, 2, 'two', 2.2),
(1, 10, 1, 'one', 10.1),
(2, 2, 2, 'two', 2.2),
(1, 3, 1, 'one', 3.1),
(null, 4, null, 'unknown', 4.6),
(null, 4, 2, 'unknown', 4.7);

CREATE MATERIALIZED VIEW mat1 PARTITIONED ON (a, c, d) STORED AS ORC TBLPROPERTIES ('transactional'='true', 'transactional_properties'='insert_only') AS
SELECT a, sum(b) sumb, c, d, sum(e) sume FROM t1 GROUP BY a, c, d;

INSERT INTO t1(a, b, c, d, e) VALUES
(1, 3, 1, 'one', 3.3),
(1, 110, 1, 'one', 110.11),
(null, 20, null, 'unknown', 20.22);

EXPLAIN CBO
ALTER MATERIALIZED VIEW mat1 REBUILD;
EXPLAIN
ALTER MATERIALIZED VIEW mat1 REBUILD;
ALTER MATERIALIZED VIEW mat1 REBUILD;

SELECT a, sumb, c, d, sume FROM mat1
order by a, c, d;

DROP MATERIALIZED VIEW mat1;

SELECT a, sum(b), c, d, sum(e) FROM t1 GROUP BY a, c, d
order by a, c, d;