Repository: hive Updated Branches: refs/heads/master 91d0c8347 -> de7810a4e
http://git-wip-us.apache.org/repos/asf/hive/blob/de7810a4/ql/src/test/results/clientpositive/tez/windowing_gby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/windowing_gby.q.out b/ql/src/test/results/clientpositive/tez/windowing_gby.q.out index e65533f..72d1f14 100644 --- a/ql/src/test/results/clientpositive/tez/windowing_gby.q.out +++ b/ql/src/test/results/clientpositive/tez/windowing_gby.q.out @@ -10,7 +10,7 @@ POSTHOOK: query: explain from cbo_t3 ws join alltypesorc wr on ws.value = wr.cstring1 group by ws.c_boolean ) in_web POSTHOOK: type: QUERY -Plan not optimized by CBO. +Plan optimized by CBO. Vertex dependency in root stage Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 5 (SIMPLE_EDGE) @@ -22,77 +22,84 @@ Stage-0 limit:-1 Stage-1 Reducer 4 - File Output Operator [FS_17] + File Output Operator [FS_19] compressed:false Statistics:Num rows: 6758 Data size: 1453080 Basic stats: COMPLETE Column stats: NONE table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"} - Select Operator [SEL_15] + Select Operator [SEL_17] outputColumnNames:["_col0"] Statistics:Num rows: 6758 Data size: 1453080 Basic stats: COMPLETE Column stats: NONE - PTF Operator [PTF_14] - Function definitions:[{"Input definition":{"type:":"WINDOWING"}},{"name:":"windowingtablefunction","order by:":"_col0","partition by:":"0"}] + PTF Operator [PTF_16] + Function definitions:[{"Input definition":{"type:":"WINDOWING"}},{"name:":"windowingtablefunction","order by:":"(UDFToDouble(_col1) / UDFToDouble(_col2))","partition by:":"0"}] Statistics:Num rows: 6758 Data size: 1453080 Basic stats: COMPLETE Column stats: NONE - Select Operator [SEL_13] - | outputColumnNames:["_col0"] + Select Operator [SEL_15] + | outputColumnNames:["_col1","_col2"] | Statistics:Num rows: 6758 Data size: 1453080 Basic stats: COMPLETE Column stats: NONE |<-Reducer 3 [SIMPLE_EDGE] - Reduce Output Operator [RS_12] - key expressions:0 (type: int), _col0 (type: double) + Reduce Output Operator [RS_14] + key expressions:0 (type: int), (UDFToDouble(_col1) / UDFToDouble(_col2)) (type: double) Map-reduce partition columns:0 (type: int) sort order:++ Statistics:Num rows: 6758 Data size: 1453080 Basic stats: COMPLETE Column stats: NONE - Select Operator [SEL_11] - outputColumnNames:["_col0"] + value expressions:_col1 (type: bigint), _col2 (type: bigint) + Select Operator [SEL_13] + outputColumnNames:["_col1","_col2"] Statistics:Num rows: 6758 Data size: 1453080 Basic stats: COMPLETE Column stats: NONE - Group By Operator [GBY_10] + Group By Operator [GBY_12] | aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"] | keys:KEY._col0 (type: boolean) | outputColumnNames:["_col0","_col1","_col2"] | Statistics:Num rows: 6758 Data size: 1453080 Basic stats: COMPLETE Column stats: NONE |<-Reducer 2 [SIMPLE_EDGE] - Reduce Output Operator [RS_9] + Reduce Output Operator [RS_11] key expressions:_col0 (type: boolean) Map-reduce partition columns:_col0 (type: boolean) sort order:+ Statistics:Num rows: 13516 Data size: 2906160 Basic stats: COMPLETE Column stats: NONE value expressions:_col1 (type: bigint), _col2 (type: bigint) - Group By Operator [GBY_8] - aggregations:["sum(_col10)","sum(_col2)"] - keys:_col4 (type: boolean) + Group By Operator [GBY_10] + aggregations:["sum(_col3)","sum(_col1)"] + keys:_col2 (type: boolean) outputColumnNames:["_col0","_col1","_col2"] Statistics:Num rows: 13516 Data size: 2906160 Basic stats: COMPLETE Column stats: NONE - Select Operator [SEL_7] - outputColumnNames:["_col4","_col10","_col2"] + Select Operator [SEL_9] + outputColumnNames:["_col2","_col3","_col1"] Statistics:Num rows: 13516 Data size: 2906160 Basic stats: COMPLETE Column stats: NONE - Merge Join Operator [MERGEJOIN_22] + Merge Join Operator [MERGEJOIN_24] | condition map:[{"":"Inner Join 0 to 1"}] - | keys:{"0":"value (type: string)","1":"cstring1 (type: string)"} - | outputColumnNames:["_col2","_col4","_col10"] + | keys:{"0":"_col0 (type: string)","1":"_col1 (type: string)"} + | outputColumnNames:["_col1","_col2","_col3"] | Statistics:Num rows: 13516 Data size: 2906160 Basic stats: COMPLETE Column stats: NONE |<-Map 1 [SIMPLE_EDGE] - | Reduce Output Operator [RS_3] - | key expressions:value (type: string) - | Map-reduce partition columns:value (type: string) + | Reduce Output Operator [RS_6] + | key expressions:_col0 (type: string) + | Map-reduce partition columns:_col0 (type: string) | sort order:+ | Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE - | value expressions:c_int (type: int), c_boolean (type: boolean) - | Filter Operator [FIL_20] - | predicate:value is not null (type: boolean) + | value expressions:_col1 (type: int), _col2 (type: boolean) + | Select Operator [SEL_2] + | outputColumnNames:["_col0","_col1","_col2"] | Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE - | TableScan [TS_0] - | alias:ws + | Filter Operator [FIL_22] + | predicate:value is not null (type: boolean) | Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE + | TableScan [TS_0] + | alias:ws + | Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: NONE |<-Map 5 [SIMPLE_EDGE] - Reduce Output Operator [RS_5] - key expressions:cstring1 (type: string) - Map-reduce partition columns:cstring1 (type: string) + Reduce Output Operator [RS_7] + key expressions:_col1 (type: string) + Map-reduce partition columns:_col1 (type: string) sort order:+ Statistics:Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE - value expressions:cint (type: int) - Filter Operator [FIL_21] - predicate:cstring1 is not null (type: boolean) + value expressions:_col0 (type: int) + Select Operator [SEL_5] + outputColumnNames:["_col0","_col1"] Statistics:Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE - TableScan [TS_1] - alias:wr + Filter Operator [FIL_23] + predicate:cstring1 is not null (type: boolean) Statistics:Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE + TableScan [TS_3] + alias:wr + Statistics:Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE
