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 2019/01/23 16:38:59 UTC
[27/51] [partial] hive git commit: HIVE-17084: Turn on
hive.stats.fetch.column.stats configuration flag (Zoltan Haindrich reviewed
by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/268a6e5a/ql/src/test/results/clientpositive/decimal_join2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/decimal_join2.q.out b/ql/src/test/results/clientpositive/decimal_join2.q.out
index 544dce9..053b1e6 100644
--- a/ql/src/test/results/clientpositive/decimal_join2.q.out
+++ b/ql/src/test/results/clientpositive/decimal_join2.q.out
@@ -62,36 +62,36 @@ STAGE PLANS:
TableScan
alias: a
filterExpr: key is not null (type: boolean)
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 38 Data size: 4408 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: decimal(38,18)), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: decimal(38,18))
sort order: +
Map-reduce partition columns: _col0 (type: decimal(38,18))
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: int)
TableScan
alias: b
filterExpr: key is not null (type: boolean)
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 38 Data size: 4408 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: decimal(38,18)), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: decimal(38,18))
sort order: +
Map-reduce partition columns: _col0 (type: decimal(38,18))
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: int)
Reduce Operator Tree:
Join Operator
@@ -101,7 +101,7 @@ STAGE PLANS:
0 _col0 (type: decimal(38,18))
1 _col0 (type: decimal(38,18))
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 41 Data size: 4725 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 11136 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -116,16 +116,16 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: decimal(38,18)), _col1 (type: int), _col2 (type: decimal(38,18)), _col3 (type: int)
sort order: ++++
- Statistics: Num rows: 41 Data size: 4725 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 11136 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: decimal(38,18)), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: decimal(38,18)), KEY.reducesinkkey3 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 41 Data size: 4725 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 11136 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 41 Data size: 4725 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 11136 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -237,14 +237,14 @@ STAGE PLANS:
TableScan
alias: a
filterExpr: key is not null (type: boolean)
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 38 Data size: 4408 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: decimal(38,18)), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
HashTable Sink Operator
keys:
0 _col0 (type: decimal(38,18))
@@ -256,14 +256,14 @@ STAGE PLANS:
TableScan
alias: b
filterExpr: key is not null (type: boolean)
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 38 Data size: 4408 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: decimal(38,18)), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 38 Data size: 4296 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 4292 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -271,11 +271,11 @@ STAGE PLANS:
0 _col0 (type: decimal(38,18))
1 _col0 (type: decimal(38,18))
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 41 Data size: 4725 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 11136 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: decimal(38,18)), _col1 (type: int), _col2 (type: decimal(38,18)), _col3 (type: int)
sort order: ++++
- Statistics: Num rows: 41 Data size: 4725 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 11136 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: vectorized
Local Work:
Map Reduce Local Work
@@ -283,10 +283,10 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: decimal(38,18)), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: decimal(38,18)), KEY.reducesinkkey3 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 41 Data size: 4725 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 11136 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 41 Data size: 4725 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 11136 Basic stats: COMPLETE Column stats: COMPLETE
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/268a6e5a/ql/src/test/results/clientpositive/decimal_precision.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/decimal_precision.q.out b/ql/src/test/results/clientpositive/decimal_precision.q.out
index e5393ae..014a364 100644
--- a/ql/src/test/results/clientpositive/decimal_precision.q.out
+++ b/ql/src/test/results/clientpositive/decimal_precision.q.out
@@ -540,19 +540,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_precision_n0
- Statistics: Num rows: 1 Data size: 26610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(20,10))
outputColumnNames: dec
- Statistics: Num rows: 1 Data size: 26610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(dec), count(dec)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: decimal(30,10)), _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -560,14 +560,14 @@ STAGE PLANS:
aggregations: sum(VALUE._col0), count(VALUE._col1)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (_col0 / _col1) (type: decimal(38,18)), CAST( _col0 AS decimal(30,10)) (type: decimal(30,10))
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 232 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/268a6e5a/ql/src/test/results/clientpositive/decimal_udf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/decimal_udf.q.out b/ql/src/test/results/clientpositive/decimal_udf.q.out
index 3ef4002..6f0fc29 100644
--- a/ql/src/test/results/clientpositive/decimal_udf.q.out
+++ b/ql/src/test/results/clientpositive/decimal_udf.q.out
@@ -42,11 +42,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (key + key) (type: decimal(21,10))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key + key FROM DECIMAL_UDF
@@ -113,11 +113,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (key + CAST( value AS decimal(10,0))) (type: decimal(21,10))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key + value FROM DECIMAL_UDF
@@ -184,11 +184,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (UDFToDouble(key) + (UDFToDouble(value) / 2.0D)) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key + (value/2) FROM DECIMAL_UDF
@@ -255,11 +255,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (UDFToDouble(key) + 1.0D) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key + '1.0' FROM DECIMAL_UDF
@@ -326,11 +326,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (key - key) (type: decimal(21,10))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key - key FROM DECIMAL_UDF
@@ -397,11 +397,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (key - CAST( value AS decimal(10,0))) (type: decimal(21,10))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key - value FROM DECIMAL_UDF
@@ -468,11 +468,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (UDFToDouble(key) - (UDFToDouble(value) / 2.0D)) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key - (value/2) FROM DECIMAL_UDF
@@ -539,11 +539,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (UDFToDouble(key) - 1.0D) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key - '1.0' FROM DECIMAL_UDF
@@ -610,11 +610,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (key * key) (type: decimal(38,17))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key * key FROM DECIMAL_UDF
@@ -682,14 +682,14 @@ STAGE PLANS:
TableScan
alias: decimal_udf
filterExpr: ((key * CAST( value AS decimal(10,0))) > 0) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key * CAST( value AS decimal(10,0))) > 0) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: decimal(20,10)), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key, value FROM DECIMAL_UDF where key * value > 0
@@ -741,11 +741,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (key * CAST( value AS decimal(10,0))) (type: decimal(31,10))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key * value FROM DECIMAL_UDF
@@ -812,11 +812,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (UDFToDouble(key) * (UDFToDouble(value) / 2.0D)) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key * (value/2) FROM DECIMAL_UDF
@@ -883,11 +883,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (UDFToDouble(key) * 2.0D) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key * '2.0' FROM DECIMAL_UDF
@@ -954,14 +954,14 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (key / 0) (type: decimal(22,12))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 1
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key / 0 FROM DECIMAL_UDF limit 1
@@ -991,14 +991,14 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (UDFToDouble(key) / null) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 1
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key / NULL FROM DECIMAL_UDF limit 1
@@ -1029,14 +1029,14 @@ STAGE PLANS:
TableScan
alias: decimal_udf
filterExpr: (key <> 0) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key <> 0) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (key / key) (type: decimal(38,18))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key / key FROM DECIMAL_UDF WHERE key is not null and key <> 0
@@ -1100,14 +1100,14 @@ STAGE PLANS:
TableScan
alias: decimal_udf
filterExpr: (value <> 0) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (value <> 0) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (key / CAST( value AS decimal(10,0))) (type: decimal(31,21))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1161,14 +1161,14 @@ STAGE PLANS:
TableScan
alias: decimal_udf
filterExpr: (value <> 0) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (value <> 0) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (UDFToDouble(key) / (UDFToDouble(value) / 2.0D)) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1221,11 +1221,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (1.0D + (UDFToDouble(key) / 2.0D)) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT 1 + (key / '2.0') FROM DECIMAL_UDF
@@ -1292,11 +1292,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: abs(key) (type: decimal(20,10))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT abs(key) FROM DECIMAL_UDF
@@ -1364,22 +1364,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: decimal(20,10)), value (type: int)
outputColumnNames: key, value
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(key), count(key)
keys: value (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 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: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: decimal(30,10)), _col2 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -1388,11 +1388,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), (_col1 / CAST( _col2 AS decimal(19,0))) (type: decimal(38,18)), (CAST( _col1 AS decimal(24,14)) / _col2) (type: decimal(38,28)), _col1 (type: decimal(30,10))
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -1407,17 +1407,17 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: decimal(38,18)), _col2 (type: decimal(38,28)), _col3 (type: decimal(30,10))
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: decimal(38,18)), VALUE._col1 (type: decimal(38,28)), VALUE._col2 (type: decimal(30,10))
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1472,11 +1472,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (- key) (type: decimal(20,10))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT -key FROM DECIMAL_UDF
@@ -1543,11 +1543,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: decimal(20,10))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT +key FROM DECIMAL_UDF
@@ -1614,11 +1614,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: ceil(key) (type: decimal(11,0))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT CEIL(key) FROM DECIMAL_UDF
@@ -1685,11 +1685,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: floor(key) (type: decimal(11,0))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT FLOOR(key) FROM DECIMAL_UDF
@@ -1756,11 +1756,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: round(key, 2) (type: decimal(13,2))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT ROUND(key, 2) FROM DECIMAL_UDF
@@ -1827,11 +1827,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: power(key, 2) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT POWER(key, 2) FROM DECIMAL_UDF
@@ -1898,11 +1898,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: ((key + 1) % (key / 2)) (type: decimal(22,12))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF
@@ -1969,22 +1969,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: value (type: int), key (type: decimal(20,10)), UDFToDouble(key) (type: double), (UDFToDouble(key) * UDFToDouble(key)) (type: double)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col3), sum(_col2), count(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 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: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double), _col2 (type: double), _col3 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -1993,14 +1993,14 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), power(((_col1 - ((_col2 * _col2) / _col3)) / _col3), 0.5) (type: double), ((_col1 - ((_col2 * _col2) / _col3)) / _col3) (type: double)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2055,22 +2055,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: value (type: int), key (type: decimal(20,10)), UDFToDouble(key) (type: double), (UDFToDouble(key) * UDFToDouble(key)) (type: double)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col3), sum(_col2), count(_col1)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 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: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double), _col2 (type: double), _col3 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -2079,14 +2079,14 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), power(((_col1 - ((_col2 * _col2) / _col3)) / CASE WHEN ((_col3 = 1L)) THEN (null) ELSE ((_col3 - 1)) END), 0.5) (type: double), ((_col1 - ((_col2 * _col2) / _col3)) / CASE WHEN ((_col3 = 1L)) THEN (null) ELSE ((_col3 - 1)) END) (type: double)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2141,29 +2141,29 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: decimal(20,10))
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: histogram_numeric(_col0, 3)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: array<double>)
Reduce Operator Tree:
Group By Operator
aggregations: histogram_numeric(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 720 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 832 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 720 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 832 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2202,19 +2202,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: decimal(20,10))
outputColumnNames: key
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: min(key)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: decimal(20,10))
Execution mode: vectorized
Reduce Operator Tree:
@@ -2222,10 +2222,10 @@ STAGE PLANS:
aggregations: min(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2264,19 +2264,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: decimal(20,10))
outputColumnNames: key
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: max(key)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: decimal(20,10))
Execution mode: vectorized
Reduce Operator Tree:
@@ -2284,10 +2284,10 @@ STAGE PLANS:
aggregations: max(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2326,19 +2326,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_udf
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: decimal(20,10))
outputColumnNames: key
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(key)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -2346,10 +2346,10 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 120 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/268a6e5a/ql/src/test/results/clientpositive/decimal_udf2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/decimal_udf2.q.out b/ql/src/test/results/clientpositive/decimal_udf2.q.out
index 482c05b..eb98a07 100644
--- a/ql/src/test/results/clientpositive/decimal_udf2.q.out
+++ b/ql/src/test/results/clientpositive/decimal_udf2.q.out
@@ -47,17 +47,17 @@ STAGE PLANS:
TableScan
alias: decimal_udf2
filterExpr: (key = 10) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 10) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: null (type: double), null (type: double), 1.4711276743037347D (type: double), -0.8390715290764524D (type: double), -0.5440211108893698D (type: double), 0.6483608274590866D (type: double), 0.17453292519943295D (type: double)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -110,17 +110,17 @@ STAGE PLANS:
TableScan
alias: decimal_udf2
filterExpr: (key = 10) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 10) (type: boolean)
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: 22026.465794806718D (type: double), 2.302585092994046D (type: double), 2.302585092994046D (type: double), 1.0D (type: double), log(10, value) (type: double), log(value, 10) (type: double), 1.0D (type: double), 3.1622776601683795D (type: double)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 116 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/268a6e5a/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out b/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out
index 930cdd2..56467f5 100644
--- a/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out
+++ b/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out
@@ -85,29 +85,29 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: uservisits_web_text_none_n0
- Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: sourceip (type: string), adrevenue (type: float), avgtimeonsite (type: int)
outputColumnNames: sourceip, adrevenue, avgtimeonsite
- Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(sourceip, 'hll'), compute_stats(avgtimeonsite, 'hll'), compute_stats(adrevenue, 'hll')
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 1288 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1480 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 1288 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1480 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,min:double,max:double,countnulls:bigint,bitvector:binary>)
Reduce Operator Tree:
Group By Operator
aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1), compute_stats(VALUE._col2)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1512 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1512 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -143,22 +143,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: uservisits_web_text_none_n0
- Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Statistics Aggregation Key Prefix: default.uservisits_web_text_none_n0/
GatherStats: true
Select Operator
expressions: sourceip (type: string), adrevenue (type: float), avgtimeonsite (type: int)
outputColumnNames: sourceip, adrevenue, avgtimeonsite
- Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(sourceip, 'hll'), compute_stats(avgtimeonsite, 'hll'), compute_stats(adrevenue, 'hll')
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 1288 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1480 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
null sort order:
sort order:
- Statistics: Num rows: 1 Data size: 1288 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1480 Basic stats: COMPLETE Column stats: NONE
tag: -1
value expressions: _col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,min:double,max:double,countnulls:bigint,bitvector:binary>)
auto parallelism: false
@@ -221,13 +221,13 @@ STAGE PLANS:
aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1), compute_stats(VALUE._col2)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1512 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1512 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -383,29 +383,29 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: empty_tab_n0
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 344 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: a (type: int), b (type: double), c (type: string), d (type: boolean), e (type: binary)
outputColumnNames: a, b, c, d, e
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 344 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(a, 'hll'), compute_stats(b, 'hll'), compute_stats(c, 'hll'), compute_stats(d, 'hll'), compute_stats(e, 'hll')
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1 Data size: 1848 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2192 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 1848 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2192 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,min:double,max:double,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col3 (type: struct<columntype:string,counttrues:bigint,countfalses:bigint,countnulls:bigint>), _col4 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint>)
Reduce Operator Tree:
Group By Operator
aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1), compute_stats(VALUE._col2), compute_stats(VALUE._col3), compute_stats(VALUE._col4)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1 Data size: 1880 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2224 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 1880 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2224 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/268a6e5a/ql/src/test/results/clientpositive/distinct_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/distinct_stats.q.out b/ql/src/test/results/clientpositive/distinct_stats.q.out
index 3192cb3..b2dfba6 100644
--- a/ql/src/test/results/clientpositive/distinct_stats.q.out
+++ b/ql/src/test/results/clientpositive/distinct_stats.q.out
@@ -46,36 +46,36 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n11
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: a (type: string), b (type: string)
outputColumnNames: a, b
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(DISTINCT b)
keys: a (type: string), b (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46500 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 46500 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col1:0._col0)
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col1 (type: bigint)
outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -107,31 +107,31 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n11
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: b (type: string)
outputColumnNames: b
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
keys: b (type: string)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 22750 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 22750 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: vectorized
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 22750 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 22750 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -163,22 +163,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n11
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: a (type: string)
outputColumnNames: a
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
keys: a (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -187,10 +187,10 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
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/268a6e5a/ql/src/test/results/clientpositive/distinct_windowing.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/distinct_windowing.q.out b/ql/src/test/results/clientpositive/distinct_windowing.q.out
index bffc841..27d74e0 100644
--- a/ql/src/test/results/clientpositive/distinct_windowing.q.out
+++ b/ql/src/test/results/clientpositive/distinct_windowing.q.out
@@ -65,19 +65,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k_n15
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 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: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
value expressions: t (type: tinyint)
Execution mode: vectorized
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: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -97,16 +97,16 @@ STAGE PLANS:
name: first_value
window function: GenericUDAFFirstValueEvaluator
window frame: RANGE PRECEDING(MAX)~CURRENT
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: first_value_window_0 (type: tinyint)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col0 (type: tinyint)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -122,7 +122,7 @@ STAGE PLANS:
key expressions: _col0 (type: tinyint)
sort order: +
Map-reduce partition columns: _col0 (type: tinyint)
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
Execution mode: vectorized
Reduce Operator Tree:
@@ -130,13 +130,13 @@ STAGE PLANS:
keys: KEY._col0 (type: tinyint)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -189,18 +189,18 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k_n15
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 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: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int)
outputColumnNames: _col1, _col2
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -220,16 +220,16 @@ STAGE PLANS:
name: last_value
window function: GenericUDAFLastValueEvaluator
window frame: RANGE PRECEDING(MAX)~CURRENT
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: last_value_window_0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -245,7 +245,7 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
Execution mode: vectorized
Reduce Operator Tree:
@@ -253,13 +253,13 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -316,19 +316,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k_n15
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 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: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
value expressions: t (type: tinyint)
Execution mode: vectorized
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: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -354,16 +354,16 @@ STAGE PLANS:
name: first_value
window function: GenericUDAFFirstValueEvaluator
window frame: RANGE PRECEDING(MAX)~CURRENT
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: last_value_window_0 (type: int), first_value_window_1 (type: tinyint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col0 (type: int), _col1 (type: tinyint)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -379,7 +379,7 @@ 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: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
Execution mode: vectorized
Reduce Operator Tree:
@@ -387,13 +387,13 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: tinyint)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 50
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat