http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out index b8bd10c..1778d9b 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out @@ -99,8 +99,20 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n11@ds=2008-04-09 PREHOOK: query: explain extended select count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n11 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n11 +PREHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n11 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n11 +POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -404,8 +416,20 @@ POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 38 PREHOOK: query: explain extended select count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n11 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n11 +PREHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n11 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n11 +POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -681,8 +705,20 @@ POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 38 PREHOOK: query: explain extended select /*+ mapjoin(a) */ count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n11 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n11 +PREHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select /*+ mapjoin(a) */ count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n11 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n11 +POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -950,8 +986,20 @@ POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 38 PREHOOK: query: explain extended select /*+ MAPJOIN(a,b) */ count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key JOIN bucket_big_n11 c ON a.key = c.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n11 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n11 +PREHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select /*+ MAPJOIN(a,b) */ count(*) FROM bucket_small_n11 a JOIN bucket_big_n11 b ON a.key = b.key JOIN bucket_big_n11 c ON a.key = c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n11 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n11@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n11 +POSTHOOK: Input: default@bucket_small_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out index d09b19e..19e6973 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out @@ -137,8 +137,24 @@ POSTHOOK: Output: default@bucket_medium@ds=2008-04-08 Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain extended select count(*) FROM bucket_small_n15 a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big_n15 c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n15 +PREHOOK: Input: default@bucket_big_n15@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n15@ds=2008-04-09 +PREHOOK: Input: default@bucket_medium +PREHOOK: Input: default@bucket_medium@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n15 +PREHOOK: Input: default@bucket_small_n15@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n15 a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big_n15 c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n15 +POSTHOOK: Input: default@bucket_big_n15@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n15@ds=2008-04-09 +POSTHOOK: Input: default@bucket_medium +POSTHOOK: Input: default@bucket_medium@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n15 +POSTHOOK: Input: default@bucket_small_n15@ds=2008-04-08 +#### A masked pattern was here #### 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/llap/auto_sortmerge_join_13.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out index 34c9abc..f087941 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out @@ -58,6 +58,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n2 +PREHOOK: Input: default@tbl2_n1 +PREHOOK: Output: default@dest1_n20 +PREHOOK: Output: default@dest2_n4 POSTHOOK: query: explain from ( SELECT a.key key1, a.value value1, b.key key2, b.value value2 @@ -66,6 +70,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n2 +POSTHOOK: Input: default@tbl2_n1 +POSTHOOK: Output: default@dest1_n20 +POSTHOOK: Output: default@dest2_n4 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -329,6 +337,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n2 +PREHOOK: Input: default@tbl2_n1 +PREHOOK: Output: default@dest1_n20 +PREHOOK: Output: default@dest2_n4 POSTHOOK: query: explain from ( SELECT a.key key1, a.value value1, b.key key2, b.value value2 @@ -337,6 +349,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n2 +POSTHOOK: Input: default@tbl2_n1 +POSTHOOK: Output: default@dest1_n20 +POSTHOOK: Output: default@dest2_n4 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -600,6 +616,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n2 +PREHOOK: Input: default@tbl2_n1 +PREHOOK: Output: default@dest1_n20 +PREHOOK: Output: default@dest2_n4 POSTHOOK: query: explain from ( SELECT a.key key1, a.value value1, b.key key2, b.value value2 @@ -608,6 +628,10 @@ from ( INSERT OVERWRITE TABLE dest1_n20 select key1, key2 INSERT OVERWRITE TABLE dest2_n4 select value1, value2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n2 +POSTHOOK: Input: default@tbl2_n1 +POSTHOOK: Output: default@dest1_n20 +POSTHOOK: Output: default@dest2_n4 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out index 13ef018..ced0f68 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_14.q.out @@ -37,9 +37,15 @@ POSTHOOK: Lineage: tbl2_n6.value SIMPLE [(src)src.FieldSchema(name:value, type:s PREHOOK: query: explain select count(*) FROM tbl1_n7 a LEFT OUTER JOIN tbl2_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n7 +PREHOOK: Input: default@tbl2_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n7 a LEFT OUTER JOIN tbl2_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n7 +POSTHOOK: Input: default@tbl2_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -132,9 +138,15 @@ POSTHOOK: Lineage: tbl2_n6.value SIMPLE [(src)src.FieldSchema(name:value, type:s PREHOOK: query: explain select count(*) FROM tbl1_n7 a RIGHT OUTER JOIN tbl2_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n7 +PREHOOK: Input: default@tbl2_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n7 a RIGHT OUTER JOIN tbl2_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n7 +POSTHOOK: Input: default@tbl2_n6 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out index ef4a079..6615387 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_15.q.out @@ -37,9 +37,15 @@ POSTHOOK: Lineage: tbl2_n10.value SIMPLE [(src)src.FieldSchema(name:value, type: PREHOOK: query: explain select count(*) FROM tbl1_n11 a LEFT OUTER JOIN tbl2_n10 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n11 +PREHOOK: Input: default@tbl2_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n11 a LEFT OUTER JOIN tbl2_n10 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n11 +POSTHOOK: Input: default@tbl2_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -111,9 +117,15 @@ STAGE PLANS: PREHOOK: query: explain select count(*) FROM tbl1_n11 a RIGHT OUTER JOIN tbl2_n10 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n11 +PREHOOK: Input: default@tbl2_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n11 a RIGHT OUTER JOIN tbl2_n10 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n11 +POSTHOOK: Input: default@tbl2_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out index bd51c86..e8bdaa2 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out @@ -165,6 +165,12 @@ PREHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as p on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n17 +PREHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +PREHOOK: Input: default@bucket_small_n17 +PREHOOK: Input: default@bucket_small_n17@pri=1 +PREHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as pri from ( select key, value @@ -176,6 +182,12 @@ POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n17 +POSTHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +POSTHOOK: Input: default@bucket_small_n17 +POSTHOOK: Input: default@bucket_small_n17@pri=1 +POSTHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -320,6 +332,12 @@ left outer join on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n17 +PREHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +PREHOOK: Input: default@bucket_small_n17 +PREHOOK: Input: default@bucket_small_n17@pri=1 +PREHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as pri from ( select key, value @@ -331,6 +349,12 @@ left outer join on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n17 +POSTHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +POSTHOOK: Input: default@bucket_small_n17 +POSTHOOK: Input: default@bucket_small_n17@pri=1 +POSTHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -562,6 +586,12 @@ PREHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as p on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n17 +PREHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +PREHOOK: Input: default@bucket_small_n17 +PREHOOK: Input: default@bucket_small_n17@pri=1 +PREHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as pri from ( select key, value @@ -573,6 +603,12 @@ POSTHOOK: query: explain select a.key , a.value , b.value , 'day1' as day, 1 as on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n17 +POSTHOOK: Input: default@bucket_big_n17@day=day1/pri=1 +POSTHOOK: Input: default@bucket_small_n17 +POSTHOOK: Input: default@bucket_small_n17@pri=1 +POSTHOOK: Input: default@bucket_small_n17@pri=2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out index 075cbc1..80c39b4 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out @@ -83,8 +83,20 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n3@ds=2008-04-09 PREHOOK: query: explain extended select count(*) FROM bucket_big_n3 a JOIN bucket_small_n3 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n3 +PREHOOK: Input: default@bucket_big_n3@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n3@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n3 +PREHOOK: Input: default@bucket_small_n3@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n3 a JOIN bucket_small_n3 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n3 +POSTHOOK: Input: default@bucket_big_n3@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n3@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n3 +POSTHOOK: Input: default@bucket_small_n3@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -360,8 +372,20 @@ POSTHOOK: Input: default@bucket_small_n3@ds=2008-04-08 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n3 a JOIN bucket_small_n3 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n3 +PREHOOK: Input: default@bucket_big_n3@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n3@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n3 +PREHOOK: Input: default@bucket_small_n3@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n3 a JOIN bucket_small_n3 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n3 +POSTHOOK: Input: default@bucket_big_n3@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n3@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n3 +POSTHOOK: Input: default@bucket_small_n3@ds=2008-04-08 +#### A masked pattern was here #### 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/llap/auto_sortmerge_join_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out index 4bfc89e..53da73b 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out @@ -83,8 +83,20 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n9@ds=2008-04-08 PREHOOK: query: explain extended select count(*) FROM bucket_small_n9 a JOIN bucket_big_n9 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n9 +PREHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n9 a JOIN bucket_big_n9 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n9 +POSTHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -360,8 +372,20 @@ POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n9 a JOIN bucket_small_n9 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n9 +PREHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n9 a JOIN bucket_small_n9 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n9 +POSTHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -637,8 +661,20 @@ POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n9 a JOIN bucket_small_n9 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n9 +PREHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n9 a JOIN bucket_small_n9 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n9 +POSTHOOK: Input: default@bucket_big_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n9@ds=2008-04-09 +#### A masked pattern was here #### 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/llap/auto_sortmerge_join_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out index a212b04..d236611 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out @@ -99,8 +99,20 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n12@ds=2008-04-08 PREHOOK: query: explain extended select count(*) FROM bucket_small_n12 a JOIN bucket_big_n12 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n12 +PREHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n12 a JOIN bucket_big_n12 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n12 +POSTHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -376,8 +388,20 @@ POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n12 a JOIN bucket_small_n12 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n12 +PREHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n12 a JOIN bucket_small_n12 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n12 +POSTHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -653,8 +677,20 @@ POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 38 PREHOOK: query: explain extended select count(*) FROM bucket_big_n12 a JOIN bucket_small_n12 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n12 +PREHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n12 a JOIN bucket_small_n12 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n12 +POSTHOOK: Input: default@bucket_big_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n12@ds=2008-04-09 +#### A masked pattern was here #### 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/llap/auto_sortmerge_join_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out index 2f475f1..f014d39 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_5.q.out @@ -64,8 +64,14 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n0 PREHOOK: query: explain extended select count(*) FROM bucket_small_n0 a JOIN bucket_big_n0 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n0 +PREHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n0 a JOIN bucket_big_n0 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n0 +POSTHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -285,8 +291,14 @@ POSTHOOK: Input: default@bucket_small_n0 19 PREHOOK: query: explain extended select count(*) FROM bucket_big_n0 a JOIN bucket_small_n0 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n0 +PREHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n0 a JOIN bucket_small_n0 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n0 +POSTHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -506,8 +518,14 @@ POSTHOOK: Input: default@bucket_small_n0 19 PREHOOK: query: explain extended select count(*) FROM bucket_big_n0 a JOIN bucket_small_n0 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n0 +PREHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n0 a JOIN bucket_small_n0 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n0 +POSTHOOK: Input: default@bucket_small_n0 +#### A masked pattern was here #### 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/llap/auto_sortmerge_join_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out index 828c6e1..3b753ad 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out @@ -72,8 +72,16 @@ POSTHOOK: Lineage: tbl4.key EXPRESSION [(src)src.FieldSchema(name:key, type:stri POSTHOOK: Lineage: tbl4.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -218,8 +226,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src d on d.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src d on d.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -364,8 +380,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src h on h.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src h on h.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -510,8 +534,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -656,8 +688,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl3_n0 c on c.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +PREHOOK: Input: default@tbl3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl3_n0 c on c.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +POSTHOOK: Input: default@tbl3_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -760,8 +800,16 @@ POSTHOOK: Input: default@tbl3_n0 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl4 c on c.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +PREHOOK: Input: default@tbl4 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl4 c on c.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +POSTHOOK: Input: default@tbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -906,8 +954,16 @@ POSTHOOK: Input: default@tbl4 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1052,8 +1108,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join src c on c.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1198,8 +1262,16 @@ POSTHOOK: Input: default@tbl2_n3 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl3_n0 c on c.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +PREHOOK: Input: default@tbl3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl3_n0 c on c.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +POSTHOOK: Input: default@tbl3_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1302,8 +1374,16 @@ POSTHOOK: Input: default@tbl3_n0 2654 PREHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl4 c on c.value = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n4 +PREHOOK: Input: default@tbl2_n3 +PREHOOK: Input: default@tbl4 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM tbl1_n4 a JOIN tbl2_n3 b ON a.key = b.key join tbl4 c on c.value = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n4 +POSTHOOK: Input: default@tbl2_n3 +POSTHOOK: Input: default@tbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out index 4315627..0d93202 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out @@ -116,8 +116,22 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n6@ds=2008-04-09 PREHOOK: query: explain extended select count(*) FROM bucket_small_n6 a JOIN bucket_big_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n6 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n6 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n6 a JOIN bucket_big_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n6 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n6 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -445,8 +459,22 @@ POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 76 PREHOOK: query: explain extended select count(*) FROM bucket_big_n6 a JOIN bucket_small_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n6 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n6 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n6 a JOIN bucket_small_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n6 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n6 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -774,8 +802,22 @@ POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 76 PREHOOK: query: explain extended select count(*) FROM bucket_big_n6 a JOIN bucket_small_n6 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n6 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n6 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n6 a JOIN bucket_small_n6 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n6 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n6@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n6 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n6@ds=2008-04-09 +#### A masked pattern was here #### 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/llap/auto_sortmerge_join_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out index f1d4274..b8bc1bd 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out @@ -116,8 +116,22 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@bucket_big_n5@ds=2008-04-09 PREHOOK: query: explain extended select count(*) FROM bucket_small_n5 a JOIN bucket_big_n5 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n5 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n5 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_small_n5 a JOIN bucket_big_n5 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n5 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n5 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -445,8 +459,22 @@ POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 76 PREHOOK: query: explain extended select count(*) FROM bucket_big_n5 a JOIN bucket_small_n5 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n5 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n5 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n5 a JOIN bucket_small_n5 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n5 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n5 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -774,8 +802,22 @@ POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 76 PREHOOK: query: explain extended select count(*) FROM bucket_big_n5 a JOIN bucket_small_n5 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_big_n5 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +PREHOOK: Input: default@bucket_small_n5 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +PREHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) FROM bucket_big_n5 a JOIN bucket_small_n5 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_big_n5 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_big_n5@ds=2008-04-09 +POSTHOOK: Input: default@bucket_small_n5 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-08 +POSTHOOK: Input: default@bucket_small_n5@ds=2008-04-09 +#### A masked pattern was here #### 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/llap/auto_sortmerge_join_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out index 935e607..4e50c9c 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out @@ -43,11 +43,17 @@ select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -144,6 +150,9 @@ select key, count(*) from ) subq1 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from ( @@ -151,6 +160,9 @@ select key, count(*) from ) subq1 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -264,6 +276,9 @@ select count(*) from group by key ) subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -274,6 +289,9 @@ select count(*) from group by key ) subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -412,6 +430,9 @@ join ) src2 on src1.key = src2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -429,6 +450,9 @@ join ) src2 on src1.key = src2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -641,6 +665,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -648,6 +675,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -753,6 +783,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -765,6 +798,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -887,6 +923,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -906,6 +944,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1028,6 +1068,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl1_n10 a where key < 8) subq1 @@ -1035,6 +1078,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1135,6 +1181,9 @@ select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2_n9 a) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl1_n10 a) subq1 @@ -1142,6 +1191,9 @@ select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2_n9 a) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1258,11 +1310,17 @@ select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1358,12 +1416,18 @@ select count(*) from tbl1_n10 a (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tbl1_n10 a join (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1465,6 +1529,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -1475,6 +1542,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1600,6 +1670,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select subq2.key as key, subq2.value as value1, b.value as value2 from @@ -1613,6 +1686,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1723,11 +1799,17 @@ select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1824,6 +1906,9 @@ select key, count(*) from ) subq1 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from ( @@ -1831,6 +1916,9 @@ select key, count(*) from ) subq1 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1944,6 +2032,9 @@ select count(*) from group by key ) subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -1954,6 +2045,9 @@ select count(*) from group by key ) subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2092,6 +2186,9 @@ join ) src2 on src1.key = src2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -2109,6 +2206,9 @@ join ) src2 on src1.key = src2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2321,6 +2421,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -2328,6 +2431,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2433,6 +2539,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -2445,6 +2554,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2567,6 +2679,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -2586,6 +2700,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2708,6 +2824,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl1_n10 a where key < 8) subq1 @@ -2715,6 +2834,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2813,11 +2935,17 @@ select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2913,12 +3041,18 @@ select count(*) from tbl1_n10 a (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tbl1_n10 a join (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3020,6 +3154,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -3030,6 +3167,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3155,6 +3295,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select subq2.key as key, subq2.value as value1, b.value as value2 from @@ -3168,6 +3311,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/bucket2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket2.q.out b/ql/src/test/results/clientpositive/llap/bucket2.q.out index f0cbd92..c301f09 100644 --- a/ql/src/test/results/clientpositive/llap/bucket2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket2.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain extended insert overwrite table bucket2_1 select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket2_1 POSTHOOK: query: explain extended insert overwrite table bucket2_1 select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket2_1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -237,9 +241,13 @@ POSTHOOK: Lineage: bucket2_1.value SIMPLE [(src)src.FieldSchema(name:value, type PREHOOK: query: explain select * from bucket2_1 tablesample (bucket 1 out of 2) s PREHOOK: type: QUERY +PREHOOK: Input: default@bucket2_1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from bucket2_1 tablesample (bucket 1 out of 2) s POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket2_1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/bucket3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket3.q.out b/ql/src/test/results/clientpositive/llap/bucket3.q.out index 1228177..907005a 100644 --- a/ql/src/test/results/clientpositive/llap/bucket3.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket3.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain extended insert overwrite table bucket3_1 partition (ds='1') select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket3_1@ds=1 POSTHOOK: query: explain extended insert overwrite table bucket3_1 partition (ds='1') select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket3_1@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -267,9 +271,15 @@ POSTHOOK: Lineage: bucket3_1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema( PREHOOK: query: explain select * from bucket3_1 tablesample (bucket 1 out of 2) s where ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@bucket3_1 +PREHOOK: Input: default@bucket3_1@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from bucket3_1 tablesample (bucket 1 out of 2) s where ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket3_1 +POSTHOOK: Input: default@bucket3_1@ds=1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/bucket4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket4.q.out b/ql/src/test/results/clientpositive/llap/bucket4.q.out index 5deab2d..205fdaf 100644 --- a/ql/src/test/results/clientpositive/llap/bucket4.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket4.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain extended insert overwrite table bucket4_1 select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket4_1 POSTHOOK: query: explain extended insert overwrite table bucket4_1 select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket4_1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -240,9 +244,13 @@ POSTHOOK: Lineage: bucket4_1.value SIMPLE [(src)src.FieldSchema(name:value, type PREHOOK: query: explain select * from bucket4_1 tablesample (bucket 1 out of 2) s PREHOOK: type: QUERY +PREHOOK: Input: default@bucket4_1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from bucket4_1 tablesample (bucket 1 out of 2) s POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket4_1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/bucket5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket5.q.out b/ql/src/test/results/clientpositive/llap/bucket5.q.out index ee444f2..bd56c35 100644 --- a/ql/src/test/results/clientpositive/llap/bucket5.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket5.q.out @@ -19,11 +19,17 @@ FROM src INSERT OVERWRITE TABLE bucketed_table SELECT key, value INSERT OVERWRITE TABLE unbucketed_table SELECT key, value cluster by key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucketed_table +PREHOOK: Output: default@unbucketed_table POSTHOOK: query: EXPLAIN EXTENDED FROM src INSERT OVERWRITE TABLE bucketed_table SELECT key, value INSERT OVERWRITE TABLE unbucketed_table SELECT key, value cluster by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucketed_table +POSTHOOK: Output: default@unbucketed_table STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2, Stage-7, Stage-6, Stage-9 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/bucket6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket6.q.out b/ql/src/test/results/clientpositive/llap/bucket6.q.out index d0c1500..f8d920b 100644 --- a/ql/src/test/results/clientpositive/llap/bucket6.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket6.q.out @@ -9,9 +9,21 @@ POSTHOOK: Output: default@src_bucket PREHOOK: query: explain insert into table src_bucket select key,value from srcpart 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 +PREHOOK: Output: default@src_bucket POSTHOOK: query: explain insert into table src_bucket select key,value from srcpart 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 +POSTHOOK: Output: default@src_bucket 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/llap/bucket_groupby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out index 4925de5..2d1bb8a 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out @@ -42,9 +42,15 @@ POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.Field PREHOOK: query: explain select key, count(1) from clustergroupby where ds='100' group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=100 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='100' group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=100 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -169,9 +175,15 @@ POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).value SIMPLE [(src)src.Field PREHOOK: query: explain select key, count(1) from clustergroupby where ds='101' group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='101' group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -271,9 +283,15 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select length(key), count(1) from clustergroupby where ds='101' group by length(key) limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select length(key), count(1) from clustergroupby where ds='101' group by length(key) limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -352,9 +370,15 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select abs(length(key)), count(1) from clustergroupby where ds='101' group by abs(length(key)) limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select abs(length(key)), count(1) from clustergroupby where ds='101' group by abs(length(key)) limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -433,9 +457,15 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select key, count(1) from clustergroupby where ds='101' group by key,'a' order by key,'a' limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='101' group by key,'a' order by key,'a' limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -535,9 +565,15 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select key, count(1) from (select value as key, key as value from clustergroupby where ds='101')subq group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from (select value as key, key as value from clustergroupby where ds='101')subq group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -637,9 +673,17 @@ val_114 1 PREHOOK: query: explain select key, count(1) from clustergroupby group by key PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=100 +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=100 +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1022,9 +1066,17 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select key, count(1) from clustergroupby group by key, 3 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=100 +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby group by key, 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=100 +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1135,9 +1187,15 @@ POSTHOOK: Lineage: clustergroupby PARTITION(ds=102).value SIMPLE [(src)src.Field PREHOOK: query: explain select key, count(1) from clustergroupby where ds='102' group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='102' group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1238,9 +1296,15 @@ POSTHOOK: Input: default@clustergroupby@ds=102 PREHOOK: query: explain select value, count(1) from clustergroupby where ds='102' group by value order by value limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### POSTHOOK: query: explain select value, count(1) from clustergroupby where ds='102' group by value order by value limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1340,9 +1404,15 @@ val_114 1 PREHOOK: query: explain select key, count(1) from clustergroupby where ds='102' group by key, value limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='102' group by key, value limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1440,9 +1510,15 @@ POSTHOOK: Lineage: clustergroupby PARTITION(ds=103).value SIMPLE [(src)src.Field PREHOOK: query: explain select key, count(1) from clustergroupby where ds='103' group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=103 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='103' group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=103 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1543,9 +1619,15 @@ POSTHOOK: Input: default@clustergroupby@ds=103 PREHOOK: query: explain select key, count(1) from clustergroupby where ds='103' group by value, key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=103 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='103' group by value, key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=103 +#### 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/llap/bucket_many.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_many.q.out b/ql/src/test/results/clientpositive/llap/bucket_many.q.out index 00b61f2..7bce630 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_many.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_many.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain extended insert overwrite table bucket_many select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket_many POSTHOOK: query: explain extended insert overwrite table bucket_many select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket_many STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -250,9 +254,13 @@ POSTHOOK: Lineage: bucket_many.value SIMPLE [(src)src.FieldSchema(name:value, ty PREHOOK: query: explain select * from bucket_many tablesample (bucket 2 out of 256) s PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_many +#### A masked pattern was here #### POSTHOOK: query: explain select * from bucket_many tablesample (bucket 2 out of 256) s POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_many +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage
