You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by vg...@apache.org on 2017/09/25 20:59:51 UTC
[05/23] hive git commit: HIVE-17536 : StatsUtil::getBasicStatForTable
doesn't distinguish b/w absence of statistics or zero stats (Vineet Garg,
reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/subquery_in_having.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/subquery_in_having.q.out b/ql/src/test/results/clientpositive/subquery_in_having.q.out
index 627d1b4..8ccc185 100644
--- a/ql/src/test/results/clientpositive/subquery_in_having.q.out
+++ b/ql/src/test/results/clientpositive/subquery_in_having.q.out
@@ -279,21 +279,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_mfgr is not null (type: boolean)
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: avg(p_size)
keys: p_mfgr (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 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: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: struct<count:bigint,sum:double,input:int>)
Reduce Operator Tree:
Group By Operator
@@ -301,7 +301,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 15 Data size: 1586 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -317,14 +317,14 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 15 Data size: 1586 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 528 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -333,10 +333,10 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -347,21 +347,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_subq
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_mfgr is not null (type: boolean)
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: max(p_size), min(p_size)
keys: p_mfgr (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 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: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: int)
Reduce Operator Tree:
Group By Operator
@@ -369,14 +369,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 15 Data size: 1586 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((_col1 - _col2) < 20) (type: boolean)
- Statistics: Num rows: 5 Data size: 528 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 528 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -422,51 +422,51 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_mfgr is not null (type: boolean)
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: avg(p_size)
keys: p_mfgr (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 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: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: struct<count:bigint,sum:double,input:int>)
TableScan
alias: part_subq
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_mfgr is not null (type: boolean)
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: max(p_size), min(p_size)
keys: p_mfgr (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 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: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: int)
Reduce Operator Tree:
Demux Operator
- Statistics: Num rows: 60 Data size: 6346 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 6346 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: avg(VALUE._col0)
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Mux Operator
- Statistics: Num rows: 40 Data size: 4230 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 6346 Basic stats: COMPLETE Column stats: NONE
Join Operator
condition map:
Inner Join 0 to 1
@@ -487,16 +487,16 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((_col1 - _col2) < 20) (type: boolean)
- Statistics: Num rows: 10 Data size: 1057 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 10 Data size: 1057 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Mux Operator
- Statistics: Num rows: 40 Data size: 4230 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 6346 Basic stats: COMPLETE Column stats: NONE
Join Operator
condition map:
Inner Join 0 to 1
@@ -1584,21 +1584,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_subq
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: avg(p_size)
keys: p_name (type: string), p_mfgr (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
value expressions: _col2 (type: struct<count:bigint,sum:double,input:int>)
Reduce Operator Tree:
Group By Operator
@@ -1606,11 +1606,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 7 Data size: 1480 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col0 (type: string), _col2 (type: double)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 7 Data size: 1480 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -1646,10 +1646,10 @@ STAGE PLANS:
0 _col1 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1665,14 +1665,14 @@ STAGE PLANS:
key expressions: _col1 (type: string)
sort order: +
Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 7 Data size: 1480 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col2 (type: double)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -1681,10 +1681,10 @@ STAGE PLANS:
0 _col1 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1695,18 +1695,18 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_subq
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: p_mfgr (type: string), p_size (type: int)
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
value expressions: p_name (type: string)
Reduce Operator Tree:
Select Operator
expressions: VALUE._col1 (type: string), KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: int)
outputColumnNames: _col1, _col2, _col5
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -1726,19 +1726,19 @@ STAGE PLANS:
name: first_value
window function: GenericUDAFFirstValueEvaluator
window frame: RANGE PRECEDING(MAX)~CURRENT
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: first_value_window_0 is not null (type: boolean)
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: first_value_window_0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -1834,30 +1834,30 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_null
- Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
- Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: value (type: string)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 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: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), true (type: boolean)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -1887,11 +1887,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -1900,20 +1900,20 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3
residual filter predicates: {(_col1 <> _col2)}
- Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col3 is null (type: boolean)
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: _col1 (type: string), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -1931,7 +1931,7 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -1939,11 +1939,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col0 (type: string), _col2 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -1979,7 +1979,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col4, _col5
- Statistics: Num rows: 259 Data size: 130759 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12805 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -1997,19 +1997,19 @@ STAGE PLANS:
key expressions: _col1 (type: string), _col2 (type: bigint)
sort order: ++
Map-reduce partition columns: _col1 (type: string), _col2 (type: bigint)
- Statistics: Num rows: 259 Data size: 130759 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12805 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col4 (type: bigint), _col5 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
- Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Demux Operator
- Statistics: Num rows: 731 Data size: 368503 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 30267 Basic stats: COMPLETE Column stats: NONE
Mux Operator
- Statistics: Num rows: 1096 Data size: 552502 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 45400 Basic stats: COMPLETE Column stats: NONE
Join Operator
condition map:
Left Outer Join 0 to 1
@@ -2036,20 +2036,20 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: bigint)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 365 Data size: 183999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 15133 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: bigint), _col0 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 365 Data size: 183999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 15133 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col0 is not null (type: boolean)
- Statistics: Num rows: 365 Data size: 183999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 15133 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: bigint), _col1 (type: string), true (type: boolean)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 365 Data size: 183999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 15133 Basic stats: COMPLETE Column stats: NONE
Mux Operator
- Statistics: Num rows: 1096 Data size: 552502 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 45400 Basic stats: COMPLETE Column stats: NONE
Join Operator
condition map:
Left Outer Join 0 to 1
@@ -2081,14 +2081,14 @@ STAGE PLANS:
key expressions: _col1 (type: string)
sort order: +
Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col2 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 236 Data size: 118872 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: bigint)
Reduce Operator Tree:
Join Operator
@@ -2098,7 +2098,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col4, _col5
- Statistics: Num rows: 259 Data size: 130759 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 12805 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2111,19 +2111,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string)
TableScan
Reduce Output Operator
sort order:
- Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: boolean)
Reduce Operator Tree:
Join Operator
@@ -2134,20 +2134,20 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3
residual filter predicates: {(_col1 <> _col2)}
- Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col3 is null (type: boolean)
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: _col1 (type: string), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2160,30 +2160,30 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_null
- Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
- Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: value (type: string)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 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: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), true (type: boolean)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2213,11 +2213,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -2226,19 +2226,19 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3
residual filter predicates: {(_col1 <> _col2)}
- Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col3 is null (type: boolean)
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col1 (type: string), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2256,22 +2256,22 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col1
- Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col1 (type: string)
mode: complete
outputColumnNames: _col0
- Statistics: Num rows: 105 Data size: 31713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2289,14 +2289,14 @@ STAGE PLANS:
$hdt$_1:$hdt$_1:$hdt$_1:s1
TableScan
alias: s1
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key > '9') (type: boolean)
- Statistics: Num rows: 9 Data size: 1806 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 9 Data size: 1806 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0
@@ -2313,25 +2313,25 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col1 <> _col2) (type: boolean)
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col2
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: _col2 (type: string), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
value expressions: _col2 (type: bigint)
Local Work:
Map Reduce Local Work
@@ -2341,17 +2341,17 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col2 (type: bigint)
outputColumnNames: _col1, _col2
- Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(), count(_col2)
keys: _col1 (type: string)
mode: complete
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 236 Data size: 118872 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2364,19 +2364,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string)
TableScan
Reduce Output Operator
sort order:
- Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: boolean)
Reduce Operator Tree:
Join Operator
@@ -2387,19 +2387,19 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3
residual filter predicates: {(_col1 <> _col2)}
- Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col3 is null (type: boolean)
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col1 (type: string), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2412,30 +2412,30 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_null
- Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
- Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: value (type: string)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 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: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), true (type: boolean)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2465,11 +2465,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -2478,19 +2478,19 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3
residual filter predicates: {(_col1 <> _col2)}
- Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col3 is null (type: boolean)
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col1 (type: string), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2508,22 +2508,22 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col1
- Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col1 (type: string)
mode: complete
outputColumnNames: _col0
- Statistics: Num rows: 105 Data size: 31713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2541,14 +2541,14 @@ STAGE PLANS:
$hdt$_2:$hdt$_2:$hdt$_2:$hdt$_2:$hdt$_2:s1
TableScan
alias: s1
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key > '9') (type: boolean)
- Statistics: Num rows: 9 Data size: 1806 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 9 Data size: 1806 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0
@@ -2565,25 +2565,25 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col1 <> _col2) (type: boolean)
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col2
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: _col2 (type: string), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
value expressions: _col2 (type: bigint)
Local Work:
Map Reduce Local Work
@@ -2593,16 +2593,16 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col2 (type: bigint)
outputColumnNames: _col1, _col2
- Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col1 (type: string), _col2 (type: bigint)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -2615,19 +2615,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string)
TableScan
Reduce Output Operator
sort order:
- Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: boolean)
Reduce Operator Tree:
Join Operator
@@ -2638,19 +2638,19 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3
residual filter predicates: {(_col1 <> _col2)}
- Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: _col3 is null (type: boolean)
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col1 (type: string), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out
index 7cb8335..8ea8ac7 100644
--- a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out
@@ -667,11 +667,11 @@ Stage-3
Map 1
File Output Operator [FS_3]
table:{"name:":"default.orc_merge5"}
- Select Operator [SEL_2] (rows=306/3 width=335)
+ Select Operator [SEL_2] (rows=1/3 width=352)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Filter Operator [FIL_4] (rows=306/3 width=335)
+ Filter Operator [FIL_4] (rows=1/3 width=352)
predicate:(userid <= 13)
- TableScan [TS_0] (rows=919/15000 width=335)
+ TableScan [TS_0] (rows=1/15000 width=352)
default@orc_merge5,orc_merge5,Tbl:COMPLETE,Col:NONE,Output:["userid","string1","subtype","decimal1","ts"]
Stage-4(CONDITIONAL)
File Merge
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out
index ce94316..7f43645 100644
--- a/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out
@@ -296,16 +296,16 @@ Stage-3
Reducer 2
File Output Operator [FS_8]
table:{"name:":"default.acid_uami"}
- Select Operator [SEL_4] (rows=4/2 width=302)
+ Select Operator [SEL_4] (rows=1/2 width=302)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_3]
PartitionCols:UDFToInteger(_col0)
- Select Operator [SEL_2] (rows=4/2 width=302)
+ Select Operator [SEL_2] (rows=1/2 width=302)
Output:["_col0","_col1","_col3"]
- Filter Operator [FIL_9] (rows=4/2 width=226)
+ Filter Operator [FIL_9] (rows=1/2 width=226)
predicate:((de = 109.23) or (de = 119.23))
- TableScan [TS_0] (rows=8/4 width=226)
+ TableScan [TS_0] (rows=1/4 width=226)
default@acid_uami,acid_uami, ACID table,Tbl:COMPLETE,Col:COMPLETE,Output:["i","de","vc"]
PREHOOK: query: select * from acid_uami order by de
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/tez/explainuser_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out
index d26a9a3..a331bf7 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out
@@ -511,11 +511,11 @@ Stage-3
Map 1 vectorized
File Output Operator [FS_10]
table:{"name:":"default.orc_merge5"}
- Select Operator [SEL_9] (rows=306 width=335)
+ Select Operator [SEL_9] (rows=1 width=352)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Filter Operator [FIL_8] (rows=306 width=335)
+ Filter Operator [FIL_8] (rows=1 width=352)
predicate:(userid <= 13)
- TableScan [TS_0] (rows=919 width=335)
+ TableScan [TS_0] (rows=1 width=352)
default@orc_merge5,orc_merge5,Tbl:COMPLETE,Col:NONE,Output:["userid","string1","subtype","decimal1","ts"]
Stage-4(CONDITIONAL)
File Merge
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out b/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out
index ff6942a..546934c 100644
--- a/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out
+++ b/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out
@@ -510,11 +510,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket
- Statistics: Num rows: 726 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: CASE WHEN ((key < 100.0)) THEN (NaN) ELSE (key) END (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 726 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: percentile_approx(_col0, 0.5)
mode: hash
@@ -569,11 +569,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket
- Statistics: Num rows: 726 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 726 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: percentile_approx(_col0, 0.5)
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/udf_trunc_number.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_trunc_number.q.out b/ql/src/test/results/clientpositive/udf_trunc_number.q.out
index dfc9d70..1bdab02 100644
--- a/ql/src/test/results/clientpositive/udf_trunc_number.q.out
+++ b/ql/src/test/results/clientpositive/udf_trunc_number.q.out
@@ -69,11 +69,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: sampletable
- Statistics: Num rows: 4 Data size: 50 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: trunc(c, d) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 50 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: select trunc (c,d) from sampletable
@@ -124,11 +124,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: sampletable1
- Statistics: Num rows: 6 Data size: 50 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: trunc(c, d) (type: float)
outputColumnNames: _col0
- Statistics: Num rows: 6 Data size: 50 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: select trunc (c,d) from sampletable1
@@ -179,11 +179,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: sampletable2
- Statistics: Num rows: 3 Data size: 50 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: trunc(c, d) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 50 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: select trunc (c,d) from sampletable2
@@ -234,11 +234,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: sampletable3
- Statistics: Num rows: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: trunc(c, d) (type: bigint)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: select trunc (c,d) from sampletable3
@@ -289,11 +289,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: sampletable4
- Statistics: Num rows: 3 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: trunc(c, d) (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: select trunc (c,d) from sampletable4
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out b/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out
index ecf866a..beb01b4 100644
--- a/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out
+++ b/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out
@@ -399,7 +399,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
@@ -412,7 +412,7 @@ STAGE PLANS:
native: false
nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
- Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Execution mode: vectorized
Map Vectorization:
enabled: true
@@ -435,7 +435,7 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: tinyint), KEY.reducesinkkey3 (type: smallint), KEY.reducesinkkey4 (type: float), KEY.reducesinkkey1 (type: boolean), KEY.reducesinkkey2 (type: string)
outputColumnNames: _col0, _col1, _col4, _col6, _col7
- Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -456,17 +456,17 @@ STAGE PLANS:
window function: GenericUDAFLeadEvaluator
window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX)
isPivotResult: true
- Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col7 (type: string), _col1 (type: smallint), _col4 (type: float), (UDFToFloat(_col1) - lead_window_0) (type: float)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 100
- Statistics: Num rows: 100 Data size: 11600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 100 Data size: 11600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -608,7 +608,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
@@ -621,7 +621,7 @@ STAGE PLANS:
native: false
nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
- Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Execution mode: vectorized
Map Vectorization:
enabled: true
@@ -644,7 +644,7 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: string)
outputColumnNames: _col1, _col2, _col7
- Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -665,17 +665,17 @@ STAGE PLANS:
window function: GenericUDAFLeadEvaluator
window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX)
isPivotResult: true
- Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col7 (type: string), _col2 (type: int), (_col2 - lead_window_0) (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 100
- Statistics: Num rows: 100 Data size: 10800 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 100 Data size: 10800 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -817,7 +817,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
@@ -830,7 +830,7 @@ STAGE PLANS:
native: false
nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
- Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Execution mode: vectorized
Map Vectorization:
enabled: true
@@ -853,7 +853,7 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey1 (type: smallint), KEY.reducesinkkey0 (type: bigint), KEY.reducesinkkey3 (type: double), KEY.reducesinkkey2 (type: string)
outputColumnNames: _col1, _col3, _col5, _col7
- Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -874,17 +874,17 @@ STAGE PLANS:
window function: GenericUDAFLagEvaluator
window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX)
isPivotResult: true
- Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col7 (type: string), _col1 (type: smallint), _col5 (type: double), (UDFToDouble(_col1) - lag_window_0) (type: double)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 100
- Statistics: Num rows: 100 Data size: 12000 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 100 Data size: 12000 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1026,7 +1026,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
@@ -1039,7 +1039,7 @@ STAGE PLANS:
native: false
nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
- Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
value expressions: s (type: string)
Execution mode: vectorized
Map Vectorization:
@@ -1063,7 +1063,7 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey1 (type: bigint), KEY.reducesinkkey0 (type: float), VALUE._col5 (type: string)
outputColumnNames: _col3, _col4, _col7
- Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -1084,17 +1084,17 @@ STAGE PLANS:
window function: GenericUDAFLagEvaluator
window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX)
isPivotResult: true
- Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col7 (type: string), lag_window_0 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 100
- Statistics: Num rows: 100 Data size: 11200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 100 Data size: 11200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1519,7 +1519,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: over10k
- Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
@@ -1532,7 +1532,7 @@ STAGE PLANS:
native: false
nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
- Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
value expressions: s (type: string)
Execution mode: vectorized
Map Vectorization:
@@ -1556,7 +1556,7 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey1 (type: int), VALUE._col6 (type: string), KEY.reducesinkkey0 (type: timestamp)
outputColumnNames: _col2, _col7, _col8
- Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -1576,18 +1576,18 @@ STAGE PLANS:
name: sum
window function: GenericUDAFSumLong
window frame: RANGE PRECEDING(MAX)~CURRENT
- Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: sum_window_0 (type: bigint), _col7 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: UDFToInteger(_col0) (type: int), _col1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1596,10 +1596,10 @@ STAGE PLANS:
Select Operator
expressions: UDFToInteger(_col0) (type: int), _col1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat