hive-commits mailing list archives

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

http://git-wip-us.apache.org/repos/asf/hive/blob/a5d5473f/ql/src/test/results/clientpositive/parquet_vectorization_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_vectorization_2.q.out b/ql/src/test/results/clientpositive/parquet_vectorization_2.q.out
deleted file mode 100644
index ebef240..0000000
--- a/ql/src/test/results/clientpositive/parquet_vectorization_2.q.out
+++ /dev/null
@@ -1,193 +0,0 @@
-PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT AVG(csmallint),
-       (AVG(csmallint) % -563),
-       (AVG(csmallint) + 762),
-       SUM(cfloat),
-       VAR_POP(cbigint),
-       (-(VAR_POP(cbigint))),
-       (SUM(cfloat) - AVG(csmallint)),
-       COUNT(*),
-       (-((SUM(cfloat) - AVG(csmallint)))),
-       (VAR_POP(cbigint) - 762),
-       MIN(ctinyint),
-       ((-(VAR_POP(cbigint))) + MIN(ctinyint)),
-       AVG(cdouble),
-       (((-(VAR_POP(cbigint))) + MIN(ctinyint)) - SUM(cfloat))
-FROM   alltypesparquet
-WHERE  (((ctimestamp1 < ctimestamp2)
-         AND ((cstring2 LIKE 'b%')
-              AND (cfloat <= -5638.15)))
-        OR ((cdouble < ctinyint)
-            AND ((-10669 != ctimestamp2)
-                 OR (359 > cint))))
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT AVG(csmallint),
-       (AVG(csmallint) % -563),
-       (AVG(csmallint) + 762),
-       SUM(cfloat),
-       VAR_POP(cbigint),
-       (-(VAR_POP(cbigint))),
-       (SUM(cfloat) - AVG(csmallint)),
-       COUNT(*),
-       (-((SUM(cfloat) - AVG(csmallint)))),
-       (VAR_POP(cbigint) - 762),
-       MIN(ctinyint),
-       ((-(VAR_POP(cbigint))) + MIN(ctinyint)),
-       AVG(cdouble),
-       (((-(VAR_POP(cbigint))) + MIN(ctinyint)) - SUM(cfloat))
-FROM   alltypesparquet
-WHERE  (((ctimestamp1 < ctimestamp2)
-         AND ((cstring2 LIKE 'b%')
-              AND (cfloat <= -5638.15)))
-        OR ((cdouble < ctinyint)
-            AND ((-10669 != ctimestamp2)
-                 OR (359 > cint))))
-POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
-  enabled: true
-  enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: alltypesparquet
-            Statistics: Num rows: 12288 Data size: 147456 Basic stats: COMPLETE Column stats: NONE
-            TableScan Vectorization:
-                native: true
-                vectorizationSchemaColumns: [0:ctinyint:tinyint, 1:csmallint:smallint, 2:cint:int, 3:cbigint:bigint, 4:cfloat:float, 5:cdouble:double, 6:cstring1:string, 7:cstring2:string, 8:ctimestamp1:timestamp, 9:ctimestamp2:timestamp, 10:cboolean1:boolean, 11:cboolean2:boolean, 12:ROW__ID:struct<transactionid:bigint,bucketid:int,rowid:bigint>]
-            Filter Operator
-              Filter Vectorization:
-                  className: VectorFilterOperator
-                  native: true
-                  predicateExpression: FilterExprOrExpr(children: FilterExprAndExpr(children: FilterTimestampColLessTimestampColumn(col 8:timestamp, col 9:timestamp), FilterStringColLikeStringScalar(col 7:string, pattern b%), FilterDoubleColLessEqualDoubleScalar(col 4:float, val -5638.14990234375)), FilterExprAndExpr(children: FilterDoubleColLessDoubleColumn(col 5:double, col 13:double)(children: CastLongToDouble(col 0:tinyint) -> 13:double), FilterExprOrExpr(children: FilterDoubleScalarNotEqualDoubleColumn(val -10669.0, col 13:double)(children: CastTimestampToDouble(col 9:timestamp) -> 13:double), FilterLongScalarGreaterLongColumn(val 359, col 2:int))))
-              predicate: (((cdouble < UDFToDouble(ctinyint)) and ((-10669.0 <> UDFToDouble(ctimestamp2)) or (359 > cint))) or ((ctimestamp1 < ctimestamp2) and (cstring2 like 'b%') and (cfloat <= -5638.15))) (type: boolean)
-              Statistics: Num rows: 4778 Data size: 57336 Basic stats: COMPLETE Column stats: NONE
-              Select Operator
-                expressions: ctinyint (type: tinyint), csmallint (type: smallint), cbigint (type: bigint), cfloat (type: float), cdouble (type: double)
-                outputColumnNames: ctinyint, csmallint, cbigint, cfloat, cdouble
-                Select Vectorization:
-                    className: VectorSelectOperator
-                    native: true
-                    projectedOutputColumnNums: [0, 1, 3, 4, 5]
-                Statistics: Num rows: 4778 Data size: 57336 Basic stats: COMPLETE Column stats: NONE
-                Group By Operator
-                  aggregations: avg(csmallint), sum(cfloat), var_pop(cbigint), count(), min(ctinyint), avg(cdouble)
-                  Group By Vectorization:
-                      aggregators: VectorUDAFAvgLong(col 1:smallint) -> struct<count:bigint,sum:double,input:smallint>, VectorUDAFSumDouble(col 4:float) -> double, VectorUDAFVarLong(col 3:bigint) -> struct<count:bigint,sum:double,variance:double> aggregation: var_pop, VectorUDAFCountStar(*) -> bigint, VectorUDAFMinLong(col 0:tinyint) -> tinyint, VectorUDAFAvgDouble(col 5:double) -> struct<count:bigint,sum:double,input:double>
-                      className: VectorGroupByOperator
-                      groupByMode: HASH
-                      native: false
-                      vectorProcessingMode: HASH
-                      projectedOutputColumnNums: [0, 1, 2, 3, 4, 5]
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                  Statistics: Num rows: 1 Data size: 256 Basic stats: COMPLETE Column stats: NONE
-                  Reduce Output Operator
-                    sort order: 
-                    Reduce Sink Vectorization:
-                        className: VectorReduceSinkOperator
-                        native: false
-                        nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
-                        nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
-                    Statistics: Num rows: 1 Data size: 256 Basic stats: COMPLETE Column stats: NONE
-                    value expressions: _col0 (type: struct<count:bigint,sum:double,input:smallint>), _col1 (type: double), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: bigint), _col4 (type: tinyint), _col5 (type: struct<count:bigint,sum:double,input:double>)
-      Execution mode: vectorized
-      Map Vectorization:
-          enabled: true
-          enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
-          inputFormatFeatureSupport: []
-          featureSupportInUse: []
-          inputFileFormats: org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
-          allNative: false
-          usesVectorUDFAdaptor: false
-          vectorized: true
-          rowBatchContext:
-              dataColumnCount: 12
-              includeColumns: [0, 1, 2, 3, 4, 5, 7, 8, 9]
-              dataColumns: ctinyint:tinyint, csmallint:smallint, cint:int, cbigint:bigint, cfloat:float, cdouble:double, cstring1:string, cstring2:string, ctimestamp1:timestamp, ctimestamp2:timestamp, cboolean1:boolean, cboolean2:boolean
-              partitionColumnCount: 0
-              scratchColumnTypeNames: [double]
-      Reduce Vectorization:
-          enabled: false
-          enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true
-          enableConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: avg(VALUE._col0), sum(VALUE._col1), var_pop(VALUE._col2), count(VALUE._col3), min(VALUE._col4), avg(VALUE._col5)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-          Statistics: Num rows: 1 Data size: 256 Basic stats: COMPLETE Column stats: NONE
-          Select Operator
-            expressions: _col0 (type: double), (_col0 % -563.0) (type: double), (_col0 + 762.0) (type: double), _col1 (type: double), _col2 (type: double), (- _col2) (type: double), (_col1 - _col0) (type: double), _col3 (type: bigint), (- (_col1 - _col0)) (type: double), (_col2 - 762.0) (type: double), _col4 (type: tinyint), ((- _col2) + UDFToDouble(_col4)) (type: double), _col5 (type: double), (((- _col2) + UDFToDouble(_col4)) - _col1) (type: double)
-            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
-            Statistics: Num rows: 1 Data size: 256 Basic stats: COMPLETE Column stats: NONE
-            File Output Operator
-              compressed: false
-              Statistics: Num rows: 1 Data size: 256 Basic stats: COMPLETE Column stats: NONE
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: SELECT AVG(csmallint),
-       (AVG(csmallint) % -563),
-       (AVG(csmallint) + 762),
-       SUM(cfloat),
-       VAR_POP(cbigint),
-       (-(VAR_POP(cbigint))),
-       (SUM(cfloat) - AVG(csmallint)),
-       COUNT(*),
-       (-((SUM(cfloat) - AVG(csmallint)))),
-       (VAR_POP(cbigint) - 762),
-       MIN(ctinyint),
-       ((-(VAR_POP(cbigint))) + MIN(ctinyint)),
-       AVG(cdouble),
-       (((-(VAR_POP(cbigint))) + MIN(ctinyint)) - SUM(cfloat))
-FROM   alltypesparquet
-WHERE  (((ctimestamp1 < ctimestamp2)
-         AND ((cstring2 LIKE 'b%')
-              AND (cfloat <= -5638.15)))
-        OR ((cdouble < ctinyint)
-            AND ((-10669 != ctimestamp2)
-                 OR (359 > cint))))
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT AVG(csmallint),
-       (AVG(csmallint) % -563),
-       (AVG(csmallint) + 762),
-       SUM(cfloat),
-       VAR_POP(cbigint),
-       (-(VAR_POP(cbigint))),
-       (SUM(cfloat) - AVG(csmallint)),
-       COUNT(*),
-       (-((SUM(cfloat) - AVG(csmallint)))),
-       (VAR_POP(cbigint) - 762),
-       MIN(ctinyint),
-       ((-(VAR_POP(cbigint))) + MIN(ctinyint)),
-       AVG(cdouble),
-       (((-(VAR_POP(cbigint))) + MIN(ctinyint)) - SUM(cfloat))
-FROM   alltypesparquet
-WHERE  (((ctimestamp1 < ctimestamp2)
-         AND ((cstring2 LIKE 'b%')
-              AND (cfloat <= -5638.15)))
-        OR ((cdouble < ctinyint)
-            AND ((-10669 != ctimestamp2)
-                 OR (359 > cint))))
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
--5646.467075892857	-16.467075892856883	-4884.467075892857	-2839.634998679161	1.49936299222378778E18	-1.49936299222378778E18	2806.832077213696	3584	-2806.832077213696	1.49936299222378701E18	-64	-1.49936299222378778E18	-5650.1297631138395	-1.49936299222378496E18

http://git-wip-us.apache.org/repos/asf/hive/blob/a5d5473f/ql/src/test/results/clientpositive/parquet_vectorization_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_vectorization_3.q.out b/ql/src/test/results/clientpositive/parquet_vectorization_3.q.out
deleted file mode 100644
index 2abe821..0000000
--- a/ql/src/test/results/clientpositive/parquet_vectorization_3.q.out
+++ /dev/null
@@ -1,203 +0,0 @@
-WARNING: Comparing a bigint and a double may result in a loss of precision.
-PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT STDDEV_SAMP(csmallint),
-       (STDDEV_SAMP(csmallint) - 10.175),
-       STDDEV_POP(ctinyint),
-       (STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)),
-       (-(STDDEV_POP(ctinyint))),
-       (STDDEV_SAMP(csmallint) % 79.553),
-       (-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))),
-       STDDEV_SAMP(cfloat),
-       (-(STDDEV_SAMP(csmallint))),
-       SUM(cfloat),
-       ((-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))) / (STDDEV_SAMP(csmallint) - 10.175)),
-       (-((STDDEV_SAMP(csmallint) - 10.175))),
-       AVG(cint),
-       (-3728 - STDDEV_SAMP(csmallint)),
-       STDDEV_POP(cint),
-       (AVG(cint) / STDDEV_SAMP(cfloat))
-FROM   alltypesparquet
-WHERE  (((cint <= cfloat)
-         AND ((79.553 != cbigint)
-              AND (ctimestamp2 = -29071)))
-        OR ((cbigint > cdouble)
-            AND ((79.553 <= csmallint)
-                 AND (ctimestamp1 > ctimestamp2))))
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT STDDEV_SAMP(csmallint),
-       (STDDEV_SAMP(csmallint) - 10.175),
-       STDDEV_POP(ctinyint),
-       (STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)),
-       (-(STDDEV_POP(ctinyint))),
-       (STDDEV_SAMP(csmallint) % 79.553),
-       (-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))),
-       STDDEV_SAMP(cfloat),
-       (-(STDDEV_SAMP(csmallint))),
-       SUM(cfloat),
-       ((-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))) / (STDDEV_SAMP(csmallint) - 10.175)),
-       (-((STDDEV_SAMP(csmallint) - 10.175))),
-       AVG(cint),
-       (-3728 - STDDEV_SAMP(csmallint)),
-       STDDEV_POP(cint),
-       (AVG(cint) / STDDEV_SAMP(cfloat))
-FROM   alltypesparquet
-WHERE  (((cint <= cfloat)
-         AND ((79.553 != cbigint)
-              AND (ctimestamp2 = -29071)))
-        OR ((cbigint > cdouble)
-            AND ((79.553 <= csmallint)
-                 AND (ctimestamp1 > ctimestamp2))))
-POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
-  enabled: true
-  enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: alltypesparquet
-            Statistics: Num rows: 12288 Data size: 147456 Basic stats: COMPLETE Column stats: NONE
-            TableScan Vectorization:
-                native: true
-                vectorizationSchemaColumns: [0:ctinyint:tinyint, 1:csmallint:smallint, 2:cint:int, 3:cbigint:bigint, 4:cfloat:float, 5:cdouble:double, 6:cstring1:string, 7:cstring2:string, 8:ctimestamp1:timestamp, 9:ctimestamp2:timestamp, 10:cboolean1:boolean, 11:cboolean2:boolean, 12:ROW__ID:struct<transactionid:bigint,bucketid:int,rowid:bigint>]
-            Filter Operator
-              Filter Vectorization:
-                  className: VectorFilterOperator
-                  native: true
-                  predicateExpression: FilterExprOrExpr(children: FilterExprAndExpr(children: FilterDoubleColLessEqualDoubleColumn(col 13:float, col 4:float)(children: CastLongToFloatViaLongToDouble(col 2:int) -> 13:float), FilterDecimalScalarNotEqualDecimalColumn(val 79.553, col 14:decimal(22,3))(children: CastLongToDecimal(col 3:bigint) -> 14:decimal(22,3)), FilterDoubleColEqualDoubleScalar(col 13:double, val -29071.0)(children: CastTimestampToDouble(col 9:timestamp) -> 13:double)), FilterExprAndExpr(children: FilterDoubleColGreaterDoubleColumn(col 13:double, col 5:double)(children: CastLongToDouble(col 3:bigint) -> 13:double), FilterDecimalScalarLessEqualDecimalColumn(val 79.553, col 15:decimal(8,3))(children: CastLongToDecimal(col 1:smallint) -> 15:decimal(8,3)), FilterTimestampColGreaterTimestampColumn(col 8:timestamp, col 9:timestamp)))
-              predicate: (((UDFToDouble(cbigint) > cdouble) and (79.553 <= CAST( csmallint AS decimal(8,3))) and (ctimestamp1 > ctimestamp2)) or ((UDFToFloat(cint) <= cfloat) and (79.553 <> CAST( cbigint AS decimal(22,3))) and (UDFToDouble(ctimestamp2) = -29071.0))) (type: boolean)
-              Statistics: Num rows: 2503 Data size: 30036 Basic stats: COMPLETE Column stats: NONE
-              Select Operator
-                expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cfloat (type: float)
-                outputColumnNames: ctinyint, csmallint, cint, cfloat
-                Select Vectorization:
-                    className: VectorSelectOperator
-                    native: true
-                    projectedOutputColumnNums: [0, 1, 2, 4]
-                Statistics: Num rows: 2503 Data size: 30036 Basic stats: COMPLETE Column stats: NONE
-                Group By Operator
-                  aggregations: stddev_samp(csmallint), stddev_pop(ctinyint), stddev_samp(cfloat), sum(cfloat), avg(cint), stddev_pop(cint)
-                  Group By Vectorization:
-                      aggregators: VectorUDAFVarLong(col 1:smallint) -> struct<count:bigint,sum:double,variance:double> aggregation: stddev_samp, VectorUDAFVarLong(col 0:tinyint) -> struct<count:bigint,sum:double,variance:double> aggregation: stddev_pop, VectorUDAFVarDouble(col 4:float) -> struct<count:bigint,sum:double,variance:double> aggregation: stddev_samp, VectorUDAFSumDouble(col 4:float) -> double, VectorUDAFAvgLong(col 2:int) -> struct<count:bigint,sum:double,input:int>, VectorUDAFVarLong(col 2:int) -> struct<count:bigint,sum:double,variance:double> aggregation: stddev_pop
-                      className: VectorGroupByOperator
-                      groupByMode: HASH
-                      native: false
-                      vectorProcessingMode: HASH
-                      projectedOutputColumnNums: [0, 1, 2, 3, 4, 5]
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                  Statistics: Num rows: 1 Data size: 404 Basic stats: COMPLETE Column stats: NONE
-                  Reduce Output Operator
-                    sort order: 
-                    Reduce Sink Vectorization:
-                        className: VectorReduceSinkOperator
-                        native: false
-                        nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
-                        nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
-                    Statistics: Num rows: 1 Data size: 404 Basic stats: COMPLETE Column stats: NONE
-                    value expressions: _col0 (type: struct<count:bigint,sum:double,variance:double>), _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: double), _col4 (type: struct<count:bigint,sum:double,input:int>), _col5 (type: struct<count:bigint,sum:double,variance:double>)
-      Execution mode: vectorized
-      Map Vectorization:
-          enabled: true
-          enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
-          inputFormatFeatureSupport: []
-          featureSupportInUse: []
-          inputFileFormats: org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
-          allNative: false
-          usesVectorUDFAdaptor: false
-          vectorized: true
-          rowBatchContext:
-              dataColumnCount: 12
-              includeColumns: [0, 1, 2, 3, 4, 5, 8, 9]
-              dataColumns: ctinyint:tinyint, csmallint:smallint, cint:int, cbigint:bigint, cfloat:float, cdouble:double, cstring1:string, cstring2:string, ctimestamp1:timestamp, ctimestamp2:timestamp, cboolean1:boolean, cboolean2:boolean
-              partitionColumnCount: 0
-              scratchColumnTypeNames: [double, decimal(22,3), decimal(8,3)]
-      Reduce Vectorization:
-          enabled: false
-          enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true
-          enableConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: stddev_samp(VALUE._col0), stddev_pop(VALUE._col1), stddev_samp(VALUE._col2), sum(VALUE._col3), avg(VALUE._col4), stddev_pop(VALUE._col5)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-          Statistics: Num rows: 1 Data size: 404 Basic stats: COMPLETE Column stats: NONE
-          Select Operator
-            expressions: _col0 (type: double), (_col0 - 10.175) (type: double), _col1 (type: double), (_col0 * (_col0 - 10.175)) (type: double), (- _col1) (type: double), (_col0 % 79.553) (type: double), (- (_col0 * (_col0 - 10.175))) (type: double), _col2 (type: double), (- _col0) (type: double), _col3 (type: double), ((- (_col0 * (_col0 - 10.175))) / (_col0 - 10.175)) (type: double), (- (_col0 - 10.175)) (type: double), _col4 (type: double), (-3728.0 - _col0) (type: double), _col5 (type: double), (_col4 / _col2) (type: double)
-            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
-            Statistics: Num rows: 1 Data size: 404 Basic stats: COMPLETE Column stats: NONE
-            File Output Operator
-              compressed: false
-              Statistics: Num rows: 1 Data size: 404 Basic stats: COMPLETE Column stats: NONE
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-WARNING: Comparing a bigint and a double may result in a loss of precision.
-PREHOOK: query: SELECT STDDEV_SAMP(csmallint),
-       (STDDEV_SAMP(csmallint) - 10.175),
-       STDDEV_POP(ctinyint),
-       (STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)),
-       (-(STDDEV_POP(ctinyint))),
-       (STDDEV_SAMP(csmallint) % 79.553),
-       (-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))),
-       STDDEV_SAMP(cfloat),
-       (-(STDDEV_SAMP(csmallint))),
-       SUM(cfloat),
-       ((-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))) / (STDDEV_SAMP(csmallint) - 10.175)),
-       (-((STDDEV_SAMP(csmallint) - 10.175))),
-       AVG(cint),
-       (-3728 - STDDEV_SAMP(csmallint)),
-       STDDEV_POP(cint),
-       (AVG(cint) / STDDEV_SAMP(cfloat))
-FROM   alltypesparquet
-WHERE  (((cint <= cfloat)
-         AND ((79.553 != cbigint)
-              AND (ctimestamp2 = -29071)))
-        OR ((cbigint > cdouble)
-            AND ((79.553 <= csmallint)
-                 AND (ctimestamp1 > ctimestamp2))))
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT STDDEV_SAMP(csmallint),
-       (STDDEV_SAMP(csmallint) - 10.175),
-       STDDEV_POP(ctinyint),
-       (STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)),
-       (-(STDDEV_POP(ctinyint))),
-       (STDDEV_SAMP(csmallint) % 79.553),
-       (-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))),
-       STDDEV_SAMP(cfloat),
-       (-(STDDEV_SAMP(csmallint))),
-       SUM(cfloat),
-       ((-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))) / (STDDEV_SAMP(csmallint) - 10.175)),
-       (-((STDDEV_SAMP(csmallint) - 10.175))),
-       AVG(cint),
-       (-3728 - STDDEV_SAMP(csmallint)),
-       STDDEV_POP(cint),
-       (AVG(cint) / STDDEV_SAMP(cfloat))
-FROM   alltypesparquet
-WHERE  (((cint <= cfloat)
-         AND ((79.553 != cbigint)
-              AND (ctimestamp2 = -29071)))
-        OR ((cbigint > cdouble)
-            AND ((79.553 <= csmallint)
-                 AND (ctimestamp1 > ctimestamp2))))
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
-0.0	-10.175	34.287285216637066	-0.0	-34.287285216637066	0.0	0.0	34.34690095515641	-0.0	197.89499950408936	-0.0	10.175	NULL	-3728.0	NULL	NULL

http://git-wip-us.apache.org/repos/asf/hive/blob/a5d5473f/ql/src/test/results/clientpositive/parquet_vectorization_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_vectorization_4.q.out b/ql/src/test/results/clientpositive/parquet_vectorization_4.q.out
deleted file mode 100644
index 4c39858..0000000
--- a/ql/src/test/results/clientpositive/parquet_vectorization_4.q.out
+++ /dev/null
@@ -1,193 +0,0 @@
-PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT SUM(cint),
-       (SUM(cint) * -563),
-       (-3728 + SUM(cint)),
-       STDDEV_POP(cdouble),
-       (-(STDDEV_POP(cdouble))),
-       AVG(cdouble),
-       ((SUM(cint) * -563) % SUM(cint)),
-       (((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)),
-       VAR_POP(cdouble),
-       (-((((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)))),
-       ((-3728 + SUM(cint)) - (SUM(cint) * -563)),
-       MIN(ctinyint),
-       MIN(ctinyint),
-       (MIN(ctinyint) * (-((((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)))))
-FROM   alltypesparquet
-WHERE  (((csmallint >= cint)
-         OR ((-89010 >= ctinyint)
-             AND (cdouble > 79.553)))
-        OR ((-563 != cbigint)
-            AND ((ctinyint != cbigint)
-                 OR (-3728 >= cdouble))))
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT SUM(cint),
-       (SUM(cint) * -563),
-       (-3728 + SUM(cint)),
-       STDDEV_POP(cdouble),
-       (-(STDDEV_POP(cdouble))),
-       AVG(cdouble),
-       ((SUM(cint) * -563) % SUM(cint)),
-       (((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)),
-       VAR_POP(cdouble),
-       (-((((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)))),
-       ((-3728 + SUM(cint)) - (SUM(cint) * -563)),
-       MIN(ctinyint),
-       MIN(ctinyint),
-       (MIN(ctinyint) * (-((((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)))))
-FROM   alltypesparquet
-WHERE  (((csmallint >= cint)
-         OR ((-89010 >= ctinyint)
-             AND (cdouble > 79.553)))
-        OR ((-563 != cbigint)
-            AND ((ctinyint != cbigint)
-                 OR (-3728 >= cdouble))))
-POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
-  enabled: true
-  enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: alltypesparquet
-            Statistics: Num rows: 12288 Data size: 147456 Basic stats: COMPLETE Column stats: NONE
-            TableScan Vectorization:
-                native: true
-                vectorizationSchemaColumns: [0:ctinyint:tinyint, 1:csmallint:smallint, 2:cint:int, 3:cbigint:bigint, 4:cfloat:float, 5:cdouble:double, 6:cstring1:string, 7:cstring2:string, 8:ctimestamp1:timestamp, 9:ctimestamp2:timestamp, 10:cboolean1:boolean, 11:cboolean2:boolean, 12:ROW__ID:struct<transactionid:bigint,bucketid:int,rowid:bigint>]
-            Filter Operator
-              Filter Vectorization:
-                  className: VectorFilterOperator
-                  native: true
-                  predicateExpression: FilterExprOrExpr(children: FilterLongColGreaterEqualLongColumn(col 1:int, col 2:int)(children: col 1:smallint), FilterExprAndExpr(children: FilterLongScalarGreaterEqualLongColumn(val -89010, col 0:int)(children: col 0:tinyint), FilterDoubleColGreaterDoubleScalar(col 5:double, val 79.553)), FilterExprAndExpr(children: FilterLongScalarNotEqualLongColumn(val -563, col 3:bigint), FilterExprOrExpr(children: FilterLongColNotEqualLongColumn(col 0:bigint, col 3:bigint)(children: col 0:tinyint), FilterDoubleScalarGreaterEqualDoubleColumn(val -3728.0, col 5:double))))
-              predicate: (((-563 <> cbigint) and ((UDFToLong(ctinyint) <> cbigint) or (-3728.0 >= cdouble))) or ((-89010 >= UDFToInteger(ctinyint)) and (cdouble > 79.553)) or (UDFToInteger(csmallint) >= cint)) (type: boolean)
-              Statistics: Num rows: 12288 Data size: 147456 Basic stats: COMPLETE Column stats: NONE
-              Select Operator
-                expressions: ctinyint (type: tinyint), cint (type: int), cdouble (type: double)
-                outputColumnNames: ctinyint, cint, cdouble
-                Select Vectorization:
-                    className: VectorSelectOperator
-                    native: true
-                    projectedOutputColumnNums: [0, 2, 5]
-                Statistics: Num rows: 12288 Data size: 147456 Basic stats: COMPLETE Column stats: NONE
-                Group By Operator
-                  aggregations: sum(cint), stddev_pop(cdouble), avg(cdouble), var_pop(cdouble), min(ctinyint)
-                  Group By Vectorization:
-                      aggregators: VectorUDAFSumLong(col 2:int) -> bigint, VectorUDAFVarDouble(col 5:double) -> struct<count:bigint,sum:double,variance:double> aggregation: stddev_pop, VectorUDAFAvgDouble(col 5:double) -> struct<count:bigint,sum:double,input:double>, VectorUDAFVarDouble(col 5:double) -> struct<count:bigint,sum:double,variance:double> aggregation: var_pop, VectorUDAFMinLong(col 0:tinyint) -> tinyint
-                      className: VectorGroupByOperator
-                      groupByMode: HASH
-                      native: false
-                      vectorProcessingMode: HASH
-                      projectedOutputColumnNums: [0, 1, 2, 3, 4]
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2, _col3, _col4
-                  Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE
-                  Reduce Output Operator
-                    sort order: 
-                    Reduce Sink Vectorization:
-                        className: VectorReduceSinkOperator
-                        native: false
-                        nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
-                        nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
-                    Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE
-                    value expressions: _col0 (type: bigint), _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,input:double>), _col3 (type: struct<count:bigint,sum:double,variance:double>), _col4 (type: tinyint)
-      Execution mode: vectorized
-      Map Vectorization:
-          enabled: true
-          enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
-          inputFormatFeatureSupport: []
-          featureSupportInUse: []
-          inputFileFormats: org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
-          allNative: false
-          usesVectorUDFAdaptor: false
-          vectorized: true
-          rowBatchContext:
-              dataColumnCount: 12
-              includeColumns: [0, 1, 2, 3, 5]
-              dataColumns: ctinyint:tinyint, csmallint:smallint, cint:int, cbigint:bigint, cfloat:float, cdouble:double, cstring1:string, cstring2:string, ctimestamp1:timestamp, ctimestamp2:timestamp, cboolean1:boolean, cboolean2:boolean
-              partitionColumnCount: 0
-              scratchColumnTypeNames: []
-      Reduce Vectorization:
-          enabled: false
-          enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true
-          enableConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0), stddev_pop(VALUE._col1), avg(VALUE._col2), var_pop(VALUE._col3), min(VALUE._col4)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4
-          Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE
-          Select Operator
-            expressions: _col0 (type: bigint), (_col0 * -563) (type: bigint), (-3728 + _col0) (type: bigint), _col1 (type: double), (- _col1) (type: double), _col2 (type: double), ((_col0 * -563) % _col0) (type: bigint), (UDFToDouble(((_col0 * -563) % _col0)) / _col2) (type: double), _col3 (type: double), (- (UDFToDouble(((_col0 * -563) % _col0)) / _col2)) (type: double), ((-3728 + _col0) - (_col0 * -563)) (type: bigint), _col4 (type: tinyint), _col4 (type: tinyint), (UDFToDouble(_col4) * (- (UDFToDouble(((_col0 * -563) % _col0)) / _col2))) (type: double)
-            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
-            Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE
-            File Output Operator
-              compressed: false
-              Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: SELECT SUM(cint),
-       (SUM(cint) * -563),
-       (-3728 + SUM(cint)),
-       STDDEV_POP(cdouble),
-       (-(STDDEV_POP(cdouble))),
-       AVG(cdouble),
-       ((SUM(cint) * -563) % SUM(cint)),
-       (((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)),
-       VAR_POP(cdouble),
-       (-((((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)))),
-       ((-3728 + SUM(cint)) - (SUM(cint) * -563)),
-       MIN(ctinyint),
-       MIN(ctinyint),
-       (MIN(ctinyint) * (-((((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)))))
-FROM   alltypesparquet
-WHERE  (((csmallint >= cint)
-         OR ((-89010 >= ctinyint)
-             AND (cdouble > 79.553)))
-        OR ((-563 != cbigint)
-            AND ((ctinyint != cbigint)
-                 OR (-3728 >= cdouble))))
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT SUM(cint),
-       (SUM(cint) * -563),
-       (-3728 + SUM(cint)),
-       STDDEV_POP(cdouble),
-       (-(STDDEV_POP(cdouble))),
-       AVG(cdouble),
-       ((SUM(cint) * -563) % SUM(cint)),
-       (((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)),
-       VAR_POP(cdouble),
-       (-((((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)))),
-       ((-3728 + SUM(cint)) - (SUM(cint) * -563)),
-       MIN(ctinyint),
-       MIN(ctinyint),
-       (MIN(ctinyint) * (-((((SUM(cint) * -563) % SUM(cint)) / AVG(cdouble)))))
-FROM   alltypesparquet
-WHERE  (((csmallint >= cint)
-         OR ((-89010 >= ctinyint)
-             AND (cdouble > 79.553)))
-        OR ((-563 != cbigint)
-            AND ((ctinyint != cbigint)
-                 OR (-3728 >= cdouble))))
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
--493101012745	277615870175435	-493101016473	136727.7868296355	-136727.7868296355	2298.5515807767374	0	0.0	1.8694487691330246E10	-0.0	-278108971191908	-64	-64	0.0


Mime
View raw message