You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by kg...@apache.org on 2017/12/20 10:40:31 UTC
[30/37] hive git commit: HIVE-18149: Stats: rownum estimation from
datasize underestimates in most cases (Zoltan Haindrich,
reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/join_reorder2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_reorder2.q.out b/ql/src/test/results/clientpositive/join_reorder2.q.out
index aaf3b94..7d93aae 100644
--- a/ql/src/test/results/clientpositive/join_reorder2.q.out
+++ b/ql/src/test/results/clientpositive/join_reorder2.q.out
@@ -84,51 +84,51 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
TableScan
alias: d
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
Reduce Operator Tree:
Join Operator
@@ -142,14 +142,14 @@ STAGE PLANS:
2 key (type: string)
3 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
- Statistics: Num rows: 3 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 990 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
- Statistics: Num rows: 3 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 990 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 3 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 990 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -206,27 +206,27 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key + 1) is not null and key is not null and val is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key + 1) is not null and key is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
Reduce Operator Tree:
Join Operator
@@ -236,7 +236,7 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
- Statistics: Num rows: 1 Data size: 33 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 330 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -252,19 +252,19 @@ STAGE PLANS:
key expressions: _col1 (type: string)
sort order: +
Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 1 Data size: 33 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 330 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col5 (type: string), _col6 (type: string)
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: val is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: val (type: string)
sort order: +
Map-reduce partition columns: val (type: string)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
@@ -274,7 +274,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 val (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
- Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 363 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -290,19 +290,19 @@ STAGE PLANS:
key expressions: (_col0 + 1) (type: double)
sort order: +
Map-reduce partition columns: (_col0 + 1) (type: double)
- Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 363 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
TableScan
alias: d
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key + 1) is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: (key + 1) (type: double)
sort order: +
Map-reduce partition columns: (key + 1) (type: double)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: string), val (type: string)
Reduce Operator Tree:
Join Operator
@@ -312,14 +312,14 @@ STAGE PLANS:
0 (_col0 + 1) (type: double)
1 (key + 1) (type: double)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
- Statistics: Num rows: 1 Data size: 39 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 399 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
- Statistics: Num rows: 1 Data size: 39 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 399 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 39 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 399 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/join_reorder3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_reorder3.q.out b/ql/src/test/results/clientpositive/join_reorder3.q.out
index 36f0da4..898134e 100644
--- a/ql/src/test/results/clientpositive/join_reorder3.q.out
+++ b/ql/src/test/results/clientpositive/join_reorder3.q.out
@@ -84,51 +84,51 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
TableScan
alias: d
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
Reduce Operator Tree:
Join Operator
@@ -142,14 +142,14 @@ STAGE PLANS:
2 key (type: string)
3 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
- Statistics: Num rows: 3 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 990 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
- Statistics: Num rows: 3 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 990 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 3 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 990 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -206,27 +206,27 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key + 1) is not null and key is not null and val is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key + 1) is not null and key is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val (type: string)
Reduce Operator Tree:
Join Operator
@@ -236,7 +236,7 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
- Statistics: Num rows: 1 Data size: 33 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 330 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -252,19 +252,19 @@ STAGE PLANS:
key expressions: _col1 (type: string)
sort order: +
Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 1 Data size: 33 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 330 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col5 (type: string), _col6 (type: string)
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: val is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: val (type: string)
sort order: +
Map-reduce partition columns: val (type: string)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
@@ -274,7 +274,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 val (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
- Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 363 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -290,19 +290,19 @@ STAGE PLANS:
key expressions: (_col0 + 1) (type: double)
sort order: +
Map-reduce partition columns: (_col0 + 1) (type: double)
- Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 363 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
TableScan
alias: d
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key + 1) is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: (key + 1) (type: double)
sort order: +
Map-reduce partition columns: (key + 1) (type: double)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: string), val (type: string)
Reduce Operator Tree:
Join Operator
@@ -312,14 +312,14 @@ STAGE PLANS:
0 (_col0 + 1) (type: double)
1 (key + 1) (type: double)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
- Statistics: Num rows: 1 Data size: 39 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 399 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
- Statistics: Num rows: 1 Data size: 39 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 399 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 39 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 399 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/join_reorder4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_reorder4.q.out b/ql/src/test/results/clientpositive/join_reorder4.q.out
index bbc1d86..faa1372 100644
--- a/ql/src/test/results/clientpositive/join_reorder4.q.out
+++ b/ql/src/test/results/clientpositive/join_reorder4.q.out
@@ -60,39 +60,39 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key1 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key1 (type: string)
sort order: +
Map-reduce partition columns: key1 (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val1 (type: string)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key2 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key2 (type: string)
sort order: +
Map-reduce partition columns: key2 (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val2 (type: string)
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key3 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key3 (type: string)
sort order: +
Map-reduce partition columns: key3 (type: string)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
value expressions: val3 (type: string)
Reduce Operator Tree:
Join Operator
@@ -104,14 +104,14 @@ STAGE PLANS:
1 key2 (type: string)
2 key3 (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
- Statistics: Num rows: 2 Data size: 66 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 660 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 66 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 660 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 66 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 660 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -150,39 +150,39 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key1 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key1 (type: string)
sort order: +
Map-reduce partition columns: key1 (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val1 (type: string)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key2 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key2 (type: string)
sort order: +
Map-reduce partition columns: key2 (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val2 (type: string)
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key3 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key3 (type: string)
sort order: +
Map-reduce partition columns: key3 (type: string)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
value expressions: val3 (type: string)
Reduce Operator Tree:
Join Operator
@@ -194,14 +194,14 @@ STAGE PLANS:
1 key2 (type: string)
2 key3 (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
- Statistics: Num rows: 2 Data size: 66 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 660 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 66 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 660 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 66 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 660 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -240,39 +240,39 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key1 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key1 (type: string)
sort order: +
Map-reduce partition columns: key1 (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val1 (type: string)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key2 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key2 (type: string)
sort order: +
Map-reduce partition columns: key2 (type: string)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
value expressions: val2 (type: string)
TableScan
alias: c
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key3 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key3 (type: string)
sort order: +
Map-reduce partition columns: key3 (type: string)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
value expressions: val3 (type: string)
Reduce Operator Tree:
Join Operator
@@ -284,14 +284,14 @@ STAGE PLANS:
1 key2 (type: string)
2 key3 (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
- Statistics: Num rows: 2 Data size: 66 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 660 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 2 Data size: 66 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 660 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 66 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 660 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/join_star.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_star.q.out b/ql/src/test/results/clientpositive/join_star.q.out
index 1215fbb..d6c64bb 100644
--- a/ql/src/test/results/clientpositive/join_star.q.out
+++ b/ql/src/test/results/clientpositive/join_star.q.out
@@ -146,14 +146,14 @@ STAGE PLANS:
$hdt$_1:dim1
TableScan
alias: dim1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: f1 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f1 (type: int), f2 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col2 (type: int)
@@ -164,14 +164,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: fact
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: d1 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: m1 (type: int), m2 (type: int), d1 (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -179,14 +179,14 @@ STAGE PLANS:
0 _col2 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col4
- Statistics: Num rows: 1 Data size: 107 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1078 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col4 (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 107 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1078 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 107 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1078 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -243,14 +243,14 @@ STAGE PLANS:
$hdt$_1:dim1
TableScan
alias: dim1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: f1 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f1 (type: int), f2 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col2 (type: int)
@@ -258,14 +258,14 @@ STAGE PLANS:
$hdt$_2:dim2
TableScan
alias: dim2
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: f3 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f3 (type: int), f4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col3 (type: int)
@@ -276,14 +276,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: fact
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (d1 is not null and d2 is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: m1 (type: int), m2 (type: int), d1 (type: int), d2 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -291,7 +291,7 @@ STAGE PLANS:
0 _col2 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3, _col5
- Statistics: Num rows: 1 Data size: 107 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1078 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -299,14 +299,14 @@ STAGE PLANS:
0 _col3 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col5, _col7
- Statistics: Num rows: 1 Data size: 117 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1185 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int), _col7 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 117 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1185 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 117 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1185 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -365,14 +365,14 @@ STAGE PLANS:
$hdt$_0:dim1
TableScan
alias: dim1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (f1 is not null and f2 is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f1 (type: int), f2 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col1 (type: int)
@@ -380,14 +380,14 @@ STAGE PLANS:
$hdt$_2:fact
TableScan
alias: fact
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: d1 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: m1 (type: int), m2 (type: int), d1 (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col0 (type: int)
@@ -398,14 +398,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: dim2
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: f3 is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f3 (type: int), f4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -413,7 +413,7 @@ STAGE PLANS:
0 _col1 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 1 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 176 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -421,14 +421,14 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col2 (type: int)
outputColumnNames: _col1, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 18 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 193 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col4 (type: int), _col5 (type: int), _col1 (type: int), _col3 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 18 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 193 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 18 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 193 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -487,11 +487,11 @@ STAGE PLANS:
$hdt$_1:dim1
TableScan
alias: dim1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f1 (type: int), f2 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col2 (type: int)
@@ -499,11 +499,11 @@ STAGE PLANS:
$hdt$_2:dim2
TableScan
alias: dim2
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f3 (type: int), f4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col4 (type: int)
@@ -514,11 +514,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: fact
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: m1 (type: int), m2 (type: int), d1 (type: int)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -526,7 +526,7 @@ STAGE PLANS:
0 _col2 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col4
- Statistics: Num rows: 1 Data size: 107 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1078 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -534,14 +534,14 @@ STAGE PLANS:
0 _col4 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col4, _col6
- Statistics: Num rows: 1 Data size: 117 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1185 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col4 (type: int), _col6 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 117 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1185 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 117 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1185 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -631,11 +631,11 @@ STAGE PLANS:
$hdt$_1:dim1
TableScan
alias: dim1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f1 (type: int), f2 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col2 (type: int)
@@ -643,11 +643,11 @@ STAGE PLANS:
$hdt$_2:dim2
TableScan
alias: dim2
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f3 (type: int), f4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col5 (type: int)
@@ -655,11 +655,11 @@ STAGE PLANS:
$hdt$_3:dim3
TableScan
alias: dim3
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f5 (type: int), f6 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col3 (type: int)
@@ -667,11 +667,11 @@ STAGE PLANS:
$hdt$_4:dim4
TableScan
alias: dim4
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f7 (type: int), f8 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col9 (type: int)
@@ -679,11 +679,11 @@ STAGE PLANS:
$hdt$_5:dim5
TableScan
alias: dim5
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f9 (type: int), f10 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col11 (type: int)
@@ -691,11 +691,11 @@ STAGE PLANS:
$hdt$_6:dim6
TableScan
alias: dim6
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f11 (type: int), f12 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col9 (type: int)
@@ -703,11 +703,11 @@ STAGE PLANS:
$hdt$_7:dim7
TableScan
alias: dim7
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: f13 (type: int), f14 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 160 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col15 (type: int)
@@ -718,11 +718,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: fact
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: m1 (type: int), m2 (type: int), d1 (type: int), d2 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 98 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 980 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -730,7 +730,7 @@ STAGE PLANS:
0 _col2 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3, _col5
- Statistics: Num rows: 1 Data size: 107 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1078 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -738,7 +738,7 @@ STAGE PLANS:
0 _col5 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3, _col5, _col7
- Statistics: Num rows: 1 Data size: 117 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1185 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -746,7 +746,7 @@ STAGE PLANS:
0 _col3 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col5, _col7, _col9
- Statistics: Num rows: 1 Data size: 128 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1303 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -754,7 +754,7 @@ STAGE PLANS:
0 _col9 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col5, _col7, _col9, _col11
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1433 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -762,7 +762,7 @@ STAGE PLANS:
0 _col11 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col5, _col7, _col9, _col11, _col13
- Statistics: Num rows: 1 Data size: 154 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1576 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -770,7 +770,7 @@ STAGE PLANS:
0 _col9 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col5, _col7, _col9, _col11, _col13, _col15
- Statistics: Num rows: 1 Data size: 169 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1733 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -778,14 +778,14 @@ STAGE PLANS:
0 _col15 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col5, _col7, _col9, _col11, _col13, _col15, _col17
- Statistics: Num rows: 1 Data size: 185 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1906 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int), _col7 (type: int), _col9 (type: int), _col11 (type: int), _col13 (type: int), _col15 (type: int), _col17 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 1 Data size: 185 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1906 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 185 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1906 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/join_thrift.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_thrift.q.out b/ql/src/test/results/clientpositive/join_thrift.q.out
index b05d0e3..8748a5b 100644
--- a/ql/src/test/results/clientpositive/join_thrift.q.out
+++ b/ql/src/test/results/clientpositive/join_thrift.q.out
@@ -36,26 +36,26 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
- Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: aint is not null (type: boolean)
- Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: aint (type: int)
sort order: +
Map-reduce partition columns: aint (type: int)
- Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: s2
- Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: aint is not null (type: boolean)
- Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: aint (type: int)
sort order: +
Map-reduce partition columns: aint (type: int)
- Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE
value expressions: lintstring (type: array<struct<myint:int,mystring:string,underscore_int:int>>)
Reduce Operator Tree:
Join Operator
@@ -65,14 +65,14 @@ STAGE PLANS:
0 aint (type: int)
1 aint (type: int)
outputColumnNames: _col0, _col17
- Statistics: Num rows: 12 Data size: 3377 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 33770 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col17 (type: array<struct<myint:int,mystring:string,underscore_int:int>>)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 12 Data size: 3377 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 33770 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 12 Data size: 3377 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 33770 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
index c14441a..0fda4c1 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
@@ -421,14 +421,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: d
- Statistics: Num rows: 1 Data size: 178 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 1708 Basic stats: PARTIAL Column stats: COMPLETE
GatherStats: false
Select Operator
- Statistics: Num rows: 1 Data size: 178 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 1708 Basic stats: PARTIAL Column stats: COMPLETE
Reduce Output Operator
null sort order:
sort order:
- Statistics: Num rows: 1 Data size: 178 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 1708 Basic stats: PARTIAL Column stats: COMPLETE
tag: 1
auto parallelism: false
Execution mode: llap
@@ -498,7 +498,7 @@ STAGE PLANS:
0
1
Position of Big Table: 0
- Statistics: Num rows: 244 Data size: 87057 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 244 Data size: 460377 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: count()
mode: hash