You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by rh...@apache.org on 2013/11/18 20:29:27 UTC
svn commit: r1543120 [12/16] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/ data/files/
ql/src/java/org/apache/hadoop/hive/ql/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/...
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out Mon Nov 18 19:29:24 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: 6 dataSize: 24 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: 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
@@ -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: 6 dataSize: 24 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: 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
@@ -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: 6 dataSize: 24 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: 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
@@ -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: 6 dataSize: 24 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: 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
@@ -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: 6 dataSize: 24 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: 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
@@ -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: 6 dataSize: 24 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: 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
@@ -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: 6 dataSize: 24 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: 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
@@ -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: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -2663,6 +2763,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 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: 6 dataSize: 24 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: 6 dataSize: 24 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: 6 dataSize: 24 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: 6 dataSize: 24 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: 6 dataSize: 24 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: 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
@@ -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: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -3043,7 +3165,11 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 12 dataSize: 48 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: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 12 dataSize: 48 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: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -3105,7 +3241,11 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 12 dataSize: 48 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: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 12 dataSize: 48 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: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -3724,6 +3882,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -3749,6 +3909,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 12 dataSize: 48 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: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 12 dataSize: 48 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: 6 dataSize: 24 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: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 12 dataSize: 48 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: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 12 dataSize: 48 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: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4303,6 +4489,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 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: 6 dataSize: 24 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: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4342,6 +4538,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 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: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: _col1
@@ -4634,6 +4834,8 @@ STAGE PLANS:
subq2:t1
TableScan
alias: t1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -4642,6 +4844,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 +4857,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 +4869,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 +4939,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 +4977,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 +5021,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4818,6 +5032,8 @@ STAGE PLANS:
expr: _col2
type: bigint
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -4850,6 +5066,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: _col0
@@ -4861,12 +5079,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 +5098,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4883,6 +5107,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -4891,6 +5117,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: _col0
@@ -5152,12 +5380,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 +5399,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 +5409,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 +5477,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 +5511,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 +5553,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -5320,11 +5562,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
@@ -5536,6 +5782,8 @@ STAGE PLANS:
t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -5544,6 +5792,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 +5807,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -5568,11 +5820,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ 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
@@ -6069,6 +6325,8 @@ STAGE PLANS:
t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -6077,6 +6335,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 +6352,8 @@ STAGE PLANS:
type: int
mode: final
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -6105,11 +6367,15 @@ STAGE PLANS:
expr: UDFToInteger(_col4)
type: int
outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ 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
@@ -6543,6 +6809,8 @@ STAGE PLANS:
subq:t2
TableScan
alias: t2
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -6553,6 +6821,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 +6836,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -6577,11 +6849,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ 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
@@ -7075,6 +7351,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 +7363,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 +7378,8 @@ STAGE PLANS:
type: string
mode: final
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -7109,11 +7391,15 @@ STAGE PLANS:
expr: UDFToInteger(_col3)
type: int
outputColumnNames: _col0, _col1, _col2, _col3
+ 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
Modified: hive/trunk/ql/src/test/results/clientpositive/input23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input23.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input23.q.out Mon Nov 18 19:29:24 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
Modified: hive/trunk/ql/src/test/results/clientpositive/input42.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input42.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input42.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input42.q.out Mon Nov 18 19:29:24 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: 11624 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: 11624 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: 11624 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: 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
@@ -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: 11624 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: 11624 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: 11624 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: 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/trunk/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Mon Nov 18 19:29:24 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: 5812 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: 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
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Mon Nov 18 19:29:24 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: 11624 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: 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
@@ -91,6 +99,8 @@ STAGE PLANS:
predicate:
expr: ((key < 100) and (ds = '2008-04-09'))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 11624 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: 11624 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 2
#### 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/trunk/ql/src/test/results/clientpositive/input_part7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out Mon Nov 18 19:29:24 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: 11624 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: 11624 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 23248 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: 23248 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: 23248 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: 11624 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: 11624 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 23248 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: 23248 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: 23248 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: 23248 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out Mon Nov 18 19:29:24 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: 11624 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: 11624 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: 11624 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: 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/trunk/ql/src/test/results/clientpositive/join17.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join17.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join17.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join17.q.out Mon Nov 18 19:29:24 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
Modified: hive/trunk/ql/src/test/results/clientpositive/join26.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join26.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join26.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join26.q.out Mon Nov 18 19:29:24 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:
Modified: hive/trunk/ql/src/test/results/clientpositive/join32.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join32.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join32.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join32.q.out Mon Nov 18 19:29:24 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:
Modified: hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out Mon Nov 18 19:29:24 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:
@@ -560,6 +566,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 +585,8 @@ STAGE PLANS:
w
TableScan
alias: w
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -1390,6 +1400,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 +1411,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 +1420,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 +1431,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
@@ -1745,6 +1763,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 +1782,8 @@ STAGE PLANS:
res:y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -1943,6 +1965,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -2276,6 +2300,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 +2319,8 @@ STAGE PLANS:
res:x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -2474,6 +2502,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/join33.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join33.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join33.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join33.q.out Mon Nov 18 19:29:24 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:
Modified: hive/trunk/ql/src/test/results/clientpositive/join34.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join34.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join34.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join34.q.out Mon Nov 18 19:29:24 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: 5812 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: 5812 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -126,12 +136,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: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -139,7 +153,11 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Map Join Operator
condition map:
Inner Join 0 to 1