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 [11/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/groupby_sort_skew_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out Tue Nov 26 08:19:25 2013
@@ -66,12 +66,16 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -81,6 +85,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -88,11 +94,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -410,6 +420,8 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -418,6 +430,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -429,6 +443,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -439,6 +455,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: rand()
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -507,6 +525,8 @@ STAGE PLANS:
type: string
mode: partials
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -543,6 +563,8 @@ STAGE PLANS:
type: string
expr: _col1
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -585,6 +607,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -594,11 +618,15 @@ STAGE PLANS:
expr: UDFToInteger(_col2)
type: int
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -721,12 +749,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -736,6 +768,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -743,11 +777,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1115,12 +1153,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: _col0
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -1130,6 +1172,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -1137,11 +1181,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1533,12 +1581,16 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -1550,6 +1602,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1559,11 +1613,15 @@ STAGE PLANS:
expr: UDFToInteger(_col2)
type: int
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1921,6 +1979,8 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -1929,6 +1989,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -1942,6 +2004,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1954,6 +2018,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: rand()
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col3
@@ -2024,6 +2090,8 @@ STAGE PLANS:
type: string
mode: partials
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -2064,6 +2132,8 @@ STAGE PLANS:
type: int
expr: _col2
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col3
@@ -2108,6 +2178,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -2119,11 +2191,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2275,12 +2351,16 @@ STAGE PLANS:
t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -2292,6 +2372,8 @@ STAGE PLANS:
type: double
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -2302,6 +2384,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: rand()
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -2370,6 +2454,8 @@ STAGE PLANS:
type: double
mode: partials
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -2406,6 +2492,8 @@ STAGE PLANS:
type: string
expr: _col1
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -2448,6 +2536,8 @@ STAGE PLANS:
type: double
mode: final
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -2457,11 +2547,15 @@ STAGE PLANS:
expr: UDFToInteger(_col2)
type: int
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2641,12 +2735,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -2656,6 +2754,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -2663,6 +2763,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: sum(_col1)
@@ -2672,6 +2774,8 @@ STAGE PLANS:
type: double
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -2680,6 +2784,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: rand()
type: double
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -2746,6 +2852,8 @@ STAGE PLANS:
type: double
mode: partials
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -2778,6 +2886,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: double
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -2818,6 +2928,8 @@ STAGE PLANS:
type: double
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -2825,11 +2937,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3021,12 +3137,16 @@ STAGE PLANS:
null-subquery1:subq1-subquery1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -3036,6 +3156,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -3043,7 +3165,11 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -3051,11 +3177,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3083,12 +3213,16 @@ STAGE PLANS:
null-subquery2:subq1-subquery2:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -3098,6 +3232,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -3105,7 +3241,11 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -3113,11 +3253,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3556,12 +3700,16 @@ STAGE PLANS:
null-subquery2:subq1-subquery2:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -3571,6 +3719,8 @@ STAGE PLANS:
type: double
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -3579,6 +3729,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: rand()
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -3645,6 +3797,8 @@ STAGE PLANS:
type: double
mode: partials
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -3677,6 +3831,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -3717,6 +3873,8 @@ STAGE PLANS:
type: double
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -3724,6 +3882,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -3749,6 +3909,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -3756,11 +3918,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3788,12 +3954,16 @@ STAGE PLANS:
null-subquery1:subq1-subquery1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -3803,6 +3973,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToDouble(_col0)
@@ -3810,7 +3982,11 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -3818,11 +3994,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4281,12 +4461,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -4296,6 +4480,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4303,6 +4489,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -4311,6 +4499,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: _col0
@@ -4320,12 +4510,16 @@ STAGE PLANS:
subq2:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -4335,6 +4529,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4342,6 +4538,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -4350,6 +4548,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: _col1
@@ -4415,6 +4615,8 @@ STAGE PLANS:
1 {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col3
+ Statistics:
+ numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -4422,11 +4624,15 @@ STAGE PLANS:
expr: UDFToInteger((_col1 + _col3))
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4634,6 +4840,8 @@ STAGE PLANS:
subq2:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -4642,6 +4850,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -4653,6 +4863,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -4663,6 +4875,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: rand()
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -4731,6 +4945,8 @@ STAGE PLANS:
type: string
mode: partials
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -4767,6 +4983,8 @@ STAGE PLANS:
type: string
expr: _col1
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col2
@@ -4809,6 +5027,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4818,6 +5038,8 @@ STAGE PLANS:
expr: _col2
type: bigint
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -4850,6 +5072,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: _col0
@@ -4861,12 +5085,16 @@ STAGE PLANS:
subq1:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -4876,6 +5104,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4883,6 +5113,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -4891,6 +5123,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: _col0
@@ -4979,6 +5213,8 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4992,11 +5228,15 @@ STAGE PLANS:
expr: _col4
type: bigint
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 4 dataSize: 32 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5152,12 +5392,16 @@ STAGE PLANS:
t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -5167,6 +5411,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -5175,6 +5421,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: rand()
type: double
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -5241,6 +5489,8 @@ STAGE PLANS:
type: string
mode: partials
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -5273,6 +5523,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -5313,6 +5565,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -5320,11 +5574,15 @@ STAGE PLANS:
expr: UDFToInteger(_col1)
type: int
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -5536,6 +5794,8 @@ STAGE PLANS:
t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -5544,6 +5804,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -5557,6 +5819,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -5568,11 +5832,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -6069,6 +6337,8 @@ STAGE PLANS:
t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -6077,6 +6347,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: key, val
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -6092,6 +6364,8 @@ STAGE PLANS:
type: int
mode: final
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -6105,11 +6379,15 @@ STAGE PLANS:
expr: UDFToInteger(_col4)
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -6543,6 +6821,8 @@ STAGE PLANS:
subq:t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -6553,6 +6833,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -6566,6 +6848,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -6577,11 +6861,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -7075,6 +7363,8 @@ STAGE PLANS:
subq2:subq:t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -7085,6 +7375,8 @@ STAGE PLANS:
expr: val
type: string
outputColumnNames: _col0, _col3, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -7098,6 +7390,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -7109,11 +7403,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 3 dataSize: 12 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/input23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input23.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input23.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input23.q.out Tue Nov 26 08:19:25 2013
@@ -18,9 +18,13 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -34,14 +38,20 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((ds = '2008-04-08') and (hr = '14'))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -109,6 +119,8 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col2, _col3, _col6, _col7, _col8, _col9
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -128,12 +140,18 @@ STAGE PLANS:
expr: _col9
type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ 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/input42.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input42.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input42.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input42.q.out Tue Nov 26 08:19:25 2013
@@ -18,6 +18,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -30,6 +32,8 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -37,6 +41,8 @@ STAGE PLANS:
expr: _col3
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -140,11 +146,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### 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
@@ -1198,12 +1208,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 < 200)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1215,6 +1229,8 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1222,6 +1238,8 @@ STAGE PLANS:
expr: _col3
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1325,11 +1343,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### 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
@@ -1761,12 +1783,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (rand(100) < 0.1)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1778,6 +1804,8 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1785,6 +1813,8 @@ STAGE PLANS:
expr: _col3
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1888,11 +1918,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### 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
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input8.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input8.q.out Tue Nov 26 08:19:25 2013
@@ -34,10 +34,10 @@ STAGE PLANS:
Select Operator
expressions:
expr: (4 + null)
- type: int
+ type: double
expr: UDFToInteger((key - null))
type: int
- expr: UDFToDouble((null + null))
+ expr: (null + null)
type: double
outputColumnNames: _col0, _col1, _col2
File Output Operator
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input_part1.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input_part1.q.out Tue Nov 26 08:19:25 2013
@@ -31,12 +31,16 @@ STAGE PLANS:
srcpart
TableScan
alias: srcpart
+ 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: UDFToInteger(key)
@@ -48,11 +52,15 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 2906 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/input_part2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input_part2.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input_part2.q.out Tue Nov 26 08:19:25 2013
@@ -45,12 +45,16 @@ STAGE PLANS:
srcpart
TableScan
alias: srcpart
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key < 100) and (ds = '2008-04-08'))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(key)
@@ -62,11 +66,15 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ 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
@@ -91,6 +99,8 @@ STAGE PLANS:
predicate:
expr: ((key < 100) and (ds = '2008-04-09'))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(key)
@@ -102,11 +112,15 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 2
#### 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
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input_part7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input_part7.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input_part7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input_part7.q.out Tue Nov 26 08:19:25 2013
@@ -28,12 +28,16 @@ STAGE PLANS:
null-subquery1:a-subquery1:x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 100)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -45,7 +49,11 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -57,6 +65,8 @@ STAGE PLANS:
expr: _col3
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -68,6 +78,8 @@ STAGE PLANS:
expr: _col3
type: string
sort order: ++++
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -81,12 +93,16 @@ STAGE PLANS:
null-subquery2:a-subquery2:y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 100)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -98,7 +114,11 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -110,6 +130,8 @@ STAGE PLANS:
expr: _col3
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -121,6 +143,8 @@ STAGE PLANS:
expr: _col3
type: string
sort order: ++++
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -224,11 +248,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### 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
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input_part9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input_part9.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input_part9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input_part9.q.out Tue Nov 26 08:19:25 2013
@@ -18,12 +18,16 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: key is not null
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -35,6 +39,8 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -42,6 +48,8 @@ STAGE PLANS:
expr: _col3
type: string
sort order: ++
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -145,11 +153,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### 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
Modified: hive/branches/tez/ql/src/test/results/clientpositive/insert_into3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/insert_into3.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/insert_into3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/insert_into3.q.out Tue Nov 26 08:19:25 2013
@@ -16,14 +16,14 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE insert_into3b (key int, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@insert_into3b
-PREHOOK: query: EXPLAIN FROM src INSERT INTO TABLE insert_into3a SELECT * LIMIT 50
- INSERT INTO TABLE insert_into3b SELECT * LIMIT 100
+PREHOOK: query: EXPLAIN FROM src INSERT INTO TABLE insert_into3a SELECT * ORDER BY key, value LIMIT 50
+ INSERT INTO TABLE insert_into3b SELECT * ORDER BY key, value LIMIT 100
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN FROM src INSERT INTO TABLE insert_into3a SELECT * LIMIT 50
- INSERT INTO TABLE insert_into3b SELECT * LIMIT 100
+POSTHOOK: query: EXPLAIN FROM src INSERT INTO TABLE insert_into3a SELECT * ORDER BY key, value LIMIT 50
+ INSERT INTO TABLE insert_into3b SELECT * ORDER BY key, value LIMIT 100
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_INSERT_INTO (TOK_TAB (TOK_TABNAME insert_into3a))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 50)) (TOK_INSERT (TOK_INSERT_INTO (TOK_TAB (TOK_TABNAME insert_into3b))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 100)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_INSERT_INTO (TOK_TAB (TOK_TABNAME insert_into3a))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value))) (TOK_LIMIT 50)) (TOK_INSERT (TOK_INSERT_INTO (TOK_TAB (TOK_TABNAME insert_into3b))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value))) (TOK_LIMIT 100)))
STAGE DEPENDENCIES:
Stage-2 is a root stage
@@ -47,15 +47,19 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
- Limit
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
Select Operator
expressions:
expr: key
@@ -63,14 +67,13 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
Reduce Operator Tree:
Extract
Limit
@@ -109,7 +112,12 @@ STAGE PLANS:
#### A masked pattern was here ####
TableScan
Reduce Output Operator
- sort order:
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
tag: -1
value expressions:
expr: _col0
@@ -149,14 +157,14 @@ STAGE PLANS:
Stats-Aggr Operator
-PREHOOK: query: FROM src INSERT INTO TABLE insert_into3a SELECT * LIMIT 50
- INSERT INTO TABLE insert_into3b SELECT * LIMIT 100
+PREHOOK: query: FROM src INSERT INTO TABLE insert_into3a SELECT * ORDER BY key, value LIMIT 50
+ INSERT INTO TABLE insert_into3b SELECT * ORDER BY key, value LIMIT 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@insert_into3a
PREHOOK: Output: default@insert_into3b
-POSTHOOK: query: FROM src INSERT INTO TABLE insert_into3a SELECT * LIMIT 50
- INSERT INTO TABLE insert_into3b SELECT * LIMIT 100
+POSTHOOK: query: FROM src INSERT INTO TABLE insert_into3a SELECT * ORDER BY key, value LIMIT 50
+ INSERT INTO TABLE insert_into3b SELECT * ORDER BY key, value LIMIT 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@insert_into3a
@@ -181,7 +189,7 @@ POSTHOOK: Lineage: insert_into3a.key EXP
POSTHOOK: Lineage: insert_into3a.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: insert_into3b.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: insert_into3b.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-7813690682
+-1254133670
PREHOOK: query: SELECT SUM(HASH(c)) FROM (
SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into3b
) t
@@ -198,7 +206,7 @@ POSTHOOK: Lineage: insert_into3a.key EXP
POSTHOOK: Lineage: insert_into3a.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: insert_into3b.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: insert_into3b.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-10226524244
+-1142373758
PREHOOK: query: EXPLAIN FROM src INSERT OVERWRITE TABLE insert_into3a SELECT * LIMIT 10
INSERT INTO TABLE insert_into3b SELECT * LIMIT 10
PREHOOK: type: QUERY
@@ -397,7 +405,7 @@ POSTHOOK: Lineage: insert_into3b.key EXP
POSTHOOK: Lineage: insert_into3b.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: insert_into3b.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: insert_into3b.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-9399898328
+-1968999674
PREHOOK: query: DROP TABLE insert_into3a
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@insert_into3a
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join17.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join17.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join17.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
@@ -44,6 +48,8 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -53,6 +59,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
@@ -116,6 +124,8 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -127,11 +137,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: 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/join26.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join26.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join26.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join26.q.out Tue Nov 26 08:19:25 2013
@@ -43,6 +43,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -58,6 +60,8 @@ STAGE PLANS:
y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -77,6 +81,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -93,6 +99,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
@@ -102,11 +110,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