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 [13/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/join35.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join35.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join35.q.out Mon Nov 18 19:29:24 2013
@@ -49,17 +49,23 @@ STAGE PLANS:
null-subquery1:subq1-subquery1:x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 20)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -69,6 +75,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -77,6 +85,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -139,6 +149,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -146,6 +158,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -591,6 +605,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -599,6 +615,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: _col1
@@ -607,6 +625,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -615,6 +635,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: _col1
@@ -622,6 +644,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -631,6 +655,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -775,17 +801,23 @@ STAGE PLANS:
null-subquery2:subq1-subquery2:x1
TableScan
alias: x1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key > 100)
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -795,6 +827,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -803,6 +837,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -865,6 +901,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -872,6 +910,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
Modified: hive/trunk/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join9.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join9.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
@@ -42,6 +46,8 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -51,6 +57,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: value
Modified: hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out Mon Nov 18 19:29:24 2013
@@ -29,6 +29,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -38,6 +40,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -47,12 +51,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 50)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -61,6 +69,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -70,12 +80,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -84,6 +98,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -195,7 +211,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select * from a left outer join a b on (a.key=b.key AND a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60)
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -238,12 +253,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 50)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -252,6 +271,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -261,6 +282,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -270,6 +293,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -279,12 +304,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -293,6 +322,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -404,7 +435,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select * from a right outer join a b on (a.key=b.key AND a.value=50 AND b.value=50) left outer join a c on (b.key=c.key AND b.value=60 AND c.value=60)
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -447,12 +477,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 50)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -461,6 +495,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -470,6 +506,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -479,6 +517,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -488,12 +528,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -502,6 +546,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -613,7 +659,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select * from a right outer join a b on (a.key=b.key AND a.value=50 AND b.value=50 AND b.value>10) left outer join a c on (b.key=c.key AND b.value=60 AND b.value>20 AND c.value=60)
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -656,6 +701,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -665,6 +712,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -674,6 +723,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -683,6 +734,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -692,12 +745,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -706,6 +763,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -715,12 +774,16 @@ STAGE PLANS:
d
TableScan
alias: d
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 40)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -729,6 +792,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 3
value expressions:
expr: key
@@ -882,6 +947,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -891,6 +958,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -900,12 +969,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 50)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -914,6 +987,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -923,12 +998,16 @@ STAGE PLANS:
c
TableScan
alias: c
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 60)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -937,6 +1016,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 2
value expressions:
expr: key
@@ -946,12 +1027,16 @@ STAGE PLANS:
d
TableScan
alias: d
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (value = 40)
type: boolean
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -960,6 +1045,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: int
+ Statistics:
+ numRows: 3 dataSize: 18 basicStatsState: COMPLETE colStatsState: NONE
tag: 3
value expressions:
expr: key
Modified: hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out Mon Nov 18 19:29:24 2013
@@ -45,6 +45,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -60,6 +62,8 @@ STAGE PLANS:
y
TableScan
alias: y
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -79,6 +83,8 @@ STAGE PLANS:
z
TableScan
alias: z
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Map Join Operator
condition map:
@@ -590,6 +596,8 @@ STAGE PLANS:
x
TableScan
alias: x
+ Statistics:
+ numRows: 25 dataSize: 191 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -605,6 +613,8 @@ STAGE PLANS:
y
TableScan
alias: y
+ Statistics:
+ numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
HashTable Sink Operator
condition expressions:
@@ -624,6 +634,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/list_bucket_dml_10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out Mon Nov 18 19:29:24 2013
@@ -69,6 +69,8 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -77,12 +79,16 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Static Partition Specification: ds=2008-04-08/hr=11/
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/load_dyn_part8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part8.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/load_dyn_part8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/load_dyn_part8.q.out Mon Nov 18 19:29:24 2013
@@ -54,12 +54,16 @@ STAGE PLANS:
srcpart
TableScan
alias: srcpart
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (ds <= '2008-04-08')
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -71,11 +75,15 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### 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
@@ -101,6 +109,8 @@ STAGE PLANS:
predicate:
expr: (ds > '2008-04-08')
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -110,12 +120,16 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 2
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Static Partition Specification: ds=2008-12-31/
+ Statistics:
+ numRows: 0 dataSize: 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/louter_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out Mon Nov 18 19:29:24 2013
@@ -30,12 +30,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -44,6 +48,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -53,12 +59,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -67,6 +77,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -328,12 +340,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -342,6 +358,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -353,12 +371,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -367,6 +389,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
@@ -723,12 +747,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -737,6 +765,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
@@ -746,12 +776,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -760,6 +794,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -1113,12 +1149,16 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -1127,6 +1167,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -1136,12 +1178,16 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((key > 10) and (key < 20))
type: boolean
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -1150,6 +1196,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/macro.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/macro.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/macro.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/macro.q.out Mon Nov 18 19:29:24 2013
@@ -54,13 +54,19 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: SIGMOID(2)
type: double
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
ListSink
@@ -124,13 +130,19 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: (FIXED_NUMBER() + 1)
type: int
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
ListSink
@@ -215,13 +227,19 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: SIMPLE_ADD(1, 9)
type: int
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
ListSink
Modified: hive/trunk/ql/src/test/results/clientpositive/merge3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge3.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/merge3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/merge3.q.out Mon Nov 18 19:29:24 2013
@@ -74,6 +74,8 @@ STAGE PLANS:
merge_src
TableScan
alias: merge_src
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -82,11 +84,15 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2403,6 +2409,8 @@ STAGE PLANS:
merge_src_part
TableScan
alias: merge_src_part
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -2413,11 +2421,15 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4838,6 +4850,8 @@ STAGE PLANS:
s:merge_src_part
TableScan
alias: merge_src_part
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -4848,11 +4862,15 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
sort order:
Map-reduce partition columns:
expr: _col2
type: string
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -4952,6 +4970,8 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -4961,11 +4981,15 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 2000 dataSize: 21248 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out Mon Nov 18 19:29:24 2013
@@ -21,20 +21,28 @@ STAGE PLANS:
test1
TableScan
alias: test1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
GatherStats: false
Select Operator
expressions:
expr: ds
type: string
outputColumnNames: ds
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Group By Operator
aggregations:
expr: max(ds)
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ 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: _col0
@@ -47,16 +55,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: string
outputColumnNames: _col0
+ 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
@@ -112,20 +126,28 @@ STAGE PLANS:
test1
TableScan
alias: test1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: ds
type: string
outputColumnNames: ds
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Group By Operator
aggregations:
expr: max(ds)
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col0
@@ -179,16 +201,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
type: string
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -239,12 +267,16 @@ STAGE PLANS:
test1
TableScan
alias: test1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: ds
type: string
outputColumnNames: ds
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(DISTINCT ds)
@@ -254,11 +286,15 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Reduce Output Operator
key expressions:
expr: _col0
type: string
sort order: +
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col1
@@ -312,16 +348,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -372,20 +414,28 @@ STAGE PLANS:
test1
TableScan
alias: test1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: ds
type: string
outputColumnNames: ds
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(ds)
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col0
@@ -439,16 +489,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
type: bigint
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -510,20 +566,28 @@ STAGE PLANS:
b:test1
TableScan
alias: test1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: ds
type: string
outputColumnNames: ds
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Group By Operator
aggregations:
expr: max(ds)
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col0
@@ -615,11 +679,15 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
type: string
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -652,10 +720,14 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: 1
a2
TableScan
alias: a2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -665,6 +737,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: ds
type: string
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: 0
Path -> Alias:
#### A masked pattern was here ####
@@ -932,6 +1006,8 @@ STAGE PLANS:
test2
TableScan
alias: test2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
@@ -940,6 +1016,8 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: ds, hr
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(DISTINCT hr)
@@ -951,6 +1029,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Reduce Output Operator
key expressions:
expr: _col0
@@ -961,6 +1041,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col2
@@ -1096,6 +1178,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
@@ -1103,11 +1187,15 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1162,6 +1250,8 @@ STAGE PLANS:
test2
TableScan
alias: test2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
@@ -1170,6 +1260,8 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: ds, hr
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(hr)
@@ -1179,6 +1271,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1187,6 +1281,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col1
@@ -1320,6 +1416,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
@@ -1327,11 +1425,15 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1385,20 +1487,28 @@ STAGE PLANS:
test1
TableScan
alias: test1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: ds
type: string
outputColumnNames: ds
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Group By Operator
aggregations:
expr: max(ds)
bucketGroup: false
mode: hash
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col0
@@ -1490,16 +1600,22 @@ STAGE PLANS:
bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
type: string
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1603,6 +1719,8 @@ STAGE PLANS:
test2
TableScan
alias: test2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
@@ -1611,6 +1729,8 @@ STAGE PLANS:
expr: hr
type: string
outputColumnNames: ds, hr
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(DISTINCT hr)
@@ -1622,6 +1742,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1632,6 +1754,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col2
@@ -1845,6 +1969,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
@@ -1852,11 +1978,15 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out Mon Nov 18 19:29:24 2013
@@ -30,6 +30,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -39,6 +41,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
@@ -48,6 +52,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -57,6 +63,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key
@@ -415,6 +423,8 @@ STAGE PLANS:
a
TableScan
alias: a
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -424,6 +434,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
@@ -433,6 +445,8 @@ STAGE PLANS:
b
TableScan
alias: b
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Reduce Output Operator
key expressions:
@@ -442,6 +456,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
tag: 1
value expressions:
expr: key