hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject [20/30] hive git commit: HIVE-13945 : Decimal value is displayed as rounded when selecting where clause with that decimal value (Sergey Shelukhin, reviewed by Ashutosh Chauhan)
Date Thu, 07 Jul 2016 19:50:05 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/1b5ee3d8/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out b/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out
index 55ec10d..6e443f8 100644
--- a/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out
+++ b/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out
@@ -1,4 +1,3 @@
-WARNING: Comparing a bigint and a double may result in a loss of precision.
 PREHOOK: query: -- SORT_QUERY_RESULTS
 
 -- If you look at ql/src/test/org/apache/hadoop/hive/ql/exec/vector/util/OrcFileGenerator.java
@@ -152,7 +151,7 @@ STAGE PLANS:
                   alias: alltypesorc
                   Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
-                    predicate: ((762 = cbigint) or ((UDFToFloat(csmallint) < cfloat) and (UDFToDouble(ctimestamp2) > -5.0) and (cdouble <> UDFToDouble(cint))) or (cstring1 = 'a') or ((UDFToDouble(cbigint) <= -1.389) and (cstring2 <> 'a') and (79.553 <> UDFToDouble(cint)) and (cboolean2 <> cboolean1))) (type: boolean)
+                    predicate: ((762 = cbigint) or ((UDFToFloat(csmallint) < cfloat) and (UDFToDouble(ctimestamp2) > -5.0) and (cdouble <> UDFToDouble(cint))) or (cstring1 = 'a') or ((CAST( cbigint AS decimal(22,3)) <= -1.389) and (cstring2 <> 'a') and (79.553 <> CAST( cint AS decimal(13,3))) and (cboolean2 <> cboolean1))) (type: boolean)
                     Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: cint (type: int), cdouble (type: double), csmallint (type: smallint), cfloat (type: float), ctinyint (type: tinyint)
@@ -193,7 +192,6 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-WARNING: Comparing a bigint and a double may result in a loss of precision.
 PREHOOK: query: SELECT AVG(cint),
        (AVG(cint) + -3728),
        (-((AVG(cint) + -3728))),
@@ -567,7 +565,7 @@ STAGE PLANS:
                   alias: alltypesorc
                   Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
-                    predicate: ((ctimestamp1 = ctimestamp2) or (762.0 = cfloat) or (cstring1 = 'ss') or ((UDFToLong(csmallint) <= cbigint) and (1 = cboolean2)) or (cboolean1 is not null and ctimestamp2 is not null and (cstring2 > 'a'))) (type: boolean)
+                    predicate: ((ctimestamp1 = ctimestamp2) or (762 = cfloat) or (cstring1 = 'ss') or ((UDFToLong(csmallint) <= cbigint) and (1 = cboolean2)) or (cboolean1 is not null and ctimestamp2 is not null and (cstring2 > 'a'))) (type: boolean)
                     Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: cbigint (type: bigint), ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cdouble (type: double)
@@ -591,7 +589,7 @@ STAGE PLANS:
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
                 Statistics: Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
-                  expressions: _col0 (type: double), (- _col0) (type: double), (_col0 - (- _col0)) (type: double), _col1 (type: bigint), (UDFToDouble(_col1) % 79.553) (type: double), _col2 (type: tinyint), (UDFToDouble(_col1) - (- _col0)) (type: double), (- (- _col0)) (type: double), (-1.0 % (- _col0)) (type: double), _col1 (type: bigint), (- _col1) (type: bigint), _col3 (type: double), (- (- (- _col0))) (type: double), (762 * (- _col1)) (type: bigint), _col4 (type: int), (UDFToLong(_col2) + (762 * (- _col1))) (type: bigint), ((- _col0) + UDFToDouble(_col4)) (type: double), _col5 (type: double), ((- _col1) % _col1) (type: bigint), _col6 (type: bigint), _col7 (type: double), (-3728 % (UDFToLong(_col2) + (762 * (- _col1)))) (type: bigint)
+                  expressions: _col0 (type: double), (- _col0) (type: double), (_col0 - (- _col0)) (type: double), _col1 (type: bigint), (CAST( _col1 AS decimal(19,0)) % 79.553) (type: decimal(5,3)), _col2 (type: tinyint), (UDFToDouble(_col1) - (- _col0)) (type: double), (- (- _col0)) (type: double), (-1.0 % (- _col0)) (type: double), _col1 (type: bigint), (- _col1) (type: bigint), _col3 (type: double), (- (- (- _col0))) (type: double), (762 * (- _col1)) (type: bigint), _col4 (type: int), (UDFToLong(_col2) + (762 * (- _col1))) (type: bigint), ((- _col0) + UDFToDouble(_col4)) (type: double), _col5 (type: double), ((- _col1) % _col1) (type: bigint), _col6 (type: bigint), _col7 (type: double), (-3728 % (UDFToLong(_col2) + (762 * (- _col1)))) (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
                   Statistics: Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE
                   File Output Operator
@@ -676,7 +674,7 @@ WHERE  ((ctimestamp1 = ctimestamp2)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
-2.5109214708345636E18	-2.5109214708345636E18	5.0218429416691272E18	2780	75.19800000000009	62	2.5109214708345661E18	2.5109214708345636E18	-1.0	2780	-2780	9460.675803068349	-2.5109214708345636E18	-2118360	1072872630	-2118298	-2.5109214697616911E18	185935.34910862707	0	758	-1.733509234828496	-3728
+2.5109214708345636E18	-2.5109214708345636E18	5.0218429416691272E18	2780	75.198	62	2.5109214708345661E18	2.5109214708345636E18	-1.0	2780	-2780	9460.675803068349	-2.5109214708345636E18	-2118360	1072872630	-2118298	-2.5109214697616911E18	185935.34910862707	0	758	-1.733509234828496	-3728
 WARNING: Comparing a bigint and a double may result in a loss of precision.
 PREHOOK: query: -- TargetTypeClasses: String, Bool, Timestamp, Long, Double
 -- Functions: Avg, Max, StDev, VarP
@@ -749,7 +747,7 @@ STAGE PLANS:
                   alias: alltypesorc
                   Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
-                    predicate: (((ctimestamp2 <= ctimestamp1) and (UDFToDouble(cbigint) <> cdouble) and ('ss' <= cstring1)) or ((csmallint < UDFToShort(ctinyint)) and (UDFToDouble(ctimestamp1) >= 0.0)) or (cfloat = 17.0)) (type: boolean)
+                    predicate: (((ctimestamp2 <= ctimestamp1) and (UDFToDouble(cbigint) <> cdouble) and ('ss' <= cstring1)) or ((csmallint < UDFToShort(ctinyint)) and (UDFToDouble(ctimestamp1) >= 0.0)) or (cfloat = 17)) (type: boolean)
                     Statistics: Num rows: 8874 Data size: 272428 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: ctinyint (type: tinyint), cbigint (type: bigint), cint (type: int), cfloat (type: float)
@@ -939,14 +937,14 @@ STAGE PLANS:
                   alias: alltypesorc
                   Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
-                    predicate: ((cstring1 regexp 'a.*' and (cstring2 like '%ss%')) or ((1 <> cboolean2) and (UDFToDouble(csmallint) < 79.553) and (-257 <> UDFToInteger(ctinyint))) or ((cdouble > UDFToDouble(ctinyint)) and (cfloat >= UDFToFloat(cint))) or ((UDFToLong(cint) < cbigint) and (UDFToLong(ctinyint) > cbigint))) (type: boolean)
+                    predicate: ((cstring1 regexp 'a.*' and (cstring2 like '%ss%')) or ((1 <> cboolean2) and (CAST( csmallint AS decimal(8,3)) < 79.553) and (-257 <> UDFToInteger(ctinyint))) or ((cdouble > UDFToDouble(ctinyint)) and (cfloat >= UDFToFloat(cint))) or ((UDFToLong(cint) < cbigint) and (UDFToLong(ctinyint) > cbigint))) (type: boolean)
                     Statistics: Num rows: 9898 Data size: 303864 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
-                      expressions: cint (type: int), cdouble (type: double), ctimestamp2 (type: timestamp), cstring1 (type: string), cboolean2 (type: boolean), ctinyint (type: tinyint), cfloat (type: float), ctimestamp1 (type: timestamp), csmallint (type: smallint), cbigint (type: bigint), (-3728 * cbigint) (type: bigint), (- cint) (type: int), (-863.257 - UDFToDouble(cint)) (type: double), (- csmallint) (type: smallint), (csmallint - (- csmallint)) (type: smallint), ((csmallint - (- csmallint)) + (- csmallint)) (type: smallint), (UDFToDouble(cint) / UDFToDouble(cint)) (type: double), ((-863.257 - UDFToDouble(cint)) - -26.28) (type: double), (- cfloat) (type: float), (cdouble * -89010.0) (type: double), (UDFToDouble(ctinyint) / 988888.0) (type: double), (- ctinyint) (type: tinyint), (79.553 / UDFToDouble(ctinyint)) (type: double)
+                      expressions: cint (type: int), cdouble (type: double), ctimestamp2 (type: timestamp), cstring1 (type: string), cboolean2 (type: boolean), ctinyint (type: tinyint), cfloat (type: float), ctimestamp1 (type: timestamp), csmallint (type: smallint), cbigint (type: bigint), (-3728 * cbigint) (type: bigint), (- cint) (type: int), (-863.257 - CAST( cint AS decimal(10,0))) (type: decimal(14,3)), (- csmallint) (type: smallint), (csmallint - (- csmallint)) (type: smallint), ((csmallint - (- csmallint)) + (- csmallint)) (type: smallint), (UDFToDouble(cint) / UDFToDouble(cint)) (type: double), ((-863.257 - CAST( cint AS decimal(10,0))) - -26.28) (type: decimal(15,3)), (- cfloat) (type: float), (cdouble * -89010.0) (type: double), (UDFToDouble(ctinyint) / 988888.0) (type: double), (- ctinyint) (type: tinyint), (79.553 / CAST( ctinyint AS decimal(3,0))) (type: decimal(20,18))
                       outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22
                       Statistics: Num rows: 9898 Data size: 303864 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
-                        key expressions: _col0 (type: int), _col1 (type: double), _col2 (type: timestamp), _col3 (type: string), _col4 (type: boolean), _col5 (type: tinyint), _col6 (type: float), _col7 (type: timestamp), _col8 (type: smallint), _col9 (type: bigint), _col10 (type: bigint), _col11 (type: int), _col12 (type: double), _col13 (type: smallint), _col14 (type: smallint), _col15 (type: smallint), _col16 (type: double), _col17 (type: double), _col18 (type: float), _col19 (type: double), _col20 (type: double), _col21 (type: tinyint), _col22 (type: double)
+                        key expressions: _col0 (type: int), _col1 (type: double), _col2 (type: timestamp), _col3 (type: string), _col4 (type: boolean), _col5 (type: tinyint), _col6 (type: float), _col7 (type: timestamp), _col8 (type: smallint), _col9 (type: bigint), _col10 (type: bigint), _col11 (type: int), _col12 (type: decimal(14,3)), _col13 (type: smallint), _col14 (type: smallint), _col15 (type: smallint), _col16 (type: double), _col17 (type: decimal(15,3)), _col18 (type: float), _col19 (type: double), _col20 (type: double), _col21 (type: tinyint), _col22 (type: decimal(20,18))
                         sort order: +++++++++++++++++++++++
                         Statistics: Num rows: 9898 Data size: 303864 Basic stats: COMPLETE Column stats: NONE
                         TopN Hash Memory Usage: 0.1
@@ -955,7 +953,7 @@ STAGE PLANS:
             Execution mode: vectorized
             Reduce Operator Tree:
               Select Operator
-                expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: boolean), KEY.reducesinkkey5 (type: tinyint), KEY.reducesinkkey6 (type: float), KEY.reducesinkkey7 (type: timestamp), KEY.reducesinkkey8 (type: smallint), KEY.reducesinkkey9 (type: bigint), KEY.reducesinkkey10 (type: bigint), KEY.reducesinkkey11 (type: int), KEY.reducesinkkey12 (type: double), KEY.reducesinkkey13 (type: smallint), KEY.reducesinkkey14 (type: smallint), KEY.reducesinkkey15 (type: smallint), KEY.reducesinkkey16 (type: double), KEY.reducesinkkey17 (type: double), KEY.reducesinkkey18 (type: float), KEY.reducesinkkey19 (type: double), KEY.reducesinkkey20 (type: double), KEY.reducesinkkey21 (type: tinyint), KEY.reducesinkkey22 (type: double)
+                expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: boolean), KEY.reducesinkkey5 (type: tinyint), KEY.reducesinkkey6 (type: float), KEY.reducesinkkey7 (type: timestamp), KEY.reducesinkkey8 (type: smallint), KEY.reducesinkkey9 (type: bigint), KEY.reducesinkkey10 (type: bigint), KEY.reducesinkkey11 (type: int), KEY.reducesinkkey12 (type: decimal(14,3)), KEY.reducesinkkey13 (type: smallint), KEY.reducesinkkey14 (type: smallint), KEY.reducesinkkey15 (type: smallint), KEY.reducesinkkey16 (type: double), KEY.reducesinkkey17 (type: decimal(15,3)), KEY.reducesinkkey18 (type: float), KEY.reducesinkkey19 (type: double), KEY.reducesinkkey20 (type: double), KEY.reducesinkkey21 (type: tinyint), KEY.reducesinkkey22 (type: decimal(20,18))
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22
                 Statistics: Num rows: 9898 Data size: 303864 Basic stats: COMPLETE Column stats: NONE
                 Limit
@@ -1051,56 +1049,56 @@ LIMIT 50
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-51	-51.0	1969-12-31 15:59:43.64	-7196	-1339164819	4992406445232	NULL	NULL	7196	-14392	-7196	NULL	NULL	51.0	6.4051596E8	-5.157308006568995E-5	51	-1.5598627450980391
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 15:59:45.978	-7196	-2128720310	7935869315680	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.5298653846153845
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 15:59:47.15	-7196	628698169	-2343786774032	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.5298653846153845
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 15:59:57.86	-7196	-26309289	98081029392	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.5298653846153845
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 15:59:58.479	-7196	-1379694191	5143499944048	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.5298653846153845
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 16:00:03.963	-7196	95444104	-355815619712	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.5298653846153845
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 16:00:04.518	-7196	-1658319459	6182214943152	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.5298653846153845
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-53	-53.0	1969-12-31 15:59:48.882	-7196	-1560660031	5818140595568	NULL	NULL	7196	-14392	-7196	NULL	NULL	53.0	6.4051596E8	-5.359555379375622E-5	53	-1.501
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-53	-53.0	1969-12-31 15:59:57.663	-7196	898472381	-3349505036368	NULL	NULL	7196	-14392	-7196	NULL	NULL	53.0	6.4051596E8	-5.359555379375622E-5	53	-1.501
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-53	-53.0	1969-12-31 16:00:11.36	-7196	-1357789899	5061840743472	NULL	NULL	7196	-14392	-7196	NULL	NULL	53.0	6.4051596E8	-5.359555379375622E-5	53	-1.501
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-54	-54.0	1969-12-31 15:59:53.657	-7196	1476582815	-5504700734320	NULL	NULL	7196	-14392	-7196	NULL	NULL	54.0	6.4051596E8	-5.4606790657789354E-5	54	-1.4732037037037036
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-54	-54.0	1969-12-31 16:00:05.688	-7196	1614836149	-6020109163472	NULL	NULL	7196	-14392	-7196	NULL	NULL	54.0	6.4051596E8	-5.4606790657789354E-5	54	-1.4732037037037036
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-54	-54.0	1969-12-31 16:00:06.484	-7196	1605976008	-5987078557824	NULL	NULL	7196	-14392	-7196	NULL	NULL	54.0	6.4051596E8	-5.4606790657789354E-5	54	-1.4732037037037036
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-54	-54.0	1969-12-31 16:00:11.198	-7196	1650677402	-6153725354656	NULL	NULL	7196	-14392	-7196	NULL	NULL	54.0	6.4051596E8	-5.4606790657789354E-5	54	-1.4732037037037036
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-55	-55.0	1969-12-31 15:59:43.932	-7196	1982381637	-7390318742736	NULL	NULL	7196	-14392	-7196	NULL	NULL	55.0	6.4051596E8	-5.561802752182249E-5	55	-1.4464181818181818
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-55	-55.0	1969-12-31 16:00:01.138	-7196	888532643	-3312449693104	NULL	NULL	7196	-14392	-7196	NULL	NULL	55.0	6.4051596E8	-5.561802752182249E-5	55	-1.4464181818181818
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-55	-55.0	1969-12-31 16:00:13.249	-7196	-685064281	2553919639568	NULL	NULL	7196	-14392	-7196	NULL	NULL	55.0	6.4051596E8	-5.561802752182249E-5	55	-1.4464181818181818
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-56	-56.0	1969-12-31 16:00:02.298	-7196	-1509994296	5629258735488	NULL	NULL	7196	-14392	-7196	NULL	NULL	56.0	6.4051596E8	-5.6629264385855625E-5	56	-1.4205892857142857
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-57	-57.0	1969-12-31 15:59:44.539	-7196	1839592407	-6858000493296	NULL	NULL	7196	-14392	-7196	NULL	NULL	57.0	6.4051596E8	-5.764050124988876E-5	57	-1.3956666666666666
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-57	-57.0	1969-12-31 16:00:04.659	-7196	-1579093262	5886859680736	NULL	NULL	7196	-14392	-7196	NULL	NULL	57.0	6.4051596E8	-5.764050124988876E-5	57	-1.3956666666666666
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-57	-57.0	1969-12-31 16:00:05.5	-7196	2042351711	-7613887178608	NULL	NULL	7196	-14392	-7196	NULL	NULL	57.0	6.4051596E8	-5.764050124988876E-5	57	-1.3956666666666666
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-57	-57.0	1969-12-31 16:00:12.626	-7196	248308622	-925694542816	NULL	NULL	7196	-14392	-7196	NULL	NULL	57.0	6.4051596E8	-5.764050124988876E-5	57	-1.3956666666666666
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-58	-58.0	1969-12-31 15:59:47.859	-7196	-1770443874	6600214762272	NULL	NULL	7196	-14392	-7196	NULL	NULL	58.0	6.4051596E8	-5.86517381139219E-5	58	-1.3716034482758621
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-58	-58.0	1969-12-31 15:59:55.857	-7196	-825174557	3076250748496	NULL	NULL	7196	-14392	-7196	NULL	NULL	58.0	6.4051596E8	-5.86517381139219E-5	58	-1.3716034482758621
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-58	-58.0	1969-12-31 16:00:12.065	-7196	1257970504	-4689714038912	NULL	NULL	7196	-14392	-7196	NULL	NULL	58.0	6.4051596E8	-5.86517381139219E-5	58	-1.3716034482758621
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-59	-59.0	1969-12-31 16:00:13.15	-7196	-1604890000	5983029920000	NULL	NULL	7196	-14392	-7196	NULL	NULL	59.0	6.4051596E8	-5.966297497795504E-5	59	-1.3483559322033898
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-60	-60.0	1969-12-31 15:59:45.385	-7196	1775867066	-6620432422048	NULL	NULL	7196	-14392	-7196	NULL	NULL	60.0	6.4051596E8	-6.0674211841988174E-5	60	-1.3258833333333333
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-60	-60.0	1969-12-31 15:59:52.408	-7196	1516314750	-5652821388000	NULL	NULL	7196	-14392	-7196	NULL	NULL	60.0	6.4051596E8	-6.0674211841988174E-5	60	-1.3258833333333333
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-60	-60.0	1969-12-31 15:59:55.806	-7196	-1802243330	6718763134240	NULL	NULL	7196	-14392	-7196	NULL	NULL	60.0	6.4051596E8	-6.0674211841988174E-5	60	-1.3258833333333333
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-60	-60.0	1969-12-31 16:00:10.618	-7196	-68838726	256630770528	NULL	NULL	7196	-14392	-7196	NULL	NULL	60.0	6.4051596E8	-6.0674211841988174E-5	60	-1.3258833333333333
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 15:59:44.823	-7196	NULL	NULL	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.3041475409836065
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 15:59:48.035	-7196	1237548317	-4613580125776	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.3041475409836065
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:03.049	-7196	-1513172815	5641108254320	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.3041475409836065
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:06.848	-7196	1415466231	-5276858109168	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.3041475409836065
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:11.842	-7196	NULL	NULL	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.3041475409836065
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:12.454	-7196	-2175533	8110387024	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.3041475409836065
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:14.192	-7196	-2114172148	7881633767744	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.3041475409836065
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 15:59:58.395	-7196	-1367753794	5098986144032	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.2831129032258064
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:01.22	-7196	1670449519	-6227435806832	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.2831129032258064
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:02.373	-7196	NULL	NULL	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.2831129032258064
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:03.85	-7196	-642836823	2396495676144	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.2831129032258064
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:09.025	-7196	-840223244	3132352253632	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.2831129032258064
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:12.388	-7196	NULL	NULL	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.2831129032258064
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-63	-63.0	1969-12-31 16:00:03.552	-7196	-1224023895	4563161080560	NULL	NULL	7196	-14392	-7196	NULL	NULL	63.0	6.4051596E8	-6.370792243408759E-5	63	-1.2627460317460317
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-63	-63.0	1969-12-31 16:00:07.375	-7196	-1711796768	6381578351104	NULL	NULL	7196	-14392	-7196	NULL	NULL	63.0	6.4051596E8	-6.370792243408759E-5	63	-1.2627460317460317
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-63	-63.0	1969-12-31 16:00:11.946	-7196	-994504916	3707514326848	NULL	NULL	7196	-14392	-7196	NULL	NULL	63.0	6.4051596E8	-6.370792243408759E-5	63	-1.2627460317460317
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-64	-64.0	1969-12-31 15:59:56.048	-7196	406535485	-1515564288080	NULL	NULL	7196	-14392	-7196	NULL	NULL	64.0	6.4051596E8	-6.471915929812072E-5	64	-1.243015625
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-64	-64.0	1969-12-31 16:00:01.785	-7196	-1639157869	6110780535632	NULL	NULL	7196	-14392	-7196	NULL	NULL	64.0	6.4051596E8	-6.471915929812072E-5	64	-1.243015625
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-64	-64.0	1969-12-31 16:00:11.912	-7196	-1615920595	6024151978160	NULL	NULL	7196	-14392	-7196	NULL	NULL	64.0	6.4051596E8	-6.471915929812072E-5	64	-1.243015625
-NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-64	-64.0	1969-12-31 16:00:12.339	-7196	1805860756	-6732248898368	NULL	NULL	7196	-14392	-7196	NULL	NULL	64.0	6.4051596E8	-6.471915929812072E-5	64	-1.243015625
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-51	-51.0	1969-12-31 15:59:43.64	-7196	-1339164819	4992406445232	NULL	NULL	7196	-14392	-7196	NULL	NULL	51.0	6.4051596E8	-5.157308006568995E-5	51	-1.559862745098039216
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 15:59:45.978	-7196	-2128720310	7935869315680	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.529865384615384615
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 15:59:47.15	-7196	628698169	-2343786774032	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.529865384615384615
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 15:59:57.86	-7196	-26309289	98081029392	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.529865384615384615
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 15:59:58.479	-7196	-1379694191	5143499944048	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.529865384615384615
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 16:00:03.963	-7196	95444104	-355815619712	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.529865384615384615
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-52	-52.0	1969-12-31 16:00:04.518	-7196	-1658319459	6182214943152	NULL	NULL	7196	-14392	-7196	NULL	NULL	52.0	6.4051596E8	-5.258431692972308E-5	52	-1.529865384615384615
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-53	-53.0	1969-12-31 15:59:48.882	-7196	-1560660031	5818140595568	NULL	NULL	7196	-14392	-7196	NULL	NULL	53.0	6.4051596E8	-5.359555379375622E-5	53	-1.501000000000000000
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-53	-53.0	1969-12-31 15:59:57.663	-7196	898472381	-3349505036368	NULL	NULL	7196	-14392	-7196	NULL	NULL	53.0	6.4051596E8	-5.359555379375622E-5	53	-1.501000000000000000
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-53	-53.0	1969-12-31 16:00:11.36	-7196	-1357789899	5061840743472	NULL	NULL	7196	-14392	-7196	NULL	NULL	53.0	6.4051596E8	-5.359555379375622E-5	53	-1.501000000000000000
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-54	-54.0	1969-12-31 15:59:53.657	-7196	1476582815	-5504700734320	NULL	NULL	7196	-14392	-7196	NULL	NULL	54.0	6.4051596E8	-5.4606790657789354E-5	54	-1.473203703703703704
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-54	-54.0	1969-12-31 16:00:05.688	-7196	1614836149	-6020109163472	NULL	NULL	7196	-14392	-7196	NULL	NULL	54.0	6.4051596E8	-5.4606790657789354E-5	54	-1.473203703703703704
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-54	-54.0	1969-12-31 16:00:06.484	-7196	1605976008	-5987078557824	NULL	NULL	7196	-14392	-7196	NULL	NULL	54.0	6.4051596E8	-5.4606790657789354E-5	54	-1.473203703703703704
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-54	-54.0	1969-12-31 16:00:11.198	-7196	1650677402	-6153725354656	NULL	NULL	7196	-14392	-7196	NULL	NULL	54.0	6.4051596E8	-5.4606790657789354E-5	54	-1.473203703703703704
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-55	-55.0	1969-12-31 15:59:43.932	-7196	1982381637	-7390318742736	NULL	NULL	7196	-14392	-7196	NULL	NULL	55.0	6.4051596E8	-5.561802752182249E-5	55	-1.446418181818181818
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-55	-55.0	1969-12-31 16:00:01.138	-7196	888532643	-3312449693104	NULL	NULL	7196	-14392	-7196	NULL	NULL	55.0	6.4051596E8	-5.561802752182249E-5	55	-1.446418181818181818
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-55	-55.0	1969-12-31 16:00:13.249	-7196	-685064281	2553919639568	NULL	NULL	7196	-14392	-7196	NULL	NULL	55.0	6.4051596E8	-5.561802752182249E-5	55	-1.446418181818181818
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-56	-56.0	1969-12-31 16:00:02.298	-7196	-1509994296	5629258735488	NULL	NULL	7196	-14392	-7196	NULL	NULL	56.0	6.4051596E8	-5.6629264385855625E-5	56	-1.420589285714285714
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-57	-57.0	1969-12-31 15:59:44.539	-7196	1839592407	-6858000493296	NULL	NULL	7196	-14392	-7196	NULL	NULL	57.0	6.4051596E8	-5.764050124988876E-5	57	-1.395666666666666667
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-57	-57.0	1969-12-31 16:00:04.659	-7196	-1579093262	5886859680736	NULL	NULL	7196	-14392	-7196	NULL	NULL	57.0	6.4051596E8	-5.764050124988876E-5	57	-1.395666666666666667
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-57	-57.0	1969-12-31 16:00:05.5	-7196	2042351711	-7613887178608	NULL	NULL	7196	-14392	-7196	NULL	NULL	57.0	6.4051596E8	-5.764050124988876E-5	57	-1.395666666666666667
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-57	-57.0	1969-12-31 16:00:12.626	-7196	248308622	-925694542816	NULL	NULL	7196	-14392	-7196	NULL	NULL	57.0	6.4051596E8	-5.764050124988876E-5	57	-1.395666666666666667
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-58	-58.0	1969-12-31 15:59:47.859	-7196	-1770443874	6600214762272	NULL	NULL	7196	-14392	-7196	NULL	NULL	58.0	6.4051596E8	-5.86517381139219E-5	58	-1.371603448275862069
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-58	-58.0	1969-12-31 15:59:55.857	-7196	-825174557	3076250748496	NULL	NULL	7196	-14392	-7196	NULL	NULL	58.0	6.4051596E8	-5.86517381139219E-5	58	-1.371603448275862069
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-58	-58.0	1969-12-31 16:00:12.065	-7196	1257970504	-4689714038912	NULL	NULL	7196	-14392	-7196	NULL	NULL	58.0	6.4051596E8	-5.86517381139219E-5	58	-1.371603448275862069
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-59	-59.0	1969-12-31 16:00:13.15	-7196	-1604890000	5983029920000	NULL	NULL	7196	-14392	-7196	NULL	NULL	59.0	6.4051596E8	-5.966297497795504E-5	59	-1.348355932203389831
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-60	-60.0	1969-12-31 15:59:45.385	-7196	1775867066	-6620432422048	NULL	NULL	7196	-14392	-7196	NULL	NULL	60.0	6.4051596E8	-6.0674211841988174E-5	60	-1.325883333333333333
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-60	-60.0	1969-12-31 15:59:52.408	-7196	1516314750	-5652821388000	NULL	NULL	7196	-14392	-7196	NULL	NULL	60.0	6.4051596E8	-6.0674211841988174E-5	60	-1.325883333333333333
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-60	-60.0	1969-12-31 15:59:55.806	-7196	-1802243330	6718763134240	NULL	NULL	7196	-14392	-7196	NULL	NULL	60.0	6.4051596E8	-6.0674211841988174E-5	60	-1.325883333333333333
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-60	-60.0	1969-12-31 16:00:10.618	-7196	-68838726	256630770528	NULL	NULL	7196	-14392	-7196	NULL	NULL	60.0	6.4051596E8	-6.0674211841988174E-5	60	-1.325883333333333333
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 15:59:44.823	-7196	NULL	NULL	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.304147540983606557
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 15:59:48.035	-7196	1237548317	-4613580125776	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.304147540983606557
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:03.049	-7196	-1513172815	5641108254320	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.304147540983606557
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:06.848	-7196	1415466231	-5276858109168	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.304147540983606557
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:11.842	-7196	NULL	NULL	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.304147540983606557
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:12.454	-7196	-2175533	8110387024	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.304147540983606557
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:14.192	-7196	-2114172148	7881633767744	NULL	NULL	7196	-14392	-7196	NULL	NULL	61.0	6.4051596E8	-6.16854487060213E-5	61	-1.304147540983606557
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 15:59:58.395	-7196	-1367753794	5098986144032	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.283112903225806452
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:01.22	-7196	1670449519	-6227435806832	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.283112903225806452
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:02.373	-7196	NULL	NULL	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.283112903225806452
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:03.85	-7196	-642836823	2396495676144	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.283112903225806452
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:09.025	-7196	-840223244	3132352253632	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.283112903225806452
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-62	-62.0	1969-12-31 16:00:12.388	-7196	NULL	NULL	NULL	NULL	7196	-14392	-7196	NULL	NULL	62.0	6.4051596E8	-6.269668557005445E-5	62	-1.283112903225806452
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-63	-63.0	1969-12-31 16:00:03.552	-7196	-1224023895	4563161080560	NULL	NULL	7196	-14392	-7196	NULL	NULL	63.0	6.4051596E8	-6.370792243408759E-5	63	-1.262746031746031746
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-63	-63.0	1969-12-31 16:00:07.375	-7196	-1711796768	6381578351104	NULL	NULL	7196	-14392	-7196	NULL	NULL	63.0	6.4051596E8	-6.370792243408759E-5	63	-1.262746031746031746
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-63	-63.0	1969-12-31 16:00:11.946	-7196	-994504916	3707514326848	NULL	NULL	7196	-14392	-7196	NULL	NULL	63.0	6.4051596E8	-6.370792243408759E-5	63	-1.262746031746031746
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-64	-64.0	1969-12-31 15:59:56.048	-7196	406535485	-1515564288080	NULL	NULL	7196	-14392	-7196	NULL	NULL	64.0	6.4051596E8	-6.471915929812072E-5	64	-1.243015625000000000
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-64	-64.0	1969-12-31 16:00:01.785	-7196	-1639157869	6110780535632	NULL	NULL	7196	-14392	-7196	NULL	NULL	64.0	6.4051596E8	-6.471915929812072E-5	64	-1.243015625000000000
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-64	-64.0	1969-12-31 16:00:11.912	-7196	-1615920595	6024151978160	NULL	NULL	7196	-14392	-7196	NULL	NULL	64.0	6.4051596E8	-6.471915929812072E-5	64	-1.243015625000000000
+NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-64	-64.0	1969-12-31 16:00:12.339	-7196	1805860756	-6732248898368	NULL	NULL	7196	-14392	-7196	NULL	NULL	64.0	6.4051596E8	-6.471915929812072E-5	64	-1.243015625000000000
 PREHOOK: query: -- TargetTypeClasses: Long, String, Double, Bool, Timestamp
 -- Functions: VarP, Var, StDev, StDevP, Max, Sum
 -- ArithmeticOps: Divide, Remainder, Subtract, Multiply
@@ -1201,11 +1199,11 @@ STAGE PLANS:
                     predicate: (((197 > UDFToInteger(ctinyint)) and (UDFToLong(cint) = cbigint)) or (cbigint = 359) or (cboolean1 < 0) or ((cstring1 like '%ss') and (cfloat <= UDFToFloat(ctinyint)))) (type: boolean)
                     Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
-                      expressions: cint (type: int), cbigint (type: bigint), cstring1 (type: string), cboolean1 (type: boolean), cfloat (type: float), cdouble (type: double), ctimestamp2 (type: timestamp), csmallint (type: smallint), cstring2 (type: string), cboolean2 (type: boolean), (UDFToDouble(cint) / UDFToDouble(cbigint)) (type: double), (UDFToDouble(cbigint) % 79.553) (type: double), (- (UDFToDouble(cint) / UDFToDouble(cbigint))) (type: double), (10.175 % UDFToDouble(cfloat)) (type: double), (- cfloat) (type: float), (cfloat - (- cfloat)) (type: float), ((cfloat - (- cfloat)) % -6432.0) (type: float), (cdouble * UDFToDouble(csmallint)) (type: double), (- cdouble) (type: double), (- cbigint) (type: bigint), (UDFToDouble(cfloat) - (UDFToDouble(cint) / UDFToDouble(cbigint))) (type: double), (- csmallint) (type: smallint), (3569 % cbigint) (type: bigint), (359.0 - cdouble) (type: double), (- csmallint) (type: smallint)
+                      expressions: cint (type: int), cbigint (type: bigint), cstring1 (type: string), cboolean1 (type: boolean), cfloat (type: float), cdouble (type: double), ctimestamp2 (type: timestamp), csmallint (type: smallint), cstring2 (type: string), cboolean2 (type: boolean), (UDFToDouble(cint) / UDFToDouble(cbigint)) (type: double), (CAST( cbigint AS decimal(19,0)) % 79.553) (type: decimal(5,3)), (- (UDFToDouble(cint) / UDFToDouble(cbigint))) (type: double), (10.175 % cfloat) (type: float), (- cfloat) (type: float), (cfloat - (- cfloat)) (type: float), ((cfloat - (- cfloat)) % -6432.0) (type: float), (cdouble * UDFToDouble(csmallint)) (type: double), (- cdouble) (type: double), (- cbigint) (type: bigint), (UDFToDouble(cfloat) - (UDFToDouble(cint) / UDFToDouble(cbigint))) (type: double), (- csmallint) (type: smallint), (3569 % cbigint) (type: bigint), (359.0 - cdouble) (type: double), (- csmallint) (type: smallint)
                       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
                       Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
-                        key expressions: _col0 (type: int), _col1 (type: bigint), _col2 (type: string), _col3 (type: boolean), _col4 (type: float), _col5 (type: double), _col6 (type: timestamp), _col7 (type: smallint), _col8 (type: string), _col9 (type: boolean), _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type: float), _col15 (type: float), _col16 (type: float), _col17 (type: double), _col18 (type: double), _col19 (type: bigint), _col20 (type: double), _col21 (type: smallint), _col22 (type: bigint), _col23 (type: double), _col24 (type: smallint)
+                        key expressions: _col0 (type: int), _col1 (type: bigint), _col2 (type: string), _col3 (type: boolean), _col4 (type: float), _col5 (type: double), _col6 (type: timestamp), _col7 (type: smallint), _col8 (type: string), _col9 (type: boolean), _col10 (type: double), _col11 (type: decimal(5,3)), _col12 (type: double), _col13 (type: float), _col14 (type: float), _col15 (type: float), _col16 (type: float), _col17 (type: double), _col18 (type: double), _col19 (type: bigint), _col20 (type: double), _col21 (type: smallint), _col22 (type: bigint), _col23 (type: double), _col24 (type: smallint)
                         sort order: +++++++++++++++++++++++++
                         Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                         TopN Hash Memory Usage: 0.1
@@ -1214,7 +1212,7 @@ STAGE PLANS:
             Execution mode: vectorized
             Reduce Operator Tree:
               Select Operator
-                expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: bigint), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: boolean), KEY.reducesinkkey4 (type: float), KEY.reducesinkkey5 (type: double), KEY.reducesinkkey6 (type: timestamp), KEY.reducesinkkey7 (type: smallint), KEY.reducesinkkey8 (type: string), KEY.reducesinkkey9 (type: boolean), KEY.reducesinkkey10 (type: double), KEY.reducesinkkey11 (type: double), KEY.reducesinkkey12 (type: double), KEY.reducesinkkey13 (type: double), KEY.reducesinkkey14 (type: float), KEY.reducesinkkey15 (type: float), KEY.reducesinkkey16 (type: float), KEY.reducesinkkey17 (type: double), KEY.reducesinkkey18 (type: double), KEY.reducesinkkey19 (type: bigint), KEY.reducesinkkey20 (type: double), KEY.reducesinkkey21 (type: smallint), KEY.reducesinkkey22 (type: bigint), KEY.reducesinkkey23 (type: double), KEY.reducesinkkey21 (type: smallint)
+                expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: bigint), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: boolean), KEY.reducesinkkey4 (type: float), KEY.reducesinkkey5 (type: double), KEY.reducesinkkey6 (type: timestamp), KEY.reducesinkkey7 (type: smallint), KEY.reducesinkkey8 (type: string), KEY.reducesinkkey9 (type: boolean), KEY.reducesinkkey10 (type: double), KEY.reducesinkkey11 (type: decimal(5,3)), KEY.reducesinkkey12 (type: double), KEY.reducesinkkey13 (type: float), KEY.reducesinkkey14 (type: float), KEY.reducesinkkey15 (type: float), KEY.reducesinkkey16 (type: float), KEY.reducesinkkey17 (type: double), KEY.reducesinkkey18 (type: double), KEY.reducesinkkey19 (type: bigint), KEY.reducesinkkey20 (type: double), KEY.reducesinkkey21 (type: smallint), KEY.reducesinkkey22 (type: bigint), KEY.reducesinkkey23 (type: double), KEY.reducesinkkey21 (type: smallint)
                 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
                 Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                 Limit
@@ -1308,8 +1306,8 @@ LIMIT 25
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
--462839731	988888	ss	false	-51.0	NULL	NULL	NULL	Lml5J2QBU77	false	-468.04059812638036	44.210000000033915	468.04059812638036	10.175	51.0	-102.0	-102.0	NULL	NULL	-988888	417.04059812638036	NULL	3569	NULL	NULL
--635141101	-89010	ss	false	-51.0	NULL	NULL	NULL	rVWAj4N1MCg8Scyp7wj2C	true	7135.6151106617235	-69.74600000000305	-7135.6151106617235	10.175	51.0	-102.0	-102.0	NULL	NULL	89010	-7186.6151106617235	NULL	3569	NULL	NULL
+-462839731	988888	ss	false	-51.0	NULL	NULL	NULL	Lml5J2QBU77	false	-468.04059812638036	44.210	468.04059812638036	10.175	51.0	-102.0	-102.0	NULL	NULL	-988888	417.04059812638036	NULL	3569	NULL	NULL
+-635141101	-89010	ss	false	-51.0	NULL	NULL	NULL	rVWAj4N1MCg8Scyp7wj2C	true	7135.6151106617235	-69.746	-7135.6151106617235	10.175	51.0	-102.0	-102.0	NULL	NULL	89010	-7186.6151106617235	NULL	3569	NULL	NULL
 WARNING: Comparing a bigint and a double may result in a loss of precision.
 PREHOOK: query: -- TargetTypeClasses: String, Bool, Double, Long, Timestamp
 -- Functions: Sum, Max, Avg, Var, StDevP, VarP
@@ -1406,14 +1404,14 @@ STAGE PLANS:
                   alias: alltypesorc
                   Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
-                    predicate: (((UDFToDouble(csmallint) > -26.28) and (cstring2 like 'ss')) or ((cdouble <= UDFToDouble(cbigint)) and (cstring1 >= 'ss') and (UDFToDouble(cint) <> cdouble)) or (UDFToInteger(ctinyint) = -89010) or ((UDFToFloat(cbigint) <= cfloat) and (-26.28 <= UDFToDouble(csmallint)))) (type: boolean)
+                    predicate: (((CAST( csmallint AS decimal(7,2)) > -26.28) and (cstring2 like 'ss')) or ((cdouble <= UDFToDouble(cbigint)) and (cstring1 >= 'ss') and (UDFToDouble(cint) <> cdouble)) or (UDFToInteger(ctinyint) = -89010) or ((UDFToFloat(cbigint) <= cfloat) and (-26.28 <= CAST( csmallint AS decimal(7,2))))) (type: boolean)
                     Statistics: Num rows: 10922 Data size: 335301 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
-                      expressions: cint (type: int), cstring1 (type: string), cboolean2 (type: boolean), ctimestamp2 (type: timestamp), cdouble (type: double), cfloat (type: float), cbigint (type: bigint), csmallint (type: smallint), cboolean1 (type: boolean), (cint + UDFToInteger(csmallint)) (type: int), (cbigint - UDFToLong(ctinyint)) (type: bigint), (- cbigint) (type: bigint), (- cfloat) (type: float), ((cbigint - UDFToLong(ctinyint)) + cbigint) (type: bigint), (cdouble / cdouble) (type: double), (- cdouble) (type: double), (UDFToLong((cint + UDFToInteger(csmallint))) * (- cbigint)) (type: bigint), ((- cdouble) + UDFToDouble(cbigint)) (type: double), (-1.389 / UDFToDouble(ctinyint)) (type: double), (UDFToDouble(cbigint) % cdouble) (type: double), (- csmallint) (type: smallint), (UDFToInteger(csmallint) + (cint + UDFToInteger(csmallint))) (type: int)
+                      expressions: cint (type: int), cstring1 (type: string), cboolean2 (type: boolean), ctimestamp2 (type: timestamp), cdouble (type: double), cfloat (type: float), cbigint (type: bigint), csmallint (type: smallint), cboolean1 (type: boolean), (cint + UDFToInteger(csmallint)) (type: int), (cbigint - UDFToLong(ctinyint)) (type: bigint), (- cbigint) (type: bigint), (- cfloat) (type: float), ((cbigint - UDFToLong(ctinyint)) + cbigint) (type: bigint), (cdouble / cdouble) (type: double), (- cdouble) (type: double), (UDFToLong((cint + UDFToInteger(csmallint))) * (- cbigint)) (type: bigint), ((- cdouble) + UDFToDouble(cbigint)) (type: double), (-1.389 / CAST( ctinyint AS decimal(3,0))) (type: decimal(19,18)), (UDFToDouble(cbigint) % cdouble) (type: double), (- csmallint) (type: smallint), (UDFToInteger(csmallint) + (cint + UDFToInteger(csmallint))) (type: int)
                       outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21
                       Statistics: Num rows: 10922 Data size: 335301 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
-                        key expressions: _col8 (type: boolean), _col1 (type: string), _col3 (type: timestamp), _col5 (type: float), _col6 (type: bigint), _col1 (type: string), _col4 (type: double), _col0 (type: int), _col7 (type: smallint), _col4 (type: double), _col9 (type: int), _col10 (type: bigint), _col11 (type: bigint), _col12 (type: float), _col13 (type: bigint), _col14 (type: double), _col15 (type: double), _col16 (type: bigint), _col17 (type: double), _col18 (type: double), _col19 (type: double), _col20 (type: smallint), _col21 (type: int)
+                        key expressions: _col8 (type: boolean), _col1 (type: string), _col3 (type: timestamp), _col5 (type: float), _col6 (type: bigint), _col1 (type: string), _col4 (type: double), _col0 (type: int), _col7 (type: smallint), _col4 (type: double), _col9 (type: int), _col10 (type: bigint), _col11 (type: bigint), _col12 (type: float), _col13 (type: bigint), _col14 (type: double), _col15 (type: double), _col16 (type: bigint), _col17 (type: double), _col18 (type: decimal(19,18)), _col19 (type: double), _col20 (type: smallint), _col21 (type: int)
                         sort order: +++++++++++++++++++++++
                         Statistics: Num rows: 10922 Data size: 335301 Basic stats: COMPLETE Column stats: NONE
                         TopN Hash Memory Usage: 0.1
@@ -1423,7 +1421,7 @@ STAGE PLANS:
             Execution mode: vectorized
             Reduce Operator Tree:
               Select Operator
-                expressions: KEY.reducesinkkey7 (type: int), KEY.reducesinkkey1 (type: string), VALUE._col0 (type: boolean), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey6 (type: double), KEY.reducesinkkey3 (type: float), KEY.reducesinkkey4 (type: bigint), KEY.reducesinkkey8 (type: smallint), KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey10 (type: int), KEY.reducesinkkey11 (type: bigint), KEY.reducesinkkey12 (type: bigint), KEY.reducesinkkey13 (type: float), KEY.reducesinkkey14 (type: bigint), KEY.reducesinkkey15 (type: double), KEY.reducesinkkey16 (type: double), KEY.reducesinkkey17 (type: bigint), KEY.reducesinkkey18 (type: double), KEY.reducesinkkey19 (type: double), KEY.reducesinkkey20 (type: double), KEY.reducesinkkey21 (type: smallint), KEY.reducesinkkey22 (type: int)
+                expressions: KEY.reducesinkkey7 (type: int), KEY.reducesinkkey1 (type: string), VALUE._col0 (type: boolean), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey6 (type: double), KEY.reducesinkkey3 (type: float), KEY.reducesinkkey4 (type: bigint), KEY.reducesinkkey8 (type: smallint), KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey10 (type: int), KEY.reducesinkkey11 (type: bigint), KEY.reducesinkkey12 (type: bigint), KEY.reducesinkkey13 (type: float), KEY.reducesinkkey14 (type: bigint), KEY.reducesinkkey15 (type: double), KEY.reducesinkkey16 (type: double), KEY.reducesinkkey17 (type: bigint), KEY.reducesinkkey18 (type: double), KEY.reducesinkkey19 (type: decimal(19,18)), KEY.reducesinkkey20 (type: double), KEY.reducesinkkey21 (type: smallint), KEY.reducesinkkey22 (type: int)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21
                 Statistics: Num rows: 10922 Data size: 335301 Basic stats: COMPLETE Column stats: NONE
                 Limit
@@ -1516,82 +1514,81 @@ LIMIT 75
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
-NULL	NULL	NULL	1969-12-31 15:59:58.456	15601.0	-44.0	-1416000760	15601	NULL	NULL	-1416000716	1416000760	44.0	-2832001476	1.0	-15601.0	NULL	-1.416016361E9	0.03156818181818182	-7197.0	-15601	NULL
-NULL	NULL	NULL	1969-12-31 15:59:58.456	15601.0	-48.0	-1683400285	15601	NULL	NULL	-1683400237	1683400285	48.0	-3366800522	1.0	-15601.0	NULL	-1.683415886E9	0.0289375	-5582.0	-15601	NULL
-NULL	NULL	NULL	1969-12-31 15:59:58.456	15601.0	-57.0	-1057361026	15601	NULL	NULL	-1057360969	1057361026	57.0	-2114721995	1.0	-15601.0	NULL	-1.057376627E9	0.02436842105263158	-3251.0	-15601	NULL
+NULL	NULL	NULL	1969-12-31 15:59:58.456	15601.0	-44.0	-1416000760	15601	NULL	NULL	-1416000716	1416000760	44.0	-2832001476	1.0	-15601.0	NULL	-1.416016361E9	0.031568181818181818	-7197.0	-15601	NULL
+NULL	NULL	NULL	1969-12-31 15:59:58.456	15601.0	-48.0	-1683400285	15601	NULL	NULL	-1683400237	1683400285	48.0	-3366800522	1.0	-15601.0	NULL	-1.683415886E9	0.028937500000000000	-5582.0	-15601	NULL
+NULL	NULL	NULL	1969-12-31 15:59:58.456	15601.0	-57.0	-1057361026	15601	NULL	NULL	-1057360969	1057361026	57.0	-2114721995	1.0	-15601.0	NULL	-1.057376627E9	0.024368421052631579	-3251.0	-15601	NULL
 NULL	NULL	NULL	1969-12-31 15:59:58.456	15601.0	-62.0	-1726415169	15601	NULL	NULL	-1726415107	1726415169	62.0	-3452830276	1.0	-15601.0	NULL	-1.72643077E9	0.022403225806451613	-8509.0	-15601	NULL
-NULL	NULL	NULL	1969-12-31 15:59:58.456	15601.0	-63.0	-1167054574	15601	NULL	NULL	-1167054511	1167054574	63.0	-2334109085	1.0	-15601.0	NULL	-1.167070175E9	0.02204761904761905	-6168.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-44.0	-1551649760	15601	NULL	NULL	-1551649716	1551649760	44.0	-3103299476	1.0	-15601.0	NULL	-1.551665361E9	0.03156818181818182	-5502.0	-15601	NULL
+NULL	NULL	NULL	1969-12-31 15:59:58.456	15601.0	-63.0	-1167054574	15601	NULL	NULL	-1167054511	1167054574	63.0	-2334109085	1.0	-15601.0	NULL	-1.167070175E9	0.022047619047619048	-6168.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-44.0	-1551649760	15601	NULL	NULL	-1551649716	1551649760	44.0	-3103299476	1.0	-15601.0	NULL	-1.551665361E9	0.031568181818181818	-5502.0	-15601	NULL
 NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-45.0	-1022657523	15601	NULL	NULL	-1022657478	1022657523	45.0	-2045315001	1.0	-15601.0	NULL	-1.022673124E9	0.030866666666666667	-11973.0	-15601	NULL
 NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-45.0	-1291025659	15601	NULL	NULL	-1291025614	1291025659	45.0	-2582051273	1.0	-15601.0	NULL	-1.29104126E9	0.030866666666666667	-11707.0	-15601	NULL
 NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-45.0	-831227593	15601	NULL	NULL	-831227548	831227593	45.0	-1662455141	1.0	-15601.0	NULL	-8.31243194E8	0.030866666666666667	-6313.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-46.0	-208932264	15601	NULL	NULL	-208932218	208932264	46.0	-417864482	1.0	-15601.0	NULL	-2.08947865E8	0.030195652173913044	-3672.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-46.0	-468932050	15601	NULL	NULL	-468932004	468932050	46.0	-937864054	1.0	-15601.0	NULL	-4.68947651E8	0.030195652173913044	-12793.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-47.0	-436916225	15601	NULL	NULL	-436916178	436916225	47.0	-873832403	1.0	-15601.0	NULL	-4.36931826E8	0.029553191489361703	-10220.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-47.0	-493471535	15601	NULL	NULL	-493471488	493471535	47.0	-986943023	1.0	-15601.0	NULL	-4.93487136E8	0.029553191489361703	-11905.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-48.0	-1228417392	15601	NULL	NULL	-1228417344	1228417392	48.0	-2456834736	1.0	-15601.0	NULL	-1.228432993E9	0.0289375	-10253.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-48.0	-1294837001	15601	NULL	NULL	-1294836953	1294837001	48.0	-2589673954	1.0	-15601.0	NULL	-1.294852602E9	0.0289375	-804.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-48.0	-1427685796	15601	NULL	NULL	-1427685748	1427685796	48.0	-2855371544	1.0	-15601.0	NULL	-1.427701397E9	0.0289375	-7084.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-48.0	-803222928	15601	NULL	NULL	-803222880	803222928	48.0	-1606445808	1.0	-15601.0	NULL	-8.03238529E8	0.0289375	-5443.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-49.0	-1841324115	15601	NULL	NULL	-1841324066	1841324115	49.0	-3682648181	1.0	-15601.0	NULL	-1.841339716E9	0.028346938775510203	-489.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-49.0	-230127703	15601	NULL	NULL	-230127654	230127703	49.0	-460255357	1.0	-15601.0	NULL	-2.30143304E8	0.028346938775510203	-12953.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-50.0	-596103241	15601	NULL	NULL	-596103191	596103241	50.0	-1192206432	1.0	-15601.0	NULL	-5.96118842E8	0.02778	-4632.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-51.0	-546830045	15601	NULL	NULL	-546829994	546830045	51.0	-1093660039	1.0	-15601.0	NULL	-5.46845646E8	0.02723529411764706	-14995.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-52.0	-2097289702	15601	NULL	NULL	-2097289650	2097289702	52.0	-4194579352	1.0	-15601.0	NULL	-2.097305303E9	0.02671153846153846	-469.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-52.0	-886068046	15601	NULL	NULL	-886067994	886068046	52.0	-1772136040	1.0	-15601.0	NULL	-8.86083647E8	0.02671153846153846	-9251.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-54.0	-1114169807	15601	NULL	NULL	-1114169753	1114169807	54.0	-2228339560	1.0	-15601.0	NULL	-1.114185408E9	0.025722222222222223	-8791.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-54.0	-1754189160	15601	NULL	NULL	-1754189106	1754189160	54.0	-3508378266	1.0	-15601.0	NULL	-1.754204761E9	0.025722222222222223	-12720.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-54.0	-989710558	15601	NULL	NULL	-989710504	989710558	54.0	-1979421062	1.0	-15601.0	NULL	-9.89726159E8	0.025722222222222223	-14320.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-56.0	-1105322173	15601	NULL	NULL	-1105322117	1105322173	56.0	-2210644290	1.0	-15601.0	NULL	-1.105337774E9	0.02480357142857143	-6924.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-56.0	-1466363382	15601	NULL	NULL	-1466363326	1466363382	56.0	-2932726708	1.0	-15601.0	NULL	-1.466378983E9	0.02480357142857143	-9791.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-56.0	-865054294	15601	NULL	NULL	-865054238	865054294	56.0	-1730108532	1.0	-15601.0	NULL	-8.65069895E8	0.02480357142857143	-10046.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-57.0	-1698345590	15601	NULL	NULL	-1698345533	1698345590	57.0	-3396691123	1.0	-15601.0	NULL	-1.698361191E9	0.02436842105263158	-5129.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-57.0	-2123576095	15601	NULL	NULL	-2123576038	2123576095	57.0	-4247152133	1.0	-15601.0	NULL	-2.123591696E9	0.02436842105263158	-14778.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-57.0	-304247740	15601	NULL	NULL	-304247683	304247740	57.0	-608495423	1.0	-15601.0	NULL	-3.04263341E8	0.02436842105263158	-12639.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-57.0	-365505703	15601	NULL	NULL	-365505646	365505703	57.0	-731011349	1.0	-15601.0	NULL	-3.65521304E8	0.02436842105263158	-5475.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-59.0	-2021724111	15601	NULL	NULL	-2021724052	2021724111	59.0	-4043448163	1.0	-15601.0	NULL	-2.021739712E9	0.02354237288135593	-6122.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-60.0	-1016256928	15601	NULL	NULL	-1016256868	1016256928	60.0	-2032513796	1.0	-15601.0	NULL	-1.016272529E9	0.02315	-7788.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-60.0	-1743144280	15601	NULL	NULL	-1743144220	1743144280	60.0	-3486288500	1.0	-15601.0	NULL	-1.743159881E9	0.02315	-13348.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-60.0	-519753851	15601	NULL	NULL	-519753791	519753851	60.0	-1039507642	1.0	-15601.0	NULL	-5.19769452E8	0.02315	-6536.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-60.0	-5953872	15601	NULL	NULL	-5953812	5953872	60.0	-11907684	1.0	-15601.0	NULL	-5969473.0	0.02315	-9891.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-61.0	-982179838	15601	NULL	NULL	-982179777	982179838	61.0	-1964359615	1.0	-15601.0	NULL	-9.82195439E8	0.02277049180327869	-3282.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-63.0	-1574729892	15601	NULL	NULL	-1574729829	1574729892	63.0	-3149459721	1.0	-15601.0	NULL	-1.574745493E9	0.02204761904761905	-11755.0	-15601	NULL
-NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-63.0	-1996001975	15601	NULL	NULL	-1996001912	1996001975	63.0	-3992003887	1.0	-15601.0	NULL	-1.996017576E9	0.02204761904761905	-10035.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-44.0	-1447719201	15601	NULL	NULL	-1447719157	1447719201	44.0	-2895438358	1.0	-15601.0	NULL	-1.447734802E9	0.03156818181818182	-8805.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-47.0	-1828371599	15601	NULL	NULL	-1828371552	1828371599	47.0	-3656743151	1.0	-15601.0	NULL	-1.8283872E9	0.029553191489361703	-12404.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-48.0	-1465907371	15601	NULL	NULL	-1465907323	1465907371	48.0	-2931814694	1.0	-15601.0	NULL	-1.465922972E9	0.0289375	-6209.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-48.0	-1666377780	15601	NULL	NULL	-1666377732	1666377780	48.0	-3332755512	1.0	-15601.0	NULL	-1.666393381E9	0.0289375	-3768.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-48.0	-652336471	15601	NULL	NULL	-652336423	652336471	48.0	-1304672894	1.0	-15601.0	NULL	-6.52352072E8	0.0289375	-11858.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-197652849	15601	NULL	NULL	-197652800	197652849	49.0	-395305649	1.0	-15601.0	NULL	-1.9766845E8	0.028346938775510203	-3780.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-211726367	15601	NULL	NULL	-211726318	211726367	49.0	-423452685	1.0	-15601.0	NULL	-2.11741968E8	0.028346938775510203	-5196.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-57200424	15601	NULL	NULL	-57200375	57200424	49.0	-114400799	1.0	-15601.0	NULL	-5.7216025E7	0.028346938775510203	-7158.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-668597606	15601	NULL	NULL	-668597557	668597606	49.0	-1337195163	1.0	-15601.0	NULL	-6.68613207E8	0.028346938775510203	-1150.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-990904667	15601	NULL	NULL	-990904618	990904667	49.0	-1981809285	1.0	-15601.0	NULL	-9.90920268E8	0.028346938775510203	-7152.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-50.0	-458110015	15601	NULL	NULL	-458109965	458110015	50.0	-916219980	1.0	-15601.0	NULL	-4.58125616E8	0.02778	-2251.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-52.0	-2074134645	15601	NULL	NULL	-2074134593	2074134645	52.0	-4148269238	1.0	-15601.0	NULL	-2.074150246E9	0.02671153846153846	-12897.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-54.0	-1795674990	15601	NULL	NULL	-1795674936	1795674990	54.0	-3591349926	1.0	-15601.0	NULL	-1.795690591E9	0.025722222222222223	-15491.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-54.0	-1984659810	15601	NULL	NULL	-1984659756	1984659810	54.0	-3969319566	1.0	-15601.0	NULL	-1.984675411E9	0.025722222222222223	-9797.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-54.0	-641670659	15601	NULL	NULL	-641670605	641670659	54.0	-1283341264	1.0	-15601.0	NULL	-6.4168626E8	0.025722222222222223	-1529.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-55.0	-1062767051	15601	NULL	NULL	-1062766996	1062767051	55.0	-2125534047	1.0	-15601.0	NULL	-1.062782652E9	0.025254545454545453	-11330.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-55.0	-1338667765	15601	NULL	NULL	-1338667710	1338667765	55.0	-2677335475	1.0	-15601.0	NULL	-1.338683366E9	0.025254545454545453	-8359.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-55.0	-1483320156	15601	NULL	NULL	-1483320101	1483320156	55.0	-2966640257	1.0	-15601.0	NULL	-1.483335757E9	0.025254545454545453	-8278.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-56.0	-1683701844	15601	NULL	NULL	-1683701788	1683701844	56.0	-3367403632	1.0	-15601.0	NULL	-1.683717445E9	0.02480357142857143	-10722.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-56.0	-971846497	15601	NULL	NULL	-971846441	971846497	56.0	-1943692938	1.0	-15601.0	NULL	-9.71862098E8	0.02480357142857143	-13404.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-57.0	-585350546	15601	NULL	NULL	-585350489	585350546	57.0	-1170701035	1.0	-15601.0	NULL	-5.85366147E8	0.02436842105263158	-1026.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-46.0	-208932264	15601	NULL	NULL	-208932218	208932264	46.0	-417864482	1.0	-15601.0	NULL	-2.08947865E8	0.030195652173913043	-3672.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-46.0	-468932050	15601	NULL	NULL	-468932004	468932050	46.0	-937864054	1.0	-15601.0	NULL	-4.68947651E8	0.030195652173913043	-12793.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-47.0	-436916225	15601	NULL	NULL	-436916178	436916225	47.0	-873832403	1.0	-15601.0	NULL	-4.36931826E8	0.029553191489361702	-10220.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-47.0	-493471535	15601	NULL	NULL	-493471488	493471535	47.0	-986943023	1.0	-15601.0	NULL	-4.93487136E8	0.029553191489361702	-11905.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-48.0	-1228417392	15601	NULL	NULL	-1228417344	1228417392	48.0	-2456834736	1.0	-15601.0	NULL	-1.228432993E9	0.028937500000000000	-10253.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-48.0	-1294837001	15601	NULL	NULL	-1294836953	1294837001	48.0	-2589673954	1.0	-15601.0	NULL	-1.294852602E9	0.028937500000000000	-804.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-48.0	-1427685796	15601	NULL	NULL	-1427685748	1427685796	48.0	-2855371544	1.0	-15601.0	NULL	-1.427701397E9	0.028937500000000000	-7084.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-48.0	-803222928	15601	NULL	NULL	-803222880	803222928	48.0	-1606445808	1.0	-15601.0	NULL	-8.03238529E8	0.028937500000000000	-5443.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-49.0	-1841324115	15601	NULL	NULL	-1841324066	1841324115	49.0	-3682648181	1.0	-15601.0	NULL	-1.841339716E9	0.028346938775510204	-489.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-49.0	-230127703	15601	NULL	NULL	-230127654	230127703	49.0	-460255357	1.0	-15601.0	NULL	-2.30143304E8	0.028346938775510204	-12953.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-50.0	-596103241	15601	NULL	NULL	-596103191	596103241	50.0	-1192206432	1.0	-15601.0	NULL	-5.96118842E8	0.027780000000000000	-4632.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-51.0	-546830045	15601	NULL	NULL	-546829994	546830045	51.0	-1093660039	1.0	-15601.0	NULL	-5.46845646E8	0.027235294117647059	-14995.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-52.0	-2097289702	15601	NULL	NULL	-2097289650	2097289702	52.0	-4194579352	1.0	-15601.0	NULL	-2.097305303E9	0.026711538461538462	-469.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-52.0	-886068046	15601	NULL	NULL	-886067994	886068046	52.0	-1772136040	1.0	-15601.0	NULL	-8.86083647E8	0.026711538461538462	-9251.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-54.0	-1114169807	15601	NULL	NULL	-1114169753	1114169807	54.0	-2228339560	1.0	-15601.0	NULL	-1.114185408E9	0.025722222222222222	-8791.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-54.0	-1754189160	15601	NULL	NULL	-1754189106	1754189160	54.0	-3508378266	1.0	-15601.0	NULL	-1.754204761E9	0.025722222222222222	-12720.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-54.0	-989710558	15601	NULL	NULL	-989710504	989710558	54.0	-1979421062	1.0	-15601.0	NULL	-9.89726159E8	0.025722222222222222	-14320.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-56.0	-1105322173	15601	NULL	NULL	-1105322117	1105322173	56.0	-2210644290	1.0	-15601.0	NULL	-1.105337774E9	0.024803571428571429	-6924.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-56.0	-1466363382	15601	NULL	NULL	-1466363326	1466363382	56.0	-2932726708	1.0	-15601.0	NULL	-1.466378983E9	0.024803571428571429	-9791.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-56.0	-865054294	15601	NULL	NULL	-865054238	865054294	56.0	-1730108532	1.0	-15601.0	NULL	-8.65069895E8	0.024803571428571429	-10046.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-57.0	-1698345590	15601	NULL	NULL	-1698345533	1698345590	57.0	-3396691123	1.0	-15601.0	NULL	-1.698361191E9	0.024368421052631579	-5129.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-57.0	-2123576095	15601	NULL	NULL	-2123576038	2123576095	57.0	-4247152133	1.0	-15601.0	NULL	-2.123591696E9	0.024368421052631579	-14778.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-57.0	-304247740	15601	NULL	NULL	-304247683	304247740	57.0	-608495423	1.0	-15601.0	NULL	-3.04263341E8	0.024368421052631579	-12639.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-57.0	-365505703	15601	NULL	NULL	-365505646	365505703	57.0	-731011349	1.0	-15601.0	NULL	-3.65521304E8	0.024368421052631579	-5475.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-59.0	-2021724111	15601	NULL	NULL	-2021724052	2021724111	59.0	-4043448163	1.0	-15601.0	NULL	-2.021739712E9	0.023542372881355932	-6122.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-60.0	-1016256928	15601	NULL	NULL	-1016256868	1016256928	60.0	-2032513796	1.0	-15601.0	NULL	-1.016272529E9	0.023150000000000000	-7788.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-60.0	-1743144280	15601	NULL	NULL	-1743144220	1743144280	60.0	-3486288500	1.0	-15601.0	NULL	-1.743159881E9	0.023150000000000000	-13348.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-60.0	-519753851	15601	NULL	NULL	-519753791	519753851	60.0	-1039507642	1.0	-15601.0	NULL	-5.19769452E8	0.023150000000000000	-6536.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-60.0	-5953872	15601	NULL	NULL	-5953812	5953872	60.0	-11907684	1.0	-15601.0	NULL	-5969473.0	0.023150000000000000	-9891.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-61.0	-982179838	15601	NULL	NULL	-982179777	982179838	61.0	-1964359615	1.0	-15601.0	NULL	-9.82195439E8	0.022770491803278689	-3282.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-63.0	-1574729892	15601	NULL	NULL	-1574729829	1574729892	63.0	-3149459721	1.0	-15601.0	NULL	-1.574745493E9	0.022047619047619048	-11755.0	-15601	NULL
+NULL	NULL	false	1969-12-31 15:59:58.456	15601.0	-63.0	-1996001975	15601	NULL	NULL	-1996001912	1996001975	63.0	-3992003887	1.0	-15601.0	NULL	-1.996017576E9	0.022047619047619048	-10035.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-44.0	-1447719201	15601	NULL	NULL	-1447719157	1447719201	44.0	-2895438358	1.0	-15601.0	NULL	-1.447734802E9	0.031568181818181818	-8805.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-47.0	-1828371599	15601	NULL	NULL	-1828371552	1828371599	47.0	-3656743151	1.0	-15601.0	NULL	-1.8283872E9	0.029553191489361702	-12404.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-48.0	-1465907371	15601	NULL	NULL	-1465907323	1465907371	48.0	-2931814694	1.0	-15601.0	NULL	-1.465922972E9	0.028937500000000000	-6209.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-48.0	-1666377780	15601	NULL	NULL	-1666377732	1666377780	48.0	-3332755512	1.0	-15601.0	NULL	-1.666393381E9	0.028937500000000000	-3768.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-48.0	-652336471	15601	NULL	NULL	-652336423	652336471	48.0	-1304672894	1.0	-15601.0	NULL	-6.52352072E8	0.028937500000000000	-11858.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-197652849	15601	NULL	NULL	-197652800	197652849	49.0	-395305649	1.0	-15601.0	NULL	-1.9766845E8	0.028346938775510204	-3780.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-211726367	15601	NULL	NULL	-211726318	211726367	49.0	-423452685	1.0	-15601.0	NULL	-2.11741968E8	0.028346938775510204	-5196.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-57200424	15601	NULL	NULL	-57200375	57200424	49.0	-114400799	1.0	-15601.0	NULL	-5.7216025E7	0.028346938775510204	-7158.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-668597606	15601	NULL	NULL	-668597557	668597606	49.0	-1337195163	1.0	-15601.0	NULL	-6.68613207E8	0.028346938775510204	-1150.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-49.0	-990904667	15601	NULL	NULL	-990904618	990904667	49.0	-1981809285	1.0	-15601.0	NULL	-9.90920268E8	0.028346938775510204	-7152.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-50.0	-458110015	15601	NULL	NULL	-458109965	458110015	50.0	-916219980	1.0	-15601.0	NULL	-4.58125616E8	0.027780000000000000	-2251.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-52.0	-2074134645	15601	NULL	NULL	-2074134593	2074134645	52.0	-4148269238	1.0	-15601.0	NULL	-2.074150246E9	0.026711538461538462	-12897.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-54.0	-1795674990	15601	NULL	NULL	-1795674936	1795674990	54.0	-3591349926	1.0	-15601.0	NULL	-1.795690591E9	0.025722222222222222	-15491.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-54.0	-1984659810	15601	NULL	NULL	-1984659756	1984659810	54.0	-3969319566	1.0	-15601.0	NULL	-1.984675411E9	0.025722222222222222	-9797.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-54.0	-641670659	15601	NULL	NULL	-641670605	641670659	54.0	-1283341264	1.0	-15601.0	NULL	-6.4168626E8	0.025722222222222222	-1529.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-55.0	-1062767051	15601	NULL	NULL	-1062766996	1062767051	55.0	-2125534047	1.0	-15601.0	NULL	-1.062782652E9	0.025254545454545455	-11330.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-55.0	-1338667765	15601	NULL	NULL	-1338667710	1338667765	55.0	-2677335475	1.0	-15601.0	NULL	-1.338683366E9	0.025254545454545455	-8359.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-55.0	-1483320156	15601	NULL	NULL	-1483320101	1483320156	55.0	-2966640257	1.0	-15601.0	NULL	-1.483335757E9	0.025254545454545455	-8278.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-56.0	-1683701844	15601	NULL	NULL	-1683701788	1683701844	56.0	-3367403632	1.0	-15601.0	NULL	-1.683717445E9	0.024803571428571429	-10722.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-56.0	-971846497	15601	NULL	NULL	-971846441	971846497	56.0	-1943692938	1.0	-15601.0	NULL	-9.71862098E8	0.024803571428571429	-13404.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-57.0	-585350546	15601	NULL	NULL	-585350489	585350546	57.0	-1170701035	1.0	-15601.0	NULL	-5.85366147E8	0.024368421052631579	-1026.0	-15601	NULL
 NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-58.0	-1072335429	15601	NULL	NULL	-1072335371	1072335429	58.0	-2144670800	1.0	-15601.0	NULL	-1.07235103E9	0.023948275862068966	-694.0	-15601	NULL
 NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-58.0	-1560616588	15601	NULL	NULL	-1560616530	1560616588	58.0	-3121233118	1.0	-15601.0	NULL	-1.560632189E9	0.023948275862068966	-1755.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-59.0	-1315413812	15601	NULL	NULL	-1315413753	1315413812	59.0	-2630827565	1.0	-15601.0	NULL	-1.315429413E9	0.02354237288135593	-15497.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-59.0	-133287350	15601	NULL	NULL	-133287291	133287350	59.0	-266574641	1.0	-15601.0	NULL	-1.33302951E8	0.02354237288135593	-8007.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-60.0	-2041965187	15601	NULL	NULL	-2041965127	2041965187	60.0	-4083930314	1.0	-15601.0	NULL	-2.041980788E9	0.02315	-12701.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-60.0	-903925845	15601	NULL	NULL	-903925785	903925845	60.0	-1807851630	1.0	-15601.0	NULL	-9.03941446E8	0.02315	-3905.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-61.0	-1022679553	15601	NULL	NULL	-1022679492	1022679553	61.0	-2045359045	1.0	-15601.0	NULL	-1.022695154E9	0.02277049180327869	-2801.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-61.0	-854893578	15601	NULL	NULL	-854893517	854893578	61.0	-1709787095	1.0	-15601.0	NULL	-8.54909179E8	0.02277049180327869	-5581.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-59.0	-1315413812	15601	NULL	NULL	-1315413753	1315413812	59.0	-2630827565	1.0	-15601.0	NULL	-1.315429413E9	0.023542372881355932	-15497.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-59.0	-133287350	15601	NULL	NULL	-133287291	133287350	59.0	-266574641	1.0	-15601.0	NULL	-1.33302951E8	0.023542372881355932	-8007.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-60.0	-2041965187	15601	NULL	NULL	-2041965127	2041965187	60.0	-4083930314	1.0	-15601.0	NULL	-2.041980788E9	0.023150000000000000	-12701.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-60.0	-903925845	15601	NULL	NULL	-903925785	903925845	60.0	-1807851630	1.0	-15601.0	NULL	-9.03941446E8	0.023150000000000000	-3905.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-61.0	-1022679553	15601	NULL	NULL	-1022679492	1022679553	61.0	-2045359045	1.0	-15601.0	NULL	-1.022695154E9	0.022770491803278689	-2801.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-61.0	-854893578	15601	NULL	NULL	-854893517	854893578	61.0	-1709787095	1.0	-15601.0	NULL	-8.54909179E8	0.022770491803278689	-5581.0	-15601	NULL
 NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-62.0	-1592016120	15601	NULL	NULL	-1592016058	1592016120	62.0	-3184032178	1.0	-15601.0	NULL	-1.592031721E9	0.022403225806451613	-12075.0	-15601	NULL
 NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-62.0	667693308	15601	NULL	NULL	667693370	-667693308	62.0	1335386678	1.0	-15601.0	NULL	6.67677707E8	0.022403225806451613	1710.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-63.0	-200542601	15601	NULL	NULL	-200542538	200542601	63.0	-401085139	1.0	-15601.0	NULL	-2.00558202E8	0.02204761904761905	-7347.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-63.0	-721244708	15601	NULL	NULL	-721244645	721244708	63.0	-1442489353	1.0	-15601.0	NULL	-7.21260309E8	0.02204761904761905	-10478.0	-15601	NULL
-NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-64.0	-1809291815	15601	NULL	NULL	-1809291751	1809291815	64.0	-3618583566	1.0	-15601.0	NULL	-1.809307416E9	0.021703125	-12643.0	-15601	NULL
-WARNING: Comparing a bigint and a double may result in a loss of precision.
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-63.0	-200542601	15601	NULL	NULL	-200542538	200542601	63.0	-401085139	1.0	-15601.0	NULL	-2.00558202E8	0.022047619047619048	-7347.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-63.0	-721244708	15601	NULL	NULL	-721244645	721244708	63.0	-1442489353	1.0	-15601.0	NULL	-7.21260309E8	0.022047619047619048	-10478.0	-15601	NULL
+NULL	NULL	true	1969-12-31 15:59:58.456	15601.0	-64.0	-1809291815	15601	NULL	NULL	-1809291751	1809291815	64.0	-3618583566	1.0	-15601.0	NULL	-1.809307416E9	0.021703125000000000	-12643.0	-15601	NULL
 PREHOOK: query: -- TargetTypeClasses: Long, String, Double, Timestamp
 -- Functions: Avg, Min, StDevP, Sum, Var
 -- ArithmeticOps: Divide, Subtract, Multiply, Remainder
@@ -1673,7 +1670,7 @@ STAGE PLANS:
                   alias: alltypesorc
                   Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
-                    predicate: (((-1.389 >= UDFToDouble(cint)) and (csmallint < UDFToShort(ctinyint)) and (-6432 > UDFToInteger(csmallint))) or ((cdouble >= UDFToDouble(cfloat)) and (cstring2 <= 'a')) or ((cstring1 like 'ss%') and (10.175 > UDFToDouble(cbigint)))) (type: boolean)
+                    predicate: (((-1.389 >= CAST( cint AS decimal(13,3))) and (csmallint < UDFToShort(ctinyint)) and (-6432 > UDFToInteger(csmallint))) or ((cdouble >= UDFToDouble(cfloat)) and (cstring2 <= 'a')) or ((cstring1 like 'ss%') and (10.175 > CAST( cbigint AS decimal(22,3))))) (type: boolean)
                     Statistics: Num rows: 3868 Data size: 118746 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: ctimestamp1 (type: timestamp), cstring2 (type: string), cdouble (type: double), cfloat (type: float), cbigint (type: bigint), csmallint (type: smallint), (UDFToDouble(cbigint) / 3569.0) (type: double), (-257 - UDFToInteger(csmallint)) (type: int), (-6432.0 * cfloat) (type: float), (- cdouble) (type: double), (cdouble * 10.175) (type: double), (UDFToDouble((-6432.0 * cfloat)) / UDFToDouble(cfloat)) (type: double), (- cfloat) (type: float), (cint % UDFToInteger(csmallint)) (type: int), (- cdouble) (type: double), (cdouble * (- cdouble)) (type: double)
@@ -1710,7 +1707,6 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-WARNING: Comparing a bigint and a double may result in a loss of precision.
 PREHOOK: query: SELECT   ctimestamp1,
          cstring2,
          cdouble,
@@ -1910,11 +1906,11 @@ STAGE PLANS:
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4
                 Statistics: Num rows: 1251 Data size: 38405 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
-                  expressions: _col0 (type: smallint), (UDFToInteger(_col0) % -75) (type: int), _col1 (type: double), (-1.389 / UDFToDouble(_col0)) (type: double), _col2 (type: bigint), (UDFToDouble((UDFToInteger(_col0) % -75)) / UDFToDouble(_col2)) (type: double), (- (UDFToInteger(_col0) % -75)) (type: int), _col3 (type: double), (- (- (UDFToInteger(_col0) % -75))) (type: int), _col4 (type: bigint), (_col4 - -89010) (type: bigint)
+                  expressions: _col0 (type: smallint), (UDFToInteger(_col0) % -75) (type: int), _col1 (type: double), (-1.389 / CAST( _col0 AS decimal(5,0))) (type: decimal(19,18)), _col2 (type: bigint), (UDFToDouble((UDFToInteger(_col0) % -75)) / UDFToDouble(_col2)) (type: double), (- (UDFToInteger(_col0) % -75)) (type: int), _col3 (type: double), (- (- (UDFToInteger(_col0) % -75))) (type: int), _col4 (type: bigint), (_col4 - -89010) (type: bigint)
                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
                   Statistics: Num rows: 1251 Data size: 38405 Basic stats: COMPLETE Column stats: NONE
                   Reduce Output Operator
-                    key expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: double), _col3 (type: double), _col4 (type: bigint), _col5 (type: double), _col6 (type: int), _col7 (type: double), _col8 (type: int), _col9 (type: bigint), _col10 (type: bigint)
+                    key expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: double), _col3 (type: decimal(19,18)), _col4 (type: bigint), _col5 (type: double), _col6 (type: int), _col7 (type: double), _col8 (type: int), _col9 (type: bigint), _col10 (type: bigint)
                     sort order: +++++++++++
                     Statistics: Num rows: 1251 Data size: 38405 Basic stats: COMPLETE Column stats: NONE
                     TopN Hash Memory Usage: 0.1
@@ -1922,7 +1918,7 @@ STAGE PLANS:
             Execution mode: vectorized
             Reduce Operator Tree:
               Select Operator
-                expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: double), KEY.reducesinkkey3 (type: double), KEY.reducesinkkey4 (type: bigint), KEY.reducesinkkey5 (type: double), KEY.reducesinkkey6 (type: int), KEY.reducesinkkey7 (type: double), KEY.reducesinkkey8 (type: int), KEY.reducesinkkey9 (type: bigint), KEY.reducesinkkey10 (type: bigint)
+                expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: double), KEY.reducesinkkey3 (type: decimal(19,18)), KEY.reducesinkkey4 (type: bigint), KEY.reducesinkkey5 (type: double), KEY.reducesinkkey6 (type: int), KEY.reducesinkkey7 (type: double), KEY.reducesinkkey8 (type: int), KEY.reducesinkkey9 (type: bigint), KEY.reducesinkkey10 (type: bigint)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
                 Statistics: Num rows: 1251 Data size: 38405 Basic stats: COMPLETE Column stats: NONE
                 Limit
@@ -1986,27 +1982,26 @@ LIMIT 20
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
--100	-25	0.0	0.01389	NULL	NULL	25	0.0	-25	1	89011
--113	-38	0.0	0.01229203539823009	NULL	NULL	38	0.0	-38	1	89011
+-100	-25	0.0	0.013890000000000000	NULL	NULL	25	0.0	-25	1	89011
+-113	-38	0.0	0.012292035398230088	NULL	NULL	38	0.0	-38	1	89011
 -118	-43	0.0	0.011771186440677966	NULL	NULL	43	0.0	-43	1	89011
 -165	-15	0.0	0.008418181818181818	NULL	NULL	15	0.0	-15	1	89011
 -168	-18	0.0	0.008267857142857143	NULL	NULL	18	0.0	-18	1	89011
--171	-21	0.0	0.00812280701754386	NULL	NULL	21	0.0	-21	1	89011
+-171	-21	0.0	0.008122807017543860	NULL	NULL	21	0.0	-21	1	89011
 -180	-30	0.0	0.007716666666666667	NULL	NULL	30	0.0	-30	1	89011
 -203	-53	0.0	0.006842364532019704	NULL	NULL	53	0.0	-53	1	89011
 -217	-67	0.0	0.006400921658986175	NULL	NULL	67	0.0	-67	1	89011
--220	-70	0.0	0.006313636363636363	NULL	NULL	70	0.0	-70	1	89011
+-220	-70	0.0	0.006313636363636364	NULL	NULL	70	0.0	-70	1	89011
 -257	-32	0.0	0.005404669260700389	NULL	NULL	32	0.0	-32	2	89012
--29	-29	0.0	0.04789655172413793	NULL	NULL	29	0.0	-29	1	89011
--42	-42	0.0	0.03307142857142857	NULL	NULL	42	0.0	-42	1	89011
--49	-49	0.0	0.028346938775510203	NULL	NULL	49	0.0	-49	1	89011
+-29	-29	0.0	0.047896551724137931	NULL	NULL	29	0.0	-29	1	89011
+-42	-42	0.0	0.033071428571428571	NULL	NULL	42	0.0	-42	1	89011
+-49	-49	0.0	0.028346938775510204	NULL	NULL	49	0.0	-49	1	89011
 -62	-62	0.0	0.022403225806451613	NULL	NULL	62	0.0	-62	1	89011
--75	0	0.0	0.018520000000000002	NULL	NULL	0	107.55555555555556	0	3	89013
--77	-2	0.0	0.01803896103896104	NULL	NULL	2	0.0	-2	1	89011
+-75	0	0.0	0.018520000000000000	NULL	NULL	0	107.55555555555556	0	3	89013
+-77	-2	0.0	0.018038961038961039	NULL	NULL	2	0.0	-2	1	89011
 -84	-9	0.0	0.016535714285714286	NULL	NULL	9	0.0	-9	1	89011
 -89	-14	0.0	0.015606741573033708	NULL	NULL	14	0.0	-14	1	89011
--95	-20	0.0	0.014621052631578948	NULL	NULL	20	0.0	-20	1	89011
-WARNING: Comparing a bigint and a double may result in a loss of precision.
+-95	-20	0.0	0.014621052631578947	NULL	NULL	20	0.0	-20	1	89011
 WARNING: Comparing a bigint and a double may result in a loss of precision.
 PREHOOK: query: -- TargetTypeClasses: Long, Double, Timestamp
 -- Functions: Var, Count, Sum, VarP, StDevP
@@ -2090,7 +2085,7 @@ STAGE PLANS:
                   alias: alltypesorc
                   Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
-                    predicate: ((cdouble > 2563.58) and (((cbigint >= UDFToLong(cint)) and (UDFToInteger(csmallint) < cint) and (UDFToDouble(cfloat) < -5638.15)) or (2563.58 = UDFToDouble(ctinyint)) or ((cdouble <= UDFToDouble(cbigint)) and (-5638.15 > UDFToDouble(cbigint))))) (type: boolean)
+                    predicate: ((cdouble > 2563.58) and (((cbigint >= UDFToLong(cint)) and (UDFToInteger(csmallint) < cint) and (cfloat < -5638.15)) or (2563.58 = CAST( ctinyint AS decimal(6,2))) or ((cdouble <= UDFToDouble(cbigint)) and (-5638.15 > CAST( cbigint AS decimal(21,2)))))) (type: boolean)
                     Statistics: Num rows: 2654 Data size: 81476 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: cdouble (type: double), cfloat (type: float)
@@ -2148,7 +2143,6 @@ STAGE PLANS:
         ListSink
 
 WARNING: Comparing a bigint and a double may result in a loss of precision.
-WARNING: Comparing a bigint and a double may result in a loss of precision.
 PREHOOK: query: SELECT   cdouble,
          VAR_SAMP(cdouble),
          (2563.58 * VAR_SAMP(cdouble)),
@@ -2373,11 +2367,11 @@ STAGE PLANS:
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14
                 Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
-                  expressions: _col0 (type: timestamp), _col1 (type: string), _col2 (type: double), (_col2 * 10.175) (type: double), (- _col2) (type: double), _col3 (type: double), (- _col2) (type: double), (-26.28 - _col2) (type: double), _col4 (type: bigint), (- _col4) (type: bigint), ((-26.28 - _col2) * (- _col2)) (type: double), _col5 (type: tinyint), (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4))) (type: double), (- (_col2 * 10.175)) (type: double), _col6 (type: double), (_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) (type: double), (- (- _col2)) (type: double), (UDFToDouble((- _col4)) / _col2) (type: double), _col7 (type: double), (10.175 / _col3) (type: double), _col8 (type: double), _col9 (type: double), ((_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) - (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) (type: double), (- (- (_col2 * 10.175))) (type: double), _col10 (type: double), (((_col6 + (((-26.28 - _col2) * (-
  _col2)) * UDFToDouble((- _col4)))) - (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) * 10.175) (type: double), (10.175 % (10.175 / _col3)) (type: double), (- _col5) (type: tinyint), _col11 (type: double), _col12 (type: double), (- ((-26.28 - _col2) * (- _col2))) (type: double), ((- _col2) % _col10) (type: double), (-26.28 / UDFToDouble((- _col5))) (type: double), _col13 (type: double), _col14 (type: bigint), ((_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) / _col7) (type: double), (- (- _col4)) (type: bigint), _col4 (type: bigint), ((_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) % -26.28) (type: double)
+                  expressions: _col0 (type: timestamp), _col1 (type: string), _col2 (type: double), (_col2 * 10.175) (type: double), (- _col2) (type: double), _col3 (type: double), (- _col2) (type: double), (-26.28 - _col2) (type: double), _col4 (type: bigint), (- _col4) (type: bigint), ((-26.28 - _col2) * (- _col2)) (type: double), _col5 (type: tinyint), (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4))) (type: double), (- (_col2 * 10.175)) (type: double), _col6 (type: double), (_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) (type: double), (- (- _col2)) (type: double), (UDFToDouble((- _col4)) / _col2) (type: double), _col7 (type: double), (10.175 / _col3) (type: double), _col8 (type: double), _col9 (type: double), ((_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) - (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) (type: double), (- (- (_col2 * 10.175))) (type: double), _col10 (type: double), (((_col6 + (((-26.28 - _col2) * (-
  _col2)) * UDFToDouble((- _col4)))) - (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) * 10.175) (type: double), (10.175 % (10.175 / _col3)) (type: double), (- _col5) (type

<TRUNCATED>

Mime
View raw message