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 [12/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/join32.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join32.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join32.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join32.q.out Tue Nov 26 08:19:25 2013
@@ -84,6 +84,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -97,6 +99,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -114,6 +118,8 @@ STAGE PLANS:
y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -148,11 +154,15 @@ STAGE PLANS:
expr: _col1
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/join32_lessSize.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join32_lessSize.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join32_lessSize.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join32_lessSize.q.out Tue Nov 26 08:19:25 2013
@@ -46,6 +46,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -63,6 +65,8 @@ STAGE PLANS:
y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -237,6 +241,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -275,11 +281,15 @@ STAGE PLANS:
expr: _col1
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
@@ -560,6 +570,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -577,6 +589,8 @@ STAGE PLANS:
w
TableScan
alias: w
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -1383,6 +1397,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col4
type: string
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
tag: 0
value expressions:
expr: _col4
@@ -1390,6 +1406,8 @@ STAGE PLANS:
y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -1399,6 +1417,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: value
@@ -1406,6 +1426,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -1415,6 +1437,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
tag: 2
value expressions:
expr: value
@@ -1542,6 +1566,8 @@ STAGE PLANS:
2 {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col4, _col9, _col13
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col4
@@ -1551,11 +1577,15 @@ STAGE PLANS:
expr: _col9
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
@@ -1745,6 +1775,8 @@ STAGE PLANS:
res:x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -1762,6 +1794,8 @@ STAGE PLANS:
res:y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -1782,6 +1816,8 @@ STAGE PLANS:
expr: _col1
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1943,6 +1979,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -1981,11 +2019,15 @@ STAGE PLANS:
expr: _col1
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
@@ -2276,6 +2318,8 @@ STAGE PLANS:
res:y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -2293,6 +2337,8 @@ STAGE PLANS:
res:x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -2313,6 +2359,8 @@ STAGE PLANS:
expr: _col1
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -2474,6 +2522,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -2512,11 +2562,15 @@ STAGE PLANS:
expr: _col1
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/join33.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join33.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join33.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join33.q.out Tue Nov 26 08:19:25 2013
@@ -84,6 +84,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -97,6 +99,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -114,6 +118,8 @@ STAGE PLANS:
y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -148,11 +154,15 @@ STAGE PLANS:
expr: _col1
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/join34.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join34.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join34.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join34.q.out Tue Nov 26 08:19:25 2013
@@ -47,6 +47,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -64,12 +66,16 @@ STAGE PLANS:
null-subquery1:subq1-subquery1:x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 20)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -77,7 +83,11 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -99,11 +109,15 @@ STAGE PLANS:
expr: _col1
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
@@ -126,12 +140,16 @@ STAGE PLANS:
null-subquery2:subq1-subquery2:x1
TableScan
alias: x1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key > 100)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -139,7 +157,11 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -161,11 +183,15 @@ STAGE PLANS:
expr: _col1
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/join35.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join35.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join35.q.out Tue Nov 26 08:19:25 2013
@@ -49,17 +49,23 @@ STAGE PLANS:
null-subquery1:subq1-subquery1:x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 20)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -69,6 +75,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -77,6 +85,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -139,6 +149,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -146,6 +158,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -591,6 +605,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -599,6 +615,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: _col1
@@ -607,6 +625,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -615,6 +635,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: _col1
@@ -622,6 +644,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -631,6 +655,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -735,6 +761,8 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col2
@@ -744,11 +772,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
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
@@ -775,17 +807,23 @@ STAGE PLANS:
null-subquery2:subq1-subquery2:x1
TableScan
alias: x1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key > 100)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -795,6 +833,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -803,6 +843,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -865,6 +907,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -872,6 +916,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 1453 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join9.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join9.q.out Tue Nov 26 08:19:25 2013
@@ -26,6 +26,8 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -35,6 +37,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -42,6 +46,8 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -51,6 +57,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: value
@@ -155,6 +163,8 @@ STAGE PLANS:
1 {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col7
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -162,11 +172,15 @@ STAGE PLANS:
expr: _col7
type: string
outputColumnNames: _col0, _col1
+ 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/join_filters_overlap.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out Tue Nov 26 08:19:25 2013
@@ -29,6 +29,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -38,6 +40,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -47,12 +51,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 50)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -61,6 +69,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -70,12 +80,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -84,6 +98,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -155,6 +171,8 @@ STAGE PLANS:
2
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -170,11 +188,15 @@ STAGE PLANS:
expr: _col9
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ 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
@@ -238,12 +260,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 50)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -252,6 +278,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -261,6 +289,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -270,6 +300,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -279,12 +311,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -293,6 +329,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -364,6 +402,8 @@ STAGE PLANS:
2
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -379,11 +419,15 @@ STAGE PLANS:
expr: _col9
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ 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
@@ -447,12 +491,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 50)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -461,6 +509,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -470,6 +520,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -479,6 +531,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -488,12 +542,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -502,6 +560,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -573,6 +633,8 @@ STAGE PLANS:
2
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -588,11 +650,15 @@ STAGE PLANS:
expr: _col9
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ 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
@@ -656,6 +722,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -665,6 +733,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -674,6 +744,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -683,6 +755,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -692,12 +766,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -706,6 +784,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -715,12 +795,16 @@ STAGE PLANS:
d
TableScan
alias: d
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 40)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -729,6 +813,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 3
value expressions:
expr: key
@@ -804,6 +890,8 @@ STAGE PLANS:
3
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ Statistics:
+ numRows: 1 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -823,11 +911,15 @@ STAGE PLANS:
expr: _col13
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ Statistics:
+ numRows: 1 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -882,6 +974,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -891,6 +985,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -900,12 +996,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 50)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -914,6 +1014,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -923,12 +1025,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -937,6 +1043,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -946,12 +1054,16 @@ STAGE PLANS:
d
TableScan
alias: d
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 40)
type: boolean
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -960,6 +1072,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 1 dataSize: 6 basicStatsState: COMPLETE colStatsState: NONE
tag: 3
value expressions:
expr: key
@@ -1034,6 +1148,8 @@ STAGE PLANS:
3
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1053,11 +1169,15 @@ STAGE PLANS:
expr: _col13
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ 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/join_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join_map_ppr.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join_map_ppr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join_map_ppr.q.out Tue Nov 26 08:19:25 2013
@@ -45,6 +45,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -60,6 +62,8 @@ STAGE PLANS:
y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -79,6 +83,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -95,6 +101,8 @@ STAGE PLANS:
2 [Column[key]]
outputColumnNames: _col0, _col5, _col9
Position of Big Table: 2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -104,11 +112,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
@@ -590,6 +602,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 25 dataSize: 191 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -598,13 +612,15 @@ STAGE PLANS:
2 {value}
handleSkewJoin: false
keys:
- 0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- 1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- 2 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
+ 0 [GenericUDFBridge(Column[key])]
+ 1 [GenericUDFBridge(Column[key])]
+ 2 [GenericUDFBridge(Column[key])]
Position of Big Table: 2
y
TableScan
alias: y
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -613,9 +629,9 @@ STAGE PLANS:
2 {value}
handleSkewJoin: false
keys:
- 0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- 1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- 2 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
+ 0 [GenericUDFBridge(Column[key])]
+ 1 [GenericUDFBridge(Column[key])]
+ 2 [GenericUDFBridge(Column[key])]
Position of Big Table: 2
Stage: Stage-1
@@ -624,6 +640,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -635,11 +653,13 @@ STAGE PLANS:
2 {value}
handleSkewJoin: false
keys:
- 0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- 1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- 2 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
+ 0 [GenericUDFBridge(Column[key])]
+ 1 [GenericUDFBridge(Column[key])]
+ 2 [GenericUDFBridge(Column[key])]
outputColumnNames: _col0, _col5, _col9
Position of Big Table: 2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -649,11 +669,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/list_bucket_dml_10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out Tue Nov 26 08:19:25 2013
@@ -69,6 +69,8 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -77,12 +79,16 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Static Partition Specification: ds=2008-04-08/hr=11/
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/literal_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/literal_decimal.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/literal_decimal.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/literal_decimal.q.out Tue Nov 26 08:19:25 2013
@@ -18,7 +18,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (- 1)
- type: decimal(65,30)
+ type: decimal(38,18)
expr: 0
type: decimal(1,0)
expr: 1
@@ -26,7 +26,7 @@ STAGE PLANS:
expr: 3.14
type: decimal(3,2)
expr: (- 3.14)
- type: decimal(65,30)
+ type: decimal(38,18)
expr: 99999999999999999
type: decimal(17,0)
expr: 99999999999999999.9999999999999
Modified: hive/branches/tez/ql/src/test/results/clientpositive/load_dyn_part8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/load_dyn_part8.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/load_dyn_part8.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/load_dyn_part8.q.out Tue Nov 26 08:19:25 2013
@@ -54,12 +54,16 @@ STAGE PLANS:
srcpart
TableScan
alias: srcpart
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (ds <= '2008-04-08')
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -71,11 +75,15 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -101,6 +109,8 @@ STAGE PLANS:
predicate:
expr: (ds > '2008-04-08')
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -110,12 +120,16 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 2
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Static Partition Specification: ds=2008-12-31/
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/louter_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/louter_join_ppr.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/louter_join_ppr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/louter_join_ppr.q.out Tue Nov 26 08:19:25 2013
@@ -30,12 +30,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -44,6 +48,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -53,12 +59,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -67,6 +77,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -216,11 +228,15 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: ((_col4 > 15) and (_col4 < 25))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -232,11 +248,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
@@ -328,12 +348,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -342,6 +366,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -353,12 +379,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -367,6 +397,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -607,11 +639,15 @@ STAGE PLANS:
1
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col6, _col7
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: ((_col6 > 15) and (_col6 < 25))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -623,11 +659,15 @@ STAGE PLANS:
expr: _col7
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
@@ -723,12 +763,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -737,6 +781,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -746,12 +792,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -760,6 +810,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -997,11 +1049,15 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5, _col6
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: (((_col4 > 15) and (_col4 < 25)) and (_col6 = '2008-04-08'))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1013,11 +1069,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
@@ -1113,12 +1173,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -1127,6 +1191,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -1136,12 +1202,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -1150,6 +1220,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -1299,11 +1371,15 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col6, _col7
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Filter Operator
isSamplingPred: false
predicate:
expr: ((_col6 > 15) and (_col6 < 25))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1315,11 +1391,15 @@ STAGE PLANS:
expr: _col7
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/macro.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/macro.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/macro.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/macro.q.out Tue Nov 26 08:19:25 2013
@@ -54,13 +54,19 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: SIGMOID(2)
type: double
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
ListSink
@@ -124,13 +130,19 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: (FIXED_NUMBER() + 1)
type: int
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
ListSink
@@ -215,13 +227,19 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: SIMPLE_ADD(1, 9)
type: int
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
ListSink
Modified: hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out Tue Nov 26 08:19:25 2013
@@ -74,6 +74,8 @@ STAGE PLANS:
merge_src
TableScan
alias: merge_src
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -82,11 +84,15 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2403,6 +2409,8 @@ STAGE PLANS:
merge_src_part
TableScan
alias: merge_src_part
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -2413,11 +2421,15 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4838,6 +4850,8 @@ STAGE PLANS:
s:merge_src_part
TableScan
alias: merge_src_part
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -4848,11 +4862,15 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
Map-reduce partition columns:
expr: _col2
type: string
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -4952,6 +4970,8 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4961,11 +4981,15 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 2000 dataSize: 21248 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/metadata_only_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/metadata_only_queries.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/metadata_only_queries.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/metadata_only_queries.q.out Tue Nov 26 08:19:25 2013
@@ -986,7 +986,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).si SIMPLE [(over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
-9486 9486 9486 9486 9486 9486 65791 0 99.9800033569336 0.0
+9489 9489 9489 9489 9489 9489 65791 0 99.9800033569336 0.0
PREHOOK: query: explain select count(ts) from stats_tbl_part
PREHOOK: type: QUERY
POSTHOOK: query: explain select count(ts) from stats_tbl_part