http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/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 0927b91..cc9d5aa 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 @@ -643,9 +647,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 @@ -1754,10 +1762,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 @@ -2416,10 +2428,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 @@ -3078,10 +3094,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 @@ -3725,9 +3745,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/c39b5d1b/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 50ce9f6..692ce22 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 @@ -90,9 +94,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/c39b5d1b/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 045c395..78206a7 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/c39b5d1b/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 8535c43..d0bf77a 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 @@ -447,6 +455,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 ( @@ -463,6 +475,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/c39b5d1b/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 1ca04b3..3c9412d 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/c39b5d1b/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 f2cca31..1bbc06c 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 @@ -106,12 +112,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 @@ -213,6 +225,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 @@ -221,6 +236,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 @@ -313,6 +331,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 @@ -321,6 +342,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 @@ -419,6 +443,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 @@ -426,6 +453,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 @@ -518,6 +548,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 @@ -525,6 +558,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 @@ -710,6 +752,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 @@ -717,6 +762,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 @@ -857,6 +905,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 @@ -864,6 +915,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 @@ -1000,6 +1054,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 @@ -1007,6 +1064,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 @@ -1143,6 +1203,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 @@ -1150,6 +1213,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 @@ -1276,6 +1342,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 @@ -1283,6 +1352,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 @@ -1419,6 +1491,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 @@ -1426,6 +1501,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 @@ -1564,6 +1642,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 @@ -1573,6 +1654,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/c39b5d1b/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 07582e1..0c9405f 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 @@ -237,12 +249,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 @@ -330,11 +348,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 @@ -418,11 +442,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 @@ -514,6 +544,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 @@ -521,6 +554,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 @@ -614,12 +650,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 @@ -711,12 +753,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 @@ -803,6 +851,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 @@ -810,6 +861,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 @@ -900,12 +954,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 @@ -997,6 +1057,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 @@ -1004,6 +1067,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 @@ -1097,12 +1163,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 @@ -1191,12 +1263,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 @@ -1285,6 +1363,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 @@ -1292,6 +1373,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 @@ -1381,6 +1465,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 @@ -1388,6 +1475,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 @@ -1481,12 +1571,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 @@ -1578,12 +1674,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 @@ -1672,6 +1774,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 @@ -1679,6 +1784,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 @@ -1785,6 +1893,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 ( @@ -1805,6 +1916,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/c39b5d1b/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 4a13df8..1da3a83 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 @@ -106,12 +112,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 @@ -213,6 +225,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 @@ -221,6 +236,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 @@ -313,6 +331,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 @@ -321,6 +342,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 @@ -417,6 +441,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 @@ -424,6 +451,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 @@ -514,6 +544,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 @@ -521,6 +554,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 @@ -614,12 +650,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 @@ -702,6 +744,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 @@ -709,6 +754,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 @@ -847,6 +895,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 @@ -854,6 +905,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 @@ -988,6 +1042,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 @@ -995,6 +1052,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 @@ -1129,6 +1189,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 @@ -1136,6 +1199,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 @@ -1260,6 +1326,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 @@ -1267,6 +1336,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 @@ -1401,6 +1473,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 @@ -1408,6 +1483,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 @@ -1544,6 +1622,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 @@ -1553,6 +1634,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/c39b5d1b/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 a21f35a..2e0ef5c 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/c39b5d1b/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 2d73af2..27edf3e 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/c39b5d1b/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 490ab1b..bda8fa0 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/c39b5d1b/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 d27098e..96054ff 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/c39b5d1b/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 343df28..63825b9 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 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/c39b5d1b/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 5f9a7ce..0a1f40e 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 @@ -148,10 +156,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 @@ -235,10 +247,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 @@ -349,11 +365,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, Stage-4 @@ -511,11 +531,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, Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/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 831d84f..b12bf75 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 @@ -88,9 +92,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 @@ -176,9 +184,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 @@ -289,9 +301,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/c39b5d1b/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 374aefb..4c723f0 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 @@ -136,10 +140,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, Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/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 560b8e0..35344b7 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 @@ -91,10 +95,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 @@ -181,10 +189,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 @@ -296,10 +308,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/c39b5d1b/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 0270744..c094666 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 @@ -139,11 +143,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, Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/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 9f273dc..30d8518 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 @@ -148,9 +156,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 @@ -240,9 +256,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 @@ -353,9 +377,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/c39b5d1b/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 bd37fc7..1fddca3 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 @@ -167,10 +175,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/c39b5d1b/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 1e27c28..f63aaae 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 @@ -151,10 +159,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 @@ -245,10 +261,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 @@ -360,10 +384,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 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out index 68c6b81..f3d8e23 100644 --- a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out +++ b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out @@ -58,10 +58,18 @@ PREHOOK: query: explain select * from part p1 join part2_n4 p2 join part3_n1 p3 on p1.p_name = p2_name join part p4 where p2_name = p3_name and p1.p_name = p4.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part2_n4 +PREHOOK: Input: default@part3_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n4 p2 join part3_n1 p3 on p1.p_name = p2_name join part p4 where p2_name = p3_name and p1.p_name = p4.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part2_n4 +POSTHOOK: Input: default@part3_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -170,11 +178,19 @@ from part p1 join part2_n4 p2 join part3_n1 p3 on p2_name = p1.p_name join part where 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_n4 +PREHOOK: Input: default@part3_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part p1 join part2_n4 p2 join part3_n1 p3 on p2_name = p1.p_name join part p4 where 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_n4 +POSTHOOK: Input: default@part3_n1 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out index d80bbf1..9492ca9 100644 --- a/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out +++ b/ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out @@ -39,8 +39,14 @@ POSTHOOK: Lineage: rtable.rk1 SCRIPT [] POSTHOOK: Lineage: rtable.rk2 SCRIPT [] PREHOOK: query: EXPLAIN SELECT * FROM ltable l LEFT OUTER JOIN rtable r on (l.lk1 = r.rk1 AND l.lk2 = r.rk2) WHERE COALESCE(l.la,'EMPTY')=COALESCE(r.ra,'EMPTY') PREHOOK: type: QUERY +PREHOOK: Input: default@ltable +PREHOOK: Input: default@rtable +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM ltable l LEFT OUTER JOIN rtable r on (l.lk1 = r.rk1 AND l.lk2 = r.rk2) WHERE COALESCE(l.la,'EMPTY')=COALESCE(r.ra,'EMPTY') POSTHOOK: type: QUERY +POSTHOOK: Input: default@ltable +POSTHOOK: Input: default@rtable +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -114,8 +120,14 @@ POSTHOOK: Input: default@rtable 2 NULL CD5415192225530 00071 NULL NULL NULL PREHOOK: query: EXPLAIN SELECT * FROM ltable l LEFT OUTER JOIN rtable r on (l.lk1 = r.rk1 AND l.lk2 = r.rk2) WHERE COALESCE(l.la,'EMPTY')=COALESCE(r.ra,'EMPTY') PREHOOK: type: QUERY +PREHOOK: Input: default@ltable +PREHOOK: Input: default@rtable +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM ltable l LEFT OUTER JOIN rtable r on (l.lk1 = r.rk1 AND l.lk2 = r.rk2) WHERE COALESCE(l.la,'EMPTY')=COALESCE(r.ra,'EMPTY') POSTHOOK: type: QUERY +POSTHOOK: Input: default@ltable +POSTHOOK: Input: default@rtable +#### 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/c39b5d1b/ql/src/test/results/clientpositive/join_emit_interval.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_emit_interval.q.out b/ql/src/test/results/clientpositive/join_emit_interval.q.out index 6b8178d..44d69da 100644 --- a/ql/src/test/results/clientpositive/join_emit_interval.q.out +++ b/ql/src/test/results/clientpositive/join_emit_interval.q.out @@ -45,11 +45,17 @@ SELECT * FROM test1_n7 LEFT OUTER JOIN test2_n4 ON (test1_n7.value=test2_n4.value AND test1_n7.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n7 +PREHOOK: Input: default@test2_n4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n7 LEFT OUTER JOIN test2_n4 ON (test1_n7.value=test2_n4.value AND test1_n7.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n7 +POSTHOOK: Input: default@test2_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -137,11 +143,17 @@ SELECT * FROM test1_n7 LEFT OUTER JOIN test2_n4 ON (test1_n7.key between 100 and 102) PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n7 +PREHOOK: Input: default@test2_n4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM test1_n7 LEFT OUTER JOIN test2_n4 ON (test1_n7.key between 100 and 102) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n7 +POSTHOOK: Input: default@test2_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/join_filters_overlap.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_filters_overlap.q.out b/ql/src/test/results/clientpositive/join_filters_overlap.q.out index cc34704..03dcfe8 100644 --- a/ql/src/test/results/clientpositive/join_filters_overlap.q.out +++ b/ql/src/test/results/clientpositive/join_filters_overlap.q.out @@ -12,8 +12,12 @@ POSTHOOK: Lineage: a_n4.key SIMPLE [] POSTHOOK: Lineage: a_n4.value SCRIPT [] PREHOOK: query: explain extended select * from a_n4 left outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50) left outer join a_n4 c on (a_n4.key=c.key AND a_n4.value=60 AND c.value=60) PREHOOK: type: QUERY +PREHOOK: Input: default@a_n4 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from a_n4 left outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50) left outer join a_n4 c on (a_n4.key=c.key AND a_n4.value=60 AND c.value=60) POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -205,8 +209,12 @@ POSTHOOK: Input: default@a_n4 100 60 NULL NULL 100 60 PREHOOK: query: explain extended select * from a_n4 right outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50) left outer join a_n4 c on (b.key=c.key AND b.value=60 AND c.value=60) PREHOOK: type: QUERY +PREHOOK: Input: default@a_n4 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from a_n4 right outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50) left outer join a_n4 c on (b.key=c.key AND b.value=60 AND c.value=60) POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -398,8 +406,12 @@ NULL NULL 100 40 NULL NULL NULL NULL 100 60 100 60 PREHOOK: query: explain extended select * from a_n4 right outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50 AND b.value>10) left outer join a_n4 c on (b.key=c.key AND b.value=60 AND b.value>20 AND c.value=60) PREHOOK: type: QUERY +PREHOOK: Input: default@a_n4 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from a_n4 right outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50 AND b.value>10) left outer join a_n4 c on (b.key=c.key AND b.value=60 AND b.value>20 AND c.value=60) POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -591,8 +603,12 @@ NULL NULL 100 40 NULL NULL NULL NULL 100 60 100 60 PREHOOK: query: explain extended select * from a_n4 full outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50) left outer join a_n4 c on (b.key=c.key AND b.value=60 AND c.value=60) left outer join a_n4 d on (a_n4.key=d.key AND a_n4.value=40 AND d.value=40) PREHOOK: type: QUERY +PREHOOK: Input: default@a_n4 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from a_n4 full outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50) left outer join a_n4 c on (b.key=c.key AND b.value=60 AND c.value=60) left outer join a_n4 d on (a_n4.key=d.key AND a_n4.value=40 AND d.value=40) POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -796,8 +812,12 @@ NULL NULL 100 40 NULL NULL NULL NULL NULL NULL 100 60 100 60 NULL NULL PREHOOK: query: explain extended select * from a_n4 left outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50) left outer join a_n4 c on (a_n4.key=c.key AND a_n4.value=60 AND c.value=60) left outer join a_n4 d on (a_n4.key=d.key AND a_n4.value=40 AND d.value=40) PREHOOK: type: QUERY +PREHOOK: Input: default@a_n4 +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from a_n4 left outer join a_n4 b on (a_n4.key=b.key AND a_n4.value=50 AND b.value=50) left outer join a_n4 c on (a_n4.key=c.key AND a_n4.value=60 AND c.value=60) left outer join a_n4 d on (a_n4.key=d.key AND a_n4.value=40 AND d.value=40) POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/join_grp_diff_keys.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_grp_diff_keys.q.out b/ql/src/test/results/clientpositive/join_grp_diff_keys.q.out index 9242238..53dfbde 100644 --- a/ql/src/test/results/clientpositive/join_grp_diff_keys.q.out +++ b/ql/src/test/results/clientpositive/join_grp_diff_keys.q.out @@ -38,6 +38,11 @@ SELECT foo.id, count(*) as factor from WHERE foo.orders != 'blah' group by foo.id PREHOOK: type: QUERY +PREHOOK: Input: default@bar +PREHOOK: Input: default@foo +PREHOOK: Input: default@forecast +PREHOOK: Input: default@split +#### A masked pattern was here #### POSTHOOK: query: explain SELECT foo.id, count(*) as factor from foo JOIN bar ON (foo.id = bar.id and foo.line_id = bar.line_id) @@ -46,6 +51,11 @@ SELECT foo.id, count(*) as factor from WHERE foo.orders != 'blah' group by foo.id POSTHOOK: type: QUERY +POSTHOOK: Input: default@bar +POSTHOOK: Input: default@foo +POSTHOOK: Input: default@forecast +POSTHOOK: Input: default@split +#### 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/c39b5d1b/ql/src/test/results/clientpositive/join_hive_626.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_hive_626.q.out b/ql/src/test/results/clientpositive/join_hive_626.q.out index 4309be4..e15aee3 100644 --- a/ql/src/test/results/clientpositive/join_hive_626.q.out +++ b/ql/src/test/results/clientpositive/join_hive_626.q.out @@ -60,10 +60,18 @@ PREHOOK: query: explain select hive_foo.foo_name, hive_bar.bar_name, n from hive_foo join hive_bar on hive_foo.foo_id = hive_bar.foo_id join hive_count on hive_count.bar_id = hive_bar.bar_id PREHOOK: type: QUERY +PREHOOK: Input: default@hive_bar +PREHOOK: Input: default@hive_count +PREHOOK: Input: default@hive_foo +#### A masked pattern was here #### POSTHOOK: query: explain select hive_foo.foo_name, hive_bar.bar_name, n from hive_foo join hive_bar on hive_foo.foo_id = hive_bar.foo_id join hive_count on hive_count.bar_id = hive_bar.bar_id POSTHOOK: type: QUERY +POSTHOOK: Input: default@hive_bar +POSTHOOK: Input: default@hive_count +POSTHOOK: Input: default@hive_foo +#### 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/c39b5d1b/ql/src/test/results/clientpositive/join_map_ppr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_map_ppr.q.out b/ql/src/test/results/clientpositive/join_map_ppr.q.out index 8712d81..d53f322 100644 --- a/ql/src/test/results/clientpositive/join_map_ppr.q.out +++ b/ql/src/test/results/clientpositive/join_map_ppr.q.out @@ -13,6 +13,11 @@ FROM src1 x JOIN src y ON (x.key = y.key) JOIN srcpart z ON (x.key = z.key) WHERE 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_n4 POSTHOOK: query: EXPLAIN EXTENDED INSERT OVERWRITE TABLE dest_j1_n4 SELECT /*+ MAPJOIN(x,y) */ x.key, z.value, y.value @@ -20,6 +25,11 @@ FROM src1 x JOIN src y ON (x.key = y.key) JOIN srcpart z ON (x.key = z.key) WHERE 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_n4 STAGE DEPENDENCIES: Stage-10 is a root stage Stage-1 depends on stages: Stage-10 @@ -651,6 +661,11 @@ FROM src1_copy x JOIN src_copy y ON (x.key = y.key) JOIN srcpart z ON (x.key = z.key) WHERE z.ds='2008-04-08' and z.hr=11 PREHOOK: type: QUERY +PREHOOK: Input: default@src1_copy +PREHOOK: Input: default@src_copy +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Output: default@dest_j1_n4 POSTHOOK: query: EXPLAIN EXTENDED INSERT OVERWRITE TABLE dest_j1_n4 SELECT /*+ MAPJOIN(x,y) */ x.key, z.value, y.value @@ -658,6 +673,11 @@ FROM src1_copy x JOIN src_copy y ON (x.key = y.key) JOIN srcpart z ON (x.key = z.key) WHERE z.ds='2008-04-08' and z.hr=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1_copy +POSTHOOK: Input: default@src_copy +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@dest_j1_n4 STAGE DEPENDENCIES: Stage-10 is a root stage Stage-1 depends on stages: Stage-10 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/join_merge_multi_expressions.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_merge_multi_expressions.q.out b/ql/src/test/results/clientpositive/join_merge_multi_expressions.q.out index fba4083..3bd712c 100644 --- a/ql/src/test/results/clientpositive/join_merge_multi_expressions.q.out +++ b/ql/src/test/results/clientpositive/join_merge_multi_expressions.q.out @@ -1,9 +1,21 @@ PREHOOK: query: explain select count(*) from srcpart a join srcpart b on a.key = b.key and a.hr = b.hr join srcpart c on a.hr = c.hr and a.key = c.key PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from srcpart a join srcpart b on a.key = b.key and a.hr = b.hr join srcpart c on a.hr = c.hr and a.key = c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/join_merging.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_merging.q.out b/ql/src/test/results/clientpositive/join_merging.q.out index 609cc83..4039f21 100644 --- a/ql/src/test/results/clientpositive/join_merging.q.out +++ b/ql/src/test/results/clientpositive/join_merging.q.out @@ -3,11 +3,15 @@ from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey right outer join part p3 on p2.p_partkey = p3.p_partkey and p1.p_size > 10 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p1.p_size, p2.p_size from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey right outer join part p3 on p2.p_partkey = p3.p_partkey and p1.p_size > 10 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,11 +95,15 @@ from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey right outer join part p3 on p2.p_partkey = p3.p_partkey and p1.p_size > 10 and p1.p_size > p2.p_size + 10 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p1.p_size, p2.p_size from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey right outer join part p3 on p2.p_partkey = p3.p_partkey and p1.p_size > 10 and p1.p_size > p2.p_size + 10 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 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/join_on_varchar.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_on_varchar.q.out b/ql/src/test/results/clientpositive/join_on_varchar.q.out index fb207a0..bc41012 100644 --- a/ql/src/test/results/clientpositive/join_on_varchar.q.out +++ b/ql/src/test/results/clientpositive/join_on_varchar.q.out @@ -55,9 +55,15 @@ POSTHOOK: Lineage: tbl2_n2.c2 EXPRESSION [] PREHOOK: query: explain select /*+ MAPJOIN(tbl2_n2) */ c1,c2 from tbl1_n3 join tbl2_n2 on (c1 = c2) order by c1,c2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n3 +PREHOOK: Input: default@tbl2_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ MAPJOIN(tbl2_n2) */ c1,c2 from tbl1_n3 join tbl2_n2 on (c1 = c2) order by c1,c2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n3 +POSTHOOK: Input: default@tbl2_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-5 is a root stage Stage-2 depends on stages: Stage-5
