http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out index 5a9024c..acb1e87 100644 --- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out @@ -82,12 +82,22 @@ SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds = '1' and b.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds = '1' and b.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -292,12 +302,24 @@ SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds is not null and b.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table1_n0@ds=2 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds is not null and b.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table1_n0@ds=2 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -526,12 +548,24 @@ SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds = '1' and b.ds is not null PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Input: default@test_table2_n0@ds=2 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds = '1' and b.ds is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0@ds=2 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -763,6 +797,11 @@ JOIN (select key, value from test_table2_n0 where ds = '1') b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) @@ -772,6 +811,11 @@ JOIN (select key, value from test_table2_n0 where ds = '1') b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -985,6 +1029,11 @@ JOIN (select key, concat(value, value) as v2 from test_table2_n0 where ds = '1') b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.v1, b.v2) @@ -994,6 +1043,11 @@ JOIN (select key, concat(value, value) as v2 from test_table2_n0 where ds = '1') b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1207,6 +1261,11 @@ JOIN (select key, value from test_table2_n0 where ds = '1') b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key+a.key, concat(a.value, b.value) @@ -1216,6 +1275,11 @@ JOIN (select key, value from test_table2_n0 where ds = '1') b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 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/bucketsortoptimize_insert_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out index e867859..28e43cf 100644 --- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out @@ -60,12 +60,22 @@ SELECT a.key, a.key2, concat(a.value, b.value) FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT a.key, a.key2, concat(a.value, b.value) FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -274,6 +284,11 @@ FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT subq1.key, subq1.key2, subq1.value from @@ -283,6 +298,11 @@ FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -494,12 +514,22 @@ SELECT a.key2, a.key, concat(a.value, b.value) FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT a.key2, a.key, concat(a.value, b.value) FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -643,6 +673,11 @@ FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT subq1.key2, subq1.key, subq1.value from @@ -652,6 +687,11 @@ FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -798,6 +838,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT subq2.key, subq2.key2, subq2.value from @@ -810,6 +855,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1033,6 +1083,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT subq2.k2, subq2.k1, subq2.value from @@ -1045,6 +1100,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1278,6 +1338,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table4@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table4 PARTITION (ds = '1') SELECT subq2.k2, subq2.k1, subq2.value from @@ -1290,6 +1355,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table4@ds=1 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/bucketsortoptimize_insert_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out index 82a7717..afd2975 100644 --- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out @@ -59,6 +59,11 @@ FROM test_table1_n20 a JOIN test_table2_n19 b ON a.key = b.key WHERE a.ds = '1' and b.ds = '1' and (a.key = 0 or a.key = 5) PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n20 +PREHOOK: Input: default@test_table1_n20@ds=1 +PREHOOK: Input: default@test_table2_n19 +PREHOOK: Input: default@test_table2_n19@ds=1 +PREHOOK: Output: default@test_table3_n11@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n11 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) @@ -66,6 +71,11 @@ FROM test_table1_n20 a JOIN test_table2_n19 b ON a.key = b.key WHERE a.ds = '1' and b.ds = '1' and (a.key = 0 or a.key = 5) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n20 +POSTHOOK: Input: default@test_table1_n20@ds=1 +POSTHOOK: Input: default@test_table2_n19 +POSTHOOK: Input: default@test_table2_n19@ds=1 +POSTHOOK: Output: default@test_table3_n11@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -271,6 +281,11 @@ JOIN (select key, value from test_table2_n19 where ds = '1' and (key = 0 or key = 5)) b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n20 +PREHOOK: Input: default@test_table1_n20@ds=1 +PREHOOK: Input: default@test_table2_n19 +PREHOOK: Input: default@test_table2_n19@ds=1 +PREHOOK: Output: default@test_table3_n11@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n11 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) @@ -280,6 +295,11 @@ JOIN (select key, value from test_table2_n19 where ds = '1' and (key = 0 or key = 5)) b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n20 +POSTHOOK: Input: default@test_table1_n20@ds=1 +POSTHOOK: Input: default@test_table2_n19 +POSTHOOK: Input: default@test_table2_n19@ds=1 +POSTHOOK: Output: default@test_table3_n11@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -490,6 +510,11 @@ JOIN ON a.key = b.key WHERE a.key = 0 or a.key = 5 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n20 +PREHOOK: Input: default@test_table1_n20@ds=1 +PREHOOK: Input: default@test_table2_n19 +PREHOOK: Input: default@test_table2_n19@ds=1 +PREHOOK: Output: default@test_table3_n11@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n11 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) @@ -500,6 +525,11 @@ JOIN ON a.key = b.key WHERE a.key = 0 or a.key = 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n20 +POSTHOOK: Input: default@test_table1_n20@ds=1 +POSTHOOK: Input: default@test_table2_n19 +POSTHOOK: Input: default@test_table2_n19@ds=1 +POSTHOOK: Output: default@test_table3_n11@ds=1 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/cbo_simple_select.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out b/ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out index e61300b..acf91bf 100644 --- a/ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out +++ b/ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out @@ -743,8 +743,14 @@ POSTHOOK: Input: default@cbo_t2@dt=2014 400 PREHOOK: query: EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -766,9 +772,15 @@ STAGE PLANS: PREHOOK: query: -- c_int is not null EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (2*cbo_t2.c_int) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- c_int is not null EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (2*cbo_t2.c_int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -790,9 +802,15 @@ STAGE PLANS: PREHOOK: query: -- c_int is 0 EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) = (cbo_t2.c_int) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- c_int is 0 EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) = (cbo_t2.c_int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -814,9 +832,15 @@ STAGE PLANS: PREHOOK: query: -- c_int is not null EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (NULL) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- c_int is not null EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (NULL) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -838,9 +862,15 @@ STAGE PLANS: PREHOOK: query: -- rewrite to NULL EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 2*cbo_t2.c_int) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- rewrite to NULL EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 2*cbo_t2.c_int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -862,9 +892,15 @@ STAGE PLANS: PREHOOK: query: -- no rewrite EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 0) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- no rewrite EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### 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/check_constraint.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/check_constraint.q.out b/ql/src/test/results/clientpositive/llap/check_constraint.q.out index be1084b..357dd9f 100644 --- a/ql/src/test/results/clientpositive/llap/check_constraint.q.out +++ b/ql/src/test/results/clientpositive/llap/check_constraint.q.out @@ -79,8 +79,12 @@ Column Name:bb Check Value:bb IN (23.4,56,4) PREHOOK: query: EXPLAIN INSERT INTO table1_n0 values(1,100,true, 5, 23.4, 700.5) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table1_n0 POSTHOOK: query: EXPLAIN INSERT INTO table1_n0 values(1,100,true, 5, 23.4, 700.5) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table1_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -230,8 +234,12 @@ Column Name:i Check Value:i + NULL > 0 PREHOOK: query: EXPLAIN INSERT INTO table2_n0 values(8) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table2_n0 POSTHOOK: query: EXPLAIN INSERT INTO table2_n0 values(8) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table2_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -330,8 +338,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@tudf PREHOOK: query: EXPLAIN INSERT INTO tudf values('function1') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tudf POSTHOOK: query: EXPLAIN INSERT INTO tudf values('function1') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tudf STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -461,8 +473,12 @@ Column Name:numclicks Check Value:numClicks > 0 PREHOOK: query: EXPLAIN INSERT INTO tmulti values('hive.apache.com', 'user1', 48, '12-01-2018') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tmulti POSTHOOK: query: EXPLAIN INSERT INTO tmulti values('hive.apache.com', 'user1', 48, '12-01-2018') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tmulti STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -620,8 +636,12 @@ Column Name:numclicks Check Value:numClicks > 0 PREHOOK: query: EXPLAIN INSERT INTO tmulti values('hive.apache.com', 'user1', 48, '12-01-2018') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tmulti POSTHOOK: query: EXPLAIN INSERT INTO tmulti values('hive.apache.com', 'user1', 48, '12-01-2018') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tmulti STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -765,8 +785,12 @@ Column Name:numclicks Check Value:numclicks > 0 PREHOOK: query: EXPLAIN INSERT INTO tcase values('hive.apache.com', 'user1', '12-01-2018', 48) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcase POSTHOOK: query: EXPLAIN INSERT INTO tcase values('hive.apache.com', 'user1', '12-01-2018', 48) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcase STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -911,8 +935,12 @@ Column Name:price Check Value:cast(numClicks as FLOAT)*price > 10.00 PREHOOK: query: EXPLAIN INSERT INTO tcast values('www.google.com', 100, cast(0.5 as float)) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcast POSTHOOK: query: EXPLAIN INSERT INTO tcast values('www.google.com', 100, cast(0.5 as float)) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcast STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -989,8 +1017,12 @@ POSTHOOK: Input: default@tcast www.google.com 100 0.5 PREHOOK: query: EXPLAIN INSERT INTO tcast(url, price) values('www.yahoo.com', 0.5) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcast POSTHOOK: query: EXPLAIN INSERT INTO tcast(url, price) values('www.yahoo.com', 0.5) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcast STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1142,8 +1174,12 @@ Column Name:b Check Value:((cast(d as float) + f) < cast(i as float) + (i PREHOOK: query: explain insert into texpr values(3,3.4,5.6,true) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@texpr POSTHOOK: query: explain insert into texpr values(3,3.4,5.6,true) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@texpr STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1294,8 +1330,12 @@ Column Name:vc Check Value:de >= cast(i as decimal(5,2)) PREHOOK: query: explain insert into table acid_uami_n0 select cast(key as int), cast (key as decimal(5,2)), value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain insert into table acid_uami_n0 select cast(key as int), cast (key as decimal(5,2)), value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1373,9 +1413,13 @@ POSTHOOK: Lineage: acid_uami_n0.vc EXPRESSION [(src)src.FieldSchema(name:value, PREHOOK: query: explain insert overwrite table acid_uami_n0 select cast(key as int), cast (key as decimal(5,2)), value from src order by cast(key as int) limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain insert overwrite table acid_uami_n0 select cast(key as int), cast (key as decimal(5,2)), value from src order by cast(key as int) limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1472,9 +1516,13 @@ POSTHOOK: Lineage: acid_uami_n0.vc EXPRESSION [(src)src.FieldSchema(name:value, PREHOOK: query: explain insert into table acid_uami_n0 select cast(s1.key as int) as c1, cast (s2.key as decimal(5,2)) as c2, s1.value from src s1 left outer join src s2 on s1.key=s2.key where s1.value > 'val' limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain insert into table acid_uami_n0 select cast(s1.key as int) as c1, cast (s2.key as decimal(5,2)) as c2, s1.value from src s1 left outer join src s2 on s1.key=s2.key where s1.value > 'val' limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1649,9 +1697,13 @@ POSTHOOK: Output: default@acid_uami_n0 PREHOOK: query: explain insert into table acid_uami_n0 select min(cast(key as int)) as c1, max(cast (key as decimal(5,2))) as c2, value from src group by key, value order by key, value limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain insert into table acid_uami_n0 select min(cast(key as int)) as c1, max(cast (key as decimal(5,2))) as c2, value from src group by key, value order by key, value limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1800,11 +1852,17 @@ from src insert into table acid_uami_n0 select cast(key as int), cast(key as decimal(5,2)), value where key < 10 insert overwrite table src_multi2_n0 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 +PREHOOK: Output: default@src_multi2_n0 POSTHOOK: query: explain from src insert into table acid_uami_n0 select cast(key as int), cast(key as decimal(5,2)), value where key < 10 insert overwrite table src_multi2_n0 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 +POSTHOOK: Output: default@src_multi2_n0 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1912,8 +1970,12 @@ POSTHOOK: Input: default@acid_uami_n0 #### A masked pattern was here #### PREHOOK: query: explain update acid_uami_n0 set de = 893.14 where de = 103.00 or de = 119.00 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_uami_n0 +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain update acid_uami_n0 set de = 893.14 where de = 103.00 or de = 119.00 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_uami_n0 +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2001,8 +2063,12 @@ POSTHOOK: query: ALTER table acid_uami_n0 drop constraint ch2 POSTHOOK: type: ALTERTABLE_DROPCONSTRAINT PREHOOK: query: explain update acid_uami_n0 set vc = 'apache_hive' where de = 893.14 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_uami_n0 +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain update acid_uami_n0 set vc = 'apache_hive' where de = 893.14 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_uami_n0 +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2164,11 +2230,21 @@ WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@nonacid +PREHOOK: Input: default@tmerge +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge POSTHOOK: query: explain MERGE INTO tmerge as t using nonacid as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@nonacid +POSTHOOK: Input: default@tmerge +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -2351,11 +2427,23 @@ WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@nonacid +PREHOOK: Input: default@tmerge +PREHOOK: Output: default@merge_tmp_table +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge POSTHOOK: query: explain MERGE INTO tmerge as t using nonacid as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@nonacid +POSTHOOK: Input: default@tmerge +POSTHOOK: Output: default@merge_tmp_table +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge STAGE DEPENDENCIES: Stage-4 is a root stage Stage-5 depends on stages: Stage-4 @@ -2592,10 +2680,20 @@ PREHOOK: query: explain MERGE INTO tmerge as t using nonacid as s ON t.key = s.k WHEN MATCHED AND s.key < 5 THEN DELETE WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@nonacid +PREHOOK: Input: default@tmerge +PREHOOK: Output: default@merge_tmp_table +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge POSTHOOK: query: explain MERGE INTO tmerge as t using nonacid as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@nonacid +POSTHOOK: Input: default@tmerge +POSTHOOK: Output: default@merge_tmp_table +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -2906,8 +3004,12 @@ Column Name:a Default Value:127Y PREHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(456) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@numericdatatype POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(456) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@numericdatatype STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3055,8 +3157,12 @@ Column Name:b Check Value:b in(4,5) PREHOOK: query: EXPLAIN INSERT INTO tcheck(a) values(1) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcheck POSTHOOK: query: EXPLAIN INSERT INTO tcheck(a) values(1) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcheck STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3130,8 +3236,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN INSERT INTO tcheck(b) values(4) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcheck POSTHOOK: query: EXPLAIN INSERT INTO tcheck(b) values(4) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcheck STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3242,8 +3352,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@part_mm PREHOOK: query: explain insert into table part_mm partition(key_mm=455) select key from src order by value limit 3 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@part_mm@key_mm=455 POSTHOOK: query: explain insert into table part_mm partition(key_mm=455) select key from src order by value limit 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@part_mm@key_mm=455 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3472,8 +3586,12 @@ Column Name:null Check Value:a != '' AND b > 4 PREHOOK: query: explain insert into tbl1_n1 values('a', 69) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tbl1_n1 POSTHOOK: query: explain insert into tbl1_n1 values('a', 69) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tbl1_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3600,8 +3718,12 @@ Column Name:null Check Value:(b < 100) PREHOOK: query: explain insert into tbl1_n1 values('a', 69) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tbl1_n1 POSTHOOK: query: explain insert into tbl1_n1 values('a', 69) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tbl1_n1 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/cluster.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/cluster.q.out b/ql/src/test/results/clientpositive/llap/cluster.q.out index 5e6a88b..056c4da 100644 --- a/ql/src/test/results/clientpositive/llap/cluster.q.out +++ b/ql/src/test/results/clientpositive/llap/cluster.q.out @@ -1,9 +1,13 @@ PREHOOK: query: EXPLAIN SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -70,9 +74,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT * FROM SRC x where x.key = 20 CLUSTER BY key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM SRC x where x.key = 20 CLUSTER BY key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -139,9 +147,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT x.* FROM SRC x where x.key = 20 CLUSTER BY key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.* FROM SRC x where x.key = 20 CLUSTER BY key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -208,9 +220,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT x.* FROM SRC x where x.key = 20 CLUSTER BY x.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.* FROM SRC x where x.key = 20 CLUSTER BY x.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -277,9 +293,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT x.key, x.value as v1 FROM SRC x where x.key = 20 CLUSTER BY key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value as v1 FROM SRC x where x.key = 20 CLUSTER BY key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -346,9 +366,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT x.key, x.value as v1 FROM SRC x where x.key = 20 CLUSTER BY x.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value as v1 FROM SRC x where x.key = 20 CLUSTER BY x.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -415,9 +439,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT x.key, x.value as v1 FROM SRC x where x.key = 20 CLUSTER BY v1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value as v1 FROM SRC x where x.key = 20 CLUSTER BY v1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -484,9 +512,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT y.* from (SELECT x.* FROM SRC x CLUSTER BY x.key) y where y.key = 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT y.* from (SELECT x.* FROM SRC x CLUSTER BY x.key) y where y.key = 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -553,9 +585,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -656,9 +692,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT x.key, x.value as v1, y.* FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value as v1, y.* FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -760,9 +800,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT x.key, x.value as v1, y.* FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY x.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value as v1, y.* FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY x.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -864,9 +908,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT x.key, x.value as v1, y.key as yk FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value as v1, y.key as yk FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -973,6 +1021,8 @@ FROM ( ) unioninput CLUSTER BY unioninput.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT unioninput.* FROM ( @@ -982,6 +1032,8 @@ FROM ( ) unioninput CLUSTER BY unioninput.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### 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/colstats_date_min_max.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/colstats_date_min_max.q.out b/ql/src/test/results/clientpositive/llap/colstats_date_min_max.q.out index 7754f3e..fd5e563 100644 --- a/ql/src/test/results/clientpositive/llap/colstats_date_min_max.q.out +++ b/ql/src/test/results/clientpositive/llap/colstats_date_min_max.q.out @@ -101,9 +101,13 @@ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"d\":\"true\" PREHOOK: query: explain select 'stats: FIL ~0 read',count(1) from d1 where d < '2010-03-01' PREHOOK: type: QUERY +PREHOOK: Input: default@d1 +#### A masked pattern was here #### POSTHOOK: query: explain select 'stats: FIL ~0 read',count(1) from d1 where d < '2010-03-01' POSTHOOK: type: QUERY +POSTHOOK: Input: default@d1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -132,9 +136,13 @@ Stage-0 PREHOOK: query: explain select 'stats: FIL estimate some read',count(1) from d1 where d < '2010-10-03' PREHOOK: type: QUERY +PREHOOK: Input: default@d1 +#### A masked pattern was here #### POSTHOOK: query: explain select 'stats: FIL estimate some read',count(1) from d1 where d < '2010-10-03' POSTHOOK: type: QUERY +POSTHOOK: Input: default@d1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -163,9 +171,13 @@ Stage-0 PREHOOK: query: explain select 'stats: FIL estimate all read',count(1) from d1 where d < '2010-11-03' PREHOOK: type: QUERY +PREHOOK: Input: default@d1 +#### A masked pattern was here #### POSTHOOK: query: explain select 'stats: FIL estimate all read',count(1) from d1 where d < '2010-11-03' POSTHOOK: type: QUERY +POSTHOOK: Input: default@d1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out b/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out index e8605da..5d57fb4 100644 --- a/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out +++ b/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out @@ -100,8 +100,12 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select count(1) from calendar_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from calendar_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -114,8 +118,12 @@ STAGE PLANS: PREHOOK: query: explain select max(year) from calendar_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select max(year) from calendar_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -235,8 +243,12 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(year) from calendar_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select max(year) from calendar_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -303,8 +315,12 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(year) from calendar_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select max(year) from calendar_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -370,8 +386,12 @@ POSTHOOK: Input: default@calendar_n0 2015 PREHOOK: query: explain select max(month) from calendar_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select max(month) from calendar_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -482,8 +502,12 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(year) from calendar_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select max(year) from calendar_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -505,8 +529,12 @@ POSTHOOK: Input: default@calendar_n0 2015 PREHOOK: query: explain select max(month) from calendar_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select max(month) from calendar_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -617,8 +645,12 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(month) from calendar_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select max(month) from calendar_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendar_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -693,8 +725,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(year) from calendarp where p=1 PREHOOK: type: QUERY +PREHOOK: Input: default@calendarp +PREHOOK: Input: default@calendarp@p=1 +#### A masked pattern was here #### POSTHOOK: query: explain select max(year) from calendarp where p=1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendarp +POSTHOOK: Input: default@calendarp@p=1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -813,8 +851,12 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(year) from calendarp where p=1 PREHOOK: type: QUERY +PREHOOK: Input: default@calendarp +#### A masked pattern was here #### POSTHOOK: query: explain select max(year) from calendarp where p=1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendarp +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -872,8 +914,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(year) from calendarp where p=1 PREHOOK: type: QUERY +PREHOOK: Input: default@calendarp +PREHOOK: Input: default@calendarp@p=1 +#### A masked pattern was here #### POSTHOOK: query: explain select max(year) from calendarp where p=1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@calendarp +POSTHOOK: Input: default@calendarp@p=1 +#### 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/column_access_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/column_access_stats.q.out b/ql/src/test/results/clientpositive/llap/column_access_stats.q.out index 37fe85c..646ee3a 100644 --- a/ql/src/test/results/clientpositive/llap/column_access_stats.q.out +++ b/ql/src/test/results/clientpositive/llap/column_access_stats.q.out @@ -77,6 +77,8 @@ Columns:p,val PREHOOK: query: EXPLAIN SELECT key FROM (SELECT key, val FROM T1_n127) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n127 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -107,6 +109,8 @@ Columns:key 8 PREHOOK: query: EXPLAIN SELECT k FROM (SELECT key as k, val as v FROM T1_n127) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n127 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -168,6 +172,8 @@ SELECT key as c FROM T1_n127 SELECT val as c FROM T1_n127 ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n127 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -256,6 +262,8 @@ SELECT key as c FROM T1_n127 SELECT key as c FROM T1_n127 ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n127 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -371,6 +379,9 @@ SELECT T1_n127.key FROM T1_n127 JOIN T2_n75 ON T1_n127.key = T2_n75.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n127 +PREHOOK: Input: default@t2_n75 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -504,6 +515,9 @@ SELECT * FROM T1_n127 JOIN T2_n75 ON T1_n127.key = T2_n75.key AND T1_n127.val = 3 and T2_n75.val = 3 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n127 +PREHOOK: Input: default@t2_n75 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -608,6 +622,9 @@ JOIN ) subq2 ON subq1.val = subq2.val PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n127 +PREHOOK: Input: default@t2_n75 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -723,6 +740,10 @@ FROM JOIN T3_n29 ON T3_n29.key = T4_n16.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n127 +PREHOOK: Input: default@t2_n75 +PREHOOK: Input: default@t3_n29 +#### 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/column_table_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out index 7034a74..6ea838a 100644 --- a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out +++ b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out @@ -54,8 +54,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain extended analyze table s compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@s +PREHOOK: Output: default@s +#### A masked pattern was here #### POSTHOOK: query: explain extended analyze table s compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@s +POSTHOOK: Output: default@s +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-2 depends on stages: Stage-0 @@ -311,8 +317,22 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain extended analyze table spart compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@spart +PREHOOK: Input: default@spart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@spart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@spart +PREHOOK: Output: default@spart@ds=2008-04-08/hr=11 +PREHOOK: Output: default@spart@ds=2008-04-08/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain extended analyze table spart compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@spart +POSTHOOK: Input: default@spart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@spart@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@spart +POSTHOOK: Output: default@spart@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@spart@ds=2008-04-08/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-2 depends on stages: Stage-0 @@ -721,8 +741,22 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain extended analyze table spart partition(ds,hr) compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@spart +PREHOOK: Input: default@spart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@spart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@spart +PREHOOK: Output: default@spart@ds=2008-04-08/hr=11 +PREHOOK: Output: default@spart@ds=2008-04-08/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain extended analyze table spart partition(ds,hr) compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@spart +POSTHOOK: Input: default@spart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@spart@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@spart +POSTHOOK: Output: default@spart@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@spart@ds=2008-04-08/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-2 depends on stages: Stage-0 @@ -1131,8 +1165,18 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain extended analyze table spart partition(hr="11") compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@spart +PREHOOK: Input: default@spart@ds=2008-04-08/hr=11 +PREHOOK: Output: default@spart +PREHOOK: Output: default@spart@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain extended analyze table spart partition(hr="11") compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@spart +POSTHOOK: Input: default@spart@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@spart +POSTHOOK: Output: default@spart@ds=2008-04-08/hr=11 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-2 depends on stages: Stage-0 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out index 3ea86e5..64562a0 100644 --- a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out +++ b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out @@ -57,8 +57,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain extended analyze table s_n0 compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@s_n0 +PREHOOK: Output: default@s_n0 +#### A masked pattern was here #### POSTHOOK: query: explain extended analyze table s_n0 compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@s_n0 +POSTHOOK: Output: default@s_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-2 depends on stages: Stage-0 @@ -314,8 +320,22 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain extended analyze table spart_n0 compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@spart_n0 +PREHOOK: Input: default@spart_n0@ds=2008-04-08/hr=11 +PREHOOK: Input: default@spart_n0@ds=2008-04-08/hr=12 +PREHOOK: Output: default@spart_n0 +PREHOOK: Output: default@spart_n0@ds=2008-04-08/hr=11 +PREHOOK: Output: default@spart_n0@ds=2008-04-08/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain extended analyze table spart_n0 compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@spart_n0 +POSTHOOK: Input: default@spart_n0@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@spart_n0@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@spart_n0 +POSTHOOK: Output: default@spart_n0@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@spart_n0@ds=2008-04-08/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-2 depends on stages: Stage-0 @@ -716,8 +736,18 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain extended analyze table spart_n0 partition(hr="11") compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@spart_n0 +PREHOOK: Input: default@spart_n0@ds=2008-04-08/hr=11 +PREHOOK: Output: default@spart_n0 +PREHOOK: Output: default@spart_n0@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain extended analyze table spart_n0 partition(hr="11") compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@spart_n0 +POSTHOOK: Input: default@spart_n0@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@spart_n0 +POSTHOOK: Output: default@spart_n0@ds=2008-04-08/hr=11 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-2 depends on stages: Stage-0 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out b/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out index aaa4ecc..eef365b 100644 --- a/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out +++ b/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out @@ -30,6 +30,9 @@ union all select 2 as id from tb2 limit 1) b on a.id=b.id PREHOOK: type: QUERY +PREHOOK: Input: default@tb1 +PREHOOK: Input: default@tb2 +#### A masked pattern was here #### POSTHOOK: query: explain select a.id from tb1 a left outer join @@ -38,6 +41,9 @@ union all select 2 as id from tb2 limit 1) b on a.id=b.id POSTHOOK: type: QUERY +POSTHOOK: Input: default@tb1 +POSTHOOK: Input: default@tb2 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out b/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out index 2b48970..54a73cd 100644 --- a/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out +++ b/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out @@ -55,8 +55,14 @@ POSTHOOK: Output: default@table3_n0 POSTHOOK: Lineage: table3_n0.id SCRIPT [] PREHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id where table1_n10.val = 't1val01' PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n10 +PREHOOK: Input: default@table3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id where table1_n10.val = 't1val01' POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n10 +POSTHOOK: Input: default@table3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -108,8 +114,16 @@ POSTHOOK: Input: default@table3_n0 3 t1val01 val106 PREHOOK: query: explain select table1_n10.id, table1_n10.val, table2_n6.val2 from table1_n10 inner join table2_n6 on table1_n10.val = 't1val01' and table1_n10.id = table2_n6.id left semi join table3_n0 on table1_n10.dimid = table3_n0.id PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n10 +PREHOOK: Input: default@table2_n6 +PREHOOK: Input: default@table3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select table1_n10.id, table1_n10.val, table2_n6.val2 from table1_n10 inner join table2_n6 on table1_n10.val = 't1val01' and table1_n10.id = table2_n6.id left semi join table3_n0 on table1_n10.dimid = table3_n0.id POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n10 +POSTHOOK: Input: default@table2_n6 +POSTHOOK: Input: default@table3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -178,8 +192,16 @@ POSTHOOK: Input: default@table3_n0 3 t1val01 t2val203 PREHOOK: query: explain select table1_n10.id, table1_n10.val, table2_n6.val2 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id inner join table2_n6 on table1_n10.val = 't1val01' and table1_n10.id = table2_n6.id PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n10 +PREHOOK: Input: default@table2_n6 +PREHOOK: Input: default@table3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select table1_n10.id, table1_n10.val, table2_n6.val2 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id inner join table2_n6 on table1_n10.val = 't1val01' and table1_n10.id = table2_n6.id POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n10 +POSTHOOK: Input: default@table2_n6 +POSTHOOK: Input: default@table3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -248,8 +270,14 @@ POSTHOOK: Input: default@table3_n0 3 t1val01 t2val203 PREHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid <> 100 PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n10 +PREHOOK: Input: default@table3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid <> 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n10 +POSTHOOK: Input: default@table3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -296,8 +324,14 @@ POSTHOOK: Input: default@table3_n0 #### A masked pattern was here #### PREHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid IN (100,200) PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n10 +PREHOOK: Input: default@table3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid IN (100,200) POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n10 +POSTHOOK: Input: default@table3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -346,8 +380,14 @@ POSTHOOK: Input: default@table3_n0 3 t1val01 val104 PREHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid = 200 PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n10 +PREHOOK: Input: default@table3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid = 200 POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n10 +POSTHOOK: Input: default@table3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -394,8 +434,14 @@ POSTHOOK: Input: default@table3_n0 #### A masked pattern was here #### PREHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid = 100 PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n10 +PREHOOK: Input: default@table3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid = 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n10 +POSTHOOK: Input: default@table3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -444,8 +490,14 @@ POSTHOOK: Input: default@table3_n0 3 t1val01 val104 PREHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n10 +PREHOOK: Input: default@table3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n10 +POSTHOOK: Input: default@table3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out b/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out index 3d0053c..abed87d 100644 --- a/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out +++ b/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out @@ -131,8 +131,14 @@ POSTHOOK: Input: default@table_19 POSTHOOK: Output: default@table_19 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT count(t2.smallint_col_15) FROM table_19 t1 INNER JOIN table_8 t2 ON t2.decimal0402_col_20 = t1.decimal0801_col_4 PREHOOK: type: QUERY +PREHOOK: Input: default@table_19 +PREHOOK: Input: default@table_8 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT count(t2.smallint_col_15) FROM table_19 t1 INNER JOIN table_8 t2 ON t2.decimal0402_col_20 = t1.decimal0801_col_4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@table_19 +POSTHOOK: Input: default@table_8 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -340,8 +346,14 @@ POSTHOOK: Input: default@table_8 2 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT count(t2.smallint_col_15) FROM table_19 t1 INNER JOIN table_8 t2 ON t2.decimal0402_col_20 = t1.decimal0801_col_4 PREHOOK: type: QUERY +PREHOOK: Input: default@table_19 +PREHOOK: Input: default@table_8 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT count(t2.smallint_col_15) FROM table_19 t1 INNER JOIN table_8 t2 ON t2.decimal0402_col_20 = t1.decimal0801_col_4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@table_19 +POSTHOOK: Input: default@table_8 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/correlationoptimizer1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/correlationoptimizer1.q.out b/ql/src/test/results/clientpositive/llap/correlationoptimizer1.q.out index 6316323..224d980 100644 --- a/ql/src/test/results/clientpositive/llap/correlationoptimizer1.q.out +++ b/ql/src/test/results/clientpositive/llap/correlationoptimizer1.q.out @@ -4,12 +4,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -154,12 +160,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -304,12 +316,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -448,12 +466,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x LEFT SEMI JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x LEFT SEMI JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -603,12 +627,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x LEFT SEMI JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x LEFT SEMI JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -758,12 +788,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -900,12 +936,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1042,12 +1084,18 @@ FROM (SELECT y.key AS key, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key) GROUP BY y.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT y.key AS key, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key) GROUP BY y.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1184,12 +1232,18 @@ FROM (SELECT y.key AS key, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key) GROUP BY y.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT y.key AS key, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key) GROUP BY y.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1325,11 +1379,17 @@ SELECT x.key, y.value, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value) GROUP BY x.key, y.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, y.value, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value) GROUP BY x.key, y.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1456,11 +1516,17 @@ SELECT x.key, y.value, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value) GROUP BY x.key, y.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, y.value, count(1) AS cnt FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value) GROUP BY x.key, y.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1588,12 +1654,18 @@ FROM (SELECT y.key AS key, count(1) AS cnt FROM src1 x RIGHT OUTER JOIN src y ON (x.key = y.key) GROUP BY y.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT y.key AS key, count(1) AS cnt FROM src1 x RIGHT OUTER JOIN src y ON (x.key = y.key) GROUP BY y.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1730,12 +1802,18 @@ FROM (SELECT y.key AS key, count(1) AS cnt FROM src1 x RIGHT OUTER JOIN src y ON (x.key = y.key) GROUP BY y.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT y.key AS key, count(1) AS cnt FROM src1 x RIGHT OUTER JOIN src y ON (x.key = y.key) GROUP BY y.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1872,12 +1950,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x RIGHT OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x RIGHT OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2014,12 +2098,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x RIGHT OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x RIGHT OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2156,12 +2246,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x FULL OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x FULL OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2298,12 +2394,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x FULL OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x FULL OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2440,12 +2542,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x FULL OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x FULL OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2582,12 +2690,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x FULL OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x FULL OUTER JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2724,12 +2838,18 @@ FROM (SELECT x.key AS key, x.value AS value, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key, x.value) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.value)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, x.value AS value, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key, x.value) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2875,12 +2995,18 @@ FROM (SELECT x.key AS key, x.value AS value, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key, x.value) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.value)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, x.value AS value, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key, x.value) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3026,12 +3152,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key AND x.value = y.value) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key AND x.value = y.value) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3176,12 +3308,18 @@ FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key AND x.value = y.value) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (SELECT x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key AND x.value = y.value) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1
