You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by vg...@apache.org on 2017/09/02 05:08:56 UTC
[24/51] [partial] hive git commit: HIVE-16811 : Estimate statistics
in absence of stats (Vineet Garg, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin46.q.out b/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
index efada10..c4ce854 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
@@ -62,11 +62,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -76,10 +76,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -90,16 +90,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 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: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -162,11 +162,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -179,10 +179,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -193,19 +193,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key BETWEEN 100 AND 102 (type: boolean)
- Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 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: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -269,11 +269,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -286,10 +286,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 6 Data size: 116 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 2310 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 116 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 2310 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -300,17 +300,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key BETWEEN 100 AND 102 (type: boolean)
- Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -370,16 +370,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 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: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -387,11 +387,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -401,10 +401,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
0 Map 1
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -465,11 +465,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -482,10 +482,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -496,14 +496,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -572,11 +572,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -587,10 +587,10 @@ STAGE PLANS:
input vertices:
1 Map 2
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -601,14 +601,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -680,11 +680,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -695,10 +695,10 @@ STAGE PLANS:
input vertices:
1 Map 2
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -709,14 +709,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -786,11 +786,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -801,10 +801,10 @@ STAGE PLANS:
input vertices:
1 Map 2
residual filter predicates: {((_col1 = _col4) or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -815,14 +815,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -888,11 +888,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -903,10 +903,10 @@ STAGE PLANS:
input vertices:
1 Map 2
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -917,16 +917,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 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: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -993,14 +993,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1008,11 +1008,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1023,10 +1023,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1101,14 +1101,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1116,11 +1116,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1131,10 +1131,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1204,14 +1204,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1219,11 +1219,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1234,10 +1234,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {((_col1 = _col4) or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1308,16 +1308,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 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: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1325,11 +1325,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1340,10 +1340,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1411,14 +1411,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1426,14 +1426,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1448,10 +1448,10 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1524,14 +1524,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1539,14 +1539,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1561,10 +1561,10 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1635,14 +1635,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1650,14 +1650,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1672,10 +1672,10 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
residual filter predicates: {((_col1 = _col4) or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1744,16 +1744,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 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: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1761,16 +1761,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 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: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1785,10 +1785,10 @@ STAGE PLANS:
1 _col1 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1886,21 +1886,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 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: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -1911,10 +1911,10 @@ STAGE PLANS:
input vertices:
1 Map 4
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string), _col3 (type: int), _col4 (type: int), _col5 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1922,11 +1922,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1937,10 +1937,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string), _col3 (type: int), _col4 (type: int), _col5 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1948,16 +1948,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 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: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1972,10 +1972,10 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
residual filter predicates: {(_col1 is null or (_col10 is null and (_col7 <> _col4)))}
- Statistics: Num rows: 36 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 36 Data size: 15240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 36 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 36 Data size: 15240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
index 38b8f92..30239fa 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
@@ -95,14 +95,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 111776 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(4,2))
outputColumnNames: _col0
- Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -112,11 +112,11 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
input vertices:
1 Map 3
- Statistics: Num rows: 1153 Data size: 129236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1096 Data size: 116858 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: decimal(4,2))
sort order: +
- Statistics: Num rows: 1153 Data size: 129236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1096 Data size: 116858 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: decimal(4,0))
Execution mode: llap
LLAP IO: all inputs
@@ -124,19 +124,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 111776 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(4,0))
outputColumnNames: _col0
- Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: decimal(6,2))
sort order: +
Map-reduce partition columns: _col0 (type: decimal(6,2))
- Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: all inputs
Reducer 2
@@ -145,10 +145,10 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: decimal(4,2)), VALUE._col0 (type: decimal(4,0))
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1153 Data size: 129236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1096 Data size: 116858 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1153 Data size: 129236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1096 Data size: 116858 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out
index fdbca8a..5468448 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out
@@ -62,11 +62,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -79,10 +79,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -93,16 +93,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 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: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -161,11 +161,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -178,10 +178,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -192,14 +192,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/merge1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/merge1.q.out b/ql/src/test/results/clientpositive/llap/merge1.q.out
index 649c2f7..ec794dc 100644
--- a/ql/src/test/results/clientpositive/llap/merge1.q.out
+++ b/ql/src/test/results/clientpositive/llap/merge1.q.out
@@ -483,14 +483,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test_src
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -549,14 +549,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test_src
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/merge2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/merge2.q.out b/ql/src/test/results/clientpositive/llap/merge2.q.out
index dd72689..6ad6864 100644
--- a/ql/src/test/results/clientpositive/llap/merge2.q.out
+++ b/ql/src/test/results/clientpositive/llap/merge2.q.out
@@ -483,14 +483,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test_src
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -549,14 +549,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test_src
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat