hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject [26/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:19 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/63deec40/ql/src/test/results/clientpositive/spark/vectorization_15.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorization_15.q.out b/ql/src/test/results/clientpositive/spark/vectorization_15.q.out
index a58d941..4bd24c3 100644
--- a/ql/src/test/results/clientpositive/spark/vectorization_15.q.out
+++ b/ql/src/test/results/clientpositive/spark/vectorization_15.q.out
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN 
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN 
 SELECT   cfloat,
          cboolean1,
          cdouble,
@@ -29,7 +31,9 @@ WHERE    (((cstring2 LIKE '%ss%')
 GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
 ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
 PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN 
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN 
 SELECT   cfloat,
          cboolean1,
          cdouble,
@@ -199,22 +203,7 @@ ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
-NULL	false	-13008.0	10	NULL	-896629175	NULL	NULL	8.9662914872E8	-13008.0	-1034825.424	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-8.9662914872E8	0.0
-NULL	false	-7707.0	10vke853	NULL	424959354	NULL	NULL	-4.2495938028E8	-7707.0	-613114.971	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	4.2495938028E8	0.0
-NULL	false	2459.0	10	NULL	-394064473	NULL	NULL	3.9406444672E8	2459.0	195620.827	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-3.9406444672E8	0.0
-NULL	false	14771.0	10	NULL	993788576	NULL	NULL	-9.9378860228E8	14771.0	1175077.363	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	9.9378860228E8	0.0
-NULL	true	-14674.0	105aFDAt30c4rI4U	NULL	-831072496	NULL	NULL	8.3107246972E8	-14674.0	-1167360.722	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-8.3107246972E8	0.0
-NULL	true	-14640.0	101n6n461o	NULL	-819657767	NULL	NULL	8.1965774072E8	-14640.0	-1164655.92	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-8.1965774072E8	0.0
-NULL	true	-9489.0	10Yr6	NULL	500274721	NULL	NULL	-5.0027474728E8	-9489.0	-754878.417	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	5.0027474728E8	0.0
-NULL	true	-7238.0	10ljXCFT6fG6Qi3S7414e	NULL	-256767096	NULL	NULL	2.5676706972E8	-7238.0	-575804.614	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-2.5676706972E8	0.0
-NULL	true	2261.0	10Hr5oB07Ohu0622u	NULL	612000160	NULL	NULL	-6.1200018628E8	2261.0	179869.33299999998	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	6.1200018628E8	0.0
-NULL	true	4516.0	10lL0XD6WP2x64f70N0fHmC1	NULL	-974538365	NULL	NULL	9.7453833872E8	4516.0	359261.348	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-9.7453833872E8	0.0
-NULL	true	4767.0	10dUdwyXp5XwgpkTxLffmv3x	NULL	187503456	NULL	NULL	-1.8750348228E8	4767.0	379229.151	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	1.8750348228E8	0.0
-NULL	true	5658.0	10M3eGUsKVonbl70DyoCk25	NULL	486382507	NULL	NULL	-4.8638253328E8	5658.0	450110.874	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	4.8638253328E8	0.0
-NULL	true	8659.0	1047piRsT3c3r134I	NULL	487236176	NULL	NULL	-4.8723620228E8	8659.0	688849.427	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	4.8723620228E8	0.0
-NULL	true	10419.0	10	NULL	-721614386	NULL	NULL	7.2161435972E8	10419.0	828862.7069999999	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-7.2161435972E8	0.0
-NULL	true	14519.0	100xJdkyc	NULL	729277608	NULL	NULL	-7.2927763428E8	14519.0	1155030.007	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	7.2927763428E8	0.0
--62.0	NULL	15601.0	NULL	-62	NULL	1969-12-31 16:00:09.889	0.0	NULL	15601.0	1241106.353	33.0	0.0	0.0	-23.0	62	NULL	NULL	-23	NULL	NULL
+-48.0	NULL	-7196.0	NULL	-48	NULL	1969-12-31 16:00:06.337	0.0	NULL	-7196.0	-572463.388	33.0	0.0	0.0	-23.0	48	NULL	NULL	-23	NULL	NULL
 -51.0	NULL	-200.0	NULL	-51	NULL	1969-12-31 15:59:55.423	0.0	NULL	-200.0	-15910.599999999999	33.0	0.0	0.0	-23.0	51	NULL	NULL	-23	NULL	NULL
 -51.0	false	NULL	10	-51	1058319346	1969-12-31 16:00:08.451	0.0	-1.05831937228E9	NULL	NULL	33.0	0.0	0.0	NULL	51	0.0	1.05831942E9	-23	1.05831937228E9	0.0
 -51.0	false	NULL	10TYIE5S35U6dj3N	-51	-469581869	1969-12-31 16:00:08.451	0.0	4.6958184272E8	NULL	NULL	33.0	0.0	0.0	NULL	51	0.0	-4.69581792E8	-23	-4.6958184272E8	0.0
@@ -226,9 +215,17 @@ NULL	true	14519.0	100xJdkyc	NULL	729277608	NULL	NULL	-7.2927763428E8	14519.0	115
 -51.0	true	NULL	8iHtdkJ6d	-51	1006818344	1969-12-31 16:00:08.451	0.0	-1.00681837028E9	NULL	NULL	33.0	0.0	0.0	NULL	51	0.0	1.00681843E9	-23	1.00681837028E9	0.0
 -51.0	true	NULL	QiOcvR0kt6r7f0R7fiPxQTCU	-51	266531954	1969-12-31 16:00:08.451	0.0	-2.6653198028E8	NULL	NULL	33.0	0.0	0.0	NULL	51	0.0	2.66532E8	-23	2.6653198028E8	0.0
 -51.0	true	NULL	Ybpj38RTTYl7CnJXPNx1g4C	-51	-370919370	1969-12-31 16:00:08.451	0.0	3.7091934372E8	NULL	NULL	33.0	0.0	0.0	NULL	51	0.0	-3.70919296E8	-23	-3.7091934372E8	0.0
--48.0	NULL	-7196.0	NULL	-48	NULL	1969-12-31 16:00:06.337	0.0	NULL	-7196.0	-572463.388	33.0	0.0	0.0	-23.0	48	NULL	NULL	-23	NULL	NULL
 -6.0	NULL	-200.0	NULL	-6	NULL	1969-12-31 15:59:56.094	0.0	NULL	-200.0	-15910.599999999999	3.0	0.0	0.0	-23.0	6	NULL	NULL	-5	NULL	NULL
+-62.0	NULL	15601.0	NULL	-62	NULL	1969-12-31 16:00:09.889	0.0	NULL	15601.0	1241106.353	33.0	0.0	0.0	-23.0	62	NULL	NULL	-23	NULL	NULL
+11.0	false	NULL	10pO8p1LNx4Y	11	271296824	1969-12-31 16:00:02.351	0.0	-2.7129685028E8	NULL	NULL	0.0	0.0	0.0	NULL	-11	0.0	2.71296832E8	-1	2.7129685028E8	0.0
+11.0	false	NULL	1H6wGP	11	-560827082	1969-12-31 16:00:02.351	0.0	5.6082705572E8	NULL	NULL	0.0	0.0	0.0	NULL	-11	0.0	-5.6082707E8	-1	-5.6082705572E8	0.0
+11.0	false	NULL	2a7V63IL7jK3o	11	-325931647	1969-12-31 16:00:02.351	0.0	3.2593162072E8	NULL	NULL	0.0	0.0	0.0	NULL	-11	0.0	-3.25931648E8	-1	-3.2593162072E8	0.0
+11.0	true	NULL	10	11	92365813	1969-12-31 16:00:02.351	0.0	-9.236583928E7	NULL	NULL	0.0	0.0	0.0	NULL	-11	0.0	9.2365808E7	-1	9.236583928E7	0.0
+21.0	NULL	15601.0	NULL	21	NULL	1969-12-31 16:00:14.256	0.0	NULL	15601.0	1241106.353	12.0	0.0	0.0	-23.0	-21	NULL	NULL	-2	NULL	NULL
+32.0	NULL	-200.0	NULL	32	NULL	1969-12-31 16:00:02.445	0.0	NULL	-200.0	-15910.599999999999	1.0	0.0	0.0	-23.0	-32	NULL	NULL	-23	NULL	NULL
+36.0	NULL	-200.0	NULL	36	NULL	1969-12-31 16:00:00.554	0.0	NULL	-200.0	-15910.599999999999	33.0	0.0	0.0	-23.0	-36	NULL	NULL	-23	NULL	NULL
 5.0	NULL	15601.0	NULL	5	NULL	1969-12-31 16:00:00.959	0.0	NULL	15601.0	1241106.353	3.0	0.0	0.0	-23.0	-5	NULL	NULL	-3	NULL	NULL
+58.0	NULL	15601.0	NULL	58	NULL	1969-12-31 15:59:56.527	0.0	NULL	15601.0	1241106.353	33.0	0.0	0.0	-23.0	-58	NULL	NULL	-23	NULL	NULL
 8.0	false	NULL	10V3pN5r5lI2qWl2lG103	8	-362835731	1969-12-31 16:00:15.892	0.0	3.6283570472E8	NULL	NULL	1.0	0.0	0.0	NULL	-8	0.0	-3.62835744E8	-7	-3.6283570472E8	0.0
 8.0	false	NULL	10c4qt584m5y6uWT	8	-183000142	1969-12-31 16:00:15.892	0.0	1.8300011572E8	NULL	NULL	1.0	0.0	0.0	NULL	-8	0.0	-1.8300016E8	-7	-1.8300011572E8	0.0
 8.0	false	NULL	8GloEukQ0c68JDmnYL53	8	-722873402	1969-12-31 16:00:15.892	0.0	7.2287337572E8	NULL	NULL	1.0	0.0	0.0	NULL	-8	0.0	-7.2287341E8	-7	-7.2287337572E8	0.0
@@ -238,11 +235,18 @@ NULL	true	14519.0	100xJdkyc	NULL	729277608	NULL	NULL	-7.2927763428E8	14519.0	115
 8.0	true	NULL	1063cEnGjSal	8	-624769630	1969-12-31 16:00:15.892	0.0	6.2476960372E8	NULL	NULL	1.0	0.0	0.0	NULL	-8	0.0	-6.247696E8	-7	-6.2476960372E8	0.0
 8.0	true	NULL	4kMasVoB7lX1wc5i64bNk	8	683567667	1969-12-31 16:00:15.892	0.0	-6.8356769328E8	NULL	NULL	1.0	0.0	0.0	NULL	-8	0.0	6.8356768E8	-7	6.8356769328E8	0.0
 8.0	true	NULL	XH6I7A417	8	436627202	1969-12-31 16:00:15.892	0.0	-4.3662722828E8	NULL	NULL	1.0	0.0	0.0	NULL	-8	0.0	4.366272E8	-7	4.3662722828E8	0.0
-11.0	false	NULL	10pO8p1LNx4Y	11	271296824	1969-12-31 16:00:02.351	0.0	-2.7129685028E8	NULL	NULL	0.0	0.0	0.0	NULL	-11	0.0	2.71296832E8	-1	2.7129685028E8	0.0
-11.0	false	NULL	1H6wGP	11	-560827082	1969-12-31 16:00:02.351	0.0	5.6082705572E8	NULL	NULL	0.0	0.0	0.0	NULL	-11	0.0	-5.6082707E8	-1	-5.6082705572E8	0.0
-11.0	false	NULL	2a7V63IL7jK3o	11	-325931647	1969-12-31 16:00:02.351	0.0	3.2593162072E8	NULL	NULL	0.0	0.0	0.0	NULL	-11	0.0	-3.25931648E8	-1	-3.2593162072E8	0.0
-11.0	true	NULL	10	11	92365813	1969-12-31 16:00:02.351	0.0	-9.236583928E7	NULL	NULL	0.0	0.0	0.0	NULL	-11	0.0	9.2365808E7	-1	9.236583928E7	0.0
-21.0	NULL	15601.0	NULL	21	NULL	1969-12-31 16:00:14.256	0.0	NULL	15601.0	1241106.353	12.0	0.0	0.0	-23.0	-21	NULL	NULL	-2	NULL	NULL
-32.0	NULL	-200.0	NULL	32	NULL	1969-12-31 16:00:02.445	0.0	NULL	-200.0	-15910.599999999999	1.0	0.0	0.0	-23.0	-32	NULL	NULL	-23	NULL	NULL
-36.0	NULL	-200.0	NULL	36	NULL	1969-12-31 16:00:00.554	0.0	NULL	-200.0	-15910.599999999999	33.0	0.0	0.0	-23.0	-36	NULL	NULL	-23	NULL	NULL
-58.0	NULL	15601.0	NULL	58	NULL	1969-12-31 15:59:56.527	0.0	NULL	15601.0	1241106.353	33.0	0.0	0.0	-23.0	-58	NULL	NULL	-23	NULL	NULL
+NULL	false	-13008.0	10	NULL	-896629175	NULL	NULL	8.9662914872E8	-13008.0	-1034825.424	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-8.9662914872E8	0.0
+NULL	false	-7707.0	10vke853	NULL	424959354	NULL	NULL	-4.2495938028E8	-7707.0	-613114.971	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	4.2495938028E8	0.0
+NULL	false	14771.0	10	NULL	993788576	NULL	NULL	-9.9378860228E8	14771.0	1175077.363	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	9.9378860228E8	0.0
+NULL	false	2459.0	10	NULL	-394064473	NULL	NULL	3.9406444672E8	2459.0	195620.827	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-3.9406444672E8	0.0
+NULL	true	-14640.0	101n6n461o	NULL	-819657767	NULL	NULL	8.1965774072E8	-14640.0	-1164655.92	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-8.1965774072E8	0.0
+NULL	true	-14674.0	105aFDAt30c4rI4U	NULL	-831072496	NULL	NULL	8.3107246972E8	-14674.0	-1167360.722	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-8.3107246972E8	0.0
+NULL	true	-7238.0	10ljXCFT6fG6Qi3S7414e	NULL	-256767096	NULL	NULL	2.5676706972E8	-7238.0	-575804.614	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-2.5676706972E8	0.0
+NULL	true	-9489.0	10Yr6	NULL	500274721	NULL	NULL	-5.0027474728E8	-9489.0	-754878.417	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	5.0027474728E8	0.0
+NULL	true	10419.0	10	NULL	-721614386	NULL	NULL	7.2161435972E8	10419.0	828862.7069999999	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-7.2161435972E8	0.0
+NULL	true	14519.0	100xJdkyc	NULL	729277608	NULL	NULL	-7.2927763428E8	14519.0	1155030.007	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	7.2927763428E8	0.0
+NULL	true	2261.0	10Hr5oB07Ohu0622u	NULL	612000160	NULL	NULL	-6.1200018628E8	2261.0	179869.33299999998	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	6.1200018628E8	0.0
+NULL	true	4516.0	10lL0XD6WP2x64f70N0fHmC1	NULL	-974538365	NULL	NULL	9.7453833872E8	4516.0	359261.348	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	-9.7453833872E8	0.0
+NULL	true	4767.0	10dUdwyXp5XwgpkTxLffmv3x	NULL	187503456	NULL	NULL	-1.8750348228E8	4767.0	379229.151	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	1.8750348228E8	0.0
+NULL	true	5658.0	10M3eGUsKVonbl70DyoCk25	NULL	486382507	NULL	NULL	-4.8638253328E8	5658.0	450110.874	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	4.8638253328E8	0.0
+NULL	true	8659.0	1047piRsT3c3r134I	NULL	487236176	NULL	NULL	-4.8723620228E8	8659.0	688849.427	NULL	NULL	NULL	-23.0	NULL	0.0	NULL	NULL	4.8723620228E8	0.0

http://git-wip-us.apache.org/repos/asf/hive/blob/63deec40/ql/src/test/results/clientpositive/spark/vectorization_17.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorization_17.q.out b/ql/src/test/results/clientpositive/spark/vectorization_17.q.out
new file mode 100644
index 0000000..472d98f
--- /dev/null
+++ b/ql/src/test/results/clientpositive/spark/vectorization_17.q.out
@@ -0,0 +1,507 @@
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN 
+SELECT   cfloat,
+         cstring1,
+         cint,
+         ctimestamp1,
+         cdouble,
+         cbigint,
+         (cfloat / ctinyint),
+         (cint % cbigint),
+         (-(cdouble)),
+         (cdouble + (cfloat / ctinyint)),
+         (cdouble / cint),
+         (-((-(cdouble)))),
+         (9763215.5639 % cbigint),
+         (2563.58 + (-((-(cdouble)))))
+FROM     alltypesorc
+WHERE    (((cbigint > -23)
+           AND ((cdouble != 988888)
+                OR (cint > -863.257)))
+          AND ((ctinyint >= 33)
+              OR ((csmallint >= cbigint)
+                  OR (cfloat = cdouble))))
+ORDER BY cbigint, cfloat
+PREHOOK: type: QUERY
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN 
+SELECT   cfloat,
+         cstring1,
+         cint,
+         ctimestamp1,
+         cdouble,
+         cbigint,
+         (cfloat / ctinyint),
+         (cint % cbigint),
+         (-(cdouble)),
+         (cdouble + (cfloat / ctinyint)),
+         (cdouble / cint),
+         (-((-(cdouble)))),
+         (9763215.5639 % cbigint),
+         (2563.58 + (-((-(cdouble)))))
+FROM     alltypesorc
+WHERE    (((cbigint > -23)
+           AND ((cdouble != 988888)
+                OR (cint > -863.257)))
+          AND ((ctinyint >= 33)
+              OR ((csmallint >= cbigint)
+                  OR (cfloat = cdouble))))
+ORDER BY cbigint, cfloat
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Spark
+      Edges:
+        Reducer 2 <- Map 1 (SORT, 1)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: alltypesorc
+                  Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+                  Filter Operator
+                    predicate: (((cbigint > -23) and ((cdouble <> 988888.0) or (UDFToDouble(cint) > -863.257))) and ((ctinyint >= 33) or ((UDFToLong(csmallint) >= cbigint) or (UDFToDouble(cfloat) = cdouble)))) (type: boolean)
+                    Statistics: Num rows: 6370 Data size: 195556 Basic stats: COMPLETE Column stats: NONE
+                    Select Operator
+                      expressions: cfloat (type: float), cstring1 (type: string), cint (type: int), ctimestamp1 (type: timestamp), cdouble (type: double), cbigint (type: bigint), (UDFToDouble(cfloat) / UDFToDouble(ctinyint)) (type: double), (UDFToLong(cint) % cbigint) (type: bigint), (- cdouble) (type: double), (cdouble + (UDFToDouble(cfloat) / UDFToDouble(ctinyint))) (type: double), (cdouble / UDFToDouble(cint)) (type: double), (- (- cdouble)) (type: double), (9763215.5639 % UDFToDouble(cbigint)) (type: double), (2563.58 + (- (- cdouble))) (type: double)
+                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
+                      Statistics: Num rows: 6370 Data size: 195556 Basic stats: COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        key expressions: _col5 (type: bigint), _col0 (type: float)
+                        sort order: ++
+                        Statistics: Num rows: 6370 Data size: 195556 Basic stats: COMPLETE Column stats: NONE
+                        value expressions: _col1 (type: string), _col2 (type: int), _col3 (type: timestamp), _col4 (type: double), _col6 (type: double), _col7 (type: bigint), _col8 (type: double), _col9 (type: double), _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: double)
+            Execution mode: vectorized
+        Reducer 2 
+            Reduce Operator Tree:
+              Select Operator
+                expressions: KEY.reducesinkkey1 (type: float), VALUE._col0 (type: string), VALUE._col1 (type: int), VALUE._col2 (type: timestamp), VALUE._col3 (type: double), KEY.reducesinkkey0 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: bigint), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: double), VALUE._col9 (type: double), VALUE._col10 (type: double), VALUE._col11 (type: double)
+                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
+                Statistics: Num rows: 6370 Data size: 195556 Basic stats: COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 6370 Data size: 195556 Basic stats: COMPLETE Column stats: NONE
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+            Execution mode: vectorized
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: SELECT   cfloat,
+         cstring1,
+         cint,
+         ctimestamp1,
+         cdouble,
+         cbigint,
+         (cfloat / ctinyint),
+         (cint % cbigint),
+         (-(cdouble)),
+         (cdouble + (cfloat / ctinyint)),
+         (cdouble / cint),
+         (-((-(cdouble)))),
+         (9763215.5639 % cbigint),
+         (2563.58 + (-((-(cdouble)))))
+FROM     alltypesorc
+WHERE    (((cbigint > -23)
+           AND ((cdouble != 988888)
+                OR (cint > -863.257)))
+          AND ((ctinyint >= 33)
+              OR ((csmallint >= cbigint)
+                  OR (cfloat = cdouble))))
+ORDER BY cbigint, cfloat
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT   cfloat,
+         cstring1,
+         cint,
+         ctimestamp1,
+         cdouble,
+         cbigint,
+         (cfloat / ctinyint),
+         (cint % cbigint),
+         (-(cdouble)),
+         (cdouble + (cfloat / ctinyint)),
+         (cdouble / cint),
+         (-((-(cdouble)))),
+         (9763215.5639 % cbigint),
+         (2563.58 + (-((-(cdouble)))))
+FROM     alltypesorc
+WHERE    (((cbigint > -23)
+           AND ((cdouble != 988888)
+                OR (cint > -863.257)))
+          AND ((ctinyint >= 33)
+              OR ((csmallint >= cbigint)
+                  OR (cfloat = cdouble))))
+ORDER BY cbigint, cfloat
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+33.0	NULL	NULL	1969-12-31 15:59:45.163	-200.0	766974126	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+33.0	NULL	NULL	1969-12-31 15:59:49.489	-200.0	1531926845	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+33.0	NULL	NULL	1969-12-31 15:59:54.68	15601.0	2094164536	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+33.0	NULL	NULL	1969-12-31 16:00:04.396	-7196.0	1409016642	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+33.0	NULL	NULL	1969-12-31 16:00:04.631	15601.0	739625813	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+33.0	NULL	NULL	1969-12-31 16:00:15.198	-200.0	29795288	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+33.0	NULL	NULL	1969-12-31 16:00:15.99	-7196.0	1994545529	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+34.0	NULL	NULL	1969-12-31 15:59:44.179	15601.0	1563271651	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+34.0	NULL	NULL	1969-12-31 15:59:45.717	15601.0	1425488085	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+34.0	NULL	NULL	1969-12-31 15:59:48.473	-200.0	144591485	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+34.0	NULL	NULL	1969-12-31 15:59:53.981	-7196.0	131852675	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+34.0	NULL	NULL	1969-12-31 15:59:54.145	-7196.0	9288869	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	474346.5638999995	-4632.42
+34.0	NULL	NULL	1969-12-31 15:59:54.821	15601.0	1736691817	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+34.0	NULL	NULL	1969-12-31 16:00:00.82	-7196.0	221369308	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+34.0	NULL	NULL	1969-12-31 16:00:01.232	-200.0	1961389522	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+34.0	NULL	NULL	1969-12-31 16:00:04.36	-7196.0	1412648789	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+34.0	NULL	NULL	1969-12-31 16:00:07.045	15601.0	709756299	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+34.0	NULL	NULL	1969-12-31 16:00:09.65	-200.0	1990585322	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+34.0	NULL	NULL	1969-12-31 16:00:12.502	-7196.0	1539208529	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+34.0	NULL	NULL	1969-12-31 16:00:13.955	15601.0	47514726	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+34.0	NULL	NULL	1969-12-31 16:00:14.909	-200.0	26234080	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+35.0	NULL	NULL	1969-12-31 15:59:48.022	-7196.0	523231898	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+35.0	NULL	NULL	1969-12-31 15:59:50.803	15601.0	456583571	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+35.0	NULL	NULL	1969-12-31 15:59:51.86	-7196.0	1667895530	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+35.0	NULL	NULL	1969-12-31 15:59:51.882	-200.0	1045814182	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+35.0	NULL	NULL	1969-12-31 16:00:00.546	-200.0	1537595879	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+35.0	NULL	NULL	1969-12-31 16:00:00.9	-200.0	880598992	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+35.0	NULL	NULL	1969-12-31 16:00:01.792	-7196.0	1587509603	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+35.0	NULL	NULL	1969-12-31 16:00:05.007	15601.0	2123136080	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+35.0	NULL	NULL	1969-12-31 16:00:07.613	-7196.0	2000277321	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+35.0	NULL	NULL	1969-12-31 16:00:08.58	-200.0	1321091454	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+35.0	NULL	NULL	1969-12-31 16:00:11.356	-7196.0	1004273023	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+35.0	NULL	NULL	1969-12-31 16:00:14.084	-200.0	1974986508	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+36.0	NULL	NULL	1969-12-31 15:59:46.019	-7196.0	1086107721	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+36.0	NULL	NULL	1969-12-31 15:59:48.771	15601.0	503569096	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+36.0	NULL	NULL	1969-12-31 15:59:55.218	15601.0	445347927	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+36.0	NULL	NULL	1969-12-31 15:59:58.752	15601.0	4757615	1.0	NULL	-15601.0	15602.0	NULL	15601.0	247985.56389999948	18164.58
+36.0	NULL	NULL	1969-12-31 16:00:00.865	-7196.0	1613629130	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+36.0	NULL	NULL	1969-12-31 16:00:05.234	15601.0	873370057	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+36.0	NULL	NULL	1969-12-31 16:00:06.51	-7196.0	1141844958	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+36.0	NULL	NULL	1969-12-31 16:00:07.504	-7196.0	787178337	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+36.0	NULL	NULL	1969-12-31 16:00:10.467	-200.0	1284716338	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+37.0	NULL	NULL	1969-12-31 15:59:45.102	-7196.0	106550057	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+37.0	NULL	NULL	1969-12-31 15:59:51.566	-200.0	1829107401	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+37.0	NULL	NULL	1969-12-31 15:59:52.832	15601.0	676613895	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+37.0	NULL	NULL	1969-12-31 15:59:57.118	-200.0	248910079	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+37.0	NULL	NULL	1969-12-31 15:59:58.129	-200.0	1838442362	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+37.0	NULL	NULL	1969-12-31 16:00:01.979	15601.0	2144325818	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+37.0	NULL	NULL	1969-12-31 16:00:05.356	-200.0	1248357837	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+37.0	NULL	NULL	1969-12-31 16:00:08.692	-200.0	448909712	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+37.0	NULL	NULL	1969-12-31 16:00:09.907	-200.0	1256255128	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+37.0	NULL	NULL	1969-12-31 16:00:09.934	-200.0	1820006290	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+37.0	NULL	NULL	1969-12-31 16:00:11.091	15601.0	398128194	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+37.0	NULL	NULL	1969-12-31 16:00:11.309	15601.0	1251122304	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+37.0	NULL	NULL	1969-12-31 16:00:12.712	15601.0	980331206	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+37.0	NULL	NULL	1969-12-31 16:00:14.674	15601.0	1217409914	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+38.0	NULL	NULL	1969-12-31 15:59:46.966	-7196.0	1030289173	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+38.0	NULL	NULL	1969-12-31 15:59:48.017	-200.0	428518739	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+38.0	NULL	NULL	1969-12-31 15:59:48.059	-7196.0	799787406	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+38.0	NULL	NULL	1969-12-31 15:59:49.567	-200.0	1576772382	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+38.0	NULL	NULL	1969-12-31 15:59:51.77	-200.0	835189885	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+38.0	NULL	NULL	1969-12-31 15:59:53.592	-200.0	1922447714	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+38.0	NULL	NULL	1969-12-31 15:59:53.834	15601.0	951445775	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+38.0	NULL	NULL	1969-12-31 15:59:56.858	15601.0	954040345	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+38.0	NULL	NULL	1969-12-31 15:59:57.048	-7196.0	806488245	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+38.0	NULL	NULL	1969-12-31 15:59:58.015	15601.0	1202434039	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+38.0	NULL	NULL	1969-12-31 16:00:05.29	-200.0	679959712	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+38.0	NULL	NULL	1969-12-31 16:00:08.703	-200.0	1479847097	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+38.0	NULL	NULL	1969-12-31 16:00:13.506	15601.0	1524423680	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+38.0	NULL	NULL	1969-12-31 16:00:14.648	15601.0	1927566094	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+38.0	NULL	NULL	1969-12-31 16:00:16.279	15601.0	299342203	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+39.0	NULL	NULL	1969-12-31 15:59:45.218	15601.0	923495645	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+39.0	NULL	NULL	1969-12-31 15:59:45.229	-200.0	1564077167	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+39.0	NULL	NULL	1969-12-31 15:59:46.368	-200.0	112950540	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+39.0	NULL	NULL	1969-12-31 15:59:47.616	15601.0	333745628	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+39.0	NULL	NULL	1969-12-31 15:59:54.999	15601.0	2102419786	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+39.0	NULL	NULL	1969-12-31 16:00:01.122	15601.0	345989051	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+39.0	NULL	NULL	1969-12-31 16:00:02.804	-200.0	1368309884	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+39.0	NULL	NULL	1969-12-31 16:00:06.149	-7196.0	2071577258	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+39.0	NULL	NULL	1969-12-31 16:00:07.541	-200.0	260798405	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+39.0	NULL	NULL	1969-12-31 16:00:09.365	15601.0	1210224988	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+39.0	NULL	NULL	1969-12-31 16:00:10.575	15601.0	186460538	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+39.0	NULL	NULL	1969-12-31 16:00:12.719	15601.0	581431028	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+39.0	NULL	NULL	1969-12-31 16:00:15.146	-7196.0	1832892113	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+39.0	NULL	NULL	1969-12-31 16:00:15.52	15601.0	1748908827	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+40.0	NULL	NULL	1969-12-31 15:59:45.707	-200.0	183831674	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+40.0	NULL	NULL	1969-12-31 15:59:48.045	15601.0	364112219	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+40.0	NULL	NULL	1969-12-31 15:59:48.264	15601.0	2088429109	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+40.0	NULL	NULL	1969-12-31 15:59:49.23	-7196.0	437984126	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+40.0	NULL	NULL	1969-12-31 15:59:51.519	-200.0	1165114321	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+40.0	NULL	NULL	1969-12-31 15:59:55.197	-200.0	1958187727	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+40.0	NULL	NULL	1969-12-31 16:00:00.258	15601.0	472680102	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+40.0	NULL	NULL	1969-12-31 16:00:01.356	-200.0	1778581609	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+40.0	NULL	NULL	1969-12-31 16:00:06.346	-200.0	2068959120	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+40.0	NULL	NULL	1969-12-31 16:00:14.565	15601.0	946637795	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+40.0	NULL	NULL	1969-12-31 16:00:15.311	-7196.0	316847321	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+41.0	NULL	NULL	1969-12-31 15:59:44.57	-7196.0	649072626	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+41.0	NULL	NULL	1969-12-31 15:59:44.669	-7196.0	253244734	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+41.0	NULL	NULL	1969-12-31 15:59:51.387	-200.0	689333315	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+41.0	NULL	NULL	1969-12-31 15:59:56.691	-200.0	1642331517	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+41.0	NULL	NULL	1969-12-31 16:00:00.123	15601.0	987132753	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+41.0	NULL	NULL	1969-12-31 16:00:00.469	15601.0	439625822	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+41.0	NULL	NULL	1969-12-31 16:00:01.424	-7196.0	1759398044	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+41.0	NULL	NULL	1969-12-31 16:00:01.951	-200.0	2014322043	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+41.0	NULL	NULL	1969-12-31 16:00:04.12	-200.0	1476633885	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+41.0	NULL	NULL	1969-12-31 16:00:07.175	-200.0	1542568556	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+41.0	NULL	NULL	1969-12-31 16:00:08.408	-200.0	696650264	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+41.0	NULL	NULL	1969-12-31 16:00:08.418	-7196.0	791540035	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+41.0	NULL	NULL	1969-12-31 16:00:14.017	15601.0	137074296	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+42.0	NULL	NULL	1969-12-31 15:59:43.931	15601.0	509177858	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+42.0	NULL	NULL	1969-12-31 15:59:45.686	15601.0	1273900453	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+42.0	NULL	NULL	1969-12-31 15:59:48.292	-200.0	760034197	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+42.0	NULL	NULL	1969-12-31 15:59:48.675	-7196.0	567300720	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+42.0	NULL	NULL	1969-12-31 15:59:57.319	15601.0	1756904629	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+42.0	NULL	NULL	1969-12-31 16:00:00.11	-200.0	1303413031	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+42.0	NULL	NULL	1969-12-31 16:00:00.992	-7196.0	1644841467	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+42.0	NULL	NULL	1969-12-31 16:00:05.092	-200.0	1057329243	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+42.0	NULL	NULL	1969-12-31 16:00:07.179	-200.0	550015371	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+42.0	NULL	NULL	1969-12-31 16:00:10.894	15601.0	1267863526	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+42.0	NULL	NULL	1969-12-31 16:00:11.591	-7196.0	873176558	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+42.0	NULL	NULL	1969-12-31 16:00:11.758	-7196.0	83253614	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+42.0	NULL	NULL	1969-12-31 16:00:13.183	15601.0	1370965887	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+42.0	NULL	NULL	1969-12-31 16:00:15.369	-200.0	942676094	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+43.0	NULL	NULL	1969-12-31 15:59:45.546	-200.0	313484894	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+43.0	NULL	NULL	1969-12-31 15:59:49.388	-7196.0	1840183062	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+43.0	NULL	NULL	1969-12-31 15:59:50.893	-200.0	1796171294	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+43.0	NULL	NULL	1969-12-31 15:59:52.311	15601.0	2113671499	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+43.0	NULL	NULL	1969-12-31 15:59:58.65	-200.0	762545274	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+43.0	NULL	NULL	1969-12-31 16:00:06.578	-200.0	548851592	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+43.0	NULL	NULL	1969-12-31 16:00:08.554	15601.0	657369975	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+44.0	NULL	NULL	1969-12-31 15:59:51.468	15601.0	1265051089	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+44.0	NULL	NULL	1969-12-31 15:59:53.541	-7196.0	764482700	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+44.0	NULL	NULL	1969-12-31 15:59:55.798	-7196.0	1723777074	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+44.0	NULL	NULL	1969-12-31 16:00:00.206	15601.0	970663654	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+44.0	NULL	NULL	1969-12-31 16:00:03.63	-200.0	1216277933	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+44.0	NULL	NULL	1969-12-31 16:00:04.431	-7196.0	2015572524	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+45.0	NULL	NULL	1969-12-31 15:59:45.347	15601.0	1100120303	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+45.0	NULL	NULL	1969-12-31 15:59:49.29	15601.0	1477361644	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+45.0	NULL	NULL	1969-12-31 15:59:49.881	-200.0	877201446	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+45.0	NULL	NULL	1969-12-31 15:59:50.515	-200.0	1618117091	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+45.0	NULL	NULL	1969-12-31 15:59:53.84	15601.0	1903410305	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+45.0	NULL	NULL	1969-12-31 15:59:57.771	-7196.0	26143086	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+45.0	NULL	NULL	1969-12-31 16:00:00.543	-7196.0	940192068	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+45.0	NULL	NULL	1969-12-31 16:00:01.005	15601.0	270402394	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+45.0	NULL	NULL	1969-12-31 16:00:03.875	15601.0	29687887	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+45.0	NULL	NULL	1969-12-31 16:00:04.572	-200.0	612900585	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+45.0	NULL	NULL	1969-12-31 16:00:07.497	-200.0	1495508907	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+45.0	NULL	NULL	1969-12-31 16:00:08.378	-7196.0	1816604358	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+45.0	NULL	NULL	1969-12-31 16:00:08.799	15601.0	761255971	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+45.0	NULL	NULL	1969-12-31 16:00:11.515	-200.0	855920504	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+45.0	NULL	NULL	1969-12-31 16:00:15.07	-7196.0	676615206	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+45.0	NULL	NULL	1969-12-31 16:00:16.149	15601.0	2034207903	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+45.0	NULL	NULL	1969-12-31 16:00:16.167	-7196.0	744145938	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+46.0	NULL	NULL	1969-12-31 15:59:46.028	-200.0	14115102	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+46.0	NULL	NULL	1969-12-31 15:59:48.225	-7196.0	1372930003	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+46.0	NULL	NULL	1969-12-31 15:59:48.406	-200.0	1457394745	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+46.0	NULL	NULL	1969-12-31 16:00:00.259	15601.0	1056441941	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+46.0	NULL	NULL	1969-12-31 16:00:00.382	-7196.0	1891715684	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+46.0	NULL	NULL	1969-12-31 16:00:01.388	-7196.0	242119227	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+46.0	NULL	NULL	1969-12-31 16:00:04.717	15601.0	519083144	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+46.0	NULL	NULL	1969-12-31 16:00:05.226	-7196.0	275575541	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+46.0	NULL	NULL	1969-12-31 16:00:06.353	15601.0	1863251368	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+46.0	NULL	NULL	1969-12-31 16:00:09.441	15601.0	1247409916	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+47.0	NULL	NULL	1969-12-31 15:59:44.671	-200.0	650092010	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+47.0	NULL	NULL	1969-12-31 15:59:45.085	-7196.0	2074601799	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+47.0	NULL	NULL	1969-12-31 15:59:45.198	-200.0	326580052	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+47.0	NULL	NULL	1969-12-31 15:59:45.518	-7196.0	1726448718	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+47.0	NULL	NULL	1969-12-31 15:59:46.953	15601.0	661404907	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+47.0	NULL	NULL	1969-12-31 15:59:47.17	-200.0	1241593530	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+47.0	NULL	NULL	1969-12-31 15:59:51.788	-200.0	1394914812	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+47.0	NULL	NULL	1969-12-31 15:59:52.118	-200.0	1683928379	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+47.0	NULL	NULL	1969-12-31 15:59:54.438	-7196.0	265927514	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+47.0	NULL	NULL	1969-12-31 16:00:01.694	-7196.0	58767695	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+47.0	NULL	NULL	1969-12-31 16:00:02	-200.0	678949554	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+47.0	NULL	NULL	1969-12-31 16:00:05.344	15601.0	1640015816	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+47.0	NULL	NULL	1969-12-31 16:00:06.723	15601.0	1447975413	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+47.0	NULL	NULL	1969-12-31 16:00:12.183	-200.0	1577520702	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+47.0	NULL	NULL	1969-12-31 16:00:15.105	-7196.0	1071491504	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+48.0	NULL	NULL	1969-12-31 15:59:45.106	-200.0	1039294810	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+48.0	NULL	NULL	1969-12-31 15:59:56.394	15601.0	400830823	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+48.0	NULL	NULL	1969-12-31 16:00:00.88	15601.0	1294882412	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+48.0	NULL	NULL	1969-12-31 16:00:06.529	15601.0	847428763	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+48.0	NULL	NULL	1969-12-31 16:00:07.08	15601.0	1766992295	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+48.0	NULL	NULL	1969-12-31 16:00:07.115	-7196.0	1930601673	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+48.0	NULL	NULL	1969-12-31 16:00:07.257	-7196.0	1639854261	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+48.0	NULL	NULL	1969-12-31 16:00:08.445	15601.0	846324964	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+48.0	NULL	NULL	1969-12-31 16:00:09.582	15601.0	1366904455	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+48.0	NULL	NULL	1969-12-31 16:00:10.548	15601.0	1276990360	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+48.0	NULL	NULL	1969-12-31 16:00:10.669	-7196.0	938665221	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+48.0	NULL	NULL	1969-12-31 16:00:15.548	-200.0	1372727646	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+48.0	NULL	NULL	1969-12-31 16:00:16.19	-7196.0	624835112	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+49.0	NULL	NULL	1969-12-31 15:59:30.929	-7196.0	1948223613	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+49.0	NULL	NULL	1969-12-31 15:59:44.289	-200.0	1713733703	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+49.0	NULL	NULL	1969-12-31 15:59:48.367	-200.0	1709812289	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+49.0	NULL	NULL	1969-12-31 15:59:50.686	15601.0	1911676187	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+49.0	NULL	NULL	1969-12-31 15:59:50.754	15601.0	46706681	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+49.0	NULL	NULL	1969-12-31 15:59:51.555	-200.0	1235418687	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+49.0	NULL	NULL	1969-12-31 15:59:52.069	15601.0	940280284	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+49.0	NULL	NULL	1969-12-31 16:00:00.148	-7196.0	1839707228	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+49.0	NULL	NULL	1969-12-31 16:00:00.754	-7196.0	1237005923	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+49.0	NULL	NULL	1969-12-31 16:00:01.128	-200.0	1720947024	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+49.0	NULL	NULL	1969-12-31 16:00:02.657	-200.0	1444653089	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+49.0	NULL	NULL	1969-12-31 16:00:03.074	15601.0	1174850100	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+49.0	NULL	NULL	1969-12-31 16:00:04.12	15601.0	1419034476	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+49.0	NULL	NULL	1969-12-31 16:00:05.369	-200.0	1700360415	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+49.0	NULL	NULL	1969-12-31 16:00:08.726	-200.0	1233260108	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+49.0	NULL	NULL	1969-12-31 16:00:10.173	15601.0	172978219	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+49.0	NULL	NULL	1969-12-31 16:00:12.006	-7196.0	1143654535	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+49.0	NULL	NULL	1969-12-31 16:00:13.879	-7196.0	796009413	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+50.0	NULL	NULL	1969-12-31 15:59:44.235	15601.0	1492034515	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+50.0	NULL	NULL	1969-12-31 15:59:54.103	-200.0	2126656350	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+50.0	NULL	NULL	1969-12-31 15:59:55.491	-200.0	820068105	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+50.0	NULL	NULL	1969-12-31 15:59:57.847	-200.0	1819421386	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+50.0	NULL	NULL	1969-12-31 16:00:00.022	-7196.0	1241181208	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+50.0	NULL	NULL	1969-12-31 16:00:04.228	-200.0	977627069	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+50.0	NULL	NULL	1969-12-31 16:00:05.051	-7196.0	114074001	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+50.0	NULL	NULL	1969-12-31 16:00:06.371	-7196.0	1278879719	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+50.0	NULL	NULL	1969-12-31 16:00:08.38	-7196.0	1192295669	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+50.0	NULL	NULL	1969-12-31 16:00:09.965	15601.0	1278766496	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+50.0	NULL	NULL	1969-12-31 16:00:10.654	15601.0	1055873342	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+51.0	NULL	NULL	1969-12-31 15:59:49.479	15601.0	870739658	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+51.0	NULL	NULL	1969-12-31 15:59:50.363	-7196.0	1825079468	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+51.0	NULL	NULL	1969-12-31 15:59:50.675	-200.0	1403895734	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+51.0	NULL	NULL	1969-12-31 15:59:58.171	-7196.0	1289268469	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+51.0	NULL	NULL	1969-12-31 16:00:00.147	-200.0	908074420	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+51.0	NULL	NULL	1969-12-31 16:00:06.906	-7196.0	1257482423	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+51.0	NULL	NULL	1969-12-31 16:00:08.063	-200.0	194106296	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+51.0	NULL	NULL	1969-12-31 16:00:10.321	-7196.0	1836737728	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+51.0	NULL	NULL	1969-12-31 16:00:15.668	-7196.0	2091591361	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+52.0	NULL	NULL	1969-12-31 15:59:46.681	-7196.0	1070947931	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+52.0	NULL	NULL	1969-12-31 15:59:47.921	-200.0	505653702	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+52.0	NULL	NULL	1969-12-31 15:59:48.54	-7196.0	1495620354	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+52.0	NULL	NULL	1969-12-31 15:59:48.688	-7196.0	649946996	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+52.0	NULL	NULL	1969-12-31 15:59:49.565	-7196.0	1198121662	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+52.0	NULL	NULL	1969-12-31 15:59:53.671	-200.0	643105282	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+52.0	NULL	NULL	1969-12-31 15:59:54.179	15601.0	113813447	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+52.0	NULL	NULL	1969-12-31 15:59:54.524	15601.0	1551262646	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+52.0	NULL	NULL	1969-12-31 15:59:54.886	-200.0	2029007949	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+52.0	NULL	NULL	1969-12-31 15:59:58.309	-7196.0	1735974184	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+52.0	NULL	NULL	1969-12-31 16:00:02.269	-200.0	2035546169	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+52.0	NULL	NULL	1969-12-31 16:00:04.024	-200.0	741404204	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+53.0	NULL	NULL	1969-12-31 15:59:44.556	15601.0	1556590849	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+53.0	NULL	NULL	1969-12-31 15:59:50.996	-7196.0	1897312309	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+53.0	NULL	NULL	1969-12-31 15:59:54.143	-7196.0	1277748931	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+53.0	NULL	NULL	1969-12-31 15:59:55.064	-200.0	801413772	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+53.0	NULL	NULL	1969-12-31 15:59:56.913	15601.0	2049798602	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+53.0	NULL	NULL	1969-12-31 16:00:00.557	-7196.0	1366995402	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+53.0	NULL	NULL	1969-12-31 16:00:02.966	-7196.0	332635492	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+53.0	NULL	NULL	1969-12-31 16:00:15.223	15601.0	613322929	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+54.0	NULL	NULL	1969-12-31 15:59:44.646	-7196.0	324834827	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+54.0	NULL	NULL	1969-12-31 15:59:44.754	15601.0	1825424393	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+54.0	NULL	NULL	1969-12-31 15:59:52.405	-7196.0	1483839864	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+54.0	NULL	NULL	1969-12-31 15:59:53.886	-200.0	1838082189	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+54.0	NULL	NULL	1969-12-31 15:59:55.269	-7196.0	2142292772	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+54.0	NULL	NULL	1969-12-31 15:59:56.345	-200.0	1756261895	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+54.0	NULL	NULL	1969-12-31 15:59:57.434	-200.0	108833936	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+54.0	NULL	NULL	1969-12-31 16:00:01.841	-7196.0	59525273	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+54.0	NULL	NULL	1969-12-31 16:00:05.43	-7196.0	1826915108	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+54.0	NULL	NULL	1969-12-31 16:00:08.241	-7196.0	381343252	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+54.0	NULL	NULL	1969-12-31 16:00:10.187	-200.0	829351969	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+54.0	NULL	NULL	1969-12-31 16:00:13.128	-7196.0	1288406362	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+54.0	NULL	NULL	1969-12-31 16:00:14.808	15601.0	493058527	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+55.0	NULL	NULL	1969-12-31 15:59:51.024	-200.0	4521993	1.0	NULL	200.0	-199.0	NULL	-200.0	719229.5638999995	2363.58
+55.0	NULL	NULL	1969-12-31 15:59:51.884	-200.0	391675186	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+55.0	NULL	NULL	1969-12-31 15:59:56.568	-7196.0	468599417	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+55.0	NULL	NULL	1969-12-31 15:59:56.776	-200.0	1254338221	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+55.0	NULL	NULL	1969-12-31 16:00:00.124	15601.0	448409948	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+55.0	NULL	NULL	1969-12-31 16:00:00.805	15601.0	1386764124	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+55.0	NULL	NULL	1969-12-31 16:00:02.215	15601.0	1582500035	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+55.0	NULL	NULL	1969-12-31 16:00:03.384	15601.0	590990961	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+55.0	NULL	NULL	1969-12-31 16:00:08.191	-200.0	870390717	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+55.0	NULL	NULL	1969-12-31 16:00:10.601	-200.0	2004193196	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+55.0	NULL	NULL	1969-12-31 16:00:14.709	-200.0	529159242	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+55.0	NULL	NULL	1969-12-31 16:00:15.035	-200.0	180810790	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+56.0	NULL	NULL	1969-12-31 15:59:44.707	-7196.0	350999879	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+56.0	NULL	NULL	1969-12-31 15:59:45.198	-7196.0	131812689	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+56.0	NULL	NULL	1969-12-31 15:59:57.56	-200.0	951463637	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+56.0	NULL	NULL	1969-12-31 16:00:00.909	-7196.0	1421751268	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+56.0	NULL	NULL	1969-12-31 16:00:09.452	-200.0	1024563527	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+57.0	NULL	NULL	1969-12-31 15:59:45.591	-7196.0	1658221441	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+57.0	NULL	NULL	1969-12-31 15:59:46.195	-7196.0	157777745	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+57.0	NULL	NULL	1969-12-31 15:59:48.508	-200.0	1228278036	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+57.0	NULL	NULL	1969-12-31 15:59:51.829	15601.0	560414150	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+57.0	NULL	NULL	1969-12-31 15:59:57.154	-7196.0	1073635983	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+57.0	NULL	NULL	1969-12-31 15:59:58.455	-200.0	735056642	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+57.0	NULL	NULL	1969-12-31 16:00:00.363	-200.0	1330662545	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+57.0	NULL	NULL	1969-12-31 16:00:01.811	-7196.0	1371995065	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+57.0	NULL	NULL	1969-12-31 16:00:03.066	-200.0	1240619294	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+57.0	NULL	NULL	1969-12-31 16:00:04.254	15601.0	761877407	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+57.0	NULL	NULL	1969-12-31 16:00:07.361	-7196.0	418917539	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+57.0	NULL	NULL	1969-12-31 16:00:07.907	-7196.0	1200709486	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+57.0	NULL	NULL	1969-12-31 16:00:09.441	-7196.0	632897807	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+57.0	NULL	NULL	1969-12-31 16:00:12.523	-7196.0	118933574	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+57.0	NULL	NULL	1969-12-31 16:00:14.011	15601.0	1913333647	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+57.0	NULL	NULL	1969-12-31 16:00:14.076	-200.0	1614623727	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+57.0	NULL	NULL	1969-12-31 16:00:15.76	-7196.0	2018251685	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+58.0	NULL	NULL	1969-12-31 15:59:45.489	-200.0	1300104054	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+58.0	NULL	NULL	1969-12-31 15:59:46.056	15601.0	235428680	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+58.0	NULL	NULL	1969-12-31 15:59:48.244	15601.0	805666814	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+58.0	NULL	NULL	1969-12-31 15:59:56.527	15601.0	1575089695	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+58.0	NULL	NULL	1969-12-31 16:00:12.924	15601.0	300682807	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+58.0	NULL	NULL	1969-12-31 16:00:13.801	-200.0	1354169877	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+58.0	NULL	NULL	1969-12-31 16:00:14.013	-7196.0	1864202979	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+59.0	NULL	NULL	1969-12-31 15:59:44.549	-200.0	188494759	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+59.0	NULL	NULL	1969-12-31 15:59:44.942	-7196.0	1482384994	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+59.0	NULL	NULL	1969-12-31 15:59:45.08	15601.0	701594431	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+59.0	NULL	NULL	1969-12-31 15:59:48.363	15601.0	2109726979	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+59.0	NULL	NULL	1969-12-31 15:59:50.306	-200.0	771123694	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+59.0	NULL	NULL	1969-12-31 15:59:51.265	15601.0	1762456014	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+59.0	NULL	NULL	1969-12-31 15:59:51.675	-7196.0	887031443	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+59.0	NULL	NULL	1969-12-31 16:00:00.551	-7196.0	854892886	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+59.0	NULL	NULL	1969-12-31 16:00:00.738	-200.0	455272113	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+59.0	NULL	NULL	1969-12-31 16:00:01.496	-200.0	1751846592	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+59.0	NULL	NULL	1969-12-31 16:00:04.284	15601.0	1841882240	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+59.0	NULL	NULL	1969-12-31 16:00:04.476	15601.0	617599316	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+59.0	NULL	NULL	1969-12-31 16:00:05.13	-200.0	661665098	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+59.0	NULL	NULL	1969-12-31 16:00:09.343	15601.0	850073759	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+59.0	NULL	NULL	1969-12-31 16:00:12.325	15601.0	1786184100	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+59.0	NULL	NULL	1969-12-31 16:00:15.05	15601.0	1129363554	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+60.0	NULL	NULL	1969-12-31 15:59:46.085	15601.0	1428011023	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+60.0	NULL	NULL	1969-12-31 15:59:48.771	-200.0	1026483347	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+60.0	NULL	NULL	1969-12-31 15:59:51.342	-200.0	1981140540	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+60.0	NULL	NULL	1969-12-31 15:59:53.139	-7196.0	1395377862	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+60.0	NULL	NULL	1969-12-31 15:59:53.274	-200.0	190449983	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+60.0	NULL	NULL	1969-12-31 15:59:55.035	-200.0	1810792403	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+60.0	NULL	NULL	1969-12-31 16:00:05.691	15601.0	1480022657	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+60.0	NULL	NULL	1969-12-31 16:00:06.811	-200.0	733796430	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+60.0	NULL	NULL	1969-12-31 16:00:13.71	-7196.0	1067519794	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+61.0	NULL	NULL	1969-12-31 15:59:44.836	-7196.0	1003317046	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+61.0	NULL	NULL	1969-12-31 15:59:44.877	-7196.0	1661971	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	1453360.5638999995	-4632.42
+61.0	NULL	NULL	1969-12-31 15:59:45.97	-200.0	1333492663	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+61.0	NULL	NULL	1969-12-31 15:59:49.195	-200.0	1478237866	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+61.0	NULL	NULL	1969-12-31 15:59:50.861	-7196.0	1596693466	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+61.0	NULL	NULL	1969-12-31 15:59:56.14	-200.0	1648986748	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+61.0	NULL	NULL	1969-12-31 15:59:56.929	-200.0	1198240264	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+61.0	NULL	NULL	1969-12-31 16:00:01.505	-200.0	657304547	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+61.0	NULL	NULL	1969-12-31 16:00:05.697	15601.0	1755717265	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+61.0	NULL	NULL	1969-12-31 16:00:09.251	-7196.0	1429349855	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+61.0	NULL	NULL	1969-12-31 16:00:11.132	-7196.0	1652808422	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+61.0	NULL	NULL	1969-12-31 16:00:13.868	-7196.0	1875242301	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+61.0	NULL	NULL	1969-12-31 16:00:15.143	-7196.0	838733994	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+62.0	NULL	NULL	1969-12-31 15:59:46.338	-200.0	175991222	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+62.0	NULL	NULL	1969-12-31 15:59:48.734	-7196.0	1602156586	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+62.0	NULL	NULL	1969-12-31 15:59:49.053	-200.0	1277284867	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+62.0	NULL	NULL	1969-12-31 15:59:54.116	15601.0	158194463	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+62.0	NULL	NULL	1969-12-31 15:59:54.256	-7196.0	524247756	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+62.0	NULL	NULL	1969-12-31 15:59:54.762	-200.0	1011458748	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+62.0	NULL	NULL	1969-12-31 16:00:02.38	-7196.0	1733885960	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+62.0	NULL	NULL	1969-12-31 16:00:04.967	-200.0	988888	1.0	NULL	200.0	-199.0	NULL	-200.0	863223.5638999995	2363.58
+62.0	NULL	NULL	1969-12-31 16:00:07.828	-200.0	1801868132	1.0	NULL	200.0	-199.0	NULL	-200.0	9763215.5639	2363.58
+62.0	NULL	NULL	1969-12-31 16:00:10.51	15601.0	1815385311	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+62.0	NULL	NULL	1969-12-31 16:00:12.36	-7196.0	176172843	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+62.0	NULL	NULL	1969-12-31 16:00:12.762	-7196.0	1034824629	1.0	NULL	7196.0	-7195.0	NULL	-7196.0	9763215.5639	-4632.42
+62.0	NULL	NULL	1969-12-31 16:00:14.982	15601.0	107241980	1.0	NULL	-15601.0	15602.0	NULL	15601.0	9763215.5639	18164.58
+79.553	NULL	NULL	1969-12-31 16:00:00.761	-7196.0	514550698	2.410697012236624	NULL	7196.0	-7193.589302987763	NULL	-7196.0	9763215.5639	-4632.42

http://git-wip-us.apache.org/repos/asf/hive/blob/63deec40/ql/src/test/results/clientpositive/spark/vectorization_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorization_2.q.out b/ql/src/test/results/clientpositive/spark/vectorization_2.q.out
index 709a75f..e9df371 100644
--- a/ql/src/test/results/clientpositive/spark/vectorization_2.q.out
+++ b/ql/src/test/results/clientpositive/spark/vectorization_2.q.out
@@ -1,4 +1,6 @@
-PREHOOK: query: SELECT AVG(csmallint),
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT AVG(csmallint),
        (AVG(csmallint) % -563),
        (AVG(csmallint) + 762),
        SUM(cfloat),
@@ -22,7 +24,9 @@ WHERE  (((ctimestamp1 < ctimestamp2)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT AVG(csmallint),
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT AVG(csmallint),
        (AVG(csmallint) % -563),
        (AVG(csmallint) + 762),
        SUM(cfloat),

http://git-wip-us.apache.org/repos/asf/hive/blob/63deec40/ql/src/test/results/clientpositive/spark/vectorization_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorization_3.q.out b/ql/src/test/results/clientpositive/spark/vectorization_3.q.out
index d797835..a9aba5f 100644
--- a/ql/src/test/results/clientpositive/spark/vectorization_3.q.out
+++ b/ql/src/test/results/clientpositive/spark/vectorization_3.q.out
@@ -1,6 +1,8 @@
 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 STDDEV_SAMP(csmallint),
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT STDDEV_SAMP(csmallint),
        (STDDEV_SAMP(csmallint) - 10.175),
        STDDEV_POP(ctinyint),
        (STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)),
@@ -26,7 +28,9 @@ WHERE  (((cint <= cfloat)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT STDDEV_SAMP(csmallint),
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT STDDEV_SAMP(csmallint),
        (STDDEV_SAMP(csmallint) - 10.175),
        STDDEV_POP(ctinyint),
        (STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)),

http://git-wip-us.apache.org/repos/asf/hive/blob/63deec40/ql/src/test/results/clientpositive/spark/vectorization_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorization_4.q.out b/ql/src/test/results/clientpositive/spark/vectorization_4.q.out
index 0d6829f..0181588 100644
--- a/ql/src/test/results/clientpositive/spark/vectorization_4.q.out
+++ b/ql/src/test/results/clientpositive/spark/vectorization_4.q.out
@@ -1,4 +1,6 @@
-PREHOOK: query: SELECT SUM(cint),
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT SUM(cint),
        (SUM(cint) * -563),
        (-3728 + SUM(cint)),
        STDDEV_POP(cdouble),
@@ -22,7 +24,9 @@ WHERE  (((csmallint >= cint)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT SUM(cint),
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT SUM(cint),
        (SUM(cint) * -563),
        (-3728 + SUM(cint)),
        STDDEV_POP(cdouble),

http://git-wip-us.apache.org/repos/asf/hive/blob/63deec40/ql/src/test/results/clientpositive/spark/vectorization_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorization_5.q.out b/ql/src/test/results/clientpositive/spark/vectorization_5.q.out
index 914a626..f661fc3 100644
--- a/ql/src/test/results/clientpositive/spark/vectorization_5.q.out
+++ b/ql/src/test/results/clientpositive/spark/vectorization_5.q.out
@@ -1,4 +1,6 @@
-PREHOOK: query: SELECT MAX(csmallint),
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT MAX(csmallint),
        (MAX(csmallint) * -75),
        COUNT(*),
        ((MAX(csmallint) * -75) / COUNT(*)),
@@ -19,7 +21,9 @@ WHERE  (((cboolean2 IS NOT NULL)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT MAX(csmallint),
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+SELECT MAX(csmallint),
        (MAX(csmallint) * -75),
        COUNT(*),
        ((MAX(csmallint) * -75) / COUNT(*)),


Mime
View raw message