http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction.q.out b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction.q.out index 1c3a730..ff9d98c 100644 --- a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction.q.out +++ b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction.q.out @@ -150,8 +150,22 @@ POSTHOOK: Output: default@srcpart_small_n3@ds=2008-04-09 #### A masked pattern was here #### PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -267,8 +281,22 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -411,8 +439,22 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.ds) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.ds) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -540,8 +582,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_small_n3.key1 = alltypesorc_int_n1.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n1 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_small_n3.key1 = alltypesorc_int_n1.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n1 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -681,8 +739,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_small_n3.key1 = alltypesorc_int_n1.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n1 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_small_n3.key1 = alltypesorc_int_n1.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n1 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -880,8 +954,22 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1 and srcpart_date_n7.value = srcpart_small_n3.value1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1 and srcpart_date_n7.value = srcpart_small_n3.value1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -997,8 +1085,22 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1 and srcpart_date_n7.value = srcpart_small_n3.value1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1 and srcpart_date_n7.value = srcpart_small_n3.value1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1167,8 +1269,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n1 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n1 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1324,8 +1442,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n1 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n1 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1535,8 +1669,22 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 0 PREHOOK: query: EXPLAIN extended select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN extended select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `key` FROM `default`.`srcpart_date_n7` @@ -1894,8 +2042,22 @@ STAGE PLANS: PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2005,8 +2167,22 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2116,8 +2292,22 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2253,8 +2443,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 176 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n1 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n1 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2397,8 +2603,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n1 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n1 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2541,8 +2763,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n1 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.key = srcpart_small_n3.key1) join alltypesorc_int_n1 on (srcpart_date_n7.value = alltypesorc_int_n1.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n1 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2749,8 +2987,24 @@ POSTHOOK: Lineage: alltypesorc_int40.cint SIMPLE [(alltypesorc_int_n1)alltypesor POSTHOOK: Lineage: alltypesorc_int40.cstring SIMPLE [(alltypesorc_int_n1)alltypesorc_int_n1.FieldSchema(name:cstring, type:string, comment:null), ] PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.ds = srcpart_small_n3.ds) join alltypesorc_int40 on (srcpart_date_n7.value = alltypesorc_int40.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int40 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.ds = srcpart_small_n3.ds) join alltypesorc_int40 on (srcpart_date_n7.value = alltypesorc_int40.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int40 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2904,8 +3158,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 0 PREHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.ds = srcpart_small_n3.ds) join alltypesorc_int40 on (srcpart_date_n7.value = alltypesorc_int40.cstring) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int40 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_date_n7 join srcpart_small_n3 on (srcpart_date_n7.ds = srcpart_small_n3.ds) join alltypesorc_int40 on (srcpart_date_n7.value = alltypesorc_int40.cstring) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int40 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3086,8 +3356,24 @@ POSTHOOK: Output: default@srcpart_small10 #### A masked pattern was here #### PREHOOK: query: EXPLAIN select count(*) from srcpart_small10, srcpart_small_n3, srcpart_date_n7 where srcpart_small_n3.key1 = srcpart_small10.key1 and srcpart_date_n7.ds = srcpart_small_n3.ds PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small10 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_small10, srcpart_small_n3, srcpart_date_n7 where srcpart_small_n3.key1 = srcpart_small10.key1 and srcpart_date_n7.ds = srcpart_small_n3.ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small10 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3242,8 +3528,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 10000 PREHOOK: query: EXPLAIN select count(*) from srcpart_small10, srcpart_small_n3, srcpart_date_n7 where srcpart_small_n3.key1 = srcpart_small10.key1 and srcpart_date_n7.ds = srcpart_small_n3.ds PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small10 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_small10, srcpart_small_n3, srcpart_date_n7 where srcpart_small_n3.key1 = srcpart_small10.key1 and srcpart_date_n7.ds = srcpart_small_n3.ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small10 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3424,8 +3726,24 @@ POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 10000 PREHOOK: query: EXPLAIN select count(*) from srcpart_small10, srcpart_small_n3, srcpart_date_n7 where srcpart_small_n3.key1 = srcpart_small10.key1 and srcpart_date_n7.ds = srcpart_small_n3.ds PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small10 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_small10, srcpart_small_n3, srcpart_date_n7 where srcpart_small_n3.key1 = srcpart_small10.key1 and srcpart_date_n7.ds = srcpart_small_n3.ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small10 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3585,8 +3903,24 @@ STAGE PLANS: PREHOOK: query: EXPLAIN select count(*) from srcpart_small10, srcpart_small_n3, srcpart_date_n7 where srcpart_small_n3.key1 = srcpart_small10.key1 and srcpart_date_n7.ds = srcpart_small_n3.ds PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small10 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN select count(*) from srcpart_small10, srcpart_small_n3, srcpart_date_n7 where srcpart_small_n3.key1 = srcpart_small10.key1 and srcpart_date_n7.ds = srcpart_small_n3.ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small10 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3723,11 +4057,27 @@ PREHOOK: query: explain select * from alltypesorc_int_n1 join union all select srcpart_small_n3.key1 as key from srcpart_small_n3) unionsrc on (alltypesorc_int_n1.cstring = unionsrc.key) PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc_int_n1 +PREHOOK: Input: default@srcpart_date_n7 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +PREHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +PREHOOK: Input: default@srcpart_small_n3 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +PREHOOK: Input: default@srcpart_small_n3@ds=2008-04-09 +#### A masked pattern was here #### POSTHOOK: query: explain select * from alltypesorc_int_n1 join (select srcpart_date_n7.key as key from srcpart_date_n7 union all select srcpart_small_n3.key1 as key from srcpart_small_n3) unionsrc on (alltypesorc_int_n1.cstring = unionsrc.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc_int_n1 +POSTHOOK: Input: default@srcpart_date_n7 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_date_n7@ds=2008-04-09 +POSTHOOK: Input: default@srcpart_small_n3 +POSTHOOK: Input: default@srcpart_small_n3@ds=2008-04-08 +POSTHOOK: Input: default@srcpart_small_n3@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/163caed7/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/163caed7/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/163caed7/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/163caed7/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 e85fd5e..bd7fcbd 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/163caed7/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/163caed7/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/163caed7/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 dec761e..62fdbdb 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 @@ -233,8 +236,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 @@ -332,8 +338,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 @@ -411,8 +420,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 @@ -558,8 +570,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 @@ -638,8 +653,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 @@ -737,8 +755,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 @@ -816,8 +837,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 @@ -1349,8 +1373,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 @@ -1464,8 +1491,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 @@ -1544,8 +1574,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 @@ -1644,8 +1677,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 @@ -1765,8 +1801,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 @@ -2154,8 +2193,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 @@ -2269,8 +2311,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 @@ -2443,8 +2488,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 @@ -2493,8 +2546,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 @@ -2657,8 +2718,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 @@ -2707,8 +2776,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 @@ -2793,9 +2870,12 @@ POSTHOOK: Output: default@addcolumns_vectorization_true_disallowincompatible_tru PREHOOK: query: explain insert into table addcolumns_vectorization_true_disallowincompatible_true_fileformat_orc_tinyint partition (s) select cint,csmallint, cstring1 from alltypesorc limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Output: default@addcolumns_vectorization_true_disallowincompatible_true_fileformat_orc_tinyint POSTHOOK: query: explain insert into table addcolumns_vectorization_true_disallowincompatible_true_fileformat_orc_tinyint partition (s) select cint,csmallint, cstring1 from alltypesorc limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1
