hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vihan...@apache.org
Subject [07/29] hive git commit: HIVE-17528 : Add more q-tests for Hive-on-Spark with Parquet vectorized reader (Ferdinand Xu, reviewed by Vihang Karajgaonkar)
Date Wed, 29 Nov 2017 18:01:21 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/9a59592e/ql/src/test/results/clientpositive/spark/parquet_vectorization_17.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/parquet_vectorization_17.q.out b/ql/src/test/results/clientpositive/spark/parquet_vectorization_17.q.out
new file mode 100644
index 0000000..a5ef4ae
--- /dev/null
+++ b/ql/src/test/results/clientpositive/spark/parquet_vectorization_17.q.out
@@ -0,0 +1,560 @@
+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
+    Spark
+      Edges:
+        Reducer 2 <- Map 1 (SORT, 1)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            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: Double
 ColUnaryMinus(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: VectorReduceSinkObjectHashOperator
+                            keyColumnNums: [3, 4]
+                            native: true
+                            nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
+                            valueColumnNums: [6, 2, 8, 5, 15, 16, 14, 17, 19, 20, 22, 18]
+                        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: true
+                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]
+        Reducer 2 
+            Execution mode: vectorized
+            Reduce Vectorization:
+                enabled: true
+                enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
+                reduceColumnNullOrder: aa
+                reduceColumnSortOrder: ++
+                allNative: false
+                usesVectorUDFAdaptor: false
+                vectorized: true
+                rowBatchContext:
+                    dataColumnCount: 14
+                    dataColumns: KEY.reducesinkkey0:bigint, KEY.reducesinkkey1:float, VALUE._col0:string, VALUE._col1:int, VALUE._col2:timestamp, VALUE._col3:double, VALUE._col4:double, VALUE._col5:bigint, VALUE._col6:double, VALUE._col7:double, VALUE._col8:double, VALUE._col9:double, VALUE._col10:decimal(11,4), VALUE._col11:double
+                    partitionColumnCount: 0
+                    scratchColumnTypeNames: []
+            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
+                Select Vectorization:
+                    className: VectorSelectOperator
+                    native: true
+                    projectedOutputColumnNums: [1, 2, 3, 4, 5, 0, 6, 7, 8, 9, 10, 11, 12, 13]
+                Statistics: Num rows: 4096 Data size: 49152 Basic stats: COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  File Sink Vectorization:
+                      className: VectorFileSinkOperator
+                      native: 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/9a59592e/ql/src/test/results/clientpositive/spark/parquet_vectorization_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/parquet_vectorization_2.q.out b/ql/src/test/results/clientpositive/spark/parquet_vectorization_2.q.out
new file mode 100644
index 0000000..a4d1a39
--- /dev/null
+++ b/ql/src/test/results/clientpositive/spark/parquet_vectorization_2.q.out
@@ -0,0 +1,225 @@
+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
+    Spark
+      Edges:
+        Reducer 2 <- Map 1 (GROUP, 1)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            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: VectorReduceSinkEmptyKeyOperator
+                              keyColumnNums: []
+                              native: true
+                              nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
+                              valueColumnNums: [0, 1, 2, 3, 4, 5]
+                          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]
+        Reducer 2 
+            Execution mode: vectorized
+            Reduce Vectorization:
+                enabled: true
+                enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
+                reduceColumnNullOrder: 
+                reduceColumnSortOrder: 
+                allNative: false
+                usesVectorUDFAdaptor: false
+                vectorized: true
+                rowBatchContext:
+                    dataColumnCount: 6
+                    dataColumns: VALUE._col0:struct<count:bigint,sum:double,input:smallint>, VALUE._col1:double, VALUE._col2:struct<count:bigint,sum:double,variance:double>, VALUE._col3:bigint, VALUE._col4:tinyint, VALUE._col5:struct<count:bigint,sum:double,input:double>
+                    partitionColumnCount: 0
+                    scratchColumnTypeNames: []
+            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)
+                Group By Vectorization:
+                    aggregators: VectorUDAFAvgFinal(col 0:struct<count:bigint,sum:double,input:smallint>) -> double, VectorUDAFSumDouble(col 1:double) -> double, VectorUDAFVarFinal(col 2:struct<count:bigint,sum:double,variance:double>) -> double aggregation: var_pop, VectorUDAFCountMerge(col 3:bigint) -> bigint, VectorUDAFMinLong(col 4:tinyint) -> tinyint, VectorUDAFAvgFinal(col 5:struct<count:bigint,sum:double,input:double>) -> double
+                    className: VectorGroupByOperator
+                    groupByMode: MERGEPARTIAL
+                    native: false
+                    vectorProcessingMode: GLOBAL
+                    projectedOutputColumnNums: [0, 1, 2, 3, 4, 5]
+                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
+                  Select Vectorization:
+                      className: VectorSelectOperator
+                      native: true
+                      projectedOutputColumnNums: [0, 6, 7, 1, 2, 8, 9, 3, 11, 10, 4, 14, 5, 12]
+                      selectExpressions: DoubleColModuloDoubleScalar(col 0:double, val -563.0) -> 6:double, DoubleColAddDoubleScalar(col 0:double, val 762.0) -> 7:double, DoubleColUnaryMinus(col 2:double) -> 8:double, DoubleColSubtractDoubleColumn(col 1:double, col 0:double) -> 9:double, DoubleColUnaryMinus(col 10:double)(children: DoubleColSubtractDoubleColumn(col 1:double, col 0:double) -> 10:double) -> 11:double, DoubleColSubtractDoubleScalar(col 2:double, val 762.0) -> 10:double, DoubleColAddDoubleColumn(col 12:double, col 13:double)(children: DoubleColUnaryMinus(col 2:double) -> 12:double, CastLongToDouble(col 4:tinyint) -> 13:double) -> 14:double, DoubleColSubtractDoubleColumn(col 15:double, col 1:double)(children: DoubleColAddDoubleColumn(col 12:double, col 13:double)(children: DoubleColUnaryMinus(col 2:double) -> 12:double, CastLongToDouble(col 4:tinyint) -> 13:double) -> 15:double) -> 12:double
+                  Statistics: Num rows: 1 Data size: 256 Basic stats: COMPLETE Column stats: NONE
+                  File Output Operator
+                    compressed: false
+                    File Sink Vectorization:
+                        className: VectorFileSinkOperator
+                        native: 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/9a59592e/ql/src/test/results/clientpositive/spark/parquet_vectorization_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/parquet_vectorization_3.q.out b/ql/src/test/results/clientpositive/spark/parquet_vectorization_3.q.out
new file mode 100644
index 0000000..59bf2ce
--- /dev/null
+++ b/ql/src/test/results/clientpositive/spark/parquet_vectorization_3.q.out
@@ -0,0 +1,235 @@
+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
+    Spark
+      Edges:
+        Reducer 2 <- Map 1 (GROUP, 1)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            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: VectorReduceSinkEmptyKeyOperator
+                              keyColumnNums: []
+                              native: true
+                              nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
+                              valueColumnNums: [0, 1, 2, 3, 4, 5]
+                          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)]
+        Reducer 2 
+            Execution mode: vectorized
+            Reduce Vectorization:
+                enabled: true
+                enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
+                reduceColumnNullOrder: 
+                reduceColumnSortOrder: 
+                allNative: false
+                usesVectorUDFAdaptor: false
+                vectorized: true
+                rowBatchContext:
+                    dataColumnCount: 6
+                    dataColumns: VALUE._col0:struct<count:bigint,sum:double,variance:double>, VALUE._col1:struct<count:bigint,sum:double,variance:double>, VALUE._col2:struct<count:bigint,sum:double,variance:double>, VALUE._col3:double, VALUE._col4:struct<count:bigint,sum:double,input:int>, VALUE._col5:struct<count:bigint,sum:double,variance:double>
+                    partitionColumnCount: 0
+                    scratchColumnTypeNames: []
+            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)
+                Group By Vectorization:
+                    aggregators: VectorUDAFVarFinal(col 0:struct<count:bigint,sum:double,variance:double>) -> double aggregation: stddev_samp, VectorUDAFVarFinal(col 1:struct<count:bigint,sum:double,variance:double>) -> double aggregation: stddev_pop, VectorUDAFVarFinal(col 2:struct<count:bigint,sum:double,variance:double>) -> double aggregation: stddev_samp, VectorUDAFSumDouble(col 3:double) -> double, VectorUDAFAvgFinal(col 4:struct<count:bigint,sum:double,input:int>) -> double, VectorUDAFVarFinal(col 5:struct<count:bigint,sum:double,variance:double>) -> double aggregation: stddev_pop
+                    className: VectorGroupByOperator
+                    groupByMode: MERGEPARTIAL
+                    native: false
+                    vectorProcessingMode: GLOBAL
+                    projectedOutputColumnNums: [0, 1, 2, 3, 4, 5]
+                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
+                  Select Vectorization:
+                      className: VectorSelectOperator
+                      native: true
+                      projectedOutputColumnNums: [0, 6, 1, 8, 7, 9, 10, 2, 11, 3, 14, 13, 4, 12, 5, 15]
+                      selectExpressions: DoubleColSubtractDoubleScalar(col 0:double, val 10.175) -> 6:double, DoubleColMultiplyDoubleColumn(col 0:double, col 7:double)(children: DoubleColSubtractDoubleScalar(col 0:double, val 10.175) -> 7:double) -> 8:double, DoubleColUnaryMinus(col 1:double) -> 7:double, DoubleColModuloDoubleScalar(col 0:double, val 79.553) -> 9:double, DoubleColUnaryMinus(col 11:double)(children: DoubleColMultiplyDoubleColumn(col 0:double, col 10:double)(children: DoubleColSubtractDoubleScalar(col 0:double, val 10.175) -> 10:double) -> 11:double) -> 10:double, DoubleColUnaryMinus(col 0:double) -> 11:double, DoubleColDivideDoubleColumn(col 12:double, col 13:double)(children: DoubleColUnaryMinus(col 13:double)(children: DoubleColMultiplyDoubleColumn(col 0:double, col 12:double)(children: DoubleColSubtractDoubleScalar(col 0:double, val 10.175) -> 12:double) -> 13:double) -> 12:double, DoubleColSubtractDoubleScalar(col 0:double, val 10.175) -> 13:double) -> 14:double,
  DoubleColUnaryMinus(col 12:double)(children: DoubleColSubtractDoubleScalar(col 0:double, val 10.175) -> 12:double) -> 13:double, DoubleScalarSubtractDoubleColumn(val -3728.0, col 0:double) -> 12:double, DoubleColDivideDoubleColumn(col 4:double, col 2:double) -> 15:double
+                  Statistics: Num rows: 1 Data size: 404 Basic stats: COMPLETE Column stats: NONE
+                  File Output Operator
+                    compressed: false
+                    File Sink Vectorization:
+                        className: VectorFileSinkOperator
+                        native: 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


Mime
View raw message