http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out index 0c196be..ec95389 100644 --- a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out +++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out @@ -110,8 +110,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part_buck_sort PREHOOK: query: explain insert overwrite table over1k_part partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -190,8 +193,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_limit partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_limit@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part_limit partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -289,8 +295,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_buck partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck POSTHOOK: query: explain insert overwrite table over1k_part_buck partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -368,8 +377,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_buck_sort partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck_sort POSTHOOK: query: explain insert overwrite table over1k_part_buck_sort partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -515,8 +527,11 @@ POSTHOOK: Lineage: over1k_part_buck_sort PARTITION(t=__HIVE_DEFAULT_PARTITION__) POSTHOOK: Lineage: over1k_part_buck_sort PARTITION(t=__HIVE_DEFAULT_PARTITION__).si SIMPLE [(over1k_n3)over1k_n3.FieldSchema(name:si, type:smallint, comment:null), ] PREHOOK: query: explain insert into table over1k_part partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part@ds=foo POSTHOOK: query: explain insert into table over1k_part partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -595,8 +610,11 @@ STAGE PLANS: PREHOOK: query: explain insert into table over1k_part_limit partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_limit@ds=foo POSTHOOK: query: explain insert into table over1k_part_limit partition(ds="foo", t) select si,i,b,f,t from over1k_n3 where t is null or t=27 limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -694,8 +712,11 @@ STAGE PLANS: PREHOOK: query: explain insert into table over1k_part_buck partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck POSTHOOK: query: explain insert into table over1k_part_buck partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -773,8 +794,11 @@ STAGE PLANS: PREHOOK: query: explain insert into table over1k_part_buck_sort partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck_sort POSTHOOK: query: explain insert into table over1k_part_buck_sort partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1306,8 +1330,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part2 PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 order by i PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 order by i POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1421,8 +1448,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 order by i PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 order by i POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1501,8 +1531,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from (select * from over1k_n3 order by i limit 10) tmp where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from (select * from over1k_n3 order by i limit 10) tmp where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1601,8 +1634,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 group by si,i,b,f,t PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 group by si,i,b,f,t POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1722,8 +1758,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 group by si,i,b,f,t PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part2@ds=foo POSTHOOK: query: explain insert overwrite table over1k_part2 partition(ds="foo",t) select si,i,b,f,t from over1k_n3 where t is null or t=27 group by si,i,b,f,t POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2111,8 +2150,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part_buck_sort2 PREHOOK: query: explain insert overwrite table over1k_part_buck_sort2 partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck_sort2 POSTHOOK: query: explain insert overwrite table over1k_part_buck_sort2 partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2226,8 +2268,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part_buck_sort2 partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part_buck_sort2 POSTHOOK: query: explain insert overwrite table over1k_part_buck_sort2 partition(t) select si,i,b,f,t from over1k_n3 where t is null or t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2599,8 +2644,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@over1k_part3 PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where s="foo" PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where s="foo" POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2680,8 +2728,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2761,8 +2812,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2842,8 +2896,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and t=27 PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and t=27 POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2923,8 +2980,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and s="foo" PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and s="foo" POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3004,8 +3064,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where t=27 and s="foo" PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where t=27 and s="foo" POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3085,8 +3148,11 @@ STAGE PLANS: PREHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and t=27 and s="foo" PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n3 +PREHOOK: Output: default@over1k_part3 POSTHOOK: query: explain insert overwrite table over1k_part3 partition(s,t,i) select si,b,f,s,t,i from over1k_n3 where i=100 and t=27 and s="foo" POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out index c730427..d953eeb 100644 --- a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out +++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out @@ -61,6 +61,8 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_n0 +PREHOOK: Output: default@ss_part POSTHOOK: query: explain insert overwrite table ss_part partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -72,6 +74,7 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -309,6 +312,8 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_n0 +PREHOOK: Output: default@ss_part POSTHOOK: query: explain insert overwrite table ss_part partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -317,6 +322,7 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -546,6 +552,8 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_n0 +PREHOOK: Output: default@ss_part POSTHOOK: query: explain insert overwrite table ss_part partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -557,6 +565,7 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -814,6 +823,8 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_n0 +PREHOOK: Output: default@ss_part POSTHOOK: query: explain insert overwrite table ss_part partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -822,6 +833,7 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1126,6 +1138,8 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_orc +PREHOOK: Output: default@ss_part_orc POSTHOOK: query: explain insert overwrite table ss_part_orc partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -1137,6 +1151,7 @@ select ss_net_paid_inc_tax, ss_net_profit distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1394,6 +1409,8 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk PREHOOK: type: QUERY +PREHOOK: Input: default@ss_orc +PREHOOK: Output: default@ss_part_orc POSTHOOK: query: explain insert overwrite table ss_part_orc partition (ss_sold_date_sk) select ss_net_paid_inc_tax, ss_net_profit, @@ -1402,6 +1419,7 @@ select ss_net_paid_inc_tax, where ss_sold_date_sk>=2452617 and ss_sold_date_sk<=2452638 distribute by ss_sold_date_sk POSTHOOK: type: QUERY +POSTHOOK: Input: default@ss_orc STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1686,6 +1704,8 @@ select from src group by "day", key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@hive13_dp1 POSTHOOK: query: explain insert overwrite table `hive13_dp1` partition(`day`) select key k1, @@ -1694,6 +1714,7 @@ select from src group by "day", key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1858,6 +1879,8 @@ select from src group by "day", key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@hive13_dp1 POSTHOOK: query: explain insert overwrite table `hive13_dp1` partition(`day`) select key k1, @@ -1866,6 +1889,7 @@ select from src group by "day", key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out index 157f96a..5fd1bf6 100644 --- a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out +++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out @@ -74,8 +74,14 @@ POSTHOOK: Input: default@acid_part@ds=2008-04-08 1001 PREHOOK: query: explain update acid_part set value = 'bar' where key = 'foo' and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@acid_part +PREHOOK: Input: default@acid_part@ds=2008-04-08 +PREHOOK: Output: default@acid_part@ds=2008-04-08 POSTHOOK: query: explain update acid_part set value = 'bar' where key = 'foo' and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_part +POSTHOOK: Input: default@acid_part@ds=2008-04-08 +POSTHOOK: Output: default@acid_part@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -170,8 +176,14 @@ POSTHOOK: Input: default@acid_part@ds=2008-04-08 1001 PREHOOK: query: explain update acid_part set value = 'bar' where key = 'foo' and ds in ('2008-04-08') PREHOOK: type: QUERY +PREHOOK: Input: default@acid_part +PREHOOK: Input: default@acid_part@ds=2008-04-08 +PREHOOK: Output: default@acid_part@ds=2008-04-08 POSTHOOK: query: explain update acid_part set value = 'bar' where key = 'foo' and ds in ('2008-04-08') POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_part +POSTHOOK: Input: default@acid_part@ds=2008-04-08 +POSTHOOK: Output: default@acid_part@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -362,8 +374,14 @@ POSTHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 1001 PREHOOK: query: explain update acid_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@acid_part_sdpo +PREHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 +PREHOOK: Output: default@acid_part_sdpo@ds=2008-04-08 POSTHOOK: query: explain update acid_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_part_sdpo +POSTHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 +POSTHOOK: Output: default@acid_part_sdpo@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -458,8 +476,14 @@ POSTHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 1001 PREHOOK: query: explain update acid_part_sdpo set value = 'bar' where key = 'foo' and ds in ('2008-04-08') PREHOOK: type: QUERY +PREHOOK: Input: default@acid_part_sdpo +PREHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 +PREHOOK: Output: default@acid_part_sdpo@ds=2008-04-08 POSTHOOK: query: explain update acid_part_sdpo set value = 'bar' where key = 'foo' and ds in ('2008-04-08') POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_part_sdpo +POSTHOOK: Input: default@acid_part_sdpo@ds=2008-04-08 +POSTHOOK: Output: default@acid_part_sdpo@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -659,8 +683,14 @@ POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 POSTHOOK: query: explain update acid_2L_part set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -756,8 +786,18 @@ POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=12 POSTHOOK: query: explain update acid_2L_part set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -882,9 +922,27 @@ POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 PREHOOK: query: explain delete from acid_2L_part where value = 'bar' PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=12 +PREHOOK: Input: default@acid_2l_part@ds=2008-04-09/hr=11 +PREHOOK: Input: default@acid_2l_part@ds=2008-04-09/hr=12 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-09/hr=11 +PREHOOK: Output: default@acid_2l_part@ds=2008-04-09/hr=12 POSTHOOK: query: explain delete from acid_2L_part where value = 'bar' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@acid_2l_part@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@acid_2l_part@ds=2008-04-09/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1082,8 +1140,14 @@ POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 POSTHOOK: query: explain update acid_2L_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1179,8 +1243,18 @@ POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 POSTHOOK: query: explain update acid_2L_part_sdpo set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1305,9 +1379,27 @@ POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 PREHOOK: query: explain delete from acid_2L_part_sdpo where value = 'bar' PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-09/hr=11 +PREHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-09/hr=12 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-09/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-09/hr=12 POSTHOOK: query: explain delete from acid_2L_part_sdpo where value = 'bar' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@acid_2l_part_sdpo@ds=2008-04-09/hr=12 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo@ds=2008-04-09/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1505,8 +1597,14 @@ POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part_sdpo_no_cp set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 POSTHOOK: query: explain update acid_2L_part_sdpo_no_cp set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1604,8 +1702,18 @@ POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 501 PREHOOK: query: explain update acid_2L_part_sdpo_no_cp set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +PREHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=12 +PREHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +PREHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=12 POSTHOOK: query: explain update acid_2L_part_sdpo_no_cp set value = 'bar' where key = 'foo' and ds='2008-04-08' and hr>=11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@acid_2l_part_sdpo_no_cp@ds=2008-04-08/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/empty_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/empty_join.q.out b/ql/src/test/results/clientpositive/llap/empty_join.q.out index f7fba0b..44fe8a9 100644 --- a/ql/src/test/results/clientpositive/llap/empty_join.q.out +++ b/ql/src/test/results/clientpositive/llap/empty_join.q.out @@ -46,12 +46,20 @@ FROM test_1_n2 t1 LEFT JOIN test_2_n2 t2 ON t1.id = t2.id INNER JOIN test_3_n0 t3 ON t1.id = t3.id PREHOOK: type: QUERY +PREHOOK: Input: default@test_1_n2 +PREHOOK: Input: default@test_2_n2 +PREHOOK: Input: default@test_3_n0 +#### A masked pattern was here #### POSTHOOK: query: explain SELECT t1.id, t2.id, t3.id FROM test_1_n2 t1 LEFT JOIN test_2_n2 t2 ON t1.id = t2.id INNER JOIN test_3_n0 t3 ON t1.id = t3.id POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_1_n2 +POSTHOOK: Input: default@test_2_n2 +POSTHOOK: Input: default@test_3_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out b/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out index 1cfa613..dca0ebd 100644 --- a/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out +++ b/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out @@ -8,8 +8,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@table1_n7 PREHOOK: query: explain INSERT INTO table1_n7 values('not', 'null', 'constraint') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain INSERT INTO table1_n7 values('not', 'null', 'constraint') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -126,8 +130,12 @@ POSTHOOK: Input: default@table1_n7 not null constraint PREHOOK: query: explain insert into table1_n7(a,c) values('1','2') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain insert into table1_n7(a,c) values('1','2') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -235,8 +243,12 @@ POSTHOOK: Lineage: table1_n7.b SIMPLE [] POSTHOOK: Lineage: table1_n7.c SCRIPT [] PREHOOK: query: explain INSERT INTO table1_n7 select key, src.value, value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain INSERT INTO table1_n7 select key, src.value, value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -846,8 +858,12 @@ POSTHOOK: Input: default@table1_n7 not null constraint PREHOOK: query: explain INSERT OVERWRITE TABLE table1_n7 select src.*, value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain INSERT OVERWRITE TABLE table1_n7 select src.*, value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1455,8 +1471,12 @@ POSTHOOK: Input: default@table1_n7 98 val_98 val_98 PREHOOK: query: explain INSERT OVERWRITE TABLE table1_n7 if not exists select src.key, src.key, src.value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain INSERT OVERWRITE TABLE table1_n7 if not exists select src.key, src.key, src.value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2091,11 +2111,17 @@ from src insert overwrite table src_multi1_n0 select * where key < 10 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n0 +PREHOOK: Output: default@src_multi2_n1 POSTHOOK: query: explain from src insert overwrite table src_multi1_n0 select * where key < 10 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n0 +POSTHOOK: Output: default@src_multi2_n1 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2269,11 +2295,17 @@ from src insert into table src_multi1_n0 select * where src.key < 10 insert into table src_multi2_n1 select src.* where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n0 +PREHOOK: Output: default@src_multi2_n1 POSTHOOK: query: explain from src insert into table src_multi1_n0 select * where src.key < 10 insert into table src_multi2_n1 select src.* where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n0 +POSTHOOK: Output: default@src_multi2_n1 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2458,10 +2490,14 @@ PREHOOK: query: explain insert into table acid_uami_n1 values (1, 109.23, 'mary had a little lamb'), (6553, 923.19, 'its fleece was white as snow') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain insert into table acid_uami_n1 values (1, 109.23, 'mary had a little lamb'), (6553, 923.19, 'its fleece was white as snow') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2599,9 +2635,13 @@ POSTHOOK: Input: default@acid_uami_n1 PREHOOK: query: --insert into select explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: --insert into select explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2716,8 +2756,12 @@ POSTHOOK: Lineage: acid_uami_n1.i EXPRESSION [(src)src.FieldSchema(name:key, typ POSTHOOK: Lineage: acid_uami_n1.vc EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2840,9 +2884,13 @@ STAGE PLANS: PREHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src order by key limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src order by key limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2963,9 +3011,13 @@ STAGE PLANS: PREHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src group by key, value order by key limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src group by key, value order by key limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3096,9 +3148,13 @@ STAGE PLANS: PREHOOK: query: --overwrite explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: --overwrite explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3213,8 +3269,12 @@ POSTHOOK: Lineage: acid_uami_n1.i EXPRESSION [(src)src.FieldSchema(name:key, typ POSTHOOK: Lineage: acid_uami_n1.vc EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain update acid_uami_n1 set de = 3.14 where de = 109.23 or de = 119.23 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_uami_n1 +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain update acid_uami_n1 set de = 3.14 where de = 109.23 or de = 119.23 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_uami_n1 +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3307,8 +3367,12 @@ POSTHOOK: Input: default@acid_uami_n1 POSTHOOK: Output: default@acid_uami_n1 PREHOOK: query: explain update acid_uami_n1 set de = 3.14159 where de = 3.14 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_uami_n1 +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain update acid_uami_n1 set de = 3.14159 where de = 3.14 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_uami_n1 +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3392,11 +3456,17 @@ from src insert overwrite table acid_uami_n1 select cast(key as int), cast(key as decimal(5,2)), value where key < 10 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 +PREHOOK: Output: default@src_multi2_n1 POSTHOOK: query: explain from src insert overwrite table acid_uami_n1 select cast(key as int), cast(key as decimal(5,2)), value where key < 10 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 +POSTHOOK: Output: default@src_multi2_n1 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -3574,8 +3644,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@tablePartitioned PREHOOK: query: explain INSERT INTO tablePartitioned partition(p1='today', p2=10) values('not', 'null', 'constraint') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tablepartitioned@p1=today/p2=10 POSTHOOK: query: explain INSERT INTO tablePartitioned partition(p1='today', p2=10) values('not', 'null', 'constraint') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tablepartitioned@p1=today/p2=10 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3694,8 +3768,11 @@ POSTHOOK: Lineage: tablepartitioned PARTITION(p1=today,p2=10).b SCRIPT [] POSTHOOK: Lineage: tablepartitioned PARTITION(p1=today,p2=10).c SCRIPT [] PREHOOK: query: explain INSERT INTO tablePartitioned partition(p1, p2) select key, value, value, key as p1, 3 as p2 from src limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@tablepartitioned POSTHOOK: query: explain INSERT INTO tablePartitioned partition(p1, p2) select key, value, value, key as p1, 3 as p2 from src limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3904,11 +3981,16 @@ from src INSERT INTO tablePartitioned partition(p1, p2) select key, value, value, 'yesterday' as p1, 3 as p2 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi2_n1 +PREHOOK: Output: default@tablepartitioned POSTHOOK: query: explain from src INSERT INTO tablePartitioned partition(p1, p2) select key, value, value, 'yesterday' as p1, 3 as p2 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi2_n1 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -4119,11 +4201,21 @@ WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -4354,11 +4446,23 @@ WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-4 is a root stage Stage-5 depends on stages: Stage-4 @@ -4672,10 +4776,20 @@ PREHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON WHEN MATCHED AND s.key < 5 THEN DELETE WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -4942,10 +5056,20 @@ PREHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -5212,9 +5336,17 @@ STAGE PLANS: PREHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -5431,8 +5563,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@table2_n3 PREHOOK: query: explain insert into table2_n3 values(2, 3) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table2_n3 POSTHOOK: query: explain insert into table2_n3 values(2, 3) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table2_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -5533,8 +5669,12 @@ POSTHOOK: query: alter table table2_n3 drop constraint nn5 POSTHOOK: type: ALTERTABLE_DROPCONSTRAINT PREHOOK: query: explain insert into table2_n3 values(2, 3) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table2_n3 POSTHOOK: query: explain insert into table2_n3 values(2, 3) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table2_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -5644,8 +5784,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@tttemp PREHOOK: query: explain insert into tttemp values(1) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tttemp POSTHOOK: query: explain insert into tttemp values(1) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tttemp STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -5742,8 +5886,12 @@ STAGE PLANS: PREHOOK: query: explain insert into tttemp select cast(key as int) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@tttemp POSTHOOK: query: explain insert into tttemp select cast(key as int) from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@tttemp STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -5848,8 +5996,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@part_mm_n1 PREHOOK: query: explain insert into table part_mm_n1 partition(key_mm=455) select key from src order by value limit 3 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@part_mm_n1@key_mm=455 POSTHOOK: query: explain insert into table part_mm_n1 partition(key_mm=455) select key from src order by value limit 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@part_mm_n1@key_mm=455 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/except_distinct.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/except_distinct.q.out b/ql/src/test/results/clientpositive/llap/except_distinct.q.out index 961a855..ea0224c 100644 --- a/ql/src/test/results/clientpositive/llap/except_distinct.q.out +++ b/ql/src/test/results/clientpositive/llap/except_distinct.q.out @@ -203,8 +203,12 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 2 20 PREHOOK: query: explain select * from src except distinct select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select * from src except distinct select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -365,8 +369,12 @@ POSTHOOK: Input: default@src POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain select * from src except distinct select * from src except distinct select * from src except distinct select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select * from src except distinct select * from src except distinct select * from src except distinct select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -689,8 +697,14 @@ POSTHOOK: Input: default@src POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain select value from a_n16 group by value except distinct select key from b_n12 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@a_n16 +PREHOOK: Input: default@b_n12 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select value from a_n16 group by value except distinct select key from b_n12 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n16 +POSTHOOK: Input: default@b_n12 +POSTHOOK: Output: hdfs://### HDFS PATH ### 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/explainanalyze_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/explainanalyze_2.q.out b/ql/src/test/results/clientpositive/llap/explainanalyze_2.q.out index e40203f..9332e71 100644 --- a/ql/src/test/results/clientpositive/llap/explainanalyze_2.q.out +++ b/ql/src/test/results/clientpositive/llap/explainanalyze_2.q.out @@ -29,6 +29,9 @@ SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN (select * from src1 union select * from src)z ON (x.value = z.value) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain analyze SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -38,6 +41,9 @@ SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN (select * from src1 union select * from src)z ON (x.value = z.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -208,6 +214,9 @@ SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN (select key, value from src1 union select key, value from src union select key, value from src union select key, value from src)z ON (x.value = z.value) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain analyze SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -221,6 +230,9 @@ SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN (select key, value from src1 union select key, value from src union select key, value from src union select key, value from src)z ON (x.value = z.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -598,9 +610,15 @@ POSTHOOK: Input: default@tab_n6@ds=2008-04-08 PREHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -637,9 +655,15 @@ POSTHOOK: Input: default@tab_n6@ds=2008-04-08 PREHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key join tab_n6 s2 on s1.value=s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key join tab_n6 s2 on s1.value=s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -704,9 +728,19 @@ POSTHOOK: Input: default@tab_n6@ds=2008-04-08 PREHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab2_n3 s3 on s1.key=s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab2_n3 +PREHOOK: Input: default@tab2_n3@ds=2008-04-08 +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab2_n3 s3 on s1.key=s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab2_n3 +POSTHOOK: Input: default@tab2_n3@ds=2008-04-08 +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -747,9 +781,19 @@ POSTHOOK: Input: default@tab_n6@ds=2008-04-08 PREHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab2_n3 s3 on s1.key=s3.key join tab2_n3 s2 on s1.value=s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab2_n3 +PREHOOK: Input: default@tab2_n3@ds=2008-04-08 +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab2_n3 s3 on s1.key=s3.key join tab2_n3 s2 on s1.value=s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab2_n3 +POSTHOOK: Input: default@tab2_n3@ds=2008-04-08 +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -823,12 +867,22 @@ UNION ALL select s2.key as key, s2.value as value from tab_n6 s2 ) a_n14 join tab_part_n7 b_n10 on (a_n14.key = b_n10.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n7 +PREHOOK: Input: default@tab_part_n7@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select count(*) from (select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from tab_n6 s2 ) a_n14 join tab_part_n7 b_n10 on (a_n14.key = b_n10.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n7 +POSTHOOK: Input: default@tab_part_n7@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -912,12 +966,22 @@ UNION ALL select s2.key as key, s2.value as value from tab_n6 s2 ) a_n14 join tab_part_n7 b_n10 on (a_n14.key = b_n10.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n7 +PREHOOK: Input: default@tab_part_n7@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select count(*) from (select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key join tab_n6 s2 on s1.value=s2.value UNION ALL select s2.key as key, s2.value as value from tab_n6 s2 ) a_n14 join tab_part_n7 b_n10 on (a_n14.key = b_n10.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n7 +POSTHOOK: Input: default@tab_part_n7@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1085,6 +1149,11 @@ INSERT OVERWRITE TABLE a_n14 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE b_n10 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE c_n3 SELECT tmp.key, tmp.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@a_n14 +PREHOOK: Output: default@b_n10 +PREHOOK: Output: default@c_n3 POSTHOOK: query: explain analyze from ( @@ -1104,6 +1173,11 @@ INSERT OVERWRITE TABLE a_n14 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE b_n10 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE c_n3 SELECT tmp.key, tmp.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@a_n14 +POSTHOOK: Output: default@b_n10 +POSTHOOK: Output: default@c_n3 Plan optimized by CBO. Vertex dependency in root stage @@ -1440,6 +1514,11 @@ INSERT OVERWRITE TABLE a_n14 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE b_n10 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE c_n3 SELECT tmp.key, tmp.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@a_n14 +PREHOOK: Output: default@b_n10 +PREHOOK: Output: default@c_n3 POSTHOOK: query: explain analyze FROM ( @@ -1456,6 +1535,11 @@ INSERT OVERWRITE TABLE a_n14 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE b_n10 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE c_n3 SELECT tmp.key, tmp.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@a_n14 +POSTHOOK: Output: default@b_n10 +POSTHOOK: Output: default@c_n3 Plan optimized by CBO. Vertex dependency in root stage @@ -1796,6 +1880,9 @@ FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n105 +PREHOOK: Output: default@dest2_n29 POSTHOOK: query: explain analyze FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 UNION DISTINCT @@ -1803,6 +1890,9 @@ FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n105 +POSTHOOK: Output: default@dest2_n29 Plan optimized by CBO. Vertex dependency in root stage @@ -1903,8 +1993,24 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 #### A masked pattern was here #### PREHOOK: query: explain analyze FROM UNIQUEJOIN PRESERVE src a_n14 (a_n14.key), PRESERVE src1 b_n10 (b_n10.key), PRESERVE srcpart c_n3 (c_n3.key) SELECT a_n14.key, b_n10.key, c_n3.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +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 analyze FROM UNIQUEJOIN PRESERVE src a_n14 (a_n14.key), PRESERVE src1 b_n10 (b_n10.key), PRESERVE srcpart c_n3 (c_n3.key) SELECT a_n14.key, b_n10.key, c_n3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +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 #### Plan not optimized by CBO due to missing feature [Unique_join]. Vertex dependency in root stage @@ -1979,6 +2085,9 @@ INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR( INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n105 +PREHOOK: Output: default@dest2_n29 POSTHOOK: query: explain analyze FROM ( select key, value from ( @@ -1992,6 +2101,9 @@ INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR( INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n105 +POSTHOOK: Output: default@dest2_n29 Plan optimized by CBO. Vertex dependency in root stage @@ -2119,6 +2231,9 @@ INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR( INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n105 +PREHOOK: Output: default@dest2_n29 POSTHOOK: query: explain analyze FROM ( select 'tst1' as key, cast(count(1) as string) as value, 'tst1' as value2 from src s1 @@ -2129,6 +2244,9 @@ INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR( INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n105 +POSTHOOK: Output: default@dest2_n29 Plan optimized by CBO. Vertex dependency in root stage
