http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out b/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out index 0da6c05..2ac8400 100644 --- a/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out @@ -19,9 +19,15 @@ POSTHOOK: Lineage: orc_src.value SIMPLE [(src)src.FieldSchema(name:value, type:s PREHOOK: query: explain SELECT count(*) FROM src, orc_src where src.key=orc_src.key PREHOOK: type: QUERY +PREHOOK: Input: default@orc_src +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT count(*) FROM src, orc_src where src.key=orc_src.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_src +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -133,12 +139,26 @@ srcpart x join srcpart y on (x.key = y.key) union all select key, value from srcpart z) a join src b on (a.value = b.value) group by a.key, a.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +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 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from (select x.key as key, y.value as value from srcpart x join srcpart y on (x.key = y.key) union all select key, value from srcpart z) a join src b on (a.value = b.value) group by a.key, a.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +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 +#### 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/tez_join_result_complex.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out b/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out index 849a691..c54a89b 100644 --- a/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out @@ -133,6 +133,10 @@ inner join service_request_clean b on a.contact_event_id = b.cnctevn_id PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@ct_events_clean +PREHOOK: Input: default@service_request_clean +PREHOOK: Output: database:default +PREHOOK: Output: default@ct_events1_test POSTHOOK: query: explain extended create table ct_events1_test as select a.*, @@ -148,6 +152,10 @@ inner join service_request_clean b on a.contact_event_id = b.cnctevn_id POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@ct_events_clean +POSTHOOK: Input: default@service_request_clean +POSTHOOK: Output: database:default +POSTHOOK: Output: default@ct_events1_test OPTIMIZED SQL: SELECT `t0`.`contact_event_id`, `t0`.`ce_create_dt`, `t0`.`ce_end_dt`, `t0`.`contact_type`, `t0`.`cnctevs_cd`, `t0`.`contact_mode`, `t0`.`cntvnst_stts_cd`, `t0`.`total_transfers`, `t0`.`ce_notes`, `t2`.`svcrqst_id`, `t2`.`svcrqct_cds`, `t2`.`svcrtyp_cd`, `t2`.`cmpltyp_cd`, `t2`.`sum_reason_cd` AS `src`, `t2`.`cnctmd_cd`, `t2`.`notes` FROM (SELECT `contact_event_id`, `ce_create_dt`, `ce_end_dt`, `contact_type`, `cnctevs_cd`, `contact_mode`, `cntvnst_stts_cd`, `total_transfers`, `ce_notes` FROM `default`.`ct_events_clean` @@ -1131,6 +1139,10 @@ inner join service_request_clean b on a.contact_event_id = b.cnctevn_id PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@ct_events_clean +PREHOOK: Input: default@service_request_clean +PREHOOK: Output: database:default +PREHOOK: Output: default@ct_events1_test POSTHOOK: query: explain extended create table ct_events1_test as select a.*, @@ -1146,6 +1158,10 @@ inner join service_request_clean b on a.contact_event_id = b.cnctevn_id POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@ct_events_clean +POSTHOOK: Input: default@service_request_clean +POSTHOOK: Output: database:default +POSTHOOK: Output: default@ct_events1_test OPTIMIZED SQL: SELECT `t0`.`contact_event_id`, `t0`.`ce_create_dt`, `t0`.`ce_end_dt`, `t0`.`contact_type`, `t0`.`cnctevs_cd`, `t0`.`contact_mode`, `t0`.`cntvnst_stts_cd`, `t0`.`total_transfers`, `t0`.`ce_notes`, `t2`.`svcrqst_id`, `t2`.`svcrqct_cds`, `t2`.`svcrtyp_cd`, `t2`.`cmpltyp_cd`, `t2`.`sum_reason_cd` AS `src`, `t2`.`cnctmd_cd`, `t2`.`notes` FROM (SELECT `contact_event_id`, `ce_create_dt`, `ce_end_dt`, `contact_type`, `cnctevs_cd`, `contact_mode`, `cntvnst_stts_cd`, `total_transfers`, `ce_notes` FROM `default`.`ct_events_clean` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out b/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out index 5f55446..4471f04 100644 --- a/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out @@ -1,9 +1,15 @@ PREHOOK: query: explain select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### 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/tez_joins_explain.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_joins_explain.q.out b/ql/src/test/results/clientpositive/llap/tez_joins_explain.q.out index 81df0f2..08a2215 100644 --- a/ql/src/test/results/clientpositive/llap/tez_joins_explain.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_joins_explain.q.out @@ -1,9 +1,15 @@ PREHOOK: query: explain select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### 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/tez_nway_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out b/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out index 9b9f157..288f64c 100644 --- a/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out @@ -34,8 +34,14 @@ POSTHOOK: Output: default@bar POSTHOOK: Lineage: bar.key SCRIPT [] PREHOOK: query: explain select count(*) from foo a join bar b on (a.key = b.key) join bar c on (a.key = c.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bar +PREHOOK: Input: default@foo +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from foo a join bar b on (a.key = b.key) join bar c on (a.key = c.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bar +POSTHOOK: Input: default@foo +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -149,8 +155,14 @@ STAGE PLANS: PREHOOK: query: explain select count(*) from foo a join bar b on (a.key = b.key) join bar c on (a.key = c.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bar +PREHOOK: Input: default@foo +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from foo a join bar b on (a.key = b.key) join bar c on (a.key = c.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bar +POSTHOOK: Input: default@foo +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -293,8 +305,14 @@ POSTHOOK: Input: default@foo 1 PREHOOK: query: explain select count(*) from foo a left outer join bar b on (a.key = b.key) left outer join bar c on (a.key = c.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bar +PREHOOK: Input: default@foo +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from foo a left outer join bar b on (a.key = b.key) left outer join bar c on (a.key = c.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bar +POSTHOOK: Input: default@foo +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -401,8 +419,14 @@ STAGE PLANS: PREHOOK: query: explain select count(*) from foo a left outer join bar b on (a.key = b.key) left outer join bar c on (a.key = c.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bar +PREHOOK: Input: default@foo +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from foo a left outer join bar b on (a.key = b.key) left outer join bar c on (a.key = c.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bar +POSTHOOK: Input: default@foo +#### 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/tez_self_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_self_join.q.out b/ql/src/test/results/clientpositive/llap/tez_self_join.q.out index ca0dace..c8bde87 100644 --- a/ql/src/test/results/clientpositive/llap/tez_self_join.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_self_join.q.out @@ -54,6 +54,9 @@ join tez_self_join2 on s.id1=tez_self_join2.id1 where s.id2='ab' PREHOOK: type: QUERY +PREHOOK: Input: default@tez_self_join1 +PREHOOK: Input: default@tez_self_join2 +#### A masked pattern was here #### POSTHOOK: query: explain select s.id2, s.id3 from @@ -65,6 +68,9 @@ join tez_self_join2 on s.id1=tez_self_join2.id1 where s.id2='ab' POSTHOOK: type: QUERY +POSTHOOK: Input: default@tez_self_join1 +POSTHOOK: Input: default@tez_self_join2 +#### 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/tez_smb_empty.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_smb_empty.q.out b/ql/src/test/results/clientpositive/llap/tez_smb_empty.q.out index dfc4d30..b529bbb 100644 --- a/ql/src/test/results/clientpositive/llap/tez_smb_empty.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_smb_empty.q.out @@ -119,9 +119,17 @@ POSTHOOK: Output: default@empty_n0 PREHOOK: query: explain select count(*) from tab_n4 s1 join empty_n0 s3 on s1.key=s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@empty_n0 +PREHOOK: Input: default@tab_n4 +PREHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n4 s1 join empty_n0 s3 on s1.key=s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty_n0 +POSTHOOK: Input: default@tab_n4 +POSTHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -214,9 +222,17 @@ POSTHOOK: Input: default@tab_n4@ds=2008-04-08 PREHOOK: query: explain select * from tab_n4 s1 left outer join empty_n0 s3 on s1.key=s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@empty_n0 +PREHOOK: Input: default@tab_n4 +PREHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select * from tab_n4 s1 left outer join empty_n0 s3 on s1.key=s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty_n0 +POSTHOOK: Input: default@tab_n4 +POSTHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -523,9 +539,17 @@ POSTHOOK: Input: default@tab_n4@ds=2008-04-08 PREHOOK: query: explain select count(*) from tab_n4 s1 left outer join tab_n4 s2 on s1.key=s2.key join empty_n0 s3 on s1.key = s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@empty_n0 +PREHOOK: Input: default@tab_n4 +PREHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n4 s1 left outer join tab_n4 s2 on s1.key=s2.key join empty_n0 s3 on s1.key = s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty_n0 +POSTHOOK: Input: default@tab_n4 +POSTHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -632,9 +656,17 @@ POSTHOOK: Input: default@tab_n4@ds=2008-04-08 PREHOOK: query: explain select count(*) from tab_n4 s1 left outer join empty_n0 s2 on s1.key=s2.key join tab_n4 s3 on s1.key = s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@empty_n0 +PREHOOK: Input: default@tab_n4 +PREHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n4 s1 left outer join empty_n0 s2 on s1.key=s2.key join tab_n4 s3 on s1.key = s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty_n0 +POSTHOOK: Input: default@tab_n4 +POSTHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -741,9 +773,13 @@ POSTHOOK: Input: default@tab_n4@ds=2008-04-08 PREHOOK: query: explain select count(*) from empty_n0 s1 join empty_n0 s3 on s1.key=s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@empty_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from empty_n0 s1 join empty_n0 s3 on s1.key=s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -832,9 +868,17 @@ POSTHOOK: Input: default@empty_n0 PREHOOK: query: explain select count(*) from empty_n0 s1 join tab_n4 s3 on s1.key=s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@empty_n0 +PREHOOK: Input: default@tab_n4 +PREHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from empty_n0 s1 join tab_n4 s3 on s1.key=s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty_n0 +POSTHOOK: Input: default@tab_n4 +POSTHOOK: Input: default@tab_n4@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_smb_main.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_smb_main.q.out b/ql/src/test/results/clientpositive/llap/tez_smb_main.q.out index 0fbb1b1..06f43de 100644 --- a/ql/src/test/results/clientpositive/llap/tez_smb_main.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_smb_main.q.out @@ -1,9 +1,15 @@ PREHOOK: query: explain select * from src a join src1 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from src a join src1 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -244,10 +250,20 @@ PREHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -357,10 +373,20 @@ PREHOOK: query: explain select count (*) from tab_n11 a join tab_part_n12 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count (*) from tab_n11 a join tab_part_n12 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -470,10 +496,20 @@ PREHOOK: query: explain select count (*) from tab_n11 a join tab_part_n12 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count (*) from tab_n11 a join tab_part_n12 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -581,8 +617,20 @@ POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 480 PREHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key join src1 c on a.value = c.value PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key join src1 c on a.value = c.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -717,8 +765,20 @@ STAGE PLANS: PREHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key join src1 c on a.value = c.value PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key join src1 c on a.value = c.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -863,8 +923,18 @@ POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 40 PREHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -961,8 +1031,18 @@ STAGE PLANS: PREHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1078,12 +1158,22 @@ UNION ALL select s2.key as key, s2.value as value from tab_n11 s2 ) a join tab_part_n12 b on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select s1.key as key, s1.value as value from tab_n11 s1 join tab_n11 s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from tab_n11 s2 ) a join tab_part_n12 b on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1223,8 +1313,18 @@ STAGE PLANS: PREHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1315,8 +1415,18 @@ STAGE PLANS: PREHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1422,8 +1532,20 @@ POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 480 PREHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key join src1 c on a.value = c.value PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key join src1 c on a.value = c.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1545,8 +1667,20 @@ STAGE PLANS: PREHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key join src1 c on a.value = c.value PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from tab_n11 a join tab_part_n12 b on a.key = b.key join src1 c on a.value = c.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1689,12 +1823,22 @@ UNION ALL select s2.key as key, s2.value as value from tab_n11 s2 ) a join tab_part_n12 b on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select s1.key as key, s1.value as value from tab_n11 s1 join tab_n11 s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from tab_n11 s2 ) a join tab_part_n12 b on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1863,6 +2007,11 @@ join (select t2.key as id, t2.value as od from tab_part_n12 t2 order by id, od) rt2) vt2 where vt1.id=vt2.id PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n11 +PREHOOK: Input: default@tab_n11@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n12 +PREHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from (select rt1.id from @@ -1872,6 +2021,11 @@ join (select t2.key as id, t2.value as od from tab_part_n12 t2 order by id, od) rt2) vt2 where vt1.id=vt2.id POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n11 +POSTHOOK: Input: default@tab_n11@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n12 +POSTHOOK: Input: default@tab_part_n12@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out b/ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out index 0e49f56..9ee3dc1 100644 --- a/ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out @@ -57,6 +57,9 @@ FROM (SELECT a.key AS key1, a.cnt AS cnt1, b.key AS key2, b.cnt AS cnt2 RIGHT OUTER JOIN (SELECT y.key as key, count(y.value) AS cnt FROM src1_10 y group by y.key) b ON (a.key = b.key)) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src1_10 +PREHOOK: Input: default@src_10 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(key1)), SUM(HASH(cnt1)), SUM(HASH(key2)), SUM(HASH(cnt2)) FROM (SELECT a.key AS key1, a.cnt AS cnt1, b.key AS key2, b.cnt AS cnt2 @@ -64,6 +67,9 @@ FROM (SELECT a.key AS key1, a.cnt AS cnt1, b.key AS key2, b.cnt AS cnt2 RIGHT OUTER JOIN (SELECT y.key as key, count(y.value) AS cnt FROM src1_10 y group by y.key) b ON (a.key = b.key)) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1_10 +POSTHOOK: Input: default@src_10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -571,8 +577,14 @@ POSTHOOK: Output: default@t2 POSTHOOK: Lineage: t2.c1 SCRIPT [] PREHOOK: query: explain SELECT c1 FROM t1 WHERE c1 NOT IN (SELECT c1 FROM t2 where t1.c1=t2.c1) PREHOOK: type: QUERY +PREHOOK: Input: default@t1 +PREHOOK: Input: default@t2 +#### A masked pattern was here #### POSTHOOK: query: explain SELECT c1 FROM t1 WHERE c1 NOT IN (SELECT c1 FROM t2 where t1.c1=t2.c1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1 +POSTHOOK: Input: default@t2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -769,8 +781,14 @@ POSTHOOK: Output: default@t2 POSTHOOK: Lineage: t2.c1 SCRIPT [] PREHOOK: query: explain SELECT c1 FROM t1 WHERE c1 NOT IN (SELECT c1 FROM t2 where t1.c1=t2.c1) PREHOOK: type: QUERY +PREHOOK: Input: default@t1 +PREHOOK: Input: default@t2 +#### A masked pattern was here #### POSTHOOK: query: explain SELECT c1 FROM t1 WHERE c1 NOT IN (SELECT c1 FROM t2 where t1.c1=t2.c1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1 +POSTHOOK: Input: default@t2 +#### 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/tez_union.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_union.q.out b/ql/src/test/results/clientpositive/llap/tez_union.q.out index 914ed47..875b75f 100644 --- a/ql/src/test/results/clientpositive/llap/tez_union.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_union.q.out @@ -3,11 +3,15 @@ select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from src s2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from src s2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -159,11 +163,15 @@ with u as (select * from src union all select * from src) select count(*) from (select u1.key as k1, u2.key as k2 from u as u1 join u as u2 on (u1.key = u2.key)) a PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain with u as (select * from src union all select * from src) select count(*) from (select u1.key as k1, u2.key as k2 from u as u1 join u as u2 on (u1.key = u2.key)) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -344,10 +352,14 @@ PREHOOK: query: explain select s1.key as skey, u1.key as ukey from src s1 join (select * from src union all select * from src) u1 on s1.key = u1.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select s1.key as skey, u1.key as ukey from src s1 join (select * from src union all select * from src) u1 on s1.key = u1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -521,6 +533,8 @@ join (select s2.key as key from src s2 join src s3 on s2.key = s3.key join src s8 on (u1.key = s8.key) order by lkey PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select s1.key as skey, u1.key as ukey, s8.key as lkey from src s1 join (select s2.key as key from src s2 join src s3 on s2.key = s3.key @@ -529,6 +543,8 @@ join (select s2.key as key from src s2 join src s3 on s2.key = s3.key join src s8 on (u1.key = s8.key) order by lkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -975,10 +991,14 @@ PREHOOK: query: explain select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1171,11 +1191,15 @@ select * from (select * from src union all select * from src) u left outer join src s on u.key = s.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select * from src union all select * from src) u left outer join src s on u.key = s.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1282,11 +1306,15 @@ select u.key as ukey, s.key as skey from (select * from src union all select * from src) u right outer join src s on u.key = s.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select u.key as ukey, s.key as skey from (select * from src union all select * from src) u right outer join src s on u.key = s.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1454,8 +1482,13 @@ POSTHOOK: Lineage: view_n123456789.emp_id SIMPLE [(table1_n3)table1_n3.FieldSche POSTHOOK: Lineage: view_n123456789.emp_name SIMPLE [(table1_n3)table1_n3.FieldSchema(name:emp_name, type:string, comment:null), ] PREHOOK: query: explain formatted select count(*) from view_n123456789 PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n3 +PREHOOK: Input: default@view_n123456789 +#### A masked pattern was here #### POSTHOOK: query: explain formatted select count(*) from view_n123456789 POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n3 +POSTHOOK: Input: default@view_n123456789 #### A masked pattern was here #### PREHOOK: query: drop table table2_n1 PREHOOK: type: DROPTABLE @@ -1487,6 +1520,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@view_n123456789 PREHOOK: query: explain formatted select count(*) from view_n123456789 PREHOOK: type: QUERY +PREHOOK: Input: default@table1_n3 +PREHOOK: Input: default@table2_n1 +PREHOOK: Input: default@view_n123456789 +#### A masked pattern was here #### POSTHOOK: query: explain formatted select count(*) from view_n123456789 POSTHOOK: type: QUERY +POSTHOOK: Input: default@table1_n3 +POSTHOOK: Input: default@table2_n1 +POSTHOOK: Input: default@view_n123456789 #### A masked pattern was here #### http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_union2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_union2.q.out b/ql/src/test/results/clientpositive/llap/tez_union2.q.out index 7cbee12..b00c36e 100644 --- a/ql/src/test/results/clientpositive/llap/tez_union2.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_union2.q.out @@ -15,6 +15,8 @@ SELECT key, value FROM )t4 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT key, value FROM ( @@ -32,6 +34,8 @@ SELECT key, value FROM )t4 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### 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/tez_union_dynamic_partition.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_union_dynamic_partition.q.out b/ql/src/test/results/clientpositive/llap/tez_union_dynamic_partition.q.out index dae5130..b2202ad 100644 --- a/ql/src/test/results/clientpositive/llap/tez_union_dynamic_partition.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_union_dynamic_partition.q.out @@ -38,12 +38,15 @@ select 1 as id1, '2014' as part1 from dummy_n2 union all select 2 as id1, '2014' as part1 from dummy_n2 ) temps PREHOOK: type: QUERY +PREHOOK: Input: default@dummy_n2 +PREHOOK: Output: default@partunion1 POSTHOOK: query: explain insert into table partunion1 partition(part1) select temps.* from ( select 1 as id1, '2014' as part1 from dummy_n2 union all select 2 as id1, '2014' as part1 from dummy_n2 ) temps POSTHOOK: type: QUERY +POSTHOOK: Input: default@dummy_n2 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_union_dynamic_partition_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_union_dynamic_partition_2.q.out b/ql/src/test/results/clientpositive/llap/tez_union_dynamic_partition_2.q.out index 114aceb..0d61e29 100644 --- a/ql/src/test/results/clientpositive/llap/tez_union_dynamic_partition_2.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_union_dynamic_partition_2.q.out @@ -46,12 +46,15 @@ select 1 as id1, '2014' as part1 from dummy_n7 union all select 2 as id1, '2014' as part1 from dummy_n7 ) temps PREHOOK: type: QUERY +PREHOOK: Input: default@dummy_n7 +PREHOOK: Output: default@partunion1_n0 POSTHOOK: query: explain insert into table partunion1_n0 partition(part1) select temps.* from ( select 1 as id1, '2014' as part1 from dummy_n7 union all select 2 as id1, '2014' as part1 from dummy_n7 ) temps POSTHOOK: type: QUERY +POSTHOOK: Input: default@dummy_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_union_group_by.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_union_group_by.q.out b/ql/src/test/results/clientpositive/llap/tez_union_group_by.q.out index 2c79549..d512e7d 100644 --- a/ql/src/test/results/clientpositive/llap/tez_union_group_by.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_union_group_by.q.out @@ -111,6 +111,11 @@ GROUP BY x_n3.u ON n.u = o.u WHERE n.u <> 0 AND n.ft <= '2014-09-02' PREHOOK: type: QUERY +PREHOOK: Input: default@v_n15 +PREHOOK: Input: default@x_n3 +PREHOOK: Input: default@y_n1 +PREHOOK: Input: default@z_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT o.u, n.u FROM @@ -138,6 +143,11 @@ GROUP BY x_n3.u ON n.u = o.u WHERE n.u <> 0 AND n.ft <= '2014-09-02' POSTHOOK: type: QUERY +POSTHOOK: Input: default@v_n15 +POSTHOOK: Input: default@x_n3 +POSTHOOK: Input: default@y_n1 +POSTHOOK: Input: default@z_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/tez_union_multiinsert.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out b/ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out index 04ae90a..05d259b 100644 --- a/ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out @@ -27,6 +27,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n150 +PREHOOK: Output: default@dest2_n39 POSTHOOK: query: explain FROM ( select key, value from ( @@ -40,6 +43,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n150 +POSTHOOK: Output: default@dest2_n39 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1003,6 +1009,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n150 +PREHOOK: Output: default@dest2_n39 POSTHOOK: query: explain FROM ( select key, value from src s0 @@ -1015,6 +1024,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n150 +POSTHOOK: Output: default@dest2_n39 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1975,6 +1987,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n150 +PREHOOK: Output: default@dest2_n39 POSTHOOK: query: explain FROM ( select key, value from src s0 @@ -1986,6 +2001,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n150 +POSTHOOK: Output: default@dest2_n39 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2941,6 +2959,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n150 +PREHOOK: Output: default@dest2_n39 POSTHOOK: query: explain FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 UNION all @@ -2949,6 +2970,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n150 +POSTHOOK: Output: default@dest2_n39 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -3864,6 +3888,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n150 +PREHOOK: Output: default@dest2_n39 POSTHOOK: query: explain FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 UNION distinct @@ -3872,6 +3899,9 @@ INSERT OVERWRITE TABLE DEST1_n150 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(uni INSERT OVERWRITE TABLE DEST2_n39 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n150 +POSTHOOK: Output: default@dest2_n39 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out index db483d1..a3e285b 100644 --- a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out @@ -6,6 +6,8 @@ where a.cint between 1000000 and 3000000 and b.cbigint is not null order by a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select * @@ -14,6 +16,8 @@ where a.cint between 1000000 and 3000000 and b.cbigint is not null order by a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -141,6 +145,8 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) @@ -148,6 +154,8 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -268,6 +276,8 @@ where group by a.csmallint order by a.csmallint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select a.csmallint, count(*) c1 @@ -277,6 +287,8 @@ where group by a.csmallint order by a.csmallint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -423,6 +435,8 @@ where a.cint between 1000000 and 3000000 and b.cbigint is not null order by a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select * @@ -431,6 +445,8 @@ where a.cint between 1000000 and 3000000 and b.cbigint is not null order by a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -562,6 +578,8 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) @@ -569,6 +587,8 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -693,6 +713,8 @@ where group by a.csmallint order by a.csmallint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select a.csmallint, count(*) c1 @@ -702,6 +724,8 @@ where group by a.csmallint order by a.csmallint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### 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/tez_vector_dynpart_hashjoin_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out index 3f74be1..37970ab 100644 --- a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out @@ -10,6 +10,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select a.* @@ -22,6 +25,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -204,6 +210,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select a.* @@ -216,6 +225,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -398,6 +410,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select a.* @@ -410,6 +425,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### 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/topnkey.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/topnkey.q.out b/ql/src/test/results/clientpositive/llap/topnkey.q.out index c1d8874..9dafa1f 100644 --- a/ql/src/test/results/clientpositive/llap/topnkey.q.out +++ b/ql/src/test/results/clientpositive/llap/topnkey.q.out @@ -1,9 +1,13 @@ PREHOOK: query: EXPLAIN SELECT key, SUM(CAST(SUBSTR(value,5) AS INT)) FROM src GROUP BY key ORDER BY key LIMIT 5 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT key, SUM(CAST(SUBSTR(value,5) AS INT)) FROM src GROUP BY key ORDER BY key LIMIT 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -101,9 +105,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT key FROM src GROUP BY key ORDER BY key LIMIT 5 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT key FROM src GROUP BY key ORDER BY key LIMIT 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -197,9 +205,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain vectorization detail SELECT src1.key, src2.value FROM src src1 JOIN src src2 ON (src1.key = src2.key) ORDER BY src1.key LIMIT 5 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail SELECT src1.key, src2.value FROM src src1 JOIN src src2 ON (src1.key = src2.key) ORDER BY src1.key LIMIT 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: false enabledConditionsNotMet: [hive.vectorized.execution.enabled IS false] http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/udf_coalesce.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/udf_coalesce.q.out b/ql/src/test/results/clientpositive/llap/udf_coalesce.q.out index 48e9e32..34e610d 100644 --- a/ql/src/test/results/clientpositive/llap/udf_coalesce.q.out +++ b/ql/src/test/results/clientpositive/llap/udf_coalesce.q.out @@ -34,6 +34,8 @@ SELECT COALESCE(1), COALESCE(IF(TRUE, NULL, 0), NULL) FROM src tablesample (1 rows) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT COALESCE(1), COALESCE(1, 2), @@ -55,6 +57,8 @@ SELECT COALESCE(1), COALESCE(IF(TRUE, NULL, 0), NULL) FROM src tablesample (1 rows) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -122,12 +126,16 @@ SELECT COALESCE(src_thrift.lint[1], 999), COALESCE(src_thrift.mstringstring['key_2'], '999') FROM src_thrift PREHOOK: type: QUERY +PREHOOK: Input: default@src_thrift +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT COALESCE(src_thrift.lint[1], 999), COALESCE(src_thrift.lintstring[0].mystring, '999'), COALESCE(src_thrift.mstringstring['key_2'], '999') FROM src_thrift POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_thrift +#### 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/union2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union2.q.out b/ql/src/test/results/clientpositive/llap/union2.q.out index c9d09a0..7009ce4 100644 --- a/ql/src/test/results/clientpositive/llap/union2.q.out +++ b/ql/src/test/results/clientpositive/llap/union2.q.out @@ -2,10 +2,14 @@ PREHOOK: query: explain select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL select s2.key as key, s2.value as value from src s2) unionsrc PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL select s2.key as key, s2.value as value from src s2) unionsrc POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### 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/union3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union3.q.out b/ql/src/test/results/clientpositive/llap/union3.q.out index 80dd6e1..1a9fdd4 100644 --- a/ql/src/test/results/clientpositive/llap/union3.q.out +++ b/ql/src/test/results/clientpositive/llap/union3.q.out @@ -15,6 +15,8 @@ FROM ( CLUSTER BY id ) a PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM ( @@ -32,6 +34,8 @@ FROM ( CLUSTER BY id ) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### 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/union4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union4.q.out b/ql/src/test/results/clientpositive/llap/union4.q.out index 0685d26..eb8c900 100644 --- a/ql/src/test/results/clientpositive/llap/union4.q.out +++ b/ql/src/test/results/clientpositive/llap/union4.q.out @@ -12,12 +12,16 @@ insert overwrite table tmptable_n12 UNION ALL select 'tst2' as key, count(1) as value from src s2) unionsrc PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@tmptable_n12 POSTHOOK: query: explain insert overwrite table tmptable_n12 select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, count(1) as value from src s1 UNION ALL select 'tst2' as key, count(1) as value from src s2) unionsrc POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@tmptable_n12 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/union5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union5.q.out b/ql/src/test/results/clientpositive/llap/union5.q.out index e6de3e4..26ef4c6 100644 --- a/ql/src/test/results/clientpositive/llap/union5.q.out +++ b/ql/src/test/results/clientpositive/llap/union5.q.out @@ -3,11 +3,15 @@ PREHOOK: query: explain UNION ALL select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1 UNION ALL select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### 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/union6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union6.q.out b/ql/src/test/results/clientpositive/llap/union6.q.out index cfd20a8..b120098 100644 --- a/ql/src/test/results/clientpositive/llap/union6.q.out +++ b/ql/src/test/results/clientpositive/llap/union6.q.out @@ -12,12 +12,18 @@ insert overwrite table tmptable_n5 UNION ALL select s2.key as key, s2.value as value from src1 s2) unionsrc PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@tmptable_n5 POSTHOOK: query: explain insert overwrite table tmptable_n5 select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 UNION ALL select s2.key as key, s2.value as value from src1 s2) unionsrc POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@tmptable_n5 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/union7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union7.q.out b/ql/src/test/results/clientpositive/llap/union7.q.out index 612bf86..d9bb4a9 100644 --- a/ql/src/test/results/clientpositive/llap/union7.q.out +++ b/ql/src/test/results/clientpositive/llap/union7.q.out @@ -3,11 +3,17 @@ PREHOOK: query: explain UNION ALL select s2.key as key, s2.value as value from src1 s2) unionsrc group by unionsrc.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 UNION ALL select s2.key as key, s2.value as value from src1 s2) unionsrc group by unionsrc.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### 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/union8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union8.q.out b/ql/src/test/results/clientpositive/llap/union8.q.out index 5fb990a..3173864 100644 --- a/ql/src/test/results/clientpositive/llap/union8.q.out +++ b/ql/src/test/results/clientpositive/llap/union8.q.out @@ -3,11 +3,15 @@ PREHOOK: query: explain select s2.key as key, s2.value as value from src s2 UNION ALL select s3.key as key, s3.value as value from src s3) unionsrc PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION ALL select s2.key as key, s2.value as value from src s2 UNION ALL select s3.key as key, s3.value as value from src s3) unionsrc POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### 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/union9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union9.q.out b/ql/src/test/results/clientpositive/llap/union9.q.out index a67065a..fc8bd99 100644 --- a/ql/src/test/results/clientpositive/llap/union9.q.out +++ b/ql/src/test/results/clientpositive/llap/union9.q.out @@ -3,11 +3,15 @@ PREHOOK: query: explain select s2.key as key, s2.value as value from src s2 UNION ALL select s3.key as key, s3.value as value from src s3) unionsrc PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL select s2.key as key, s2.value as value from src s2 UNION ALL select s3.key as key, s3.value as value from src s3) unionsrc POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1
