hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject [12/57] [abbrv] hive git commit: HIVE-11090: ordering issues with windows unit test runs (Matt McCline via Gunther Hagleitner)
Date Tue, 30 Jun 2015 01:21:05 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/63deec40/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out b/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out
index 3cf898f..9729a8f 100644
--- a/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out
+++ b/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out
@@ -1,5 +1,7 @@
 WARNING: Comparing a bigint and a double may result in a loss of precision.
-PREHOOK: query: -- If you look at ql/src/test/org/apache/hadoop/hive/ql/exec/vector/util/OrcFileGenerator.java
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- If you look at ql/src/test/org/apache/hadoop/hive/ql/exec/vector/util/OrcFileGenerator.java
 -- which is the data generation class you'll see that those values are specified in the
 -- initializeFixedPointValues for each data type. When I created the queries I usedthose values
 -- where I needed scalar values to ensure that when the queries executed their predicates would be
@@ -65,7 +67,9 @@ WHERE  ((762 = cbigint)
                     AND ((79.553 != cint)
                          AND (cboolean2 != cboolean1)))))
 PREHOOK: type: QUERY
-POSTHOOK: query: -- If you look at ql/src/test/org/apache/hadoop/hive/ql/exec/vector/util/OrcFileGenerator.java
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- If you look at ql/src/test/org/apache/hadoop/hive/ql/exec/vector/util/OrcFileGenerator.java
 -- which is the data generation class you'll see that those values are specified in the
 -- initializeFixedPointValues for each data type. When I created the queries I usedthose values
 -- where I needed scalar values to ensure that when the queries executed their predicates would be
@@ -851,19 +855,19 @@ EXPLAIN SELECT cint,
        ctimestamp1,
        csmallint,
        cbigint,
-       (-3728 * cbigint),
-       (-(cint)),
-       (-863.257 - cint),
-       (-(csmallint)),
-       (csmallint - (-(csmallint))),
-       ((csmallint - (-(csmallint))) + (-(csmallint))),
-       (cint / cint),
-       ((-863.257 - cint) - -26.28),
-       (-(cfloat)),
-       (cdouble * -89010),
-       (ctinyint / 988888),
-       (-(ctinyint)),
-       (79.553 / ctinyint)
+       (-3728 * cbigint) as c1,
+       (-(cint)) as c2,
+       (-863.257 - cint) as c3,
+       (-(csmallint)) as c4,
+       (csmallint - (-(csmallint))) as c5,
+       ((csmallint - (-(csmallint))) + (-(csmallint))) as c6,
+       (cint / cint) as c7,
+       ((-863.257 - cint) - -26.28) as c8,
+       (-(cfloat)) as c9,
+       (cdouble * -89010) as c10,
+       (ctinyint / 988888) as c11,
+       (-(ctinyint)) as c12,
+       (79.553 / ctinyint) as c13
 FROM   alltypesorc
 WHERE  (((cstring1 RLIKE 'a.*')
          AND (cstring2 LIKE '%ss%'))
@@ -874,7 +878,7 @@ WHERE  (((cstring1 RLIKE 'a.*')
             AND (cfloat >= cint))
            OR ((cint < cbigint)
                AND (ctinyint > cbigint)))
-ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint
+ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13
 LIMIT 50
 PREHOOK: type: QUERY
 POSTHOOK: query: -- TargetTypeClasses: Timestamp, String, Long, Double, Bool
@@ -892,19 +896,19 @@ EXPLAIN SELECT cint,
        ctimestamp1,
        csmallint,
        cbigint,
-       (-3728 * cbigint),
-       (-(cint)),
-       (-863.257 - cint),
-       (-(csmallint)),
-       (csmallint - (-(csmallint))),
-       ((csmallint - (-(csmallint))) + (-(csmallint))),
-       (cint / cint),
-       ((-863.257 - cint) - -26.28),
-       (-(cfloat)),
-       (cdouble * -89010),
-       (ctinyint / 988888),
-       (-(ctinyint)),
-       (79.553 / ctinyint)
+       (-3728 * cbigint) as c1,
+       (-(cint)) as c2,
+       (-863.257 - cint) as c3,
+       (-(csmallint)) as c4,
+       (csmallint - (-(csmallint))) as c5,
+       ((csmallint - (-(csmallint))) + (-(csmallint))) as c6,
+       (cint / cint) as c7,
+       ((-863.257 - cint) - -26.28) as c8,
+       (-(cfloat)) as c9,
+       (cdouble * -89010) as c10,
+       (ctinyint / 988888) as c11,
+       (-(ctinyint)) as c12,
+       (79.553 / ctinyint) as c13
 FROM   alltypesorc
 WHERE  (((cstring1 RLIKE 'a.*')
          AND (cstring2 LIKE '%ss%'))
@@ -915,7 +919,7 @@ WHERE  (((cstring1 RLIKE 'a.*')
             AND (cfloat >= cint))
            OR ((cint < cbigint)
                AND (ctinyint > cbigint)))
-ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint
+ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13
 LIMIT 50
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
@@ -942,15 +946,14 @@ STAGE PLANS:
                       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: 2128105 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)
-                        sort order: ++++++++++
+                        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)
+                        sort order: +++++++++++++++++++++++
                         Statistics: Num rows: 9898 Data size: 2128105 Basic stats: COMPLETE Column stats: NONE
-                        value expressions: _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)
             Execution mode: vectorized
         Reducer 2 
             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), VALUE._col0 (type: bigint), VALUE._col1 (type: int), VALUE._col2 (type: double), VALUE._col3 (type: smallint), VALUE._col4 (type: smallint), VALUE._col5 (type: smallint), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: float), VALUE._col9 (type: double), VALUE._col10 (type: double), VALUE._col11 (type: tinyint), VALUE._col12 (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: 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)
                 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: 2128105 Basic stats: COMPLETE Column stats: NONE
                 Limit
@@ -981,19 +984,19 @@ PREHOOK: query: SELECT cint,
        ctimestamp1,
        csmallint,
        cbigint,
-       (-3728 * cbigint),
-       (-(cint)),
-       (-863.257 - cint),
-       (-(csmallint)),
-       (csmallint - (-(csmallint))),
-       ((csmallint - (-(csmallint))) + (-(csmallint))),
-       (cint / cint),
-       ((-863.257 - cint) - -26.28),
-       (-(cfloat)),
-       (cdouble * -89010),
-       (ctinyint / 988888),
-       (-(ctinyint)),
-       (79.553 / ctinyint)
+       (-3728 * cbigint) as c1,
+       (-(cint)) as c2,
+       (-863.257 - cint) as c3,
+       (-(csmallint)) as c4,
+       (csmallint - (-(csmallint))) as c5,
+       ((csmallint - (-(csmallint))) + (-(csmallint))) as c6,
+       (cint / cint) as c7,
+       ((-863.257 - cint) - -26.28) as c8,
+       (-(cfloat)) as c9,
+       (cdouble * -89010) as c10,
+       (ctinyint / 988888) as c11,
+       (-(ctinyint)) as c12,
+       (79.553 / ctinyint) as c13
 FROM   alltypesorc
 WHERE  (((cstring1 RLIKE 'a.*')
          AND (cstring2 LIKE '%ss%'))
@@ -1004,7 +1007,7 @@ WHERE  (((cstring1 RLIKE 'a.*')
             AND (cfloat >= cint))
            OR ((cint < cbigint)
                AND (ctinyint > cbigint)))
-ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint
+ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13
 LIMIT 50
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
@@ -1019,19 +1022,19 @@ POSTHOOK: query: SELECT cint,
        ctimestamp1,
        csmallint,
        cbigint,
-       (-3728 * cbigint),
-       (-(cint)),
-       (-863.257 - cint),
-       (-(csmallint)),
-       (csmallint - (-(csmallint))),
-       ((csmallint - (-(csmallint))) + (-(csmallint))),
-       (cint / cint),
-       ((-863.257 - cint) - -26.28),
-       (-(cfloat)),
-       (cdouble * -89010),
-       (ctinyint / 988888),
-       (-(ctinyint)),
-       (79.553 / ctinyint)
+       (-3728 * cbigint) as c1,
+       (-(cint)) as c2,
+       (-863.257 - cint) as c3,
+       (-(csmallint)) as c4,
+       (csmallint - (-(csmallint))) as c5,
+       ((csmallint - (-(csmallint))) + (-(csmallint))) as c6,
+       (cint / cint) as c7,
+       ((-863.257 - cint) - -26.28) as c8,
+       (-(cfloat)) as c9,
+       (cdouble * -89010) as c10,
+       (ctinyint / 988888) as c11,
+       (-(ctinyint)) as c12,
+       (79.553 / ctinyint) as c13
 FROM   alltypesorc
 WHERE  (((cstring1 RLIKE 'a.*')
          AND (cstring2 LIKE '%ss%'))
@@ -1042,24 +1045,41 @@ WHERE  (((cstring1 RLIKE 'a.*')
             AND (cfloat >= cint))
            OR ((cint < cbigint)
                AND (ctinyint > cbigint)))
-ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint
+ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13
 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	-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	-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	-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	-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
@@ -1067,36 +1087,19 @@ NULL	-7196.0	1969-12-31 15:59:58.174	NULL	false	-61	-61.0	1969-12-31 16:00:06.84
 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	-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	-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	-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	-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	-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	-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	-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	-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	-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	-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	-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
 PREHOOK: query: -- TargetTypeClasses: Long, String, Double, Bool, Timestamp
 -- Functions: VarP, Var, StDev, StDevP, Max, Sum
 -- ArithmeticOps: Divide, Remainder, Subtract, Multiply
@@ -1112,21 +1115,21 @@ EXPLAIN SELECT cint,
        csmallint,
        cstring2,
        cboolean2,
-       (cint / cbigint),
-       (cbigint % 79.553),
-       (-((cint / cbigint))),
-       (10.175 % cfloat),
-       (-(cfloat)),
-       (cfloat - (-(cfloat))),
-       ((cfloat - (-(cfloat))) % -6432),
-       (cdouble * csmallint),
-       (-(cdouble)),
-       (-(cbigint)),
-       (cfloat - (cint / cbigint)),
-       (-(csmallint)),
-       (3569 % cbigint),
-       (359 - cdouble),
-       (-(csmallint))
+       (cint / cbigint) as c1,
+       (cbigint % 79.553) as c2,
+       (-((cint / cbigint))) as c3,
+       (10.175 % cfloat) as c4,
+       (-(cfloat)) as c5,
+       (cfloat - (-(cfloat))) as c6,
+       ((cfloat - (-(cfloat))) % -6432) as c7,
+       (cdouble * csmallint) as c8,
+       (-(cdouble)) as c9,
+       (-(cbigint)) as c10,
+       (cfloat - (cint / cbigint)) as c11,
+       (-(csmallint)) as c12,
+       (3569 % cbigint) as c13,
+       (359 - cdouble) as c14,
+       (-(csmallint)) as c15
 FROM   alltypesorc
 WHERE  (((197 > ctinyint)
          AND (cint = cbigint))
@@ -1134,7 +1137,7 @@ WHERE  (((197 > ctinyint)
         OR (cboolean1 < 0)
            OR ((cstring1 LIKE '%ss')
                AND (cfloat <= ctinyint)))
-ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2
+ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15
 LIMIT 25
 PREHOOK: type: QUERY
 POSTHOOK: query: -- TargetTypeClasses: Long, String, Double, Bool, Timestamp
@@ -1152,21 +1155,21 @@ EXPLAIN SELECT cint,
        csmallint,
        cstring2,
        cboolean2,
-       (cint / cbigint),
-       (cbigint % 79.553),
-       (-((cint / cbigint))),
-       (10.175 % cfloat),
-       (-(cfloat)),
-       (cfloat - (-(cfloat))),
-       ((cfloat - (-(cfloat))) % -6432),
-       (cdouble * csmallint),
-       (-(cdouble)),
-       (-(cbigint)),
-       (cfloat - (cint / cbigint)),
-       (-(csmallint)),
-       (3569 % cbigint),
-       (359 - cdouble),
-       (-(csmallint))
+       (cint / cbigint) as c1,
+       (cbigint % 79.553) as c2,
+       (-((cint / cbigint))) as c3,
+       (10.175 % cfloat) as c4,
+       (-(cfloat)) as c5,
+       (cfloat - (-(cfloat))) as c6,
+       ((cfloat - (-(cfloat))) % -6432) as c7,
+       (cdouble * csmallint) as c8,
+       (-(cdouble)) as c9,
+       (-(cbigint)) as c10,
+       (cfloat - (cint / cbigint)) as c11,
+       (-(csmallint)) as c12,
+       (3569 % cbigint) as c13,
+       (359 - cdouble) as c14,
+       (-(csmallint)) as c15
 FROM   alltypesorc
 WHERE  (((197 > ctinyint)
          AND (cint = cbigint))
@@ -1174,7 +1177,7 @@ WHERE  (((197 > ctinyint)
         OR (cboolean1 < 0)
            OR ((cstring1 LIKE '%ss')
                AND (cfloat <= ctinyint)))
-ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2
+ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15
 LIMIT 25
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
@@ -1197,19 +1200,18 @@ STAGE PLANS:
                     predicate: (((197.0 > UDFToDouble(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: 2641964 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
-                      expressions: cint (type: int), cbigint (type: bigint), (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), cstring1 (type: string), (UDFToDouble(cfloat) - (UDFToDouble(cint) / UDFToDouble(cbigint))) (type: double), (- csmallint) (type: smallint), (3569 % cbigint) (type: bigint), (359.0 - cdouble) (type: double), cboolean1 (type: boolean), cfloat (type: float), cdouble (type: double), ctimestamp2 (type: timestamp), csmallint (type: smallint), cstring2 (type: string), cboolean2 (type: boolean)
-                      outputColumnNames: _col0, _col1, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col2, _col20, _col21, _col22, _col23, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+                      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)
+                      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: 2641964 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)
-                        sort order: ++++++++++
+                        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)
+                        sort order: +++++++++++++++++++++++++
                         Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE
-                        value expressions: _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)
             Execution mode: vectorized
         Reducer 2 
             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), VALUE._col0 (type: double), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: double), VALUE._col4 (type: float), VALUE._col5 (type: float), VALUE._col6 (type: float), VALUE._col7 (type: double), VALUE._col8 (type: double), VALUE._col9 (type: bigint), VALUE._col10 (type: double), VALUE._col11 (type: smallint), VALUE._col12 (type: bigint), VALUE._col13 (type: double), VALUE._col11 (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: 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)
                 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: 2641964 Basic stats: COMPLETE Column stats: NONE
                 Limit
@@ -1240,21 +1242,21 @@ PREHOOK: query: SELECT cint,
        csmallint,
        cstring2,
        cboolean2,
-       (cint / cbigint),
-       (cbigint % 79.553),
-       (-((cint / cbigint))),
-       (10.175 % cfloat),
-       (-(cfloat)),
-       (cfloat - (-(cfloat))),
-       ((cfloat - (-(cfloat))) % -6432),
-       (cdouble * csmallint),
-       (-(cdouble)),
-       (-(cbigint)),
-       (cfloat - (cint / cbigint)),
-       (-(csmallint)),
-       (3569 % cbigint),
-       (359 - cdouble),
-       (-(csmallint))
+       (cint / cbigint) as c1,
+       (cbigint % 79.553) as c2,
+       (-((cint / cbigint))) as c3,
+       (10.175 % cfloat) as c4,
+       (-(cfloat)) as c5,
+       (cfloat - (-(cfloat))) as c6,
+       ((cfloat - (-(cfloat))) % -6432) as c7,
+       (cdouble * csmallint) as c8,
+       (-(cdouble)) as c9,
+       (-(cbigint)) as c10,
+       (cfloat - (cint / cbigint)) as c11,
+       (-(csmallint)) as c12,
+       (3569 % cbigint) as c13,
+       (359 - cdouble) as c14,
+       (-(csmallint)) as c15
 FROM   alltypesorc
 WHERE  (((197 > ctinyint)
          AND (cint = cbigint))
@@ -1262,7 +1264,7 @@ WHERE  (((197 > ctinyint)
         OR (cboolean1 < 0)
            OR ((cstring1 LIKE '%ss')
                AND (cfloat <= ctinyint)))
-ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2
+ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15
 LIMIT 25
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
@@ -1277,21 +1279,21 @@ POSTHOOK: query: SELECT cint,
        csmallint,
        cstring2,
        cboolean2,
-       (cint / cbigint),
-       (cbigint % 79.553),
-       (-((cint / cbigint))),
-       (10.175 % cfloat),
-       (-(cfloat)),
-       (cfloat - (-(cfloat))),
-       ((cfloat - (-(cfloat))) % -6432),
-       (cdouble * csmallint),
-       (-(cdouble)),
-       (-(cbigint)),
-       (cfloat - (cint / cbigint)),
-       (-(csmallint)),
-       (3569 % cbigint),
-       (359 - cdouble),
-       (-(csmallint))
+       (cint / cbigint) as c1,
+       (cbigint % 79.553) as c2,
+       (-((cint / cbigint))) as c3,
+       (10.175 % cfloat) as c4,
+       (-(cfloat)) as c5,
+       (cfloat - (-(cfloat))) as c6,
+       ((cfloat - (-(cfloat))) % -6432) as c7,
+       (cdouble * csmallint) as c8,
+       (-(cdouble)) as c9,
+       (-(cbigint)) as c10,
+       (cfloat - (cint / cbigint)) as c11,
+       (-(csmallint)) as c12,
+       (3569 % cbigint) as c13,
+       (359 - cdouble) as c14,
+       (-(csmallint)) as c15
 FROM   alltypesorc
 WHERE  (((197 > ctinyint)
          AND (cint = cbigint))
@@ -1299,13 +1301,13 @@ WHERE  (((197 > ctinyint)
         OR (cboolean1 < 0)
            OR ((cstring1 LIKE '%ss')
                AND (cfloat <= ctinyint)))
-ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2
+ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15
 LIMIT 25
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
--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.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
 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
@@ -1321,19 +1323,19 @@ EXPLAIN SELECT   cint,
          cbigint,
          csmallint,
          cboolean1,
-         (cint + csmallint),
-         (cbigint - ctinyint),
-         (-(cbigint)),
-         (-(cfloat)),
-         ((cbigint - ctinyint) + cbigint),
-         (cdouble / cdouble),
-         (-(cdouble)),
-         ((cint + csmallint) * (-(cbigint))),
-         ((-(cdouble)) + cbigint),
-         (-1.389 / ctinyint),
-         (cbigint % cdouble),
-         (-(csmallint)),
-         (csmallint + (cint + csmallint))
+         (cint + csmallint) as c1,
+         (cbigint - ctinyint) as c2,
+         (-(cbigint)) as c3,
+         (-(cfloat)) as c4,
+         ((cbigint - ctinyint) + cbigint) as c5,
+         (cdouble / cdouble) as c6,
+         (-(cdouble)) as c7,
+         ((cint + csmallint) * (-(cbigint))) as c8,
+         ((-(cdouble)) + cbigint) as c9,
+         (-1.389 / ctinyint) as c10,
+         (cbigint % cdouble) as c11,
+         (-(csmallint)) as c12,
+         (csmallint + (cint + csmallint)) as c13
 FROM     alltypesorc
 WHERE    (((csmallint > -26.28)
            AND (cstring2 LIKE 'ss'))
@@ -1343,7 +1345,7 @@ WHERE    (((csmallint > -26.28)
           OR (ctinyint = -89010)
              OR ((cbigint <= cfloat)
                  AND (-26.28 <= csmallint)))
-ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble
+ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13
 LIMIT 75
 PREHOOK: type: QUERY
 POSTHOOK: query: -- TargetTypeClasses: String, Bool, Double, Long, Timestamp
@@ -1360,19 +1362,19 @@ EXPLAIN SELECT   cint,
          cbigint,
          csmallint,
          cboolean1,
-         (cint + csmallint),
-         (cbigint - ctinyint),
-         (-(cbigint)),
-         (-(cfloat)),
-         ((cbigint - ctinyint) + cbigint),
-         (cdouble / cdouble),
-         (-(cdouble)),
-         ((cint + csmallint) * (-(cbigint))),
-         ((-(cdouble)) + cbigint),
-         (-1.389 / ctinyint),
-         (cbigint % cdouble),
-         (-(csmallint)),
-         (csmallint + (cint + csmallint))
+         (cint + csmallint) as c1,
+         (cbigint - ctinyint) as c2,
+         (-(cbigint)) as c3,
+         (-(cfloat)) as c4,
+         ((cbigint - ctinyint) + cbigint) as c5,
+         (cdouble / cdouble) as c6,
+         (-(cdouble)) as c7,
+         ((cint + csmallint) * (-(cbigint))) as c8,
+         ((-(cdouble)) + cbigint) as c9,
+         (-1.389 / ctinyint) as c10,
+         (cbigint % cdouble) as c11,
+         (-(csmallint)) as c12,
+         (csmallint + (cint + csmallint)) as c13
 FROM     alltypesorc
 WHERE    (((csmallint > -26.28)
            AND (cstring2 LIKE 'ss'))
@@ -1382,7 +1384,7 @@ WHERE    (((csmallint > -26.28)
           OR (ctinyint = -89010)
              OR ((cbigint <= cfloat)
                  AND (-26.28 <= csmallint)))
-ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble
+ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13
 LIMIT 75
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
@@ -1409,15 +1411,15 @@ STAGE PLANS:
                       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: 2348269 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)
-                        sort order: ++++++++++
+                        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)
+                        sort order: +++++++++++++++++++++++
                         Statistics: Num rows: 10922 Data size: 2348269 Basic stats: COMPLETE Column stats: NONE
-                        value expressions: _col2 (type: boolean), _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)
+                        value expressions: _col2 (type: boolean)
             Execution mode: vectorized
         Reducer 2 
             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), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: bigint), VALUE._col4 (type: float), VALUE._col5 (type: bigint), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: bigint), VALUE._col9 (type: double), VALUE._col10 (type: double), VALUE._col11 (type: double), VALUE._col12 (type: smallint), VALUE._col13 (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: double), 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: 2348269 Basic stats: COMPLETE Column stats: NONE
                 Limit
@@ -1448,19 +1450,19 @@ PREHOOK: query: SELECT   cint,
          cbigint,
          csmallint,
          cboolean1,
-         (cint + csmallint),
-         (cbigint - ctinyint),
-         (-(cbigint)),
-         (-(cfloat)),
-         ((cbigint - ctinyint) + cbigint),
-         (cdouble / cdouble),
-         (-(cdouble)),
-         ((cint + csmallint) * (-(cbigint))),
-         ((-(cdouble)) + cbigint),
-         (-1.389 / ctinyint),
-         (cbigint % cdouble),
-         (-(csmallint)),
-         (csmallint + (cint + csmallint))
+         (cint + csmallint) as c1,
+         (cbigint - ctinyint) as c2,
+         (-(cbigint)) as c3,
+         (-(cfloat)) as c4,
+         ((cbigint - ctinyint) + cbigint) as c5,
+         (cdouble / cdouble) as c6,
+         (-(cdouble)) as c7,
+         ((cint + csmallint) * (-(cbigint))) as c8,
+         ((-(cdouble)) + cbigint) as c9,
+         (-1.389 / ctinyint) as c10,
+         (cbigint % cdouble) as c11,
+         (-(csmallint)) as c12,
+         (csmallint + (cint + csmallint)) as c13
 FROM     alltypesorc
 WHERE    (((csmallint > -26.28)
            AND (cstring2 LIKE 'ss'))
@@ -1470,7 +1472,7 @@ WHERE    (((csmallint > -26.28)
           OR (ctinyint = -89010)
              OR ((cbigint <= cfloat)
                  AND (-26.28 <= csmallint)))
-ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble
+ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13
 LIMIT 75
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
@@ -1484,19 +1486,19 @@ POSTHOOK: query: SELECT   cint,
          cbigint,
          csmallint,
          cboolean1,
-         (cint + csmallint),
-         (cbigint - ctinyint),
-         (-(cbigint)),
-         (-(cfloat)),
-         ((cbigint - ctinyint) + cbigint),
-         (cdouble / cdouble),
-         (-(cdouble)),
-         ((cint + csmallint) * (-(cbigint))),
-         ((-(cdouble)) + cbigint),
-         (-1.389 / ctinyint),
-         (cbigint % cdouble),
-         (-(csmallint)),
-         (csmallint + (cint + csmallint))
+         (cint + csmallint) as c1,
+         (cbigint - ctinyint) as c2,
+         (-(cbigint)) as c3,
+         (-(cfloat)) as c4,
+         ((cbigint - ctinyint) + cbigint) as c5,
+         (cdouble / cdouble) as c6,
+         (-(cdouble)) as c7,
+         ((cint + csmallint) * (-(cbigint))) as c8,
+         ((-(cdouble)) + cbigint) as c9,
+         (-1.389 / ctinyint) as c10,
+         (cbigint % cdouble) as c11,
+         (-(csmallint)) as c12,
+         (csmallint + (cint + csmallint)) as c13
 FROM     alltypesorc
 WHERE    (((csmallint > -26.28)
            AND (cstring2 LIKE 'ss'))
@@ -1506,86 +1508,86 @@ WHERE    (((csmallint > -26.28)
           OR (ctinyint = -89010)
              OR ((cbigint <= cfloat)
                  AND (-26.28 <= csmallint)))
-ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble
+ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13
 LIMIT 75
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
-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
-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	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	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	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	-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	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	-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	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	-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	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	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	-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	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	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	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	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	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	-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	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	-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	-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	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	-1698345590	15601	NULL	NULL	-1698345533	1698345590	57.0	-3396691123	1.0	-15601.0	NULL	-1.698361191E9	0.02436842105263158	-5129.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	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	-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	-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	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	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	-1105322173	15601	NULL	NULL	-1105322117	1105322173	56.0	-2210644290	1.0	-15601.0	NULL	-1.105337774E9	0.02480357142857143	-6924.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	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	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	-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	-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	-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	-1795674990	15601	NULL	NULL	-1795674936	1795674990	54.0	-3591349926	1.0	-15601.0	NULL	-1.795690591E9	0.025722222222222223	-15491.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	-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	-989710558	15601	NULL	NULL	-989710504	989710558	54.0	-1979421062	1.0	-15601.0	NULL	-9.89726159E8	0.025722222222222223	-14320.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	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	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	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	-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	-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	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	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	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	-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	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	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	-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	-57200424	15601	NULL	NULL	-57200375	57200424	49.0	-114400799	1.0	-15601.0	NULL	-5.7216025E7	0.028346938775510203	-7158.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	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	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	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	-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	-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	-803222928	15601	NULL	NULL	-803222880	803222928	48.0	-1606445808	1.0	-15601.0	NULL	-8.03238529E8	0.0289375	-5443.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	-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	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	-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	-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	-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	-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	-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	-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	-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	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	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	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	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	-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.
 PREHOOK: query: -- TargetTypeClasses: Long, String, Double, Timestamp
 -- Functions: Avg, Min, StDevP, Sum, Var
@@ -1598,16 +1600,16 @@ EXPLAIN SELECT   ctimestamp1,
          cfloat,
          cbigint,
          csmallint,
-         (cbigint / 3569),
-         (-257 - csmallint),
-         (-6432 * cfloat),
-         (-(cdouble)),
-         (cdouble * 10.175),
-         ((-6432 * cfloat) / cfloat),
-         (-(cfloat)),
-         (cint % csmallint),
-         (-(cdouble)),
-         (cdouble * (-(cdouble)))
+         (cbigint / 3569) as c1,
+         (-257 - csmallint) as c2,
+         (-6432 * cfloat) as c3,
+         (-(cdouble)) as c4,
+         (cdouble * 10.175) as c5,
+         ((-6432 * cfloat) / cfloat) as c6,
+         (-(cfloat)) as c7,
+         (cint % csmallint) as c8,
+         (-(cdouble)) as c9,
+         (cdouble * (-(cdouble))) as c10
 FROM     alltypesorc
 WHERE    (((-1.389 >= cint)
            AND ((csmallint < ctinyint)
@@ -1616,7 +1618,7 @@ WHERE    (((-1.389 >= cint)
               AND (cstring2 <= 'a'))
              OR ((cstring1 LIKE 'ss%')
                  AND (10.175 > cbigint)))
-ORDER BY csmallint, cstring2, cdouble
+ORDER BY csmallint, cstring2, cdouble, cfloat, cbigint, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10
 LIMIT 45
 PREHOOK: type: QUERY
 POSTHOOK: query: -- TargetTypeClasses: Long, String, Double, Timestamp
@@ -1630,16 +1632,16 @@ EXPLAIN SELECT   ctimestamp1,
          cfloat,
          cbigint,
          csmallint,
-         (cbigint / 3569),
-         (-257 - csmallint),
-         (-6432 * cfloat),
-         (-(cdouble)),
-         (cdouble * 10.175),
-         ((-6432 * cfloat) / cfloat),
-         (-(cfloat)),
-         (cint % csmallint),
-         (-(cdouble)),
-         (cdouble * (-(cdouble)))
+         (cbigint / 3569) as c1,
+         (-257 - csmallint) as c2,
+         (-6432 * cfloat) as c3,
+         (-(cdouble)) as c4,
+         (cdouble * 10.175) as c5,
+         ((-6432 * cfloat) / cfloat) as c6,
+         (-(cfloat)) as c7,
+         (cint % csmallint) as c8,
+         (-(cdouble)) as c9,
+         (cdouble * (-(cdouble))) as c10
 FROM     alltypesorc
 WHERE    (((-1.389 >= cint)
            AND ((csmallint < ctinyint)
@@ -1648,7 +1650,7 @@ WHERE    (((-1.389 >= cint)
               AND (cstring2 <= 'a'))
              OR ((cstring1 LIKE 'ss%')
                  AND (10.175 > cbigint)))
-ORDER BY csmallint, cstring2, cdouble
+ORDER BY csmallint, cstring2, cdouble, cfloat, cbigint, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10
 LIMIT 45
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
@@ -1671,19 +1673,19 @@ STAGE PLANS:
                     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)
                     Statistics: Num rows: 3868 Data size: 831633 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
-                      expressions: ctimestamp1 (type: timestamp), cstring2 (type: string), (cdouble * 10.175) (type: double), (UDFToDouble((-6432.0 * cfloat)) / UDFToDouble(cfloat)) (type: double), (- cfloat) (type: float), (cint % UDFToInteger(csmallint)) (type: int), (cdouble * (- cdouble)) (type: double), 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)
-                      outputColumnNames: _col0, _col1, _col10, _col11, _col12, _col13, _col15, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+                      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)
+                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
                       Statistics: Num rows: 3868 Data size: 831633 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
-                        key expressions: _col5 (type: smallint), _col1 (type: string), _col2 (type: double)
-                        sort order: +++
+                        key expressions: _col5 (type: smallint), _col1 (type: string), _col2 (type: double), _col3 (type: float), _col4 (type: bigint), _col6 (type: double), _col7 (type: int), _col8 (type: float), _col9 (type: double), _col10 (type: double), _col11 (type: double), _col12 (type: float), _col13 (type: int), _col14 (type: double), _col15 (type: double)
+                        sort order: +++++++++++++++
                         Statistics: Num rows: 3868 Data size: 831633 Basic stats: COMPLETE Column stats: NONE
-                        value expressions: _col0 (type: timestamp), _col3 (type: float), _col4 (type: bigint), _col6 (type: double), _col7 (type: int), _col8 (type: float), _col9 (type: double), _col10 (type: double), _col11 (type: double), _col12 (type: float), _col1

<TRUNCATED>

Mime
View raw message