You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2017/12/12 00:00:08 UTC
[10/51] [partial] hive git commit: HIVE-13567 : Enable auto-gather
column stats by default (Zoltan Haindrich,
Pengcheng Xiong via Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/3bbc24d2/ql/src/test/results/clientpositive/llap/load_dyn_part5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/load_dyn_part5.q.out b/ql/src/test/results/clientpositive/llap/load_dyn_part5.q.out
index 8b98b8e..7223808 100644
--- a/ql/src/test/results/clientpositive/llap/load_dyn_part5.q.out
+++ b/ql/src/test/results/clientpositive/llap/load_dyn_part5.q.out
@@ -36,6 +36,9 @@ STAGE PLANS:
Stage: Stage-1
Tez
#### A masked pattern was here ####
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
Vertices:
Map 1
Map Operator Tree:
@@ -54,8 +57,44 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.nzhang_part5
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string)
+ outputColumnNames: key, value
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
+ Group By Operator
+ aggregations: compute_stats(key, 'hll')
+ keys: value (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 250 Data size: 132750 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: 250 Data size: 132750 Basic stats: COMPLETE Column stats: COMPLETE
+ value expressions: _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
Execution mode: llap
LLAP IO: no inputs
+ Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: compute_stats(VALUE._col0)
+ keys: KEY._col0 (type: string)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 250 Data size: 132750 Basic stats: COMPLETE Column stats: COMPLETE
+ Select Operator
+ expressions: _col1 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col0 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 250 Data size: 132750 Basic stats: COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 250 Data size: 132750 Basic stats: COMPLETE Column stats: COMPLETE
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-2
Dependency Collection
@@ -75,6 +114,10 @@ STAGE PLANS:
Stage: Stage-3
Stats Work
Basic Stats Work:
+ Column Stats Desc:
+ Columns: key
+ Column Types: string
+ Table: default.nzhang_part5
PREHOOK: query: insert overwrite table nzhang_part5 partition (value) select key, value from src
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/3bbc24d2/ql/src/test/results/clientpositive/llap/mapjoin3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin3.q.out b/ql/src/test/results/clientpositive/llap/mapjoin3.q.out
index ccd0388..b8e9ec1 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin3.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin3.q.out
@@ -105,11 +105,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: member (type: bigint)
outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -119,14 +119,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col2, _col3
input vertices:
1 Map 2
- Statistics: Num rows: 3 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 540 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: bigint), _col2 (type: varchar(100)), _col3 (type: varchar(100))
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 3 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 540 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 3 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 540 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -137,16 +137,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test_1
- Statistics: Num rows: 3 Data size: 576 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 282 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: member (type: bigint), age (type: varchar(100)), age (type: varchar(100))
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 3 Data size: 576 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 540 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: bigint)
sort order: +
Map-reduce partition columns: _col0 (type: bigint)
- Statistics: Num rows: 3 Data size: 576 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 540 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: varchar(100)), _col2 (type: varchar(100))
Execution mode: llap
LLAP IO: no inputs
http://git-wip-us.apache.org/repos/asf/hive/blob/3bbc24d2/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin46.q.out b/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
index c4ce854..654b041 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
@@ -62,11 +62,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -76,10 +76,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -90,16 +90,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -162,11 +162,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -179,10 +179,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 857 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 857 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -193,19 +193,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key BETWEEN 100 AND 102 (type: boolean)
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -269,11 +269,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -286,10 +286,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 6 Data size: 2310 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1142 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 2310 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 1142 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -300,17 +300,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key BETWEEN 100 AND 102 (type: boolean)
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -370,16 +370,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -387,11 +387,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -401,10 +401,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
0 Map 1
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -465,11 +465,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -482,10 +482,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -496,14 +496,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -572,11 +572,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -587,10 +587,10 @@ STAGE PLANS:
input vertices:
1 Map 2
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -601,14 +601,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -680,11 +680,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -695,10 +695,10 @@ STAGE PLANS:
input vertices:
1 Map 2
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -709,14 +709,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -786,11 +786,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -801,10 +801,10 @@ STAGE PLANS:
input vertices:
1 Map 2
residual filter predicates: {((_col1 = _col4) or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -815,14 +815,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -888,11 +888,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -903,10 +903,10 @@ STAGE PLANS:
input vertices:
1 Map 2
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -917,16 +917,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -993,14 +993,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1008,11 +1008,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1023,10 +1023,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1101,14 +1101,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1116,11 +1116,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1131,10 +1131,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1204,14 +1204,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1219,11 +1219,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1234,10 +1234,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {((_col1 = _col4) or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1308,16 +1308,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1325,11 +1325,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1340,10 +1340,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1411,14 +1411,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1426,14 +1426,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1448,10 +1448,10 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1524,14 +1524,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1539,14 +1539,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1561,10 +1561,10 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1635,14 +1635,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1650,14 +1650,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1672,10 +1672,10 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
residual filter predicates: {((_col1 = _col4) or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1744,16 +1744,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1761,16 +1761,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1785,10 +1785,10 @@ STAGE PLANS:
1 _col1 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1711 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 1711 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1886,21 +1886,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -1911,10 +1911,10 @@ STAGE PLANS:
input vertices:
1 Map 4
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string), _col3 (type: int), _col4 (type: int), _col5 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1922,11 +1922,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -1937,10 +1937,10 @@ STAGE PLANS:
input vertices:
0 Map 1
residual filter predicates: {(_col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)}
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string), _col3 (type: int), _col4 (type: int), _col5 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1948,16 +1948,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -1972,10 +1972,10 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
residual filter predicates: {(_col1 is null or (_col10 is null and (_col7 <> _col4)))}
- Statistics: Num rows: 36 Data size: 15240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 64 Data size: 24440 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 36 Data size: 15240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 64 Data size: 24440 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/3bbc24d2/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
index 30239fa..0ffe74e 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
@@ -95,14 +95,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1049 Data size: 111776 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: dec (type: decimal(4,2))
outputColumnNames: _col0
- Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -112,11 +112,11 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
input vertices:
1 Map 3
- Statistics: Num rows: 1096 Data size: 116858 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1101 Data size: 246624 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: decimal(4,2))
sort order: +
- Statistics: Num rows: 1096 Data size: 116858 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1101 Data size: 246624 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: decimal(4,0))
Execution mode: llap
LLAP IO: all inputs
@@ -124,19 +124,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 1049 Data size: 111776 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: dec (type: decimal(4,0))
outputColumnNames: _col0
- Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: decimal(6,2))
sort order: +
Map-reduce partition columns: _col0 (type: decimal(6,2))
- Statistics: Num rows: 997 Data size: 106235 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
LLAP IO: all inputs
Reducer 2
@@ -145,10 +145,10 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: decimal(4,2)), VALUE._col0 (type: decimal(4,0))
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1096 Data size: 116858 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1101 Data size: 246624 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1096 Data size: 116858 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1101 Data size: 246624 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/3bbc24d2/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out
index 5468448..0cda68d 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin_emit_interval.q.out
@@ -62,11 +62,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -79,10 +79,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 1267 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 1524 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -93,16 +93,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -161,11 +161,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 6 Data size: 1152 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -178,10 +178,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
input vertices:
1 Map 2
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 9240 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 4580 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -192,14 +192,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: int), col_2 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 4 Data size: 768 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string)
Execution mode: llap
LLAP IO: no inputs
http://git-wip-us.apache.org/repos/asf/hive/blob/3bbc24d2/ql/src/test/results/clientpositive/llap/mapreduce1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapreduce1.q.out b/ql/src/test/results/clientpositive/llap/mapreduce1.q.out
index 7908e58..f777993 100644
--- a/ql/src/test/results/clientpositive/llap/mapreduce1.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapreduce1.q.out
@@ -34,6 +34,7 @@ STAGE PLANS:
#### A masked pattern was here ####
Edges:
Reducer 2 <- Map 1 (SIMPLE_EDGE)
+ Reducer 3 <- Reducer 2 (CUSTOM_SIMPLE_EDGE)
#### A masked pattern was here ####
Vertices:
Map 1
@@ -73,6 +74,34 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dest1
+ Select Operator
+ expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: string)
+ outputColumnNames: key, ten, one, value
+ Statistics: Num rows: 500 Data size: 51500 Basic stats: COMPLETE Column stats: COMPLETE
+ Group By Operator
+ aggregations: compute_stats(key, 'hll'), compute_stats(ten, 'hll'), compute_stats(one, 'hll'), compute_stats(value, 'hll')
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 1 Data size: 1712 Basic stats: COMPLETE Column stats: COMPLETE
+ Reduce Output Operator
+ sort order:
+ Statistics: Num rows: 1 Data size: 1712 Basic stats: COMPLETE Column stats: COMPLETE
+ value expressions: _col0 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col3 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
+ Reducer 3
+ Execution mode: llap
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1), compute_stats(VALUE._col2), compute_stats(VALUE._col3)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 1 Data size: 1760 Basic stats: COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 1760 Basic stats: COMPLETE Column stats: COMPLETE
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-2
Dependency Collection
@@ -90,6 +119,10 @@ STAGE PLANS:
Stage: Stage-3
Stats Work
Basic Stats Work:
+ Column Stats Desc:
+ Columns: key, ten, one, value
+ Column Types: int, int, int, string
+ Table: default.dest1
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1
http://git-wip-us.apache.org/repos/asf/hive/blob/3bbc24d2/ql/src/test/results/clientpositive/llap/mapreduce2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapreduce2.q.out b/ql/src/test/results/clientpositive/llap/mapreduce2.q.out
index d468e1e..a333468 100644
--- a/ql/src/test/results/clientpositive/llap/mapreduce2.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapreduce2.q.out
@@ -32,6 +32,7 @@ STAGE PLANS:
#### A masked pattern was here ####
Edges:
Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
+ Reducer 3 <- Reducer 2 (CUSTOM_SIMPLE_EDGE)
#### A masked pattern was here ####
Vertices:
Map 1
@@ -70,6 +71,34 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dest1
+ Select Operator
+ expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: string)
+ outputColumnNames: key, ten, one, value
+ Statistics: Num rows: 500 Data size: 51500 Basic stats: COMPLETE Column stats: COMPLETE
+ Group By Operator
+ aggregations: compute_stats(key, 'hll'), compute_stats(ten, 'hll'), compute_stats(one, 'hll'), compute_stats(value, 'hll')
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 1 Data size: 1712 Basic stats: COMPLETE Column stats: COMPLETE
+ Reduce Output Operator
+ sort order:
+ Statistics: Num rows: 1 Data size: 1712 Basic stats: COMPLETE Column stats: COMPLETE
+ value expressions: _col0 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col3 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
+ Reducer 3
+ Execution mode: llap
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1), compute_stats(VALUE._col2), compute_stats(VALUE._col3)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 1 Data size: 1760 Basic stats: COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 1760 Basic stats: COMPLETE Column stats: COMPLETE
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-2
Dependency Collection
@@ -87,6 +116,10 @@ STAGE PLANS:
Stage: Stage-3
Stats Work
Basic Stats Work:
+ Column Stats Desc:
+ Columns: key, ten, one, value
+ Column Types: int, int, int, string
+ Table: default.dest1
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1