You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/10/23 17:15:14 UTC
svn commit: r1535055 [14/14] - in /hive/trunk:
ant/src/org/apache/hadoop/hive/ant/
ql/src/gen/vectorization/ExpressionTemplates/
ql/src/gen/vectorization/TestTemplates/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/e...
Added: hive/trunk/ql/src/test/results/clientpositive/vectorization_9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_9.q.out?rev=1535055&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_9.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_9.q.out Wed Oct 23 15:15:11 2013
@@ -0,0 +1,405 @@
+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 ####
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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 16:00:12.36 -7196.0 176172843 1.0 NULL 7196.0 -7195.0 NULL -7196.0 9763215.5639 -4632.42
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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 16:00:01.122 15601.0 345989051 1.0 NULL -15601.0 15602.0 NULL 15601.0 9763215.5639 18164.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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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 16:00:08.408 -200.0 696650264 1.0 NULL 200.0 -199.0 NULL -200.0 9763215.5639 2363.58
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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:06.529 15601.0 847428763 1.0 NULL -15601.0 15602.0 NULL 15601.0 9763215.5639 18164.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:00.551 -7196.0 854892886 1.0 NULL 7196.0 -7195.0 NULL -7196.0 9763215.5639 -4632.42
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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 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 16:00:00.754 -7196.0 1237005923 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
+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
+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
+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
+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:11.309 15601.0 1251122304 1.0 NULL -15601.0 15602.0 NULL 15601.0 9763215.5639 18164.58
+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
+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
+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
+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
+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 15:59:45.686 15601.0 1273900453 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
+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
+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
+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:06.371 -7196.0 1278879719 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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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 16:00:11.132 -7196.0 1652808422 1.0 NULL 7196.0 -7195.0 NULL -7196.0 9763215.5639 -4632.42
+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
+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
+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
+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 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: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 16:00:01.128 -200.0 1720947024 1.0 NULL 200.0 -199.0 NULL -200.0 9763215.5639 2363.58
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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 16:00:05.43 -7196.0 1826915108 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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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 16:00:14.648 15601.0 1927566094 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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
Added: hive/trunk/ql/src/test/results/clientpositive/vectorization_not.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_not.q.out?rev=1535055&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_not.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_not.q.out Wed Oct 23 15:15:11 2013
@@ -0,0 +1,58 @@
+WARNING: Comparing a bigint and a double may result in a loss of precision.
+PREHOOK: query: SELECT AVG(cbigint),
+ (-(AVG(cbigint))),
+ (-6432 + AVG(cbigint)),
+ STDDEV_POP(cbigint),
+ (-((-6432 + AVG(cbigint)))),
+ ((-((-6432 + AVG(cbigint)))) + (-6432 + AVG(cbigint))),
+ VAR_SAMP(cbigint),
+ (-((-6432 + AVG(cbigint)))),
+ (-6432 + (-((-6432 + AVG(cbigint))))),
+ (-((-6432 + AVG(cbigint)))),
+ ((-((-6432 + AVG(cbigint)))) / (-((-6432 + AVG(cbigint))))),
+ COUNT(*),
+ SUM(cfloat),
+ (VAR_SAMP(cbigint) % STDDEV_POP(cbigint)),
+ (-(VAR_SAMP(cbigint))),
+ ((-((-6432 + AVG(cbigint)))) * (-(AVG(cbigint)))),
+ MIN(ctinyint),
+ (-(MIN(ctinyint)))
+FROM alltypesorc
+WHERE (((cstring2 LIKE '%b%')
+ OR ((79.553 != cint)
+ OR (NOT(cbigint >= cdouble))))
+ OR ((ctinyint >= csmallint)
+ AND (NOT ((cboolean2 != 1)
+ OR (3569 != ctinyint)))))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT AVG(cbigint),
+ (-(AVG(cbigint))),
+ (-6432 + AVG(cbigint)),
+ STDDEV_POP(cbigint),
+ (-((-6432 + AVG(cbigint)))),
+ ((-((-6432 + AVG(cbigint)))) + (-6432 + AVG(cbigint))),
+ VAR_SAMP(cbigint),
+ (-((-6432 + AVG(cbigint)))),
+ (-6432 + (-((-6432 + AVG(cbigint))))),
+ (-((-6432 + AVG(cbigint)))),
+ ((-((-6432 + AVG(cbigint)))) / (-((-6432 + AVG(cbigint))))),
+ COUNT(*),
+ SUM(cfloat),
+ (VAR_SAMP(cbigint) % STDDEV_POP(cbigint)),
+ (-(VAR_SAMP(cbigint))),
+ ((-((-6432 + AVG(cbigint)))) * (-(AVG(cbigint)))),
+ MIN(ctinyint),
+ (-(MIN(ctinyint)))
+FROM alltypesorc
+WHERE (((cstring2 LIKE '%b%')
+ OR ((79.553 != cint)
+ OR (NOT(cbigint >= cdouble))))
+ OR ((ctinyint >= csmallint)
+ AND (NOT ((cboolean2 != 1)
+ OR (3569 != ctinyint)))))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+-3.875652215945533E8 3.875652215945533E8 -3.875716535945533E8 1.436387455459401E9 3.875716535945533E8 0.0 2.06347151720204902E18 3.875716535945533E8 3.875652215945533E8 3.875716535945533E8 1.0 10934 -37224.52399241924 1.0517370547117279E9 -2.06347151720204902E18 1.5020929380914048E17 -64 64