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:39 UTC
[07/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/subquery_scalar.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out b/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out
index 40c6c82..ba5ccad 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out
@@ -112,19 +112,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 814 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 814 Data size: 3100 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: p_size (type: int)
outputColumnNames: p_size
- Statistics: Num rows: 814 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 814 Data size: 3100 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: avg(p_size)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 76 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 80 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 76 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 80 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: struct<count:bigint,sum:double,input:int>)
Execution mode: llap
LLAP IO: no inputs
@@ -139,14 +139,14 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
residual filter predicates: {(UDFToDouble(_col5) > _col9)}
- Statistics: Num rows: 8 Data size: 5568 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 8 Data size: 5568 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 8 Data size: 5568 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -158,10 +158,10 @@ STAGE PLANS:
aggregations: avg(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 76 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 80 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 76 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 80 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: double)
Stage: Stage-0
@@ -258,14 +258,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tempty
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 86 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: c (type: char(2))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 86 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 86 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: char(2))
Execution mode: llap
LLAP IO: no inputs
@@ -282,14 +282,14 @@ STAGE PLANS:
2
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col10
residual filter predicates: {(UDFToDouble(_col5) > UDFToDouble(_col10))}
- Statistics: Num rows: 8 Data size: 5024 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5712 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 8 Data size: 5024 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5712 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 8 Data size: 5024 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5712 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -357,24 +357,24 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 32 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5888 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is null (type: boolean)
- Statistics: Num rows: 16 Data size: 1628 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 16 Data size: 1628 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 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: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: bigint)
Reduce Output Operator
sort order:
- Statistics: Num rows: 16 Data size: 1628 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
@@ -389,14 +389,14 @@ STAGE PLANS:
1
2
outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 16 Data size: 11084 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 959 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), null (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 16 Data size: 11084 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 959 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 16 Data size: 11084 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 959 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -408,15 +408,15 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (sq_count_check(_col0) <= 1) (type: boolean)
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 1 Data size: 8 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: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -491,17 +491,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tnull
- Statistics: Num rows: 2 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: i (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 1
- Statistics: Num rows: 1 Data size: 5 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 5 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col0 (type: int)
Execution mode: llap
@@ -531,17 +531,17 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col10
- Statistics: Num rows: 26 Data size: 16250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 16224 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col10 is null (type: boolean)
- Statistics: Num rows: 13 Data size: 8125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 13 Data size: 8125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8112 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 13 Data size: 8125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8112 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -583,13 +583,13 @@ STAGE PLANS:
Select Operator
expressions: VALUE._col0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 5 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 1
- Statistics: Num rows: 1 Data size: 5 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 5 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int)
Stage: Stage-0
@@ -673,19 +673,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 32 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5888 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: p_name (type: string)
outputColumnNames: p_name
- Statistics: Num rows: 32 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5888 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: max(p_name)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -699,10 +699,10 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 26 Data size: 20904 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 25688 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 26 Data size: 20904 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 25688 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -714,15 +714,15 @@ STAGE PLANS:
aggregations: max(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col0 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -1599,21 +1599,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 31 Data size: 5828 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_type is not null (type: boolean)
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 30 Data size: 5640 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: avg(p_size)
keys: p_type (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 30 Data size: 5640 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 30 Data size: 5640 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: struct<count:bigint,sum:double,input:int>)
Execution mode: llap
LLAP IO: no inputs
@@ -1648,16 +1648,16 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 15 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 2820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: double), true (type: boolean), _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 15 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 2820 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
sort order: +
Map-reduce partition columns: _col2 (type: string)
- Statistics: Num rows: 15 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 2820 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: double), _col1 (type: boolean)
Stage: Stage-0
@@ -1718,21 +1718,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 31 Data size: 5828 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_type is not null (type: boolean)
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 30 Data size: 5640 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: min(p_size)
keys: p_type (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 30 Data size: 5640 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 30 Data size: 5640 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int)
Execution mode: llap
LLAP IO: no inputs
@@ -1740,19 +1740,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 814 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 814 Data size: 3100 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: p_size (type: int)
outputColumnNames: p_size
- Statistics: Num rows: 814 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 814 Data size: 3100 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: max(p_size)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int)
Execution mode: llap
LLAP IO: no inputs
@@ -1781,17 +1781,17 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col12
- Statistics: Num rows: 28 Data size: 17843 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 17955 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col5 BETWEEN CASE WHEN (_col10 is null) THEN (null) ELSE (_col9) END AND _col12 (type: boolean)
- Statistics: Num rows: 3 Data size: 1911 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 1923 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 3 Data size: 1911 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 1923 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 3 Data size: 1911 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 1923 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1804,16 +1804,16 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 15 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 2820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), true (type: boolean), _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 15 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 2820 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
sort order: +
Map-reduce partition columns: _col2 (type: string)
- Statistics: Num rows: 15 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 2820 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: boolean)
Reducer 7
Execution mode: llap
@@ -1822,10 +1822,10 @@ STAGE PLANS:
aggregations: max(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int)
Stage: Stage-0
@@ -1912,21 +1912,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 31 Data size: 5828 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_type is not null (type: boolean)
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 30 Data size: 5640 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: min(p_size)
keys: p_type (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 30 Data size: 5640 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 31 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 30 Data size: 5640 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int)
Execution mode: llap
LLAP IO: no inputs
@@ -1934,19 +1934,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 407 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 407 Data size: 3104 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: p_retailprice (type: double)
outputColumnNames: p_retailprice
- Statistics: Num rows: 407 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 407 Data size: 3104 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: max(p_retailprice)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: double)
Execution mode: llap
LLAP IO: no inputs
@@ -1981,14 +1981,14 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
residual filter predicates: {(_col7 <= _col9)}
- Statistics: Num rows: 3 Data size: 1923 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 1947 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 3 Data size: 1923 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 1947 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 3 Data size: 1923 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 1947 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2001,16 +2001,16 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 15 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 2820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), true (type: boolean), _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 15 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 2820 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
sort order: +
Map-reduce partition columns: _col2 (type: string)
- Statistics: Num rows: 15 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 2820 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: boolean)
Reducer 7
Execution mode: llap
@@ -2019,10 +2019,10 @@ STAGE PLANS:
aggregations: max(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: double)
Stage: Stage-0
@@ -3346,14 +3346,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 5 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 5 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 5 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -3361,19 +3361,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 32 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5888 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: p_name (type: string)
outputColumnNames: p_name
- Statistics: Num rows: 32 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 32 Data size: 5888 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: min(p_name)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -3417,17 +3417,17 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 5 Data size: 4181 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 7445 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (not (_col1 like _col9)) (type: boolean)
- Statistics: Num rows: 3 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 4467 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 3 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 4467 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 3 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 4467 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
Reducer 3
Execution mode: llap
@@ -3439,12 +3439,12 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col10, _col11
- Statistics: Num rows: 3 Data size: 2559 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 4518 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string)
sort order: +
Map-reduce partition columns: _col3 (type: string)
- Statistics: Num rows: 3 Data size: 2559 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 4518 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col10 (type: bigint), _col11 (type: bigint)
Reducer 4
Execution mode: llap
@@ -3478,10 +3478,10 @@ STAGE PLANS:
aggregations: min(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Reducer 8
Execution mode: llap
@@ -3583,14 +3583,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 5 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 5 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 5 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -3628,21 +3628,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
- Statistics: Num rows: 16 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 5888 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_type is not null (type: boolean)
- Statistics: Num rows: 16 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 5888 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: min(p_name)
keys: p_type (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 16 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 5888 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 16 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 5888 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -3656,12 +3656,12 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
- Statistics: Num rows: 5 Data size: 3341 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5685 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string)
sort order: +
Map-reduce partition columns: _col3 (type: string)
- Statistics: Num rows: 5 Data size: 3341 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5685 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col9 (type: bigint), _col10 (type: bigint)
Reducer 3
Execution mode: llap
@@ -3697,17 +3697,17 @@ STAGE PLANS:
0 _col4 (type: string)
1 _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col13, _col14
- Statistics: Num rows: 8 Data size: 1790 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 3238 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (not (_col1 like CASE WHEN (_col14 is null) THEN (null) ELSE (_col13) END)) (type: boolean)
- Statistics: Num rows: 4 Data size: 895 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1619 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 4 Data size: 895 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1619 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 895 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1619 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -3750,16 +3750,16 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 1628 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 2944 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), true (type: boolean), _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 8 Data size: 1628 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 2944 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
sort order: +
Map-reduce partition columns: _col2 (type: string)
- Statistics: Num rows: 8 Data size: 1628 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 2944 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: boolean)
Stage: Stage-0
@@ -4378,16 +4378,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
- Statistics: Num rows: 5 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 5 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: string), _col4 (type: string)
sort order: ++
Map-reduce partition columns: _col1 (type: string), _col4 (type: string)
- Statistics: Num rows: 5 Data size: 3256 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 5600 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: string), _col3 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -4681,16 +4681,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps
- Statistics: Num rows: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: empno (type: int), name (type: string), deptno (type: int), gender (type: string), city (type: string), empid (type: int), age (type: int), slacker (type: boolean), manager (type: boolean), joinedat (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 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: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
Execution mode: llap
LLAP IO: no inputs
@@ -4698,21 +4698,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: name is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(deptno)
keys: name (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Execution mode: llap
LLAP IO: no inputs
@@ -4726,17 +4726,17 @@ STAGE PLANS:
0 _col1 (type: string)
1 _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (UDFToLong(_col2) <> CASE WHEN (_col11 is null) THEN (0) ELSE (_col10) END) (type: boolean)
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -4749,16 +4749,16 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: bigint), true (type: boolean), _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
sort order: +
Map-reduce partition columns: _col2 (type: string)
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: bigint), _col1 (type: boolean)
Stage: Stage-0
@@ -4803,16 +4803,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps
- Statistics: Num rows: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: empno (type: int), name (type: string), deptno (type: int), gender (type: string), city (type: string), empid (type: int), age (type: int), slacker (type: boolean), manager (type: boolean), joinedat (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: int)
sort order: +
Map-reduce partition columns: _col2 (type: int)
- Statistics: Num rows: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
Execution mode: llap
LLAP IO: no inputs
@@ -4820,21 +4820,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: deptno is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: min(name)
keys: deptno (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 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: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -4849,14 +4849,14 @@ STAGE PLANS:
1 _col2 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
residual filter predicates: {(_col1 > CASE WHEN (_col11 is null) THEN (null) ELSE (_col10) END)}
- Statistics: Num rows: 1 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 695 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 1 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 695 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 695 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -4869,16 +4869,16 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), true (type: boolean), _col0 (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: int)
sort order: +
Map-reduce partition columns: _col2 (type: int)
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: boolean)
Stage: Stage-0
@@ -4921,16 +4921,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps
- Statistics: Num rows: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: empno (type: int), name (type: string), deptno (type: int), gender (type: string), city (type: string), empid (type: int), age (type: int), slacker (type: boolean), manager (type: boolean), joinedat (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 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: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
Execution mode: llap
LLAP IO: no inputs
@@ -4938,36 +4938,36 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: name is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(deptno)
keys: name (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Filter Operator
predicate: deptno is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(name)
keys: deptno (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 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: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Execution mode: llap
LLAP IO: no inputs
@@ -4981,19 +4981,19 @@ STAGE PLANS:
0 _col1 (type: string)
1 _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (UDFToLong(_col2) <> CASE WHEN (_col11 is null) THEN (0) ELSE (_col10) END) (type: boolean)
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: int)
sort order: +
Map-reduce partition columns: _col2 (type: int)
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
Reducer 3
Execution mode: llap
@@ -5005,17 +5005,17 @@ STAGE PLANS:
0 _col2 (type: int)
1 _col2 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col13, _col14
- Statistics: Num rows: 5 Data size: 287 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3823 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (UDFToLong(_col0) > CASE WHEN (_col14 is null) THEN (0) ELSE (_col13) END) (type: boolean)
- Statistics: Num rows: 1 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 764 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 1 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 764 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 764 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -5028,16 +5028,16 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: bigint), true (type: boolean), _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
sort order: +
Map-reduce partition columns: _col2 (type: string)
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: bigint), _col1 (type: boolean)
Reducer 6
Execution mode: llap
@@ -5047,16 +5047,16 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: bigint), true (type: boolean), _col0 (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: int)
sort order: +
Map-reduce partition columns: _col2 (type: int)
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: bigint), _col1 (type: boolean)
Stage: Stage-0
@@ -5104,16 +5104,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps
- Statistics: Num rows: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: empno (type: int), name (type: string), deptno (type: int), gender (type: string), city (type: string), empid (type: int), age (type: int), slacker (type: boolean), manager (type: boolean), joinedat (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 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: 5 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
Execution mode: llap
LLAP IO: no inputs
@@ -5121,21 +5121,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: name is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(deptno)
keys: name (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 564 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Execution mode: llap
LLAP IO: no inputs
@@ -5143,19 +5143,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 552 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: name (type: string)
outputColumnNames: name
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 552 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(name)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 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: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: bigint)
Execution mode: llap
LLAP IO: no inputs
@@ -5170,14 +5170,14 @@ STAGE PLANS:
1 _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
residual filter predicates: {(UDFToLong(_col2) <> CASE WHEN (_col11 is null) THEN (null) ELSE (_col10) END)}
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 5 Data size: 261 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 3476 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
Reducer 3
Execution mode: llap
@@ -5190,14 +5190,14 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
residual filter predicates: {(UDFToLong(_col0) > _col10)}
- Statistics: Num rows: 1 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 888 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: int), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: date)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 1 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 888 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 888 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -5210,16 +5210,16 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: bigint), true (type: boolean), _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
sort order: +
Map-reduce partition columns: _col2 (type: string)
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: bigint), _col1 (type: boolean)
Reducer 7
Execution mode: llap
@@ -5228,10 +5228,10 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 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: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: bigint)
Stage: Stage-0
@@ -6154,16 +6154,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: i (type: int), j (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 16 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: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int)
Execution mode: llap
LLAP IO: no inputs
@@ -6171,14 +6171,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tt
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: j (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int)
Execution mode: llap
LLAP IO: no inputs
@@ -6186,17 +6186,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: i (type: int)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 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: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
@@ -6209,17 +6209,17 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col2 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 17 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: CASE WHEN (_col3 is null) THEN ((0 = 0)) ELSE ((_col2 = 0)) END (type: boolean)
- Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.
<TRUNCATED>