You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/26 09:19:34 UTC
svn commit: r1545564 [8/22] - in /hive/branches/tez: ./ ant/ beeline/ bin/
cli/ common/ common/src/java/org/apache/hadoop/hive/common/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hadoop/hive/conf/ common/src/test/org/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin10.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin10.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin10.q.out Tue Nov 26 08:19:25 2013
@@ -216,6 +216,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 6950 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -233,6 +235,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 6950 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -245,15 +249,23 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -360,16 +372,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin11.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin11.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin11.q.out Tue Nov 26 08:19:25 2013
@@ -222,6 +222,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 8562 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -246,6 +248,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 8562 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -258,16 +262,24 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -374,16 +386,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -540,6 +558,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 8562 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -564,6 +584,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 8562 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -576,16 +598,24 @@ STAGE PLANS:
0 [Column[key], Column[part]]
1 [Column[key], Column[part]]
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -692,16 +722,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin12.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin12.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin12.q.out Tue Nov 26 08:19:25 2013
@@ -148,6 +148,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -172,6 +174,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -184,16 +188,24 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -256,16 +268,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -380,6 +398,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -397,6 +417,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -409,15 +431,23 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -480,16 +510,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -510,6 +546,7 @@ STAGE PLANS:
Fetch Operator
limit: -1
+
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ count(*)
FROM srcbucket_mapjoin_part_1 a JOIN srcbucket_mapjoin_part_3 b
ON a.key = b.key AND a.part = '1' and b.part = '1'
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin13.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin13.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin13.q.out Tue Nov 26 08:19:25 2013
@@ -155,6 +155,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -172,6 +174,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 1000 dataSize: 10624 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -184,15 +188,23 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 250000 dataSize: 5000000 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
+ Statistics:
+ numRows: 250000 dataSize: 5000000 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -299,16 +311,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -438,6 +456,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -462,6 +482,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -474,16 +496,24 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
BucketMapJoin: true
Select Operator
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -546,16 +576,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -697,6 +733,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -721,6 +759,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -733,16 +773,24 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
BucketMapJoin: true
Select Operator
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -805,16 +853,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -958,6 +1012,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -982,6 +1038,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -994,16 +1052,24 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
BucketMapJoin: true
Select Operator
+ Statistics:
+ numRows: 125000 dataSize: 2500000 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1066,16 +1132,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin2.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin2.q.out Tue Nov 26 08:19:25 2013
@@ -140,6 +140,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 3062 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -164,6 +166,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -177,6 +181,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col6
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -187,11 +193,15 @@ STAGE PLANS:
expr: _col6
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -676,6 +686,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -700,6 +712,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 3062 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -713,6 +727,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col6
Position of Big Table: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -723,11 +739,15 @@ STAGE PLANS:
expr: _col6
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1452,6 +1472,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 6124 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -1476,6 +1498,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -1489,6 +1513,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col6
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -1499,11 +1525,15 @@ STAGE PLANS:
expr: _col6
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin3.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin3.q.out Tue Nov 26 08:19:25 2013
@@ -157,6 +157,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -181,6 +183,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 3062 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -194,6 +198,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col6
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -204,11 +210,15 @@ STAGE PLANS:
expr: _col6
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -693,6 +703,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 3062 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -717,6 +729,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -730,6 +744,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col6
Position of Big Table: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -740,11 +756,15 @@ STAGE PLANS:
expr: _col6
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin4.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin4.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin4.q.out Tue Nov 26 08:19:25 2013
@@ -115,6 +115,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -139,6 +141,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -152,6 +156,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -162,11 +168,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -598,6 +608,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -622,6 +634,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -635,6 +649,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col5
Position of Big Table: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -645,11 +661,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin5.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin5.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin5.q.out Tue Nov 26 08:19:25 2013
@@ -153,6 +153,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -177,6 +179,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -190,6 +194,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col5
Position of Big Table: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -200,11 +206,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -494,6 +504,7 @@ STAGE PLANS:
hdfs directory: true
#### A masked pattern was here ####
+
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
select /*+mapjoin(a)*/ a.key, a.value, b.value
from srcbucket_mapjoin a join srcbucket_mapjoin_part b
@@ -690,6 +701,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -714,6 +727,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 6124 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -727,6 +742,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col5
Position of Big Table: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -737,11 +754,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin7.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin7.q.out Tue Nov 26 08:19:25 2013
@@ -114,6 +114,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -138,6 +140,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -151,6 +155,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col7
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -159,12 +165,18 @@ STAGE PLANS:
expr: _col7
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Limit
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin8.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin8.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin8.q.out Tue Nov 26 08:19:25 2013
@@ -121,6 +121,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -145,6 +147,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -157,16 +161,24 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -229,16 +241,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -362,6 +380,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -386,6 +406,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -398,16 +420,24 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -470,16 +500,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin9.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin9.q.out Tue Nov 26 08:19:25 2013
@@ -127,6 +127,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -144,6 +146,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -156,15 +160,23 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -227,16 +239,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -389,6 +407,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -406,6 +426,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -418,15 +440,23 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: count()
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -489,16 +519,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out Tue Nov 26 08:19:25 2013
@@ -123,6 +123,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -140,6 +142,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -153,6 +157,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -162,11 +168,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out Tue Nov 26 08:19:25 2013
@@ -171,6 +171,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 6124 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -195,6 +197,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 2750 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -208,6 +212,8 @@ STAGE PLANS:
1 [Column[key]]
outputColumnNames: _col0, _col1, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -218,11 +224,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out Tue Nov 26 08:19:25 2013
@@ -131,6 +131,8 @@ STAGE PLANS:
r
TableScan
alias: r
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -155,6 +157,8 @@ STAGE PLANS:
l
TableScan
alias: l
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -168,6 +172,8 @@ STAGE PLANS:
1 [Column[key], Column[value]]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -180,11 +186,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -282,6 +292,8 @@ STAGE PLANS:
r
TableScan
alias: r
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -306,6 +318,8 @@ STAGE PLANS:
l
TableScan
alias: l
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -319,6 +333,8 @@ STAGE PLANS:
1 [Column[key], Column[value]]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
BucketMapJoin: true
Select Operator
expressions:
@@ -331,11 +347,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -435,6 +455,8 @@ STAGE PLANS:
r
TableScan
alias: r
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -442,8 +464,8 @@ STAGE PLANS:
1 {key} {value}
handleSkewJoin: false
keys:
- 0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key], Column[key]()]
- 1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
+ 0 [GenericUDFOPPlus(Column[key], Column[key])]
+ 1 [GenericUDFBridge(Column[key])]
Position of Big Table: 0
Stage: Stage-1
@@ -452,6 +474,8 @@ STAGE PLANS:
l
TableScan
alias: l
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -461,10 +485,12 @@ STAGE PLANS:
1 {key} {value}
handleSkewJoin: false
keys:
- 0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key], Column[key]()]
- 1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
+ 0 [GenericUDFOPPlus(Column[key], Column[key])]
+ 1 [GenericUDFBridge(Column[key])]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -476,11 +502,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -578,6 +608,8 @@ STAGE PLANS:
r
TableScan
alias: r
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -595,6 +627,8 @@ STAGE PLANS:
l
TableScan
alias: l
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -608,6 +642,8 @@ STAGE PLANS:
1 [Column[key], Column[value]]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -619,11 +655,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -721,6 +761,8 @@ STAGE PLANS:
r
TableScan
alias: r
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -738,6 +780,8 @@ STAGE PLANS:
l
TableScan
alias: l
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -751,6 +795,8 @@ STAGE PLANS:
1 [Column[key], Column[value]]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -762,11 +808,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -864,6 +914,8 @@ STAGE PLANS:
r
TableScan
alias: r
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -881,6 +933,8 @@ STAGE PLANS:
l
TableScan
alias: l
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -894,6 +948,8 @@ STAGE PLANS:
1 [Column[key], Column[value]]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -905,11 +961,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1007,6 +1067,8 @@ STAGE PLANS:
r
TableScan
alias: r
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -1024,6 +1086,8 @@ STAGE PLANS:
l
TableScan
alias: l
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -1037,6 +1101,8 @@ STAGE PLANS:
1 [Column[key], Column[value]]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1048,11 +1114,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1150,6 +1220,8 @@ STAGE PLANS:
r
TableScan
alias: r
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -1167,6 +1239,8 @@ STAGE PLANS:
l
TableScan
alias: l
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -1180,6 +1254,8 @@ STAGE PLANS:
1 [Column[key], Column[value]]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1191,11 +1267,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1293,6 +1373,8 @@ STAGE PLANS:
r
TableScan
alias: r
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -1310,6 +1392,8 @@ STAGE PLANS:
l
TableScan
alias: l
+ Statistics:
+ numRows: 0 dataSize: 4200 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -1323,6 +1407,8 @@ STAGE PLANS:
1 [Column[key], Column[value]]
outputColumnNames: _col0, _col1, _col4, _col5
Position of Big Table: 0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1334,11 +1420,15 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/combine2_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/combine2_hadoop20.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/combine2_hadoop20.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/combine2_hadoop20.q.out Tue Nov 26 08:19:25 2013
@@ -219,16 +219,24 @@ STAGE PLANS:
combine2
TableScan
alias: combine2
+ Statistics:
+ numRows: 12 dataSize: 14 basicStatsState: COMPLETE colStatsState: COMPLETE
GatherStats: false
Select Operator
+ Statistics:
+ numRows: 12 dataSize: 14 basicStatsState: COMPLETE colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(1)
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col0
@@ -581,16 +589,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/ctas_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas_hadoop20.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas_hadoop20.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas_hadoop20.q.out Tue Nov 26 08:19:25 2013
@@ -754,6 +754,8 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -762,6 +764,8 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -769,6 +773,8 @@ STAGE PLANS:
expr: _col1
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -825,7 +831,11 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -857,6 +867,8 @@ STAGE PLANS:
expr: _col1
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -891,12 +903,18 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat