You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2015/05/23 20:48:46 UTC
[13/48] hive git commit: HIVE-8769 : Physical optimizer : Incorrect
CE results in a shuffle join instead of a Map join (PK/FK pattern not
detected) (Pengcheng Xiong via Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/d823fc80/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
index b684858..dadcec1 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
@@ -237,10 +237,10 @@ Stage-0
outputColumnNames:["_col0"]
Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Select Operator [SEL_2]
- Statistics:Num rows: 0 Data size: 2527 Basic stats: PARTIAL Column stats: NONE
+ Statistics:Num rows: 1 Data size: 2527 Basic stats: PARTIAL Column stats: NONE
TableScan [TS_0]
alias:src_orc_merge_test_part
- Statistics:Num rows: 0 Data size: 2527 Basic stats: PARTIAL Column stats: NONE
+ Statistics:Num rows: 1 Data size: 2527 Basic stats: PARTIAL Column stats: NONE
PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31'
PREHOOK: type: QUERY
POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31'
@@ -504,45 +504,45 @@ Stage-0
Reducer 4
File Output Operator [FS_47]
compressed:false
- Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Select Operator [SEL_46]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 3 [SIMPLE_EDGE]
Reduce Output Operator [RS_45]
key expressions:(UDFToLong(_col0) + _col1) (type: bigint), _col1 (type: bigint)
sort order:-+
- Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col0 (type: int), _col2 (type: bigint)
Group By Operator [GBY_43]
| aggregations:["count(VALUE._col0)"]
| keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 2 [SIMPLE_EDGE]
Reduce Output Operator [RS_42]
key expressions:_col0 (type: int), _col1 (type: bigint)
Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
sort order:++
- Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col2 (type: bigint)
Group By Operator [GBY_41]
aggregations:["count()"]
keys:_col0 (type: int), _col1 (type: bigint)
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_37]
outputColumnNames:["_col0","_col1"]
- Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_53]
predicate:((_col3 > 0) or (_col1 >= 0)) (type: boolean)
- Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_59]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col3","_col4"]
- | Statistics:Num rows: 19 Data size: 1566 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 3 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_33]
| key expressions:_col0 (type: string)
@@ -564,14 +564,14 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: bigint)
Select Operator [SEL_29]
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_55]
predicate:((_col3 + _col1) >= 0) (type: boolean)
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_58]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
@@ -689,45 +689,45 @@ Stage-0
Reducer 6
File Output Operator [FS_42]
compressed:false
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Select Operator [SEL_41]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 5 [SIMPLE_EDGE]
Reduce Output Operator [RS_40]
key expressions:(UDFToLong(_col0) % _col1) (type: bigint), _col0 (type: int)
sort order:+-
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: bigint), _col2 (type: bigint)
Group By Operator [GBY_38]
| aggregations:["count(VALUE._col0)"]
| keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 4 [SIMPLE_EDGE]
Reduce Output Operator [RS_37]
key expressions:_col0 (type: int), _col1 (type: bigint)
Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
sort order:++
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col2 (type: bigint)
Group By Operator [GBY_36]
aggregations:["count()"]
keys:_col0 (type: int), _col1 (type: bigint)
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_34]
outputColumnNames:["_col0","_col1"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_33]
predicate:(((_col1 > 0) or (_col6 >= 0)) and (((_col6 >= 1) or (_col2 >= 1)) and ((UDFToLong(_col6) + _col2) >= 0))) (type: boolean)
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_52]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2","_col6"]
- | Statistics:Num rows: 5 Data size: 391 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 10 [SIMPLE_EDGE]
| Reduce Output Operator [RS_31]
| key expressions:_col0 (type: string)
@@ -749,49 +749,49 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: bigint)
Select Operator [SEL_22]
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_47]
predicate:((_col3 + _col1) >= 0) (type: boolean)
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_51]
| condition map:[{"":"Right Outer Join0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2","_col3","_col4"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 2 [SIMPLE_EDGE]
| Reduce Output Operator [RS_19]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
| value expressions:_col1 (type: int)
| Select Operator [SEL_7]
| outputColumnNames:["_col0","_col1"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_6]
| | keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
| | outputColumnNames:["_col0","_col1","_col2"]
- | | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| |<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_5]
| key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| sort order:+++
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_4]
| keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Select Operator [SEL_2]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Filter Operator [FIL_48]
| predicate:(((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is not null) (type: boolean)
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| TableScan [TS_0]
| alias:cbo_t2
| Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -800,43 +800,43 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: bigint)
Select Operator [SEL_17]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 8 [SIMPLE_EDGE]
Reduce Output Operator [RS_16]
key expressions:_col3 (type: bigint), _col1 (type: int)
sort order:+-
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col0 (type: string), _col2 (type: bigint)
Select Operator [SEL_15]
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator [GBY_14]
| aggregations:["sum(VALUE._col0)"]
| keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 7 [SIMPLE_EDGE]
Reduce Output Operator [RS_13]
key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
sort order:+++
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col3 (type: bigint)
Group By Operator [GBY_12]
aggregations:["sum(_col1)"]
keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_10]
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_49]
predicate:(((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is not null) (type: boolean)
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
TableScan [TS_8]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -861,36 +861,36 @@ Stage-0
Reducer 5
File Output Operator [FS_35]
compressed:false
- Statistics:Num rows: 2 Data size: 160 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Group By Operator [GBY_33]
| aggregations:["count(VALUE._col0)"]
| keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 2 Data size: 160 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 4 [SIMPLE_EDGE]
Reduce Output Operator [RS_32]
key expressions:_col0 (type: int), _col1 (type: bigint)
Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
sort order:++
- Statistics:Num rows: 4 Data size: 320 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col2 (type: bigint)
Group By Operator [GBY_31]
aggregations:["count()"]
keys:_col0 (type: int), _col1 (type: bigint)
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 4 Data size: 320 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_29]
outputColumnNames:["_col0","_col1"]
- Statistics:Num rows: 4 Data size: 320 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_39]
predicate:(((_col1 + _col4) >= 2) and ((_col1 > 0) or (_col6 >= 0))) (type: boolean)
- Statistics:Num rows: 4 Data size: 320 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_44]
| condition map:[{"":"Right Outer Join0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2","_col4","_col6"]
- | Statistics:Num rows: 22 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 4 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 9 [SIMPLE_EDGE]
| Reduce Output Operator [RS_26]
| key expressions:_col0 (type: string)
@@ -909,46 +909,46 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: bigint), _col4 (type: int)
Select Operator [SEL_22]
outputColumnNames:["_col0","_col1","_col2","_col4"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_43]
| condition map:[{"":"Left Outer Join0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2","_col3","_col4"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 2 [SIMPLE_EDGE]
| Reduce Output Operator [RS_19]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
| value expressions:_col1 (type: int)
| Select Operator [SEL_7]
| outputColumnNames:["_col0","_col1"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_6]
| | keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
| | outputColumnNames:["_col0","_col1","_col2"]
- | | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| |<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_5]
| key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| sort order:+++
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_4]
| keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Select Operator [SEL_2]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Filter Operator [FIL_41]
| predicate:((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| TableScan [TS_0]
| alias:cbo_t2
| Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -957,43 +957,43 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: bigint)
Select Operator [SEL_17]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 7 [SIMPLE_EDGE]
Reduce Output Operator [RS_16]
key expressions:_col3 (type: bigint), _col0 (type: string)
sort order:+-
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: bigint)
Select Operator [SEL_15]
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator [GBY_14]
| aggregations:["sum(VALUE._col0)"]
| keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 6 [SIMPLE_EDGE]
Reduce Output Operator [RS_13]
key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
sort order:+++
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col3 (type: bigint)
Group By Operator [GBY_12]
aggregations:["sum(_col1)"]
keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_10]
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_42]
predicate:((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
TableScan [TS_8]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1020,45 +1020,45 @@ Stage-0
Reducer 7
File Output Operator [FS_41]
compressed:false
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Select Operator [SEL_40]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 6 [SIMPLE_EDGE]
Reduce Output Operator [RS_39]
key expressions:_col0 (type: int)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: bigint), _col2 (type: bigint)
Group By Operator [GBY_37]
| aggregations:["count(VALUE._col0)"]
| keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 5 [SIMPLE_EDGE]
Reduce Output Operator [RS_36]
key expressions:_col0 (type: int), _col1 (type: bigint)
Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
sort order:++
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col2 (type: bigint)
Group By Operator [GBY_35]
aggregations:["count()"]
keys:_col0 (type: int), _col1 (type: bigint)
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_33]
outputColumnNames:["_col0","_col1"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_44]
predicate:(((((_col1 + _col4) >= 0) and ((_col1 > 0) or (_col6 >= 0))) and ((_col6 >= 1) or (_col2 >= 1))) and ((UDFToLong(_col6) + _col2) >= 0)) (type: boolean)
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_50]
| condition map:[{"":"Right Outer Join0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2","_col4","_col6"]
- | Statistics:Num rows: 6 Data size: 489 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 3 Data size: 60 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 11 [SIMPLE_EDGE]
| Reduce Output Operator [RS_30]
| key expressions:_col0 (type: string)
@@ -1080,58 +1080,58 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: bigint), _col4 (type: int)
Select Operator [SEL_25]
outputColumnNames:["_col0","_col1","_col2","_col4"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_49]
| condition map:[{"":"Outer Join 0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2","_col3","_col4"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 10 [SIMPLE_EDGE]
| Reduce Output Operator [RS_23]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
| value expressions:_col1 (type: int), _col2 (type: bigint)
| Select Operator [SEL_20]
| | outputColumnNames:["_col0","_col1","_col2"]
- | | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | | Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
| |<-Reducer 9 [SIMPLE_EDGE]
| Reduce Output Operator [RS_19]
| key expressions:_col3 (type: double)
| sort order:-
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
| value expressions:_col0 (type: string), _col1 (type: int), _col2 (type: bigint)
| Select Operator [SEL_18]
| outputColumnNames:["_col0","_col1","_col2","_col3"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_17]
| | aggregations:["sum(VALUE._col0)"]
| | keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
| | outputColumnNames:["_col0","_col1","_col2","_col3"]
- | | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
| |<-Map 8 [SIMPLE_EDGE]
| Reduce Output Operator [RS_16]
| key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| sort order:+++
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
| value expressions:_col3 (type: bigint)
| Group By Operator [GBY_15]
| aggregations:["sum(_col1)"]
| keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
| Select Operator [SEL_13]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Filter Operator [FIL_47]
| predicate:((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| TableScan [TS_11]
| alias:cbo_t1
| Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1140,43 +1140,43 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int)
Select Operator [SEL_9]
| outputColumnNames:["_col0","_col1"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 2 [SIMPLE_EDGE]
Reduce Output Operator [RS_8]
key expressions:_col3 (type: double), _col2 (type: bigint)
sort order:-+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col0 (type: string), _col1 (type: int)
Select Operator [SEL_7]
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator [GBY_6]
| aggregations:["sum(VALUE._col0)"]
| keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 1 [SIMPLE_EDGE]
Reduce Output Operator [RS_5]
key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
sort order:+++
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col3 (type: bigint)
Group By Operator [GBY_4]
aggregations:["sum(_col1)"]
keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_2]
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_46]
predicate:((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
TableScan [TS_0]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1200,36 +1200,36 @@ Stage-0
Reducer 3
File Output Operator [FS_39]
compressed:false
- Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Group By Operator [GBY_37]
| aggregations:["count(VALUE._col0)"]
| keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 2 [SIMPLE_EDGE]
Reduce Output Operator [RS_36]
key expressions:_col0 (type: int), _col1 (type: bigint)
Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
sort order:++
- Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col2 (type: bigint)
Group By Operator [GBY_35]
aggregations:["count()"]
keys:_col0 (type: int), _col1 (type: bigint)
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_31]
outputColumnNames:["_col0","_col1"]
- Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_45]
predicate:((_col3 > 0) or (_col1 >= 0)) (type: boolean)
- Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_51]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col3","_col4"]
- | Statistics:Num rows: 19 Data size: 1566 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 3 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_27]
| key expressions:_col0 (type: string)
@@ -1251,49 +1251,49 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: bigint)
Select Operator [SEL_23]
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_47]
predicate:((_col3 + _col1) >= 0) (type: boolean)
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_50]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2","_col3","_col4"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 5 [SIMPLE_EDGE]
| Reduce Output Operator [RS_19]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
| value expressions:_col1 (type: int)
| Select Operator [SEL_9]
| outputColumnNames:["_col0","_col1"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_8]
| | keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
| | outputColumnNames:["_col0","_col1","_col2"]
- | | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| |<-Map 4 [SIMPLE_EDGE]
| Reduce Output Operator [RS_7]
| key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| sort order:+++
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_6]
| keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Select Operator [SEL_4]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| Filter Operator [FIL_48]
| predicate:(((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is not null) (type: boolean)
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
| TableScan [TS_2]
| alias:cbo_t2
| Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1302,34 +1302,34 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: bigint)
Select Operator [SEL_17]
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator [GBY_16]
| aggregations:["sum(VALUE._col0)"]
| keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
- | Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 7 [SIMPLE_EDGE]
Reduce Output Operator [RS_15]
key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
sort order:+++
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col3 (type: bigint)
Group By Operator [GBY_14]
aggregations:["sum(_col1)"]
keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_12]
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_49]
predicate:(((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is not null) (type: boolean)
- Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
TableScan [TS_10]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1399,21 +1399,24 @@ Stage-0
Reducer 4
File Output Operator [FS_29]
compressed:false
- Statistics:Num rows: 3 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Select Operator [SEL_28]
| outputColumnNames:["_col0"]
- | Statistics:Num rows: 3 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ | Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
|<-Union 3 [SIMPLE_EDGE]
|<-Reducer 2 [CONTAINS]
| Reduce Output Operator [RS_27]
| key expressions:_col0 (type: string)
| sort order:+
+ | Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
| Select Operator [SEL_6]
| outputColumnNames:["_col0"]
+ | Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_5]
| | aggregations:["count(VALUE._col0)"]
| | outputColumnNames:["_col0"]
+ | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
| |<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_4]
| sort order:
@@ -1433,11 +1436,14 @@ Stage-0
| Reduce Output Operator [RS_27]
| key expressions:_col0 (type: string)
| sort order:+
+ | Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
| Select Operator [SEL_14]
| outputColumnNames:["_col0"]
+ | Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_13]
| | aggregations:["count(VALUE._col0)"]
| | outputColumnNames:["_col0"]
+ | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
| |<-Map 5 [SIMPLE_EDGE]
| Reduce Output Operator [RS_12]
| sort order:
@@ -1457,11 +1463,14 @@ Stage-0
Reduce Output Operator [RS_27]
key expressions:_col0 (type: string)
sort order:+
+ Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_24]
outputColumnNames:["_col0"]
+ Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator [GBY_23]
| aggregations:["count(VALUE._col0)"]
| outputColumnNames:["_col0"]
+ | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 7 [SIMPLE_EDGE]
Reduce Output Operator [RS_22]
sort order:
@@ -1505,38 +1514,42 @@ Stage-0
Reducer 5
File Output Operator [FS_34]
compressed:false
- Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Select Operator [SEL_33]
| outputColumnNames:["_col0","_col1"]
- | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 4 [SIMPLE_EDGE]
Reduce Output Operator [RS_32]
key expressions:_col0 (type: string)
sort order:+
- Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: bigint)
Group By Operator [GBY_30]
| aggregations:["count(VALUE._col0)"]
| keys:KEY._col0 (type: string)
| outputColumnNames:["_col0","_col1"]
- | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
+ | Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
|<-Union 3 [SIMPLE_EDGE]
|<-Reducer 2 [CONTAINS]
| Reduce Output Operator [RS_29]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
+ | Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
| value expressions:_col1 (type: bigint)
| Group By Operator [GBY_28]
| aggregations:["count(1)"]
| keys:_col0 (type: string)
| outputColumnNames:["_col0","_col1"]
+ | Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
| Select Operator [SEL_6]
| outputColumnNames:["_col0"]
+ | Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_5]
| | aggregations:["count(VALUE._col0)"]
| | outputColumnNames:["_col0"]
+ | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
| |<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_4]
| sort order:
@@ -1557,16 +1570,20 @@ Stage-0
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
+ | Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
| value expressions:_col1 (type: bigint)
| Group By Operator [GBY_28]
| aggregations:["count(1)"]
| keys:_col0 (type: string)
| outputColumnNames:["_col0","_col1"]
+ | Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
| Select Operator [SEL_14]
| outputColumnNames:["_col0"]
+ | Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
| Group By Operator [GBY_13]
| | aggregations:["count(VALUE._col0)"]
| | outputColumnNames:["_col0"]
+ | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
| |<-Map 6 [SIMPLE_EDGE]
| Reduce Output Operator [RS_12]
| sort order:
@@ -1587,16 +1604,20 @@ Stage-0
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
+ Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: bigint)
Group By Operator [GBY_28]
aggregations:["count(1)"]
keys:_col0 (type: string)
outputColumnNames:["_col0","_col1"]
+ Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_24]
outputColumnNames:["_col0"]
+ Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator [GBY_23]
| aggregations:["count(VALUE._col0)"]
| outputColumnNames:["_col0"]
+ | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 8 [SIMPLE_EDGE]
Reduce Output Operator [RS_22]
sort order:
@@ -1933,19 +1954,19 @@ Stage-0
Reducer 3
File Output Operator [FS_20]
compressed:false
- Statistics:Num rows: 8 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics:Num rows: 8 Data size: 808 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Select Operator [SEL_19]
outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
- Statistics:Num rows: 8 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics:Num rows: 8 Data size: 808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_18]
predicate:((_col1 > 0) or (_col6 >= 0)) (type: boolean)
- Statistics:Num rows: 8 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics:Num rows: 8 Data size: 808 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_29]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2","_col3","_col4","_col6"]
- | Statistics:Num rows: 14 Data size: 168 Basic stats: COMPLETE Column stats: COMPLETE
+ | Statistics:Num rows: 14 Data size: 1414 Basic stats: COMPLETE Column stats: COMPLETE
|<-Map 5 [SIMPLE_EDGE]
| Reduce Output Operator [RS_16]
| key expressions:_col0 (type: string)
@@ -2292,26 +2313,26 @@ Stage-0
Reducer 4
File Output Operator [FS_13]
compressed:false
- Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Limit [LIM_12]
Number of rows:5
- Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_11]
| outputColumnNames:["_col0","_col1"]
- | Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ | Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 3 [SIMPLE_EDGE]
Reduce Output Operator [RS_10]
key expressions:_col1 (type: int)
sort order:+
- Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col0 (type: string)
Limit [LIM_8]
Number of rows:5
- Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_7]
| outputColumnNames:["_col0","_col1"]
- | Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ | Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 2 [SIMPLE_EDGE]
Reduce Output Operator [RS_6]
key expressions:_col1 (type: int)
@@ -2359,48 +2380,48 @@ Stage-0
Reducer 4
File Output Operator [FS_50]
compressed:false
- Statistics:Num rows: 5 Data size: 410 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
Limit [LIM_49]
Number of rows:5
- Statistics:Num rows: 5 Data size: 410 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator [SEL_48]
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 3 [SIMPLE_EDGE]
Reduce Output Operator [RS_47]
key expressions:(UDFToLong(_col0) + _col1) (type: bigint), _col1 (type: bigint)
sort order:-+
- Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col0 (type: int), _col2 (type: bigint)
Group By Operator [GBY_45]
| aggregations:["count(VALUE._col0)"]
| keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
| outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
|<-Reducer 2 [SIMPLE_EDGE]
Reduce Output Operator [RS_44]
key expressions:_col0 (type: int), _col1 (type: bigint)
Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
sort order:++
- Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col2 (type: bigint)
Group By Operator [GBY_43]
aggregations:["count()"]
keys:_col0 (type: int), _col1 (typ
<TRUNCATED>