http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/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 814c947..79348f3 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
@@ -134,16 +134,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Map 2
@@ -153,11 +153,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -167,15 +167,15 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
0 Map 1
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col0 (type: int), _col1 (type:
string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -217,17 +217,17 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Group By Operator
keys: key (type: int), value (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 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: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
Map 4
Map Operator Tree:
@@ -236,16 +236,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
Reducer 2
Execution mode: llap
@@ -254,11 +254,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 125 Data size: 1328 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -267,7 +267,7 @@ STAGE PLANS:
1 _col0 (type: int)
input vertices:
1 Map 4
- Statistics: Num rows: 137 Data size: 1460 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Group By Operator
aggregations: count()
@@ -351,22 +351,22 @@ STAGE PLANS:
Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 14 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), substr(value, 5) (type:
string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 14 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 14 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 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: 14 Data size: 1456 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 Basic
stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Execution mode: llap
Map 3
@@ -376,16 +376,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Reducer 2
@@ -396,11 +396,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 7 Data size: 728 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1352 Basic stats: COMPLETE
Column stats: NONE
Select Operator
expressions: _col1 (type: double), _col0 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 7 Data size: 728 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1352 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -410,15 +410,15 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 3
- Statistics: Num rows: 133 Data size: 1411 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 2822 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col1 (type: int), _col0 (type: double),
_col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 133 Data size: 1411 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 2822 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 133 Data size: 1411 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 2822 Basic stats:
COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -459,11 +459,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -473,23 +473,23 @@ STAGE PLANS:
outputColumnNames: _col1, _col2
input vertices:
1 Map 3
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col1 (type: int), substr(_col2, 5)
(type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 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: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Execution mode: llap
Map 3
@@ -499,16 +499,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Map 4
@@ -518,16 +518,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Reducer 2
@@ -538,11 +538,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: double), _col0 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -552,15 +552,15 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 4
- Statistics: Num rows: 150 Data size: 1600 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 3213 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col1 (type: int), _col0 (type: double),
_col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 150 Data size: 1600 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 3213 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 150 Data size: 1600 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 3213 Basic stats:
COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -601,11 +601,11 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -615,23 +615,23 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
input vertices:
1 Map 3
- Statistics: Num rows: 133 Data size: 1411 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 2822 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col0 (type: int), substr(_col1, 5)
(type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 133 Data size: 1411 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 2822 Basic
stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 133 Data size: 1411 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 2822 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: 133 Data size: 1411 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 266 Data size: 2822 Basic
stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Execution mode: llap
Map 3
@@ -641,16 +641,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
Map 4
Map Operator Tree:
@@ -659,16 +659,16 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 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: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Reducer 2
@@ -679,11 +679,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 66 Data size: 700 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 133 Data size: 1411 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: double), _col0 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 66 Data size: 700 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 133 Data size: 1411 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -693,15 +693,15 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 4
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col1 (type: int), _col0 (type: double),
_col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -741,11 +741,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -758,15 +758,15 @@ STAGE PLANS:
input vertices:
1 Map 2
2 Map 3
- Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1100 Data size: 11686 Basic
stats: COMPLETE Column stats: NONE
HybridGraceHashJoin: true
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: 1100 Data size: 11686 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: 1100 Data size: 11686 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -779,16 +779,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Map 3
@@ -798,16 +798,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
Stage: Stage-0
@@ -842,11 +842,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -856,7 +856,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
input vertices:
1 Map 2
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Map Join Operator
condition map:
@@ -867,15 +867,15 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 3
- Statistics: Num rows: 302 Data size: 3213 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col0 (type: int), _col1 (type:
string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 302 Data size: 3213 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 6427 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: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -888,16 +888,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Execution mode: llap
Map 3
Map Operator Tree:
@@ -906,16 +906,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
@@ -955,22 +955,22 @@ STAGE PLANS:
Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 14 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), substr(value, 5) (type:
string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 14 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 14 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 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: 14 Data size: 1456 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 Basic
stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Execution mode: llap
Map 3
@@ -980,16 +980,16 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 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: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Reducer 2
@@ -1000,7 +1000,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 7 Data size: 728 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1352 Basic stats: COMPLETE
Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1010,15 +1010,15 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 3
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col0 (type: int), _col1 (type: double),
_col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1058,16 +1058,16 @@ STAGE PLANS:
Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 14 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), substr(value, 5) (type:
string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 14 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 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: 14 Data size: 1456 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2808 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Map 3
@@ -1077,16 +1077,16 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 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: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Reducer 2
@@ -1097,7 +1097,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: complete
outputColumnNames: _col0, _col1
- Statistics: Num rows: 7 Data size: 728 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1352 Basic stats: COMPLETE
Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1107,15 +1107,15 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 3
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col0 (type: int), _col1 (type: double),
_col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1155,16 +1155,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: int)
Execution mode: llap
Map 2
@@ -1174,11 +1174,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: value (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1188,11 +1188,11 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2
input vertices:
0 Map 1
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1253,16 +1253,16 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
Map 2
@@ -1272,11 +1272,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1286,15 +1286,15 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
0 Map 1
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col0 (type: int), _col1 (type:
string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1319,7 +1319,7 @@ STAGE PLANS:
Stage: Stage-1
Tez
Edges:
- Map 2 <- Map 1 (CUSTOM_EDGE), Map 3 (BROADCAST_EDGE)
+ Map 1 <- Map 2 (CUSTOM_EDGE), Map 3 (BROADCAST_EDGE)
#### A masked pattern was here ####
Vertices:
Map 1
@@ -1329,30 +1329,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type:
boolean)
- Statistics: Num rows: 125 Data size: 1328 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 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: 125 Data size: 1328 Basic stats:
COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
- Execution mode: llap
- Map 2
- Map Operator Tree:
- TableScan
- alias: a
- Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: int)
- outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1361,8 +1342,8 @@ STAGE PLANS:
1 _col0 (type: int)
outputColumnNames: _col0, _col1
input vertices:
- 0 Map 1
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ 1 Map 2
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Map Join Operator
condition map:
@@ -1373,20 +1354,38 @@ STAGE PLANS:
outputColumnNames: _col0, _col3
input vertices:
1 Map 3
- Statistics: Num rows: 302 Data size: 3213 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col0 (type: int), _col3 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 302 Data size: 3213 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 6427 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: 605 Data size: 6427 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: llap
+ Map 2
+ Map Operator Tree:
+ TableScan
+ alias: a
+ Statistics: Num rows: 500 Data size: 5312 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
+ Select Operator
+ expressions: key (type: int)
+ outputColumnNames: _col0
+ Statistics: Num rows: 500 Data size: 5312 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
+ Execution mode: llap
Map 3
Map Operator Tree:
TableScan
@@ -1394,16 +1393,16 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 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: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: int)
Execution mode: llap
@@ -1439,30 +1438,30 @@ STAGE PLANS:
Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string), ds
(type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
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: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Select Operator
expressions: _col2 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 121 Data size: 1283 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic stats:
COMPLETE Column stats: NONE
Group By Operator
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 121 Data size: 1283 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic
stats: COMPLETE Column stats: NONE
Dynamic Partitioning Event Operator
Target Input: b
Partition key expr: ds
- Statistics: Num rows: 121 Data size: 1283 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 2566 Basic
stats: COMPLETE Column stats: NONE
Target column: ds
Target Vertex: Map 2
Execution mode: llap
@@ -1473,11 +1472,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string), ds
(type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1487,15 +1486,15 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col4
input vertices:
0 Map 1
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
HybridGraceHashJoin: true
Select Operator
expressions: _col0 (type: int), _col1 (type:
string), _col4 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1549,11 +1548,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1562,10 +1561,10 @@ STAGE PLANS:
1 _col0 (type: int)
input vertices:
1 Map 3
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
Execution mode: llap
Map 3
Map Operator Tree:
@@ -1665,11 +1664,11 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1678,10 +1677,10 @@ STAGE PLANS:
1 _col0 (type: int)
input vertices:
1 Map 3
- Statistics: Num rows: 275 Data size: 2921 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 275 Data size: 2921 Basic
stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic
stats: COMPLETE Column stats: NONE
Execution mode: llap
Map 3
Map Operator Tree:
