http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/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 3891ea0..b8760c3 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 @@ -616,9 +620,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 @@ -1234,9 +1242,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 @@ -1864,9 +1876,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 @@ -2491,9 +2507,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 @@ -2608,9 +2628,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 @@ -3226,9 +3250,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 @@ -3338,9 +3366,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 @@ -3475,9 +3507,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/b356aae0/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 1f95237..4edc863 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 @@ -128,6 +132,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 @@ -136,6 +142,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 @@ -245,6 +253,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 @@ -253,6 +263,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 @@ -364,6 +376,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 @@ -375,6 +389,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 @@ -520,6 +536,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 @@ -531,6 +549,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 @@ -673,6 +693,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 @@ -684,6 +706,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 @@ -826,6 +850,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 @@ -837,6 +863,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 @@ -979,6 +1007,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 @@ -990,6 +1020,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/b356aae0/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 5489137..1b61d55 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 @@ -147,6 +153,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 ( @@ -157,6 +166,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 @@ -295,6 +307,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 ( @@ -312,6 +327,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 @@ -524,6 +542,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 @@ -531,6 +552,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 @@ -636,6 +660,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 ( @@ -648,6 +675,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 @@ -770,6 +800,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 ( @@ -789,6 +821,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 @@ -911,6 +945,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 @@ -918,6 +955,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 @@ -1018,6 +1058,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 @@ -1025,6 +1068,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 @@ -1141,11 +1187,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 @@ -1245,6 +1297,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 @@ -1255,6 +1310,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 @@ -1380,6 +1438,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 @@ -1393,6 +1454,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 @@ -1521,6 +1585,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 @@ -1528,6 +1596,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 @@ -1805,6 +1877,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 @@ -1812,6 +1888,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/b356aae0/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 569f4b9..ee712c0 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` @@ -385,8 +397,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` @@ -669,8 +693,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/b356aae0/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 c2a273b..fbb6362 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 @@ -213,6 +219,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 @@ -220,6 +229,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/b356aae0/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 f880bc0..3d71f2e 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` @@ -411,8 +423,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` @@ -695,8 +719,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 @@ -964,8 +1000,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/b356aae0/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 300b4b9..c0fb13a 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[36][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/b356aae0/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 34c9abc..f087941 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 @@ -329,6 +337,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 @@ -337,6 +349,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 @@ -600,6 +616,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 @@ -608,6 +628,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/b356aae0/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/b356aae0/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/b356aae0/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 bd51c86..e8bdaa2 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 @@ -320,6 +332,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 @@ -331,6 +349,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 @@ -562,6 +586,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 @@ -573,6 +603,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/b356aae0/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 0d5c8f8..e24f448 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` @@ -367,8 +379,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/b356aae0/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 e00a22b..12fb353 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` @@ -367,8 +379,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` @@ -651,8 +675,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/b356aae0/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 ae83c60..c811827 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` @@ -383,8 +395,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` @@ -667,8 +691,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/b356aae0/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 a6656d3..dd78af9 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` @@ -292,8 +298,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` @@ -520,8 +532,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/b356aae0/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 828c6e1..3b753ad 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 @@ -218,8 +226,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 @@ -364,8 +380,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 @@ -510,8 +534,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 @@ -656,8 +688,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 @@ -760,8 +800,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 @@ -906,8 +954,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 @@ -1052,8 +1108,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 @@ -1198,8 +1262,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 @@ -1302,8 +1374,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/b356aae0/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 f561813..9cda07c 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` @@ -452,8 +466,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` @@ -788,8 +816,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/b356aae0/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 d5d17a3..3e9c06e 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` @@ -452,8 +466,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` @@ -788,8 +816,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` http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out index 935e607..4e50c9c 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out @@ -43,11 +43,17 @@ select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### 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_n10 a join tbl2_n9 b on a.key = b.key ) subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -144,6 +150,9 @@ select key, count(*) from ) subq1 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from ( @@ -151,6 +160,9 @@ select key, count(*) from ) subq1 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -264,6 +276,9 @@ select count(*) from group by key ) subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -274,6 +289,9 @@ select count(*) from group by key ) subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -412,6 +430,9 @@ join ) src2 on src1.key = src2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -429,6 +450,9 @@ join ) src2 on src1.key = src2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -641,6 +665,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -648,6 +675,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -753,6 +783,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -765,6 +798,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -887,6 +923,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -906,6 +944,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1028,6 +1068,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### 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_n10 a where key < 8) subq1 @@ -1035,6 +1078,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1135,6 +1181,9 @@ select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2_n9 a) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### 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_n10 a) subq1 @@ -1142,6 +1191,9 @@ select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2_n9 a) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1258,11 +1310,17 @@ select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1358,12 +1416,18 @@ select count(*) from tbl1_n10 a (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tbl1_n10 a join (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1465,6 +1529,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -1475,6 +1542,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1600,6 +1670,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### 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 @@ -1613,6 +1686,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1723,11 +1799,17 @@ select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### 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_n10 a join tbl2_n9 b on a.key = b.key ) subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1824,6 +1906,9 @@ select key, count(*) from ) subq1 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from ( @@ -1831,6 +1916,9 @@ select key, count(*) from ) subq1 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1944,6 +2032,9 @@ select count(*) from group by key ) subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -1954,6 +2045,9 @@ select count(*) from group by key ) subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2092,6 +2186,9 @@ join ) src2 on src1.key = src2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -2109,6 +2206,9 @@ join ) src2 on src1.key = src2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2321,6 +2421,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -2328,6 +2431,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2433,6 +2539,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -2445,6 +2554,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2567,6 +2679,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -2586,6 +2700,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2708,6 +2824,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### 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_n10 a where key < 8) subq1 @@ -2715,6 +2834,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2813,11 +2935,17 @@ select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2913,12 +3041,18 @@ select count(*) from tbl1_n10 a (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tbl1_n10 a join (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3020,6 +3154,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -3030,6 +3167,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3155,6 +3295,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### 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 @@ -3168,6 +3311,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/bucket2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket2.q.out b/ql/src/test/results/clientpositive/llap/bucket2.q.out index d0fa92b..9d86258 100644 --- a/ql/src/test/results/clientpositive/llap/bucket2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket2.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain extended insert overwrite table bucket2_1 select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket2_1 POSTHOOK: query: explain extended insert overwrite table bucket2_1 select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket2_1 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src` STAGE DEPENDENCIES: @@ -239,9 +243,13 @@ POSTHOOK: Lineage: bucket2_1.value SIMPLE [(src)src.FieldSchema(name:value, type PREHOOK: query: explain select * from bucket2_1 tablesample (bucket 1 out of 2) s PREHOOK: type: QUERY +PREHOOK: Input: default@bucket2_1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from bucket2_1 tablesample (bucket 1 out of 2) s POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket2_1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage