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:37 UTC
[36/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/beeline/select_dummy_source.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/select_dummy_source.q.out b/ql/src/test/results/clientpositive/beeline/select_dummy_source.q.out
index b3ca623..ee07e64 100644
--- a/ql/src/test/results/clientpositive/beeline/select_dummy_source.q.out
+++ b/ql/src/test/results/clientpositive/beeline/select_dummy_source.q.out
@@ -15,7 +15,7 @@ STAGE PLANS:
TableScan
alias: _dummy_table
Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: 'a' (type: string), 100 (type: int)
outputColumnNames: _col0, _col1
@@ -48,7 +48,7 @@ STAGE PLANS:
TableScan
alias: _dummy_table
Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: 2 (type: int)
outputColumnNames: _col0
@@ -81,7 +81,7 @@ STAGE PLANS:
TableScan
alias: _dummy_table
Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: array('a','b') (type: array<string>)
outputColumnNames: _col0
@@ -134,7 +134,7 @@ STAGE PLANS:
TableScan
alias: _dummy_table
Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: 'a' (type: string), 100 (type: int)
outputColumnNames: _col0, _col1
@@ -167,7 +167,7 @@ STAGE PLANS:
TableScan
alias: _dummy_table
Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: 2 (type: int)
outputColumnNames: _col0
@@ -200,7 +200,7 @@ STAGE PLANS:
TableScan
alias: _dummy_table
Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: array('a','b') (type: array<string>)
outputColumnNames: _col0
@@ -241,7 +241,7 @@ STAGE PLANS:
TableScan
alias: _dummy_table
Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: 5 (type: int), 3 (type: int)
outputColumnNames: _col0, _col1
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out
index ea314b3..8ca2c33 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out
@@ -107,10 +107,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -160,7 +160,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -215,7 +215,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -269,7 +269,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Outer Join 0 to 1
@@ -328,10 +328,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -381,7 +381,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -436,7 +436,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -490,7 +490,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Outer Join 0 to 1
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out
index 419c8ce..7dcc26b 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out
@@ -62,10 +62,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -117,7 +117,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -172,7 +172,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -228,7 +228,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Outer Join 0 to 1
@@ -287,10 +287,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -342,7 +342,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -397,7 +397,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -453,7 +453,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Outer Join 0 to 1
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out
index 33c872c..7b4e491 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out
@@ -62,10 +62,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -117,7 +117,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -171,7 +171,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -227,7 +227,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Outer Join 0 to 1
@@ -285,10 +285,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -340,7 +340,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -394,7 +394,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -450,7 +450,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Outer Join 0 to 1
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/binarysortable_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/binarysortable_1.q.out b/ql/src/test/results/clientpositive/binarysortable_1.q.out
index 3fc39f5..5575fa1 100644
Binary files a/ql/src/test/results/clientpositive/binarysortable_1.q.out and b/ql/src/test/results/clientpositive/binarysortable_1.q.out differ
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucket_map_join_1.q.out b/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
index 63107dd..a5612c6 100644
--- a/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
+++ b/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
@@ -64,12 +64,12 @@ STAGE PLANS:
b
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 21 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 210 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 21 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 210 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -81,12 +81,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- 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
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value 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
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -94,7 +94,7 @@ STAGE PLANS:
0 key (type: string), value (type: string)
1 key (type: string), value (type: string)
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucket_map_join_2.q.out b/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
index c61cdd9..97c5e80 100644
--- a/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
+++ b/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
@@ -64,12 +64,12 @@ STAGE PLANS:
b
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 21 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 210 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 21 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 210 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -81,12 +81,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- 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
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value 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
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -94,7 +94,7 @@ STAGE PLANS:
0 key (type: string), value (type: string)
1 key (type: string), value (type: string)
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/bucketcontext_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_5.q.out b/ql/src/test/results/clientpositive/bucketcontext_5.q.out
index 1326629..d42dbef 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_5.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_5.q.out
@@ -82,12 +82,12 @@ STAGE PLANS:
a
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string)
@@ -106,12 +106,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -119,7 +119,7 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
Position of Big Table: 1
- Statistics: Num rows: 1 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 63932 Basic stats: COMPLETE Column stats: NONE
BucketMapJoin: true
Group By Operator
aggregations: count()
@@ -249,12 +249,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/bucketcontext_6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_6.q.out b/ql/src/test/results/clientpositive/bucketcontext_6.q.out
index 069a895..36d7e3a 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_6.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_6.q.out
@@ -100,12 +100,12 @@ STAGE PLANS:
a
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/bucketmapjoin5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketmapjoin5.q.out b/ql/src/test/results/clientpositive/bucketmapjoin5.q.out
index 21937f4..473461f 100644
--- a/ql/src/test/results/clientpositive/bucketmapjoin5.q.out
+++ b/ql/src/test/results/clientpositive/bucketmapjoin5.q.out
@@ -196,12 +196,12 @@ STAGE PLANS:
a
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: int)
@@ -788,12 +788,12 @@ STAGE PLANS:
a
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: int)
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out b/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out
index f6652b8..baef408 100644
--- a/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out
+++ b/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out
@@ -161,12 +161,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out b/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out
index 095d559..6aa0e1d 100644
--- a/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out
+++ b/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out
@@ -223,12 +223,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out b/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out
index ece8f76..441d59a 100644
--- a/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out
+++ b/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out
@@ -162,12 +162,12 @@ STAGE PLANS:
r
TableScan
alias: r
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -186,12 +186,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -200,18 +200,18 @@ STAGE PLANS:
1 key (type: string), value (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
BucketMapJoin: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -310,12 +310,12 @@ STAGE PLANS:
r
TableScan
alias: r
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -334,12 +334,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -348,18 +348,18 @@ STAGE PLANS:
1 key (type: string), value (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
BucketMapJoin: true
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -458,12 +458,12 @@ STAGE PLANS:
r
TableScan
alias: r
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: UDFToDouble(key) is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 (key + key) (type: double)
@@ -475,12 +475,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key + key) is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -489,17 +489,17 @@ STAGE PLANS:
1 UDFToDouble(key) (type: double)
outputColumnNames: _col0, _col1, _col5, _col6
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -598,12 +598,12 @@ STAGE PLANS:
r
TableScan
alias: r
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -615,12 +615,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -629,17 +629,17 @@ STAGE PLANS:
1 key (type: string), value (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -738,12 +738,12 @@ STAGE PLANS:
r
TableScan
alias: r
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -755,12 +755,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -769,17 +769,17 @@ STAGE PLANS:
1 key (type: string), value (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -878,12 +878,12 @@ STAGE PLANS:
r
TableScan
alias: r
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -895,12 +895,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -909,17 +909,17 @@ STAGE PLANS:
1 key (type: string), value (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -1018,12 +1018,12 @@ STAGE PLANS:
r
TableScan
alias: r
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -1035,12 +1035,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1049,17 +1049,17 @@ STAGE PLANS:
1 key (type: string), value (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -1158,12 +1158,12 @@ STAGE PLANS:
r
TableScan
alias: r
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -1175,12 +1175,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1189,17 +1189,17 @@ STAGE PLANS:
1 key (type: string), value (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -1298,12 +1298,12 @@ STAGE PLANS:
r
TableScan
alias: r
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 key (type: string), value (type: string)
@@ -1315,12 +1315,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 42000 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -1329,17 +1329,17 @@ STAGE PLANS:
1 key (type: string), value (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Position of Big Table: 0
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4620 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 46200 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/case_sensitivity.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/case_sensitivity.q.out b/ql/src/test/results/clientpositive/case_sensitivity.q.out
index c77994d..439d7b8 100644
--- a/ql/src/test/results/clientpositive/case_sensitivity.q.out
+++ b/ql/src/test/results/clientpositive/case_sensitivity.q.out
@@ -30,17 +30,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_thrift
- 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: (lint[0] > 0) (type: boolean)
- Statistics: Num rows: 3 Data size: 837 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 8372 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: lint[1] (type: int), lintstring[0].mystring (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 837 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 8372 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 3 Data size: 837 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 8372 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -49,7 +49,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: int), _col1 (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 3 Data size: 837 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 8372 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/cbo_rp_join1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cbo_rp_join1.q.out b/ql/src/test/results/clientpositive/cbo_rp_join1.q.out
index f439eee..03ca51f 100644
--- a/ql/src/test/results/clientpositive/cbo_rp_join1.q.out
+++ b/ql/src/test/results/clientpositive/cbo_rp_join1.q.out
@@ -30,25 +30,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int)
Reduce Operator Tree:
Join Operator
@@ -61,11 +61,11 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 441 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: hash(_col0,_col1,_col2,_col3) (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 441 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col0)
mode: hash
@@ -132,25 +132,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int)
Reduce Operator Tree:
Join Operator
@@ -163,11 +163,11 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 441 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: hash(_col0,_col1,_col2,_col3) (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 441 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col0)
mode: hash
@@ -234,25 +234,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int)
Reduce Operator Tree:
Join Operator
@@ -265,11 +265,11 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 441 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: hash(_col0,_col1,_col2,_col3) (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 441 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col0)
mode: hash
@@ -336,25 +336,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int)
TableScan
alias: b
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int)
Reduce Operator Tree:
Join Operator
@@ -367,11 +367,11 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 441 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: hash(_col0,_col1,_col2,_col3) (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 441 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col0)
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/cbo_rp_udaf_percentile_approx_23.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cbo_rp_udaf_percentile_approx_23.q.out b/ql/src/test/results/clientpositive/cbo_rp_udaf_percentile_approx_23.q.out
index de24732..4a2369d 100644
--- a/ql/src/test/results/clientpositive/cbo_rp_udaf_percentile_approx_23.q.out
+++ b/ql/src/test/results/clientpositive/cbo_rp_udaf_percentile_approx_23.q.out
@@ -510,11 +510,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket
- Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: CASE WHEN ((key < 100.0)) THEN (NaN) ELSE (key) END (type: double)
outputColumnNames: $f0
- Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: percentile_approx($f0, 0.5)
mode: hash
@@ -569,11 +569,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket
- Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: double)
outputColumnNames: $f0
- Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: percentile_approx($f0, 0.5)
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out b/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out
index feac97e..f0b49b2 100644
--- a/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out
+++ b/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out
@@ -25,24 +25,24 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_thrift
- 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
Select Operator
expressions: lint (type: array<int>), lstring (type: array<string>), mstringstring (type: map<string,string>), aint (type: int), astring (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- 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
sort order:
Map-reduce partition columns: 1 (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: _col0 (type: array<int>), _col1 (type: array<string>), _col2 (type: map<string,string>), _col3 (type: int), _col4 (type: string)
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: array<int>), VALUE._col1 (type: array<string>), VALUE._col2 (type: map<string,string>), VALUE._col3 (type: int), VALUE._col4 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- 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
File Output Operator
compressed: false
- 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
table:
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out b/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out
index 6050694..9a9223a 100644
--- a/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out
+++ b/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out
@@ -54,11 +54,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: uservisits_web_text_none
- Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: sourceip (type: string), adrevenue (type: float), avgtimeonsite (type: int)
outputColumnNames: sourceip, adrevenue, avgtimeonsite
- Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(sourceip, 'hll'), compute_stats(avgtimeonsite, 'hll'), compute_stats(adrevenue, 'hll')
mode: hash
@@ -106,13 +106,13 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: uservisits_web_text_none
- Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
Statistics Aggregation Key Prefix: default.uservisits_web_text_none/
GatherStats: true
Select Operator
expressions: sourceip (type: string), adrevenue (type: float), avgtimeonsite (type: int)
outputColumnNames: sourceip, adrevenue, avgtimeonsite
- Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(sourceip, 'hll'), compute_stats(avgtimeonsite, 'hll'), compute_stats(adrevenue, 'hll')
mode: hash
@@ -526,11 +526,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: uservisits_in_dummy_db
- Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: sourceip (type: string), adrevenue (type: float), avgtimeonsite (type: int)
outputColumnNames: sourceip, adrevenue, avgtimeonsite
- Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(sourceip, 'hll'), compute_stats(avgtimeonsite, 'hll'), compute_stats(adrevenue, 'hll')
mode: hash
@@ -578,13 +578,13 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: uservisits_in_dummy_db
- Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
Statistics Aggregation Key Prefix: dummydb.uservisits_in_dummy_db/
GatherStats: true
Select Operator
expressions: sourceip (type: string), adrevenue (type: float), avgtimeonsite (type: int)
outputColumnNames: sourceip, adrevenue, avgtimeonsite
- Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(sourceip, 'hll'), compute_stats(avgtimeonsite, 'hll'), compute_stats(adrevenue, 'hll')
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/combine2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/combine2.q.out b/ql/src/test/results/clientpositive/combine2.q.out
index d4194c8..6c94c87 100644
--- a/ql/src/test/results/clientpositive/combine2.q.out
+++ b/ql/src/test/results/clientpositive/combine2.q.out
@@ -161,22 +161,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
- Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2000 Data size: 212480 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: ds (type: string)
outputColumnNames: ds
- Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2000 Data size: 212480 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
keys: ds (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2000 Data size: 212480 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2000 Data size: 212480 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -184,10 +184,10 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 106240 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 106240 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/compute_stats_date.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/compute_stats_date.q.out b/ql/src/test/results/clientpositive/compute_stats_date.q.out
index 796b3d3..1c12421 100644
--- a/ql/src/test/results/clientpositive/compute_stats_date.q.out
+++ b/ql/src/test/results/clientpositive/compute_stats_date.q.out
@@ -60,11 +60,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tab_date
- Statistics: Num rows: 1 Data size: 778 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 7780 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: fl_date (type: date)
outputColumnNames: fl_date
- Statistics: Num rows: 1 Data size: 778 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 7780 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(fl_date, 'hll')
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/concat_op.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/concat_op.q.out b/ql/src/test/results/clientpositive/concat_op.q.out
index 17a0e31..33c84f9 100644
--- a/ql/src/test/results/clientpositive/concat_op.q.out
+++ b/ql/src/test/results/clientpositive/concat_op.q.out
@@ -248,7 +248,7 @@ STAGE PLANS:
TableScan
alias: _dummy_table
Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: 'abc' (type: string)
outputColumnNames: _col0
@@ -270,7 +270,7 @@ STAGE PLANS:
TableScan
alias: _dummy_table
Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: 'abc' (type: string)
outputColumnNames: _col0