You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by kg...@apache.org on 2017/12/20 10:40:35 UTC
[34/37] hive git commit: HIVE-18149: Stats: rownum estimation from
datasize underestimates in most cases (Zoltan Haindrich,
reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/distinct_windowing_no_cbo.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/distinct_windowing_no_cbo.q.out b/ql/src/test/results/clientpositive/distinct_windowing_no_cbo.q.out
index 9488ace..95e2bb5 100644
--- a/ql/src/test/results/clientpositive/distinct_windowing_no_cbo.q.out
+++ b/ql/src/test/results/clientpositive/distinct_windowing_no_cbo.q.out
@@ -61,18 +61,18 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: si (type: smallint), i (type: int)
sort order: ++
Map-reduce partition columns: si (type: smallint)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
value expressions: t (type: tinyint)
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: tinyint), KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -92,16 +92,16 @@ STAGE PLANS:
name: first_value
window function: GenericUDAFFirstValueEvaluator
window frame: RANGE PRECEDING(MAX)~CURRENT
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: first_value_window_0 (type: tinyint)
outputColumnNames: first_value_window_0
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: first_value_window_0 (type: tinyint)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -117,20 +117,20 @@ STAGE PLANS:
key expressions: _col0 (type: tinyint)
sort order: +
Map-reduce partition columns: _col0 (type: tinyint)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: tinyint)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -179,17 +179,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: si (type: smallint), i (type: int)
sort order: ++
Map-reduce partition columns: si (type: smallint)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int)
outputColumnNames: _col1, _col2
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -209,16 +209,16 @@ STAGE PLANS:
name: last_value
window function: GenericUDAFLastValueEvaluator
window frame: RANGE PRECEDING(MAX)~CURRENT
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: last_value_window_0 (type: int)
outputColumnNames: last_value_window_0
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: last_value_window_0 (type: int)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -234,20 +234,20 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -300,18 +300,18 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: si (type: smallint), i (type: int)
sort order: ++
Map-reduce partition columns: si (type: smallint)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
value expressions: t (type: tinyint)
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: tinyint), KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -337,16 +337,16 @@ STAGE PLANS:
name: first_value
window function: GenericUDAFFirstValueEvaluator
window frame: RANGE PRECEDING(MAX)~CURRENT
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: last_value_window_0 (type: int), first_value_window_1 (type: tinyint)
outputColumnNames: last_value_window_0, first_value_window_1
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: last_value_window_0 (type: int), first_value_window_1 (type: tinyint)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -362,20 +362,20 @@ STAGE PLANS:
key expressions: _col0 (type: int), _col1 (type: tinyint)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: tinyint)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: int), KEY._col1 (type: tinyint)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 50
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -474,22 +474,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: si (type: smallint), f (type: float)
outputColumnNames: si, f
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: max(f)
keys: si (type: smallint)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: smallint)
sort order: +
Map-reduce partition columns: _col0 (type: smallint)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: float)
Reduce Operator Tree:
Group By Operator
@@ -497,10 +497,10 @@ STAGE PLANS:
keys: KEY._col0 (type: smallint)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col1 > 0.0) (type: boolean)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -516,12 +516,12 @@ STAGE PLANS:
key expressions: _col0 (type: smallint), _col1 (type: float)
sort order: ++
Map-reduce partition columns: _col0 (type: smallint)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: float)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -542,17 +542,17 @@ STAGE PLANS:
window function: GenericUDAFRankEvaluator
window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX)
isPivotResult: true
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: smallint), _col1 (type: float), rank_window_0 (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 50
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -651,17 +651,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: si (type: smallint), i (type: int)
sort order: ++
Map-reduce partition columns: si (type: smallint)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int)
outputColumnNames: _col1, _col2
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -682,16 +682,16 @@ STAGE PLANS:
window function: GenericUDAFRankEvaluator
window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX)
isPivotResult: true
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: rank_window_0 (type: int), _col1 (type: smallint)
outputColumnNames: rank_window_0, _col1
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col1 (type: smallint), rank_window_0 (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -707,20 +707,20 @@ STAGE PLANS:
key expressions: _col0 (type: smallint), _col1 (type: int)
sort order: ++
Map-reduce partition columns: _col0 (type: smallint), _col1 (type: int)
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: smallint), KEY._col1 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 50
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/drop_table_with_index.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/drop_table_with_index.q.out b/ql/src/test/results/clientpositive/drop_table_with_index.q.out
index 145f385..2312eee 100644
--- a/ql/src/test/results/clientpositive/drop_table_with_index.q.out
+++ b/ql/src/test/results/clientpositive/drop_table_with_index.q.out
@@ -113,22 +113,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: aa
- Statistics: Num rows: 1 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120990 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: l_shipdate (type: string)
outputColumnNames: l_shipdate
- Statistics: Num rows: 1 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120990 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(l_shipdate)
keys: l_shipdate (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120990 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: 1 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120990 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -136,10 +136,10 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120990 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120990 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out b/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out
index 82b0079..27d10b8 100644
--- a/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out
+++ b/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out
@@ -108,30 +108,30 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: users_table
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: field_3 (type: boolean)
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: field_1 (type: int), field_2 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col0 (type: int), _col1 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: int), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -147,13 +147,13 @@ STAGE PLANS:
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
TableScan
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -162,13 +162,13 @@ STAGE PLANS:
0 _col0 (type: int), _col1 (type: string)
1 _col0 (type: int), _col1 (type: string)
outputColumnNames: _col0, _col3
- Statistics: Num rows: 1 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 25080 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(), sum(if(_col3 is not null, 1, 0))
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 25080 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -184,7 +184,7 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 25080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -192,7 +192,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 25080 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -207,16 +207,16 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 1 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 25080 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: bigint)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: bigint), VALUE._col1 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 25080 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 2508 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 25080 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -227,30 +227,30 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: users_table
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: field_4 (type: boolean)
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: field_1 (type: int), field_2 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col0 (type: int), _col1 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: int), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 2280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 22800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/gen_udf_example_add10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/gen_udf_example_add10.q.out b/ql/src/test/results/clientpositive/gen_udf_example_add10.q.out
index 2969e76..93fd92a 100644
--- a/ql/src/test/results/clientpositive/gen_udf_example_add10.q.out
+++ b/ql/src/test/results/clientpositive/gen_udf_example_add10.q.out
@@ -34,27 +34,27 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: add10(x) (type: int), add10(y) (type: double)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: double)
sort order: -+
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/groupby10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/groupby10.q.out b/ql/src/test/results/clientpositive/groupby10.q.out
index 79e4fd2..f2b14ad 100644
--- a/ql/src/test/results/clientpositive/groupby10.q.out
+++ b/ql/src/test/results/clientpositive/groupby10.q.out
@@ -60,20 +60,20 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: input
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: int), substr(value, 5) (type: string)
sort order: ++
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -86,7 +86,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: partial1
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -102,7 +102,7 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -110,14 +110,14 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: final
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -126,7 +126,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int)
outputColumnNames: key, val1, val2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -159,7 +159,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Map-reduce partition columns: rand() (type: double)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: int), val1 (type: int), val2 (type: int)
Reduce Operator Tree:
Group By Operator
@@ -212,14 +212,14 @@ STAGE PLANS:
key expressions: key (type: int), substr(value, 5) (type: string)
sort order: ++
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
aggregations: sum(KEY._col1:0._col0), sum(DISTINCT KEY._col1:0._col0)
keys: KEY._col0 (type: int)
mode: partial1
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -235,7 +235,7 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double), _col2 (type: double)
Reduce Operator Tree:
Group By Operator
@@ -243,14 +243,14 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: final
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -259,7 +259,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int)
outputColumnNames: key, val1, val2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -284,7 +284,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Map-reduce partition columns: rand() (type: double)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: int), val1 (type: int), val2 (type: int)
Reduce Operator Tree:
Group By Operator
@@ -427,20 +427,20 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: input
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: int), substr(value, 5) (type: string)
sort order: ++
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -453,7 +453,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: partial1
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -469,7 +469,7 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -477,14 +477,14 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: final
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -493,7 +493,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int)
outputColumnNames: key, val1, val2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -526,7 +526,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Map-reduce partition columns: rand() (type: double)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: int), val1 (type: int), val2 (type: int)
Reduce Operator Tree:
Group By Operator
@@ -579,14 +579,14 @@ STAGE PLANS:
key expressions: key (type: int), substr(value, 5) (type: string)
sort order: ++
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
aggregations: sum(KEY._col1:0._col0), sum(DISTINCT KEY._col1:0._col0)
keys: KEY._col0 (type: int)
mode: partial1
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -602,7 +602,7 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double), _col2 (type: double)
Reduce Operator Tree:
Group By Operator
@@ -610,14 +610,14 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: final
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -626,7 +626,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int)
outputColumnNames: key, val1, val2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -651,7 +651,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Map-reduce partition columns: rand() (type: double)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: int), val1 (type: int), val2 (type: int)
Reduce Operator Tree:
Group By Operator
@@ -789,32 +789,32 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: input
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: int), substr(value, 5) (type: string)
sort order: ++
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Forward
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT KEY._col1:0._col0), count(DISTINCT KEY._col1:1._col0)
keys: KEY._col0 (type: int)
mode: complete
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -823,7 +823,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int)
outputColumnNames: key, val1, val2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -835,14 +835,14 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: complete
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -851,7 +851,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int)
outputColumnNames: key, val1, val2
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -883,7 +883,7 @@ STAGE PLANS:
TableScan
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: int), val1 (type: int), val2 (type: int)
Reduce Operator Tree:
Group By Operator
@@ -923,7 +923,7 @@ STAGE PLANS:
TableScan
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: int), val1 (type: int), val2 (type: int)
Reduce Operator Tree:
Group By Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/groupby_cube1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/groupby_cube1.q.out b/ql/src/test/results/clientpositive/groupby_cube1.q.out
index 94f1ac0..e5ece81 100644
--- a/ql/src/test/results/clientpositive/groupby_cube1.q.out
+++ b/ql/src/test/results/clientpositive/groupby_cube1.q.out
@@ -30,22 +30,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: key, val
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: key (type: string), val (type: string), 0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string), _col2 (type: int)
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -53,15 +53,15 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -89,22 +89,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: key, val
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: key (type: string), val (type: string), 0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string), _col2 (type: int)
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -112,15 +112,15 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -174,22 +174,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: _col0 (type: string), _col1 (type: string), 0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string), _col2 (type: int)
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -197,14 +197,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -258,37 +258,37 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: key, val
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(DISTINCT val)
keys: key (type: string), 0 (type: int), val (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: int), _col2 (type: string)
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: int)
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col2:0._col0)
keys: KEY._col0 (type: string), KEY._col1 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col2
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col2 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -331,22 +331,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: key, val
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: key (type: string), val (type: string), 0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
sort order: +++
Map-reduce partition columns: rand() (type: double)
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -354,7 +354,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: partials
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -370,7 +370,7 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -378,15 +378,15 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: final
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col3 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -441,29 +441,29 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: key, val
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(DISTINCT val)
keys: key (type: string), 0 (type: int), val (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: int), _col2 (type: string)
sort order: +++
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col2:0._col0)
keys: KEY._col0 (type: string), KEY._col1 (type: int)
mode: partials
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -479,7 +479,7 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: int)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -487,15 +487,15 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: int)
mode: final
outputColumnNames: _col0, _col2
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col2 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -565,33 +565,33 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: key, val
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(1)
keys: key (type: string), val (type: string), 0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
sort order: +++
Map-reduce partition columns: rand() (type: double)
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
value expressions: _col3 (type: bigint)
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: key, val
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(1)
keys: key (type: string), val (type: string), 0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -604,7 +604,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: partials
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -620,7 +620,7 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -628,15 +628,15 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: final
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), UDFToInteger(_col3) (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -645,7 +645,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
outputColumnNames: key1, key2, val
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key1, 'hll'), compute_stats(key2, 'hll'), compute_stats(val, 'hll')
mode: hash
@@ -714,7 +714,7 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
sort order: +++
Map-reduce partition columns: rand() (type: double)
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -722,7 +722,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: partials
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -738,7 +738,7 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 4 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 1200 Basic stats: COMPLETE Column stats: NONE
value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -746,15 +746,15 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: final
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
pruneGroupingSetId: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), UDFToInteger(_col3) (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -763,7 +763,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
outputColumnNames: key1, key2, val
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 600 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key1, 'hll'), compute_stats(key2, 'hll'), compute_stats(val, 'hll')
mode: hash