You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by vg...@apache.org on 2017/09/25 20:59:57 UTC
[11/23] hive git commit: HIVE-17536 : StatsUtil::getBasicStatForTable
doesn't distinguish b/w absence of statistics or zero stats (Vineet Garg,
reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/nullscript.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/nullscript.q.out b/ql/src/test/results/clientpositive/nullscript.q.out
index 4220e69..fedebf8 100644
--- a/ql/src/test/results/clientpositive/nullscript.q.out
+++ b/ql/src/test/results/clientpositive/nullscript.q.out
@@ -38,21 +38,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: nullscript
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Transform Operator
command: cat
output info:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5812 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/6a99cf53/ql/src/test/results/clientpositive/orc_merge5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/orc_merge5.q.out b/ql/src/test/results/clientpositive/orc_merge5.q.out
index e845186..fe24e16 100644
--- a/ql/src/test/results/clientpositive/orc_merge5.q.out
+++ b/ql/src/test/results/clientpositive/orc_merge5.q.out
@@ -38,17 +38,17 @@ STAGE PLANS:
TableScan
alias: orc_merge5
filterExpr: (userid <= 13) (type: boolean)
- Statistics: Num rows: 919 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (userid <= 13) (type: boolean)
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: userid (type: bigint), string1 (type: string), subtype (type: double), decimal1 (type: decimal(10,0)), ts (type: timestamp)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
@@ -123,17 +123,17 @@ STAGE PLANS:
TableScan
alias: orc_merge5
filterExpr: (userid <= 13) (type: boolean)
- Statistics: Num rows: 919 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (userid <= 13) (type: boolean)
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: userid (type: bigint), string1 (type: string), subtype (type: double), decimal1 (type: decimal(10,0)), ts (type: timestamp)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/orc_merge6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/orc_merge6.q.out b/ql/src/test/results/clientpositive/orc_merge6.q.out
index 5ece361..d998f4c 100644
--- a/ql/src/test/results/clientpositive/orc_merge6.q.out
+++ b/ql/src/test/results/clientpositive/orc_merge6.q.out
@@ -38,17 +38,17 @@ STAGE PLANS:
TableScan
alias: orc_merge5
filterExpr: (userid <= 13) (type: boolean)
- Statistics: Num rows: 919 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (userid <= 13) (type: boolean)
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: userid (type: bigint), string1 (type: string), subtype (type: double), decimal1 (type: decimal(10,0)), ts (type: timestamp)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
@@ -168,17 +168,17 @@ STAGE PLANS:
TableScan
alias: orc_merge5
filterExpr: (userid <= 13) (type: boolean)
- Statistics: Num rows: 919 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (userid <= 13) (type: boolean)
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: userid (type: bigint), string1 (type: string), subtype (type: double), decimal1 (type: decimal(10,0)), ts (type: timestamp)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out b/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out
index fcf1c68..aac4d15 100644
--- a/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out
+++ b/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out
@@ -37,17 +37,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_merge5
- Statistics: Num rows: 919 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (userid <= 13) (type: boolean)
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: userid (type: bigint), string1 (type: string), subtype (type: double), decimal1 (type: decimal(10,0)), ts (type: timestamp)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out b/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out
index a27041f..4b36e97 100644
--- a/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out
+++ b/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out
@@ -37,14 +37,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_merge5
- Statistics: Num rows: 919 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: userid (type: bigint), string1 (type: string), subtype (type: double), decimal1 (type: decimal(10,0)), ts (type: timestamp), subtype (type: double)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 919 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 919 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 246402 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/parallel_orderby.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parallel_orderby.q.out b/ql/src/test/results/clientpositive/parallel_orderby.q.out
index 8249a7b..98016ee 100644
--- a/ql/src/test/results/clientpositive/parallel_orderby.q.out
+++ b/ql/src/test/results/clientpositive/parallel_orderby.q.out
@@ -40,23 +40,23 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src5
- Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
- Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/ptf_matchpath.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/ptf_matchpath.q.out b/ql/src/test/results/clientpositive/ptf_matchpath.q.out
index b7409f9..59595ec 100644
--- a/ql/src/test/results/clientpositive/ptf_matchpath.q.out
+++ b/ql/src/test/results/clientpositive/ptf_matchpath.q.out
@@ -66,18 +66,18 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: flights_tiny
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: fl_num (type: string), year (type: int), month (type: int), day_of_month (type: int)
sort order: ++++
Map-reduce partition columns: fl_num (type: string)
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
value expressions: origin_city_name (type: string), arr_delay (type: float)
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: int), KEY.reducesinkkey3 (type: int), VALUE._col2 (type: float), KEY.reducesinkkey0 (type: string)
outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -93,14 +93,14 @@ STAGE PLANS:
partition by: _col6
raw input shape:
referenced columns: _col0, _col6, _col2, _col3, _col4, tpath, _col5
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: origin_city_name (type: string), fl_num (type: string), year (type: int), month (type: int), day_of_month (type: int), sz (type: int), tpath (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -184,18 +184,18 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: flights_tiny
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: 0 (type: int), fl_num (type: string), year (type: int), month (type: int), day_of_month (type: int)
sort order: +++++
Map-reduce partition columns: 0 (type: int)
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
value expressions: origin_city_name (type: string), arr_delay (type: float)
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey2 (type: int), KEY.reducesinkkey3 (type: int), KEY.reducesinkkey4 (type: int), VALUE._col2 (type: float), KEY.reducesinkkey1 (type: string)
outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -211,17 +211,17 @@ STAGE PLANS:
partition by: 0
raw input shape:
referenced columns: _col0, _col6, _col2, _col3, _col4, tpath, _col5
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (fl_num = 1142) (type: boolean)
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: origin_city_name (type: string), fl_num (type: string), year (type: int), month (type: int), day_of_month (type: int), sz (type: int), tpath (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -292,25 +292,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: flights_tiny
- Statistics: Num rows: 24 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (fl_num = -1142) (type: boolean)
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: origin_city_name (type: string), year (type: int), month (type: int), day_of_month (type: int), arr_delay (type: float), fl_num (type: string)
outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: 0 (type: int), _col6 (type: string), _col2 (type: int), _col3 (type: int), _col4 (type: int)
sort order: +++++
Map-reduce partition columns: 0 (type: int)
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col5 (type: float)
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey2 (type: int), KEY.reducesinkkey3 (type: int), KEY.reducesinkkey4 (type: int), VALUE._col2 (type: float), KEY.reducesinkkey1 (type: string)
outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Function definitions:
Input definition
@@ -326,14 +326,14 @@ STAGE PLANS:
partition by: 0
raw input shape:
referenced columns: _col0, _col6, _col2, _col3, _col4, tpath, _col5
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: origin_city_name (type: string), fl_num (type: string), year (type: int), month (type: int), day_of_month (type: int), sz (type: int), tpath (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 12 Data size: 2689 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 5379 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/6a99cf53/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out b/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out
index 52314d9..b3f36ad 100644
--- a/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out
+++ b/ql/src/test/results/clientpositive/smb_mapjoin_1.q.out
@@ -283,10 +283,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -336,7 +336,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -391,7 +391,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Right Outer Join 0 to 1
@@ -445,7 +445,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 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/6a99cf53/ql/src/test/results/clientpositive/smb_mapjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/smb_mapjoin_2.q.out b/ql/src/test/results/clientpositive/smb_mapjoin_2.q.out
index 56a38a2..419c8ce 100644
--- a/ql/src/test/results/clientpositive/smb_mapjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/smb_mapjoin_2.q.out
@@ -62,10 +62,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 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: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 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: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 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: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 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: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 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: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 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: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 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: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 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/6a99cf53/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out b/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
index f72c2a7..bf0e6e6 100644
--- a/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
+++ b/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
@@ -67,26 +67,26 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 52 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 5) (type: boolean)
- Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: b
- Statistics: Num rows: 51 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (5 = key) (type: boolean)
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -94,7 +94,7 @@ STAGE PLANS:
keys:
0
1
- Statistics: Num rows: 650 Data size: 5850 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 415 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -108,11 +108,11 @@ STAGE PLANS:
TableScan
Reduce Output Operator
sort order:
- Statistics: Num rows: 650 Data size: 5850 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 415 Basic stats: COMPLETE Column stats: NONE
TableScan
Reduce Output Operator
sort order:
- Statistics: Num rows: 675 Data size: 6075 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 429 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -120,14 +120,14 @@ STAGE PLANS:
keys:
0
1
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: 5 (type: int), 5 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -138,26 +138,26 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 51 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 5) (type: boolean)
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: d
- Statistics: Num rows: 55 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (5 = key) (type: boolean)
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -165,7 +165,7 @@ STAGE PLANS:
keys:
0
1
- Statistics: Num rows: 675 Data size: 6075 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 429 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -214,12 +214,12 @@ STAGE PLANS:
$hdt$_0:$hdt$_1:b
TableScan
alias: b
- Statistics: Num rows: 51 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (5 = key) (type: boolean)
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0
@@ -230,19 +230,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 52 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 5) (type: boolean)
- Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
keys:
0
1
- Statistics: Num rows: 650 Data size: 5850 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 415 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -279,14 +279,14 @@ STAGE PLANS:
keys:
0
1
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: 5 (type: int), 5 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -318,14 +318,14 @@ STAGE PLANS:
keys:
0
1
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: 5 (type: int), 5 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -339,11 +339,11 @@ STAGE PLANS:
TableScan
Reduce Output Operator
sort order:
- Statistics: Num rows: 650 Data size: 5850 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 415 Basic stats: COMPLETE Column stats: NONE
TableScan
Reduce Output Operator
sort order:
- Statistics: Num rows: 675 Data size: 6075 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 429 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -351,14 +351,14 @@ STAGE PLANS:
keys:
0
1
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: 5 (type: int), 5 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 438750 Data size: 8336250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -374,12 +374,12 @@ STAGE PLANS:
$hdt$_1:$hdt$_1:c
TableScan
alias: c
- Statistics: Num rows: 51 Data size: 206 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 5) (type: boolean)
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0
@@ -390,19 +390,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: d
- Statistics: Num rows: 55 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (5 = key) (type: boolean)
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
keys:
0
1
- Statistics: Num rows: 675 Data size: 6075 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 429 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/smb_mapjoin_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/smb_mapjoin_3.q.out b/ql/src/test/results/clientpositive/smb_mapjoin_3.q.out
index f33b8bb..33c872c 100644
--- a/ql/src/test/results/clientpositive/smb_mapjoin_3.q.out
+++ b/ql/src/test/results/clientpositive/smb_mapjoin_3.q.out
@@ -62,10 +62,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 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: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 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: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 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: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 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/6a99cf53/ql/src/test/results/clientpositive/spark/auto_sortmerge_join_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/auto_sortmerge_join_5.q.out b/ql/src/test/results/clientpositive/spark/auto_sortmerge_join_5.q.out
index 50468e9..54f11c4 100644
--- a/ql/src/test/results/clientpositive/spark/auto_sortmerge_join_5.q.out
+++ b/ql/src/test/results/clientpositive/spark/auto_sortmerge_join_5.q.out
@@ -81,16 +81,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 27 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 27 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 27 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -98,7 +98,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 1
- Statistics: Num rows: 29 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 248 Basic stats: COMPLETE Column stats: NONE
BucketMapJoin: true
Group By Operator
aggregations: count()
@@ -232,16 +232,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 27 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 27 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 27 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
@@ -249,7 +249,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 29 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
BucketMapJoin: true
Group By Operator
aggregations: count()
@@ -382,16 +382,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 2 Data size: 226 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 2 Data size: 226 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 226 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column stats: NONE
Spark HashTable Sink Operator
keys:
0 _col0 (type: string)
@@ -468,16 +468,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 27 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 27 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 27 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -487,7 +487,7 @@ STAGE PLANS:
input vertices:
1 Map 3
Position of Big Table: 0
- Statistics: Num rows: 29 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
BucketMapJoin: true
Group By Operator
aggregations: count()
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out b/ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out
index 724f982..0b1ee92 100644
--- a/ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out
+++ b/ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out
@@ -390,22 +390,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
tag: 0
value expressions: _col1 (type: string)
auto parallelism: false
@@ -745,22 +745,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
tag: 0
value expressions: _col1 (type: string)
auto parallelism: false
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/spark/bucketmapjoin4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/bucketmapjoin4.q.out b/ql/src/test/results/clientpositive/spark/bucketmapjoin4.q.out
index 7fb61f0..563e816 100644
--- a/ql/src/test/results/clientpositive/spark/bucketmapjoin4.q.out
+++ b/ql/src/test/results/clientpositive/spark/bucketmapjoin4.q.out
@@ -140,22 +140,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
tag: 0
value expressions: _col1 (type: string)
auto parallelism: false
@@ -214,22 +214,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
tag: 1
value expressions: _col1 (type: string)
auto parallelism: false
@@ -294,17 +294,17 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 28 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: UDFToString(_col0) (type: string), _col1 (type: string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 28 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 28 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -485,22 +485,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
tag: 0
value expressions: _col1 (type: string)
auto parallelism: false
@@ -559,22 +559,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
tag: 1
value expressions: _col1 (type: string)
auto parallelism: false
@@ -639,17 +639,17 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 28 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: UDFToString(_col0) (type: string), _col1 (type: string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 28 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 28 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3025 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/spark/bucketmapjoin5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/bucketmapjoin5.q.out b/ql/src/test/results/clientpositive/spark/bucketmapjoin5.q.out
index a941513..5e57618 100644
--- a/ql/src/test/results/clientpositive/spark/bucketmapjoin5.q.out
+++ b/ql/src/test/results/clientpositive/spark/bucketmapjoin5.q.out
@@ -189,12 +189,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Spark HashTable Sink Operator
keys:
0 key (type: int)
@@ -595,12 +595,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Spark HashTable Sink Operator
keys:
0 key (type: int)
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative.q.out b/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative.q.out
index 3e74c21..2bfb4af 100644
--- a/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative.q.out
+++ b/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative.q.out
@@ -165,12 +165,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 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/6a99cf53/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative2.q.out b/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative2.q.out
index a3acd5d..277eb7f 100644
--- a/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative2.q.out
+++ b/ql/src/test/results/clientpositive/spark/bucketmapjoin_negative2.q.out
@@ -228,12 +228,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2750 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1