http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/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 c683098..086878e 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 @@ -415,9 +447,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 @@ -471,9 +523,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/b356aae0/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 e25ef64..8735689 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/b356aae0/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 2ebe0df..efde607 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-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -479,10 +495,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 @@ -548,10 +572,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 @@ -666,9 +696,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 @@ -730,9 +764,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 @@ -794,9 +832,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 @@ -859,9 +903,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 @@ -964,9 +1014,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 @@ -1070,9 +1126,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/b356aae0/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/b356aae0/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 445f15a..a524fa9 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 @@ -284,11 +292,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 @@ -363,11 +379,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 @@ -442,11 +466,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 @@ -526,11 +558,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 @@ -656,6 +696,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 @@ -664,6 +709,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/b356aae0/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 683bb2c..129206d 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 @@ -275,10 +283,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 @@ -352,10 +368,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 @@ -429,12 +453,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/b356aae0/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 578f028..988d71a 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 @@ -632,11 +660,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 @@ -764,6 +800,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 @@ -771,6 +812,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 @@ -936,12 +982,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/b356aae0/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 61cdbff..637c772 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 @@ -321,10 +327,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 @@ -456,6 +468,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 @@ -465,6 +483,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 @@ -590,9 +614,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 @@ -700,10 +730,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 @@ -780,6 +816,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 @@ -787,6 +828,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 @@ -946,6 +992,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 @@ -953,6 +1004,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 @@ -1114,11 +1170,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 @@ -1196,11 +1260,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 @@ -1271,9 +1343,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 @@ -1345,11 +1423,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 @@ -1429,11 +1515,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 @@ -1512,11 +1606,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/b356aae0/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 073ef48..11fe979 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 @@ -334,10 +340,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 @@ -458,12 +470,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 @@ -607,6 +629,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 @@ -614,6 +642,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 @@ -780,6 +814,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 @@ -787,6 +826,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-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/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 2e8c1e3..4e9c703 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 @@ -528,6 +540,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 @@ -537,6 +555,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 @@ -845,6 +869,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 @@ -852,6 +881,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/b356aae0/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 eb2d7c6..06bef2f 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 @@ -381,6 +423,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, @@ -389,6 +434,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 @@ -412,12 +460,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 @@ -482,6 +536,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, @@ -489,6 +546,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 @@ -558,6 +618,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, @@ -566,6 +629,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/b356aae0/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/b356aae0/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 e988ea4..d4097dc 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 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_1.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_1.q.out index 29f9408..18a3f93 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_1.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_1.q.out @@ -209,11 +209,21 @@ select * from (select * from emps_n30 where empid < 120) t join depts_n20 using (deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select * from emps_n30 where empid < 120) t join depts_n20 using (deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -382,11 +392,23 @@ select emps_n30.name, emps_n30.salary, emps_n30.commission from emps_n30 join depts_n20 using (deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@deptno=10 +PREHOOK: Input: default@mv1_part_n2@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n30.name, emps_n30.salary, emps_n30.commission from emps_n30 join depts_n20 using (deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@deptno=10 +POSTHOOK: Input: default@mv1_part_n2@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -541,10 +563,18 @@ PREHOOK: query: explain select * from emps_n30 where empid > 120 union all select * from emps_n30 where empid < 150 PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n30 where empid > 120 union all select * from emps_n30 where empid < 150 POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -686,9 +716,23 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name, salary from emps_n30 group by name, salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Eric +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name, salary from emps_n30 group by name, salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Eric +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -784,9 +828,23 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name from emps_n30 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Eric +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n30 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Eric +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -916,9 +974,21 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name from emps_n30 where deptno = 10 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n30 where deptno = 10 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1061,9 +1131,23 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name from emps_n30 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Eric +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n30 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Eric +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_2.q.out index 6d1452c..8cf07fa 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_2.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_2.q.out @@ -212,11 +212,21 @@ select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -299,11 +309,21 @@ select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -386,11 +406,21 @@ select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -479,11 +509,23 @@ select depts_n00.deptno from depts_n00 join emps_n00 using (deptno) where emps_n00.empid > 15 group by depts_n00.deptno, emps_n00.empid PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=10 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n00.deptno from depts_n00 join emps_n00 using (deptno) where emps_n00.empid > 15 group by depts_n00.deptno, emps_n00.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=10 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -580,11 +622,23 @@ select depts_n00.deptno from depts_n00 join emps_n00 using (deptno) where emps_n00.empid > 15 group by depts_n00.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=10 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n00.deptno from depts_n00 join emps_n00 using (deptno) where emps_n00.empid > 15 group by depts_n00.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=10 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -733,6 +787,13 @@ join emps_n00 on (emps_n00.deptno = depts_n00.deptno) where depts_n00.deptno > 10 group by dependents_n00.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n00 +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno2=20 +PREHOOK: Input: default@mv1_part_n0@deptno2=30 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n00.empid from depts_n00 @@ -741,6 +802,13 @@ join emps_n00 on (emps_n00.deptno = depts_n00.deptno) where depts_n00.deptno > 10 group by dependents_n00.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n00 +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno2=20 +POSTHOOK: Input: default@mv1_part_n0@deptno2=30 +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out index 378c877..91f7ee3 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out @@ -661,6 +661,10 @@ where and lo_discount between 1 and 3 and lo_quantity < 25 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_extendedprice*lo_discount) as revenue @@ -672,6 +676,10 @@ where and lo_discount between 1 and 3 and lo_quantity < 25 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -740,6 +748,10 @@ where and lo_discount between 4 and 6 and lo_quantity between 26 and 35 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_extendedprice*lo_discount) as revenue @@ -751,6 +763,10 @@ where and lo_discount between 4 and 6 and lo_quantity between 26 and 35 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -820,6 +836,10 @@ where and lo_discount between 5 and 7 and lo_quantity between 26 and 35 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_extendedprice*lo_discount) as revenue @@ -832,6 +852,10 @@ where and lo_discount between 5 and 7 and lo_quantity between 26 and 35 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -905,6 +929,12 @@ group by order by d_year, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_revenue) as lo_revenue, d_year, p_brand1 @@ -921,6 +951,12 @@ group by order by d_year, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1015,6 +1051,12 @@ group by order by d_year, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_revenue) as lo_revenue, d_year, p_brand1 @@ -1031,6 +1073,12 @@ group by order by d_year, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1125,6 +1173,12 @@ group by order by d_year, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_revenue) as lo_revenue, d_year, p_brand1 @@ -1141,6 +1195,12 @@ group by order by d_year, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1237,6 +1297,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select c_nation, s_nation, d_year, @@ -1255,6 +1321,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1350,6 +1422,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue @@ -1367,6 +1445,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1462,6 +1546,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue @@ -1479,6 +1569,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1570,6 +1666,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue @@ -1587,6 +1689,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1684,6 +1792,13 @@ group by order by d_year, c_nation PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select d_year, c_nation, @@ -1703,6 +1818,13 @@ group by order by d_year, c_nation POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1797,6 +1919,13 @@ group by order by d_year, s_nation, p_category PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select d_year, s_nation, p_category, @@ -1817,6 +1946,13 @@ group by order by d_year, s_nation, p_category POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1911,6 +2047,13 @@ group by order by d_year, s_city, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select d_year, s_city, p_brand1, @@ -1931,6 +2074,13 @@ group by order by d_year, s_city, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1