http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join22.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join22.q.out b/ql/src/test/results/clientpositive/join22.q.out index f4b9472..7690d99 100644 --- a/ql/src/test/results/clientpositive/join22.q.out +++ b/ql/src/test/results/clientpositive/join22.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain SELECT src5.src1_value FROM (SELECT src3.*, src4.value as src4_value, src4.key as src4_key FROM src src4 JOIN (SELECT src2.*, src1.key as src1_key, src1.value as src1_value FROM src src1 JOIN src src2 ON src1.key = src2.key) src3 ON src3.src1_key = src4.key) src5 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT src5.src1_value FROM (SELECT src3.*, src4.value as src4_value, src4.key as src4_key FROM src src4 JOIN (SELECT src2.*, src1.key as src1_key, src1.value as src1_value FROM src src1 JOIN src src2 ON src1.key = src2.key) src3 ON src3.src1_key = src4.key) src5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join23.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join23.q.out b/ql/src/test/results/clientpositive/join23.q.out index c76118a..91565c3 100644 --- a/ql/src/test/results/clientpositive/join23.q.out +++ b/ql/src/test/results/clientpositive/join23.q.out @@ -2,9 +2,13 @@ Warning: Shuffle Join JOIN[4][tables = [src1, src2]] in Stage 'Stage-1:MAPRED' i PREHOOK: query: EXPLAIN SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join25.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join25.q.out b/ql/src/test/results/clientpositive/join25.q.out index 2cf39a4..3a05531 100644 --- a/ql/src/test/results/clientpositive/join25.q.out +++ b/ql/src/test/results/clientpositive/join25.q.out @@ -11,11 +11,17 @@ INSERT OVERWRITE TABLE dest_j1_n18 SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest_j1_n18 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_j1_n18 SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest_j1_n18 STAGE DEPENDENCIES: Stage-6 is a root stage Stage-5 depends on stages: Stage-6 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join26.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join26.q.out b/ql/src/test/results/clientpositive/join26.q.out index 088b741..3707d09 100644 --- a/ql/src/test/results/clientpositive/join26.q.out +++ b/ql/src/test/results/clientpositive/join26.q.out @@ -12,12 +12,22 @@ SELECT /*+ MAPJOIN(x,y) */ x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN srcpart z ON (x.key = z.key and z.ds='2008-04-08' and z.hr=11) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Output: default@dest_j1_n10 POSTHOOK: query: EXPLAIN EXTENDED INSERT OVERWRITE TABLE dest_j1_n10 SELECT /*+ MAPJOIN(x,y) */ x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN srcpart z ON (x.key = z.key and z.ds='2008-04-08' and z.hr=11) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@dest_j1_n10 OPTIMIZED SQL: SELECT `t4`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value`, CAST('2008-04-08' AS STRING) AS `ds`, `hr` FROM `default`.`srcpart` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join27.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join27.q.out b/ql/src/test/results/clientpositive/join27.q.out index 13d8f72..533f2cd 100644 --- a/ql/src/test/results/clientpositive/join27.q.out +++ b/ql/src/test/results/clientpositive/join27.q.out @@ -11,11 +11,17 @@ INSERT OVERWRITE TABLE dest_j1_n2 SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value FROM src1 x JOIN src y ON (x.value = y.value) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest_j1_n2 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_j1_n2 SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value FROM src1 x JOIN src y ON (x.value = y.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest_j1_n2 STAGE DEPENDENCIES: Stage-6 is a root stage Stage-5 depends on stages: Stage-6 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join28.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join28.q.out b/ql/src/test/results/clientpositive/join28.q.out index ed1ab26..1be4cf9 100644 --- a/ql/src/test/results/clientpositive/join28.q.out +++ b/ql/src/test/results/clientpositive/join28.q.out @@ -14,6 +14,11 @@ FROM FROM src1 x JOIN src y ON (x.key = y.key)) subq JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Output: default@dest_j1_n11 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_j1_n11 SELECT subq.key1, z.value @@ -22,6 +27,11 @@ FROM FROM src1 x JOIN src y ON (x.key = y.key)) subq JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@dest_j1_n11 STAGE DEPENDENCIES: Stage-7 is a root stage Stage-6 depends on stages: Stage-7 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join29.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join29.q.out b/ql/src/test/results/clientpositive/join29.q.out index 9bb10b7..d5be206 100644 --- a/ql/src/test/results/clientpositive/join29.q.out +++ b/ql/src/test/results/clientpositive/join29.q.out @@ -12,12 +12,18 @@ SELECT subq1.key, subq1.cnt, subq2.cnt FROM (select x.key, count(1) as cnt from src1 x group by x.key) subq1 JOIN (select y.key, count(1) as cnt from src y group by y.key) subq2 ON (subq1.key = subq2.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest_j1_n6 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_j1_n6 SELECT subq1.key, subq1.cnt, subq2.cnt FROM (select x.key, count(1) as cnt from src1 x group by x.key) subq1 JOIN (select y.key, count(1) as cnt from src y group by y.key) subq2 ON (subq1.key = subq2.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest_j1_n6 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-8 depends on stages: Stage-1, Stage-5 , consists of Stage-9, Stage-10, Stage-2 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join3.q.out b/ql/src/test/results/clientpositive/join3.q.out index 800202b..b1d46e7 100644 --- a/ql/src/test/results/clientpositive/join3.q.out +++ b/ql/src/test/results/clientpositive/join3.q.out @@ -10,10 +10,14 @@ PREHOOK: query: EXPLAIN FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key) INSERT OVERWRITE TABLE dest1_n46 SELECT src1.key, src3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n46 POSTHOOK: query: EXPLAIN FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key) INSERT OVERWRITE TABLE dest1_n46 SELECT src1.key, src3.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n46 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/join30.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join30.q.out b/ql/src/test/results/clientpositive/join30.q.out index 059b263..438a5d3 100644 --- a/ql/src/test/results/clientpositive/join30.q.out +++ b/ql/src/test/results/clientpositive/join30.q.out @@ -10,10 +10,16 @@ PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_j1_n0 SELECT /*+ MAPJOIN(x) */ x.key, count(1) FROM src1 x JOIN src y ON (x.key = y.key) group by x.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest_j1_n0 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_j1_n0 SELECT /*+ MAPJOIN(x) */ x.key, count(1) FROM src1 x JOIN src y ON (x.key = y.key) group by x.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest_j1_n0 STAGE DEPENDENCIES: Stage-7 is a root stage Stage-2 depends on stages: Stage-7 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join31.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join31.q.out b/ql/src/test/results/clientpositive/join31.q.out index 8fda645..67690f1 100644 --- a/ql/src/test/results/clientpositive/join31.q.out +++ b/ql/src/test/results/clientpositive/join31.q.out @@ -13,6 +13,9 @@ FROM (select x.key, count(1) as cnt from src1 x group by x.key) subq1 JOIN (select y.key, count(1) as cnt from src y group by y.key) subq2 ON (subq1.key = subq2.key) group by subq1.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest_j1_n22 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_j1_n22 SELECT subq1.key, count(1) as cnt @@ -20,6 +23,9 @@ FROM (select x.key, count(1) as cnt from src1 x group by x.key) subq1 JOIN (select y.key, count(1) as cnt from src y group by y.key) subq2 ON (subq1.key = subq2.key) group by subq1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest_j1_n22 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-8 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join32.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join32.q.out b/ql/src/test/results/clientpositive/join32.q.out index 1f58627..77060d9 100644 --- a/ql/src/test/results/clientpositive/join32.q.out +++ b/ql/src/test/results/clientpositive/join32.q.out @@ -12,12 +12,22 @@ SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Output: default@dest_j1_n12 POSTHOOK: query: EXPLAIN EXTENDED INSERT OVERWRITE TABLE dest_j1_n12 SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@dest_j1_n12 OPTIMIZED SQL: SELECT `t4`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `value`, CAST('2008-04-08' AS STRING) AS `ds`, `hr` FROM `default`.`srcpart` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join33.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join33.q.out b/ql/src/test/results/clientpositive/join33.q.out index d40bb04..321a9b7 100644 --- a/ql/src/test/results/clientpositive/join33.q.out +++ b/ql/src/test/results/clientpositive/join33.q.out @@ -12,12 +12,22 @@ SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Output: default@dest_j1_n7 POSTHOOK: query: EXPLAIN EXTENDED INSERT OVERWRITE TABLE dest_j1_n7 SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@dest_j1_n7 OPTIMIZED SQL: SELECT `t4`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `value`, CAST('2008-04-08' AS STRING) AS `ds`, `hr` FROM `default`.`srcpart` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join34.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join34.q.out b/ql/src/test/results/clientpositive/join34.q.out index 6181b39..5be9a28 100644 --- a/ql/src/test/results/clientpositive/join34.q.out +++ b/ql/src/test/results/clientpositive/join34.q.out @@ -16,6 +16,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest_j1_n1 POSTHOOK: query: EXPLAIN EXTENDED INSERT OVERWRITE TABLE dest_j1_n1 SELECT x.key, x.value, subq1.value @@ -26,6 +29,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest_j1_n1 OPTIMIZED SQL: SELECT `t5`.`key`, `t5`.`value`, `t3`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`src` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join35.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join35.q.out b/ql/src/test/results/clientpositive/join35.q.out index 6a52d9d..4c53b75 100644 --- a/ql/src/test/results/clientpositive/join35.q.out +++ b/ql/src/test/results/clientpositive/join35.q.out @@ -16,6 +16,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest_j1_n24 POSTHOOK: query: EXPLAIN EXTENDED INSERT OVERWRITE TABLE dest_j1_n24 SELECT x.key, x.value, subq1.cnt @@ -26,6 +29,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest_j1_n24 OPTIMIZED SQL: SELECT `t5`.`key`, `t5`.`value`, `t3`.`$f1` AS `cnt` FROM (SELECT `key`, COUNT(*) AS `$f1` FROM `default`.`src` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join36.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join36.q.out b/ql/src/test/results/clientpositive/join36.q.out index 76737ac..747181e 100644 --- a/ql/src/test/results/clientpositive/join36.q.out +++ b/ql/src/test/results/clientpositive/join36.q.out @@ -51,11 +51,17 @@ INSERT OVERWRITE TABLE dest_j1_n13 SELECT /*+ MAPJOIN(x) */ x.key, x.cnt, y.cnt FROM tmp1_n0 x JOIN tmp2_n0 y ON (x.key = y.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tmp1_n0 +PREHOOK: Input: default@tmp2_n0 +PREHOOK: Output: default@dest_j1_n13 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_j1_n13 SELECT /*+ MAPJOIN(x) */ x.key, x.cnt, y.cnt FROM tmp1_n0 x JOIN tmp2_n0 y ON (x.key = y.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp1_n0 +POSTHOOK: Input: default@tmp2_n0 +POSTHOOK: Output: default@dest_j1_n13 STAGE DEPENDENCIES: Stage-6 is a root stage Stage-5 depends on stages: Stage-6 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join37.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join37.q.out b/ql/src/test/results/clientpositive/join37.q.out index 8f9c8a4..91d373a 100644 --- a/ql/src/test/results/clientpositive/join37.q.out +++ b/ql/src/test/results/clientpositive/join37.q.out @@ -11,11 +11,17 @@ INSERT OVERWRITE TABLE dest_j1_n9 SELECT /*+ MAPJOIN(X) */ x.key, x.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@dest_j1_n9 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_j1_n9 SELECT /*+ MAPJOIN(X) */ x.key, x.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@dest_j1_n9 STAGE DEPENDENCIES: Stage-6 is a root stage Stage-5 depends on stages: Stage-6 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join38.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join38.q.out b/ql/src/test/results/clientpositive/join38.q.out index c4ddd7a..a96d2ad 100644 --- a/ql/src/test/results/clientpositive/join38.q.out +++ b/ql/src/test/results/clientpositive/join38.q.out @@ -42,12 +42,18 @@ SELECT /*+ MAPJOIN(a) */ a.value, b.col5, count(1) as count where b.col11 = 111 group by a.value, b.col5 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tmp_n1 +#### A masked pattern was here #### POSTHOOK: query: explain FROM src a JOIN tmp_n1 b ON (a.key = b.col11) SELECT /*+ MAPJOIN(a) */ a.value, b.col5, count(1) as count where b.col11 = 111 group by a.value, b.col5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tmp_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-5 is a root stage Stage-2 depends on stages: Stage-5 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join39.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join39.q.out b/ql/src/test/results/clientpositive/join39.q.out index 00c37cd..1084b4f 100644 --- a/ql/src/test/results/clientpositive/join39.q.out +++ b/ql/src/test/results/clientpositive/join39.q.out @@ -11,11 +11,15 @@ INSERT OVERWRITE TABLE dest_j1_n8 SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest_j1_n8 POSTHOOK: query: explain INSERT OVERWRITE TABLE dest_j1_n8 SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest_j1_n8 STAGE DEPENDENCIES: Stage-6 is a root stage Stage-5 depends on stages: Stage-6 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join4.q.out b/ql/src/test/results/clientpositive/join4.q.out index 916ffbb..9dbc6b9 100644 --- a/ql/src/test/results/clientpositive/join4.q.out +++ b/ql/src/test/results/clientpositive/join4.q.out @@ -21,6 +21,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n72 SELECT c.c1, c.c2, c.c3, c.c4 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n72 POSTHOOK: query: EXPLAIN FROM ( FROM @@ -36,6 +38,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n72 SELECT c.c1, c.c2, c.c3, c.c4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n72 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/join40.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join40.q.out b/ql/src/test/results/clientpositive/join40.q.out index 86cc740..2ceabc3 100644 --- a/ql/src/test/results/clientpositive/join40.q.out +++ b/ql/src/test/results/clientpositive/join40.q.out @@ -1,9 +1,13 @@ PREHOOK: query: EXPLAIN SELECT x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -644,9 +648,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN select src1.key, src2.value FROM src src1 JOIN src src2 ON (src1.key = src2.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select src1.key, src2.value FROM src src1 JOIN src src2 ON (src1.key = src2.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1757,10 +1765,14 @@ PREHOOK: query: EXPLAIN SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20) 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) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20) 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-2 depends on stages: Stage-1 @@ -2421,10 +2433,14 @@ PREHOOK: query: EXPLAIN SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20) 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 < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20) 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-2 depends on stages: Stage-1 @@ -3085,10 +3101,14 @@ PREHOOK: query: EXPLAIN SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-4 is a root stage Stage-3 depends on stages: Stage-4 @@ -3733,9 +3753,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT COUNT(1) FROM SRC A JOIN SRC B ON (A.KEY=B.KEY) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT COUNT(1) FROM SRC A JOIN SRC B ON (A.KEY=B.KEY) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-5 is a root stage Stage-2 depends on stages: Stage-5 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join41.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join41.q.out b/ql/src/test/results/clientpositive/join41.q.out index 08d6e36..467d704 100644 --- a/ql/src/test/results/clientpositive/join41.q.out +++ b/ql/src/test/results/clientpositive/join41.q.out @@ -13,9 +13,13 @@ POSTHOOK: Lineage: s1.value SIMPLE [(src)src.FieldSchema(name:value, type:string PREHOOK: query: EXPLAIN SELECT * FROM s1 src1 LEFT OUTER JOIN s1 src2 ON (src1.key = src2.key AND src2.key > 10) PREHOOK: type: QUERY +PREHOOK: Input: default@s1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM s1 src1 LEFT OUTER JOIN s1 src2 ON (src1.key = src2.key AND src2.key > 10) POSTHOOK: type: QUERY +POSTHOOK: Input: default@s1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -91,9 +95,13 @@ POSTHOOK: Input: default@s1 PREHOOK: query: EXPLAIN SELECT * FROM s1 src1 LEFT OUTER JOIN s1 src2 ON (src1.key = src2.key AND src2.key > 10) PREHOOK: type: QUERY +PREHOOK: Input: default@s1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM s1 src1 LEFT OUTER JOIN s1 src2 ON (src1.key = src2.key AND src2.key > 10) POSTHOOK: type: QUERY +POSTHOOK: Input: default@s1 +#### 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/join42.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join42.q.out b/ql/src/test/results/clientpositive/join42.q.out index 83287ca..81ac363 100644 --- a/ql/src/test/results/clientpositive/join42.q.out +++ b/ql/src/test/results/clientpositive/join42.q.out @@ -104,6 +104,13 @@ WHERE L.id = 4436 and acct.brn is not null PREHOOK: type: QUERY +PREHOOK: Input: default@a_n11 +PREHOOK: Input: default@acct +PREHOOK: Input: default@fr +PREHOOK: Input: default@l +PREHOOK: Input: default@la_n11 +PREHOOK: Input: default@pi +#### A masked pattern was here #### POSTHOOK: query: explain select acct.ACC_N, acct.brn @@ -117,6 +124,13 @@ WHERE L.id = 4436 and acct.brn is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n11 +POSTHOOK: Input: default@acct +POSTHOOK: Input: default@fr +POSTHOOK: Input: default@l +POSTHOOK: Input: default@la_n11 +POSTHOOK: Input: default@pi +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1, Stage-6 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join43.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join43.q.out b/ql/src/test/results/clientpositive/join43.q.out index 5880856..77c8aa8 100644 --- a/ql/src/test/results/clientpositive/join43.q.out +++ b/ql/src/test/results/clientpositive/join43.q.out @@ -224,6 +224,10 @@ from ( on last.s = action.s and last.last_stage_time = action.`time` ) list PREHOOK: type: QUERY +PREHOOK: Input: default@cart_history +PREHOOK: Input: default@events +PREHOOK: Input: default@purchase_history +#### A masked pattern was here #### POSTHOOK: query: explain select s from ( @@ -240,6 +244,10 @@ from ( on last.s = action.s and last.last_stage_time = action.`time` ) list POSTHOOK: type: QUERY +POSTHOOK: Input: default@cart_history +POSTHOOK: Input: default@events +POSTHOOK: Input: default@purchase_history +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -450,6 +458,10 @@ from ( on last.s = action.s and last.last_stage_time = action.`time` ) list PREHOOK: type: QUERY +PREHOOK: Input: default@cart_history +PREHOOK: Input: default@events +PREHOOK: Input: default@purchase_history +#### A masked pattern was here #### POSTHOOK: query: explain select * from ( @@ -466,6 +478,10 @@ from ( on last.s = action.s and last.last_stage_time = action.`time` ) list POSTHOOK: type: QUERY +POSTHOOK: Input: default@cart_history +POSTHOOK: Input: default@events +POSTHOOK: Input: default@purchase_history +#### A masked pattern was here #### 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/join44.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join44.q.out b/ql/src/test/results/clientpositive/join44.q.out index 470a03b..48154db 100644 --- a/ql/src/test/results/clientpositive/join44.q.out +++ b/ql/src/test/results/clientpositive/join44.q.out @@ -13,6 +13,8 @@ WHERE src1.val1=src2.val1 AND src1.val2 between 2450816 and 2451500 AND src2.val2 between 2450816 and 2451500 PREHOOK: type: QUERY +PREHOOK: Input: default@mytable_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM mytable_n1 src1, mytable_n1 src2 @@ -20,6 +22,8 @@ WHERE src1.val1=src2.val1 AND src1.val2 between 2450816 and 2451500 AND src2.val2 between 2450816 and 2451500 POSTHOOK: type: QUERY +POSTHOOK: Input: default@mytable_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join45.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join45.q.out b/ql/src/test/results/clientpositive/join45.q.out index 77dbaa2..47aaf7d 100644 --- a/ql/src/test/results/clientpositive/join45.q.out +++ b/ql/src/test/results/clientpositive/join45.q.out @@ -6,6 +6,9 @@ ON (src1.key=src.key AND src.value between 100 and 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -14,6 +17,9 @@ ON (src1.key=src.key AND src.value between 100 and 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -108,12 +114,18 @@ FROM src1 JOIN src ON (src1.key=src.key AND true) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src ON (src1.key=src.key AND true) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -217,6 +229,9 @@ ON (src1.value between 100 and 102 AND true) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -225,6 +240,9 @@ ON (src1.value between 100 and 102 AND true) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -319,6 +337,9 @@ ON (src1.key=src.key OR src.value between 100 and 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -327,6 +348,9 @@ ON (src1.key=src.key OR src.value between 100 and 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -425,6 +449,9 @@ ON (src1.key+src.key >= 100 AND src1.key+src.key <= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -432,6 +459,9 @@ ON (src1.key+src.key >= 100 AND src1.key+src.key <= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -524,6 +554,9 @@ ON (src1.key+src.key >= 100 OR src1.key+src.key <= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -531,6 +564,9 @@ ON (src1.key+src.key >= 100 OR src1.key+src.key <= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -626,12 +662,18 @@ FROM src1 JOIN src ON ((src1.key,src.key) IN ((100,100),(101,101),(102,102))) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src ON ((src1.key,src.key) IN ((100,100),(101,101),(102,102))) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -716,6 +758,9 @@ JOIN src1 a ON (a.key+src.key >= 100) LEFT OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -723,6 +768,9 @@ JOIN src1 a ON (a.key+src.key >= 100) LEFT OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -863,6 +911,9 @@ LEFT OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -870,6 +921,9 @@ LEFT OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1006,6 +1060,9 @@ JOIN src1 a ON (a.key+src.key >= 100) RIGHT OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -1013,6 +1070,9 @@ JOIN src1 a ON (a.key+src.key >= 100) RIGHT OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1149,6 +1209,9 @@ RIGHT OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -1156,6 +1219,9 @@ RIGHT OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1282,6 +1348,9 @@ JOIN src1 a ON (a.key+src.key >= 100) FULL OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -1289,6 +1358,9 @@ JOIN src1 a ON (a.key+src.key >= 100) FULL OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1425,6 +1497,9 @@ FULL OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -1432,6 +1507,9 @@ FULL OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1570,6 +1648,9 @@ JOIN cbo_t1 t4 ON (t4.key = t2.key or t2.c_float = t4.c_float and t4.value = t2 JOIN cbo_t1 t5 ON (t5.key = t2.key or t2.c_boolean = t4.c_boolean and t5.c_int = 42) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM cbo_t1 t1 @@ -1579,6 +1660,9 @@ JOIN cbo_t1 t4 ON (t4.key = t2.key or t2.c_float = t4.c_float and t4.value = t2 JOIN cbo_t1 t5 ON (t5.key = t2.key or t2.c_boolean = t4.c_boolean and t5.c_int = 42) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-4 is a root stage Stage-1 depends on stages: Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join46.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join46.q.out b/ql/src/test/results/clientpositive/join46.q.out index 2f89a52..738f0b6 100644 --- a/ql/src/test/results/clientpositive/join46.q.out +++ b/ql/src/test/results/clientpositive/join46.q.out @@ -45,11 +45,17 @@ SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -136,6 +142,9 @@ ON (test1_n2.value=test2_n0.value AND test1_n2.key between 100 and 102 AND test2_n0.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 @@ -143,6 +152,9 @@ ON (test1_n2.value=test2_n0.value AND test1_n2.key between 100 and 102 AND test2_n0.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -238,12 +250,18 @@ FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.key between 100 and 102 AND test2_n0.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.key between 100 and 102 AND test2_n0.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -332,11 +350,17 @@ SELECT * FROM test1_n2 RIGHT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value AND true) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 RIGHT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value AND true) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -420,11 +444,17 @@ SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -516,6 +546,9 @@ ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 @@ -523,6 +556,9 @@ ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -616,12 +652,18 @@ FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -713,12 +755,18 @@ FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test2_n0.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test2_n0.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -805,6 +853,9 @@ ON (test1_n2.value=test2_n0.value AND (test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102)) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 LEFT OUTER JOIN test2_n0 @@ -812,6 +863,9 @@ ON (test1_n2.value=test2_n0.value AND (test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -902,12 +956,18 @@ FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test1_n2.key=test2_n0.key) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT col_1, col_2 FROM test1_n2 LEFT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test1_n2.key=test2_n0.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -999,6 +1059,9 @@ ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 RIGHT OUTER JOIN test2_n0 @@ -1006,6 +1069,9 @@ ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1099,12 +1165,18 @@ FROM test1_n2 RIGHT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 RIGHT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1193,12 +1265,18 @@ FROM test1_n2 RIGHT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test2_n0.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 RIGHT OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test2_n0.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1287,6 +1365,9 @@ ON (test1_n2.value=test2_n0.value AND (test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102)) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 RIGHT OUTER JOIN test2_n0 @@ -1294,6 +1375,9 @@ ON (test1_n2.value=test2_n0.value AND (test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1383,6 +1467,9 @@ ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 FULL OUTER JOIN test2_n0 @@ -1390,6 +1477,9 @@ ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1483,12 +1573,18 @@ FROM test1_n2 FULL OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 FULL OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test1_n2.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1580,12 +1676,18 @@ FROM test1_n2 FULL OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test2_n0.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 FULL OUTER JOIN test2_n0 ON (test1_n2.value=test2_n0.value OR test2_n0.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1674,6 +1776,9 @@ ON (test1_n2.value=test2_n0.value AND (test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102)) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n2 FULL OUTER JOIN test2_n0 @@ -1681,6 +1786,9 @@ ON (test1_n2.value=test2_n0.value AND (test1_n2.key between 100 and 102 OR test2_n0.key between 100 and 102)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1787,6 +1895,9 @@ FULL OUTER JOIN ( ) sq2 ON (sq1.value1 is null or sq2.value4 is null and sq2.value3 != sq1.value2) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n2 +PREHOOK: Input: default@test2_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM ( @@ -1807,6 +1918,9 @@ FULL OUTER JOIN ( ) sq2 ON (sq1.value1 is null or sq2.value4 is null and sq2.value3 != sq1.value2) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n2 +POSTHOOK: Input: default@test2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1, Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join47.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join47.q.out b/ql/src/test/results/clientpositive/join47.q.out index 2536f7f..4d9e937 100644 --- a/ql/src/test/results/clientpositive/join47.q.out +++ b/ql/src/test/results/clientpositive/join47.q.out @@ -6,6 +6,9 @@ ON (src1.key=src.key AND src.value between 100 and 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -14,6 +17,9 @@ ON (src1.key=src.key AND src.value between 100 and 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -108,12 +114,18 @@ FROM src1 JOIN src ON (src1.key=src.key AND true) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src ON (src1.key=src.key AND true) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -217,6 +229,9 @@ ON (src1.value between 100 and 102 AND true) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -225,6 +240,9 @@ ON (src1.value between 100 and 102 AND true) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -319,6 +337,9 @@ ON (src1.key=src.key OR src.value between 100 and 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -327,6 +348,9 @@ ON (src1.key=src.key OR src.value between 100 and 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -423,6 +447,9 @@ ON (src1.key+src.key >= 100 AND src1.key+src.key <= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -430,6 +457,9 @@ ON (src1.key+src.key >= 100 AND src1.key+src.key <= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -520,6 +550,9 @@ ON (src1.key+src.key >= 100 OR src1.key+src.key <= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src @@ -527,6 +560,9 @@ ON (src1.key+src.key >= 100 OR src1.key+src.key <= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -620,12 +656,18 @@ FROM src1 JOIN src ON ((src1.key,src.key) IN ((100,100),(101,101),(102,102))) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src1 JOIN src ON ((src1.key,src.key) IN ((100,100),(101,101),(102,102))) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -708,6 +750,9 @@ JOIN src1 a ON (a.key+src.key >= 100) LEFT OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -715,6 +760,9 @@ JOIN src1 a ON (a.key+src.key >= 100) LEFT OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -853,6 +901,9 @@ LEFT OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -860,6 +911,9 @@ LEFT OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -994,6 +1048,9 @@ JOIN src1 a ON (a.key+src.key >= 100) RIGHT OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -1001,6 +1058,9 @@ JOIN src1 a ON (a.key+src.key >= 100) RIGHT OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1135,6 +1195,9 @@ RIGHT OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -1142,6 +1205,9 @@ RIGHT OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1266,6 +1332,9 @@ JOIN src1 a ON (a.key+src.key >= 100) FULL OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -1273,6 +1342,9 @@ JOIN src1 a ON (a.key+src.key >= 100) FULL OUTER JOIN src1 b ON (b.key = src.key) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1407,6 +1479,9 @@ FULL OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM src @@ -1414,6 +1489,9 @@ FULL OUTER JOIN src1 a ON (a.key = src.key) JOIN src1 b ON (b.key+src.key<= 102) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1550,6 +1628,9 @@ JOIN cbo_t1 t4 ON (t4.key = t2.key or t2.c_float = t4.c_float and t4.value = t2 JOIN cbo_t1 t5 ON (t5.key = t2.key or t2.c_boolean = t4.c_boolean and t5.c_int = 42) LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM cbo_t1 t1 @@ -1559,6 +1640,9 @@ JOIN cbo_t1 t4 ON (t4.key = t2.key or t2.c_float = t4.c_float and t4.value = t2 JOIN cbo_t1 t5 ON (t5.key = t2.key or t2.c_boolean = t4.c_boolean and t5.c_int = 42) LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-4 is a root stage Stage-1 depends on stages: Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join5.q.out b/ql/src/test/results/clientpositive/join5.q.out index 49dd968..fc2abe0 100644 --- a/ql/src/test/results/clientpositive/join5.q.out +++ b/ql/src/test/results/clientpositive/join5.q.out @@ -21,6 +21,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n126 SELECT c.c1, c.c2, c.c3, c.c4 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n126 POSTHOOK: query: EXPLAIN FROM ( FROM @@ -36,6 +38,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n126 SELECT c.c1, c.c2, c.c3, c.c4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n126 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/join6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join6.q.out b/ql/src/test/results/clientpositive/join6.q.out index 1135cef..2b6b621 100644 --- a/ql/src/test/results/clientpositive/join6.q.out +++ b/ql/src/test/results/clientpositive/join6.q.out @@ -21,6 +21,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n156 SELECT c.c1, c.c2, c.c3, c.c4 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n156 POSTHOOK: query: EXPLAIN FROM ( FROM @@ -36,6 +38,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n156 SELECT c.c1, c.c2, c.c3, c.c4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n156 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/join7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join7.q.out b/ql/src/test/results/clientpositive/join7.q.out index 0bc6f89..5f626f2 100644 --- a/ql/src/test/results/clientpositive/join7.q.out +++ b/ql/src/test/results/clientpositive/join7.q.out @@ -26,6 +26,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n17 SELECT c.c1, c.c2, c.c3, c.c4, c.c5, c.c6 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n17 POSTHOOK: query: EXPLAIN FROM ( FROM @@ -46,6 +48,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n17 SELECT c.c1, c.c2, c.c3, c.c4, c.c5, c.c6 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n17 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/join8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join8.q.out b/ql/src/test/results/clientpositive/join8.q.out index c9c8833..313d5f9 100644 --- a/ql/src/test/results/clientpositive/join8.q.out +++ b/ql/src/test/results/clientpositive/join8.q.out @@ -21,6 +21,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n173 SELECT c.c1, c.c2, c.c3, c.c4 where c.c3 IS NULL AND c.c1 IS NOT NULL PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n173 POSTHOOK: query: EXPLAIN FROM ( FROM @@ -36,6 +38,8 @@ FROM ( ) c INSERT OVERWRITE TABLE dest1_n173 SELECT c.c1, c.c2, c.c3, c.c4 where c.c3 IS NULL AND c.c1 IS NOT NULL POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n173 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/join9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join9.q.out b/ql/src/test/results/clientpositive/join9.q.out index e025726..8c2dead 100644 --- a/ql/src/test/results/clientpositive/join9.q.out +++ b/ql/src/test/results/clientpositive/join9.q.out @@ -10,10 +10,18 @@ PREHOOK: query: EXPLAIN EXTENDED FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE dest1_n39 SELECT src1.key, src2.value where src1.ds = '2008-04-08' and src1.hr = '12' PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Output: default@dest1_n39 POSTHOOK: query: EXPLAIN EXTENDED FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE dest1_n39 SELECT src1.key, src2.value where src1.ds = '2008-04-08' and src1.hr = '12' POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@dest1_n39 OPTIMIZED SQL: SELECT `t0`.`key`, `t2`.`value` FROM (SELECT `key`, CAST('2008-04-08' AS STRING) AS `ds`, CAST('12' AS STRING) AS `hr` FROM `default`.`srcpart` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join_alt_syntax.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_alt_syntax.q.out b/ql/src/test/results/clientpositive/join_alt_syntax.q.out index 20a0ebc..454b117 100644 --- a/ql/src/test/results/clientpositive/join_alt_syntax.q.out +++ b/ql/src/test/results/clientpositive/join_alt_syntax.q.out @@ -2,9 +2,13 @@ Warning: Shuffle Join JOIN[6][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAP PREHOOK: query: explain select p1.p_name, p2.p_name from part p1 , part p2 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p1.p_name, p2.p_name from part p1 , part p2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -62,10 +66,14 @@ PREHOOK: query: explain select p1.p_name, p2.p_name, p3.p_name from part p1 ,part p2 ,part p3 where p1.p_name = p2.p_name and p2.p_name = p3.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p1.p_name, p2.p_name, p3.p_name from part p1 ,part p2 ,part p3 where p1.p_name = p2.p_name and p2.p_name = p3.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -151,10 +159,14 @@ PREHOOK: query: explain select p1.p_name, p2.p_name, p3.p_name from part p1 , (select p_name from part) p2 ,part p3 where p1.p_name = p2.p_name and p2.p_name = p3.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p1.p_name, p2.p_name, p3.p_name from part p1 , (select p_name from part) p2 ,part p3 where p1.p_name = p2.p_name and p2.p_name = p3.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -241,10 +253,14 @@ PREHOOK: query: explain select p1.p_name, p2.p_name, p3.p_name from part p1 , part p2 , part p3 where p2.p_partkey + p1.p_partkey = p1.p_partkey and p3.p_name = p2.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p1.p_name, p2.p_name, p3.p_name from part p1 , part p2 , part p3 where p2.p_partkey + p1.p_partkey = p1.p_partkey and p3.p_name = p2.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -357,11 +373,15 @@ from part p1 , part p2 join part p3 on p2.p_name = p1.p_name join part p4 where p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2.p_partkey PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p1.p_name, p2.p_name, p3.p_name, p4.p_name from part p1 , part p2 join part p3 on p2.p_name = p1.p_name join part p4 where p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2.p_partkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -521,11 +541,15 @@ from part p1 join part p2 on p2.p_name = p1.p_name , part p3 , part p4 where p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2.p_partkey PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p1.p_name, p2.p_name, p3.p_name, p4.p_name from part p1 join part p2 on p2.p_name = p1.p_name , part p3 , part p4 where p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2.p_partkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out index dc2de9f..c968b38 100644 --- a/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out +++ b/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select * from part p1 join part p2 join part p3 on p1.p_name = p2.p_name and p2.p_name = p3.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 on p1.p_name = p2.p_name and p2.p_name = p3.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -91,9 +95,13 @@ STAGE PLANS: PREHOOK: query: explain select * from part p1 join part p2 join part p3 on p2.p_name = p1.p_name and p3.p_name = p2.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 on p2.p_name = p1.p_name and p3.p_name = p2.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -182,9 +190,13 @@ Warning: Shuffle Join JOIN[13][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'S PREHOOK: query: explain select * from part p1 join part p2 join part p3 on p2.p_partkey + p1.p_partkey = p1.p_partkey and p3.p_name = p2.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 on p2.p_partkey + p1.p_partkey = p1.p_partkey and p3.p_name = p2.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -297,9 +309,13 @@ Warning: Shuffle Join JOIN[13][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'S PREHOOK: query: explain select * from part p1 join part p2 join part p3 on p2.p_partkey = 1 and p3.p_name = p2.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 on p2.p_partkey = 1 and p3.p_name = p2.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out index e1a4c99..93161e6 100644 --- a/ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out +++ b/ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select * from part p1 join part p2 join part p3 on p1.p_name = p2.p_name join part p4 on p2.p_name = p3.p_name and p1.p_name = p4.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 on p1.p_name = p2.p_name join part p4 on p2.p_name = p3.p_name and p1.p_name = p4.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-1 depends on stages: Stage-3 @@ -140,10 +144,14 @@ PREHOOK: query: explain select * from part p1 join part p2 join part p3 on p2.p_name = p1.p_name join part p4 on p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2.p_partkey PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 on p2.p_name = p1.p_name join part p4 on p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2.p_partkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out index c157212..871d318 100644 --- a/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out +++ b/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out @@ -2,10 +2,14 @@ PREHOOK: query: explain select * from part p1 join part p2 join part p3 where p1.p_name = p2.p_name and p2.p_name = p3.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 where p1.p_name = p2.p_name and p2.p_name = p3.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -94,10 +98,14 @@ PREHOOK: query: explain select * from part p1 join part p2 join part p3 where p2.p_name = p1.p_name and p3.p_name = p2.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 where p2.p_name = p1.p_name and p3.p_name = p2.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -187,10 +195,14 @@ PREHOOK: query: explain select * from part p1 join part p2 join part p3 where p2.p_partkey + p1.p_partkey = p1.p_partkey and p3.p_name = p2.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 where p2.p_partkey + p1.p_partkey = p1.p_partkey and p3.p_name = p2.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -304,10 +316,14 @@ PREHOOK: query: explain select * from part p1 join part p2 join part p3 where p2.p_partkey = 1 and p3.p_name = p2.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 where p2.p_partkey = 1 and p3.p_name = p2.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out index b12f0b4..4e969af 100644 --- a/ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out +++ b/ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out @@ -2,10 +2,14 @@ PREHOOK: query: explain select * from part p1 join part p2 join part p3 on p1.p_name = p2.p_name join part p4 where p2.p_name = p3.p_name and p1.p_name = p4.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 on p1.p_name = p2.p_name join part p4 where p2.p_name = p3.p_name and p1.p_name = p4.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-1 depends on stages: Stage-3 @@ -143,11 +147,15 @@ from part p1 join part p2 join part p3 on p2.p_name = p1.p_name join part p4 where p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2.p_partkey PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part p2 join part p3 on p2.p_name = p1.p_name join part p4 where p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2.p_partkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out index 5c2dee3..1d86613 100644 --- a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out +++ b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out @@ -57,9 +57,17 @@ POSTHOOK: Output: default@part3_n0 PREHOOK: query: explain select * from part p1 join part2_n0 p2 join part3_n0 p3 on p1.p_name = p2_name and p2_name = p3_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2_n0 +PREHOOK: Input: default@part3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n0 p2 join part3_n0 p3 on p1.p_name = p2_name and p2_name = p3_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2_n0 +POSTHOOK: Input: default@part3_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -151,9 +159,17 @@ STAGE PLANS: PREHOOK: query: explain select * from part p1 join part2_n0 p2 join part3_n0 p3 on p2_name = p1.p_name and p3_name = p2_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2_n0 +PREHOOK: Input: default@part3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n0 p2 join part3_n0 p3 on p2_name = p1.p_name and p3_name = p2_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2_n0 +POSTHOOK: Input: default@part3_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -246,9 +262,17 @@ Warning: Shuffle Join JOIN[13][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'S PREHOOK: query: explain select * from part p1 join part2_n0 p2 join part3_n0 p3 on p2_partkey + p_partkey = p1.p_partkey and p3_name = p2_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2_n0 +PREHOOK: Input: default@part3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n0 p2 join part3_n0 p3 on p2_partkey + p_partkey = p1.p_partkey and p3_name = p2_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2_n0 +POSTHOOK: Input: default@part3_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -361,9 +385,17 @@ Warning: Shuffle Join JOIN[13][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'S PREHOOK: query: explain select * from part p1 join part2_n0 p2 join part3_n0 p3 on p2_partkey = 1 and p3_name = p2_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2_n0 +PREHOOK: Input: default@part3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n0 p2 join part3_n0 p3 on p2_partkey = 1 and p3_name = p2_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2_n0 +POSTHOOK: Input: default@part3_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out index 536390b..c9017d0 100644 --- a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out +++ b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out @@ -57,9 +57,17 @@ POSTHOOK: Output: default@part3 PREHOOK: query: explain select * from part p1 join part2 p2 join part3 p3 on p1.p_name = p2_name join part p4 on p2_name = p3_name and p1.p_name = p4.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2 +PREHOOK: Input: default@part3 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2 p2 join part3 p3 on p1.p_name = p2_name join part p4 on p2_name = p3_name and p1.p_name = p4.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2 +POSTHOOK: Input: default@part3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -171,10 +179,18 @@ PREHOOK: query: explain select * from part p1 join part2 p2 join part3 p3 on p2_name = p1.p_name join part p4 on p2_name = p3_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2_partkey PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2 +PREHOOK: Input: default@part3 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2 p2 join part3 p3 on p2_name = p1.p_name join part p4 on p2_name = p3_name and p1.p_partkey = p4.p_partkey and p1.p_partkey = p2_partkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2 +POSTHOOK: Input: default@part3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out index 0ce23ae..8ffee7a 100644 --- a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out +++ b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out @@ -58,10 +58,18 @@ PREHOOK: query: explain select * from part p1 join part2_n5 p2 join part3_n2 p3 where p1.p_name = p2_name and p2_name = p3_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2_n5 +PREHOOK: Input: default@part3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n5 p2 join part3_n2 p3 where p1.p_name = p2_name and p2_name = p3_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2_n5 +POSTHOOK: Input: default@part3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -154,10 +162,18 @@ PREHOOK: query: explain select * from part p1 join part2_n5 p2 join part3_n2 p3 where p2_name = p1.p_name and p3_name = p2_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2_n5 +PREHOOK: Input: default@part3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n5 p2 join part3_n2 p3 where p2_name = p1.p_name and p3_name = p2_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2_n5 +POSTHOOK: Input: default@part3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -251,10 +267,18 @@ PREHOOK: query: explain select * from part p1 join part2_n5 p2 join part3_n2 p3 where p2_partkey + p1.p_partkey = p1.p_partkey and p3_name = p2_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2_n5 +PREHOOK: Input: default@part3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n5 p2 join part3_n2 p3 where p2_partkey + p1.p_partkey = p1.p_partkey and p3_name = p2_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2_n5 +POSTHOOK: Input: default@part3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -368,10 +392,18 @@ PREHOOK: query: explain select * from part p1 join part2_n5 p2 join part3_n2 p3 where p2_partkey = 1 and p3_name = p2_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2_n5 +PREHOOK: Input: default@part3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n5 p2 join part3_n2 p3 where p2_partkey = 1 and p3_name = p2_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2_n5 +POSTHOOK: Input: default@part3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1
