You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/10/30 19:03:29 UTC
svn commit: r1635566 [5/5] -
/hive/branches/spark/ql/src/test/results/clientpositive/spark/
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_11.q.out?rev=1635566&r1=1635565&r2=1635566&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_11.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_11.q.out Thu Oct 30 18:03:26 2014
@@ -101,18 +101,15 @@ STAGE PLANS:
expressions: key (type: string), 2 (type: int)
outputColumnNames: _col0, _col1
Select Operator
- expressions: _col0 (type: string), _col1 (type: int)
+ expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint)
outputColumnNames: _col0, _col1
- Select Operator
- expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint)
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.outputtbl1
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.outputtbl1
Map 3
Map Operator Tree:
TableScan
@@ -138,18 +135,15 @@ STAGE PLANS:
expressions: key (type: string), 3 (type: int)
outputColumnNames: _col0, _col1
Select Operator
- expressions: _col0 (type: string), _col1 (type: int)
+ expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint)
outputColumnNames: _col0, _col1
- Select Operator
- expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint)
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.outputtbl1
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.outputtbl1
Union 2
Vertex: Union 2
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_19.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_19.q.out?rev=1635566&r1=1635565&r2=1635566&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_19.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_19.q.out Thu Oct 30 18:03:26 2014
@@ -342,10 +342,10 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1
Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
+ expressions: _col1 (type: bigint)
+ outputColumnNames: _col1
Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
+ expressions: '7' (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
File Output Operator
compressed: false
@@ -362,10 +362,10 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1
Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
+ expressions: _col1 (type: bigint)
+ outputColumnNames: _col1
Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
+ expressions: '7' (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
File Output Operator
compressed: false
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_25.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_25.q.out?rev=1635566&r1=1635565&r2=1635566&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_25.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/union_remove_25.q.out Thu Oct 30 18:03:26 2014
@@ -311,8 +311,8 @@ STAGE PLANS:
alias: srcpart
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string), ds (type: string)
- outputColumnNames: _col0, _col1, _col2
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 500
@@ -320,15 +320,15 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 500 Data size: 5000 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: srcpart
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string), ds (type: string)
- outputColumnNames: _col0, _col1, _col2
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 500
@@ -336,16 +336,16 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 500 Data size: 5000 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
Select Operator
- expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string)
- outputColumnNames: _col0, _col1, _col2
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Limit
Number of rows: 500
Select Operator
- expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint), _col2 (type: string)
+ expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint), '2008-04-08' (type: string)
outputColumnNames: _col0, _col1, _col2
File Output Operator
compressed: false
@@ -357,12 +357,12 @@ STAGE PLANS:
Reducer 5
Reduce Operator Tree:
Select Operator
- expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string)
- outputColumnNames: _col0, _col1, _col2
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Limit
Number of rows: 500
Select Operator
- expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint), _col2 (type: string)
+ expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint), '2008-04-08' (type: string)
outputColumnNames: _col0, _col1, _col2
File Output Operator
compressed: false
@@ -499,8 +499,8 @@ STAGE PLANS:
alias: srcpart
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ expressions: key (type: string), value (type: string), hr (type: string)
+ outputColumnNames: _col0, _col1, _col3
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 1000
@@ -508,15 +508,15 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 1000 Data size: 10000 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col3 (type: string)
Map 4
Map Operator Tree:
TableScan
alias: srcpart
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ expressions: key (type: string), value (type: string), hr (type: string)
+ outputColumnNames: _col0, _col1, _col3
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 1000
@@ -524,16 +524,16 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 1000 Data size: 10000 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col3 (type: string)
Reducer 2
Reduce Operator Tree:
Select Operator
- expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col3 (type: string)
+ outputColumnNames: _col0, _col1, _col3
Limit
Number of rows: 1000
Select Operator
- expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint), _col2 (type: string), _col3 (type: string)
+ expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint), '2008-04-08' (type: string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
compressed: false
@@ -545,12 +545,12 @@ STAGE PLANS:
Reducer 5
Reduce Operator Tree:
Select Operator
- expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col3 (type: string)
+ outputColumnNames: _col0, _col1, _col3
Limit
Number of rows: 1000
Select Operator
- expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint), _col2 (type: string), _col3 (type: string)
+ expressions: _col0 (type: string), UDFToLong(_col1) (type: bigint), '2008-04-08' (type: string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
compressed: false
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_data_types.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_data_types.q.out?rev=1635566&r1=1635565&r2=1635566&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_data_types.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_data_types.q.out Thu Oct 30 18:03:26 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_decimal_aggregate.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_decimal_aggregate.q.out?rev=1635566&r1=1635565&r2=1635566&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_decimal_aggregate.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_decimal_aggregate.q.out Thu Oct 30 18:03:26 2014
@@ -113,14 +113,14 @@ POSTHOOK: query: SELECT cint,
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_vgby
#### A masked pattern was here ####
-253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 1024 11697.96923076923100 -11712.99230769231000 -416182.64030769233089
762 2 5831542.2692483780 1531.2194054054 5833073.4886537834 2 6984454.21109769200000 1833.9456923076925 6986288.15678999969250
-528534767 1024 5831542.2692483780 -9777.1594594595 11646372.8607481068 1024 6984454.21109769200000 -11710.13076923077100 13948892.79980307629003
+253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 1024 11697.96923076923100 -11712.99230769231000 -416182.64030769233089
+-3728 6 5831542.2692483780 -3367.6517567568 5817556.0411483778 6 6984454.21109769200000 -4033.445769230769 6967702.86724384584710
+-563 2 -515.6210729730 -3367.6517567568 -3883.2728297298 2 -617.56077692307690 -4033.445769230769 -4651.00654615384590
6981 3 5831542.269248378 -515.6210729730 5830511.0271024320 3 6984454.211097692 -617.56077692307690 6983219.08954384584620
626923679 1024 9723.4027027027 -9778.9513513514 10541.0525297287 1024 11645.74615384615400 -11712.27692307692300 12625.04759999997746
+528534767 1024 5831542.2692483780 -9777.1594594595 11646372.8607481068 1024 6984454.21109769200000 -11710.13076923077100 13948892.79980307629003
NULL 3072 9318.4351351351 -4298.1513513514 5018444.1081079808 3072 11160.71538461538500 -5147.90769230769300 6010604.30769230735360
--3728 6 5831542.2692483780 -3367.6517567568 5817556.0411483778 6 6984454.21109769200000 -4033.445769230769 6967702.86724384584710
--563 2 -515.6210729730 -3367.6517567568 -3883.2728297298 2 -617.56077692307690 -4033.445769230769 -4651.00654615384590
PREHOOK: query: -- Now add the others...
EXPLAIN SELECT cint,
COUNT(cdecimal1), MAX(cdecimal1), MIN(cdecimal1), SUM(cdecimal1), AVG(cdecimal1), STDDEV_POP(cdecimal1), STDDEV_SAMP(cdecimal1),
@@ -217,11 +217,11 @@ POSTHOOK: query: SELECT cint,
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_vgby
#### A masked pattern was here ####
-253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 -339.33992366976309 5708.9563478862 5711.745967572779 1024 11697.96923076923100 -11712.99230769231000 -416182.64030769233089 -406.428359675480791885 6837.632716002934 6840.973851172274
762 2 5831542.2692483780 1531.2194054054 5833073.4886537834 2916536.7443268917 2915005.5249214866 4122440.3477364695 2 6984454.21109769200000 1833.9456923076925 6986288.15678999969250 3493144.07839499984625 3491310.1327026924 4937458.140118758
-528534767 1024 5831542.2692483780 -9777.1594594595 11646372.8607481068 11373.41099682432305 257528.92988206653 257654.7686043977 1024 6984454.21109769200000 -11710.13076923077100 13948892.79980307629003 13621.965624807691689482 308443.1074570801 308593.82484083984
+253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 -339.33992366976309 5708.9563478862 5711.745967572779 1024 11697.96923076923100 -11712.99230769231000 -416182.64030769233089 -406.428359675480791885 6837.632716002934 6840.973851172274
+-3728 6 5831542.2692483780 -3367.6517567568 5817556.0411483778 969592.67352472963333 2174330.2092403853 2381859.406131774 6 6984454.21109769200000 -4033.445769230769 6967702.86724384584710 1161283.811207307641183333 2604201.2704476737 2852759.5602156054
+-563 2 -515.6210729730 -3367.6517567568 -3883.2728297298 -1941.6364148649 1426.0153418918999 2016.6902366556308 2 -617.56077692307690 -4033.445769230769 -4651.00654615384590 -2325.50327307692295 1707.9424961538462 2415.395441814127
6981 3 5831542.269248378 -515.6210729730 5830511.0271024320 1943503.67570081066667 2749258.455012492 3367140.1929065133 3 6984454.211097692 -617.56077692307690 6983219.08954384584620 2327739.696514615282066667 3292794.4113115156 4032833.0678006653
626923679 1024 9723.4027027027 -9778.9513513514 10541.0525297287 10.29399661106318 5742.09145323734 5744.897264034267 1024 11645.74615384615400 -11712.27692307692300 12625.04759999997746 12.329148046874977988 6877.318722794877 6880.679250101603
+528534767 1024 5831542.2692483780 -9777.1594594595 11646372.8607481068 11373.41099682432305 257528.92988206653 257654.7686043977 1024 6984454.21109769200000 -11710.13076923077100 13948892.79980307629003 13621.965624807691689482 308443.1074570801 308593.82484083984
NULL 3072 9318.4351351351 -4298.1513513514 5018444.1081079808 1633.60810810806667 5695.483082135364 5696.4103077145055 3072 11160.71538461538500 -5147.90769230769300 6010604.30769230735360 1956.576923076922966667 6821.495748565159 6822.606289190924
--3728 6 5831542.2692483780 -3367.6517567568 5817556.0411483778 969592.67352472963333 2174330.2092403853 2381859.406131774 6 6984454.21109769200000 -4033.445769230769 6967702.86724384584710 1161283.811207307641183333 2604201.2704476737 2852759.5602156054
--563 2 -515.6210729730 -3367.6517567568 -3883.2728297298 -1941.6364148649 1426.0153418918999 2016.6902366556308 2 -617.56077692307690 -4033.445769230769 -4651.00654615384590 -2325.50327307692295 1707.9424961538462 2415.395441814127
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out?rev=1635566&r1=1635565&r2=1635566&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out Thu Oct 30 18:03:26 2014
@@ -47,12 +47,12 @@ STAGE PLANS:
alias: r
Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (cint is not null and (cint = 6981)) (type: boolean)
- Statistics: Num rows: 3072 Data size: 541265 Basic stats: COMPLETE Column stats: NONE
+ predicate: (cint = 6981) (type: boolean)
+ Statistics: Num rows: 6144 Data size: 1082530 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: 6981 (type: int)
sort order: +
- Statistics: Num rows: 3072 Data size: 541265 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6144 Data size: 1082530 Basic stats: COMPLETE Column stats: NONE
value expressions: cdecimal2 (type: decimal(23,14))
Execution mode: vectorized
Map 3
@@ -61,12 +61,12 @@ STAGE PLANS:
alias: l
Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (cint is not null and (cint = 6981)) (type: boolean)
- Statistics: Num rows: 3072 Data size: 541265 Basic stats: COMPLETE Column stats: NONE
+ predicate: (cint = 6981) (type: boolean)
+ Statistics: Num rows: 6144 Data size: 1082530 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: 6981 (type: int)
sort order: +
- Statistics: Num rows: 3072 Data size: 541265 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6144 Data size: 1082530 Basic stats: COMPLETE Column stats: NONE
value expressions: cdecimal1 (type: decimal(20,10))
Execution mode: vectorized
Reducer 2
@@ -78,14 +78,14 @@ STAGE PLANS:
0 {VALUE._col1}
1 {VALUE._col2}
outputColumnNames: _col1, _col9
- Statistics: Num rows: 3379 Data size: 595391 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6758 Data size: 1190783 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: 6981 (type: int), 6981 (type: int), _col1 (type: decimal(20,10)), _col9 (type: decimal(23,14))
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 3379 Data size: 595391 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6758 Data size: 1190783 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 3379 Data size: 595391 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6758 Data size: 1190783 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorization_13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorization_13.q.out?rev=1635566&r1=1635565&r2=1635566&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorization_13.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorization_13.q.out Thu Oct 30 18:03:26 2014
@@ -193,46 +193,46 @@ LIMIT 40
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL -25 1969-12-31 16:00:13.374 -25.0 NULL 25 -25 0 -25.0 -0.0 25.0 -1988.8249999999998 0.0 25.0 0.0 -10.175 -25.0 1.0512000000000001 -25.0 0.0 -25
-NULL 62 1969-12-31 16:00:13.524 62.0 NULL -62 62 0 62.0 0.0 -62.0 4932.286 0.0 -62.0 0.0 -10.175 62.0 -0.4238709677419355 62.0 0.0 62
-NULL -38 1969-12-31 16:00:14.548 -38.0 NULL 38 -38 0 -38.0 -0.0 38.0 -3023.014 0.0 38.0 0.0 -10.175 -38.0 0.6915789473684211 -38.0 0.0 -38
-true 26 1969-12-31 16:00:14.341 26.0 1cGVWH7n1QU -26 26 0 26.0 0.0 -26.0 2068.3779999999997 0.0 -26.0 0.0 -10.175 26.0 -1.0107692307692309 26.0 0.0 26
-NULL -62 1969-12-31 16:00:12.388 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62
-NULL 28 1969-12-31 16:00:12.148 28.0 NULL -28 28 0 28.0 0.0 -28.0 2227.484 0.0 -28.0 0.0 -10.175 28.0 -0.9385714285714286 28.0 0.0 28
-true 49 1969-12-31 16:00:12.273 49.0 821UdmGbkEf4j -49 49 0 49.0 0.0 -49.0 3898.0969999999998 0.0 -49.0 0.0 -10.175 49.0 -0.5363265306122449 49.0 0.0 49
-true 13 1969-12-31 16:00:12.554 13.0 cvLH6Eat2yFsyy7p -13 13 0 13.0 0.0 -13.0 1034.1889999999999 0.0 -13.0 0.0 -10.175 13.0 -2.0215384615384617 13.0 0.0 13
-NULL 41 1969-12-31 16:00:14.017 41.0 NULL -41 41 0 41.0 0.0 -41.0 3261.673 0.0 -41.0 0.0 -10.175 41.0 -0.6409756097560976 41.0 0.0 41
-NULL -62 1969-12-31 16:00:14.247 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62
-NULL -49 1969-12-31 16:00:11.627 -49.0 NULL 49 -49 0 -49.0 -0.0 49.0 -3898.0969999999998 0.0 49.0 0.0 -10.175 -49.0 0.5363265306122449 -49.0 0.0 -49
-NULL 40 1969-12-31 16:00:14.977 40.0 NULL -40 40 0 40.0 0.0 -40.0 3182.12 0.0 -40.0 0.0 -10.175 40.0 -0.657 40.0 0.0 40
-NULL 13 1969-12-31 16:00:14.548 13.0 NULL -13 13 0 13.0 0.0 -13.0 1034.1889999999999 0.0 -13.0 0.0 -10.175 13.0 -2.0215384615384617 13.0 0.0 13
-NULL -2 1969-12-31 16:00:14.391 -2.0 NULL 2 -2 0 -2.0 -0.0 2.0 -159.106 0.0 2.0 0.0 -10.175 -2.0 13.14 -2.0 0.0 -2
-true -22 1969-12-31 16:00:14.318 -22.0 1cGVWH7n1QU 22 -22 0 -22.0 -0.0 22.0 -1750.166 0.0 22.0 0.0 -10.175 -22.0 1.1945454545454546 -22.0 0.0 -22
-true 34 1969-12-31 16:00:13.221 34.0 821UdmGbkEf4j -34 34 0 34.0 0.0 -34.0 2704.8019999999997 0.0 -34.0 0.0 -10.175 34.0 -0.7729411764705882 34.0 0.0 34
-NULL 18 1969-12-31 16:00:12.437 18.0 NULL -18 18 0 18.0 0.0 -18.0 1431.954 0.0 -18.0 0.0 -10.175 18.0 -1.46 18.0 0.0 18
-NULL 62 1969-12-31 16:00:14.982 62.0 NULL -62 62 0 62.0 0.0 -62.0 4932.286 0.0 -62.0 0.0 -10.175 62.0 -0.4238709677419355 62.0 0.0 62
-true 38 1969-12-31 16:00:14.239 38.0 821UdmGbkEf4j -38 38 0 38.0 0.0 -38.0 3023.014 0.0 -38.0 0.0 -10.175 38.0 -0.6915789473684211 38.0 0.0 38
-true 61 1969-12-31 16:00:15.673 61.0 1cGVWH7n1QU -61 61 0 61.0 0.0 -61.0 4852.733 0.0 -61.0 0.0 -10.175 61.0 -0.4308196721311476 61.0 0.0 61
-true 9 1969-12-31 16:00:11.544 9.0 1cGVWH7n1QU -9 9 0 9.0 0.0 -9.0 715.977 0.0 -9.0 0.0 -10.175 9.0 -2.92 9.0 0.0 9
-NULL -51 1969-12-31 16:00:12.494 -51.0 NULL 51 -51 0 -51.0 -0.0 51.0 -4057.203 0.0 51.0 0.0 -10.175 -51.0 0.5152941176470588 -51.0 0.0 -51
-true 25 1969-12-31 16:00:13.338 25.0 cvLH6Eat2yFsyy7p -25 25 0 25.0 0.0 -25.0 1988.8249999999998 0.0 -25.0 0.0 -10.175 25.0 -1.0512000000000001 25.0 0.0 25
-true -14 1969-12-31 16:00:15.625 -14.0 cvLH6Eat2yFsyy7p 14 -14 0 -14.0 -0.0 14.0 -1113.742 0.0 14.0 0.0 -10.175 -14.0 1.8771428571428572 -14.0 0.0 -14
-true -34 1969-12-31 16:00:15.254 -34.0 821UdmGbkEf4j 34 -34 0 -34.0 -0.0 34.0 -2704.8019999999997 0.0 34.0 0.0 -10.175 -34.0 0.7729411764705882 -34.0 0.0 -34
-true -1 1969-12-31 16:00:16.189 -1.0 cvLH6Eat2yFsyy7p 1 -1 0 -1.0 -0.0 1.0 -79.553 0.0 1.0 0.0 -10.175 -1.0 26.28 -1.0 0.0 -1
-NULL -30 1969-12-31 16:00:12.935 -30.0 NULL 30 -30 0 -30.0 -0.0 30.0 -2386.59 0.0 30.0 0.0 -10.175 -30.0 0.876 -30.0 0.0 -30
-true -53 1969-12-31 16:00:11.977 -53.0 821UdmGbkEf4j 53 -53 0 -53.0 -0.0 53.0 -4216.309 0.0 53.0 0.0 -10.175 -53.0 0.4958490566037736 -53.0 0.0 -53
-true 6 1969-12-31 16:00:11.357 6.0 cvLH6Eat2yFsyy7p -6 6 0 6.0 0.0 -6.0 477.318 0.0 -6.0 0.0 -10.175 6.0 -4.38 6.0 0.0 6
-NULL 30 1969-12-31 16:00:11.876 30.0 NULL -30 30 0 30.0 0.0 -30.0 2386.59 0.0 -30.0 0.0 -10.175 30.0 -0.876 30.0 0.0 30
-NULL 48 1969-12-31 16:00:15.512 48.0 NULL -48 48 0 48.0 0.0 -48.0 3818.544 0.0 -48.0 0.0 -10.175 48.0 -0.5475 48.0 0.0 48
-NULL -21 1969-12-31 16:00:13.32 -21.0 NULL 21 -21 0 -21.0 -0.0 21.0 -1670.6129999999998 0.0 21.0 0.0 -10.175 -21.0 1.2514285714285716 -21.0 0.0 -21
-NULL -42 1969-12-31 16:00:16.191 -42.0 NULL 42 -42 0 -42.0 -0.0 42.0 -3341.2259999999997 0.0 42.0 0.0 -10.175 -42.0 0.6257142857142858 -42.0 0.0 -42
-NULL 0 1969-12-31 16:00:11.089 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
-true -58 1969-12-31 16:00:13.209 -58.0 cvLH6Eat2yFsyy7p 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58
-NULL 60 1969-12-31 16:00:11.003 60.0 NULL -60 60 0 60.0 0.0 -60.0 4773.18 0.0 -60.0 0.0 -10.175 60.0 -0.438 60.0 0.0 60
-true 23 1969-12-31 16:00:11.343 23.0 cvLH6Eat2yFsyy7p -23 23 0 23.0 0.0 -23.0 1829.719 0.0 -23.0 0.0 -10.175 23.0 -1.142608695652174 23.0 0.0 23
-NULL -27 1969-12-31 16:00:14.065 -27.0 NULL 27 -27 0 -27.0 -0.0 27.0 -2147.931 0.0 27.0 0.0 -10.175 -27.0 0.9733333333333334 -27.0 0.0 -27
-true 57 1969-12-31 16:00:13.71 57.0 cvLH6Eat2yFsyy7p -57 57 0 57.0 0.0 -57.0 4534.521 0.0 -57.0 0.0 -10.175 57.0 -0.4610526315789474 57.0 0.0 57
-true -59 1969-12-31 16:00:12.227 -59.0 cvLH6Eat2yFsyy7p 59 -59 0 -59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59
+NULL -31 1969-12-31 16:00:16.059 -31.0 NULL 31 -31 0 -31.0 -0.0 31.0 -2466.143 0.0 31.0 0.0 -10.175 -31.0 0.847741935483871 -31.0 0.0 -31
+true 50 1969-12-31 16:00:16.338 50.0 821UdmGbkEf4j -50 50 0 50.0 0.0 -50.0 3977.6499999999996 0.0 -50.0 0.0 -10.175 50.0 -0.5256000000000001 50.0 0.0 50
+NULL 23 1969-12-31 16:00:11.785 23.0 NULL -23 23 0 23.0 0.0 -23.0 1829.719 0.0 -23.0 0.0 -10.175 23.0 -1.142608695652174 23.0 0.0 23
+true 14 1969-12-31 16:00:11.528 14.0 821UdmGbkEf4j -14 14 0 14.0 0.0 -14.0 1113.742 0.0 -14.0 0.0 -10.175 14.0 -1.8771428571428572 14.0 0.0 14
+true 50 1969-12-31 16:00:11.087 50.0 1cGVWH7n1QU -50 50 0 50.0 0.0 -50.0 3977.6499999999996 0.0 -50.0 0.0 -10.175 50.0 -0.5256000000000001 50.0 0.0 50
+NULL 13 1969-12-31 16:00:12.498 13.0 NULL -13 13 0 13.0 0.0 -13.0 1034.1889999999999 0.0 -13.0 0.0 -10.175 13.0 -2.0215384615384617 13.0 0.0 13
+true 36 1969-12-31 16:00:15.145 36.0 1cGVWH7n1QU -36 36 0 36.0 0.0 -36.0 2863.908 0.0 -36.0 0.0 -10.175 36.0 -0.73 36.0 0.0 36
+true 3 1969-12-31 16:00:14.349 3.0 cvLH6Eat2yFsyy7p -3 3 0 3.0 0.0 -3.0 238.659 0.0 -3.0 0.0 -10.175 3.0 -8.76 3.0 0.0 3
+NULL -4 1969-12-31 16:00:13.237 -4.0 NULL 4 -4 0 -4.0 -0.0 4.0 -318.212 0.0 4.0 0.0 -10.175 -4.0 6.57 -4.0 0.0 -4
+NULL -20 1969-12-31 16:00:13.131 -20.0 NULL 20 -20 0 -20.0 -0.0 20.0 -1591.06 0.0 20.0 0.0 -10.175 -20.0 1.314 -20.0 0.0 -20
+true 30 1969-12-31 16:00:15.705 30.0 821UdmGbkEf4j -30 30 0 30.0 0.0 -30.0 2386.59 0.0 -30.0 0.0 -10.175 30.0 -0.876 30.0 0.0 30
+true -57 1969-12-31 16:00:13.365 -57.0 1cGVWH7n1QU 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57
+true 40 1969-12-31 16:00:16.188 40.0 1cGVWH7n1QU -40 40 0 40.0 0.0 -40.0 3182.12 0.0 -40.0 0.0 -10.175 40.0 -0.657 40.0 0.0 40
+NULL -21 1969-12-31 16:00:12.544 -21.0 NULL 21 -21 0 -21.0 -0.0 21.0 -1670.6129999999998 0.0 21.0 0.0 -10.175 -21.0 1.2514285714285716 -21.0 0.0 -21
+NULL 7 1969-12-31 16:00:14.872 7.0 NULL -7 7 0 7.0 0.0 -7.0 556.871 0.0 -7.0 0.0 -10.175 7.0 -3.7542857142857144 7.0 0.0 7
+true -34 1969-12-31 16:00:14.043 -34.0 821UdmGbkEf4j 34 -34 0 -34.0 -0.0 34.0 -2704.8019999999997 0.0 34.0 0.0 -10.175 -34.0 0.7729411764705882 -34.0 0.0 -34
+NULL -58 1969-12-31 16:00:15.658 -58.0 NULL 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58
+true -59 1969-12-31 16:00:11.231 -59.0 821UdmGbkEf4j 59 -59 0 -59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59
+NULL 44 1969-12-31 16:00:16.279 44.0 NULL -44 44 0 44.0 0.0 -44.0 3500.332 0.0 -44.0 0.0 -10.175 44.0 -0.5972727272727273 44.0 0.0 44
+true -27 1969-12-31 16:00:14.723 -27.0 1cGVWH7n1QU 27 -27 0 -27.0 -0.0 27.0 -2147.931 0.0 27.0 0.0 -10.175 -27.0 0.9733333333333334 -27.0 0.0 -27
+NULL 0 1969-12-31 16:00:13.396 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true -25 1969-12-31 16:00:15.516 -25.0 821UdmGbkEf4j 25 -25 0 -25.0 -0.0 25.0 -1988.8249999999998 0.0 25.0 0.0 -10.175 -25.0 1.0512000000000001 -25.0 0.0 -25
+true -40 1969-12-31 16:00:11.833 -40.0 cvLH6Eat2yFsyy7p 40 -40 0 -40.0 -0.0 40.0 -3182.12 0.0 40.0 0.0 -10.175 -40.0 0.657 -40.0 0.0 -40
+NULL 29 1969-12-31 16:00:16.19 29.0 NULL -29 29 0 29.0 0.0 -29.0 2307.037 0.0 -29.0 0.0 -10.175 29.0 -0.9062068965517242 29.0 0.0 29
+NULL -27 1969-12-31 16:00:15.435 -27.0 NULL 27 -27 0 -27.0 -0.0 27.0 -2147.931 0.0 27.0 0.0 -10.175 -27.0 0.9733333333333334 -27.0 0.0 -27
+NULL -63 1969-12-31 16:00:15.436 -63.0 NULL 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63
+NULL -6 1969-12-31 16:00:11.883 -6.0 NULL 6 -6 0 -6.0 -0.0 6.0 -477.318 0.0 6.0 0.0 -10.175 -6.0 4.38 -6.0 0.0 -6
+true 14 1969-12-31 16:00:11.302 14.0 821UdmGbkEf4j -14 14 0 14.0 0.0 -14.0 1113.742 0.0 -14.0 0.0 -10.175 14.0 -1.8771428571428572 14.0 0.0 14
+true -63 1969-12-31 16:00:14.899 -63.0 cvLH6Eat2yFsyy7p 63 -63 0 -63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0 0.41714285714285715 -63.0 0.0 -63
+true -13 1969-12-31 16:00:15.223 -13.0 1cGVWH7n1QU 13 -13 0 -13.0 -0.0 13.0 -1034.1889999999999 0.0 13.0 0.0 -10.175 -13.0 2.0215384615384617 -13.0 0.0 -13
+true 49 1969-12-31 16:00:15.541 49.0 cvLH6Eat2yFsyy7p -49 49 0 49.0 0.0 -49.0 3898.0969999999998 0.0 -49.0 0.0 -10.175 49.0 -0.5363265306122449 49.0 0.0 49
+true -60 1969-12-31 16:00:12.291 -60.0 821UdmGbkEf4j 60 -60 0 -60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0 0.438 -60.0 0.0 -60
+NULL 32 1969-12-31 16:00:14.026 32.0 NULL -32 32 0 32.0 0.0 -32.0 2545.696 0.0 -32.0 0.0 -10.175 32.0 -0.82125 32.0 0.0 32
+true 16 1969-12-31 16:00:15.698 16.0 1cGVWH7n1QU -16 16 0 16.0 0.0 -16.0 1272.848 0.0 -16.0 0.0 -10.175 16.0 -1.6425 16.0 0.0 16
+NULL 57 1969-12-31 16:00:14.011 57.0 NULL -57 57 0 57.0 0.0 -57.0 4534.521 0.0 -57.0 0.0 -10.175 57.0 -0.4610526315789474 57.0 0.0 57
+true 41 1969-12-31 16:00:12.235 41.0 cvLH6Eat2yFsyy7p -41 41 0 41.0 0.0 -41.0 3261.673 0.0 -41.0 0.0 -10.175 41.0 -0.6409756097560976 41.0 0.0 41
+true -64 1969-12-31 16:00:12.857 -64.0 821UdmGbkEf4j 64 -64 0 -64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0 0.410625 -64.0 0.0 -64
+true 36 1969-12-31 16:00:13.825 36.0 cvLH6Eat2yFsyy7p -36 36 0 36.0 0.0 -36.0 2863.908 0.0 -36.0 0.0 -10.175 36.0 -0.73 36.0 0.0 36
+NULL -15 1969-12-31 16:00:15.186 -15.0 NULL 15 -15 0 -15.0 -0.0 15.0 -1193.295 0.0 15.0 0.0 -10.175 -15.0 1.752 -15.0 0.0 -15
+true -2 1969-12-31 16:00:15.431 -2.0 1cGVWH7n1QU 2 -2 0 -2.0 -0.0 2.0 -159.106 0.0 2.0 0.0 -10.175 -2.0 13.14 -2.0 0.0 -2
PREHOOK: query: -- double compare timestamp
EXPLAIN
SELECT cboolean1,
@@ -430,43 +430,43 @@ LIMIT 40
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-true -21 1969-12-31 16:00:00.826 -21.0 1cGVWH7n1QU 21 -21 0 -21.0 -0.0 21.0 -1670.6129999999998 0.0 21.0 0.0 -10.175 -21.0 1.2514285714285716 -21.0 0.0 -21
-true 26 1969-12-31 16:00:14.341 26.0 1cGVWH7n1QU -26 26 0 26.0 0.0 -26.0 2068.3779999999997 0.0 -26.0 0.0 -10.175 26.0 -1.0107692307692309 26.0 0.0 26
-NULL -62 1969-12-31 16:00:12.388 -62.0 NULL 62 -62 0 -62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0 0.4238709677419355 -62.0 0.0 -62
-NULL -16 1969-12-31 15:59:58.727 -16.0 NULL 16 -16 0 -16.0 -0.0 16.0 -1272.848 0.0 16.0 0.0 -10.175 -16.0 1.6425 -16.0 0.0 -16
-NULL -24 1969-12-31 16:00:07.302 -24.0 NULL 24 -24 0 -24.0 -0.0 24.0 -1909.272 0.0 24.0 0.0 -10.175 -24.0 1.095 -24.0 0.0 -24
-true -10 1969-12-31 16:00:05.636 -10.0 1cGVWH7n1QU 10 -10 0 -10.0 -0.0 10.0 -795.53 0.0 10.0 0.0 -10.175 -10.0 2.628 -10.0 0.0 -10
-NULL 41 1969-12-31 16:00:14.017 41.0 NULL -41 41 0 41.0 0.0 -41.0 3261.673 0.0 -41.0 0.0 -10.175 41.0 -0.6409756097560976 41.0 0.0 41
-NULL 26 1969-12-31 16:00:04.699 26.0 NULL -26 26 0 26.0 0.0 -26.0 2068.3779999999997 0.0 -26.0 0.0 -10.175 26.0 -1.0107692307692309 26.0 0.0 26
-NULL 18 1969-12-31 16:00:02.295 18.0 NULL -18 18 0 18.0 0.0 -18.0 1431.954 0.0 -18.0 0.0 -10.175 18.0 -1.46 18.0 0.0 18
-true 61 1969-12-31 16:00:05.394 61.0 cvLH6Eat2yFsyy7p -61 61 0 61.0 0.0 -61.0 4852.733 0.0 -61.0 0.0 -10.175 61.0 -0.4308196721311476 61.0 0.0 61
-true 9 1969-12-31 16:00:11.544 9.0 1cGVWH7n1QU -9 9 0 9.0 0.0 -9.0 715.977 0.0 -9.0 0.0 -10.175 9.0 -2.92 9.0 0.0 9
-true 55 1969-12-31 15:59:58.962 55.0 cvLH6Eat2yFsyy7p -55 55 0 55.0 0.0 -55.0 4375.415 0.0 -55.0 0.0 -10.175 55.0 -0.47781818181818186 55.0 0.0 55
-true 52 1969-12-31 16:00:07.428 52.0 1cGVWH7n1QU -52 52 0 52.0 0.0 -52.0 4136.755999999999 0.0 -52.0 0.0 -10.175 52.0 -0.5053846153846154 52.0 0.0 52
-NULL -41 1969-12-31 16:00:00.096 -41.0 NULL 41 -41 0 -41.0 -0.0 41.0 -3261.673 0.0 41.0 0.0 -10.175 -41.0 0.6409756097560976 -41.0 0.0 -41
-NULL -51 1969-12-31 16:00:12.494 -51.0 NULL 51 -51 0 -51.0 -0.0 51.0 -4057.203 0.0 51.0 0.0 -10.175 -51.0 0.5152941176470588 -51.0 0.0 -51
-NULL -18 1969-12-31 16:00:06.015 -18.0 NULL 18 -18 0 -18.0 -0.0 18.0 -1431.954 0.0 18.0 0.0 -10.175 -18.0 1.46 -18.0 0.0 -18
-true -34 1969-12-31 16:00:15.254 -34.0 821UdmGbkEf4j 34 -34 0 -34.0 -0.0 34.0 -2704.8019999999997 0.0 34.0 0.0 -10.175 -34.0 0.7729411764705882 -34.0 0.0 -34
-NULL 46 1969-12-31 16:00:00.259 46.0 NULL -46 46 0 46.0 0.0 -46.0 3659.438 0.0 -46.0 0.0 -10.175 46.0 -0.571304347826087 46.0 0.0 46
-NULL -30 1969-12-31 16:00:12.935 -30.0 NULL 30 -30 0 -30.0 -0.0 30.0 -2386.59 0.0 30.0 0.0 -10.175 -30.0 0.876 -30.0 0.0 -30
-true 34 1969-12-31 16:00:10.818 34.0 1cGVWH7n1QU -34 34 0 34.0 0.0 -34.0 2704.8019999999997 0.0 -34.0 0.0 -10.175 34.0 -0.7729411764705882 34.0 0.0 34
-true -29 1969-12-31 16:00:03.586 -29.0 1cGVWH7n1QU 29 -29 0 -29.0 -0.0 29.0 -2307.037 0.0 29.0 0.0 -10.175 -29.0 0.9062068965517242 -29.0 0.0 -29
-NULL 48 1969-12-31 16:00:15.512 48.0 NULL -48 48 0 48.0 0.0 -48.0 3818.544 0.0 -48.0 0.0 -10.175 48.0 -0.5475 48.0 0.0 48
-NULL -21 1969-12-31 16:00:13.32 -21.0 NULL 21 -21 0 -21.0 -0.0 21.0 -1670.6129999999998 0.0 21.0 0.0 -10.175 -21.0 1.2514285714285716 -21.0 0.0 -21
-true 15 1969-12-31 16:00:03.901 15.0 1cGVWH7n1QU -15 15 0 15.0 0.0 -15.0 1193.295 0.0 -15.0 0.0 -10.175 15.0 -1.752 15.0 0.0 15
-NULL 53 1969-12-31 16:00:00.557 53.0 NULL -53 53 0 53.0 0.0 -53.0 4216.309 0.0 -53.0 0.0 -10.175 53.0 -0.4958490566037736 53.0 0.0 53
-true -54 1969-12-31 16:00:01.64 -54.0 821UdmGbkEf4j 54 -54 0 -54.0 -0.0 54.0 -4295.862 0.0 54.0 0.0 -10.175 -54.0 0.4866666666666667 -54.0 0.0 -54
-true -44 1969-12-31 16:00:05.272 -44.0 1cGVWH7n1QU 44 -44 0 -44.0 -0.0 44.0 -3500.332 0.0 44.0 0.0 -10.175 -44.0 0.5972727272727273 -44.0 0.0 -44
-true 28 1969-12-31 16:00:02.779 28.0 1cGVWH7n1QU -28 28 0 28.0 0.0 -28.0 2227.484 0.0 -28.0 0.0 -10.175 28.0 -0.9385714285714286 28.0 0.0 28
-NULL 47 1969-12-31 16:00:06.723 47.0 NULL -47 47 0 47.0 0.0 -47.0 3738.991 0.0 -47.0 0.0 -10.175 47.0 -0.5591489361702128 47.0 0.0 47
-NULL 36 1969-12-31 16:00:00.865 36.0 NULL -36 36 0 36.0 0.0 -36.0 2863.908 0.0 -36.0 0.0 -10.175 36.0 -0.73 36.0 0.0 36
-NULL 35 1969-12-31 16:00:09.892 35.0 NULL -35 35 0 35.0 0.0 -35.0 2784.355 0.0 -35.0 0.0 -10.175 35.0 -0.7508571428571429 35.0 0.0 35
-NULL 55 1969-12-31 16:00:15.035 55.0 NULL -55 55 0 55.0 0.0 -55.0 4375.415 0.0 -55.0 0.0 -10.175 55.0 -0.47781818181818186 55.0 0.0 55
-NULL -19 1969-12-31 16:00:08.607 -19.0 NULL 19 -19 0 -19.0 -0.0 19.0 -1511.507 0.0 19.0 0.0 -10.175 -19.0 1.3831578947368421 -19.0 0.0 -19
-NULL -49 1969-12-31 16:00:09.473 -49.0 NULL 49 -49 0 -49.0 -0.0 49.0 -3898.0969999999998 0.0 49.0 0.0 -10.175 -49.0 0.5363265306122449 -49.0 0.0 -49
-true 19 1969-12-31 16:00:03.827 19.0 cvLH6Eat2yFsyy7p -19 19 0 19.0 0.0 -19.0 1511.507 0.0 -19.0 0.0 -10.175 19.0 -1.3831578947368421 19.0 0.0 19
-NULL 13 1969-12-31 16:00:09.387 13.0 NULL -13 13 0 13.0 0.0 -13.0 1034.1889999999999 0.0 -13.0 0.0 -10.175 13.0 -2.0215384615384617 13.0 0.0 13
-NULL 42 1969-12-31 16:00:16.251 42.0 NULL -42 42 0 42.0 0.0 -42.0 3341.2259999999997 0.0 -42.0 0.0 -10.175 42.0 -0.6257142857142858 42.0 0.0 42
-NULL 11 1969-12-31 16:00:15.338 11.0 NULL -11 11 0 11.0 0.0 -11.0 875.083 0.0 -11.0 0.0 -10.175 11.0 -2.389090909090909 11.0 0.0 11
-NULL 39 1969-12-31 16:00:14.32 39.0 NULL -39 39 0 39.0 0.0 -39.0 3102.567 0.0 -39.0 0.0 -10.175 39.0 -0.6738461538461539 39.0 0.0 39
-NULL 9 1969-12-31 16:00:00.945 9.0 NULL -9 9 0 9.0 0.0 -9.0 715.977 0.0 -9.0 0.0 -10.175 9.0 -2.92 9.0 0.0 9
+NULL -26 1969-12-31 16:00:08.33 -26.0 NULL 26 -26 0 -26.0 -0.0 26.0 -2068.3779999999997 0.0 26.0 0.0 -10.175 -26.0 1.0107692307692309 -26.0 0.0 -26
+NULL -6 1969-12-31 16:00:07.423 -6.0 NULL 6 -6 0 -6.0 -0.0 6.0 -477.318 0.0 6.0 0.0 -10.175 -6.0 4.38 -6.0 0.0 -6
+true 55 1969-12-31 15:59:58.969 55.0 cvLH6Eat2yFsyy7p -55 55 0 55.0 0.0 -55.0 4375.415 0.0 -55.0 0.0 -10.175 55.0 -0.47781818181818186 55.0 0.0 55
+true 14 1969-12-31 16:00:08.209 14.0 1cGVWH7n1QU -14 14 0 14.0 0.0 -14.0 1113.742 0.0 -14.0 0.0 -10.175 14.0 -1.8771428571428572 14.0 0.0 14
+true 48 1969-12-31 16:00:00.923 48.0 1cGVWH7n1QU -48 48 0 48.0 0.0 -48.0 3818.544 0.0 -48.0 0.0 -10.175 48.0 -0.5475 48.0 0.0 48
+true -10 1969-12-31 16:00:00.082 -10.0 1cGVWH7n1QU 10 -10 0 -10.0 -0.0 10.0 -795.53 0.0 10.0 0.0 -10.175 -10.0 2.628 -10.0 0.0 -10
+true -55 1969-12-31 16:00:05.591 -55.0 1cGVWH7n1QU 55 -55 0 -55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0 0.47781818181818186 -55.0 0.0 -55
+NULL -35 1969-12-31 16:00:04.52 -35.0 NULL 35 -35 0 -35.0 -0.0 35.0 -2784.355 0.0 35.0 0.0 -10.175 -35.0 0.7508571428571429 -35.0 0.0 -35
+NULL -8 1969-12-31 16:00:00.65 -8.0 NULL 8 -8 0 -8.0 -0.0 8.0 -636.424 0.0 8.0 0.0 -10.175 -8.0 3.285 -8.0 0.0 -8
+NULL -20 1969-12-31 16:00:13.131 -20.0 NULL 20 -20 0 -20.0 -0.0 20.0 -1591.06 0.0 20.0 0.0 -10.175 -20.0 1.314 -20.0 0.0 -20
+true 30 1969-12-31 16:00:15.705 30.0 821UdmGbkEf4j -30 30 0 30.0 0.0 -30.0 2386.59 0.0 -30.0 0.0 -10.175 30.0 -0.876 30.0 0.0 30
+true 40 1969-12-31 16:00:16.188 40.0 1cGVWH7n1QU -40 40 0 40.0 0.0 -40.0 3182.12 0.0 -40.0 0.0 -10.175 40.0 -0.657 40.0 0.0 40
+NULL -21 1969-12-31 16:00:12.544 -21.0 NULL 21 -21 0 -21.0 -0.0 21.0 -1670.6129999999998 0.0 21.0 0.0 -10.175 -21.0 1.2514285714285716 -21.0 0.0 -21
+true -34 1969-12-31 16:00:14.043 -34.0 821UdmGbkEf4j 34 -34 0 -34.0 -0.0 34.0 -2704.8019999999997 0.0 34.0 0.0 -10.175 -34.0 0.7729411764705882 -34.0 0.0 -34
+NULL 23 1969-12-31 16:00:08.307 23.0 NULL -23 23 0 23.0 0.0 -23.0 1829.719 0.0 -23.0 0.0 -10.175 23.0 -1.142608695652174 23.0 0.0 23
+true 8 1969-12-31 16:00:10.496 8.0 821UdmGbkEf4j -8 8 0 8.0 0.0 -8.0 636.424 0.0 -8.0 0.0 -10.175 8.0 -3.285 8.0 0.0 8
+NULL -55 1969-12-31 16:00:08.896 -55.0 NULL 55 -55 0 -55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0 0.47781818181818186 -55.0 0.0 -55
+NULL -57 1969-12-31 16:00:02.707 -57.0 NULL 57 -57 0 -57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0 0.4610526315789474 -57.0 0.0 -57
+true 1 1969-12-31 16:00:00.125 1.0 cvLH6Eat2yFsyy7p -1 1 0 1.0 0.0 -1.0 79.553 0.0 -1.0 0.0 -10.175 1.0 -26.28 1.0 0.0 1
+true -1 1969-12-31 16:00:00.107 -1.0 1cGVWH7n1QU 1 -1 0 -1.0 -0.0 1.0 -79.553 0.0 1.0 0.0 -10.175 -1.0 26.28 -1.0 0.0 -1
+true -59 1969-12-31 16:00:11.231 -59.0 821UdmGbkEf4j 59 -59 0 -59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175 -59.0 0.44542372881355935 -59.0 0.0 -59
+NULL 33 1969-12-31 16:00:07.006 33.0 NULL -33 33 0 33.0 0.0 -33.0 2625.249 0.0 -33.0 0.0 -10.175 33.0 -0.7963636363636364 33.0 0.0 33
+NULL -58 1969-12-31 16:00:15.658 -58.0 NULL 58 -58 0 -58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0 0.4531034482758621 -58.0 0.0 -58
+true -6 1969-12-31 16:00:07.372 -6.0 cvLH6Eat2yFsyy7p 6 -6 0 -6.0 -0.0 6.0 -477.318 0.0 6.0 0.0 -10.175 -6.0 4.38 -6.0 0.0 -6
+true -27 1969-12-31 16:00:14.723 -27.0 1cGVWH7n1QU 27 -27 0 -27.0 -0.0 27.0 -2147.931 0.0 27.0 0.0 -10.175 -27.0 0.9733333333333334 -27.0 0.0 -27
+NULL 29 1969-12-31 16:00:16.19 29.0 NULL -29 29 0 29.0 0.0 -29.0 2307.037 0.0 -29.0 0.0 -10.175 29.0 -0.9062068965517242 29.0 0.0 29
+NULL -27 1969-12-31 16:00:15.435 -27.0 NULL 27 -27 0 -27.0 -0.0 27.0 -2147.931 0.0 27.0 0.0 -10.175 -27.0 0.9733333333333334 -27.0 0.0 -27
+true 33 1969-12-31 16:00:09.924 33.0 cvLH6Eat2yFsyy7p -33 33 0 33.0 0.0 -33.0 2625.249 0.0 -33.0 0.0 -10.175 33.0 -0.7963636363636364 33.0 0.0 33
+NULL -18 1969-12-31 16:00:00.564 -18.0 NULL 18 -18 0 -18.0 -0.0 18.0 -1431.954 0.0 18.0 0.0 -10.175 -18.0 1.46 -18.0 0.0 -18
+NULL -51 1969-12-31 16:00:02.011 -51.0 NULL 51 -51 0 -51.0 -0.0 51.0 -4057.203 0.0 51.0 0.0 -10.175 -51.0 0.5152941176470588 -51.0 0.0 -51
+true -8 1969-12-31 16:00:02.109 -8.0 cvLH6Eat2yFsyy7p 8 -8 0 -8.0 -0.0 8.0 -636.424 0.0 8.0 0.0 -10.175 -8.0 3.285 -8.0 0.0 -8
+true -13 1969-12-31 16:00:15.223 -13.0 1cGVWH7n1QU 13 -13 0 -13.0 -0.0 13.0 -1034.1889999999999 0.0 13.0 0.0 -10.175 -13.0 2.0215384615384617 -13.0 0.0 -13
+true -52 1969-12-31 16:00:01.824 -52.0 821UdmGbkEf4j 52 -52 0 -52.0 -0.0 52.0 -4136.755999999999 0.0 52.0 0.0 -10.175 -52.0 0.5053846153846154 -52.0 0.0 -52
+true -28 1969-12-31 16:00:10.554 -28.0 821UdmGbkEf4j 28 -28 0 -28.0 -0.0 28.0 -2227.484 0.0 28.0 0.0 -10.175 -28.0 0.9385714285714286 -28.0 0.0 -28
+true 2 1969-12-31 16:00:06.546 2.0 821UdmGbkEf4j -2 2 0 2.0 0.0 -2.0 159.106 0.0 -2.0 0.0 -10.175 2.0 -13.14 2.0 0.0 2
+true 40 1969-12-31 16:00:02.842 40.0 1cGVWH7n1QU -40 40 0 40.0 0.0 -40.0 3182.12 0.0 -40.0 0.0 -10.175 40.0 -0.657 40.0 0.0 40
+NULL 55 1969-12-31 16:00:02.215 55.0 NULL -55 55 0 55.0 0.0 -55.0 4375.415 0.0 -55.0 0.0 -10.175 55.0 -0.47781818181818186 55.0 0.0 55
+NULL 22 1969-12-31 16:00:00.621 22.0 NULL -22 22 0 22.0 0.0 -22.0 1750.166 0.0 -22.0 0.0 -10.175 22.0 -1.1945454545454546 22.0 0.0 22
+NULL 58 1969-12-31 16:00:03.366 58.0 NULL -58 58 0 58.0 0.0 -58.0 4614.074 0.0 -58.0 0.0 -10.175 58.0 -0.4531034482758621 58.0 0.0 58
+true 0 1969-12-31 16:00:08.742 0.0 821UdmGbkEf4j 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out?rev=1635566&r1=1635565&r2=1635566&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out Thu Oct 30 18:03:26 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/windowing.q.out?rev=1635566&r1=1635565&r2=1635566&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/windowing.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/windowing.q.out Thu Oct 30 18:03:26 2014
@@ -2362,3 +2362,15 @@ POSTHOOK: Input: default@part
1602.59 1549.8900000000003 4649.670000000001
1414.42 1523.5400000000004 3047.080000000001
1632.66 1632.6600000000008 1632.6600000000008
+PREHOOK: query: -- 47. empty partition
+select sum(p_size) over (partition by p_mfgr )
+from part where p_mfgr = 'm1'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: -- 47. empty partition
+select sum(p_size) over (partition by p_mfgr )
+from part where p_mfgr = 'm1'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####