Return-Path: X-Original-To: apmail-hive-commits-archive@www.apache.org Delivered-To: apmail-hive-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B831917FD2 for ; Thu, 25 Jun 2015 04:22:43 +0000 (UTC) Received: (qmail 61005 invoked by uid 500); 25 Jun 2015 04:22:41 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 60895 invoked by uid 500); 25 Jun 2015 04:22:41 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 59240 invoked by uid 99); 25 Jun 2015 04:22:40 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Jun 2015 04:22:40 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 266FAE3656; Thu, 25 Jun 2015 04:22:40 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: gunther@apache.org To: commits@hive.apache.org Date: Thu, 25 Jun 2015 04:23:04 -0000 Message-Id: In-Reply-To: <9b3a1833cf9543a5b2d5c710d738e1e5@git.apache.org> References: <9b3a1833cf9543a5b2d5c710d738e1e5@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [26/31] hive git commit: HIVE-11090: ordering issues with windows unit test runs (Matt McCline via Gunther Hagleitner) http://git-wip-us.apache.org/repos/asf/hive/blob/440c91c9/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 960a058..16625b0 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/440c91c9/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/440c91c9/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/440c91c9/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/440c91c9/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/440c91c9/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(*)),