You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/26 09:19:34 UTC
svn commit: r1545564 [16/22] - in /hive/branches/tez: ./ ant/ beeline/ bin/
cli/ common/ common/src/java/org/apache/hadoop/hive/common/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hadoop/hive/conf/ common/src/test/org...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_reflect2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_reflect2.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_reflect2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_reflect2.q.out Tue Nov 26 08:19:25 2013
@@ -92,6 +92,8 @@ STAGE PLANS:
a:src
TableScan
alias: src
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
GatherStats: false
Select Operator
expressions:
@@ -102,6 +104,8 @@ STAGE PLANS:
expr: CAST( '2013-02-15 19:41:20' AS TIMESTAMP)
type: timestamp
outputColumnNames: _col0, _col1, _col2
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -167,12 +171,18 @@ STAGE PLANS:
expr: reflect2(_col2,'getTime')
type: bigint
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
Limit
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out Tue Nov 26 08:19:25 2013
@@ -155,3 +155,42 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
2 9 14 NULL 24 NULL
+PREHOOK: query: -- Allow compatible types to be used in return value
+SELECT CASE
+ WHEN 1=1 THEN 123.0BD
+ ELSE 0.0BD
+ END,
+ CASE
+ WHEN 1=1 THEN 123
+ WHEN 1=2 THEN 1.0
+ ELSE 222.02BD
+ END,
+ CASE
+ WHEN 1=1 THEN 'abcd'
+ WHEN 1=2 THEN cast('efgh' as varchar(10))
+ ELSE cast('ijkl' as char(4))
+ END
+FROM src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- Allow compatible types to be used in return value
+SELECT CASE
+ WHEN 1=1 THEN 123.0BD
+ ELSE 0.0BD
+ END,
+ CASE
+ WHEN 1=1 THEN 123
+ WHEN 1=2 THEN 1.0
+ ELSE 222.02BD
+ END,
+ CASE
+ WHEN 1=1 THEN 'abcd'
+ WHEN 1=2 THEN cast('efgh' as varchar(10))
+ ELSE cast('ijkl' as char(4))
+ END
+FROM src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+123 123.0 abcd
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udtf_explode.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udtf_explode.q.out Tue Nov 26 08:19:25 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: 2906 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: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 2906 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: 2906 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: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 2906 basicStatsState: PARTIAL colStatsState: COMPLETE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out Tue Nov 26 08:19:25 2013
@@ -333,6 +333,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -344,12 +346,16 @@ STAGE PLANS:
expr: _col3
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Static Partition Specification: ds=2/
+ Statistics:
+ numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -373,12 +379,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: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: k1
@@ -390,7 +400,11 @@ STAGE PLANS:
expr: k4
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -402,12 +416,16 @@ STAGE PLANS:
expr: _col3
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 1
#### A masked pattern was here ####
NumFilesPerFileSink: 1
Static Partition Specification: ds=2/
+ Statistics:
+ numRows: 31500 dataSize: 1727000 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -531,12 +549,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: 250 dataSize: 5500 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: k1
@@ -545,6 +567,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: k1
type: string
+ Statistics:
+ numRows: 250 dataSize: 5500 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: k1
@@ -556,12 +580,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: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: k1
@@ -571,6 +599,8 @@ STAGE PLANS:
expr: k4
type: string
outputColumnNames: _col1, _col3, _col4
+ Statistics:
+ numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col1
@@ -579,6 +609,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col1
type: string
+ Statistics:
+ numRows: 250 dataSize: 8250 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: _col3
@@ -688,6 +720,8 @@ STAGE PLANS:
1
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col10, _col11
+ Statistics:
+ numRows: 31250 dataSize: 1718750 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -699,6 +733,8 @@ STAGE PLANS:
expr: _col11
type: string
outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics:
+ numRows: 31250 dataSize: 1718750 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out Tue Nov 26 08:19:25 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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
type: string
outputColumnNames: key
+ Statistics:
+ numRows: 154 dataSize: 616 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: 154 dataSize: 616 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: 154 dataSize: 616 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: 77 dataSize: 308 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -162,6 +174,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 77 dataSize: 308 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -187,6 +201,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -194,6 +210,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 539 dataSize: 2156 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: 539 dataSize: 2156 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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -223,7 +247,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -231,6 +259,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 539 dataSize: 2156 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: 539 dataSize: 2156 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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -260,7 +296,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -268,6 +308,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 539 dataSize: 2156 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: 539 dataSize: 2156 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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -297,7 +345,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -305,6 +357,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 539 dataSize: 2156 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: 539 dataSize: 2156 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: 539 dataSize: 2156 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 539 dataSize: 2156 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: 154 dataSize: 616 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: 154 dataSize: 616 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: 154 dataSize: 616 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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
value expressions:
expr: count
@@ -731,6 +803,8 @@ STAGE PLANS:
1 {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col5
+ Statistics:
+ numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -738,6 +812,8 @@ STAGE PLANS:
expr: _col5
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -763,6 +839,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -770,6 +848,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -777,6 +857,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -786,12 +868,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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -799,7 +885,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -807,6 +897,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -814,6 +906,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -823,12 +917,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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -836,7 +934,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -844,6 +946,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -851,6 +955,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -971,11 +1077,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 12166 dataSize: 96096 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1079,12 +1189,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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -1093,6 +1207,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
tag: 0
value expressions:
expr: key
@@ -1100,12 +1216,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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: key
@@ -1114,6 +1234,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
+ Statistics:
+ numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
tag: 1
Path -> Alias:
#### A masked pattern was here ####
@@ -1215,11 +1337,15 @@ STAGE PLANS:
1
handleSkewJoin: false
outputColumnNames: _col0
+ Statistics:
+ numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
type: string
outputColumnNames: _col0
+ Statistics:
+ numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
Group By Operator
aggregations:
expr: count(1)
@@ -1229,6 +1355,8 @@ STAGE PLANS:
type: string
mode: hash
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1261,6 +1389,8 @@ STAGE PLANS:
Map-reduce partition columns:
expr: _col0
type: string
+ Statistics:
+ numRows: 11858 dataSize: 94864 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col1
@@ -1301,6 +1431,8 @@ STAGE PLANS:
type: string
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 5929 dataSize: 47432 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1308,6 +1440,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 5929 dataSize: 47432 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1333,6 +1467,8 @@ STAGE PLANS:
TableScan
GatherStats: false
Union
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1340,6 +1476,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1347,6 +1485,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1356,12 +1496,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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1369,7 +1513,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1377,6 +1525,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1384,6 +1534,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1393,12 +1545,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: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: key
@@ -1406,7 +1562,11 @@ STAGE PLANS:
expr: count
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 154 dataSize: 616 basicStatsState: COMPLETE colStatsState: NONE
Union
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
Select Operator
expressions:
expr: _col0
@@ -1414,6 +1574,8 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
Reduce Output Operator
key expressions:
expr: _col0
@@ -1421,6 +1583,8 @@ STAGE PLANS:
expr: _col1
type: bigint
sort order: ++
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
tag: -1
value expressions:
expr: _col0
@@ -1541,11 +1705,15 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 6237 dataSize: 48664 basicStatsState: COMPLETE colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_ppr.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_ppr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_ppr.q.out Tue Nov 26 08:19:25 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: 5812 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: 5812 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 11624 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: 11624 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: 11624 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: 5812 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: 5812 basicStatsState: PARTIAL colStatsState: NONE
Union
+ Statistics:
+ numRows: 0 dataSize: 11624 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: 11624 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: 11624 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: 11624 basicStatsState: PARTIAL colStatsState: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
+ Statistics:
+ numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vectorization_15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vectorization_15.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vectorization_15.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vectorization_15.q.out Tue Nov 26 08:19:25 2013
@@ -77,32 +77,32 @@ NULL true 10419.0 10 NULL -721614386 NUL
NULL true 14519.0 100xJdkyc NULL 729277608 NULL NULL -7.2927763428E8 14519.0 1155030.007 NULL NULL NULL -23.0 NULL 0.0 NULL NULL 7.2927763428E8 0.0
-62.0 NULL 15601.0 NULL -62 NULL 1969-12-31 16:00:09.889 0.0 NULL 15601.0 1241106.353 33.0 0.0 0.0 -23.0 62 NULL NULL -23 NULL NULL
-51.0 NULL -200.0 NULL -51 NULL 1969-12-31 15:59:55.423 0.0 NULL -200.0 -15910.599999999999 33.0 0.0 0.0 -23.0 51 NULL NULL -23 NULL NULL
--51.0 false NULL 10 -51 1058319346 1969-12-31 16:00:08.451 0.0 -1.05831937228E9 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 1.05831942E9 -23 1.05831937228E9 0.0
--51.0 false NULL 10TYIE5S35U6dj3N -51 -469581869 1969-12-31 16:00:08.451 0.0 4.6958184272E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -4.69581792E8 -23 -4.6958184272E8 0.0
--51.0 false NULL 1Lh6Uoq3WhNtOqQHu7WN7U -51 -352637533 1969-12-31 16:00:08.451 0.0 3.5263750672E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.52637472E8 -23 -3.5263750672E8 0.0
--51.0 true NULL 04Y1mA17 -51 -114647521 1969-12-31 16:00:08.451 0.0 1.1464749472E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -1.14647472E8 -23 -1.1464749472E8 0.0
+-51.0 false NULL 10 -51 1058319346 1969-12-31 16:00:08.451 0.0 -1.05831937228E9 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 1.058319397E9 -23 1.05831937228E9 0.0
+-51.0 false NULL 10TYIE5S35U6dj3N -51 -469581869 1969-12-31 16:00:08.451 0.0 4.6958184272E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -4.69581818E8 -23 -4.6958184272E8 0.0
+-51.0 false NULL 1Lh6Uoq3WhNtOqQHu7WN7U -51 -352637533 1969-12-31 16:00:08.451 0.0 3.5263750672E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.52637482E8 -23 -3.5263750672E8 0.0
+-51.0 true NULL 04Y1mA17 -51 -114647521 1969-12-31 16:00:08.451 0.0 1.1464749472E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -1.1464747E8 -23 -1.1464749472E8 0.0
-51.0 true NULL 10Wu570aLPO0p02P17FeH -51 405338893 1969-12-31 16:00:08.451 0.0 -4.0533891928E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 4.05338944E8 -23 4.0533891928E8 0.0
-51.0 true NULL 3cQp060 -51 -226923315 1969-12-31 16:00:08.451 0.0 2.2692328872E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -2.26923264E8 -23 -2.2692328872E8 0.0
--51.0 true NULL 8EPG0Xi307qd -51 -328662044 1969-12-31 16:00:08.451 0.0 3.2866201772E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.28661984E8 -23 -3.2866201772E8 0.0
--51.0 true NULL 8iHtdkJ6d -51 1006818344 1969-12-31 16:00:08.451 0.0 -1.00681837028E9 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 1.00681843E9 -23 1.00681837028E9 0.0
--51.0 true NULL QiOcvR0kt6r7f0R7fiPxQTCU -51 266531954 1969-12-31 16:00:08.451 0.0 -2.6653198028E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 2.66532E8 -23 2.6653198028E8 0.0
--51.0 true NULL Ybpj38RTTYl7CnJXPNx1g4C -51 -370919370 1969-12-31 16:00:08.451 0.0 3.7091934372E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.70919296E8 -23 -3.7091934372E8 0.0
+-51.0 true NULL 8EPG0Xi307qd -51 -328662044 1969-12-31 16:00:08.451 0.0 3.2866201772E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.28661993E8 -23 -3.2866201772E8 0.0
+-51.0 true NULL 8iHtdkJ6d -51 1006818344 1969-12-31 16:00:08.451 0.0 -1.00681837028E9 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 1.006818395E9 -23 1.00681837028E9 0.0
+-51.0 true NULL QiOcvR0kt6r7f0R7fiPxQTCU -51 266531954 1969-12-31 16:00:08.451 0.0 -2.6653198028E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 2.66532005E8 -23 2.6653198028E8 0.0
+-51.0 true NULL Ybpj38RTTYl7CnJXPNx1g4C -51 -370919370 1969-12-31 16:00:08.451 0.0 3.7091934372E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.70919319E8 -23 -3.7091934372E8 0.0
-48.0 NULL -7196.0 NULL -48 NULL 1969-12-31 16:00:06.337 0.0 NULL -7196.0 -572463.388 33.0 0.0 0.0 -23.0 48 NULL NULL -23 NULL NULL
-6.0 NULL -200.0 NULL -6 NULL 1969-12-31 15:59:56.094 0.0 NULL -200.0 -15910.599999999999 3.0 0.0 0.0 -23.0 6 NULL NULL -5 NULL NULL
5.0 NULL 15601.0 NULL 5 NULL 1969-12-31 16:00:00.959 0.0 NULL 15601.0 1241106.353 3.0 0.0 0.0 -23.0 -5 NULL NULL -3 NULL NULL
-8.0 false NULL 10V3pN5r5lI2qWl2lG103 8 -362835731 1969-12-31 16:00:15.892 0.0 3.6283570472E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -3.62835744E8 -7 -3.6283570472E8 0.0
-8.0 false NULL 10c4qt584m5y6uWT 8 -183000142 1969-12-31 16:00:15.892 0.0 1.8300011572E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -1.8300016E8 -7 -1.8300011572E8 0.0
+8.0 false NULL 10V3pN5r5lI2qWl2lG103 8 -362835731 1969-12-31 16:00:15.892 0.0 3.6283570472E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -3.62835739E8 -7 -3.6283570472E8 0.0
+8.0 false NULL 10c4qt584m5y6uWT 8 -183000142 1969-12-31 16:00:15.892 0.0 1.8300011572E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -1.8300015E8 -7 -1.8300011572E8 0.0
8.0 false NULL 8GloEukQ0c68JDmnYL53 8 -722873402 1969-12-31 16:00:15.892 0.0 7.2287337572E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -7.2287341E8 -7 -7.2287337572E8 0.0
8.0 false NULL kA0XH5C5 8 -503903864 1969-12-31 16:00:15.892 0.0 5.0390383772E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -5.03903872E8 -7 -5.0390383772E8 0.0
-8.0 true NULL 100VTM7PEW8GH1uE 8 88129338 1969-12-31 16:00:15.892 0.0 -8.812936428E7 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 8.8129328E7 -7 8.812936428E7 0.0
-8.0 true NULL 1062158y 8 -1005155523 1969-12-31 16:00:15.892 0.0 1.00515549672E9 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -1.00515552E9 -7 -1.00515549672E9 0.0
-8.0 true NULL 1063cEnGjSal 8 -624769630 1969-12-31 16:00:15.892 0.0 6.2476960372E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -6.247696E8 -7 -6.2476960372E8 0.0
-8.0 true NULL 4kMasVoB7lX1wc5i64bNk 8 683567667 1969-12-31 16:00:15.892 0.0 -6.8356769328E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 6.8356768E8 -7 6.8356769328E8 0.0
-8.0 true NULL XH6I7A417 8 436627202 1969-12-31 16:00:15.892 0.0 -4.3662722828E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 4.366272E8 -7 4.3662722828E8 0.0
-11.0 false NULL 10pO8p1LNx4Y 11 271296824 1969-12-31 16:00:02.351 0.0 -2.7129685028E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 2.71296832E8 -1 2.7129685028E8 0.0
-11.0 false NULL 1H6wGP 11 -560827082 1969-12-31 16:00:02.351 0.0 5.6082705572E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 -5.6082707E8 -1 -5.6082705572E8 0.0
-11.0 false NULL 2a7V63IL7jK3o 11 -325931647 1969-12-31 16:00:02.351 0.0 3.2593162072E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 -3.25931648E8 -1 -3.2593162072E8 0.0
-11.0 true NULL 10 11 92365813 1969-12-31 16:00:02.351 0.0 -9.236583928E7 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 9.2365808E7 -1 9.236583928E7 0.0
+8.0 true NULL 100VTM7PEW8GH1uE 8 88129338 1969-12-31 16:00:15.892 0.0 -8.812936428E7 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 8.812933E7 -7 8.812936428E7 0.0
+8.0 true NULL 1062158y 8 -1005155523 1969-12-31 16:00:15.892 0.0 1.00515549672E9 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -1.005155531E9 -7 -1.00515549672E9 0.0
+8.0 true NULL 1063cEnGjSal 8 -624769630 1969-12-31 16:00:15.892 0.0 6.2476960372E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -6.24769638E8 -7 -6.2476960372E8 0.0
+8.0 true NULL 4kMasVoB7lX1wc5i64bNk 8 683567667 1969-12-31 16:00:15.892 0.0 -6.8356769328E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 6.83567659E8 -7 6.8356769328E8 0.0
+8.0 true NULL XH6I7A417 8 436627202 1969-12-31 16:00:15.892 0.0 -4.3662722828E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 4.36627194E8 -7 4.3662722828E8 0.0
+11.0 false NULL 10pO8p1LNx4Y 11 271296824 1969-12-31 16:00:02.351 0.0 -2.7129685028E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 2.71296813E8 -1 2.7129685028E8 0.0
+11.0 false NULL 1H6wGP 11 -560827082 1969-12-31 16:00:02.351 0.0 5.6082705572E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 -5.60827093E8 -1 -5.6082705572E8 0.0
+11.0 false NULL 2a7V63IL7jK3o 11 -325931647 1969-12-31 16:00:02.351 0.0 3.2593162072E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 -3.25931658E8 -1 -3.2593162072E8 0.0
+11.0 true NULL 10 11 92365813 1969-12-31 16:00:02.351 0.0 -9.236583928E7 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 9.2365802E7 -1 9.236583928E7 0.0
21.0 NULL 15601.0 NULL 21 NULL 1969-12-31 16:00:14.256 0.0 NULL 15601.0 1241106.353 12.0 0.0 0.0 -23.0 -21 NULL NULL -2 NULL NULL
32.0 NULL -200.0 NULL 32 NULL 1969-12-31 16:00:02.445 0.0 NULL -200.0 -15910.599999999999 1.0 0.0 0.0 -23.0 -32 NULL NULL -23 NULL NULL
36.0 NULL -200.0 NULL 36 NULL 1969-12-31 16:00:00.554 0.0 NULL -200.0 -15910.599999999999 33.0 0.0 0.0 -23.0 -36 NULL NULL -23 NULL NULL
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vectorization_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vectorization_5.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vectorization_5.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vectorization_5.q.out Tue Nov 26 08:19:25 2013
@@ -40,4 +40,4 @@ WHERE (((cboolean2 IS NOT NULL)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-16343 -1225725 1070 -1145.53738317757 114090483 -16307 16307 197.0 -26853917571 11 -11 0
+16343 -1225725 1070 -1145.53738317757009345794 114090483 -16307 16307 NULL -26853917571 11 -11 0