http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_join29.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_join29.q.out b/ql/src/test/results/clientpositive/llap/auto_join29.q.out index 55f3797..9e4ada1 100644 --- a/ql/src/test/results/clientpositive/llap/auto_join29.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_join29.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value 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 @@ -617,9 +621,13 @@ NULL NULL NULL NULL 98 val_98 PREHOOK: query: explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value 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 @@ -1237,9 +1245,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value 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 @@ -1869,9 +1881,13 @@ NULL NULL 98 val_98 NULL NULL PREHOOK: query: explain SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value 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 @@ -2497,9 +2513,13 @@ NULL NULL NULL NULL 98 val_98 PREHOOK: query: explain SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value 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 @@ -2617,9 +2637,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value 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 @@ -3237,9 +3261,13 @@ NULL NULL NULL NULL 98 val_98 PREHOOK: query: explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value 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 @@ -3351,9 +3379,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value 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 @@ -3491,9 +3523,13 @@ NULL NULL 9 val_9 9 val_9 PREHOOK: query: explain SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value 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/auto_join30.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_join30.q.out b/ql/src/test/results/clientpositive/llap/auto_join30.q.out index 874511a..ec58793 100644 --- a/ql/src/test/results/clientpositive/llap/auto_join30.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_join30.q.out @@ -6,6 +6,8 @@ JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain FROM (SELECT src.* FROM src sort by key) x @@ -14,6 +16,8 @@ JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) 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 @@ -130,6 +134,8 @@ LEFT OUTER JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain FROM (SELECT src.* FROM src sort by key) x @@ -138,6 +144,8 @@ LEFT OUTER JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) 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 @@ -247,6 +255,8 @@ RIGHT OUTER JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain FROM (SELECT src.* FROM src sort by key) x @@ -255,6 +265,8 @@ RIGHT OUTER JOIN ON (x.key = Y.key) select sum(hash(Y.key,Y.value)) 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 @@ -366,6 +378,8 @@ JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain FROM (SELECT src.* FROM src sort by key) x @@ -377,6 +391,8 @@ JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) 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 @@ -525,6 +541,8 @@ LEFT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain FROM (SELECT src.* FROM src sort by key) x @@ -536,6 +554,8 @@ LEFT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) 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 @@ -678,6 +698,8 @@ LEFT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain FROM (SELECT src.* FROM src sort by key) x @@ -689,6 +711,8 @@ LEFT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) 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 @@ -831,6 +855,8 @@ RIGHT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain FROM (SELECT src.* FROM src sort by key) x @@ -842,6 +868,8 @@ RIGHT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) 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 @@ -984,6 +1012,8 @@ RIGHT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain FROM (SELECT src.* FROM src sort by key) x @@ -995,6 +1025,8 @@ RIGHT OUTER JOIN ON (x.key = Z.key) select sum(hash(Y.key,Y.value)) 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/auto_join_filters.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_join_filters.q.out b/ql/src/test/results/clientpositive/llap/auto_join_filters.q.out index 7290fac..d605110 100644 --- a/ql/src/test/results/clientpositive/llap/auto_join_filters.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_join_filters.q.out @@ -57,8 +57,12 @@ POSTHOOK: Input: default@myinput1_n5 Warning: Shuffle Join MERGEJOIN[14][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product PREHOOK: query: EXPLAIN SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1_n5 a FULL OUTER JOIN myinput1_n5 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n5 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1_n5 a FULL OUTER JOIN myinput1_n5 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -307,8 +311,12 @@ POSTHOOK: Input: default@myinput1_n5 4939870 PREHOOK: query: EXPLAIN SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1_n5 a FULL OUTER JOIN myinput1_n5 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n5 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1_n5 a FULL OUTER JOIN myinput1_n5 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -739,8 +747,12 @@ POSTHOOK: Input: default@myinput1_n5 4939870 PREHOOK: query: EXPLAIN SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1_n5 a FULL OUTER JOIN myinput1_n5 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n5 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1_n5 a FULL OUTER JOIN myinput1_n5 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_join_nulls.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_join_nulls.q.out b/ql/src/test/results/clientpositive/llap/auto_join_nulls.q.out index a160428..c69633b 100644 --- a/ql/src/test/results/clientpositive/llap/auto_join_nulls.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_join_nulls.q.out @@ -190,8 +190,12 @@ POSTHOOK: Input: default@myinput1_n2 4543526 PREHOOK: query: EXPLAIN SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1_n2 a FULL OUTER JOIN myinput1_n2 b ON a.key = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1_n2 a FULL OUTER JOIN myinput1_n2 b ON a.key = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out b/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out index 1c3c554..7d792ac 100644 --- a/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out @@ -43,11 +43,17 @@ select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key ) subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -149,6 +155,9 @@ select count(*) from group by key ) subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -159,6 +168,9 @@ select count(*) from group by key ) subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -299,6 +311,9 @@ join ) src2 on src1.key = src2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -316,6 +331,9 @@ join ) src2 on src1.key = src2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -532,6 +550,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1 a where key < 6) subq1 @@ -539,6 +560,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -646,6 +670,9 @@ select count(*) from join tbl2 b on subq2.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -658,6 +685,9 @@ select count(*) from join tbl2 b on subq2.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -782,6 +812,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -801,6 +833,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -925,6 +959,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2 a where key < 8) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl1 a where key < 8) subq1 @@ -932,6 +969,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2 a where key < 8) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1034,6 +1074,9 @@ select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2 a) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl1 a) subq1 @@ -1041,6 +1084,9 @@ select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2 a) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1159,11 +1205,17 @@ select count(*) from (select a.key as key, a.value as value from tbl1 a where key < 6) subq1 join tbl2 a on subq1.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1 a where key < 6) subq1 join tbl2 a on subq1.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1265,6 +1317,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2 a where key < 6) subq3 on (subq1.key = subq3.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1 a where key < 6) subq1 @@ -1275,6 +1330,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2 a where key < 6) subq3 on (subq1.key = subq3.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1403,6 +1461,9 @@ select count(*) from ( join tbl2 b on subq2.key = b.key) a PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select subq2.key as key, subq2.value as value1, b.value as value2 from @@ -1416,6 +1477,9 @@ select count(*) from ( join tbl2 b on subq2.key = b.key) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1546,6 +1610,10 @@ from ( insert overwrite table dest1_n2 select key, val1 insert overwrite table dest2_n0 select key, val1, val2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +PREHOOK: Output: default@dest1_n2 +PREHOOK: Output: default@dest2_n0 POSTHOOK: query: explain from ( select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key @@ -1553,6 +1621,10 @@ from ( insert overwrite table dest1_n2 select key, val1 insert overwrite table dest2_n0 select key, val1, val2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +POSTHOOK: Output: default@dest1_n2 +POSTHOOK: Output: default@dest2_n0 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1832,6 +1904,10 @@ from ( insert overwrite table dest1_n2 select key, val1 insert overwrite table dest2_n0 select key, count(*) group by key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1 +PREHOOK: Input: default@tbl2 +PREHOOK: Output: default@dest1_n2 +PREHOOK: Output: default@dest2_n0 POSTHOOK: query: explain from ( select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key @@ -1839,6 +1915,10 @@ from ( insert overwrite table dest1_n2 select key, val1 insert overwrite table dest2_n0 select key, count(*) group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1 +POSTHOOK: Input: default@tbl2 +POSTHOOK: Output: default@dest1_n2 +POSTHOOK: Output: default@dest2_n0 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out index fc37d0f..b4c7f98 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out @@ -101,8 +101,20 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n1@ds=2008-04-09 PREHOOK: query: explain extended select count(*) FROM bucket_small_n1 a JOIN bucket_big_n1 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n1 +PREHOOK: Input: default@bucket_big_n1@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n1@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n1 +PREHOOK: Input: default@bucket_small_n1@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n1 a JOIN bucket_big_n1 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n1 +POSTHOOK: Input: default@bucket_big_n1@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n1@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n1 +POSTHOOK: Input: default@bucket_small_n1@ds=2008-04-08 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_small_n1` @@ -387,8 +399,20 @@ POSTHOOK: Input: default@bucket_small_n1@ds=2008-04-08 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n1 a JOIN bucket_small_n1 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n1 +PREHOOK: Input: default@bucket_big_n1@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n1@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n1 +PREHOOK: Input: default@bucket_small_n1@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n1 a JOIN bucket_small_n1 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n1 +POSTHOOK: Input: default@bucket_big_n1@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n1@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n1 +POSTHOOK: Input: default@bucket_small_n1@ds=2008-04-08 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n1` @@ -673,8 +697,20 @@ POSTHOOK: Input: default@bucket_small_n1@ds=2008-04-08 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n1 a JOIN bucket_small_n1 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n1 +PREHOOK: Input: default@bucket_big_n1@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n1@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n1 +PREHOOK: Input: default@bucket_small_n1@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n1 a JOIN bucket_small_n1 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n1 +POSTHOOK: Input: default@bucket_big_n1@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n1@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n1 +POSTHOOK: Input: default@bucket_small_n1@ds=2008-04-08 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n1` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out index 3f1d832..f70fb4c 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out @@ -50,6 +50,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n4 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n5 +PREHOOK: Input: default@tbl2_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -62,6 +65,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n4 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n5 +POSTHOOK: Input: default@tbl2_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -216,6 +222,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n4 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n5 +PREHOOK: Input: default@tbl2_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, count(*) as value from tbl1_n5 a where key < 6 group by a.key) subq1 @@ -223,6 +232,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n4 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n5 +POSTHOOK: Input: default@tbl2_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out index d69e367..7273408 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out @@ -99,8 +99,20 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n11@ds=2008-04-09 PREHOOK: query: explain extended select count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n11 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n11 +PREHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n11 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n11 +POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_small_n11` @@ -413,8 +425,20 @@ POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 38 PREHOOK: query: explain extended select count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n11 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n11 +PREHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n11 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n11 +POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_small_n11` @@ -699,8 +723,20 @@ POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 38 PREHOOK: query: explain extended select /*+ mapjoin(a) */ count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n11 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n11 +PREHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select /*+ mapjoin(a) */ count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n11 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n11 +POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -970,8 +1006,20 @@ POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 38 PREHOOK: query: explain extended select /*+ MAPJOIN(a,b) */ count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key JOIN bucket_big_n11 c ON a.key = c.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n11 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n11 +PREHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select /*+ MAPJOIN(a,b) */ count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key JOIN bucket_big_n11 c ON a.key = c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n11 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n11 +POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### 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/auto_sortmerge_join_12.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out index 25f45b4..7962012 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out @@ -137,8 +137,24 @@ POSTHOOK: Output: default@bucket_medium@ds=2008-04-08 Warning: Shuffle Join MERGEJOIN[54][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain extended select count(*) FROM bucket_small_n15 a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big_n15 c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n15 +PREHOOK: Input: default@bucket_big_n15@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n15@ds=2008-04-09 +PREHOOK: Input: default@bucket_medium +PREHOOK: Input: default@bucket_medium@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n15 +PREHOOK: Input: default@bucket_small_n15@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n15 a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big_n15 c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n15 +POSTHOOK: Input: default@bucket_big_n15@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n15@ds=2008-04-09 +POSTHOOK: Input: default@bucket_medium +POSTHOOK: Input: default@bucket_medium@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n15 +POSTHOOK: Input: default@bucket_small_n15@ds=2008-04-08 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n15` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out index 11d72ef..1a28ce8 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out @@ -58,6 +58,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n2 +PREHOOK: Input: default@tbl2_n1 +PREHOOK: Output: default@dest1_n20 +PREHOOK: Output: default@dest2_n4 POSTHOOK: query: explain from ( SELECT a.key key1, a.value value1, b.key key2, b.value value2 @@ -66,6 +70,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n2 +POSTHOOK: Input: default@tbl2_n1 +POSTHOOK: Output: default@dest1_n20 +POSTHOOK: Output: default@dest2_n4 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -331,6 +339,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n2 +PREHOOK: Input: default@tbl2_n1 +PREHOOK: Output: default@dest1_n20 +PREHOOK: Output: default@dest2_n4 POSTHOOK: query: explain from ( SELECT a.key key1, a.value value1, b.key key2, b.value value2 @@ -339,6 +351,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n2 +POSTHOOK: Input: default@tbl2_n1 +POSTHOOK: Output: default@dest1_n20 +POSTHOOK: Output: default@dest2_n4 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -604,6 +620,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n2 +PREHOOK: Input: default@tbl2_n1 +PREHOOK: Output: default@dest1_n20 +PREHOOK: Output: default@dest2_n4 POSTHOOK: query: explain from ( SELECT a.key key1, a.value value1, b.key key2, b.value value2 @@ -612,6 +632,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n2 +POSTHOOK: Input: default@tbl2_n1 +POSTHOOK: Output: default@dest1_n20 +POSTHOOK: Output: default@dest2_n4 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out index 13ef018..ced0f68 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out @@ -37,9 +37,15 @@ POSTHOOK: Lineage: tbl2_n6.value SIMPLE [(src)src.FieldSchema(name:value, type:s PREHOOK: query: explain select count(*) FROM tbl1_n7 a LEFT OUTER JOIN tbl2_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n7 +PREHOOK: Input: default@tbl2_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n7 a LEFT OUTER JOIN tbl2_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n7 +POSTHOOK: Input: default@tbl2_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -132,9 +138,15 @@ POSTHOOK: Lineage: tbl2_n6.value SIMPLE [(src)src.FieldSchema(name:value, type:s PREHOOK: query: explain select count(*) FROM tbl1_n7 a RIGHT OUTER JOIN tbl2_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n7 +PREHOOK: Input: default@tbl2_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n7 a RIGHT OUTER JOIN tbl2_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n7 +POSTHOOK: Input: default@tbl2_n6 +#### 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/auto_sortmerge_join_15.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out index ef4a079..6615387 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out @@ -37,9 +37,15 @@ POSTHOOK: Lineage: tbl2_n10.value SIMPLE [(src)src.FieldSchema(name:value, type: PREHOOK: query: explain select count(*) FROM tbl1_n11 a LEFT OUTER JOIN tbl2_n10 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n11 +PREHOOK: Input: default@tbl2_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n11 a LEFT OUTER JOIN tbl2_n10 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n11 +POSTHOOK: Input: default@tbl2_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -111,9 +117,15 @@ STAGE PLANS: PREHOOK: query: explain select count(*) FROM tbl1_n11 a RIGHT OUTER JOIN tbl2_n10 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n11 +PREHOOK: Input: default@tbl2_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n11 a RIGHT OUTER JOIN tbl2_n10 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n11 +POSTHOOK: Input: default@tbl2_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out index 1fe234e..c02546a 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out @@ -165,6 +165,12 @@ PREHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as p on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n17 +PREHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +PREHOOK: Input: default@bucket_small_n17 +PREHOOK: Input: default@bucket_small_n17@pri=1 +PREHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as pri from ( select key, value @@ -176,6 +182,12 @@ POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n17 +POSTHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +POSTHOOK: Input: default@bucket_small_n17 +POSTHOOK: Input: default@bucket_small_n17@pri=1 +POSTHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -322,6 +334,12 @@ left outer join on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n17 +PREHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +PREHOOK: Input: default@bucket_small_n17 +PREHOOK: Input: default@bucket_small_n17@pri=1 +PREHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as pri from ( select key, value @@ -333,6 +351,12 @@ left outer join on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n17 +POSTHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +POSTHOOK: Input: default@bucket_small_n17 +POSTHOOK: Input: default@bucket_small_n17@pri=1 +POSTHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -566,6 +590,12 @@ PREHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as p on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n17 +PREHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +PREHOOK: Input: default@bucket_small_n17 +PREHOOK: Input: default@bucket_small_n17@pri=1 +PREHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as pri from ( select key, value @@ -577,6 +607,12 @@ POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n17 +POSTHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +POSTHOOK: Input: default@bucket_small_n17 +POSTHOOK: Input: default@bucket_small_n17@pri=1 +POSTHOOK: Input: default@bucket_small_n17@pri=2 +#### 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/auto_sortmerge_join_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out index 04683ef..c0b3f44 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out @@ -83,8 +83,20 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n3@ds=2008-04-09 PREHOOK: query: explain extended select count(*) FROM bucket_big_n3 a JOIN bucket_small_n3 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n3 +PREHOOK: Input: default@bucket_big_n3@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n3@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n3 +PREHOOK: Input: default@bucket_small_n3@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n3 a JOIN bucket_small_n3 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n3 +POSTHOOK: Input: default@bucket_big_n3@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n3@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n3 +POSTHOOK: Input: default@bucket_small_n3@ds=2008-04-08 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n3` @@ -369,8 +381,20 @@ POSTHOOK: Input: default@bucket_small_n3@ds=2008-04-08 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n3 a JOIN bucket_small_n3 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n3 +PREHOOK: Input: default@bucket_big_n3@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n3@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n3 +PREHOOK: Input: default@bucket_small_n3@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n3 a JOIN bucket_small_n3 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n3 +POSTHOOK: Input: default@bucket_big_n3@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n3@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n3 +POSTHOOK: Input: default@bucket_small_n3@ds=2008-04-08 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n3` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out index d103bbd..be37b85 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out @@ -83,8 +83,20 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n9@ds=2008-04-08 PREHOOK: query: explain extended select count(*) FROM bucket_small_n9 a JOIN bucket_big_n9 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n9 +PREHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n9 a JOIN bucket_big_n9 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n9 +POSTHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_small_n9` @@ -369,8 +381,20 @@ POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n9 a JOIN bucket_small_n9 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n9 +PREHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n9 a JOIN bucket_small_n9 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n9 +POSTHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n9` @@ -655,8 +679,20 @@ POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n9 a JOIN bucket_small_n9 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n9 +PREHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n9 a JOIN bucket_small_n9 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n9 +POSTHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n9` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out index d2f0fb0..75d8b4c 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out @@ -99,8 +99,20 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n12@ds=2008-04-08 PREHOOK: query: explain extended select count(*) FROM bucket_small_n12 a JOIN bucket_big_n12 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n12 +PREHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n12 a JOIN bucket_big_n12 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n12 +POSTHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_small_n12` @@ -385,8 +397,20 @@ POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n12 a JOIN bucket_small_n12 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n12 +PREHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n12 a JOIN bucket_small_n12 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n12 +POSTHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n12` @@ -671,8 +695,20 @@ POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n12 a JOIN bucket_small_n12 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n12 +PREHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n12 a JOIN bucket_small_n12 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n12 +POSTHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n12` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out index 7e79bac..60258a0 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out @@ -64,8 +64,14 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n0 PREHOOK: query: explain extended select count(*) FROM bucket_small_n0 a JOIN bucket_big_n0 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n0 +PREHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n0 a JOIN bucket_big_n0 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n0 +POSTHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_small_n0` @@ -294,8 +300,14 @@ POSTHOOK: Input: default@bucket_small_n0 19 PREHOOK: query: explain extended select count(*) FROM bucket_big_n0 a JOIN bucket_small_n0 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n0 +PREHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n0 a JOIN bucket_small_n0 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n0 +POSTHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n0` @@ -524,8 +536,14 @@ POSTHOOK: Input: default@bucket_small_n0 19 PREHOOK: query: explain extended select count(*) FROM bucket_big_n0 a JOIN bucket_small_n0 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n0 +PREHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n0 a JOIN bucket_small_n0 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n0 +POSTHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n0` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out index b719ed7..c1c611a 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out @@ -72,8 +72,16 @@ POSTHOOK: Lineage: tbl4.key EXPRESSION [(src)src.FieldSchema(name:key, type:stri POSTHOOK: Lineage: tbl4.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -221,8 +229,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src d on d.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src d on d.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -370,8 +386,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src h on h.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src h on h.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -519,8 +543,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -668,8 +700,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl3_n0 c on c.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +PREHOOK: Input: default@tbl3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl3_n0 c on c.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +POSTHOOK: Input: default@tbl3_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -775,8 +815,16 @@ POSTHOOK: Input: default@tbl3_n0 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl4 c on c.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +PREHOOK: Input: default@tbl4 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl4 c on c.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +POSTHOOK: Input: default@tbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -924,8 +972,16 @@ POSTHOOK: Input: default@tbl4 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1073,8 +1129,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1222,8 +1286,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl3_n0 c on c.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +PREHOOK: Input: default@tbl3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl3_n0 c on c.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +POSTHOOK: Input: default@tbl3_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1329,8 +1401,16 @@ POSTHOOK: Input: default@tbl3_n0 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl4 c on c.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +PREHOOK: Input: default@tbl4 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl4 c on c.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +POSTHOOK: Input: default@tbl4 +#### 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/auto_sortmerge_join_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out index 0997373..684d189 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out @@ -116,8 +116,22 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n6@ds=2008-04-09 PREHOOK: query: explain extended select count(*) FROM bucket_small_n6 a JOIN bucket_big_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n6 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n6 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n6 a JOIN bucket_big_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n6 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n6 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_small_n6` @@ -454,8 +468,22 @@ POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 76 PREHOOK: query: explain extended select count(*) FROM bucket_big_n6 a JOIN bucket_small_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n6 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n6 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n6 a JOIN bucket_small_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n6 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n6 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n6` @@ -792,8 +820,22 @@ POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 76 PREHOOK: query: explain extended select count(*) FROM bucket_big_n6 a JOIN bucket_small_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n6 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n6 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n6 a JOIN bucket_small_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n6 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n6 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n6` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out index 2060ba5..2e1ee3a 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out @@ -116,8 +116,22 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n5@ds=2008-04-09 PREHOOK: query: explain extended select count(*) FROM bucket_small_n5 a JOIN bucket_big_n5 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n5 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n5 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n5 a JOIN bucket_big_n5 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n5 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n5 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_small_n5` @@ -454,8 +468,22 @@ POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 76 PREHOOK: query: explain extended select count(*) FROM bucket_big_n5 a JOIN bucket_small_n5 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n5 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n5 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n5 a JOIN bucket_small_n5 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n5 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n5 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n5` @@ -792,8 +820,22 @@ POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 76 PREHOOK: query: explain extended select count(*) FROM bucket_big_n5 a JOIN bucket_small_n5 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n5 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n5 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n5 a JOIN bucket_small_n5 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n5 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n5 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`bucket_big_n5`
