You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2017/09/27 20:22:43 UTC
[08/50] [abbrv] 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/spark/smb_mapjoin_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
index d001d6d..0f31a93 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
@@ -67,19 +67,19 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -103,19 +103,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -128,10 +128,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -176,19 +176,19 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -212,19 +212,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -237,10 +237,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -285,16 +285,16 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -315,16 +315,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -337,10 +337,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -390,16 +390,16 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -420,16 +420,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -442,10 +442,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -496,16 +496,16 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -526,16 +526,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -548,10 +548,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -607,19 +607,19 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -643,19 +643,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -668,10 +668,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -718,16 +718,16 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -748,16 +748,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -770,10 +770,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -822,16 +822,16 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -852,16 +852,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -874,10 +874,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -928,16 +928,16 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -958,16 +958,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -980,10 +980,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1036,19 +1036,19 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -1072,19 +1072,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -1097,10 +1097,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1147,16 +1147,16 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -1177,16 +1177,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -1199,10 +1199,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1256,16 +1256,16 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -1286,16 +1286,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -1308,10 +1308,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1362,16 +1362,16 @@ 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Map 3
Map Operator Tree:
@@ -1392,16 +1392,16 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
- 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
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- 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
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- 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
value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
@@ -1414,10 +1414,10 @@ STAGE PLANS:
1 _col0 (type: int)
2 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 457 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 457 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/spark/spark_explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out b/ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out
index b9f2267..129feb7 100644
--- a/ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out
@@ -2899,16 +2899,16 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_6]
- Group By Operator [GBY_4] (rows=2 width=16)
+ Group By Operator [GBY_4] (rows=1 width=16)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(DISTINCT KEY._col1:0._col0)","count(DISTINCT KEY._col1:1._col0)","sum(VALUE._col2)"],keys:KEY._col0
<-Map 1 [GROUP PARTITION-LEVEL SORT]
GROUP PARTITION-LEVEL SORT [RS_3]
PartitionCols:_col0
- Group By Operator [GBY_2] (rows=4 width=16)
+ Group By Operator [GBY_2] (rows=1 width=16)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["count(DISTINCT b)","count(DISTINCT c)","sum(d)"],keys:a, b, c
- Select Operator [SEL_1] (rows=4 width=16)
+ Select Operator [SEL_1] (rows=1 width=16)
Output:["a","b","c","d"]
- TableScan [TS_0] (rows=4 width=16)
+ TableScan [TS_0] (rows=1 width=16)
default@abcd,abcd,Tbl:COMPLETE,Col:NONE,Output:["a","b","c","d"]
PREHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
@@ -2926,14 +2926,14 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_5]
- Group By Operator [GBY_3] (rows=2 width=16)
+ Group By Operator [GBY_3] (rows=1 width=16)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(DISTINCT KEY._col1:0._col0)","count(DISTINCT KEY._col1:1._col0)","sum(VALUE._col0)"],keys:KEY._col0
<-Map 1 [GROUP PARTITION-LEVEL SORT]
GROUP PARTITION-LEVEL SORT [RS_2]
PartitionCols:a
- Select Operator [SEL_1] (rows=4 width=16)
+ Select Operator [SEL_1] (rows=1 width=16)
Output:["a","b","c","d"]
- TableScan [TS_0] (rows=4 width=16)
+ TableScan [TS_0] (rows=1 width=16)
default@abcd,abcd,Tbl:COMPLETE,Col:NONE,Output:["a","b","c","d"]
PREHOOK: query: explain create table src_rc_merge_test(key int, value string) stored as rcfile
@@ -3390,19 +3390,19 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_6]
- Select Operator [SEL_5] (rows=3 width=8)
+ Select Operator [SEL_5] (rows=1 width=8)
Output:["_col0","_col1","_col2","_col3"]
- Join Operator [JOIN_4] (rows=3 width=8)
+ Join Operator [JOIN_4] (rows=1 width=8)
Output:["_col0","_col1","_col5","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"}],keys:{"0":"key","1":"value"}
<-Map 1 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_2]
PartitionCols:key
- TableScan [TS_0] (rows=3 width=8)
+ TableScan [TS_0] (rows=1 width=8)
default@myinput1,a,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 3 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_3]
PartitionCols:value
- TableScan [TS_1] (rows=3 width=8)
+ TableScan [TS_1] (rows=1 width=8)
default@myinput1,b,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: explain select * from myinput1 a join myinput1 b on a.key<=>b.value join myinput1 c on a.key=c.key
@@ -3420,30 +3420,30 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_11]
- Select Operator [SEL_10] (rows=6 width=8)
+ Select Operator [SEL_10] (rows=2 width=8)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Join Operator [JOIN_9] (rows=6 width=8)
+ Join Operator [JOIN_9] (rows=2 width=8)
Output:["_col0","_col1","_col5","_col6","_col10","_col11"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":0,\"right\":2}"}],keys:{"0":"key","1":"value","2":"key"}
<-Map 1 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_4]
PartitionCols:key
- Filter Operator [FIL_12] (rows=3 width=8)
+ Filter Operator [FIL_12] (rows=1 width=8)
predicate:key is not null
- TableScan [TS_0] (rows=3 width=8)
+ TableScan [TS_0] (rows=1 width=8)
default@myinput1,a,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 3 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_6]
PartitionCols:value
- Filter Operator [FIL_13] (rows=3 width=8)
+ Filter Operator [FIL_13] (rows=1 width=8)
predicate:value is not null
- TableScan [TS_1] (rows=3 width=8)
+ TableScan [TS_1] (rows=1 width=8)
default@myinput1,b,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 4 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_8]
PartitionCols:key
- Filter Operator [FIL_14] (rows=3 width=8)
+ Filter Operator [FIL_14] (rows=1 width=8)
predicate:key is not null
- TableScan [TS_2] (rows=3 width=8)
+ TableScan [TS_2] (rows=1 width=8)
default@myinput1,c,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: explain select * from myinput1 a join myinput1 b on a.key<=>b.value join myinput1 c on a.key<=>c.key
@@ -3461,24 +3461,24 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=6 width=8)
+ Select Operator [SEL_7] (rows=2 width=8)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Join Operator [JOIN_6] (rows=6 width=8)
+ Join Operator [JOIN_6] (rows=2 width=8)
Output:["_col0","_col1","_col5","_col6","_col10","_col11"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":0,\"right\":2}"}],keys:{"0":"key","1":"value","2":"key"}
<-Map 1 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_3]
PartitionCols:key
- TableScan [TS_0] (rows=3 width=8)
+ TableScan [TS_0] (rows=1 width=8)
default@myinput1,a,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 3 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_4]
PartitionCols:value
- TableScan [TS_1] (rows=3 width=8)
+ TableScan [TS_1] (rows=1 width=8)
default@myinput1,b,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 4 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_5]
PartitionCols:key
- TableScan [TS_2] (rows=3 width=8)
+ TableScan [TS_2] (rows=1 width=8)
default@myinput1,c,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: explain select * from myinput1 a join myinput1 b on a.key<=>b.value AND a.value=b.key join myinput1 c on a.key<=>c.key AND a.value=c.value
@@ -3496,30 +3496,30 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_11]
- Select Operator [SEL_10] (rows=6 width=8)
+ Select Operator [SEL_10] (rows=2 width=8)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Join Operator [JOIN_9] (rows=6 width=8)
+ Join Operator [JOIN_9] (rows=2 width=8)
Output:["_col0","_col1","_col5","_col6","_col10","_col11"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":0,\"right\":2}"}],keys:{"0":"key, value","1":"value, key","2":"key, value"}
<-Map 1 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_4]
PartitionCols:key, value
- Filter Operator [FIL_12] (rows=3 width=8)
+ Filter Operator [FIL_12] (rows=1 width=8)
predicate:value is not null
- TableScan [TS_0] (rows=3 width=8)
+ TableScan [TS_0] (rows=1 width=8)
default@myinput1,a,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 3 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_6]
PartitionCols:value, key
- Filter Operator [FIL_13] (rows=3 width=8)
+ Filter Operator [FIL_13] (rows=1 width=8)
predicate:key is not null
- TableScan [TS_1] (rows=3 width=8)
+ TableScan [TS_1] (rows=1 width=8)
default@myinput1,b,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 4 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_8]
PartitionCols:key, value
- Filter Operator [FIL_14] (rows=3 width=8)
+ Filter Operator [FIL_14] (rows=1 width=8)
predicate:value is not null
- TableScan [TS_2] (rows=3 width=8)
+ TableScan [TS_2] (rows=1 width=8)
default@myinput1,c,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: explain select * from myinput1 a join myinput1 b on a.key<=>b.value AND a.value<=>b.key join myinput1 c on a.key<=>c.key AND a.value<=>c.value
@@ -3537,24 +3537,24 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=6 width=8)
+ Select Operator [SEL_7] (rows=2 width=8)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Join Operator [JOIN_6] (rows=6 width=8)
+ Join Operator [JOIN_6] (rows=2 width=8)
Output:["_col0","_col1","_col5","_col6","_col10","_col11"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":0,\"right\":2}"}],keys:{"0":"key, value","1":"value, key","2":"key, value"}
<-Map 1 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_3]
PartitionCols:key, value
- TableScan [TS_0] (rows=3 width=8)
+ TableScan [TS_0] (rows=1 width=8)
default@myinput1,a,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 3 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_4]
PartitionCols:value, key
- TableScan [TS_1] (rows=3 width=8)
+ TableScan [TS_1] (rows=1 width=8)
default@myinput1,b,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 4 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_5]
PartitionCols:key, value
- TableScan [TS_2] (rows=3 width=8)
+ TableScan [TS_2] (rows=1 width=8)
default@myinput1,c,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: explain select * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key<=>b.value
@@ -3572,19 +3572,19 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_6]
- Select Operator [SEL_5] (rows=3 width=8)
+ Select Operator [SEL_5] (rows=1 width=8)
Output:["_col0","_col1","_col2","_col3"]
- Join Operator [JOIN_4] (rows=3 width=8)
+ Join Operator [JOIN_4] (rows=1 width=8)
Output:["_col0","_col1","_col5","_col6"],condition map:[{"":"{\"type\":\"Left Outer\",\"left\":0,\"right\":1}"}],keys:{"0":"key","1":"value"}
<-Map 1 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_2]
PartitionCols:key
- TableScan [TS_0] (rows=3 width=8)
+ TableScan [TS_0] (rows=1 width=8)
default@myinput1,a,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 3 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_3]
PartitionCols:value
- TableScan [TS_1] (rows=3 width=8)
+ TableScan [TS_1] (rows=1 width=8)
default@myinput1,b,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: explain select * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key<=>b.value
@@ -3602,19 +3602,19 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_6]
- Select Operator [SEL_5] (rows=3 width=8)
+ Select Operator [SEL_5] (rows=1 width=8)
Output:["_col0","_col1","_col2","_col3"]
- Join Operator [JOIN_4] (rows=3 width=8)
+ Join Operator [JOIN_4] (rows=1 width=8)
Output:["_col0","_col1","_col5","_col6"],condition map:[{"":"{\"type\":\"Right Outer\",\"left\":0,\"right\":1}"}],keys:{"0":"key","1":"value"}
<-Map 1 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_2]
PartitionCols:key
- TableScan [TS_0] (rows=3 width=8)
+ TableScan [TS_0] (rows=1 width=8)
default@myinput1,a,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 3 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_3]
PartitionCols:value
- TableScan [TS_1] (rows=3 width=8)
+ TableScan [TS_1] (rows=1 width=8)
default@myinput1,b,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: explain select * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key<=>b.value
@@ -3632,19 +3632,19 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_6]
- Select Operator [SEL_5] (rows=3 width=8)
+ Select Operator [SEL_5] (rows=1 width=8)
Output:["_col0","_col1","_col2","_col3"]
- Join Operator [JOIN_4] (rows=3 width=8)
+ Join Operator [JOIN_4] (rows=1 width=8)
Output:["_col0","_col1","_col5","_col6"],condition map:[{"":"{\"type\":\"Outer\",\"left\":0,\"right\":1}"}],keys:{"0":"key","1":"value"}
<-Map 1 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_2]
PartitionCols:key
- TableScan [TS_0] (rows=3 width=8)
+ TableScan [TS_0] (rows=1 width=8)
default@myinput1,a,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
<-Map 3 [PARTITION-LEVEL SORT]
PARTITION-LEVEL SORT [RS_3]
PartitionCols:value
- TableScan [TS_1] (rows=3 width=8)
+ TableScan [TS_1] (rows=1 width=8)
default@myinput1,b,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key<=>b.value
@@ -3659,18 +3659,18 @@ Stage-0
Stage-1
Map 1
File Output Operator [FS_6]
- Select Operator [SEL_8] (rows=3 width=8)
+ Select Operator [SEL_8] (rows=1 width=8)
Output:["_col0","_col1","_col2","_col3"]
- Map Join Operator [MAPJOIN_7] (rows=3 width=8)
+ Map Join Operator [MAPJOIN_7] (rows=1 width=8)
Conds:TS_0.key=TS_0.value(Inner),Output:["_col0","_col1","_col5","_col6"]
- <-TableScan [TS_0] (rows=3 width=8)
+ <-TableScan [TS_0] (rows=1 width=8)
default@myinput1,a,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
Map Reduce Local Work
Stage-2
Map 2
keys: [HASHTABLESINK_10]
0key,1value
- TableScan [TS_1] (rows=3 width=8)
+ TableScan [TS_1] (rows=1 width=8)
default@myinput1,b,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
Map Reduce Local Work