Repository: hive Updated Branches: refs/heads/master 24a98ea24 -> f37fef06f
http://git-wip-us.apache.org/repos/asf/hive/blob/2842f88e/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out index c253fd2..f32397a 100644 --- a/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out +++ b/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out @@ -22,20 +22,20 @@ Stage-0 Stage-1 Union 2 <-Map 1 [CONTAINS] - File Output Operator [FS_7] - Limit [LIM_6] (rows=10/20 width=178) + File Output Operator [FS_12] + Limit [LIM_11] (rows=10/10 width=178) Number of rows:10 - Select Operator [SEL_1] (rows=500/12 width=178) + Select Operator [SEL_9] (rows=500/12 width=178) Output:["_col0","_col1"] - TableScan [TS_0] (rows=500/13 width=178) + TableScan [TS_8] (rows=500/13 width=178) Output:["key","value"] <-Map 3 [CONTAINS] - File Output Operator [FS_7] - Limit [LIM_6] (rows=10/20 width=178) + File Output Operator [FS_17] + Limit [LIM_16] (rows=10/10 width=178) Number of rows:10 - Select Operator [SEL_3] (rows=500/12 width=178) + Select Operator [SEL_14] (rows=500/12 width=178) Output:["_col0","_col1"] - TableScan [TS_2] (rows=500/13 width=178) + TableScan [TS_13] (rows=500/13 width=178) Output:["key","value"] PREHOOK: query: select key from src @@ -132,8 +132,8 @@ Stage-3 Dependency Collection{} Stage-1 Reducer 2 - File Output Operator [FS_5] - Group By Operator [GBY_3] (rows=1/1 width=440) + File Output Operator [FS_8] + Group By Operator [GBY_6] (rows=1/1 width=440) Output:["_col0"],aggregations:["compute_stats(VALUE._col0, 'hll')"] <-Map 1 [CUSTOM_SIMPLE_EDGE] File Output Operator [FS_2] @@ -142,8 +142,8 @@ Stage-3 Output:["_col0"] TableScan [TS_0] (rows=500/500 width=87) default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key"] - PARTITION_ONLY_SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=500/500 width=87) + PARTITION_ONLY_SHUFFLE [RS_5] + Select Operator [SEL_4] (rows=500/500 width=87) Output:["key"] Please refer to the previous Select Operator [SEL_1] @@ -401,16 +401,16 @@ Stage-0 Stage-1 Union 2 <-Map 1 [CONTAINS] - File Output Operator [FS_6] - Select Operator [SEL_1] (rows=500/500 width=178) + File Output Operator [FS_10] + Select Operator [SEL_8] (rows=500/500 width=178) Output:["_col0","_col1"] - TableScan [TS_0] (rows=500/500 width=178) + TableScan [TS_7] (rows=500/500 width=178) Output:["key","value"] <-Map 3 [CONTAINS] - File Output Operator [FS_6] - Select Operator [SEL_3] (rows=500/500 width=178) + File Output Operator [FS_14] + Select Operator [SEL_12] (rows=500/500 width=178) Output:["_col0","_col1"] - TableScan [TS_2] (rows=500/500 width=178) + TableScan [TS_11] (rows=500/500 width=178) Output:["key","value"] PREHOOK: query: select count(*) from (select * from src a union all select * from src b)subq http://git-wip-us.apache.org/repos/asf/hive/blob/2842f88e/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out index 42bad01..a6eb4e5 100644 --- a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out +++ b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out @@ -669,22 +669,22 @@ Stage-3 Conditional Operator Stage-1 Reducer 2 - File Output Operator [FS_5] - Group By Operator [GBY_3] (rows=1/1 width=2760) + File Output Operator [FS_9] + Group By Operator [GBY_7] (rows=1/1 width=2760) Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["compute_stats(VALUE._col0, 'hll')","compute_stats(VALUE._col2, 'hll')","compute_stats(VALUE._col3, 'hll')","compute_stats(VALUE._col4, 'hll')","compute_stats(VALUE._col5, 'hll')"] <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized - File Output Operator [FS_8] + File Output Operator [FS_14] table:{"name:":"default.orc_merge5_n1"} - Select Operator [SEL_7] (rows=1/3 width=352) + Select Operator [SEL_13] (rows=1/3 width=352) Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_6] (rows=1/3 width=352) + Filter Operator [FIL_12] (rows=1/3 width=352) predicate:(userid <= 13L) TableScan [TS_0] (rows=1/15000 width=352) default@orc_merge5_n1,orc_merge5_n1,Tbl:COMPLETE,Col:NONE,Output:["userid","string1","subtype","decimal1","ts"] - PARTITION_ONLY_SHUFFLE [RS_7] - Select Operator [SEL_6] (rows=1/3 width=352) + PARTITION_ONLY_SHUFFLE [RS_16] + Select Operator [SEL_15] (rows=1/3 width=352) Output:["userid","string1","subtype","decimal1","ts"] - Please refer to the previous Select Operator [SEL_7] + Please refer to the previous Select Operator [SEL_13] Stage-4(CONDITIONAL) File Merge Please refer to the previous Stage-8(CONDITIONAL CHILD TASKS: Stage-5, Stage-4, Stage-6) http://git-wip-us.apache.org/repos/asf/hive/blob/2842f88e/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out index 75f29fa..7df06ba 100644 --- a/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out +++ b/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out @@ -108,22 +108,22 @@ Stage-3 Dependency Collection{} Stage-1 Reducer 5 - File Output Operator [FS_5] - Group By Operator [GBY_3] (rows=1/1 width=880) + File Output Operator [FS_25] + Group By Operator [GBY_23] (rows=1/1 width=880) Output:["_col0","_col1"],aggregations:["compute_stats(VALUE._col0, 'hll')","compute_stats(VALUE._col2, 'hll')"] <-Reducer 4 [CUSTOM_SIMPLE_EDGE] File Output Operator [FS_19] table:{"name:":"default.src_multi2_n7"} Select Operator [SEL_18] (rows=830/508 width=178) Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_26] (rows=830/508 width=178) + Merge Join Operator [MERGEJOIN_32] (rows=830/508 width=178) Conds:RS_15._col0=RS_16._col0(Inner),Output:["_col0","_col3"] <-Map 7 [SIMPLE_EDGE] SHUFFLE [RS_16] PartitionCols:_col0 Select Operator [SEL_14] (rows=500/500 width=178) Output:["_col0","_col1"] - Filter Operator [FIL_25] (rows=500/500 width=178) + Filter Operator [FIL_31] (rows=500/500 width=178) predicate:key is not null TableScan [TS_12] (rows=500/500 width=178) default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"] @@ -136,25 +136,25 @@ Stage-3 Output:["_col0","_col1"],keys:KEY._col0, KEY._col1 <-Union 2 [SIMPLE_EDGE] <-Map 1 [CONTAINS] - Reduce Output Operator [RS_9] + Reduce Output Operator [RS_37] PartitionCols:_col0, _col1 - Select Operator [SEL_2] (rows=500/500 width=178) + Select Operator [SEL_35] (rows=500/500 width=178) Output:["_col0","_col1"] - Filter Operator [FIL_23] (rows=500/500 width=178) + Filter Operator [FIL_34] (rows=500/500 width=178) predicate:key is not null - TableScan [TS_0] (rows=500/500 width=178) + TableScan [TS_33] (rows=500/500 width=178) Output:["key","value"] <-Map 6 [CONTAINS] - Reduce Output Operator [RS_9] + Reduce Output Operator [RS_42] PartitionCols:_col0, _col1 - Select Operator [SEL_5] (rows=25/25 width=175) + Select Operator [SEL_40] (rows=25/25 width=175) Output:["_col0","_col1"] - Filter Operator [FIL_24] (rows=25/25 width=175) + Filter Operator [FIL_39] (rows=25/25 width=175) predicate:key is not null - TableScan [TS_3] (rows=25/25 width=175) + TableScan [TS_38] (rows=25/25 width=175) Output:["key","value"] - PARTITION_ONLY_SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=830/508 width=178) + PARTITION_ONLY_SHUFFLE [RS_22] + Select Operator [SEL_21] (rows=830/508 width=178) Output:["key","value"] Please refer to the previous Select Operator [SEL_18] http://git-wip-us.apache.org/repos/asf/hive/blob/2842f88e/ql/src/test/results/clientpositive/tez/explainuser_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out index d993905..4196b31 100644 --- a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out +++ b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out @@ -511,22 +511,22 @@ Stage-3 Conditional Operator Stage-1 Reducer 2 - File Output Operator [FS_6] - Group By Operator [GBY_4] (rows=1 width=2760) + File Output Operator [FS_10] + Group By Operator [GBY_8] (rows=1 width=2760) Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["compute_stats(VALUE._col0)","compute_stats(VALUE._col1)","compute_stats(VALUE._col2)","compute_stats(VALUE._col3)","compute_stats(VALUE._col4)"] <-Map 1 [CUSTOM_SIMPLE_EDGE] File Output Operator [FS_3] table:{"name:":"default.orc_merge5_n0"} Select Operator [SEL_2] (rows=1 width=352) Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_4] (rows=1 width=352) + Filter Operator [FIL_11] (rows=1 width=352) predicate:(userid <= 13L) TableScan [TS_0] (rows=1 width=352) default@orc_merge5_n0,orc_merge5_n0,Tbl:COMPLETE,Col:NONE,Output:["userid","string1","subtype","decimal1","ts"] - PARTITION_ONLY_SHUFFLE [RS_3] - Group By Operator [GBY_2] (rows=1 width=2696) + PARTITION_ONLY_SHUFFLE [RS_7] + Group By Operator [GBY_6] (rows=1 width=2696) Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["compute_stats(userid, 'hll')","compute_stats(string1, 'hll')","compute_stats(subtype, 'hll')","compute_stats(decimal1, 'hll')","compute_stats(ts, 'hll')"] - Select Operator [SEL_1] (rows=1 width=352) + Select Operator [SEL_5] (rows=1 width=352) Output:["userid","string1","subtype","decimal1","ts"] Please refer to the previous Select Operator [SEL_2] Stage-4(CONDITIONAL) http://git-wip-us.apache.org/repos/asf/hive/blob/2842f88e/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out b/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out index 01c5096..4be1272 100644 --- a/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out +++ b/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out @@ -1,4 +1,4 @@ -Warning: Map Join MAPJOIN[34][bigTable=?] in task 'Stage-8:MAPRED' is a cross product +Warning: Map Join MAPJOIN[42][bigTable=?] in task 'Stage-8:MAPRED' is a cross product PREHOOK: query: explain vectorization expression select * from src @@ -389,7 +389,7 @@ STAGE PLANS: Processor Tree: ListSink -Warning: Map Join MAPJOIN[34][bigTable=?] in task 'Stage-8:MAPRED' is a cross product +Warning: Map Join MAPJOIN[42][bigTable=?] in task 'Stage-8:MAPRED' is a cross product PREHOOK: query: select * from src where not key in @@ -418,7 +418,7 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@orcsrc POSTHOOK: Lineage: orcsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: orcsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -Warning: Map Join MAPJOIN[34][bigTable=?] in task 'Stage-8:MAPRED' is a cross product +Warning: Map Join MAPJOIN[42][bigTable=?] in task 'Stage-8:MAPRED' is a cross product PREHOOK: query: select * from orcsrc where not key in @@ -435,7 +435,7 @@ order by key POSTHOOK: type: QUERY POSTHOOK: Input: default@orcsrc #### A masked pattern was here #### -Warning: Map Join MAPJOIN[34][bigTable=?] in task 'Stage-8:MAPRED' is a cross product +Warning: Map Join MAPJOIN[42][bigTable=?] in task 'Stage-8:MAPRED' is a cross product PREHOOK: query: select * from orcsrc where not key in