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:09:16 UTC
[44/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/bucket_groupby.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out
index 5913768..1c6ab8c 100644
--- a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out
@@ -63,22 +63,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Execution mode: llap
@@ -91,11 +91,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Reducer 3
@@ -104,13 +104,13 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -191,22 +191,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Execution mode: llap
@@ -219,11 +219,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Reducer 3
@@ -232,13 +232,13 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -292,22 +292,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: length(key) (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Execution mode: llap
@@ -320,13 +320,13 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -373,22 +373,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: abs(length(key)) (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Execution mode: llap
@@ -401,13 +401,13 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -455,22 +455,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Execution mode: llap
@@ -483,11 +483,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Reducer 3
@@ -496,13 +496,13 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -557,22 +557,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: value (type: string)
outputColumnNames: value
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: value (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Execution mode: llap
@@ -585,11 +585,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Reducer 3
@@ -598,13 +598,13 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -658,22 +658,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- 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: key
- 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
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- 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
value expressions: _col1 (type: bigint)
Execution mode: llap
LLAP IO: no inputs
@@ -685,10 +685,10 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92804 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92804 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1043,22 +1043,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- 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: key
- 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
Group By Operator
aggregations: count()
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- 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
value expressions: _col1 (type: bigint)
Execution mode: llap
LLAP IO: no inputs
@@ -1070,10 +1070,10 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92804 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92804 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1158,23 +1158,23 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
bucketGroup: true
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Execution mode: llap
@@ -1187,11 +1187,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Reducer 3
@@ -1200,13 +1200,13 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1261,22 +1261,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: value (type: string)
outputColumnNames: value
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: value (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Execution mode: llap
@@ -1289,11 +1289,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Reducer 3
@@ -1302,13 +1302,13 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1464,23 +1464,23 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
bucketGroup: true
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Execution mode: llap
@@ -1493,11 +1493,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Reducer 3
@@ -1506,13 +1506,13 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1567,22 +1567,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: clustergroupby
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 180480 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 180480 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: key (type: string), value (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 180480 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 180480 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col2 (type: bigint)
Execution mode: llap
@@ -1595,15 +1595,15 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 90240 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col2 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 90240 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 90240 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col1 (type: bigint)
Reducer 3
@@ -1612,13 +1612,13 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 90240 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 3600 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 3600 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat