http://git-wip-us.apache.org/repos/asf/hive/blob/5f01dc42/ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out
b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out
index 1fff22b..20702f9 100644
--- a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out
@@ -132,19 +132,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -152,14 +152,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -169,14 +169,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
0 Map 1
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type:
string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -217,39 +217,39 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tab_part
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Group By Operator
keys: key (type: int), value (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
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: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 4
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
@@ -259,11 +259,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 4656 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 4656 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -272,7 +272,7 @@ STAGE PLANS:
1 _col0 (type: int)
input vertices:
1 Map 4
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 5121 Basic stats:
COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -354,33 +354,33 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 2
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -390,7 +390,7 @@ STAGE PLANS:
outputColumnNames: _col0
input vertices:
0 Map 1
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -399,7 +399,7 @@ STAGE PLANS:
1 _col0 (type: int)
input vertices:
1 Map 4
- Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 11267 Basic
stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -415,19 +415,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: d
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 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: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Reducer 3
@@ -506,52 +506,52 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: d
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 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: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 2
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -561,7 +561,7 @@ STAGE PLANS:
outputColumnNames: _col0
input vertices:
0 Map 2
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -570,7 +570,7 @@ STAGE PLANS:
1 _col0 (type: int)
input vertices:
0 Map 1
- Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 11267 Basic
stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -658,25 +658,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcbucket_mapjoin
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), substr(value, 5) (type:
string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic stats:
COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 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: 27 Data size: 2808 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic
stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Execution mode: llap
LLAP IO: no inputs
@@ -684,14 +684,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -701,14 +701,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
0 Reducer 2
- Statistics: Num rows: 266 Data size: 2822 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 4952 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col0 (type:
double), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 266 Data size: 2822 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 4952 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 266 Data size: 2822 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 4952 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -723,16 +723,16 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 1352 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1456 Basic stats: COMPLETE
Column stats: NONE
Select Operator
expressions: _col1 (type: double), _col0 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 1352 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 13 Data size: 1352 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: double)
Stage: Stage-0
@@ -768,14 +768,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tab_part
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -785,22 +785,22 @@ STAGE PLANS:
outputColumnNames: _col1, _col2
input vertices:
1 Map 3
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), substr(_col2, 5)
(type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 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: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Execution mode: llap
LLAP IO: no inputs
@@ -808,19 +808,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tab
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -828,19 +828,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -852,11 +852,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 5121 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: double), _col0 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 5121 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -866,14 +866,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 4
- Statistics: Num rows: 302 Data size: 3213 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 5633 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col0 (type: double),
_col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 302 Data size: 3213 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 5633 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 302 Data size: 3213 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 5633 Basic stats:
COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -912,14 +912,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -929,22 +929,22 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
input vertices:
1 Map 3
- Statistics: Num rows: 266 Data size: 2822 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 4952 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), substr(_col1, 5)
(type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 266 Data size: 2822 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 4952 Basic
stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 266 Data size: 2822 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 4952 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: 266 Data size: 2822 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 4952 Basic
stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Execution mode: llap
LLAP IO: no inputs
@@ -952,38 +952,38 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 4
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 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: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -995,11 +995,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 133 Data size: 1411 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 133 Data size: 2476 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: double), _col0 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 133 Data size: 1411 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 133 Data size: 2476 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1009,14 +1009,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 4
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col0 (type: double),
_col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1054,14 +1054,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1074,14 +1074,14 @@ STAGE PLANS:
input vertices:
1 Map 2
2 Map 3
- Statistics: Num rows: 1100 Data size: 11686 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1100 Data size: 20486 Basic
stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type:
string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1100 Data size: 11686 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1100 Data size: 20486 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1100 Data size: 11686 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1100 Data size: 20486 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1092,19 +1092,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1112,19 +1112,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
@@ -1158,14 +1158,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1175,7 +1175,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
input vertices:
1 Map 2
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1185,14 +1185,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 3
- Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 11267 Basic
stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type:
string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 11267 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 11267 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1203,38 +1203,38 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 3
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 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: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1274,25 +1274,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcbucket_mapjoin
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), substr(value, 5) (type:
string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic stats:
COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 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: 27 Data size: 2808 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic
stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Execution mode: llap
LLAP IO: no inputs
@@ -1300,14 +1300,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1317,14 +1317,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
0 Reducer 2
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type:
double), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1339,12 +1339,12 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 1352 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1456 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: 13 Data size: 1352 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Stage: Stage-0
@@ -1380,19 +1380,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcbucket_mapjoin
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), substr(value, 5) (type:
string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 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: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3024 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1400,14 +1400,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1417,14 +1417,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
0 Reducer 2
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type:
double), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1439,12 +1439,12 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: complete
outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 1352 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1456 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: 13 Data size: 1352 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Stage: Stage-0
@@ -1479,19 +1479,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: string)
sort order: +
Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 4502 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: int)
Execution mode: llap
LLAP IO: no inputs
@@ -1499,14 +1499,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: value (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1516,10 +1516,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2
input vertices:
0 Map 1
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1599,14 +1599,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1616,14 +1616,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
0 Map 1
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type:
string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1657,14 +1657,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type:
boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1674,7 +1674,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
input vertices:
1 Map 2
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1684,14 +1684,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col3
input vertices:
1 Map 3
- Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 11267 Basic
stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col3 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 11267 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 11267 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1702,38 +1702,38 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 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: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: string)
sort order: +
Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: int)
Execution mode: llap
LLAP IO: no inputs
@@ -1768,34 +1768,34 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 47094 Basic stats:
COMPLETE Column stats: PARTIAL
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 44528 Basic stats:
COMPLETE Column stats: PARTIAL
Select Operator
expressions: key (type: int), value (type: string), ds
(type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 44528 Basic stats:
COMPLETE Column stats: PARTIAL
Reduce Output Operator
key expressions: _col0 (type: int), _col2 (type:
string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col2
(type: string)
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 44528 Basic
stats: COMPLETE Column stats: PARTIAL
value expressions: _col1 (type: string)
Select Operator
expressions: _col2 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 44528 Basic
stats: COMPLETE Column stats: PARTIAL
Group By Operator
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 242 Data size: 2566 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats:
COMPLETE Column stats: PARTIAL
Dynamic Partitioning Event Operator
Target column: ds (string)
Target Input: b
Partition key expr: ds
- Statistics: Num rows: 242 Data size: 2566 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic
stats: COMPLETE Column stats: PARTIAL
Target Vertex: Map 2
Execution mode: llap
LLAP IO: no inputs
@@ -1803,14 +1803,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 97312 Basic stats:
COMPLETE Column stats: PARTIAL
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats:
COMPLETE Column stats: PARTIAL
Select Operator
expressions: key (type: int), value (type: string), ds
(type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats:
COMPLETE Column stats: PARTIAL
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1820,14 +1820,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col4
input vertices:
0 Map 1
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 60500 Data size: 12826000 Basic
stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: _col0 (type: int), _col1 (type:
string), _col4 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 60500 Data size: 484000 Basic
stats: COMPLETE Column stats: PARTIAL
File Output Operator
compressed: false
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 60500 Data size: 484000
Basic stats: COMPLETE Column stats: PARTIAL
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1880,14 +1880,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1896,29 +1896,29 @@ STAGE PLANS:
1 _col0 (type: int)
input vertices:
1 Map 3
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 19 Basic stats: COMPLETE
Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 11 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 19 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 11 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 19 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: 11 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 19 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
@@ -1999,14 +1999,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 9312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -2015,29 +2015,29 @@ STAGE PLANS:
1 _col0 (type: int)
input vertices:
1 Map 3
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 10243 Basic
stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 3
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 19 Basic stats: COMPLETE
Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 11 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 19 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 11 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 19 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: 11 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 19 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
