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 [16/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/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out Mon Nov 18 19:29:24 2013
@@ -26,20 +26,30 @@ STAGE PLANS:
src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: array(1,2,3)
type: array<int>
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
UDTF Operator
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
function name: explode
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -127,17 +137,27 @@ STAGE PLANS:
a:src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: array(1,2,3)
type: array<int>
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
UDTF Operator
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
function name: explode
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
tag: -1
value expressions:
expr: col
@@ -192,12 +212,18 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
type: int
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(1)
@@ -207,6 +233,8 @@ STAGE PLANS:
type: int
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -239,6 +267,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: int
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col1
@@ -279,6 +309,8 @@ STAGE PLANS:
type: int
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
@@ -286,11 +318,15 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -403,17 +439,27 @@ STAGE PLANS:
a:src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
GatherStats: false
Select Operator
expressions:
expr: map(1:'one',2:'two',3:'three')
type: map<int,string>
outputColumnNames: _col0
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
UDTF Operator
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
function name: explode
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Reduce Output Operator
sort order:
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
tag: -1
value expressions:
expr: key
@@ -470,7 +516,11 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
@@ -478,6 +528,8 @@ STAGE PLANS:
expr: _col1
type: string
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Group By Operator
aggregations:
expr: count(1)
@@ -489,6 +541,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -525,6 +579,8 @@ STAGE PLANS:
type: int
expr: _col1
type: string
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
tag: -1
value expressions:
expr: _col2
@@ -567,6 +623,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
Select Operator
expressions:
expr: _col0
@@ -576,11 +634,15 @@ STAGE PLANS:
expr: _col2
type: bigint
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/union22.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union22.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union22.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union22.q.out Mon Nov 18 19:29:24 2013
@@ -373,12 +373,16 @@ STAGE PLANS:
null-subquery1:subq-subquery1:dst_union22_delta
TableScan
alias: dst_union22_delta
+ Statistics:
+ numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (k0 <= 50)
type: boolean
+ Statistics:
+ numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: k1
@@ -390,6 +394,8 @@ STAGE PLANS:
expr: k4
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
Union
Select Operator
expressions:
@@ -531,12 +537,16 @@ STAGE PLANS:
null-subquery2:subq-subquery2:a
TableScan
alias: a
+ Statistics:
+ numRows: 500 dataSize: 11124 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (k1 > 20)
type: boolean
+ Statistics:
+ numRows: 500 dataSize: 11124 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: k1
@@ -545,6 +555,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: k1
type: string
+ Statistics:
+ numRows: 500 dataSize: 11124 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: k1
@@ -556,12 +568,16 @@ STAGE PLANS:
null-subquery2:subq-subquery2:b:dst_union22_delta
TableScan
alias: dst_union22_delta
+ Statistics:
+ numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: ((k0 > 50) and (k1 > 20))
type: boolean
+ Statistics:
+ numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: k1
@@ -571,6 +587,8 @@ STAGE PLANS:
expr: k4
type: string
outputColumnNames: _col1, _col3, _col4
+ Statistics:
+ numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col1
@@ -579,6 +597,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col1
type: string
+ Statistics:
+ numRows: 500 dataSize: 16936 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: _col3
Modified: hive/trunk/ql/src/test/results/clientpositive/union24.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union24.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union24.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union24.q.out Mon Nov 18 19:29:24 2013
@@ -65,17 +65,23 @@ STAGE PLANS:
null-subquery2:s-subquery2:src5
TableScan
alias: src5
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -85,6 +91,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -93,6 +101,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -155,6 +165,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -162,6 +174,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -187,6 +201,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -194,6 +210,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -201,6 +219,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -210,12 +230,16 @@ STAGE PLANS:
null-subquery1-subquery1-subquery1:s-subquery1-subquery1-subquery1:src2
TableScan
alias: src2
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -223,7 +247,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -231,6 +259,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -238,6 +268,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -247,12 +279,16 @@ STAGE PLANS:
null-subquery1-subquery1-subquery2:s-subquery1-subquery1-subquery2:src3
TableScan
alias: src3
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -260,7 +296,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -268,6 +308,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -275,6 +317,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -284,12 +328,16 @@ STAGE PLANS:
null-subquery1-subquery2:s-subquery1-subquery2:src4
TableScan
alias: src4
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -297,7 +345,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -305,6 +357,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -312,6 +366,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -475,11 +531,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 1236 dataSize: 5928 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -592,12 +652,16 @@ STAGE PLANS:
null-subquery2:s-subquery2:a
TableScan
alias: a
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -606,6 +670,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -613,12 +679,16 @@ STAGE PLANS:
null-subquery2:s-subquery2:b
TableScan
alias: b
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -627,6 +697,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: count
@@ -786,12 +858,16 @@ STAGE PLANS:
null-subquery1-subquery1:s-subquery1-subquery1:src2
TableScan
alias: src2
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -799,6 +875,8 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Union
Select Operator
expressions:
@@ -823,12 +901,16 @@ STAGE PLANS:
null-subquery1-subquery2:s-subquery1-subquery2:src3
TableScan
alias: src3
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -836,6 +918,8 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Union
Select Operator
expressions:
@@ -1079,12 +1163,16 @@ STAGE PLANS:
null-subquery2:s-subquery2:a
TableScan
alias: a
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -1093,6 +1181,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -1100,12 +1190,16 @@ STAGE PLANS:
null-subquery2:s-subquery2:b
TableScan
alias: b
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -1114,6 +1208,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
Path -> Alias:
#### A masked pattern was here ####
@@ -1356,12 +1452,16 @@ STAGE PLANS:
null-subquery1-subquery1:s-subquery1-subquery1:src2
TableScan
alias: src2
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1369,6 +1469,8 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Union
Select Operator
expressions:
@@ -1393,12 +1495,16 @@ STAGE PLANS:
null-subquery1-subquery2:s-subquery1-subquery2:src3
TableScan
alias: src3
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate:
expr: (key < 10)
type: boolean
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1406,6 +1512,8 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 309 dataSize: 1482 basicStatsState: COMPLETE colStatsState: NONE
Union
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out Mon Nov 18 19:29:24 2013
@@ -30,12 +30,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
@@ -47,7 +51,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
@@ -59,6 +67,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
@@ -70,6 +80,8 @@ STAGE PLANS:
expr: _col3
type: string
sort order: ++++
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -83,12 +95,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
@@ -100,7 +116,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
@@ -112,6 +132,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
@@ -123,6 +145,8 @@ STAGE PLANS:
expr: _col3
type: string
sort order: ++++
+ Statistics:
+ numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -226,11 +250,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