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 2017/12/20 10:40:13 UTC
[12/37] hive git commit: HIVE-18149: Stats: rownum estimation from
datasize underestimates in most cases (Zoltan Haindrich,
reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
index 0f31a93..9d1b9df 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
@@ -67,55 +67,55 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -128,10 +128,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -176,55 +176,55 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -237,10 +237,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -285,46 +285,46 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -337,10 +337,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -390,46 +390,46 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -442,10 +442,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -496,46 +496,46 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -548,10 +548,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -607,55 +607,55 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -668,10 +668,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -718,46 +718,46 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -770,10 +770,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -822,46 +822,46 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -874,10 +874,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -928,46 +928,46 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -980,10 +980,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1036,55 +1036,55 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -1097,10 +1097,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1147,46 +1147,46 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -1199,10 +1199,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1256,46 +1256,46 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -1308,10 +1308,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1362,46 +1362,46 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -1414,10 +1414,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 4576 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat