You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by kg...@apache.org on 2019/01/23 16:39:03 UTC
[31/51] [partial] hive git commit: HIVE-17084: Turn on
hive.stats.fetch.column.stats configuration flag (Zoltan Haindrich reviewed
by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/268a6e5a/ql/src/test/results/clientpositive/correlationoptimizer8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/correlationoptimizer8.q.out b/ql/src/test/results/clientpositive/correlationoptimizer8.q.out
index 0e82cc3..9ad55cd 100644
--- a/ql/src/test/results/clientpositive/correlationoptimizer8.q.out
+++ b/ql/src/test/results/clientpositive/correlationoptimizer8.q.out
@@ -35,21 +35,21 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -58,7 +58,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -71,38 +71,38 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Union
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
Union
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
alias: x
filterExpr: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean)
- Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 2800 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 2800 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 2800 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
@@ -112,14 +112,14 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col1, _col2, _col3
- Statistics: Num rows: 182 Data size: 1938 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5856 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col2 (type: string), _col3 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 182 Data size: 1938 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5856 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 182 Data size: 1938 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5856 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -131,21 +131,21 @@ STAGE PLANS:
TableScan
alias: x1
filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -154,7 +154,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -238,71 +238,71 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
alias: x1
filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
alias: x
filterExpr: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean)
- Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 2800 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 2800 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 2800 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
Reduce Operator Tree:
Demux Operator
- Statistics: Num rows: 348 Data size: 3648 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 182 Data size: 18570 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 174 Data size: 1824 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Union
- Statistics: Num rows: 348 Data size: 3648 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
Mux Operator
- Statistics: Num rows: 696 Data size: 7296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 348 Data size: 34340 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Inner Join 0 to 1
@@ -310,14 +310,14 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col1, _col2, _col3
- Statistics: Num rows: 765 Data size: 8025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 382 Data size: 37774 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col2 (type: string), _col3 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 765 Data size: 8025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 382 Data size: 37774 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 765 Data size: 8025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 382 Data size: 37774 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -327,11 +327,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 174 Data size: 1824 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Union
- Statistics: Num rows: 348 Data size: 3648 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
Mux Operator
- Statistics: Num rows: 696 Data size: 7296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 348 Data size: 34340 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Inner Join 0 to 1
@@ -339,20 +339,20 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col1, _col2, _col3
- Statistics: Num rows: 765 Data size: 8025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 382 Data size: 37774 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col2 (type: string), _col3 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 765 Data size: 8025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 382 Data size: 37774 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 765 Data size: 8025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 382 Data size: 37774 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Mux Operator
- Statistics: Num rows: 696 Data size: 7296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 348 Data size: 34340 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Inner Join 0 to 1
@@ -360,14 +360,14 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col1, _col2, _col3
- Statistics: Num rows: 765 Data size: 8025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 382 Data size: 37774 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col2 (type: string), _col3 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 765 Data size: 8025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 382 Data size: 37774 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 765 Data size: 8025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 382 Data size: 37774 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -451,21 +451,21 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -474,7 +474,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -487,34 +487,34 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Union
- Statistics: Num rows: 87 Data size: 911 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 87 Data size: 8273 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 87 Data size: 911 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 87 Data size: 8273 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
Union
- Statistics: Num rows: 87 Data size: 911 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 87 Data size: 8273 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 87 Data size: 911 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 87 Data size: 8273 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
alias: x
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
@@ -524,10 +524,10 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 95 Data size: 1002 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 113 Data size: 15686 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 95 Data size: 1002 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 113 Data size: 15686 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -539,25 +539,25 @@ STAGE PLANS:
TableScan
alias: x1
filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1400 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: value (type: string)
outputColumnNames: value
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1400 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: value (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 388 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 388 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -566,7 +566,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 4 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 388 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -670,71 +670,71 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
alias: x1
filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1400 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: value (type: string)
outputColumnNames: value
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1400 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: value (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 388 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 388 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
alias: x
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
Reduce Operator Tree:
Demux Operator
- Statistics: Num rows: 199 Data size: 2015 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 12648 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 99 Data size: 1002 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 8051 Basic stats: COMPLETE Column stats: COMPLETE
Union
- Statistics: Num rows: 198 Data size: 2004 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 16102 Basic stats: COMPLETE Column stats: COMPLETE
Mux Operator
- Statistics: Num rows: 397 Data size: 4019 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 278 Data size: 28750 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Left Outer Join 0 to 1
@@ -742,10 +742,10 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 436 Data size: 4420 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 305 Data size: 31625 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 436 Data size: 4420 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 305 Data size: 31625 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -755,11 +755,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 99 Data size: 1002 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 8051 Basic stats: COMPLETE Column stats: COMPLETE
Union
- Statistics: Num rows: 198 Data size: 2004 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 16102 Basic stats: COMPLETE Column stats: COMPLETE
Mux Operator
- Statistics: Num rows: 397 Data size: 4019 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 278 Data size: 28750 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Left Outer Join 0 to 1
@@ -767,16 +767,16 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 436 Data size: 4420 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 305 Data size: 31625 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 436 Data size: 4420 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 305 Data size: 31625 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Mux Operator
- Statistics: Num rows: 397 Data size: 4019 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 278 Data size: 28750 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Left Outer Join 0 to 1
@@ -784,10 +784,10 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 436 Data size: 4420 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 305 Data size: 31625 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 436 Data size: 4420 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 305 Data size: 31625 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -891,21 +891,21 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -914,7 +914,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -927,38 +927,38 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Union
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
Union
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 15770 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
alias: x
filterExpr: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((UDFToDouble(key) < 20.0D) or (UDFToDouble(key) > 100.0D)) and key is not null) (type: boolean)
- Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 2800 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 2800 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 2800 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
@@ -968,14 +968,14 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col1, _col2, _col3
- Statistics: Num rows: 182 Data size: 1938 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5856 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col2 (type: string), _col3 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 182 Data size: 1938 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5856 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 182 Data size: 1938 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5856 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -987,21 +987,21 @@ STAGE PLANS:
TableScan
alias: x1
filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string), value (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 15438 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 15438 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -1010,11 +1010,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 15438 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: string), _col2 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -1066,21 +1066,21 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) < 20.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -1089,11 +1089,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: UDFToLong(UDFToInteger(_col0)) (type: bigint), _col1 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 1328 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -1106,42 +1106,42 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Union
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 2656 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: bigint), _col1 (type: bigint), UDFToDouble(_col0) (type: double)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 3984 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: double)
sort order: +
Map-reduce partition columns: _col2 (type: double)
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 3984 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint), _col1 (type: bigint)
TableScan
Union
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 2656 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: bigint), _col1 (type: bigint), UDFToDouble(_col0) (type: double)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 3984 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: double)
sort order: +
Map-reduce partition columns: _col2 (type: double)
- Statistics: Num rows: 166 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 3984 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint), _col1 (type: bigint)
TableScan
alias: x
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string), UDFToDouble(key) (type: double)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4575 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: double)
sort order: +
Map-reduce partition columns: _col2 (type: double)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 4575 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
Join Operator
@@ -1151,14 +1151,14 @@ STAGE PLANS:
0 _col2 (type: double)
1 _col2 (type: double)
outputColumnNames: _col0, _col1, _col3, _col4
- Statistics: Num rows: 182 Data size: 1938 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 241 Data size: 9741 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: bigint), _col1 (type: bigint), _col3 (type: string), _col4 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 182 Data size: 1938 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 241 Data size: 9741 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 182 Data size: 1938 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 241 Data size: 9741 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1170,21 +1170,21 @@ STAGE PLANS:
TableScan
alias: x1
filterExpr: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) > 100.0D) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -1193,11 +1193,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 7885 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col1 (type: bigint), UDFToLong(UDFToInteger(_col0)) (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 83 Data size: 1328 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
http://git-wip-us.apache.org/repos/asf/hive/blob/268a6e5a/ql/src/test/results/clientpositive/correlationoptimizer9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/correlationoptimizer9.q.out b/ql/src/test/results/clientpositive/correlationoptimizer9.q.out
index 748b168..865890f 100644
--- a/ql/src/test/results/clientpositive/correlationoptimizer9.q.out
+++ b/ql/src/test/results/clientpositive/correlationoptimizer9.q.out
@@ -53,21 +53,21 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: ((c1 < 120) and (c1 > 100)) (type: boolean)
- Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1028 Data size: 4112 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c1 < 120) and (c1 > 100)) (type: boolean)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 456 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: c1 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -76,7 +76,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -92,14 +92,14 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Join Operator
@@ -109,14 +109,14 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 62 Data size: 1400 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 816 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int), _col2 (type: int), _col1 (type: bigint), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 62 Data size: 1400 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 816 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 62 Data size: 1400 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 816 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -128,21 +128,21 @@ STAGE PLANS:
TableScan
alias: x1
filterExpr: ((c2 > 100) and (c2 < 120)) (type: boolean)
- Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1028 Data size: 4112 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c2 < 120) and (c2 > 100)) (type: boolean)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 456 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: c2 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -151,7 +151,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -223,52 +223,52 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: ((c1 < 120) and (c1 > 100)) (type: boolean)
- Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1028 Data size: 4112 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c1 < 120) and (c1 > 100)) (type: boolean)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 456 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: c1 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
alias: x1
filterExpr: ((c2 > 100) and (c2 < 120)) (type: boolean)
- Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1028 Data size: 4112 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c2 < 120) and (c2 > 100)) (type: boolean)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 456 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: c2 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Demux Operator
- Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 68 Data size: 816 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
Mux Operator
- Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 68 Data size: 816 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Inner Join 0 to 1
@@ -276,14 +276,14 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 250 Data size: 5601 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 74 Data size: 897 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col2 (type: int), _col1 (type: bigint), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 250 Data size: 5601 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 74 Data size: 897 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 5601 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 74 Data size: 897 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -293,9 +293,9 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 34 Data size: 408 Basic stats: COMPLETE Column stats: COMPLETE
Mux Operator
- Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 68 Data size: 816 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Inner Join 0 to 1
@@ -303,14 +303,14 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 250 Data size: 5601 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 74 Data size: 897 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col2 (type: int), _col1 (type: bigint), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 250 Data size: 5601 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 74 Data size: 897 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 5601 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 74 Data size: 897 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -382,21 +382,21 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: ((c1 < 120) and c3 is not null) (type: boolean)
- Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1028 Data size: 97660 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c1 < 120) and c3 is not null) (type: boolean)
- Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 32490 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: c1 (type: int), c3 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 17613 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 17613 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -405,7 +405,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 17613 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -421,14 +421,14 @@ STAGE PLANS:
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 17613 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5871 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Join Operator
@@ -438,14 +438,14 @@ STAGE PLANS:
0 _col0 (type: int), _col1 (type: string)
1 _col0 (type: int), _col1 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 188 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 11742 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col3 (type: int), _col4 (type: string), _col2 (type: bigint), _col5 (type: bigint)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 188 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 11742 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 188 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 11742 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -457,25 +457,25 @@ STAGE PLANS:
TableScan
alias: x1
filterExpr: ((c2 > 100) and (c1 < 120) and c3 is not null) (type: boolean)
- Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1028 Data size: 101772 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c1 < 120) and (c2 > 100) and c3 is not null) (type: boolean)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 11286 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: c1 (type: int), c3 (type: string)
outputColumnNames: c1, c3
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 11286 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: c1 (type: int), c3 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5871 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5871 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -484,7 +484,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5871 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -556,56 +556,56 @@ STAGE PLANS:
TableScan
alias: x
filterExpr: ((c1 < 120) and c3 is not null) (type: boolean)
- Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1028 Data size: 97660 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c1 < 120) and c3 is not null) (type: boolean)
- Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 32490 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: c1 (type: int), c3 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 17613 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 17613 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: bigint)
TableScan
alias: x1
filterExpr: ((c2 > 100) and (c1 < 120) and c3 is not null) (type: boolean)
- Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1028 Data size: 101772 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c1 < 120) and (c2 > 100) and c3 is not null) (type: boolean)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 11286 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: c1 (type: int), c3 (type: string)
outputColumnNames: c1, c3
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 11286 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: c1 (type: int), c3 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5871 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5871 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Demux Operator
- Statistics: Num rows: 456 Data size: 10185 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 23484 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: int), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 17613 Basic stats: COMPLETE Column stats: COMPLETE
Mux Operator
- Statistics: Num rows: 456 Data size: 10184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 35226 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Inner Join 0 to 1
@@ -613,14 +613,14 @@ STAGE PLANS:
0 _col0 (type: int), _col1 (type: string)
1 _col0 (type: int), _col1 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 501 Data size: 11202 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 376 Data size: 38748 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col3 (type: int), _col4 (type: string), _col2 (type: bigint), _col5 (type: bigint)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 501 Data size: 11202 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 376 Data size: 38748 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 501 Data size: 11202 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 376 Data size: 38748 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -630,9 +630,9 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 17613 Basic stats: COMPLETE Column stats: COMPLETE
Mux Operator
- Statistics: Num rows: 456 Data size: 10184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 35226 Basic stats: COMPLETE Column stats: COMPLETE
Join Operator
condition map:
Inner Join 0 to 1
@@ -640,14 +640,14 @@ STAGE PLANS:
0 _col0 (type: int), _col1 (type: string)
1 _col0 (type: int), _col1 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 501 Data size: 11202 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 376 Data size: 38748 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col3 (type: int), _col4 (type: string), _col2 (type: bigint), _col5 (type: bigint)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 501 Data size: 11202 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 376 Data size: 38748 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 501 Data size: 11202 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 376 Data size: 38748 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat