http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out index e9a8b01..4c5532f 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_9.q.out @@ -43,11 +43,17 @@ select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -146,6 +152,9 @@ select key, count(*) from ) subq1 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from ( @@ -153,6 +162,9 @@ select key, count(*) from ) subq1 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -268,6 +280,9 @@ select count(*) from group by key ) subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -278,6 +293,9 @@ select count(*) from group by key ) subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -418,6 +436,9 @@ join ) src2 on src1.key = src2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -435,6 +456,9 @@ join ) src2 on src1.key = src2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -651,6 +675,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -658,6 +685,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -765,6 +795,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -777,6 +810,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -901,6 +937,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -920,6 +958,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1044,6 +1084,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl1_n10 a where key < 8) subq1 @@ -1051,6 +1094,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1153,6 +1199,9 @@ select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2_n9 a) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl1_n10 a) subq1 @@ -1160,6 +1209,9 @@ select count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2_n9 a) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1278,11 +1330,17 @@ select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1380,12 +1438,18 @@ select count(*) from tbl1_n10 a (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tbl1_n10 a join (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1489,6 +1553,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -1499,6 +1566,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1627,6 +1697,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select subq2.key as key, subq2.value as value1, b.value as value2 from @@ -1640,6 +1713,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1752,11 +1828,17 @@ select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select a.key as key, a.value as val1, b.value as val2 from tbl1_n10 a join tbl2_n9 b on a.key = b.key ) subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1855,6 +1937,9 @@ select key, count(*) from ) subq1 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from ( @@ -1862,6 +1947,9 @@ select key, count(*) from ) subq1 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1977,6 +2065,9 @@ select count(*) from group by key ) subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -1987,6 +2078,9 @@ select count(*) from group by key ) subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2127,6 +2221,9 @@ join ) src2 on src1.key = src2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -2144,6 +2241,9 @@ join ) src2 on src1.key = src2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2360,6 +2460,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -2367,6 +2470,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2474,6 +2580,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -2486,6 +2595,9 @@ select count(*) from join tbl2_n9 b on subq2.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2610,6 +2722,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -2629,6 +2743,8 @@ select count(*) from ) subq4 on subq2.key = subq4.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2753,6 +2869,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl1_n10 a where key < 8) subq1 @@ -2760,6 +2879,9 @@ select count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n9 a where key < 8) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2860,11 +2982,17 @@ select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 join tbl2_n9 a on subq1.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2962,12 +3090,18 @@ select count(*) from tbl1_n10 a (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tbl1_n10 a join (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq1 on a.key = subq1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3071,6 +3205,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select a.key as key, a.value as value from tbl1_n10 a where key < 6) subq1 @@ -3081,6 +3218,9 @@ select count(*) from (select a.key as key, a.value as value from tbl2_n9 a where key < 6) subq3 on (subq1.key = subq3.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3209,6 +3349,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n10 +PREHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select subq2.key as key, subq2.value as value1, b.value as value2 from @@ -3222,6 +3365,9 @@ select count(*) from ( join tbl2_n9 b on subq2.key = b.key) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n10 +POSTHOOK: Input: default@tbl2_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket2.q.out b/ql/src/test/results/clientpositive/llap/bucket2.q.out index d0fa92b..9d86258 100644 --- a/ql/src/test/results/clientpositive/llap/bucket2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket2.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain extended insert overwrite table bucket2_1 select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket2_1 POSTHOOK: query: explain extended insert overwrite table bucket2_1 select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket2_1 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src` STAGE DEPENDENCIES: @@ -239,9 +243,13 @@ POSTHOOK: Lineage: bucket2_1.value SIMPLE [(src)src.FieldSchema(name:value, type PREHOOK: query: explain select * from bucket2_1 tablesample (bucket 1 out of 2) s PREHOOK: type: QUERY +PREHOOK: Input: default@bucket2_1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from bucket2_1 tablesample (bucket 1 out of 2) s POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket2_1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket3.q.out b/ql/src/test/results/clientpositive/llap/bucket3.q.out index 251fbdb..3f7fc1d 100644 --- a/ql/src/test/results/clientpositive/llap/bucket3.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket3.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain extended insert overwrite table bucket3_1 partition (ds='1') select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket3_1@ds=1 POSTHOOK: query: explain extended insert overwrite table bucket3_1 partition (ds='1') select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket3_1@ds=1 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src` STAGE DEPENDENCIES: @@ -269,9 +273,15 @@ POSTHOOK: Lineage: bucket3_1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema( PREHOOK: query: explain select * from bucket3_1 tablesample (bucket 1 out of 2) s where ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@bucket3_1 +PREHOOK: Input: default@bucket3_1@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from bucket3_1 tablesample (bucket 1 out of 2) s where ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket3_1 +POSTHOOK: Input: default@bucket3_1@ds=1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket4.q.out b/ql/src/test/results/clientpositive/llap/bucket4.q.out index be3f350..ec91b3e 100644 --- a/ql/src/test/results/clientpositive/llap/bucket4.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket4.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain extended insert overwrite table bucket4_1 select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket4_1 POSTHOOK: query: explain extended insert overwrite table bucket4_1 select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket4_1 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src` STAGE DEPENDENCIES: @@ -242,9 +246,13 @@ POSTHOOK: Lineage: bucket4_1.value SIMPLE [(src)src.FieldSchema(name:value, type PREHOOK: query: explain select * from bucket4_1 tablesample (bucket 1 out of 2) s PREHOOK: type: QUERY +PREHOOK: Input: default@bucket4_1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from bucket4_1 tablesample (bucket 1 out of 2) s POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket4_1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket5.q.out b/ql/src/test/results/clientpositive/llap/bucket5.q.out index ee444f2..bd56c35 100644 --- a/ql/src/test/results/clientpositive/llap/bucket5.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket5.q.out @@ -19,11 +19,17 @@ FROM src INSERT OVERWRITE TABLE bucketed_table SELECT key, value INSERT OVERWRITE TABLE unbucketed_table SELECT key, value cluster by key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucketed_table +PREHOOK: Output: default@unbucketed_table POSTHOOK: query: EXPLAIN EXTENDED FROM src INSERT OVERWRITE TABLE bucketed_table SELECT key, value INSERT OVERWRITE TABLE unbucketed_table SELECT key, value cluster by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucketed_table +POSTHOOK: Output: default@unbucketed_table STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2, Stage-7, Stage-6, Stage-9 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket6.q.out b/ql/src/test/results/clientpositive/llap/bucket6.q.out index d0c1500..f8d920b 100644 --- a/ql/src/test/results/clientpositive/llap/bucket6.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket6.q.out @@ -9,9 +9,21 @@ POSTHOOK: Output: default@src_bucket PREHOOK: query: explain insert into table src_bucket select key,value from srcpart PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +PREHOOK: Output: default@src_bucket POSTHOOK: query: explain insert into table src_bucket select key,value from srcpart POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@src_bucket STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out index 726d46b..433e033 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out @@ -42,9 +42,15 @@ POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.Field PREHOOK: query: explain select key, count(1) from clustergroupby where ds='100' group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=100 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='100' group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=100 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -175,9 +181,15 @@ POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).value SIMPLE [(src)src.Field PREHOOK: query: explain select key, count(1) from clustergroupby where ds='101' group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='101' group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -283,9 +295,15 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select length(key), count(1) from clustergroupby where ds='101' group by length(key) limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select length(key), count(1) from clustergroupby where ds='101' group by length(key) limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -370,9 +388,15 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select abs(length(key)), count(1) from clustergroupby where ds='101' group by abs(length(key)) limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select abs(length(key)), count(1) from clustergroupby where ds='101' group by abs(length(key)) limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -457,9 +481,15 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select key, count(1) from clustergroupby where ds='101' group by key,'a' order by key,'a' limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='101' group by key,'a' order by key,'a' limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -565,9 +595,15 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select key, count(1) from (select value as key, key as value from clustergroupby where ds='101')subq group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from (select value as key, key as value from clustergroupby where ds='101')subq group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -673,9 +709,17 @@ val_114 1 PREHOOK: query: explain select key, count(1) from clustergroupby group by key PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=100 +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=100 +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1058,9 +1102,17 @@ POSTHOOK: Input: default@clustergroupby@ds=101 PREHOOK: query: explain select key, count(1) from clustergroupby group by key, 3 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=100 +PREHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby group by key, 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=100 +POSTHOOK: Input: default@clustergroupby@ds=101 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1171,9 +1223,15 @@ POSTHOOK: Lineage: clustergroupby PARTITION(ds=102).value SIMPLE [(src)src.Field PREHOOK: query: explain select key, count(1) from clustergroupby where ds='102' group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='102' group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1280,9 +1338,15 @@ POSTHOOK: Input: default@clustergroupby@ds=102 PREHOOK: query: explain select value, count(1) from clustergroupby where ds='102' group by value order by value limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### POSTHOOK: query: explain select value, count(1) from clustergroupby where ds='102' group by value order by value limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1388,9 +1452,15 @@ val_114 1 PREHOOK: query: explain select key, count(1) from clustergroupby where ds='102' group by key, value limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='102' group by key, value limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=102 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1489,9 +1559,15 @@ POSTHOOK: Lineage: clustergroupby PARTITION(ds=103).value SIMPLE [(src)src.Field PREHOOK: query: explain select key, count(1) from clustergroupby where ds='103' group by key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=103 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='103' group by key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=103 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1598,9 +1674,15 @@ POSTHOOK: Input: default@clustergroupby@ds=103 PREHOOK: query: explain select key, count(1) from clustergroupby where ds='103' group by value, key order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@clustergroupby +PREHOOK: Input: default@clustergroupby@ds=103 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(1) from clustergroupby where ds='103' group by value, key order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@clustergroupby +POSTHOOK: Input: default@clustergroupby@ds=103 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket_many.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_many.q.out b/ql/src/test/results/clientpositive/llap/bucket_many.q.out index 80b7b4e..cf16d47 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_many.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_many.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain extended insert overwrite table bucket_many select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket_many POSTHOOK: query: explain extended insert overwrite table bucket_many select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket_many OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src` STAGE DEPENDENCIES: @@ -252,9 +256,13 @@ POSTHOOK: Lineage: bucket_many.value SIMPLE [(src)src.FieldSchema(name:value, ty PREHOOK: query: explain select * from bucket_many tablesample (bucket 2 out of 256) s PREHOOK: type: QUERY +PREHOOK: Input: default@bucket_many +#### A masked pattern was here #### POSTHOOK: query: explain select * from bucket_many tablesample (bucket 2 out of 256) s POSTHOOK: type: QUERY +POSTHOOK: Input: default@bucket_many +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out index bf64a15..771aa6d 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out @@ -166,8 +166,14 @@ POSTHOOK: Output: default@tab_part_n11@ds=2008-04-08 #### A masked pattern was here #### PREHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -291,8 +297,14 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -450,10 +462,16 @@ PREHOOK: query: explain select a.key, a.value, b.value from tab1_n5 a join src b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tab1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, a.value, b.value from tab1_n5 a join src b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tab1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -541,10 +559,16 @@ PREHOOK: query: explain select a.key, a.value, b.value from tab1_n5 a join src b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@tab1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, a.value, b.value from tab1_n5 a join src b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@tab1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -631,9 +655,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -714,9 +744,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -791,9 +827,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a left outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a left outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -874,9 +916,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a left outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a left outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -951,9 +999,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a right outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a right outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1034,9 +1088,15 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a right outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select key from tab_part_n11 where key > 1) a right outer join (select key from tab_part_n11 where key > 2) b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1110,8 +1170,14 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select distinct key from tab_n10) a join tab_n10 b on b.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select distinct key from tab_n10) a join tab_n10 b on b.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1195,8 +1261,14 @@ STAGE PLANS: PREHOOK: query: explain select a.key, b.key from (select distinct key from tab_n10) a join tab_n10 b on b.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from (select distinct key from tab_n10) a join tab_n10 b on b.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1285,8 +1357,14 @@ STAGE PLANS: PREHOOK: query: explain select a.value, b.value from (select distinct value from tab_n10) a join tab_n10 b on b.key = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.value, b.value from (select distinct value from tab_n10) a join tab_n10 b on b.key = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1387,8 +1465,14 @@ STAGE PLANS: PREHOOK: query: explain select a.value, b.value from (select distinct value from tab_n10) a join tab_n10 b on b.key = a.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.value, b.value from (select distinct value from tab_n10) a join tab_n10 b on b.key = a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1528,11 +1612,21 @@ select count(*) from (select distinct key,value from tab_part_n11) a join tab_n10 b on a.key = b.key and a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select distinct key,value from tab_part_n11) a join tab_n10 b on a.key = b.key and a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1647,11 +1741,21 @@ select count(*) from (select distinct key,value from tab_part_n11) a join tab_n10 b on a.key = b.key and a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select distinct key,value from tab_part_n11) a join tab_n10 b on a.key = b.key and a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1799,8 +1903,18 @@ POSTHOOK: Output: default@big@k=2 POSTHOOK: Lineage: big PARTITION(k=2).i SCRIPT [] PREHOOK: query: explain select small.i, big.i from small,big where small.i=big.i PREHOOK: type: QUERY +PREHOOK: Input: default@big +PREHOOK: Input: default@big@k=1 +PREHOOK: Input: default@big@k=2 +PREHOOK: Input: default@small +#### A masked pattern was here #### POSTHOOK: query: explain select small.i, big.i from small,big where small.i=big.i POSTHOOK: type: QUERY +POSTHOOK: Input: default@big +POSTHOOK: Input: default@big@k=1 +POSTHOOK: Input: default@big@k=2 +POSTHOOK: Input: default@small +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1931,8 +2045,14 @@ POSTHOOK: Output: default@tab_part_ext@ds=2008-04-08 test.comment=Bucket map join should work here PREHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from tab_part_n11 a join tab_part_n11 c on a.key = c.key join tab_part_n11 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2057,8 +2177,14 @@ STAGE PLANS: test.comment=External tables, bucket map join should be disabled PREHOOK: query: explain select a.key, b.key from tab_part_ext a join tab_part_ext c on a.key = c.key join tab_part_ext b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_part_ext +PREHOOK: Input: default@tab_part_ext@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select a.key, b.key from tab_part_ext a join tab_part_ext c on a.key = c.key join tab_part_ext b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_part_ext +POSTHOOK: Input: default@tab_part_ext@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2232,6 +2358,9 @@ WHERE my_fact.fiscal_year = '2015' AND my_dim.filter_col IN ( 'VAL1', 'VAL2' ) and my_fact.accounting_period in (10) PREHOOK: type: QUERY +PREHOOK: Input: default@my_dim +PREHOOK: Input: default@my_fact +#### A masked pattern was here #### POSTHOOK: query: explain extended select bucket_col, my_dim.join_col as account1,my_fact.accounting_period FROM my_fact JOIN my_dim ON my_fact.join_col = my_dim.join_col @@ -2239,6 +2368,9 @@ WHERE my_fact.fiscal_year = '2015' AND my_dim.filter_col IN ( 'VAL1', 'VAL2' ) and my_fact.accounting_period in (10) POSTHOOK: type: QUERY +POSTHOOK: Input: default@my_dim +POSTHOOK: Input: default@my_fact +#### 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/bucket_map_join_tez_empty.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out index 105c693..e9e03af 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out @@ -36,8 +36,14 @@ POSTHOOK: Lineage: tab2_n0.key1 SCRIPT [] POSTHOOK: Lineage: tab2_n0.value SCRIPT [] PREHOOK: query: explain select * from tab1_n0, tab2_n0 where tab1_n0.key1 = tab2_n0.key1 PREHOOK: type: QUERY +PREHOOK: Input: default@tab1_n0 +PREHOOK: Input: default@tab2_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from tab1_n0, tab2_n0 where tab1_n0.key1 = tab2_n0.key1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab1_n0 +POSTHOOK: Input: default@tab2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out b/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out index ce23bdf..5991253 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_num_reducers.q.out @@ -9,9 +9,13 @@ POSTHOOK: Output: default@bucket_nr PREHOOK: query: explain extended insert overwrite table bucket_nr select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@bucket_nr POSTHOOK: query: explain extended insert overwrite table bucket_nr select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@bucket_nr OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src` STAGE DEPENDENCIES: http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out b/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out index a767c0a..906e462 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out @@ -9,9 +9,13 @@ POSTHOOK: Output: default@test_table_n4 PREHOOK: query: explain extended insert overwrite table test_table_n4 select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@test_table_n4 POSTHOOK: query: explain extended insert overwrite table test_table_n4 select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@test_table_n4 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src` STAGE DEPENDENCIES: http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out index c70bb07..c9a3452 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out @@ -27,11 +27,17 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n1 a join srcbucket_mapjoin_part_2_n1 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n1 a join srcbucket_mapjoin_part_2_n1 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_part_n1` @@ -168,11 +174,17 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n1 a join srcbucket_mapjoin_part_2_n1 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n1 a join srcbucket_mapjoin_part_2_n1 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_part_n1` @@ -400,12 +412,20 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n1 a join srcbucket_mapjoin_part_n1 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n0 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n0 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n1 a join srcbucket_mapjoin_part_n1 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n0 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_n1` @@ -834,12 +854,20 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n1 a join srcbucket_mapjoin_part_n1 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1 +PREHOOK: Input: default@srcbucket_mapjoin_part_n1@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n0 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n0 select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n1 a join srcbucket_mapjoin_part_n1 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n1@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n0 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_n1` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out index 95ad77b..ca0e062 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out @@ -94,12 +94,22 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key and b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n2 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n2 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key and b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n2 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_part_n6` @@ -533,12 +543,22 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key and b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n2 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n2 select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key and b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n2 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_part_n6` @@ -989,12 +1009,24 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-09 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6 +PREHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n2 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n2 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_n6 a join srcbucket_mapjoin_part_2_n5 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n5@ds=2008-04-09 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n6@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n2 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_part_n6` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out index bb6386e..68fc903 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out @@ -118,12 +118,22 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_2_n11 a join srcbucket_mapjoin_part_n13 b on a.key=b.key and b.ds="2008-04-08" and a.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n11 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n11@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_n13 +PREHOOK: Input: default@srcbucket_mapjoin_part_n13@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n6 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n6 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_2_n11 a join srcbucket_mapjoin_part_n13 b on a.key=b.key and b.ds="2008-04-08" and a.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n11 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n11@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n13 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n13@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n6 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value`, CAST('2008-04-08' AS STRING) AS `ds` FROM `default`.`srcbucket_mapjoin_part_2_n11` @@ -557,12 +567,22 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_2_n11 a join srcbucket_mapjoin_part_n13 b on a.key=b.key and b.ds="2008-04-08" and a.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n11 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n11@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_n13 +PREHOOK: Input: default@srcbucket_mapjoin_part_n13@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n6 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n6 select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_part_2_n11 a join srcbucket_mapjoin_part_n13 b on a.key=b.key and b.ds="2008-04-08" and a.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n11 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n11@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n13 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n13@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n6 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value`, CAST('2008-04-08' AS STRING) AS `ds` FROM `default`.`srcbucket_mapjoin_part_2_n11` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out index 58ea699..185e2aa 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out @@ -118,12 +118,16 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n17 a join srcbucket_mapjoin_n17 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n17 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n8 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n8 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n17 a join srcbucket_mapjoin_n17 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n17 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n8 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_n17` @@ -543,12 +547,16 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n17 a join srcbucket_mapjoin_n17 b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n17 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n8 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n8 select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n17 a join srcbucket_mapjoin_n17 b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n17 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n8 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_n17` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out index 01668fa..53e57b8 100644 --- a/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin7.q.out @@ -58,12 +58,22 @@ FROM srcbucket_mapjoin_part_1_n4 a JOIN srcbucket_mapjoin_part_2_n9 b ON a.key = b.key AND a.ds = '2008-04-08' AND b.ds = '2008-04-08' ORDER BY a.key, b.value LIMIT 1 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_1_n4 +PREHOOK: Input: default@srcbucket_mapjoin_part_1_n4@ds=2008-04-08/hr=0 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n9 +PREHOOK: Input: default@srcbucket_mapjoin_part_2_n9@ds=2008-04-08/hr=0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM srcbucket_mapjoin_part_1_n4 a JOIN srcbucket_mapjoin_part_2_n9 b ON a.key = b.key AND a.ds = '2008-04-08' AND b.ds = '2008-04-08' ORDER BY a.key, b.value LIMIT 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_1_n4 +POSTHOOK: Input: default@srcbucket_mapjoin_part_1_n4@ds=2008-04-08/hr=0 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n9 +POSTHOOK: Input: default@srcbucket_mapjoin_part_2_n9@ds=2008-04-08/hr=0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/bucketpruning1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucketpruning1.q.out b/ql/src/test/results/clientpositive/llap/bucketpruning1.q.out index d80b911..9422eb4 100644 --- a/ql/src/test/results/clientpositive/llap/bucketpruning1.q.out +++ b/ql/src/test/results/clientpositive/llap/bucketpruning1.q.out @@ -17,9 +17,13 @@ POSTHOOK: Output: default@srcbucket_unpruned PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(1 AS INTEGER) AS `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = 1 @@ -82,9 +86,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 16 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 16 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(16 AS INTEGER) AS `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = 16 @@ -147,9 +155,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 17 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 17 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(17 AS INTEGER) AS `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = 17 @@ -212,9 +224,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 16+1 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 16+1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(17 AS INTEGER) AS `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = 17 @@ -277,9 +293,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = '11' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = '11' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(11 AS INTEGER) AS `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = 11 @@ -342,9 +362,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(1 AS INTEGER) AS `key`, `value`, CAST('2008-04-08' AS STRING) AS `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = 1 AND `ds` = '2008-04-08' @@ -407,9 +431,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and value='One' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and value='One' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(1 AS INTEGER) AS `$f0`, CAST('One' AS STRING) AS `$f1`, CAST('2008-04-08' AS STRING) AS `$f2` FROM `default`.`srcbucket_pruned` WHERE `key` = 1 AND `ds` = '2008-04-08' AND `value` = 'One' @@ -472,9 +500,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key = 1 and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key = 1 and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(1 AS INTEGER) AS `$f0`, CAST('One' AS STRING) AS `$f1`, CAST('2008-04-08' AS STRING) AS `$f2` FROM `default`.`srcbucket_pruned` WHERE `value` = 'One' AND `key` = 1 AND `ds` = '2008-04-08' @@ -537,9 +569,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -599,9 +635,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -661,9 +701,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' and value='One' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' and value='One' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -723,9 +767,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key in (2,3) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key in (2,3) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -785,9 +833,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where (key=1 or key=2) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where (key=1 or key=2) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -847,9 +899,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where (key=1 or key=2) and value = 'One' and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where (key=1 or key=2) and value = 'One' and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -909,9 +965,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = -15 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = -15 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(-15 AS INTEGER) AS `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = -15 @@ -974,9 +1034,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1036,9 +1100,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1098,9 +1166,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' and value='One' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' and value='One' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1160,9 +1232,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where value='One' and key in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1222,9 +1298,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' or key = 2 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' or key = 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = 1 AND `ds` = '2008-04-08' OR `key` = 2 @@ -1286,9 +1366,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and (value='One' or value = 'Two') PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and (value='One' or value = 'Two') POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1348,9 +1432,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 and value = "Two" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 and value = "Two" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = 1 OR `value` = 'One' OR `key` = 2 AND `value` = 'Two' @@ -1412,9 +1500,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 'x11' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 'x11' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE FALSE @@ -1475,9 +1567,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, `value`, `ds` FROM `default`.`srcbucket_pruned` WHERE `key` = 1 OR `value` = 'One' @@ -1539,9 +1635,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_pruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1600,9 +1700,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_unpruned where key in (3, 5) PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_unpruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_unpruned where key in (3, 5) POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_unpruned +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1661,9 +1765,13 @@ STAGE PLANS: PREHOOK: query: explain extended select * from srcbucket_unpruned where key = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_unpruned +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from srcbucket_unpruned where key = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_unpruned +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(1 AS INTEGER) AS `key`, `value`, `ds` FROM `default`.`srcbucket_unpruned` WHERE `key` = 1
