http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out index a0f57ac..801416d 100644 --- a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out +++ b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out @@ -50,6 +50,9 @@ FROM table_1_n2 tt1 INNER JOIN table_18_n2 tt2 ON (tt2.decimal1911_col_16) = (tt1.decimal2612_col_77) WHERE (t1.timestamp_col_9) = (tt2.timestamp_col_18)) PREHOOK: type: QUERY +PREHOOK: Input: default@table_18_n2 +PREHOOK: Input: default@table_1_n2 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT COUNT(*) @@ -64,6 +67,9 @@ FROM table_1_n2 tt1 INNER JOIN table_18_n2 tt2 ON (tt2.decimal1911_col_16) = (tt1.decimal2612_col_77) WHERE (t1.timestamp_col_9) = (tt2.timestamp_col_18)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@table_18_n2 +POSTHOOK: Input: default@table_1_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -508,6 +514,9 @@ select on a.key = b.key join src1 c on a.value = c.value where c.key < 0 PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Input: default@tab2_n6 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) @@ -518,6 +527,9 @@ select on a.key = b.key join src1 c on a.value = c.value where c.key < 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@tab2_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/b356aae0/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out index 251c348..cb3740d 100644 --- a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out +++ b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out @@ -19,11 +19,23 @@ WHEN MATCHED AND s.a > 8 THEN DELETE WHEN MATCHED THEN UPDATE SET b = 7 WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) PREHOOK: type: QUERY +PREHOOK: Input: default@acidtbl +PREHOOK: Input: default@nonacidorctbl +PREHOOK: Output: default@acidtbl +PREHOOK: Output: default@acidtbl +PREHOOK: Output: default@acidtbl +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain merge into acidTbl as t using nonAcidOrcTbl s ON t.a = s.a WHEN MATCHED AND s.a > 8 THEN DELETE WHEN MATCHED THEN UPDATE SET b = 7 WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@acidtbl +POSTHOOK: Input: default@nonacidorctbl +POSTHOOK: Output: default@acidtbl +POSTHOOK: Output: default@acidtbl +POSTHOOK: Output: default@acidtbl +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-4 is a root stage Stage-5 depends on stages: Stage-4 @@ -366,9 +378,15 @@ STAGE PLANS: PREHOOK: query: explain merge into acidTbl as t using nonAcidOrcTbl s ON t.a = s.a WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) PREHOOK: type: QUERY +PREHOOK: Input: default@acidtbl +PREHOOK: Input: default@nonacidorctbl +PREHOOK: Output: default@acidtbl POSTHOOK: query: explain merge into acidTbl as t using nonAcidOrcTbl s ON t.a = s.a WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@acidtbl +POSTHOOK: Input: default@nonacidorctbl +POSTHOOK: Output: default@acidtbl STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -539,6 +557,12 @@ WHEN MATCHED AND s.a > 8 THEN DELETE WHEN MATCHED THEN UPDATE SET b = 7 WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) PREHOOK: type: QUERY +PREHOOK: Input: default@acidtbl +PREHOOK: Input: default@nonacidorctbl +PREHOOK: Output: default@acidtbl +PREHOOK: Output: default@acidtbl +PREHOOK: Output: default@acidtbl +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain merge into acidTbl as t using ( select * from nonAcidOrcTbl where a > 0 union all @@ -548,6 +572,12 @@ WHEN MATCHED AND s.a > 8 THEN DELETE WHEN MATCHED THEN UPDATE SET b = 7 WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@acidtbl +POSTHOOK: Input: default@nonacidorctbl +POSTHOOK: Output: default@acidtbl +POSTHOOK: Output: default@acidtbl +POSTHOOK: Output: default@acidtbl +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-4 is a root stage Stage-5 depends on stages: Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_4.q.out b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_4.q.out index 4c04eb1..cc1c06d 100644 --- a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_4.q.out +++ b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_4.q.out @@ -288,8 +288,22 @@ POSTHOOK: Output: default@srcpart_small_ext@ds=2008-04-09 test.comment=This query should use semijoin reduction optimization PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n1 join srcpart_small_n0 on (srcpart_date_n1.key = srcpart_small_n0.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n1 +PREHOOK: Input: default@srcpart_date_n1@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n1@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n0 +PREHOOK: Input: default@srcpart_small_n0@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n0@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n1 join srcpart_small_n0 on (srcpart_date_n1.key = srcpart_small_n0.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n1 +POSTHOOK: Input: default@srcpart_date_n1@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n1@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n0 +POSTHOOK: Input: default@srcpart_small_n0@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n0@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -413,8 +427,26 @@ STAGE PLANS: PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n1 join srcpart_small_n0 on (srcpart_date_n1.key = srcpart_small_n0.key1) join srcpart_medium_n0 on (srcpart_medium_n0.key2 = srcpart_date_n1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n1 +PREHOOK: Input: default@srcpart_date_n1@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n1@ds=2008-04-09 +PREHOOK: Input: default@srcpart_medium_n0 +PREHOOK: Input: default@srcpart_medium_n0@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n0 +PREHOOK: Input: default@srcpart_small_n0@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n0@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n1 join srcpart_small_n0 on (srcpart_date_n1.key = srcpart_small_n0.key1) join srcpart_medium_n0 on (srcpart_medium_n0.key2 = srcpart_date_n1.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n1 +POSTHOOK: Input: default@srcpart_date_n1@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n1@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_medium_n0 +POSTHOOK: Input: default@srcpart_medium_n0@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n0 +POSTHOOK: Input: default@srcpart_small_n0@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n0@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -587,8 +619,22 @@ STAGE PLANS: test.comment=Big table is external table - no semijoin reduction opt PREHOOK: query: EXPLAIN select count(*) from srcpart_date_ext join srcpart_small_n0 on (srcpart_date_ext.key = srcpart_small_n0.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_ext +PREHOOK: Input: default@srcpart_date_ext@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_ext@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n0 +PREHOOK: Input: default@srcpart_small_n0@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n0@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_ext join srcpart_small_n0 on (srcpart_date_ext.key = srcpart_small_n0.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_ext +POSTHOOK: Input: default@srcpart_date_ext@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_ext@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n0 +POSTHOOK: Input: default@srcpart_small_n0@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n0@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -686,8 +732,22 @@ STAGE PLANS: test.comment=Small table is external table - no semijoin reduction opt PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n1 join srcpart_small_ext on (srcpart_date_n1.key = srcpart_small_ext.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n1 +PREHOOK: Input: default@srcpart_date_n1@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n1@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_ext +PREHOOK: Input: default@srcpart_small_ext@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_ext@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n1 join srcpart_small_ext on (srcpart_date_n1.key = srcpart_small_ext.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n1 +POSTHOOK: Input: default@srcpart_date_n1@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n1@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_ext +POSTHOOK: Input: default@srcpart_small_ext@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_ext@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -785,8 +845,26 @@ STAGE PLANS: test.comment=Small table is external table - no semijoin reduction opt for ext table but semijoin reduction opt for regular table PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n1 join srcpart_small_ext on (srcpart_date_n1.key = srcpart_small_ext.key1) join srcpart_medium_n0 on (srcpart_medium_n0.key2 = srcpart_date_n1.key) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n1 +PREHOOK: Input: default@srcpart_date_n1@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n1@ds=2008-04-09 +PREHOOK: Input: default@srcpart_medium_n0 +PREHOOK: Input: default@srcpart_medium_n0@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_ext +PREHOOK: Input: default@srcpart_small_ext@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_ext@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n1 join srcpart_small_ext on (srcpart_date_n1.key = srcpart_small_ext.key1) join srcpart_medium_n0 on (srcpart_medium_n0.key2 = srcpart_date_n1.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n1 +POSTHOOK: Input: default@srcpart_date_n1@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n1@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_medium_n0 +POSTHOOK: Input: default@srcpart_medium_n0@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_ext +POSTHOOK: Input: default@srcpart_small_ext@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_ext@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/b356aae0/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw.q.out b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw.q.out index 6056865..1461e86 100644 --- a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw.q.out +++ b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw.q.out @@ -167,6 +167,13 @@ JOIN ( ON (srcpart_small_n2.key1 = alltypesorc_int_n0.cstring)) b ON ('1' = '1') PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n0 +PREHOOK: Input: default@srcpart_date_n6 +PREHOOK: Input: default@srcpart_date_n6@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n6@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n2 +PREHOOK: Input: default@srcpart_small_n2@ds1=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT count(*) FROM ( @@ -185,6 +192,13 @@ JOIN ( ON (srcpart_small_n2.key1 = alltypesorc_int_n0.cstring)) b ON ('1' = '1') POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n0 +POSTHOOK: Input: default@srcpart_date_n6 +POSTHOOK: Input: default@srcpart_date_n6@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n6@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n2 +POSTHOOK: Input: default@srcpart_small_n2@ds1=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/b356aae0/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw2.q.out b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw2.q.out index 883bdd7..abcbd97 100644 --- a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw2.q.out +++ b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_sw2.q.out @@ -160,6 +160,13 @@ SELECT count(*) ON (alltypesorc_int_n0.cstring = srcpart_small_n2.key1)) b ON (srcpart_small_n2.key1 = b.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n0 +PREHOOK: Input: default@srcpart_date_n6 +PREHOOK: Input: default@srcpart_date_n6@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n2 +PREHOOK: Input: default@srcpart_small_n2@ds1=2008-04-08 +PREHOOK: Input: default@srcpart_small_n2@ds1=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT count(*) FROM (SELECT * FROM srcpart_date_n6 WHERE ds = "2008-04-09") `srcpart_date_n6` @@ -172,6 +179,13 @@ SELECT count(*) ON (alltypesorc_int_n0.cstring = srcpart_small_n2.key1)) b ON (srcpart_small_n2.key1 = b.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n0 +POSTHOOK: Input: default@srcpart_date_n6 +POSTHOOK: Input: default@srcpart_date_n6@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n2 +POSTHOOK: Input: default@srcpart_small_n2@ds1=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n2@ds1=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/b356aae0/ql/src/test/results/clientpositive/llap/dynamic_semijoin_user_level.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_user_level.q.out b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_user_level.q.out index eefc7f0..bc9e6fb 100644 --- a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_user_level.q.out +++ b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_user_level.q.out @@ -150,8 +150,22 @@ POSTHOOK: Output: default@srcpart_small_n4@ds=2008-04-09 POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -225,8 +239,22 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.ds) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.ds) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -291,8 +319,24 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_small_n4.key1 = alltypesorc_int_n2.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n2 +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_small_n4.key1 = alltypesorc_int_n2.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n2 +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -364,8 +408,24 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_small_n4.key1 = alltypesorc_int_n2.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n2 +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_small_n4.key1 = alltypesorc_int_n2.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n2 +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -466,8 +526,22 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1 and srcpart_date_n9.value = srcpart_small_n4.value1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1 and srcpart_date_n9.value = srcpart_small_n4.value1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -528,8 +602,22 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1 and srcpart_date_n9.value = srcpart_small_n4.value1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1 and srcpart_date_n9.value = srcpart_small_n4.value1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -615,8 +703,24 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_date_n9.value = alltypesorc_int_n2.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n2 +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_date_n9.value = alltypesorc_int_n2.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n2 +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -694,8 +798,24 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_date_n9.value = alltypesorc_int_n2.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n2 +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_date_n9.value = alltypesorc_int_n2.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n2 +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -799,8 +919,22 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 0 PREHOOK: query: EXPLAIN extended select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN extended select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`srcpart_date_n9` @@ -1168,8 +1302,22 @@ STAGE PLANS: PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -1227,8 +1375,22 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -1286,8 +1448,24 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_date_n9.value = alltypesorc_int_n2.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n2 +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_date_n9.value = alltypesorc_int_n2.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n2 +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -1359,8 +1537,24 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_date_n9.value = alltypesorc_int_n2.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n2 +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n9 join srcpart_small_n4 on (srcpart_date_n9.key = srcpart_small_n4.key1) join alltypesorc_int_n2 on (srcpart_date_n9.value = alltypesorc_int_n2.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n2 +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage @@ -1435,11 +1629,27 @@ PREHOOK: query: explain select * from alltypesorc_int_n2 join union all select srcpart_small_n4.key1 as key from srcpart_small_n4) unionsrc on (alltypesorc_int_n2.cstring = unionsrc.key) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n2 +PREHOOK: Input: default@srcpart_date_n9 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n4 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select * from alltypesorc_int_n2 join (select srcpart_date_n9.key as key from srcpart_date_n9 union all select srcpart_small_n4.key1 as key from srcpart_small_n4) unionsrc on (alltypesorc_int_n2.cstring = unionsrc.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n2 +POSTHOOK: Input: default@srcpart_date_n9 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n9@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n4 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n4@ds=2008-04-09 +POSTHOOK: Output: hdfs://### HDFS PATH ### Plan optimized by CBO. Vertex dependency in root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out index 29be9a4..6962c30 100644 --- a/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out +++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out @@ -153,8 +153,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part_buck_sort_orc PREHOOK: query: explain insert overwrite table over1k_part_orc partition(ds="foo", t) select si,i,b,f,t from over1k_orc where t is null or t=27 order by si PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_orc@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part_orc partition(ds="foo", t) select si,i,b,f,t from over1k_orc where t is null or t=27 order by si POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -232,8 +235,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_limit_orc partition(ds="foo", t) select si,i,b,f,t from over1k_orc where t is null or t=27 limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_limit_orc@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part_limit_orc partition(ds="foo", t) select si,i,b,f,t from over1k_orc where t is null or t=27 limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -330,8 +336,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_buck_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_buck_orc POSTHOOK: query: explain insert overwrite table over1k_part_buck_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -408,8 +417,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_buck_sort_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_buck_sort_orc POSTHOOK: query: explain insert overwrite table over1k_part_buck_sort_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -554,8 +566,11 @@ POSTHOOK: Lineage: over1k_part_buck_sort_orc PARTITION(t=__HIVE_DEFAULT_PARTITIO POSTHOOK: Lineage: over1k_part_buck_sort_orc PARTITION(t=__HIVE_DEFAULT_PARTITION__).si SIMPLE [(over1k_orc)over1k_orc.FieldSchema(name:si, type:smallint, comment:null), ] PREHOOK: query: explain insert into table over1k_part_orc partition(ds="foo", t) select si,i,b,f,t from over1k_orc where t is null or t=27 order by si PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_orc@ds=foo POSTHOOK: query: explain insert into table over1k_part_orc partition(ds="foo", t) select si,i,b,f,t from over1k_orc where t is null or t=27 order by si POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -633,8 +648,11 @@ STAGE PLANS: PREHOOK: query: explain insert into table over1k_part_limit_orc partition(ds="foo", t) select si,i,b,f,t from over1k_orc where t is null or t=27 limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_limit_orc@ds=foo POSTHOOK: query: explain insert into table over1k_part_limit_orc partition(ds="foo", t) select si,i,b,f,t from over1k_orc where t is null or t=27 limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -731,8 +749,11 @@ STAGE PLANS: PREHOOK: query: explain insert into table over1k_part_buck_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_buck_orc POSTHOOK: query: explain insert into table over1k_part_buck_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -809,8 +830,11 @@ STAGE PLANS: PREHOOK: query: explain insert into table over1k_part_buck_sort_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_buck_sort_orc POSTHOOK: query: explain insert into table over1k_part_buck_sort_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1341,8 +1365,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part2_orc PREHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from over1k_orc where t is null or t=27 order by i PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part2_orc@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from over1k_orc where t is null or t=27 order by i POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1455,8 +1482,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from over1k_orc where t is null or t=27 order by i PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part2_orc@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from over1k_orc where t is null or t=27 order by i POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1534,8 +1564,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from (select * from over1k_orc order by i limit 10) tmp where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part2_orc@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from (select * from over1k_orc order by i limit 10) tmp where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1634,8 +1667,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from over1k_orc where t is null or t=27 group by si,i,b,f,t PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part2_orc@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from over1k_orc where t is null or t=27 group by si,i,b,f,t POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1754,8 +1790,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from over1k_orc where t is null or t=27 group by si,i,b,f,t PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part2_orc@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2_orc partition(ds="foo",t) select si,i,b,f,t from over1k_orc where t is null or t=27 group by si,i,b,f,t POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2142,8 +2181,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part_buck_sort2_orc PREHOOK: query: explain insert overwrite table over1k_part_buck_sort2_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_buck_sort2_orc POSTHOOK: query: explain insert overwrite table over1k_part_buck_sort2_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2256,8 +2298,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_buck_sort2_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_orc +PREHOOK: Output: default@over1k_part_buck_sort2_orc POSTHOOK: query: explain insert overwrite table over1k_part_buck_sort2_orc partition(t) select si,i,b,f,t from over1k_orc where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2429,8 +2474,16 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select * from over1k_part_buck_sort2_orc PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_part_buck_sort2_orc +PREHOOK: Input: default@over1k_part_buck_sort2_orc@t=27 +PREHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### POSTHOOK: query: explain select * from over1k_part_buck_sort2_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_part_buck_sort2_orc +POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=27 +POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -2479,8 +2532,16 @@ POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ 473 65720 4294967324 80.74 NULL PREHOOK: query: explain select count(*) from over1k_part_buck_sort2_orc PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_part_buck_sort2_orc +PREHOOK: Input: default@over1k_part_buck_sort2_orc@t=27 +PREHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from over1k_part_buck_sort2_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_part_buck_sort2_orc +POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=27 +POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2643,8 +2704,16 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select * from over1k_part_buck_sort2_orc PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_part_buck_sort2_orc +PREHOOK: Input: default@over1k_part_buck_sort2_orc@t=27 +PREHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### POSTHOOK: query: explain select * from over1k_part_buck_sort2_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_part_buck_sort2_orc +POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=27 +POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -2691,8 +2760,16 @@ POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ 473 65720 4294967324 80.74 NULL PREHOOK: query: explain select count(*) from over1k_part_buck_sort2_orc PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_part_buck_sort2_orc +PREHOOK: Input: default@over1k_part_buck_sort2_orc@t=27 +PREHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from over1k_part_buck_sort2_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_part_buck_sort2_orc +POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=27 +POSTHOOK: Input: default@over1k_part_buck_sort2_orc@t=__HIVE_DEFAULT_PARTITION__ +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out index 600f452..75ec949 100644 --- a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out +++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out @@ -110,8 +110,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part_buck_sort PREHOOK: query: explain insert overwrite table over1k_part partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -189,8 +192,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_limit partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_limit@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part_limit partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -287,8 +293,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_buck partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck POSTHOOK: query: explain insert overwrite table over1k_part_buck partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -365,8 +374,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_buck_sort partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck_sort POSTHOOK: query: explain insert overwrite table over1k_part_buck_sort partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -511,8 +523,11 @@ POSTHOOK: Lineage: over1k_part_buck_sort PARTITION(t=__HIVE_DEFAULT_PARTITION__) POSTHOOK: Lineage: over1k_part_buck_sort PARTITION(t=__HIVE_DEFAULT_PARTITION__).si SIMPLE [(over1k_n3)over1k_n3.FieldSchema(name:si, type:smallint, comment:null), ] PREHOOK: query: explain insert into table over1k_part partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part@ds=foo POSTHOOK: query: explain insert into table over1k_part partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -590,8 +605,11 @@ STAGE PLANS: PREHOOK: query: explain insert into table over1k_part_limit partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_limit@ds=foo POSTHOOK: query: explain insert into table over1k_part_limit partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -688,8 +706,11 @@ STAGE PLANS: PREHOOK: query: explain insert into table over1k_part_buck partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck POSTHOOK: query: explain insert into table over1k_part_buck partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -766,8 +787,11 @@ STAGE PLANS: PREHOOK: query: explain insert into table over1k_part_buck_sort partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck_sort POSTHOOK: query: explain insert into table over1k_part_buck_sort partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1298,8 +1322,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part2 PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 order by i PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 order by i POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1412,8 +1439,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 order by i PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 order by i POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1491,8 +1521,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from (select * from over1k_n3 order by i limit 10) tmp where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from (select * from over1k_n3 order by i limit 10) tmp where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1591,8 +1624,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 group by si,i,b,f,t PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 group by si,i,b,f,t POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1711,8 +1747,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 group by si,i,b,f,t PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 group by si,i,b,f,t POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2099,8 +2138,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part_buck_sort2 PREHOOK: query: explain insert overwrite table over1k_part_buck_sort2 partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck_sort2 POSTHOOK: query: explain insert overwrite table over1k_part_buck_sort2 partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2213,8 +2255,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_buck_sort2 partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck_sort2 POSTHOOK: query: explain insert overwrite table over1k_part_buck_sort2 partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2585,8 +2630,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part3 PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where s="foo" PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where s="foo" POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2665,8 +2713,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2745,8 +2796,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2825,8 +2879,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2905,8 +2962,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and s="foo" PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and s="foo" POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2985,8 +3045,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where t=27 and s="foo" PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where t=27 and s="foo" POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3065,8 +3128,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and t=27 and s="foo" PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and t=27 and s="foo" POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 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/b356aae0/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out index 0b57fbc..a65d2d9 100644 --- a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out +++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out @@ -61,6 +61,8 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_n0 +PREHOOK: Output: default@ss_part POSTHOOK: query: explain insert overwrite table ss_part partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -72,6 +74,7 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -308,6 +311,8 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_n0 +PREHOOK: Output: default@ss_part POSTHOOK: query: explain insert overwrite table ss_part partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -316,6 +321,7 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -544,6 +550,8 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_n0 +PREHOOK: Output: default@ss_part POSTHOOK: query: explain insert overwrite table ss_part partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -555,6 +563,7 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -811,6 +820,8 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_n0 +PREHOOK: Output: default@ss_part POSTHOOK: query: explain insert overwrite table ss_part partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -819,6 +830,7 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1122,6 +1134,8 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_orc +PREHOOK: Output: default@ss_part_orc POSTHOOK: query: explain insert overwrite table ss_part_orc partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -1133,6 +1147,7 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1389,6 +1404,8 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_orc +PREHOOK: Output: default@ss_part_orc POSTHOOK: query: explain insert overwrite table ss_part_orc partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -1397,6 +1414,7 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1680,6 +1698,8 @@ select from src group by "day", key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@hive13_dp1 POSTHOOK: query: explain insert overwrite table `hive13_dp1` partition(`day`) select key k1, @@ -1688,6 +1708,7 @@ select from src group by "day", key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1852,6 +1873,8 @@ select from src group by "day", key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@hive13_dp1 POSTHOOK: query: explain insert overwrite table `hive13_dp1` partition(`day`) select key k1, @@ -1860,6 +1883,7 @@ select from src group by "day", key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src 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/b356aae0/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out index bb1d41c..4d0a9e5 100644 --- a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out +++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out @@ -74,8 +74,14 @@ POSTHOOK: Input: default@acid_part@ds=2008-04-08 1001 PREHOOK: query: explain update acid_part set value = 'bar' where key = 'foo' and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@acid_part +PREHOOK: Input: default@acid_part@ds=2008-04-08 +PREHOOK: Output: default@acid_part@ds=2008-04-08 POSTHOOK: query: explain update acid_part set value = 'bar' where key = 'foo' and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_part +POSTHOOK: Input: default@acid_part@ds=2008-04-08 +POSTHOOK: Output: default@acid_part@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -169,8 +175,14 @@ POSTHOOK: Input: default@acid_part@ds=2008-04-08 1001 PREHOOK: query: explain update acid_part set value = 'bar' where key = 'foo' and ds in ('2008-04-08') PREHOOK: type: QUERY +PREHOOK: Input: default@acid_part +PREHOOK: Input: default@acid_part@ds=2008-04-08 +PREHOOK: Output: default@acid_part@ds=2008-04-08 POSTHOOK: query: explain update acid_part set value = 'bar' where key = 'foo' and ds in ('2008-04-08') POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_part +POSTHOOK: Input: default@acid_part@ds=2008-04-08 +POSTHOOK: Output: default@acid_part@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -360,8 +372,14 @@ POSTHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 1001 PREHOOK: query: explain update acid_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@acid_part_sdpo +PREHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 +PREHOOK: Output: default@acid_part_sdpo@ds=2008-04-08 POSTHOOK: query: explain update acid_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_part_sdpo +POSTHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 +POSTHOOK: Output: default@acid_part_sdpo@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -455,8 +473,14 @@ POSTHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 1001 PREHOOK: query: explain update acid_part_sdpo set value = 'bar' where key = 'foo' and ds in ('2008-04-08') PREHOOK: type: QUERY +PREHOOK: Input: default@acid_part_sdpo +PREHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 +PREHOOK: Output: default@acid_part_sdpo@ds=2008-04-08 POSTHOOK: query: explain update acid_part_sdpo set value = 'bar' where key = 'foo' and ds in ('2008-04-08') POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_part_sdpo +POSTHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 +POSTHOOK: Output: default@acid_part_sdpo@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -655,8 +679,14 @@ POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 POSTHOOK: query: explain update acid_2L_part set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -751,8 +781,18 @@ POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=12 POSTHOOK: query: explain update acid_2L_part set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -876,9 +916,27 @@ POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 PREHOOK: query: explain delete from acid_2L_part where value = 'bar' PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=12 +PREHOOK: Input: default@acid_2l_part@ds=2008-04-09/hr=11 +PREHOOK: Input: default@acid_2l_part@ds=2008-04-09/hr=12 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-09/hr=11 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-09/hr=12 POSTHOOK: query: explain delete from acid_2L_part where value = 'bar' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-09/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1075,8 +1133,14 @@ POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 POSTHOOK: query: explain update acid_2L_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1171,8 +1235,18 @@ POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 POSTHOOK: query: explain update acid_2L_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1296,9 +1370,27 @@ POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 PREHOOK: query: explain delete from acid_2L_part_sdpo where value = 'bar' PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-09/hr=11 +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-09/hr=12 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-09/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-09/hr=12 POSTHOOK: query: explain delete from acid_2L_part_sdpo where value = 'bar' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-09/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1495,8 +1587,14 @@ POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part_sdpo_no_cp set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 POSTHOOK: query: explain update acid_2L_part_sdpo_no_cp set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1593,8 +1691,18 @@ POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part_sdpo_no_cp set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=12 POSTHOOK: query: explain update acid_2L_part_sdpo_no_cp set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=12 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/b356aae0/ql/src/test/results/clientpositive/llap/empty_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/empty_join.q.out b/ql/src/test/results/clientpositive/llap/empty_join.q.out index bd3381b..c3a3cbc 100644 --- a/ql/src/test/results/clientpositive/llap/empty_join.q.out +++ b/ql/src/test/results/clientpositive/llap/empty_join.q.out @@ -46,12 +46,20 @@ FROM test_1_n2 t1 LEFT JOIN test_2_n2 t2 ON t1.id = t2.id INNER JOIN test_3_n0 t3 ON t1.id = t3.id PREHOOK: type: QUERY +PREHOOK: Input: default@test_1_n2 +PREHOOK: Input: default@test_2_n2 +PREHOOK: Input: default@test_3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain SELECT t1.id, t2.id, t3.id FROM test_1_n2 t1 LEFT JOIN test_2_n2 t2 ON t1.id = t2.id INNER JOIN test_3_n0 t3 ON t1.id = t3.id POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_1_n2 +POSTHOOK: Input: default@test_2_n2 +POSTHOOK: Input: default@test_3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage