hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject 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...
Date Wed, 23 Oct 2013 15:15:14 GMT
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



Mime
View raw message