http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/correlationoptimizer13.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer13.q.out b/ql/src/test/results/clientpositive/correlationoptimizer13.q.out index ada7921..056bcf9 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer13.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer13.q.out @@ -28,6 +28,8 @@ JOIN (SELECT x1.c1 AS key1, x1.c3 AS key2, count(1) AS cnt FROM tmp x1 WHERE x1.c2 > 100 GROUP BY x1.c3, x1.c1) yy ON (xx.key1 = yy.key1 AND xx.key2 == yy.key2) ORDER BY xx.key1, xx.key2, yy.key1, yy.key2, xx.cnt, yy.cnt PREHOOK: type: QUERY +PREHOOK: Input: default@tmp +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key1, xx.key2, yy.key1, yy.key2, xx.cnt, yy.cnt FROM @@ -36,6 +38,8 @@ JOIN (SELECT x1.c1 AS key1, x1.c3 AS key2, count(1) AS cnt FROM tmp x1 WHERE x1.c2 > 100 GROUP BY x1.c3, x1.c1) yy ON (xx.key1 = yy.key1 AND xx.key2 == yy.key2) ORDER BY xx.key1, xx.key2, yy.key1, yy.key2, xx.cnt, yy.cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp +#### 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/correlationoptimizer14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer14.q.out b/ql/src/test/results/clientpositive/correlationoptimizer14.q.out index e761caf..2467567 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer14.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer14.q.out @@ -6,6 +6,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y DISTRIBUTE BY key) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -14,6 +17,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y DISTRIBUTE BY key) yy ON (xx.key=yy.key) 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, Stage-3 @@ -133,6 +139,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y SORT BY key) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -141,6 +150,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y SORT BY key) yy ON (xx.key=yy.key) 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, Stage-3 @@ -260,6 +272,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y DISTRIBUTE BY key SORT BY key) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -268,6 +283,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y DISTRIBUTE BY key SORT BY key) yy ON (xx.key=yy.key) 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, Stage-3 @@ -446,6 +464,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y DISTRIBUTE BY key SORT BY key) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -454,6 +475,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y DISTRIBUTE BY key SORT BY key) yy ON (xx.key=yy.key) 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 @@ -613,6 +637,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y DISTRIBUTE BY key SORT BY key DESC) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -621,6 +648,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y DISTRIBUTE BY key SORT BY key DESC) yy ON (xx.key=yy.key) 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, Stage-3 @@ -742,6 +772,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y ORDER BY key) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -750,6 +783,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y ORDER BY key) yy ON (xx.key=yy.key) 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, Stage-3 @@ -869,6 +905,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y Cluster BY key) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -877,6 +916,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y Cluster BY key) yy ON (xx.key=yy.key) 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, Stage-3 @@ -1055,6 +1097,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y Cluster BY key) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -1063,6 +1108,9 @@ JOIN (SELECT y.key as key, y.value as value FROM src1 y Cluster BY key) yy ON (xx.key=yy.key) 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 @@ -1222,6 +1270,9 @@ JOIN (SELECT y.key as key, count(*) as value FROM src1 y GROUP BY y.key ORDER BY key) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -1230,6 +1281,9 @@ JOIN (SELECT y.key as key, count(*) as value FROM src1 y GROUP BY y.key ORDER BY key) yy ON (xx.key=yy.key) 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, Stage-3 @@ -1412,6 +1466,9 @@ JOIN (SELECT y.key as key, count(*) as value FROM src1 y GROUP BY y.key ORDER BY key) yy ON (xx.key=yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.value, yy.key, yy.value FROM @@ -1420,6 +1477,9 @@ JOIN (SELECT y.key as key, count(*) as value FROM src1 y GROUP BY y.key ORDER BY key) yy ON (xx.key=yy.key) 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 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/correlationoptimizer15.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer15.q.out b/ql/src/test/results/clientpositive/correlationoptimizer15.q.out index 6e3ea64..b20b16f 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer15.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer15.q.out @@ -5,6 +5,9 @@ FROM JOIN src yy ON xx.key=yy.key ORDER BY xx.key, xx.cnt, yy.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.cnt, yy.key FROM @@ -12,6 +15,9 @@ FROM JOIN src yy ON xx.key=yy.key ORDER BY xx.key, xx.cnt, yy.key 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 @@ -234,6 +240,9 @@ FROM JOIN src yy ON xx.key=yy.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.cnt, yy.key FROM @@ -241,6 +250,9 @@ FROM JOIN src yy ON xx.key=yy.key 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 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/correlationoptimizer5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer5.q.out b/ql/src/test/results/clientpositive/correlationoptimizer5.q.out index 483139c..0c5ae3e 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer5.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer5.q.out @@ -95,6 +95,11 @@ JOIN (SELECT m.key, n.val FROM T3_n5 m JOIN T4_n1 n ON (m.key = n.key)) d ON b.key = d.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n19 +PREHOOK: Input: default@t2_n11 +PREHOOK: Input: default@t3_n5 +PREHOOK: Input: default@t4_n1 +PREHOOK: Output: default@dest_co1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_co1 SELECT b.key, d.val @@ -104,6 +109,11 @@ JOIN (SELECT m.key, n.val FROM T3_n5 m JOIN T4_n1 n ON (m.key = n.key)) d ON b.key = d.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n19 +POSTHOOK: Input: default@t2_n11 +POSTHOOK: Input: default@t3_n5 +POSTHOOK: Input: default@t4_n1 +POSTHOOK: Output: default@dest_co1 STAGE DEPENDENCIES: Stage-4 is a root stage Stage-1 depends on stages: Stage-4 @@ -284,6 +294,11 @@ JOIN (SELECT m.key, n.val FROM T3_n5 m JOIN T4_n1 n ON (m.key = n.key)) d ON b.key = d.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n19 +PREHOOK: Input: default@t2_n11 +PREHOOK: Input: default@t3_n5 +PREHOOK: Input: default@t4_n1 +PREHOOK: Output: default@dest_co2 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_co2 SELECT b.key, d.val @@ -293,6 +308,11 @@ JOIN (SELECT m.key, n.val FROM T3_n5 m JOIN T4_n1 n ON (m.key = n.key)) d ON b.key = d.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n19 +POSTHOOK: Input: default@t2_n11 +POSTHOOK: Input: default@t3_n5 +POSTHOOK: Input: default@t4_n1 +POSTHOOK: Output: default@dest_co2 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -482,6 +502,11 @@ JOIN (SELECT m.key, n.val FROM T3_n5 m JOIN T4_n1 n ON (m.key = n.key)) d ON b.key = d.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n19 +PREHOOK: Input: default@t2_n11 +PREHOOK: Input: default@t3_n5 +PREHOOK: Input: default@t4_n1 +PREHOOK: Output: default@dest_co3 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE dest_co3 SELECT b.key, d.val @@ -491,6 +516,11 @@ JOIN (SELECT m.key, n.val FROM T3_n5 m JOIN T4_n1 n ON (m.key = n.key)) d ON b.key = d.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n19 +POSTHOOK: Input: default@t2_n11 +POSTHOOK: Input: default@t3_n5 +POSTHOOK: Input: default@t4_n1 +POSTHOOK: Output: default@dest_co3 STAGE DEPENDENCIES: Stage-8 is a root stage Stage-6 depends on stages: Stage-8 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/correlationoptimizer7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer7.q.out b/ql/src/test/results/clientpositive/correlationoptimizer7.q.out index e03e669..40aab12 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer7.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer7.q.out @@ -6,6 +6,9 @@ FROM (SELECT x.key AS key, count(1) AS cnt JOIN src1 yy ON xx.key=yy.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.cnt, yy.key, yy.value FROM (SELECT x.key AS key, count(1) AS cnt @@ -14,6 +17,9 @@ FROM (SELECT x.key AS key, count(1) AS cnt JOIN src1 yy ON xx.key=yy.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-9 is a root stage Stage-2 depends on stages: Stage-9 @@ -193,6 +199,9 @@ FROM (SELECT x.key AS key, count(1) AS cnt JOIN src1 yy ON xx.key=yy.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.cnt, yy.key, yy.value FROM (SELECT x.key AS key, count(1) AS cnt @@ -201,6 +210,9 @@ FROM (SELECT x.key AS key, count(1) AS cnt JOIN src1 yy ON xx.key=yy.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-6 is a root stage Stage-2 depends on stages: Stage-6 @@ -377,6 +389,9 @@ FROM (SELECT x.key AS key, count(1) AS cnt JOIN src1 yy ON xx.key=yy.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.cnt, yy.key, yy.value FROM (SELECT x.key AS key, count(1) AS cnt @@ -385,6 +400,9 @@ FROM (SELECT x.key AS key, count(1) AS cnt JOIN src1 yy ON xx.key=yy.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-9 is a root stage Stage-2 depends on stages: Stage-9 @@ -564,6 +582,9 @@ FROM (SELECT x.key AS key, count(1) AS cnt JOIN src1 yy ON xx.key=yy.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, xx.cnt, yy.key, yy.value FROM (SELECT x.key AS key, count(1) AS cnt @@ -572,6 +593,9 @@ FROM (SELECT x.key AS key, count(1) AS cnt JOIN src1 yy ON xx.key=yy.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-6 is a root stage Stage-2 depends on stages: Stage-6 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/correlationoptimizer8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer8.q.out b/ql/src/test/results/clientpositive/correlationoptimizer8.q.out index c403941..36d5777 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer8.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer8.q.out @@ -7,6 +7,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value, subq1.cnt FROM @@ -16,6 +19,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) 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, Stage-3 @@ -206,6 +212,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value, subq1.cnt FROM @@ -215,6 +224,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) 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 @@ -411,6 +423,9 @@ FROM ) subq1 LEFT OUTER JOIN src1 x ON (x.key = subq1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT subq1.key, subq1.cnt, x.key, x.value FROM @@ -420,6 +435,9 @@ FROM ) subq1 LEFT OUTER JOIN src1 x ON (x.key = subq1.key) 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, Stage-3 @@ -626,6 +644,9 @@ FROM ) subq1 LEFT OUTER JOIN src1 x ON (x.key = subq1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT subq1.key, subq1.cnt, x.key, x.value FROM @@ -635,6 +656,9 @@ FROM ) subq1 LEFT OUTER JOIN src1 x ON (x.key = subq1.key) 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 @@ -839,6 +863,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key, x.value, subq1.cnt FROM @@ -848,6 +875,9 @@ FROM ) subq1 JOIN src1 x ON (x.key = subq1.key) 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, Stage-3 @@ -1008,6 +1038,9 @@ FROM ) subq1 FULL OUTER JOIN src1 x ON (x.key = subq1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT subq1.key, subq1.value, x.key, x.value FROM @@ -1017,6 +1050,9 @@ FROM ) subq1 FULL OUTER JOIN src1 x ON (x.key = subq1.key) 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, Stage-3 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/correlationoptimizer9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer9.q.out b/ql/src/test/results/clientpositive/correlationoptimizer9.q.out index f8e75c2..748b168 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer9.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer9.q.out @@ -28,6 +28,8 @@ JOIN (SELECT x1.c2 AS key, count(1) AS cnt FROM tmp_n2 x1 WHERE x1.c2 > 100 GROUP BY x1.c2) yy ON (xx.key = yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tmp_n2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, yy.key, xx.cnt, yy.cnt FROM @@ -36,6 +38,8 @@ JOIN (SELECT x1.c2 AS key, count(1) AS cnt FROM tmp_n2 x1 WHERE x1.c2 > 100 GROUP BY x1.c2) yy ON (xx.key = yy.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1, Stage-3 @@ -196,6 +200,8 @@ JOIN (SELECT x1.c2 AS key, count(1) AS cnt FROM tmp_n2 x1 WHERE x1.c2 > 100 GROUP BY x1.c2) yy ON (xx.key = yy.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tmp_n2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key, yy.key, xx.cnt, yy.cnt FROM @@ -204,6 +210,8 @@ JOIN (SELECT x1.c2 AS key, count(1) AS cnt FROM tmp_n2 x1 WHERE x1.c2 > 100 GROUP BY x1.c2) yy ON (xx.key = yy.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -349,6 +357,8 @@ JOIN (SELECT x1.c1 AS key1, x1.c3 AS key2, count(1) AS cnt FROM tmp_n2 x1 WHERE x1.c2 > 100 GROUP BY x1.c1, x1.c3) yy ON (xx.key1 = yy.key1 AND xx.key2 == yy.key2) PREHOOK: type: QUERY +PREHOOK: Input: default@tmp_n2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key1, xx.key2, yy.key1, yy.key2, xx.cnt, yy.cnt FROM @@ -357,6 +367,8 @@ JOIN (SELECT x1.c1 AS key1, x1.c3 AS key2, count(1) AS cnt FROM tmp_n2 x1 WHERE x1.c2 > 100 GROUP BY x1.c1, x1.c3) yy ON (xx.key1 = yy.key1 AND xx.key2 == yy.key2) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1, Stage-3 @@ -521,6 +533,8 @@ JOIN (SELECT x1.c1 AS key1, x1.c3 AS key2, count(1) AS cnt FROM tmp_n2 x1 WHERE x1.c2 > 100 GROUP BY x1.c1, x1.c3) yy ON (xx.key1 = yy.key1 AND xx.key2 == yy.key2) PREHOOK: type: QUERY +PREHOOK: Input: default@tmp_n2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT xx.key1, xx.key2, yy.key1, yy.key2, xx.cnt, yy.cnt FROM @@ -529,6 +543,8 @@ JOIN (SELECT x1.c1 AS key1, x1.c3 AS key2, count(1) AS cnt FROM tmp_n2 x1 WHERE x1.c2 > 100 GROUP BY x1.c1, x1.c3) yy ON (xx.key1 = yy.key1 AND xx.key2 == yy.key2) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/count_dist_rewrite.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/count_dist_rewrite.q.out b/ql/src/test/results/clientpositive/count_dist_rewrite.q.out index 68f4c5d..31e0d9e 100644 --- a/ql/src/test/results/clientpositive/count_dist_rewrite.q.out +++ b/ql/src/test/results/clientpositive/count_dist_rewrite.q.out @@ -1,7 +1,11 @@ PREHOOK: query: explain select count(distinct key) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(distinct key) from src 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 @@ -87,8 +91,12 @@ POSTHOOK: Input: default@src 309 PREHOOK: query: explain select max(key), count(distinct key) B1_CNTD from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select max(key), count(distinct key) B1_CNTD from src 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 @@ -177,8 +185,12 @@ POSTHOOK: Input: default@src 98 309 PREHOOK: query: explain select max(key), count(distinct key), min(key) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select max(key), count(distinct key), min(key) from src 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 @@ -267,8 +279,12 @@ POSTHOOK: Input: default@src 98 309 0 PREHOOK: query: explain select max(key), count(distinct key), min(key), avg(key) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select max(key), count(distinct key), min(key), avg(key) from src 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 @@ -360,8 +376,12 @@ POSTHOOK: Input: default@src 98 309 0 260.182 PREHOOK: query: explain select count(1), count(distinct key) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1), count(distinct key) from src 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 @@ -456,6 +476,8 @@ PREHOOK: query: explain select max(key) as max_ss_promo_sk from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) as total, count(key) as not_null_total, @@ -464,6 +486,8 @@ POSTHOOK: query: explain select max(key) as max_ss_promo_sk from src 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 @@ -564,8 +588,12 @@ POSTHOOK: Input: default@src 500 500 309 val_98 98 PREHOOK: query: explain select count(1), count(distinct key), cast(STDDEV(key) as int) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1), count(distinct key), cast(STDDEV(key) as int) from src 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 @@ -676,6 +704,8 @@ PREHOOK: query: explain SELECT cast(variance(substr(src.value,5)) as int), cast(var_samp(substr(src.value,5)) as int) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT sum(substr(src.value,5)), avg(substr(src.value,5)), @@ -687,6 +717,8 @@ POSTHOOK: query: explain SELECT cast(variance(substr(src.value,5)) as int), cast(var_samp(substr(src.value,5)) as int) from src 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 @@ -796,8 +828,12 @@ POSTHOOK: Input: default@src 130091.0 260.182 309 98 0 142 143 20428 20469 PREHOOK: query: explain select max(key), count(distinct key), min(key), avg(key) from src group by value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select max(key), count(distinct key), min(key), avg(key) from src group by value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cp_sel.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cp_sel.q.out b/ql/src/test/results/clientpositive/cp_sel.q.out index 8222156..1f88f13 100644 --- a/ql/src/test/results/clientpositive/cp_sel.q.out +++ b/ql/src/test/results/clientpositive/cp_sel.q.out @@ -1,9 +1,17 @@ PREHOOK: query: explain select key,value,'hello' as ds, 'world' as hr from srcpart where hr=11 order by 1 limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain select key,value,'hello' as ds, 'world' as hr from srcpart where hr=11 order by 1 limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -77,9 +85,16 @@ POSTHOOK: Output: default@testpartbucket PREHOOK: query: explain insert overwrite table testpartbucket partition(ds,hr) select key,value,'hello' as ds, 'world' as hr from srcpart where hr=11 PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Output: default@testpartbucket POSTHOOK: query: explain insert overwrite table testpartbucket partition(ds,hr) select key,value,'hello' as ds, 'world' as hr from srcpart where hr=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 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/create_genericudaf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/create_genericudaf.q.out b/ql/src/test/results/clientpositive/create_genericudaf.q.out index dd2ce7f..3fa8cc0 100644 --- a/ql/src/test/results/clientpositive/create_genericudaf.q.out +++ b/ql/src/test/results/clientpositive/create_genericudaf.q.out @@ -1,9 +1,11 @@ PREHOOK: query: EXPLAIN CREATE TEMPORARY FUNCTION test_avg AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFAverage' PREHOOK: type: CREATEFUNCTION +PREHOOK: Output: test_avg POSTHOOK: query: EXPLAIN CREATE TEMPORARY FUNCTION test_avg AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFAverage' POSTHOOK: type: CREATEFUNCTION +POSTHOOK: Output: test_avg STAGE DEPENDENCIES: Stage-0 is a root stage @@ -22,12 +24,16 @@ SELECT test_avg(substr(value,5)) FROM src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT test_avg(1), test_avg(substr(value,5)) FROM src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/create_genericudf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/create_genericudf.q.out b/ql/src/test/results/clientpositive/create_genericudf.q.out index 7af111d..cfe14f5 100644 --- a/ql/src/test/results/clientpositive/create_genericudf.q.out +++ b/ql/src/test/results/clientpositive/create_genericudf.q.out @@ -1,9 +1,11 @@ PREHOOK: query: EXPLAIN CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate' PREHOOK: type: CREATEFUNCTION +PREHOOK: Output: test_translate POSTHOOK: query: EXPLAIN CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate' POSTHOOK: type: CREATEFUNCTION +POSTHOOK: Output: test_translate STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/create_udaf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/create_udaf.q.out b/ql/src/test/results/clientpositive/create_udaf.q.out index d097020..8e20b30 100644 --- a/ql/src/test/results/clientpositive/create_udaf.q.out +++ b/ql/src/test/results/clientpositive/create_udaf.q.out @@ -1,9 +1,11 @@ PREHOOK: query: EXPLAIN CREATE TEMPORARY FUNCTION test_max AS 'org.apache.hadoop.hive.ql.udf.UDAFTestMax' PREHOOK: type: CREATEFUNCTION +PREHOOK: Output: test_max POSTHOOK: query: EXPLAIN CREATE TEMPORARY FUNCTION test_max AS 'org.apache.hadoop.hive.ql.udf.UDAFTestMax' POSTHOOK: type: CREATEFUNCTION +POSTHOOK: Output: test_max STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/create_union_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/create_union_table.q.out b/ql/src/test/results/clientpositive/create_union_table.q.out index f2aedd1..f773f34 100644 --- a/ql/src/test/results/clientpositive/create_union_table.q.out +++ b/ql/src/test/results/clientpositive/create_union_table.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain create table abc(mydata uniontype<int,double,array<string>,struct<a:int,b:string>>, strct struct<a:int, b:string, c:string>) PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@abc POSTHOOK: query: explain create table abc(mydata uniontype<int,double,array<string>,struct<a:int,b:string>>, strct struct<a:int, b:string, c:string>) POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@abc STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/create_view.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/create_view.q.out b/ql/src/test/results/clientpositive/create_view.q.out index 99d1543..2225605 100644 --- a/ql/src/test/results/clientpositive/create_view.q.out +++ b/ql/src/test/results/clientpositive/create_view.q.out @@ -158,9 +158,15 @@ VAL_86 PREHOOK: query: EXPLAIN CREATE VIEW view0(valoo) AS SELECT upper(value) FROM src WHERE key=86 PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view0 POSTHOOK: query: EXPLAIN CREATE VIEW view0(valoo) AS SELECT upper(value) FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@view0 STAGE DEPENDENCIES: Stage-1 is a root stage @@ -176,9 +182,15 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT * from view2 where key=18 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@view2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * from view2 where key=18 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@view2 +#### 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/create_view_translate.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/create_view_translate.q.out b/ql/src/test/results/clientpositive/create_view_translate.q.out index 7a9863f..34ffb33 100644 --- a/ql/src/test/results/clientpositive/create_view_translate.q.out +++ b/ql/src/test/results/clientpositive/create_view_translate.q.out @@ -125,9 +125,15 @@ POSTHOOK: Output: default@items PREHOOK: query: explain CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@items +PREHOOK: Output: database:default +PREHOOK: Output: default@priceview POSTHOOK: query: explain CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@items +POSTHOOK: Output: database:default +POSTHOOK: Output: default@priceview STAGE DEPENDENCIES: Stage-1 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cross_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cross_join.q.out b/ql/src/test/results/clientpositive/cross_join.q.out index b9daa35..2f9e0cd 100644 --- a/ql/src/test/results/clientpositive/cross_join.q.out +++ b/ql/src/test/results/clientpositive/cross_join.q.out @@ -1,8 +1,12 @@ Warning: Shuffle Join JOIN[6][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product PREHOOK: query: explain select src.key from src join src src2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src.key from src join src src2 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 @@ -56,8 +60,12 @@ STAGE PLANS: Warning: Shuffle Join JOIN[6][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product PREHOOK: query: explain select src.key from src cross join src src2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src.key from src cross join src src2 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 @@ -110,8 +118,12 @@ STAGE PLANS: PREHOOK: query: explain select src.key from src cross join src src2 on src.key=src2.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src.key from src cross join src src2 on src.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 @@ -178,8 +190,12 @@ STAGE PLANS: Warning: Map Join MAPJOIN[9][bigTable=?] in task 'Stage-3:MAPRED' is a cross product PREHOOK: query: explain select src.key from src join src src2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src.key from src join src src2 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 @@ -242,8 +258,12 @@ STAGE PLANS: Warning: Map Join MAPJOIN[9][bigTable=?] in task 'Stage-3:MAPRED' is a cross product PREHOOK: query: explain select src.key from src cross join src src2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src.key from src cross join src src2 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 @@ -305,8 +325,12 @@ STAGE PLANS: PREHOOK: query: explain select src.key from src cross join src src2 on src.key=src2.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src.key from src cross join src src2 on src.key=src2.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 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cross_join_merge.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cross_join_merge.q.out b/ql/src/test/results/clientpositive/cross_join_merge.q.out index 016acc6..3e02fa1 100644 --- a/ql/src/test/results/clientpositive/cross_join_merge.q.out +++ b/ql/src/test/results/clientpositive/cross_join_merge.q.out @@ -2,9 +2,13 @@ Warning: Shuffle Join JOIN[9][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'St PREHOOK: query: explain select src1.key from src src1 join src src2 join src src3 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key from src src1 join src src2 join src src3 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 @@ -68,9 +72,13 @@ STAGE PLANS: PREHOOK: query: explain select src1.key from src src1 join src src2 on src1.key=src2.key join src src3 on src1.key=src3.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key from src src1 join src src2 on src1.key=src2.key join src src3 on src1.key=src3.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 @@ -155,9 +163,13 @@ STAGE PLANS: PREHOOK: query: explain select src1.key from src src1 join src src2 join src src3 where src1.key=src2.key and src1.key=src3.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key from src src1 join src src2 join src src3 where src1.key=src2.key and src1.key=src3.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 @@ -243,9 +255,13 @@ Warning: Shuffle Join JOIN[14][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'S PREHOOK: query: explain select src1.key from src src1 join src src2 on 5 = src2.key join src src3 on src1.key=src3.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key from src src1 join src src2 on 5 = src2.key join src src3 on src1.key=src3.key 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 @@ -351,9 +367,13 @@ Warning: Shuffle Join JOIN[8][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAP PREHOOK: query: explain select src1.key from src src1 left outer join src src2 join src src3 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key from src src1 left outer join src src2 join src src3 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 @@ -440,9 +460,13 @@ STAGE PLANS: PREHOOK: query: explain select src1.key from src src1 left outer join src src2 on src1.key=src2.key join src src3 on src1.key=src3.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key from src src1 left outer join src src2 on src1.key=src2.key join src src3 on src1.key=src3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cross_product_check_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cross_product_check_1.q.out b/ql/src/test/results/clientpositive/cross_product_check_1.q.out index 2d1eb7e..ea9759a 100644 --- a/ql/src/test/results/clientpositive/cross_product_check_1.q.out +++ b/ql/src/test/results/clientpositive/cross_product_check_1.q.out @@ -31,8 +31,14 @@ POSTHOOK: Lineage: b_n6.value SIMPLE [(src)src.FieldSchema(name:value, type:stri Warning: Shuffle Join JOIN[6][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product PREHOOK: query: explain select * from A_n8 join B_n6 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n8 +PREHOOK: Input: default@b_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select * from A_n8 join B_n6 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n8 +POSTHOOK: Input: default@b_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -89,8 +95,14 @@ STAGE PLANS: Warning: Shuffle Join JOIN[13][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Stage-2:MAPRED' is a cross product PREHOOK: query: explain select * from B_n6 d1 join B_n6 d2 on d1.key = d2.key join A_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n8 +PREHOOK: Input: default@b_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select * from B_n6 d1 join B_n6 d2 on d1.key = d2.key join A_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n8 +POSTHOOK: Input: default@b_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -198,11 +210,17 @@ PREHOOK: query: explain select * from A_n8 join from B_n6 d1 join B_n6 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n8 +PREHOOK: Input: default@b_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select * from A_n8 join (select d1.key from B_n6 d1 join B_n6 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n8 +POSTHOOK: Input: default@b_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -335,8 +353,14 @@ Warning: Shuffle Join JOIN[16][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MA Warning: Shuffle Join JOIN[8][tables = [$hdt$_1, $hdt$_2]] in Stage 'Stage-2:MAPRED' is a cross product PREHOOK: query: explain select * from A_n8 join (select d1.key from B_n6 d1 join B_n6 d2 where 1 = 1 group by d1.key) od1 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n8 +PREHOOK: Input: default@b_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select * from A_n8 join (select d1.key from B_n6 d1 join B_n6 d2 where 1 = 1 group by d1.key) od1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n8 +POSTHOOK: Input: default@b_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -457,10 +481,16 @@ PREHOOK: query: explain select * from (select A_n8.key from A_n8 group by key) ss join (select d1.key from B_n6 d1 join B_n6 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n8 +PREHOOK: Input: default@b_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select A_n8.key from A_n8 group by key) ss join (select d1.key from B_n6 d1 join B_n6 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n8 +POSTHOOK: Input: default@b_n6 +#### 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/cross_product_check_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cross_product_check_2.q.out b/ql/src/test/results/clientpositive/cross_product_check_2.q.out index 61c4074..2f1e4b5 100644 --- a/ql/src/test/results/clientpositive/cross_product_check_2.q.out +++ b/ql/src/test/results/clientpositive/cross_product_check_2.q.out @@ -31,8 +31,14 @@ POSTHOOK: Lineage: b_n2.value SIMPLE [(src)src.FieldSchema(name:value, type:stri Warning: Map Join MAPJOIN[9][bigTable=?] in task 'Stage-3:MAPRED' is a cross product PREHOOK: query: explain select * from A_n2 join B_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n2 +PREHOOK: Input: default@b_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from A_n2 join B_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n2 +POSTHOOK: Input: default@b_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-4 is a root stage Stage-3 depends on stages: Stage-4 @@ -97,8 +103,14 @@ STAGE PLANS: Warning: Map Join MAPJOIN[20][bigTable=?] in task 'Stage-5:MAPRED' is a cross product PREHOOK: query: explain select * from B_n2 d1 join B_n2 d2 on d1.key = d2.key join A_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n2 +PREHOOK: Input: default@b_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from B_n2 d1 join B_n2 d2 on d1.key = d2.key join A_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n2 +POSTHOOK: Input: default@b_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-7 is a root stage Stage-5 depends on stages: Stage-7 @@ -197,11 +209,17 @@ PREHOOK: query: explain select * from A_n2 join from B_n2 d1 join B_n2 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n2 +PREHOOK: Input: default@b_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from A_n2 join (select d1.key from B_n2 d1 join B_n2 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n2 +POSTHOOK: Input: default@b_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-8 is a root stage Stage-3 depends on stages: Stage-8 @@ -335,8 +353,14 @@ Warning: Map Join MAPJOIN[23][bigTable=?] in task 'Stage-5:MAPRED' is a cross pr Warning: Map Join MAPJOIN[24][bigTable=?] in task 'Stage-3:MAPRED' is a cross product PREHOOK: query: explain select * from A_n2 join (select d1.key from B_n2 d1 join B_n2 d2 where 1 = 1 group by d1.key) od1 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n2 +PREHOOK: Input: default@b_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from A_n2 join (select d1.key from B_n2 d1 join B_n2 d2 where 1 = 1 group by d1.key) od1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n2 +POSTHOOK: Input: default@b_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-8 is a root stage Stage-3 depends on stages: Stage-8 @@ -463,10 +487,16 @@ PREHOOK: query: explain select * from (select A_n2.key from A_n2 group by key) ss join (select d1.key from B_n2 d1 join B_n2 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1 PREHOOK: type: QUERY +PREHOOK: Input: default@a_n2 +PREHOOK: Input: default@b_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select A_n2.key from A_n2 group by key) ss join (select d1.key from B_n2 d1 join B_n2 d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n2 +POSTHOOK: Input: default@b_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-8 depends on stages: Stage-1, Stage-4 , consists of Stage-10, Stage-11, Stage-2 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/ctas.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/ctas.q.out b/ql/src/test/results/clientpositive/ctas.q.out index 5f1a379..f414c68 100644 --- a/ql/src/test/results/clientpositive/ctas.q.out +++ b/ql/src/test/results/clientpositive/ctas.q.out @@ -16,8 +16,14 @@ POSTHOOK: Input: default@nzhang_tmp #### A masked pattern was here #### PREHOOK: query: explain create table nzhang_CTAS1 as select key k, value from src sort by k, value limit 10 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_CTAS1 POSTHOOK: query: explain create table nzhang_CTAS1 as select key k, value from src sort by k, value limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_CTAS1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -170,8 +176,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain create table nzhang_ctas2 as select * from src sort by key, value limit 10 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas2 POSTHOOK: query: explain create table nzhang_ctas2 as select * from src sort by key, value limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_ctas2 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -324,8 +336,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain create table nzhang_ctas3 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas3 POSTHOOK: query: explain create table nzhang_ctas3 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_ctas3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -542,8 +560,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain create table nzhang_ctas4 row format delimited fields terminated by ',' stored as textfile as select key, value from src sort by key, value limit 10 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas4 POSTHOOK: query: explain create table nzhang_ctas4 row format delimited fields terminated by ',' stored as textfile as select key, value from src sort by key, value limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_ctas4 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -698,8 +722,14 @@ Storage Desc Params: serialization.format , PREHOOK: query: explain create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas5 POSTHOOK: query: explain create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_ctas5 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/ctas_colname.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/ctas_colname.q.out b/ql/src/test/results/clientpositive/ctas_colname.q.out index 0c08845..9cc82d1 100644 --- a/ql/src/test/results/clientpositive/ctas_colname.q.out +++ b/ql/src/test/results/clientpositive/ctas_colname.q.out @@ -1,9 +1,15 @@ PREHOOK: query: explain create table summary as select *, key + 1, concat(value, value) from src limit 20 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@summary POSTHOOK: query: explain create table summary as select *, key + 1, concat(value, value) from src limit 20 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@summary STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -148,9 +154,15 @@ POSTHOOK: Input: default@summary PREHOOK: query: explain create table x4 as select *, rank() over(partition by key order by value) as rr from src1 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src1 +PREHOOK: Output: database:default +PREHOOK: Output: default@x4 POSTHOOK: query: explain create table x4 as select *, rank() over(partition by key order by value) as rr from src1 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src1 +POSTHOOK: Output: database:default +POSTHOOK: Output: default@x4 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -313,9 +325,15 @@ POSTHOOK: Input: default@x4 PREHOOK: query: explain create table x5 as select *, lead(key,1) over(partition by key order by value) as lead1 from src limit 20 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@x5 POSTHOOK: query: explain create table x5 as select *, lead(key,1) over(partition by key order by value) as lead1 from src limit 20 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@x5 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -502,9 +520,15 @@ POSTHOOK: Input: default@x5 PREHOOK: query: explain create table x6 as select * from (select *, key + 1 from src1) a PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src1 +PREHOOK: Output: database:default +PREHOOK: Output: default@x6 POSTHOOK: query: explain create table x6 as select * from (select *, key + 1 from src1) a POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src1 +POSTHOOK: Output: database:default +POSTHOOK: Output: default@x6 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5 @@ -680,9 +704,15 @@ POSTHOOK: Input: default@x6 PREHOOK: query: explain create table x7 as select * from (select *, count(value) from src group by key, value) a PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@x7 POSTHOOK: query: explain create table x7 as select * from (select *, count(value) from src group by key, value) a POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@x7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1117,9 +1147,15 @@ POSTHOOK: Input: default@x7 PREHOOK: query: explain create table x8 as select * from (select *, count(value) from src group by key, value having key < 9) a PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@x8 POSTHOOK: query: explain create table x8 as select * from (select *, count(value) from src group by key, value having key < 9) a POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@x8 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1250,9 +1286,15 @@ POSTHOOK: Input: default@x8 PREHOOK: query: explain create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@x9 POSTHOOK: query: explain create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@x9 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/ctas_uses_database_location.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out b/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out index 68bc015..8cf7fe1 100644 --- a/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out +++ b/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out @@ -16,8 +16,14 @@ POSTHOOK: type: SWITCHDATABASE POSTHOOK: Input: database:db1 PREHOOK: query: EXPLAIN CREATE TABLE table_db1 AS SELECT * FROM default.src PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:db1 +PREHOOK: Output: db1@table_db1 POSTHOOK: query: EXPLAIN CREATE TABLE table_db1 AS SELECT * FROM default.src POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:db1 +POSTHOOK: Output: db1@table_db1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cte_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_1.q.out b/ql/src/test/results/clientpositive/cte_1.q.out index 0edfeb7..ed68d87 100644 --- a/ql/src/test/results/clientpositive/cte_1.q.out +++ b/ql/src/test/results/clientpositive/cte_1.q.out @@ -3,11 +3,15 @@ with q1 as ( select key from src where key = '5') select * from q1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as ( select key from src where key = '5') select * from q1 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 @@ -61,10 +65,14 @@ PREHOOK: query: explain with q1 as ( select key from src where key = '5') select * from (select key from q1) a PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as ( select key from src where key = '5') select * from (select key from q1) a 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 @@ -117,11 +125,15 @@ with q1 as ( select key from q2 where key = '5'), q2 as ( select key from src where key = '5') select * from (select key from q1) a PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as ( select key from q2 where key = '5'), q2 as ( select key from src where key = '5') select * from (select key from q1) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cte_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_3.q.out b/ql/src/test/results/clientpositive/cte_3.q.out index d3884f1..afcfc70 100644 --- a/ql/src/test/results/clientpositive/cte_3.q.out +++ b/ql/src/test/results/clientpositive/cte_3.q.out @@ -3,11 +3,15 @@ with q1 as ( select key from src where key = '5') select * from q1 PREHOOK: type: QUERY +PREHOOK: Input: default@q1 +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as ( select key from src where key = '5') select * from q1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@q1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-6 depends on stages: Stage-1 , consists of Stage-3, Stage-2, Stage-4 @@ -126,10 +130,14 @@ PREHOOK: query: explain with q1 as ( select key from src where key = '5') select * from (select key from q1) a PREHOOK: type: QUERY +PREHOOK: Input: default@q1 +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as ( select key from src where key = '5') select * from (select key from q1) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@q1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-6 depends on stages: Stage-1 , consists of Stage-3, Stage-2, Stage-4 @@ -247,11 +255,15 @@ with q1 as ( select key from q2 where key = '5'), q2 as ( select key from src where key = '5') select * from (select key from q1) a PREHOOK: type: QUERY +PREHOOK: Input: default@q1 +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as ( select key from q2 where key = '5'), q2 as ( select key from src where key = '5') select * from (select key from q1) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@q1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-6 depends on stages: Stage-1 , consists of Stage-3, Stage-2, Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cte_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_5.q.out b/ql/src/test/results/clientpositive/cte_5.q.out index 6789cd3..5adcde2 100644 --- a/ql/src/test/results/clientpositive/cte_5.q.out +++ b/ql/src/test/results/clientpositive/cte_5.q.out @@ -48,12 +48,18 @@ select a.colnum from mydb.q1_n0 as a join q1_n0 as b on a.colnum=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: mydb@q1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain with q1_n0 as (select * from src where key= '5') select a.colnum from mydb.q1_n0 as a join q1_n0 as b on a.colnum=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: mydb@q1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cte_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_6.q.out b/ql/src/test/results/clientpositive/cte_6.q.out index 2bf6589..502ea11 100644 --- a/ql/src/test/results/clientpositive/cte_6.q.out +++ b/ql/src/test/results/clientpositive/cte_6.q.out @@ -2,10 +2,14 @@ PREHOOK: query: explain with Q1 as ( select key from sRc where key = '5') select CPS.key from Q1 CPS PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain with Q1 as ( select key from sRc where key = '5') select CPS.key from Q1 CPS 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 @@ -45,11 +49,15 @@ with Q1 as ( select key from q2 where key = '5'), Q2 as ( select key from sRc where key = '5') select CPS.key from Q1 CPS PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain with Q1 as ( select key from q2 where key = '5'), Q2 as ( select key from sRc where key = '5') select CPS.key from Q1 CPS POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cte_mat_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_1.q.out b/ql/src/test/results/clientpositive/cte_mat_1.q.out index 7e84cba..2553033 100644 --- a/ql/src/test/results/clientpositive/cte_mat_1.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_1.q.out @@ -5,12 +5,16 @@ select a.key from q1 a join q1 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as (select * from src where key= '5') select a.key from q1 a join q1 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cte_mat_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_2.q.out b/ql/src/test/results/clientpositive/cte_mat_2.q.out index 7e84cba..2553033 100644 --- a/ql/src/test/results/clientpositive/cte_mat_2.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_2.q.out @@ -5,12 +5,16 @@ select a.key from q1 a join q1 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as (select * from src where key= '5') select a.key from q1 a join q1 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cte_mat_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_3.q.out b/ql/src/test/results/clientpositive/cte_mat_3.q.out index 3d597c0..377adfc 100644 --- a/ql/src/test/results/clientpositive/cte_mat_3.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_3.q.out @@ -4,12 +4,16 @@ select a.key from q1 a join q1 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@q1 +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as (select * from src where key= '5') select a.key from q1 a join q1 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@q1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-6 depends on stages: Stage-1 , consists of Stage-3, Stage-2, Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cte_mat_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_4.q.out b/ql/src/test/results/clientpositive/cte_mat_4.q.out index 943ca59..5a94775 100644 --- a/ql/src/test/results/clientpositive/cte_mat_4.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_4.q.out @@ -29,12 +29,16 @@ select a.key from q1 a join q1 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@q1 +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as (select * from src where key= '5') select a.key from q1 a join q1 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@q1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-6 depends on stages: Stage-1 , consists of Stage-3, Stage-2, Stage-4 @@ -239,12 +243,16 @@ select a.key from q1 a join q1 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@q1 +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as (select * from src where key= '5') select a.key from q1 a join q1 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@q1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-6 depends on stages: Stage-1 , consists of Stage-3, Stage-2, Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/cte_mat_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_mat_5.q.out b/ql/src/test/results/clientpositive/cte_mat_5.q.out index 1a6f086..4f8e12f 100644 --- a/ql/src/test/results/clientpositive/cte_mat_5.q.out +++ b/ql/src/test/results/clientpositive/cte_mat_5.q.out @@ -47,12 +47,18 @@ select a.colnum from mydb.q1 as a join q1 as b on a.colnum=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@q1 +PREHOOK: Input: mydb@q1 +#### A masked pattern was here #### POSTHOOK: query: explain with q1 as (select * from src where key= '5') select a.colnum from mydb.q1 as a join q1 as b on a.colnum=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@q1 +POSTHOOK: Input: mydb@q1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-6 depends on stages: Stage-1 , consists of Stage-3, Stage-2, Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/decimal_join2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_join2.q.out b/ql/src/test/results/clientpositive/decimal_join2.q.out index 43610ea..544dce9 100644 --- a/ql/src/test/results/clientpositive/decimal_join2.q.out +++ b/ql/src/test/results/clientpositive/decimal_join2.q.out @@ -43,9 +43,13 @@ POSTHOOK: Lineage: decimal_3_n0.value SIMPLE [(decimal_3_txt)decimal_3_txt.Field PREHOOK: query: EXPLAIN SELECT * FROM DECIMAL_3_n0 a JOIN DECIMAL_3_n0 b ON (a.key = b.key) ORDER BY a.key, a.value, b.key, b.value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_3_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM DECIMAL_3_n0 a JOIN DECIMAL_3_n0 b ON (a.key = b.key) ORDER BY a.key, a.value, b.key, b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_3_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -209,9 +213,13 @@ POSTHOOK: Input: default@decimal_3_n0 PREHOOK: query: EXPLAIN SELECT * FROM DECIMAL_3_n0 a JOIN DECIMAL_3_n0 b ON (a.key = b.key) ORDER BY a.key, a.value, b.key, b.value PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_3_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM DECIMAL_3_n0 a JOIN DECIMAL_3_n0 b ON (a.key = b.key) ORDER BY a.key, a.value, b.key, b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_3_n0 +#### 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/decimal_precision.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_precision.q.out b/ql/src/test/results/clientpositive/decimal_precision.q.out index fb59c4f..e5393ae 100644 --- a/ql/src/test/results/clientpositive/decimal_precision.q.out +++ b/ql/src/test/results/clientpositive/decimal_precision.q.out @@ -524,8 +524,12 @@ NULL NULL NULL NULL PREHOOK: query: EXPLAIN SELECT avg(`dec`), sum(`dec`) FROM DECIMAL_PRECISION_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_precision_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT avg(`dec`), sum(`dec`) FROM DECIMAL_PRECISION_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_precision_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/decimal_precision2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_precision2.q.out b/ql/src/test/results/clientpositive/decimal_precision2.q.out index 3185c38..3ec620c 100644 --- a/ql/src/test/results/clientpositive/decimal_precision2.q.out +++ b/ql/src/test/results/clientpositive/decimal_precision2.q.out @@ -1,7 +1,11 @@ PREHOOK: query: explain select 100.001BD PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### POSTHOOK: query: explain select 100.001BD POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -22,8 +26,12 @@ STAGE PLANS: PREHOOK: query: explain select 100.000BD PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### POSTHOOK: query: explain select 100.000BD POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -44,8 +52,12 @@ STAGE PLANS: PREHOOK: query: explain select 0.000BD PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### POSTHOOK: query: explain select 0.000BD POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -66,8 +78,12 @@ STAGE PLANS: PREHOOK: query: explain select 0.100BD PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### POSTHOOK: query: explain select 0.100BD POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -88,8 +104,12 @@ STAGE PLANS: PREHOOK: query: explain select 0.010BD PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### POSTHOOK: query: explain select 0.010BD POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -110,8 +130,12 @@ STAGE PLANS: PREHOOK: query: explain select cast(0.010 as decimal(6,3)) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### POSTHOOK: query: explain select cast(0.010 as decimal(6,3)) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -132,8 +156,12 @@ STAGE PLANS: PREHOOK: query: explain select 0.09765625BD * 0.09765625BD * 0.0125BD * 578992BD PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### POSTHOOK: query: explain select 0.09765625BD * 0.09765625BD * 0.0125BD * 578992BD POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/decimal_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_stats.q.out b/ql/src/test/results/clientpositive/decimal_stats.q.out index de3b66d..27abe6e 100644 --- a/ql/src/test/results/clientpositive/decimal_stats.q.out +++ b/ql/src/test/results/clientpositive/decimal_stats.q.out @@ -63,8 +63,12 @@ comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"t\":\"true\",\"u\":\"true\",\"v\":\"true\"}} PREHOOK: query: explain select * from decimal_1_n1 order by t limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@decimal_1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from decimal_1_n1 order by t limit 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@decimal_1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1