http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out index 5cb59ac..9822780 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out @@ -131,11 +131,17 @@ SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n3 +PREHOOK: Input: default@cmv_basetable_n6 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n3 +POSTHOOK: Input: default@cmv_basetable_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -235,9 +241,15 @@ POSTHOOK: Input: default@cmv_basetable_n6 PREHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n6 REBUILD PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n3 +PREHOOK: Input: default@cmv_basetable_n6 +PREHOOK: Output: default@cmv_mat_view_n6 POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n6 REBUILD POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n3 +POSTHOOK: Input: default@cmv_basetable_n6 +POSTHOOK: Output: default@cmv_mat_view_n6 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -435,11 +447,19 @@ SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n3 +PREHOOK: Input: default@cmv_basetable_n6 +PREHOOK: Input: default@cmv_mat_view_n6 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n3 +POSTHOOK: Input: default@cmv_basetable_n6 +POSTHOOK: Input: default@cmv_mat_view_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -490,9 +510,15 @@ POSTHOOK: Output: default@cmv_basetable_2_n3 PREHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n6 REBUILD PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n3 +PREHOOK: Input: default@cmv_basetable_n6 +PREHOOK: Output: default@cmv_mat_view_n6 POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n6 REBUILD POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n3 +POSTHOOK: Input: default@cmv_basetable_n6 +POSTHOOK: Output: default@cmv_mat_view_n6 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -645,11 +671,19 @@ SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n3 +PREHOOK: Input: default@cmv_basetable_n6 +PREHOOK: Input: default@cmv_mat_view_n6 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n3 +POSTHOOK: Input: default@cmv_basetable_n6 +POSTHOOK: Input: default@cmv_mat_view_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -701,9 +735,15 @@ POSTHOOK: Output: default@cmv_basetable_2_n3 PREHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n6 REBUILD PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n3 +PREHOOK: Input: default@cmv_basetable_n6 +PREHOOK: Output: default@cmv_mat_view_n6 POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n6 REBUILD POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n3 +POSTHOOK: Input: default@cmv_basetable_n6 +POSTHOOK: Output: default@cmv_mat_view_n6 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -856,11 +896,19 @@ SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n3 +PREHOOK: Input: default@cmv_basetable_n6 +PREHOOK: Input: default@cmv_mat_view_n6 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n3 +POSTHOOK: Input: default@cmv_basetable_n6 +POSTHOOK: Input: default@cmv_mat_view_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -916,9 +964,15 @@ POSTHOOK: Lineage: cmv_basetable_2_n3.d SCRIPT [] PREHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n6 REBUILD PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n3 +PREHOOK: Input: default@cmv_basetable_n6 +PREHOOK: Output: default@cmv_mat_view_n6 POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n6 REBUILD POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n3 +POSTHOOK: Input: default@cmv_basetable_n6 +POSTHOOK: Output: default@cmv_mat_view_n6 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1071,11 +1125,19 @@ SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n3 +PREHOOK: Input: default@cmv_basetable_n6 +PREHOOK: Input: default@cmv_mat_view_n6 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n6.a FROM cmv_basetable_n6 join cmv_basetable_2_n3 ON (cmv_basetable_n6.a = cmv_basetable_2_n3.a) WHERE cmv_basetable_2_n3.c > 10.10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n3 +POSTHOOK: Input: default@cmv_basetable_n6 +POSTHOOK: Input: default@cmv_mat_view_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage
http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out index 22e9a69..a637b2c 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out @@ -109,9 +109,15 @@ totalSize 326 PREHOOK: query: explain select a, c from cmv_basetable_n0 where a = 3 PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_n0 +PREHOOK: Input: default@cmv_mat_view2 +#### A masked pattern was here #### POSTHOOK: query: explain select a, c from cmv_basetable_n0 where a = 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_n0 +POSTHOOK: Input: default@cmv_mat_view2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -155,6 +161,8 @@ select * from ( (select a, c from cmv_basetable_n0 where d = 3) table2 on table1.a = table2.a) PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from ( (select a, c from cmv_basetable_n0 where a = 3) table1 @@ -162,6 +170,8 @@ select * from ( (select a, c from cmv_basetable_n0 where d = 3) table2 on table1.a = table2.a) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -263,9 +273,13 @@ POSTHOOK: Input: default@cmv_basetable_n0 PREHOOK: query: explain alter materialized view cmv_mat_view2 enable rewrite PREHOOK: type: ALTER_MATERIALIZED_VIEW_REWRITE +PREHOOK: Input: default@cmv_mat_view2 +PREHOOK: Output: default@cmv_mat_view2 POSTHOOK: query: explain alter materialized view cmv_mat_view2 enable rewrite POSTHOOK: type: ALTER_MATERIALIZED_VIEW_REWRITE +POSTHOOK: Input: default@cmv_mat_view2 +POSTHOOK: Output: default@cmv_mat_view2 STAGE DEPENDENCIES: Stage-0 is a root stage @@ -292,6 +306,9 @@ select * from ( (select a, c from cmv_basetable_n0 where d = 3) table2 on table1.a = table2.a) PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_n0 +PREHOOK: Input: default@cmv_mat_view2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from ( (select a, c from cmv_basetable_n0 where a = 3) table1 @@ -299,6 +316,9 @@ select * from ( (select a, c from cmv_basetable_n0 where d = 3) table2 on table1.a = table2.a) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_n0 +POSTHOOK: Input: default@cmv_mat_view2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -407,6 +427,8 @@ select * from ( (select a, c from cmv_basetable_n0 where d = 3) table2 on table1.a = table2.a) PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from ( (select a, c from cmv_basetable_n0 where a = 3) table1 @@ -414,6 +436,8 @@ select * from ( (select a, c from cmv_basetable_n0 where d = 3) table2 on table1.a = table2.a) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out index 0bef939..ecaefad 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out @@ -145,9 +145,15 @@ POSTHOOK: Input: database:db3 PREHOOK: query: explain select a, c from db1.cmv_basetable_n7 where a = 3 PREHOOK: type: QUERY +PREHOOK: Input: db1@cmv_basetable_n7 +PREHOOK: Input: db2@cmv_mat_view2_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select a, c from db1.cmv_basetable_n7 where a = 3 POSTHOOK: type: QUERY +POSTHOOK: Input: db1@cmv_basetable_n7 +POSTHOOK: Input: db2@cmv_mat_view2_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out index 085ca91..21bfa8d 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out @@ -79,6 +79,10 @@ CREATE MATERIALIZED VIEW cmv_mat_view_n1 AS WHERE cmv_basetable_2_n0.c > 10.0 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c PREHOOK: type: CREATE_MATERIALIZED_VIEW +PREHOOK: Input: default@cmv_basetable_2_n0 +PREHOOK: Input: default@cmv_basetable_n1 +PREHOOK: Output: database:default +PREHOOK: Output: default@cmv_mat_view_n1 POSTHOOK: query: EXPLAIN CREATE MATERIALIZED VIEW cmv_mat_view_n1 AS SELECT cmv_basetable_n1.a, cmv_basetable_2_n0.c @@ -86,6 +90,10 @@ CREATE MATERIALIZED VIEW cmv_mat_view_n1 AS WHERE cmv_basetable_2_n0.c > 10.0 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c POSTHOOK: type: CREATE_MATERIALIZED_VIEW +POSTHOOK: Input: default@cmv_basetable_2_n0 +POSTHOOK: Input: default@cmv_basetable_n1 +POSTHOOK: Output: database:default +POSTHOOK: Output: default@cmv_mat_view_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -239,12 +247,20 @@ FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_baset WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n0 +PREHOOK: Input: default@cmv_basetable_n1 +PREHOOK: Input: default@cmv_mat_view_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n1.a FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_basetable_2_n0.a) WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n0 +POSTHOOK: Input: default@cmv_basetable_n1 +POSTHOOK: Input: default@cmv_mat_view_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -313,12 +329,18 @@ FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_baset WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n0 +PREHOOK: Input: default@cmv_basetable_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n1.a FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_basetable_2_n0.a) WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n0 +POSTHOOK: Input: default@cmv_basetable_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -442,9 +464,17 @@ POSTHOOK: Input: default@cmv_basetable_n1 PREHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n1 REBUILD PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n0 +PREHOOK: Input: default@cmv_basetable_n1 +PREHOOK: Input: default@cmv_mat_view_n1 +PREHOOK: Output: default@cmv_mat_view_n1 POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n1 REBUILD POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n0 +POSTHOOK: Input: default@cmv_basetable_n1 +POSTHOOK: Input: default@cmv_mat_view_n1 +POSTHOOK: Output: default@cmv_mat_view_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -656,12 +686,20 @@ FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_baset WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n0 +PREHOOK: Input: default@cmv_basetable_n1 +PREHOOK: Input: default@cmv_mat_view_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n1.a FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_basetable_2_n0.a) WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n0 +POSTHOOK: Input: default@cmv_basetable_n1 +POSTHOOK: Input: default@cmv_mat_view_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -715,12 +753,18 @@ FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_baset WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n0 +PREHOOK: Input: default@cmv_basetable_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n1.a FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_basetable_2_n0.a) WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n0 +POSTHOOK: Input: default@cmv_basetable_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -857,12 +901,20 @@ FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_baset WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n0 +PREHOOK: Input: default@cmv_basetable_n1 +PREHOOK: Input: default@cmv_mat_view_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n1.a FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_basetable_2_n0.a) WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n0 +POSTHOOK: Input: default@cmv_basetable_n1 +POSTHOOK: Input: default@cmv_mat_view_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -940,12 +992,20 @@ FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_baset WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n0 +PREHOOK: Input: default@cmv_basetable_n1 +PREHOOK: Input: default@cmv_mat_view_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n1.a FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_basetable_2_n0.a) WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n0 +POSTHOOK: Input: default@cmv_basetable_n1 +POSTHOOK: Input: default@cmv_mat_view_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -997,12 +1057,18 @@ FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_baset WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n0 +PREHOOK: Input: default@cmv_basetable_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n1.a FROM cmv_basetable_n1 join cmv_basetable_2_n0 ON (cmv_basetable_n1.a = cmv_basetable_2_n0.a) WHERE cmv_basetable_2_n0.c > 10.10 GROUP BY cmv_basetable_n1.a, cmv_basetable_2_n0.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n0 +POSTHOOK: Input: default@cmv_basetable_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out index 0601ea7..21e3b78 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out @@ -79,6 +79,10 @@ CREATE MATERIALIZED VIEW cmv_mat_view_n3 DISABLE REWRITE TBLPROPERTIES('rewritin WHERE cmv_basetable_2_n1.c > 10.0 GROUP BY cmv_basetable_n3.a, cmv_basetable_2_n1.c PREHOOK: type: CREATE_MATERIALIZED_VIEW +PREHOOK: Input: default@cmv_basetable_2_n1 +PREHOOK: Input: default@cmv_basetable_n3 +PREHOOK: Output: database:default +PREHOOK: Output: default@cmv_mat_view_n3 POSTHOOK: query: EXPLAIN CREATE MATERIALIZED VIEW cmv_mat_view_n3 DISABLE REWRITE TBLPROPERTIES('rewriting.time.window'='5min') AS SELECT cmv_basetable_n3.a, cmv_basetable_2_n1.c @@ -86,6 +90,10 @@ CREATE MATERIALIZED VIEW cmv_mat_view_n3 DISABLE REWRITE TBLPROPERTIES('rewritin WHERE cmv_basetable_2_n1.c > 10.0 GROUP BY cmv_basetable_n3.a, cmv_basetable_2_n1.c POSTHOOK: type: CREATE_MATERIALIZED_VIEW +POSTHOOK: Input: default@cmv_basetable_2_n1 +POSTHOOK: Input: default@cmv_basetable_n3 +POSTHOOK: Output: database:default +POSTHOOK: Output: default@cmv_mat_view_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -286,12 +294,18 @@ FROM cmv_basetable_n3 join cmv_basetable_2_n1 ON (cmv_basetable_n3.a = cmv_baset WHERE cmv_basetable_2_n1.c > 10.10 GROUP BY cmv_basetable_n3.a, cmv_basetable_2_n1.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n1 +PREHOOK: Input: default@cmv_basetable_n3 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n3.a FROM cmv_basetable_n3 join cmv_basetable_2_n1 ON (cmv_basetable_n3.a = cmv_basetable_2_n1.a) WHERE cmv_basetable_2_n1.c > 10.10 GROUP BY cmv_basetable_n3.a, cmv_basetable_2_n1.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n1 +POSTHOOK: Input: default@cmv_basetable_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -438,9 +452,13 @@ POSTHOOK: Output: default@cmv_basetable_2_n1 PREHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n3 ENABLE REWRITE PREHOOK: type: ALTER_MATERIALIZED_VIEW_REWRITE +PREHOOK: Input: default@cmv_mat_view_n3 +PREHOOK: Output: default@cmv_mat_view_n3 POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n3 ENABLE REWRITE POSTHOOK: type: ALTER_MATERIALIZED_VIEW_REWRITE +POSTHOOK: Input: default@cmv_mat_view_n3 +POSTHOOK: Output: default@cmv_mat_view_n3 STAGE DEPENDENCIES: Stage-0 is a root stage @@ -511,12 +529,20 @@ FROM cmv_basetable_n3 join cmv_basetable_2_n1 ON (cmv_basetable_n3.a = cmv_baset WHERE cmv_basetable_2_n1.c > 10.10 GROUP BY cmv_basetable_n3.a, cmv_basetable_2_n1.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n1 +PREHOOK: Input: default@cmv_basetable_n3 +PREHOOK: Input: default@cmv_mat_view_n3 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n3.a FROM cmv_basetable_n3 join cmv_basetable_2_n1 ON (cmv_basetable_n3.a = cmv_basetable_2_n1.a) WHERE cmv_basetable_2_n1.c > 10.10 GROUP BY cmv_basetable_n3.a, cmv_basetable_2_n1.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n1 +POSTHOOK: Input: default@cmv_basetable_n3 +POSTHOOK: Input: default@cmv_mat_view_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -558,9 +584,17 @@ POSTHOOK: Input: default@cmv_mat_view_n3 PREHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n3 REBUILD PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n1 +PREHOOK: Input: default@cmv_basetable_n3 +PREHOOK: Input: default@cmv_mat_view_n3 +PREHOOK: Output: default@cmv_mat_view_n3 POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view_n3 REBUILD POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n1 +POSTHOOK: Input: default@cmv_basetable_n3 +POSTHOOK: Input: default@cmv_mat_view_n3 +POSTHOOK: Output: default@cmv_mat_view_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -818,12 +852,20 @@ FROM cmv_basetable_n3 join cmv_basetable_2_n1 ON (cmv_basetable_n3.a = cmv_baset WHERE cmv_basetable_2_n1.c > 10.10 GROUP BY cmv_basetable_n3.a, cmv_basetable_2_n1.c PREHOOK: type: QUERY +PREHOOK: Input: default@cmv_basetable_2_n1 +PREHOOK: Input: default@cmv_basetable_n3 +PREHOOK: Input: default@cmv_mat_view_n3 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT cmv_basetable_n3.a FROM cmv_basetable_n3 join cmv_basetable_2_n1 ON (cmv_basetable_n3.a = cmv_basetable_2_n1.a) WHERE cmv_basetable_2_n1.c > 10.10 GROUP BY cmv_basetable_n3.a, cmv_basetable_2_n1.c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cmv_basetable_2_n1 +POSTHOOK: Input: default@cmv_basetable_n3 +POSTHOOK: Input: default@cmv_mat_view_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out index 11c603e..ba4d76f 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out @@ -16,10 +16,17 @@ PREHOOK: query: EXPLAIN CREATE MATERIALIZED VIEW partition_mv_1 PARTITIONED ON (key) AS SELECT value, key FROM src_txn where key > 200 and key < 250 PREHOOK: type: CREATE_MATERIALIZED_VIEW +PREHOOK: Input: default@src_txn +PREHOOK: Output: database:default +PREHOOK: Output: default@partition_mv_1 +PREHOOK: Output: default@partition_mv_1 POSTHOOK: query: EXPLAIN CREATE MATERIALIZED VIEW partition_mv_1 PARTITIONED ON (key) AS SELECT value, key FROM src_txn where key > 200 and key < 250 POSTHOOK: type: CREATE_MATERIALIZED_VIEW +POSTHOOK: Input: default@src_txn +POSTHOOK: Output: database:default +POSTHOOK: Output: default@partition_mv_1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -212,9 +219,15 @@ Outdated for Rewriting: No PREHOOK: query: EXPLAIN SELECT * FROM partition_mv_1 where key = 238 PREHOOK: type: QUERY +PREHOOK: Input: default@partition_mv_1 +PREHOOK: Input: default@partition_mv_1@key=238 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM partition_mv_1 where key = 238 POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_mv_1 +POSTHOOK: Input: default@partition_mv_1@key=238 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -323,9 +336,15 @@ POSTHOOK: Lineage: partition_mv_2 PARTITION(value=val_249).key SIMPLE [(src_txn) PREHOOK: query: EXPLAIN SELECT * FROM partition_mv_2 where value = 'val_238' PREHOOK: type: QUERY +PREHOOK: Input: default@partition_mv_2 +PREHOOK: Input: default@partition_mv_2@value=val_238 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM partition_mv_2 where value = 'val_238' POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_mv_2 +POSTHOOK: Input: default@partition_mv_2@value=val_238 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -357,9 +376,77 @@ POSTHOOK: Input: default@partition_mv_2@value=val_238 PREHOOK: query: EXPLAIN SELECT value FROM partition_mv_2 where key = 238 PREHOOK: type: QUERY +PREHOOK: Input: default@partition_mv_2 +PREHOOK: Input: default@partition_mv_2@value=val_201 +PREHOOK: Input: default@partition_mv_2@value=val_202 +PREHOOK: Input: default@partition_mv_2@value=val_203 +PREHOOK: Input: default@partition_mv_2@value=val_205 +PREHOOK: Input: default@partition_mv_2@value=val_207 +PREHOOK: Input: default@partition_mv_2@value=val_208 +PREHOOK: Input: default@partition_mv_2@value=val_209 +PREHOOK: Input: default@partition_mv_2@value=val_213 +PREHOOK: Input: default@partition_mv_2@value=val_214 +PREHOOK: Input: default@partition_mv_2@value=val_216 +PREHOOK: Input: default@partition_mv_2@value=val_217 +PREHOOK: Input: default@partition_mv_2@value=val_218 +PREHOOK: Input: default@partition_mv_2@value=val_219 +PREHOOK: Input: default@partition_mv_2@value=val_221 +PREHOOK: Input: default@partition_mv_2@value=val_222 +PREHOOK: Input: default@partition_mv_2@value=val_223 +PREHOOK: Input: default@partition_mv_2@value=val_224 +PREHOOK: Input: default@partition_mv_2@value=val_226 +PREHOOK: Input: default@partition_mv_2@value=val_228 +PREHOOK: Input: default@partition_mv_2@value=val_229 +PREHOOK: Input: default@partition_mv_2@value=val_230 +PREHOOK: Input: default@partition_mv_2@value=val_233 +PREHOOK: Input: default@partition_mv_2@value=val_235 +PREHOOK: Input: default@partition_mv_2@value=val_237 +PREHOOK: Input: default@partition_mv_2@value=val_238 +PREHOOK: Input: default@partition_mv_2@value=val_239 +PREHOOK: Input: default@partition_mv_2@value=val_241 +PREHOOK: Input: default@partition_mv_2@value=val_242 +PREHOOK: Input: default@partition_mv_2@value=val_244 +PREHOOK: Input: default@partition_mv_2@value=val_247 +PREHOOK: Input: default@partition_mv_2@value=val_248 +PREHOOK: Input: default@partition_mv_2@value=val_249 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT value FROM partition_mv_2 where key = 238 POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_mv_2 +POSTHOOK: Input: default@partition_mv_2@value=val_201 +POSTHOOK: Input: default@partition_mv_2@value=val_202 +POSTHOOK: Input: default@partition_mv_2@value=val_203 +POSTHOOK: Input: default@partition_mv_2@value=val_205 +POSTHOOK: Input: default@partition_mv_2@value=val_207 +POSTHOOK: Input: default@partition_mv_2@value=val_208 +POSTHOOK: Input: default@partition_mv_2@value=val_209 +POSTHOOK: Input: default@partition_mv_2@value=val_213 +POSTHOOK: Input: default@partition_mv_2@value=val_214 +POSTHOOK: Input: default@partition_mv_2@value=val_216 +POSTHOOK: Input: default@partition_mv_2@value=val_217 +POSTHOOK: Input: default@partition_mv_2@value=val_218 +POSTHOOK: Input: default@partition_mv_2@value=val_219 +POSTHOOK: Input: default@partition_mv_2@value=val_221 +POSTHOOK: Input: default@partition_mv_2@value=val_222 +POSTHOOK: Input: default@partition_mv_2@value=val_223 +POSTHOOK: Input: default@partition_mv_2@value=val_224 +POSTHOOK: Input: default@partition_mv_2@value=val_226 +POSTHOOK: Input: default@partition_mv_2@value=val_228 +POSTHOOK: Input: default@partition_mv_2@value=val_229 +POSTHOOK: Input: default@partition_mv_2@value=val_230 +POSTHOOK: Input: default@partition_mv_2@value=val_233 +POSTHOOK: Input: default@partition_mv_2@value=val_235 +POSTHOOK: Input: default@partition_mv_2@value=val_237 +POSTHOOK: Input: default@partition_mv_2@value=val_238 +POSTHOOK: Input: default@partition_mv_2@value=val_239 +POSTHOOK: Input: default@partition_mv_2@value=val_241 +POSTHOOK: Input: default@partition_mv_2@value=val_242 +POSTHOOK: Input: default@partition_mv_2@value=val_244 +POSTHOOK: Input: default@partition_mv_2@value=val_247 +POSTHOOK: Input: default@partition_mv_2@value=val_248 +POSTHOOK: Input: default@partition_mv_2@value=val_249 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -465,9 +552,12 @@ POSTHOOK: Lineage: src_txn.value SCRIPT [] PREHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW partition_mv_1 REBUILD PREHOOK: type: QUERY +PREHOOK: Input: default@src_txn +PREHOOK: Output: default@partition_mv_1 POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW partition_mv_1 REBUILD POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_txn STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -837,9 +927,14 @@ POSTHOOK: Lineage: src_txn.value SCRIPT [] PREHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW partition_mv_3 REBUILD PREHOOK: type: QUERY +PREHOOK: Input: default@src_txn +PREHOOK: Input: default@src_txn_2 +PREHOOK: Output: default@partition_mv_3 POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW partition_mv_3 REBUILD POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_txn +POSTHOOK: Input: default@src_txn_2 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_2.q.out index ab03522..016e306 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_2.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_2.q.out @@ -335,9 +335,41 @@ POSTHOOK: Lineage: partition_mv_4 PARTITION(key=226).value SIMPLE [(src_txn_2)sr PREHOOK: query: EXPLAIN SELECT * FROM src_txn_2 where key > 210 and key < 230 PREHOOK: type: QUERY +PREHOOK: Input: default@partition_mv_1 +PREHOOK: Input: default@partition_mv_1@key=213 +PREHOOK: Input: default@partition_mv_1@key=214 +PREHOOK: Input: default@partition_mv_1@key=216 +PREHOOK: Input: default@partition_mv_1@key=217 +PREHOOK: Input: default@partition_mv_1@key=218 +PREHOOK: Input: default@partition_mv_1@key=219 +PREHOOK: Input: default@partition_mv_1@key=221 +PREHOOK: Input: default@partition_mv_1@key=222 +PREHOOK: Input: default@partition_mv_1@key=223 +PREHOOK: Input: default@partition_mv_1@key=224 +PREHOOK: Input: default@partition_mv_1@key=226 +PREHOOK: Input: default@partition_mv_1@key=228 +PREHOOK: Input: default@partition_mv_1@key=229 +PREHOOK: Input: default@src_txn_2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src_txn_2 where key > 210 and key < 230 POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_mv_1 +POSTHOOK: Input: default@partition_mv_1@key=213 +POSTHOOK: Input: default@partition_mv_1@key=214 +POSTHOOK: Input: default@partition_mv_1@key=216 +POSTHOOK: Input: default@partition_mv_1@key=217 +POSTHOOK: Input: default@partition_mv_1@key=218 +POSTHOOK: Input: default@partition_mv_1@key=219 +POSTHOOK: Input: default@partition_mv_1@key=221 +POSTHOOK: Input: default@partition_mv_1@key=222 +POSTHOOK: Input: default@partition_mv_1@key=223 +POSTHOOK: Input: default@partition_mv_1@key=224 +POSTHOOK: Input: default@partition_mv_1@key=226 +POSTHOOK: Input: default@partition_mv_1@key=228 +POSTHOOK: Input: default@partition_mv_1@key=229 +POSTHOOK: Input: default@src_txn_2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -416,9 +448,29 @@ POSTHOOK: Input: default@src_txn_2 PREHOOK: query: EXPLAIN SELECT * FROM src_txn_2 where value > 'val_220' and value < 'val_230' PREHOOK: type: QUERY +PREHOOK: Input: default@partition_mv_2 +PREHOOK: Input: default@partition_mv_2@value=val_221 +PREHOOK: Input: default@partition_mv_2@value=val_222 +PREHOOK: Input: default@partition_mv_2@value=val_223 +PREHOOK: Input: default@partition_mv_2@value=val_224 +PREHOOK: Input: default@partition_mv_2@value=val_226 +PREHOOK: Input: default@partition_mv_2@value=val_228 +PREHOOK: Input: default@partition_mv_2@value=val_229 +PREHOOK: Input: default@src_txn_2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src_txn_2 where value > 'val_220' and value < 'val_230' POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_mv_2 +POSTHOOK: Input: default@partition_mv_2@value=val_221 +POSTHOOK: Input: default@partition_mv_2@value=val_222 +POSTHOOK: Input: default@partition_mv_2@value=val_223 +POSTHOOK: Input: default@partition_mv_2@value=val_224 +POSTHOOK: Input: default@partition_mv_2@value=val_226 +POSTHOOK: Input: default@partition_mv_2@value=val_228 +POSTHOOK: Input: default@partition_mv_2@value=val_229 +POSTHOOK: Input: default@src_txn_2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -473,9 +525,15 @@ POSTHOOK: Input: default@src_txn_2 PREHOOK: query: EXPLAIN SELECT * FROM src_txn_2 where key > 224 and key < 226 PREHOOK: type: QUERY +PREHOOK: Input: default@partition_mv_4 +PREHOOK: Input: default@src_txn_2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src_txn_2 where key > 224 and key < 226 POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_mv_4 +POSTHOOK: Input: default@src_txn_2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out index 3751ff1..2c838b6 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out @@ -16,10 +16,17 @@ PREHOOK: query: EXPLAIN CREATE MATERIALIZED VIEW partition_mv_sdp PARTITIONED ON (key) AS SELECT value, key FROM src_txn where key > 200 and key < 250 PREHOOK: type: CREATE_MATERIALIZED_VIEW +PREHOOK: Input: default@src_txn +PREHOOK: Output: database:default +PREHOOK: Output: default@partition_mv_sdp +PREHOOK: Output: default@partition_mv_sdp POSTHOOK: query: EXPLAIN CREATE MATERIALIZED VIEW partition_mv_sdp PARTITIONED ON (key) AS SELECT value, key FROM src_txn where key > 200 and key < 250 POSTHOOK: type: CREATE_MATERIALIZED_VIEW +POSTHOOK: Input: default@src_txn +POSTHOOK: Output: database:default +POSTHOOK: Output: default@partition_mv_sdp STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out index 99cdadf..735a4db 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out @@ -199,11 +199,19 @@ select * from (select * from emps_n3 where empid < 120) t join depts_n2 using (deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n2 +PREHOOK: Input: default@emps_n3 +PREHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select * from emps_n3 where empid < 120) t join depts_n2 using (deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n2 +POSTHOOK: Input: default@emps_n3 +POSTHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -338,11 +346,19 @@ select emps_n3.name, emps_n3.salary, emps_n3.commission from emps_n3 join depts_n2 using (deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n2 +PREHOOK: Input: default@emps_n3 +PREHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n3.name, emps_n3.salary, emps_n3.commission from emps_n3 join depts_n2 using (deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n2 +POSTHOOK: Input: default@emps_n3 +POSTHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -420,10 +436,18 @@ PREHOOK: query: explain select empid deptno from emps_n3 join depts_n2 using (deptno) where empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n2 +PREHOOK: Input: default@emps_n3 +PREHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select empid deptno from emps_n3 join depts_n2 using (deptno) where empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n2 +POSTHOOK: Input: default@emps_n3 +POSTHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -490,10 +514,16 @@ PREHOOK: query: explain select * from emps_n3 where empid > 120 union all select * from emps_n3 where empid < 150 PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n3 +PREHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n3 where empid > 120 union all select * from emps_n3 where empid < 150 POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n3 +POSTHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -610,9 +640,13 @@ POSTHOOK: Output: default@mv1_n2 PREHOOK: query: explain select empid, deptno from emps_n3 group by empid, deptno PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select empid, deptno from emps_n3 group by empid, deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -674,9 +708,13 @@ POSTHOOK: Output: default@mv1_n2 PREHOOK: query: explain select empid, name from emps_n3 group by empid, name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select empid, name from emps_n3 group by empid, name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -738,9 +776,15 @@ POSTHOOK: Output: default@mv1_n2 PREHOOK: query: explain select name, salary from emps_n3 group by name, salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n3 +PREHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select name, salary from emps_n3 group by name, salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n3 +POSTHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -803,9 +847,15 @@ POSTHOOK: Output: default@mv1_n2 PREHOOK: query: explain select name from emps_n3 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n3 +PREHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n3 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n3 +POSTHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -908,9 +958,15 @@ POSTHOOK: Output: default@mv1_n2 PREHOOK: query: explain select name from emps_n3 where deptno = 10 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n3 +PREHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n3 where deptno = 10 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n3 +POSTHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1014,9 +1070,15 @@ POSTHOOK: Output: default@mv1_n2 PREHOOK: query: explain select name from emps_n3 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n3 +PREHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n3 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n3 +POSTHOOK: Input: default@mv1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out index 2223764..714e0d2 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out @@ -71,10 +71,16 @@ PREHOOK: query: explain select deptno, avg(salary) as a from emps_n10 group by deptno PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n10 +PREHOOK: Input: default@mv1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select deptno, avg(salary) as a from emps_n10 group by deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n10 +POSTHOOK: Input: default@mv1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -140,10 +146,16 @@ PREHOOK: query: explain select salary, avg(salary) as a from emps_n10 group by salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n10 +PREHOOK: Input: default@mv1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select salary, avg(salary) as a from emps_n10 group by salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n10 +POSTHOOK: Input: default@mv1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -210,10 +222,16 @@ PREHOOK: query: explain select salary, avg(salary) as a from emps_n10 where salary > 0 group by salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n10 +PREHOOK: Input: default@mv1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select salary, avg(salary) as a from emps_n10 where salary > 0 group by salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n10 +POSTHOOK: Input: default@mv1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -325,10 +343,16 @@ PREHOOK: query: explain select avg(salary) from emps_n10_2 where salary > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n10_2 +PREHOOK: Input: default@mv1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select avg(salary) from emps_n10_2 where salary > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n10_2 +POSTHOOK: Input: default@mv1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out index 6b8d66f..d5afe3f 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out @@ -205,11 +205,19 @@ select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -285,11 +293,19 @@ select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -365,11 +381,19 @@ select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -445,11 +469,19 @@ select depts_n0.deptno from depts_n0 join emps_n0 using (deptno) where emps_n0.empid > 15 group by depts_n0.deptno, emps_n0.empid PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n0.deptno from depts_n0 join emps_n0 using (deptno) where emps_n0.empid > 15 group by depts_n0.deptno, emps_n0.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -530,11 +562,19 @@ select depts_n0.deptno from depts_n0 join emps_n0 using (deptno) where emps_n0.empid > 15 group by depts_n0.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n0.deptno from depts_n0 join emps_n0 using (deptno) where emps_n0.empid > 15 group by depts_n0.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -694,6 +734,11 @@ join emps_n0 on (emps_n0.deptno = depts_n0.deptno) where depts_n0.deptno > 10 group by dependents_n0.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n0 +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n0.empid from depts_n0 @@ -702,6 +747,11 @@ join emps_n0 on (emps_n0.deptno = depts_n0.deptno) where depts_n0.deptno > 10 group by dependents_n0.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n0 +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out index a2ac499..91f6982 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out @@ -202,10 +202,18 @@ PREHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n7 +PREHOOK: Input: default@emps_n9 +PREHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n7 +POSTHOOK: Input: default@emps_n9 +POSTHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -276,10 +284,18 @@ PREHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n7 +PREHOOK: Input: default@emps_n9 +PREHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n7 +POSTHOOK: Input: default@emps_n9 +POSTHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -354,10 +370,18 @@ PREHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n7 +PREHOOK: Input: default@emps_n9 +PREHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n7 +POSTHOOK: Input: default@emps_n9 +POSTHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -432,12 +456,22 @@ from depts_n7 join dependents_n5 on (depts_n7.name = dependents_n5.name) join emps_n9 on (emps_n9.deptno = depts_n7.deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n5 +PREHOOK: Input: default@depts_n7 +PREHOOK: Input: default@emps_n9 +PREHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n5.empid from depts_n7 join dependents_n5 on (depts_n7.name = dependents_n5.name) join emps_n9 on (emps_n9.deptno = depts_n7.deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n5 +POSTHOOK: Input: default@depts_n7 +POSTHOOK: Input: default@emps_n9 +POSTHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out index 6f67573..7c07024 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out @@ -200,10 +200,16 @@ PREHOOK: query: explain select name, count(*) as c, sum(empid) as s from emps_n5 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select name, count(*) as c, sum(empid) as s from emps_n5 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -314,10 +320,16 @@ PREHOOK: query: explain select salary, name, sum(empid) as s, count(*) as c from emps_n5 group by name, salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select salary, name, sum(empid) as s, count(*) as c from emps_n5 group by name, salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -390,11 +402,19 @@ select depts_n4.deptno, count(*) as c, sum(empid) as s from emps_n5 join depts_n4 using (deptno) group by depts_n4.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n4 +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n4.deptno, count(*) as c, sum(empid) as s from emps_n5 join depts_n4 using (deptno) group by depts_n4.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n4 +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -512,11 +532,19 @@ select depts_n4.deptno, sum(empid) as s from emps_n5 join depts_n4 using (deptno) where emps_n5.deptno > 10 group by depts_n4.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n4 +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n4.deptno, sum(empid) as s from emps_n5 join depts_n4 using (deptno) where emps_n5.deptno > 10 group by depts_n4.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n4 +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -633,11 +661,19 @@ select depts_n4.deptno, sum(empid) + 1 as s from emps_n5 join depts_n4 using (deptno) where depts_n4.deptno > 10 group by depts_n4.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n4 +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n4.deptno, sum(empid) + 1 as s from emps_n5 join depts_n4 using (deptno) where depts_n4.deptno > 10 group by depts_n4.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n4 +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -766,6 +802,11 @@ join depts_n4 on (emps_n5.deptno = depts_n4.deptno) join dependents_n3 on (depts_n4.name = dependents_n3.name) group by dependents_n3.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n3 +PREHOOK: Input: default@depts_n4 +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n3.empid, sum(salary) as s from emps_n5 @@ -773,6 +814,11 @@ join depts_n4 on (emps_n5.deptno = depts_n4.deptno) join dependents_n3 on (depts_n4.name = dependents_n3.name) group by dependents_n3.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n3 +POSTHOOK: Input: default@depts_n4 +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -940,12 +986,18 @@ from emps_n5 join dependents_n3 on (emps_n5.empid = dependents_n3.empid) group by dependents_n3.empid, emps_n5.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n3 +PREHOOK: Input: default@emps_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n5.deptno, count(distinct salary) as s from emps_n5 join dependents_n3 on (emps_n5.empid = dependents_n3.empid) group by dependents_n3.empid, emps_n5.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n3 +POSTHOOK: Input: default@emps_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out index 8d633aa..e4c939e 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out @@ -213,9 +213,15 @@ POSTHOOK: Output: default@mv1_n1 PREHOOK: query: explain select name from emps_n2 where deptno >= 20 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n2 where deptno >= 20 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -322,10 +328,16 @@ PREHOOK: query: explain select name, sum(empid) as s from emps_n2 where deptno > 15 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select name, sum(empid) as s from emps_n2 where deptno > 15 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -458,6 +470,12 @@ join emps_n2 on (emps_n2.deptno = depts_n1.deptno) where depts_n1.deptno > 11 and depts_n1.deptno < 19 group by dependents_n1.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@depts_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@locations_n1 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n1.empid from depts_n1 @@ -467,6 +485,12 @@ join emps_n2 on (emps_n2.deptno = depts_n1.deptno) where depts_n1.deptno > 11 and depts_n1.deptno < 19 group by dependents_n1.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@depts_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@locations_n1 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -593,9 +617,15 @@ POSTHOOK: Output: default@mv1_n1 PREHOOK: query: explain select deptno from emps_n2 group by deptno PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select deptno from emps_n2 group by deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -703,10 +733,16 @@ PREHOOK: query: explain select deptno, empid, sum(empid) as s, count(*) as c from emps_n2 group by empid, deptno PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select deptno, empid, sum(empid) as s, count(*) as c from emps_n2 group by empid, deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -784,6 +820,11 @@ join depts_n1 on (emps_n2.deptno = depts_n1.deptno) join dependents_n1 on (emps_n2.empid = dependents_n1.empid) group by dependents_n1.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@depts_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n1.empid, sum(salary) as s from emps_n2 @@ -791,6 +832,11 @@ join depts_n1 on (emps_n2.deptno = depts_n1.deptno) join dependents_n1 on (emps_n2.empid = dependents_n1.empid) group by dependents_n1.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@depts_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -916,6 +962,11 @@ join depts_n1 on (emps_n2.deptno = depts_n1.deptno) join dependents_n1 on (emps_n2.empid = dependents_n1.empid) group by depts_n1.name PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@depts_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n1.name, sum(salary) as s from emps_n2 @@ -923,6 +974,11 @@ join depts_n1 on (emps_n2.deptno = depts_n1.deptno) join dependents_n1 on (emps_n2.empid = dependents_n1.empid) group by depts_n1.name POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@depts_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1084,11 +1140,19 @@ select a.empid from (select * from emps_n2 where empid = 1) a join dependents_n1 on (a.empid = dependents_n1.empid) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select a.empid from (select * from emps_n2 where empid = 1) a join dependents_n1 on (a.empid = dependents_n1.empid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1166,11 +1230,19 @@ select a.empid from (select * from emps_n2 where empid = 1) a join dependents_n1 on (a.empid = dependents_n1.empid) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select a.empid from (select * from emps_n2 where empid = 1) a join dependents_n1 on (a.empid = dependents_n1.empid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1241,9 +1313,15 @@ POSTHOOK: Output: default@mv1_n1 PREHOOK: query: explain select empid from emps_n2 where empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n2 where empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1315,11 +1393,19 @@ select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1399,11 +1485,19 @@ select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1482,11 +1576,19 @@ select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.name = 'Sebastian' PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.name = 'Sebastian' POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out index ae43387..899e50a 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out @@ -216,10 +216,16 @@ PREHOOK: query: explain select salary, sum(empid) + 1 as s from emps where deptno > 10 group by salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select salary, sum(empid) + 1 as s from emps where deptno > 10 group by salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -335,10 +341,16 @@ PREHOOK: query: explain select salary + 1, sum(empid) + 1 as s from emps where deptno > 15 group by salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select salary + 1, sum(empid) + 1 as s from emps where deptno > 15 group by salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -460,12 +472,22 @@ from emps join depts on (emps.deptno = depts.deptno) join dependents on (depts.name = dependents.name) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents +PREHOOK: Input: default@depts +PREHOOK: Input: default@emps +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents.empid from emps join depts on (emps.deptno = depts.deptno) join dependents on (depts.name = dependents.name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents +POSTHOOK: Input: default@depts +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -611,6 +633,12 @@ join dependents on (depts.name = dependents.name) join locations on (locations.name = dependents.name) join emps on (emps.deptno = depts.deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents +PREHOOK: Input: default@depts +PREHOOK: Input: default@emps +PREHOOK: Input: default@locations +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents.empid from depts @@ -618,6 +646,12 @@ join dependents on (depts.name = dependents.name) join locations on (locations.name = dependents.name) join emps on (emps.deptno = depts.deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents +POSTHOOK: Input: default@depts +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@locations +POSTHOOK: Input: default@mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -787,6 +821,11 @@ join dependents on (emps.empid = dependents.empid) join depts a on (emps.deptno=a.deptno) where emps.name = 'Bill' PREHOOK: type: QUERY +PREHOOK: Input: default@dependents +PREHOOK: Input: default@depts +PREHOOK: Input: default@emps +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select emps.empid, dependents.empid, emps.deptno from emps @@ -794,6 +833,11 @@ join dependents on (emps.empid = dependents.empid) join depts a on (emps.deptno=a.deptno) where emps.name = 'Bill' POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents +POSTHOOK: Input: default@depts +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out index 4d9c6d6..6f00a5c 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out @@ -237,6 +237,12 @@ join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 10 group by dependents_n4.empid, depts_n6.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n4 +PREHOOK: Input: default@depts_n6 +PREHOOK: Input: default@emps_n8 +PREHOOK: Input: default@locations_n4 +PREHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n4.empid, depts_n6.deptno from depts_n6 @@ -246,6 +252,12 @@ join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 10 group by dependents_n4.empid, depts_n6.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n4 +POSTHOOK: Input: default@depts_n6 +POSTHOOK: Input: default@emps_n8 +POSTHOOK: Input: default@locations_n4 +POSTHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -536,6 +548,12 @@ join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 10 and depts_n6.deptno < 20 group by dependents_n4.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n4 +PREHOOK: Input: default@depts_n6 +PREHOOK: Input: default@emps_n8 +PREHOOK: Input: default@locations_n4 +PREHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n4.empid, count(emps_n8.salary) + 1 from depts_n6 @@ -545,6 +563,12 @@ join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 10 and depts_n6.deptno < 20 group by dependents_n4.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n4 +POSTHOOK: Input: default@depts_n6 +POSTHOOK: Input: default@emps_n8 +POSTHOOK: Input: default@locations_n4 +POSTHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -861,6 +885,11 @@ join dependents_n4 on (depts_n6.name = dependents_n4.name) join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n4 +PREHOOK: Input: default@depts_n6 +PREHOOK: Input: default@emps_n8 +PREHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n4.empid from depts_n6 @@ -868,6 +897,11 @@ join dependents_n4 on (depts_n6.name = dependents_n4.name) join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n4 +POSTHOOK: Input: default@depts_n6 +POSTHOOK: Input: default@emps_n8 +POSTHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out index 2030731..aa8763f 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out @@ -89,6 +89,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -96,6 +99,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -119,6 +125,9 @@ FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE LIMIT 100 PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -127,6 +136,9 @@ FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE LIMIT 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -152,6 +164,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select 1, @@ -160,6 +175,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -182,6 +200,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) + 0 AS DOWNLOAD_VOLUME_BYTES, @@ -189,6 +210,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -213,6 +237,9 @@ group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE ORDER BY A.MY_ID2 LIMIT 100 PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -222,6 +249,9 @@ group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE ORDER BY A.MY_ID2 LIMIT 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -280,11 +310,17 @@ select distinct A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select distinct A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -348,6 +384,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -356,6 +395,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -382,6 +424,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) + SUM(A.UP_VOLUME) AS TOTAL_VOLUME_BYTES, @@ -390,6 +435,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -414,12 +462,18 @@ SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -485,6 +539,9 @@ TO_DATE('2010-01-10') FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -492,6 +549,9 @@ TO_DATE('2010-01-10') FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -562,6 +622,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -570,6 +633,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out index 159e169..3c1de08 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out @@ -89,6 +89,9 @@ FLOOR(A.MY_DATE to hour),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to hour) PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001_mv_n0 +PREHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -96,6 +99,9 @@ FLOOR(A.MY_DATE to hour),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to hour) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001_mv_n0 +POSTHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -205,6 +211,9 @@ FLOOR(A.MY_DATE to day),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to day) PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001_mv_n0 +PREHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -212,6 +221,9 @@ FLOOR(A.MY_DATE to day),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to day) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001_mv_n0 +POSTHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -281,6 +293,9 @@ FLOOR(A.MY_DATE to hour),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to hour) PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001_mv_n0 +PREHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -288,6 +303,9 @@ FLOOR(A.MY_DATE to hour),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to hour) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001_mv_n0 +POSTHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -310,6 +328,8 @@ FLOOR(A.MY_DATE to second),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to second) PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -317,6 +337,8 @@ FLOOR(A.MY_DATE to second),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to second) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out index ac8cc35..610ab6d 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out @@ -43,9 +43,15 @@ POSTHOOK: Output: default@emps_mv_rewrite_empty_mv1 PREHOOK: query: explain select * from emps_mv_rewrite_empty where empid < 120 PREHOOK: type: QUERY +PREHOOK: Input: default@emps_mv_rewrite_empty +PREHOOK: Input: default@emps_mv_rewrite_empty_mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_mv_rewrite_empty where empid < 120 POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_mv_rewrite_empty +POSTHOOK: Input: default@emps_mv_rewrite_empty_mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage
