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 2018/01/05 10:49:01 UTC
[12/18] hive git commit: HIVE-18108: in case basic stats are missing;
rowcount estimation depends on the selected columns size (Zoltan
Haindrich, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/d0fa7d55/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
index 0fda4c1..2cebc0d 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
@@ -134,7 +134,7 @@ POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket3out
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_medium@ds=2008-04-08
-Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_1, $hdt$_2, $hdt$_0, $hdt$_3]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain extended select count(*) FROM bucket_small a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select count(*) FROM bucket_small a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key
@@ -148,24 +148,24 @@ STAGE PLANS:
Tez
#### A masked pattern was here ####
Edges:
- Reducer 4 <- Map 3 (XPROD_EDGE), Map 6 (XPROD_EDGE)
- Reducer 5 <- Reducer 4 (CUSTOM_SIMPLE_EDGE)
+ Reducer 2 <- Map 1 (XPROD_EDGE), Map 6 (XPROD_EDGE)
+ Reducer 3 <- Reducer 2 (CUSTOM_SIMPLE_EDGE)
#### A masked pattern was here ####
Vertices:
- Map 3
+ Map 1
Map Operator Tree:
TableScan
- alias: a
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ alias: b
+ Statistics: Num rows: 3 Data size: 552 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: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 552 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 552 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -176,23 +176,23 @@ STAGE PLANS:
partition values:
ds 2008-04-08
properties:
- bucket_count 2
+ bucket_count 3
bucket_field_name key
column.name.delimiter ,
columns key,value
columns.comments
columns.types string:string
#### A masked pattern was here ####
- name default.bucket_small
- numFiles 2
+ name default.bucket_medium
+ numFiles 3
numRows 0
partition_columns ds
partition_columns.types string
rawDataSize 0
- serialization.ddl struct bucket_small { string key, string value}
+ serialization.ddl struct bucket_medium { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 114
+ totalSize 170
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -200,38 +200,38 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
SORTBUCKETCOLSPREFIX TRUE
- bucket_count 2
+ bucket_count 3
bucket_field_name key
column.name.delimiter ,
columns key,value
columns.comments
columns.types string:string
#### A masked pattern was here ####
- name default.bucket_small
+ name default.bucket_medium
partition_columns ds
partition_columns.types string
- serialization.ddl struct bucket_small { string key, string value}
+ serialization.ddl struct bucket_medium { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.bucket_small
- name: default.bucket_small
+ name: default.bucket_medium
+ name: default.bucket_medium
Truncated Path -> Alias:
- /bucket_small/ds=2008-04-08 [a]
+ /bucket_medium/ds=2008-04-08 [b]
Map Operator Tree:
TableScan
- alias: b
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ alias: a
+ Statistics: Num rows: 2 Data size: 368 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: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -242,23 +242,23 @@ STAGE PLANS:
partition values:
ds 2008-04-08
properties:
- bucket_count 3
+ bucket_count 2
bucket_field_name key
column.name.delimiter ,
columns key,value
columns.comments
columns.types string:string
#### A masked pattern was here ####
- name default.bucket_medium
- numFiles 3
+ name default.bucket_small
+ numFiles 2
numRows 0
partition_columns ds
partition_columns.types string
rawDataSize 0
- serialization.ddl struct bucket_medium { string key, string value}
+ serialization.ddl struct bucket_small { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 170
+ totalSize 114
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -266,38 +266,38 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
SORTBUCKETCOLSPREFIX TRUE
- bucket_count 3
+ bucket_count 2
bucket_field_name key
column.name.delimiter ,
columns key,value
columns.comments
columns.types string:string
#### A masked pattern was here ####
- name default.bucket_medium
+ name default.bucket_small
partition_columns ds
partition_columns.types string
- serialization.ddl struct bucket_medium { string key, string value}
+ serialization.ddl struct bucket_small { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.bucket_medium
- name: default.bucket_medium
+ name: default.bucket_small
+ name: default.bucket_small
Truncated Path -> Alias:
- /bucket_medium/ds=2008-04-08 [b]
+ /bucket_small/ds=2008-04-08 [a]
Map Operator Tree:
TableScan
alias: c
- Statistics: Num rows: 116 Data size: 20608 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 240 Data size: 39008 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 111 Data size: 19719 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 211 Data size: 34294 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 111 Data size: 19719 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 211 Data size: 34294 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -306,12 +306,12 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
2 _col0 (type: string)
- Position of Big Table: 2
- Statistics: Num rows: 244 Data size: 43381 Basic stats: COMPLETE Column stats: NONE
+ Position of Big Table: 0
+ Statistics: Num rows: 464 Data size: 75446 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
null sort order:
sort order:
- Statistics: Num rows: 244 Data size: 43381 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 464 Data size: 75446 Basic stats: COMPLETE Column stats: NONE
tag: 0
auto parallelism: false
Execution mode: llap
@@ -421,14 +421,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: d
- Statistics: Num rows: 1 Data size: 1708 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 1724 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Select Operator
- Statistics: Num rows: 1 Data size: 1708 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
null sort order:
sort order:
- Statistics: Num rows: 1 Data size: 1708 Basic stats: PARTIAL Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE
tag: 1
auto parallelism: false
Execution mode: llap
@@ -487,7 +487,7 @@ STAGE PLANS:
name: default.bucket_medium
Truncated Path -> Alias:
/bucket_medium/ds=2008-04-08 [d]
- Reducer 4
+ Reducer 2
Execution mode: llap
Needs Tagging: false
Reduce Operator Tree:
@@ -498,20 +498,20 @@ STAGE PLANS:
0
1
Position of Big Table: 0
- Statistics: Num rows: 244 Data size: 460377 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1392 Data size: 238866 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
null sort order:
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
tag: -1
value expressions: _col0 (type: bigint)
auto parallelism: false
- Reducer 5
+ Reducer 3
Execution mode: llap
Needs Tagging: false
Reduce Operator Tree:
@@ -519,13 +519,13 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 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: 8 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -549,7 +549,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_1, $hdt$_2, $hdt$_0, $hdt$_3]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select count(*) FROM bucket_small a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big
http://git-wip-us.apache.org/repos/asf/hive/blob/d0fa7d55/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out
index ee70e6e..ece7cfe 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out
@@ -101,16 +101,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 2 Data size: 594 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 2996 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: 594 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 2996 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 594 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 2996 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -167,16 +167,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 54 Data size: 15252 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 74872 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -184,7 +184,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 57 Data size: 16155 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 117 Data size: 78681 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -375,16 +375,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 2 Data size: 594 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 2996 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: 594 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 2996 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 594 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 2996 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -441,16 +441,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 54 Data size: 15252 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 74872 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -458,7 +458,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 57 Data size: 16155 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 117 Data size: 78681 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/d0fa7d55/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out
index 26439b9..2661310 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out
@@ -101,16 +101,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 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: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -216,16 +216,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 58 Data size: 16300 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 120 Data size: 79280 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 56 Data size: 15737 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 75316 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 56 Data size: 15737 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 75316 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -233,7 +233,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 1
- Statistics: Num rows: 61 Data size: 17310 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 82847 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -375,16 +375,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 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: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -490,16 +490,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 58 Data size: 16300 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 120 Data size: 79280 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 56 Data size: 15737 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 75316 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 56 Data size: 15737 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 75316 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -507,7 +507,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 61 Data size: 17310 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 82847 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -649,16 +649,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 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: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -764,16 +764,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 58 Data size: 16300 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 120 Data size: 79280 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 56 Data size: 15737 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 75316 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 56 Data size: 15737 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 75316 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -781,7 +781,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 61 Data size: 17310 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 82847 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/d0fa7d55/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out
index 43500fb..87d65ff 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_4.q.out
@@ -117,16 +117,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -232,16 +232,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 27 Data size: 7718 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 37620 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: 7432 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 36276 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 26 Data size: 7432 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 36276 Basic stats: COMPLETE Column stats: NONE
Merge 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: 1
- Statistics: Num rows: 28 Data size: 8175 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 59 Data size: 39903 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -391,16 +391,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -506,16 +506,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 27 Data size: 7718 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 37620 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: 7432 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 36276 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 26 Data size: 7432 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 36276 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -523,7 +523,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 28 Data size: 8175 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 59 Data size: 39903 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -665,16 +665,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -780,16 +780,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 27 Data size: 7718 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 37620 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: 7432 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 36276 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 26 Data size: 7432 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 36276 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -797,7 +797,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 28 Data size: 8175 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 59 Data size: 39903 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/d0fa7d55/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out
index a88396b..3305c4d 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_7.q.out
@@ -134,16 +134,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -249,16 +249,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 54 Data size: 15252 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 74872 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -266,7 +266,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 1
- Statistics: Num rows: 57 Data size: 16155 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 117 Data size: 78681 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -459,16 +459,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -574,16 +574,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 54 Data size: 15252 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 74872 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -591,7 +591,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 57 Data size: 16155 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 117 Data size: 78681 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -784,16 +784,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 1188 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 5992 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -899,16 +899,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 54 Data size: 15252 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 74872 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 52 Data size: 14687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 107 Data size: 71529 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -916,7 +916,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 57 Data size: 16155 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 117 Data size: 78681 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/d0fa7d55/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out
index 5ae1699..8362c8e 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_8.q.out
@@ -134,16 +134,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 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: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -249,16 +249,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 116 Data size: 32232 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 111 Data size: 30842 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 111 Data size: 30842 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -266,7 +266,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 1
- Statistics: Num rows: 122 Data size: 33926 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 165502 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -459,16 +459,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 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: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -574,16 +574,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 116 Data size: 32232 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 111 Data size: 30842 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 111 Data size: 30842 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -591,7 +591,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 122 Data size: 33926 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 165502 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -784,16 +784,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 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: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 596 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -899,16 +899,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 116 Data size: 32232 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 111 Data size: 30842 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 111 Data size: 30842 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator
condition map:
Inner Join 0 to 1
@@ -916,7 +916,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
Position of Big Table: 0
- Statistics: Num rows: 122 Data size: 33926 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 165502 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/d0fa7d55/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out
index 480775f..df7d77e 100644
--- a/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out
@@ -483,22 +483,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 55 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 149 Data size: 85004 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 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: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
tag: 1
value expressions: _col1 (type: string)
auto parallelism: true
@@ -569,17 +569,17 @@ STAGE PLANS:
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3
Position of Big Table: 1
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 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: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -609,7 +609,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
outputColumnNames: key, value1, value2
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value1, 'hll'), compute_stats(value2, 'hll')
mode: hash
@@ -903,22 +903,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 55 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 149 Data size: 85004 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 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: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
tag: 1
value expressions: _col1 (type: string)
auto parallelism: true
@@ -989,17 +989,17 @@ STAGE PLANS:
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3
Position of Big Table: 1
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 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: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1029,7 +1029,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
outputColumnNames: key, value1, value2
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value1, 'hll'), compute_stats(value2, 'hll')
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/d0fa7d55/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out
index 14f1efe..04e104f 100644
--- a/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out
@@ -119,22 +119,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 55 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 149 Data size: 85004 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 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: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
tag: 0
value expressions: _col1 (type: string)
auto parallelism: true
@@ -197,22 +197,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 29 Data size: 8514 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 78 Data size: 44908 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 28 Data size: 8220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 75 Data size: 43180 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 8220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 75 Data size: 43180 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: 28 Data size: 8220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 75 Data size: 43180 Basic stats: COMPLETE Column stats: NONE
tag: 1
value expressions: _col1 (type: string)
auto parallelism: true
@@ -283,17 +283,17 @@ STAGE PLANS:
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3
Position of Big Table: 0
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 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: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -323,7 +323,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
outputColumnNames: key, value1, value2
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value1, 'hll'), compute_stats(value2, 'hll')
mode: hash
@@ -545,22 +545,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 55 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 149 Data size: 85004 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 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: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
tag: 0
value expressions: _col1 (type: string)
auto parallelism: true
@@ -623,22 +623,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 29 Data size: 8514 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 78 Data size: 44908 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 28 Data size: 8220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 75 Data size: 43180 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 8220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 75 Data size: 43180 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: 28 Data size: 8220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 75 Data size: 43180 Basic stats: COMPLETE Column stats: NONE
tag: 1
value expressions: _col1 (type: string)
auto parallelism: true
@@ -709,17 +709,17 @@ STAGE PLANS:
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3
Position of Big Table: 0
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 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: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -749,7 +749,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
outputColumnNames: key, value1, value2
- Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89111 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value1, 'hll'), compute_stats(value2, 'hll')
mode: hash
@@ -988,22 +988,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
- Statistics: Num rows: 55 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 149 Data size: 85004 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 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: 53 Data size: 15383 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 142 Data size: 81010 Basic stats: COMPLETE Column stats: NONE
tag: 0
value expressions: _col1 (type: string)
auto parallelism: true
@@ -1066,22 +1066,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 58 Data size: 16840 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 156 Data size: 89440 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: key is not null (type: boolean)
- Statistics: Num rows: 56 Data size: 16259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 149 Data size: 85426 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 56 Data size: 16259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 149 Data size: 85426 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: 56 Data size: 16259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 149 Data size: 85426 Basic stats: COMPLETE Column stats: NONE
tag: 1
value expressions: _col1 (type: string)
auto parallelism: true
@@ -1201,17 +1201,17 @@ STAGE PLANS:
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col3
Position of Big Table: 1
- Statistics: Num rows: 61 Data size: 17884 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 93968 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: 61 Data size: 17884 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 93968 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 61 Data size: 17884 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 93968 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1241,7 +1241,7 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
outputColumnNames: key, value1, value2
- Statistics: Num rows: 61 Data size: 17884 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 93968 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value1, 'hll'), compute_stats(value2, 'hll')
mode: hash