http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out index 7aea667..7020bf3 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out @@ -166,8 +166,14 @@ POSTHOOK: Output: default@tab_part_n11@ds=2008-04-08 #### A masked pattern was here #### PREHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -288,8 +294,14 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -444,10 +456,16 @@ PREHOOK: query: explain select a.key, a.value, b.value from tab1_n5 a join src b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tab1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, a.value, b.value from tab1_n5 a join src b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tab1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -533,10 +551,16 @@ PREHOOK: query: explain select a.key, a.value, b.value from tab1_n5 a join src b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tab1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, a.value, b.value from tab1_n5 a join src b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tab1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -621,9 +645,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -702,9 +732,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -777,9 +813,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a left outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a left outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -858,9 +900,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a left outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a left outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -933,9 +981,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a right outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a right outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -1014,9 +1068,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a right outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a right outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -1088,8 +1148,14 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select distinct key from tab_n10) a join tab_n10 b on b.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select distinct key from tab_n10) a join tab_n10 b on b.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1172,8 +1238,14 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select distinct key from tab_n10) a join tab_n10 b on b.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select distinct key from tab_n10) a join tab_n10 b on b.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1260,8 +1332,14 @@ STAGE PLANS: PREHOOK: query: explain select a.value, b.value from (select distinct value from tab_n10) a join tab_n10 b on b.key = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.value, b.value from (select distinct value from tab_n10) a join tab_n10 b on b.key = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1360,8 +1438,14 @@ STAGE PLANS: PREHOOK: query: explain select a.value, b.value from (select distinct value from tab_n10) a join tab_n10 b on b.key = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.value, b.value from (select distinct value from tab_n10) a join tab_n10 b on b.key = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1499,11 +1583,21 @@ select count(*) from (select distinct key,value from tab_part_n11) a join tab_n10 b on a.key = b.key and a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select distinct key,value from tab_part_n11) a join tab_n10 b on a.key = b.key and a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -1616,11 +1710,21 @@ select count(*) from (select distinct key,value from tab_part_n11) a join tab_n10 b on a.key = b.key and a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select distinct key,value from tab_part_n11) a join tab_n10 b on a.key = b.key and a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -1766,8 +1870,18 @@ POSTHOOK: Output: default@big@k=2 POSTHOOK: Lineage: big PARTITION(k=2).i SCRIPT [] PREHOOK: query: explain select small.i, big.i from small,big where small.i=big.i PREHOOK: type: QUERY +PREHOOK: Input: default@big +PREHOOK: Input: default@big@k=1 +PREHOOK: Input: default@big@k=2 +PREHOOK: Input: default@small +#### A masked pattern was here #### POSTHOOK: query: explain select small.i, big.i from small,big where small.i=big.i POSTHOOK: type: QUERY +POSTHOOK: Input: default@big +POSTHOOK: Input: default@big@k=1 +POSTHOOK: Input: default@big@k=2 +POSTHOOK: Input: default@small +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1896,8 +2010,14 @@ POSTHOOK: Output: default@tab_part_ext@ds=2008-04-08 test.comment=Bucket map join should work here PREHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_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 @@ -2019,8 +2139,14 @@ STAGE PLANS: test.comment=External tables, bucket map join should be disabled PREHOOK: query: explain select a.key, b.key from tab_part_ext a join tab_part_ext c on a.key = c.key join tab_part_ext b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_ext +PREHOOK: Input: default@tab_part_ext@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from tab_part_ext a join tab_part_ext c on a.key = c.key join tab_part_ext b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_ext +POSTHOOK: Input: default@tab_part_ext@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/bucket_map_join_tez_empty.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out index 20d20ec..ef64838 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out @@ -36,8 +36,14 @@ POSTHOOK: Lineage: tab2_n0.key1 SCRIPT [] POSTHOOK: Lineage: tab2_n0.value SCRIPT [] PREHOOK: query: explain select * from tab1_n0, tab2_n0 where tab1_n0.key1 = tab2_n0.key1 PREHOOK: type: QUERY +PREHOOK: Input: default@tab1_n0 +PREHOOK: Input: default@tab2_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from tab1_n0, tab2_n0 where tab1_n0.key1 = tab2_n0.key1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab1_n0 +POSTHOOK: Input: default@tab2_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/bucket_num_reducers.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out b/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out index f217142..eb50cf3 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out @@ -9,9 +9,13 @@ POSTHOOK: Output: default@bucket_nr PREHOOK: query: explain extended insert overwrite table bucket_nr select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket_nr POSTHOOK: query: explain extended insert overwrite table bucket_nr select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket_nr 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_num_reducers2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out b/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out index 209e593..e01b0f0 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out @@ -9,9 +9,13 @@ POSTHOOK: Output: default@test_table_n4 PREHOOK: query: explain extended insert overwrite table test_table_n4 select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@test_table_n4 POSTHOOK: query: explain extended insert overwrite table test_table_n4 select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@test_table_n4 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/bucketmapjoin1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out index ec76eee..6d2c133 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out @@ -27,11 +27,17 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n1 a join srcbucket_mapjoin_part_2_n1 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n1 a join srcbucket_mapjoin_part_2_n1 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -159,11 +165,17 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n1 a join srcbucket_mapjoin_part_2_n1 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n1 a join srcbucket_mapjoin_part_2_n1 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -382,12 +394,20 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n1 a join srcbucket_mapjoin_part_n1 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n0 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n0 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n1 a join srcbucket_mapjoin_part_n1 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -807,12 +827,20 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n1 a join srcbucket_mapjoin_part_n1 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n0 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n0 select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n1 a join srcbucket_mapjoin_part_n1 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n0 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/bucketmapjoin2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out index fcf5401..662c38f 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out @@ -94,12 +94,22 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key and b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n2 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n2 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key and b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n2 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -524,12 +534,22 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key and b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n2 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n2 select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key and b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n2 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -971,12 +991,24 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-09 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n2 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n2 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-09 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n2 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/bucketmapjoin3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out index 1fb3228..00da85a 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out @@ -118,12 +118,22 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_2_n11 a join srcbucket_mapjoin_part_n13 b on a.key=b.key and b.ds="2008-04-08" and a.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n11 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n11@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_n13 +PREHOOK: Input: default@srcbucket_mapjoin_part_n13@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n6 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n6 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_2_n11 a join srcbucket_mapjoin_part_n13 b on a.key=b.key and b.ds="2008-04-08" and a.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n11 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n11@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n13 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n13@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n6 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -548,12 +558,22 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_2_n11 a join srcbucket_mapjoin_part_n13 b on a.key=b.key and b.ds="2008-04-08" and a.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n11 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n11@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_n13 +PREHOOK: Input: default@srcbucket_mapjoin_part_n13@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n6 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n6 select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_2_n11 a join srcbucket_mapjoin_part_n13 b on a.key=b.key and b.ds="2008-04-08" and a.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n11 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n11@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n13 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n13@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n6 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/bucketmapjoin4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out index 6892f08..04af988 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out @@ -118,12 +118,16 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n17 a join srcbucket_mapjoin_n17 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n17 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n8 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n8 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n17 a join srcbucket_mapjoin_n17 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n17 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n8 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -534,12 +538,16 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n17 a join srcbucket_mapjoin_n17 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n17 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n8 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n8 select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n17 a join srcbucket_mapjoin_n17 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n17 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n8 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/bucketmapjoin7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out index 02c817a..95e88bd 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out @@ -58,12 +58,22 @@ FROM srcbucket_mapjoin_part_1_n4 a JOIN srcbucket_mapjoin_part_2_n9 b ON a.key = b.key AND a.ds = '2008-04-08' AND b.ds = '2008-04-08' ORDER BY a.key, b.value LIMIT 1 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_1_n4 +PREHOOK: Input: default@srcbucket_mapjoin_part_1_n4@ds=2008-04-08/hr=0 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n9 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n9@ds=2008-04-08/hr=0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM srcbucket_mapjoin_part_1_n4 a JOIN srcbucket_mapjoin_part_2_n9 b ON a.key = b.key AND a.ds = '2008-04-08' AND b.ds = '2008-04-08' ORDER BY a.key, b.value LIMIT 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_1_n4 +POSTHOOK: Input: default@srcbucket_mapjoin_part_1_n4@ds=2008-04-08/hr=0 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n9 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n9@ds=2008-04-08/hr=0 +#### 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/bucketpruning1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketpruning1.q.out b/ql/src/test/results/clientpositive/llap/bucketpruning1.q.out index b435116..4e92bd1 100644 --- a/ql/src/test/results/clientpositive/llap/bucketpruning1.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketpruning1.q.out @@ -17,9 +17,13 @@ POSTHOOK: Output: default@srcbucket_unpruned PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -79,9 +83,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 16 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 16 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -141,9 +149,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 17 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 17 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -203,9 +215,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 16+1 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 16+1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -265,9 +281,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = '11' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = '11' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -327,9 +347,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -389,9 +413,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and value='One' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and value='One' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -451,9 +479,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key = 1 and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key = 1 and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -513,9 +545,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -575,9 +611,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -637,9 +677,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' and value='One' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' and value='One' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -699,9 +743,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key in (2,3) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key in (2,3) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -761,9 +809,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where (key=1 or key=2) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where (key=1 or key=2) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -822,9 +874,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where (key=1 or key=2) and value = 'One' and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where (key=1 or key=2) and value = 'One' and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -883,9 +939,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = -15 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = -15 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -945,9 +1005,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1007,9 +1071,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1069,9 +1137,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' and value='One' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' and value='One' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1131,9 +1203,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1193,9 +1269,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' or key = 2 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' or key = 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1254,9 +1334,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and (value='One' or value = 'Two') PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and (value='One' or value = 'Two') POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1315,9 +1399,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 and value = "Two" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 and value = "Two" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1376,9 +1464,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 'x11' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 'x11' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1436,9 +1528,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1497,9 +1593,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1558,9 +1658,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_unpruned where key in (3, 5) PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_unpruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_unpruned where key in (3, 5) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_unpruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1619,9 +1723,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_unpruned where key = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_unpruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_unpruned where key = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_unpruned +#### 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/bucketsortoptimize_insert_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out index 1bb1791..34d0844 100644 --- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out @@ -82,12 +82,22 @@ SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds = '1' and b.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds = '1' and b.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -290,12 +300,24 @@ SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds is not null and b.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table1_n0@ds=2 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds is not null and b.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table1_n0@ds=2 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -522,12 +544,24 @@ SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds = '1' and b.ds is not null PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Input: default@test_table2_n0@ds=2 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) FROM test_table1_n0 a JOIN test_table2_n0 b ON a.key = b.key WHERE a.ds = '1' and b.ds is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0@ds=2 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -757,6 +791,11 @@ JOIN (select key, value from test_table2_n0 where ds = '1') b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) @@ -766,6 +805,11 @@ JOIN (select key, value from test_table2_n0 where ds = '1') b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -977,6 +1021,11 @@ JOIN (select key, concat(value, value) as v2 from test_table2_n0 where ds = '1') b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key, concat(a.v1, b.v2) @@ -986,6 +1035,11 @@ JOIN (select key, concat(value, value) as v2 from test_table2_n0 where ds = '1') b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1197,6 +1251,11 @@ JOIN (select key, value from test_table2_n0 where ds = '1') b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n0 +PREHOOK: Input: default@test_table1_n0@ds=1 +PREHOOK: Input: default@test_table2_n0 +PREHOOK: Input: default@test_table2_n0@ds=1 +PREHOOK: Output: default@test_table3_n0@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n0 PARTITION (ds = '1') SELECT a.key+a.key, concat(a.value, b.value) @@ -1206,6 +1265,11 @@ JOIN (select key, value from test_table2_n0 where ds = '1') b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n0 +POSTHOOK: Input: default@test_table1_n0@ds=1 +POSTHOOK: Input: default@test_table2_n0 +POSTHOOK: Input: default@test_table2_n0@ds=1 +POSTHOOK: Output: default@test_table3_n0@ds=1 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/bucketsortoptimize_insert_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out index 7533cf8..a51e17b 100644 --- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out @@ -60,12 +60,22 @@ SELECT a.key, a.key2, concat(a.value, b.value) FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT a.key, a.key2, concat(a.value, b.value) FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -272,6 +282,11 @@ FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT subq1.key, subq1.key2, subq1.value from @@ -281,6 +296,11 @@ FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -490,12 +510,22 @@ SELECT a.key2, a.key, concat(a.value, b.value) FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT a.key2, a.key, concat(a.value, b.value) FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -637,6 +667,11 @@ FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT subq1.key2, subq1.key, subq1.value from @@ -646,6 +681,11 @@ FROM test_table1_n3 a JOIN test_table2_n3 b ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -790,6 +830,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT subq2.key, subq2.key2, subq2.value from @@ -802,6 +847,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1023,6 +1073,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table3_n3@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n3 PARTITION (ds = '1') SELECT subq2.k2, subq2.k1, subq2.value from @@ -1035,6 +1090,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table3_n3@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1266,6 +1326,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n3 +PREHOOK: Input: default@test_table1_n3@ds=1 +PREHOOK: Input: default@test_table2_n3 +PREHOOK: Input: default@test_table2_n3@ds=1 +PREHOOK: Output: default@test_table4@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table4 PARTITION (ds = '1') SELECT subq2.k2, subq2.k1, subq2.value from @@ -1278,6 +1343,11 @@ ON a.key = b.key and a.key2 = b.key2 WHERE a.ds = '1' and b.ds = '1' )subq1 )subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n3 +POSTHOOK: Input: default@test_table1_n3@ds=1 +POSTHOOK: Input: default@test_table2_n3 +POSTHOOK: Input: default@test_table2_n3@ds=1 +POSTHOOK: Output: default@test_table4@ds=1 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/bucketsortoptimize_insert_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out index cf7e442..a8ed8e8 100644 --- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out @@ -59,6 +59,11 @@ FROM test_table1_n20 a JOIN test_table2_n19 b ON a.key = b.key WHERE a.ds = '1' and b.ds = '1' and (a.key = 0 or a.key = 5) PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n20 +PREHOOK: Input: default@test_table1_n20@ds=1 +PREHOOK: Input: default@test_table2_n19 +PREHOOK: Input: default@test_table2_n19@ds=1 +PREHOOK: Output: default@test_table3_n11@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n11 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) @@ -66,6 +71,11 @@ FROM test_table1_n20 a JOIN test_table2_n19 b ON a.key = b.key WHERE a.ds = '1' and b.ds = '1' and (a.key = 0 or a.key = 5) POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n20 +POSTHOOK: Input: default@test_table1_n20@ds=1 +POSTHOOK: Input: default@test_table2_n19 +POSTHOOK: Input: default@test_table2_n19@ds=1 +POSTHOOK: Output: default@test_table3_n11@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -269,6 +279,11 @@ JOIN (select key, value from test_table2_n19 where ds = '1' and (key = 0 or key = 5)) b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n20 +PREHOOK: Input: default@test_table1_n20@ds=1 +PREHOOK: Input: default@test_table2_n19 +PREHOOK: Input: default@test_table2_n19@ds=1 +PREHOOK: Output: default@test_table3_n11@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n11 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) @@ -278,6 +293,11 @@ JOIN (select key, value from test_table2_n19 where ds = '1' and (key = 0 or key = 5)) b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n20 +POSTHOOK: Input: default@test_table1_n20@ds=1 +POSTHOOK: Input: default@test_table2_n19 +POSTHOOK: Input: default@test_table2_n19@ds=1 +POSTHOOK: Output: default@test_table3_n11@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -486,6 +506,11 @@ JOIN ON a.key = b.key WHERE a.key = 0 or a.key = 5 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n20 +PREHOOK: Input: default@test_table1_n20@ds=1 +PREHOOK: Input: default@test_table2_n19 +PREHOOK: Input: default@test_table2_n19@ds=1 +PREHOOK: Output: default@test_table3_n11@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table3_n11 PARTITION (ds = '1') SELECT a.key, concat(a.value, b.value) @@ -496,6 +521,11 @@ JOIN ON a.key = b.key WHERE a.key = 0 or a.key = 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n20 +POSTHOOK: Input: default@test_table1_n20@ds=1 +POSTHOOK: Input: default@test_table2_n19 +POSTHOOK: Input: default@test_table2_n19@ds=1 +POSTHOOK: Output: default@test_table3_n11@ds=1 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/cbo_simple_select.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out b/ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out index f964cb6..f6ce9a3 100644 --- a/ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out +++ b/ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out @@ -743,8 +743,14 @@ POSTHOOK: Input: default@cbo_t2@dt=2014 400 PREHOOK: query: EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -765,9 +771,15 @@ STAGE PLANS: PREHOOK: query: -- c_int is not null EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (2*cbo_t2.c_int) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- c_int is not null EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (2*cbo_t2.c_int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -788,9 +800,15 @@ STAGE PLANS: PREHOOK: query: -- c_int is 0 EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) = (cbo_t2.c_int) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- c_int is 0 EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) = (cbo_t2.c_int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -811,9 +829,15 @@ STAGE PLANS: PREHOOK: query: -- c_int is not null EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (NULL) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- c_int is not null EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (NULL) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -834,9 +858,15 @@ STAGE PLANS: PREHOOK: query: -- rewrite to NULL EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 2*cbo_t2.c_int) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- rewrite to NULL EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 2*cbo_t2.c_int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -857,9 +887,15 @@ STAGE PLANS: PREHOOK: query: -- no rewrite EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 0) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: -- no rewrite EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### 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/check_constraint.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/check_constraint.q.out b/ql/src/test/results/clientpositive/llap/check_constraint.q.out index 085b003..51ccafc 100644 --- a/ql/src/test/results/clientpositive/llap/check_constraint.q.out +++ b/ql/src/test/results/clientpositive/llap/check_constraint.q.out @@ -79,8 +79,12 @@ Column Name:bb Check Value:bb IN (23.4,56,4) PREHOOK: query: EXPLAIN INSERT INTO table1_n0 values(1,100,true, 5, 23.4, 700.5) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table1_n0 POSTHOOK: query: EXPLAIN INSERT INTO table1_n0 values(1,100,true, 5, 23.4, 700.5) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table1_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -230,8 +234,12 @@ Column Name:i Check Value:i + NULL > 0 PREHOOK: query: EXPLAIN INSERT INTO table2_n0 values(8) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table2_n0 POSTHOOK: query: EXPLAIN INSERT INTO table2_n0 values(8) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table2_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -330,8 +338,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@tudf PREHOOK: query: EXPLAIN INSERT INTO tudf values('function1') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tudf POSTHOOK: query: EXPLAIN INSERT INTO tudf values('function1') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tudf STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -461,8 +473,12 @@ Column Name:numclicks Check Value:numClicks > 0 PREHOOK: query: EXPLAIN INSERT INTO tmulti values('hive.apache.com', 'user1', 48, '12-01-2018') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tmulti POSTHOOK: query: EXPLAIN INSERT INTO tmulti values('hive.apache.com', 'user1', 48, '12-01-2018') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tmulti STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -620,8 +636,12 @@ Column Name:numclicks Check Value:numClicks > 0 PREHOOK: query: EXPLAIN INSERT INTO tmulti values('hive.apache.com', 'user1', 48, '12-01-2018') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tmulti POSTHOOK: query: EXPLAIN INSERT INTO tmulti values('hive.apache.com', 'user1', 48, '12-01-2018') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tmulti STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -765,8 +785,12 @@ Column Name:numclicks Check Value:numclicks > 0 PREHOOK: query: EXPLAIN INSERT INTO tcase values('hive.apache.com', 'user1', '12-01-2018', 48) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcase POSTHOOK: query: EXPLAIN INSERT INTO tcase values('hive.apache.com', 'user1', '12-01-2018', 48) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcase STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -911,8 +935,12 @@ Column Name:price Check Value:cast(numClicks as FLOAT)*price > 10.00 PREHOOK: query: EXPLAIN INSERT INTO tcast values('www.google.com', 100, cast(0.5 as float)) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcast POSTHOOK: query: EXPLAIN INSERT INTO tcast values('www.google.com', 100, cast(0.5 as float)) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcast STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -989,8 +1017,12 @@ POSTHOOK: Input: default@tcast www.google.com 100 0.5 PREHOOK: query: EXPLAIN INSERT INTO tcast(url, price) values('www.yahoo.com', 0.5) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcast POSTHOOK: query: EXPLAIN INSERT INTO tcast(url, price) values('www.yahoo.com', 0.5) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcast STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1142,8 +1174,12 @@ Column Name:b Check Value:((cast(d as float) + f) < cast(i as float) + (i PREHOOK: query: explain insert into texpr values(3,3.4,5.6,true) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@texpr POSTHOOK: query: explain insert into texpr values(3,3.4,5.6,true) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@texpr STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1294,8 +1330,12 @@ Column Name:vc Check Value:de >= cast(i as decimal(5,2)) PREHOOK: query: explain insert into table acid_uami_n0 select cast(key as int), cast (key as decimal(5,2)), value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain insert into table acid_uami_n0 select cast(key as int), cast (key as decimal(5,2)), value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1373,9 +1413,13 @@ POSTHOOK: Lineage: acid_uami_n0.vc EXPRESSION [(src)src.FieldSchema(name:value, PREHOOK: query: explain insert overwrite table acid_uami_n0 select cast(key as int), cast (key as decimal(5,2)), value from src order by cast(key as int) limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain insert overwrite table acid_uami_n0 select cast(key as int), cast (key as decimal(5,2)), value from src order by cast(key as int) limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1472,9 +1516,13 @@ POSTHOOK: Lineage: acid_uami_n0.vc EXPRESSION [(src)src.FieldSchema(name:value, PREHOOK: query: explain insert into table acid_uami_n0 select cast(s1.key as int) as c1, cast (s2.key as decimal(5,2)) as c2, s1.value from src s1 left outer join src s2 on s1.key=s2.key where s1.value > 'val' limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain insert into table acid_uami_n0 select cast(s1.key as int) as c1, cast (s2.key as decimal(5,2)) as c2, s1.value from src s1 left outer join src s2 on s1.key=s2.key where s1.value > 'val' limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1648,9 +1696,13 @@ POSTHOOK: Output: default@acid_uami_n0 PREHOOK: query: explain insert into table acid_uami_n0 select min(cast(key as int)) as c1, max(cast (key as decimal(5,2))) as c2, value from src group by key, value order by key, value limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain insert into table acid_uami_n0 select min(cast(key as int)) as c1, max(cast (key as decimal(5,2))) as c2, value from src group by key, value order by key, value limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1794,11 +1846,17 @@ from src insert into table acid_uami_n0 select cast(key as int), cast(key as decimal(5,2)), value where key < 10 insert overwrite table src_multi2_n0 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n0 +PREHOOK: Output: default@src_multi2_n0 POSTHOOK: query: explain from src insert into table acid_uami_n0 select cast(key as int), cast(key as decimal(5,2)), value where key < 10 insert overwrite table src_multi2_n0 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n0 +POSTHOOK: Output: default@src_multi2_n0 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1909,8 +1967,12 @@ POSTHOOK: Input: default@acid_uami_n0 #### A masked pattern was here #### PREHOOK: query: explain update acid_uami_n0 set de = 893.14 where de = 103.00 or de = 119.00 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_uami_n0 +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain update acid_uami_n0 set de = 893.14 where de = 103.00 or de = 119.00 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_uami_n0 +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1997,8 +2059,12 @@ POSTHOOK: query: ALTER table acid_uami_n0 drop constraint ch2 POSTHOOK: type: ALTERTABLE_DROPCONSTRAINT PREHOOK: query: explain update acid_uami_n0 set vc = 'apache_hive' where de = 893.14 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_uami_n0 +PREHOOK: Output: default@acid_uami_n0 POSTHOOK: query: explain update acid_uami_n0 set vc = 'apache_hive' where de = 893.14 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_uami_n0 +POSTHOOK: Output: default@acid_uami_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2159,11 +2225,21 @@ WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@nonacid +PREHOOK: Input: default@tmerge +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge POSTHOOK: query: explain MERGE INTO tmerge as t using nonacid as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@nonacid +POSTHOOK: Input: default@tmerge +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -2346,11 +2422,23 @@ WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@nonacid +PREHOOK: Input: default@tmerge +PREHOOK: Output: default@merge_tmp_table +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge POSTHOOK: query: explain MERGE INTO tmerge as t using nonacid as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@nonacid +POSTHOOK: Input: default@tmerge +POSTHOOK: Output: default@merge_tmp_table +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge STAGE DEPENDENCIES: Stage-4 is a root stage Stage-5 depends on stages: Stage-4 @@ -2587,10 +2675,20 @@ PREHOOK: query: explain MERGE INTO tmerge as t using nonacid as s ON t.key = s.k WHEN MATCHED AND s.key < 5 THEN DELETE WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@nonacid +PREHOOK: Input: default@tmerge +PREHOOK: Output: default@merge_tmp_table +PREHOOK: Output: default@tmerge +PREHOOK: Output: default@tmerge POSTHOOK: query: explain MERGE INTO tmerge as t using nonacid as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@nonacid +POSTHOOK: Input: default@tmerge +POSTHOOK: Output: default@merge_tmp_table +POSTHOOK: Output: default@tmerge +POSTHOOK: Output: default@tmerge STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -2901,8 +2999,12 @@ Column Name:a Default Value:127Y PREHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(456) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@numericdatatype POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(456) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@numericdatatype STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3050,8 +3152,12 @@ Column Name:b Check Value:b in(4,5) PREHOOK: query: EXPLAIN INSERT INTO tcheck(a) values(1) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcheck POSTHOOK: query: EXPLAIN INSERT INTO tcheck(a) values(1) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcheck STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3125,8 +3231,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN INSERT INTO tcheck(b) values(4) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tcheck POSTHOOK: query: EXPLAIN INSERT INTO tcheck(b) values(4) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tcheck STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3237,8 +3347,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@part_mm PREHOOK: query: explain insert into table part_mm partition(key_mm=455) select key from src order by value limit 3 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@part_mm@key_mm=455 POSTHOOK: query: explain insert into table part_mm partition(key_mm=455) select key from src order by value limit 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@part_mm@key_mm=455 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3467,8 +3581,12 @@ Column Name:null Check Value:a != '' AND b > 4 PREHOOK: query: explain insert into tbl1_n1 values('a', 69) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tbl1_n1 POSTHOOK: query: explain insert into tbl1_n1 values('a', 69) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tbl1_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3595,8 +3713,12 @@ Column Name:null Check Value:(b < 100) PREHOOK: query: explain insert into tbl1_n1 values('a', 69) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tbl1_n1 POSTHOOK: query: explain insert into tbl1_n1 values('a', 69) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tbl1_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1
