hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From x..@apache.org
Subject [26/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:19:02 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/a5d5473f/ql/src/test/results/clientpositive/parquet_vectorization_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_vectorization_1.q.out b/ql/src/test/results/clientpositive/parquet_vectorization_1.q.out
deleted file mode 100644
index 637c5be..0000000
--- a/ql/src/test/results/clientpositive/parquet_vectorization_1.q.out
+++ /dev/null
@@ -1,185 +0,0 @@
-PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT VAR_POP(ctinyint),
-       (VAR_POP(ctinyint) / -26.28),
-       SUM(cfloat),
-       (-1.389 + SUM(cfloat)),
-       (SUM(cfloat) * (-1.389 + SUM(cfloat))),
-       MAX(ctinyint),
-       (-((SUM(cfloat) * (-1.389 + SUM(cfloat))))),
-       MAX(cint),
-       (MAX(cint) * 79.553),
-       VAR_SAMP(cdouble),
-       (10.175 % (-((SUM(cfloat) * (-1.389 + SUM(cfloat)))))),
-       COUNT(cint),
-       (-563 % MAX(cint))
-FROM   alltypesparquet
-WHERE  (((cdouble > ctinyint)
-         AND (cboolean2 > 0))
-        OR ((cbigint < ctinyint)
-            OR ((cint > cbigint)
-                OR (cboolean1 < 0))))
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT VAR_POP(ctinyint),
-       (VAR_POP(ctinyint) / -26.28),
-       SUM(cfloat),
-       (-1.389 + SUM(cfloat)),
-       (SUM(cfloat) * (-1.389 + SUM(cfloat))),
-       MAX(ctinyint),
-       (-((SUM(cfloat) * (-1.389 + SUM(cfloat))))),
-       MAX(cint),
-       (MAX(cint) * 79.553),
-       VAR_SAMP(cdouble),
-       (10.175 % (-((SUM(cfloat) * (-1.389 + SUM(cfloat)))))),
-       COUNT(cint),
-       (-563 % MAX(cint))
-FROM   alltypesparquet
-WHERE  (((cdouble > ctinyint)
-         AND (cboolean2 > 0))
-        OR ((cbigint < ctinyint)
-            OR ((cint > cbigint)
-                OR (cboolean1 < 0))))
-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: FilterDoubleColGreaterDoubleColumn(col 5:double, col 13:double)(children: CastLongToDouble(col 0:tinyint) -> 13:double), FilterLongColGreaterLongScalar(col 11:boolean, val 0)), FilterLongColLessLongColumn(col 3:bigint, col 0:bigint)(children: col 0:tinyint), FilterLongColGreaterLongColumn(col 2:bigint, col 3:bigint)(children: col 2:int), FilterLongColLessLongScalar(col 10:boolean, val 0))
-              predicate: (((cdouble > UDFToDouble(ctinyint)) and (cboolean2 > 0)) or (UDFToLong(cint) > cbigint) or (cbigint < UDFToLong(ctinyint)) or (cboolean1 < 0)) (type: boolean)
-              Statistics: Num rows: 12288 Data size: 147456 Basic stats: COMPLETE Column stats: NONE
-              Select Operator
-                expressions: ctinyint (type: tinyint), cint (type: int), cfloat (type: float), cdouble (type: double)
-                outputColumnNames: ctinyint, cint, cfloat, cdouble
-                Select Vectorization:
-                    className: VectorSelectOperator
-                    native: true
-                    projectedOutputColumnNums: [0, 2, 4, 5]
-                Statistics: Num rows: 12288 Data size: 147456 Basic stats: COMPLETE Column stats: NONE
-                Group By Operator
-                  aggregations: var_pop(ctinyint), sum(cfloat), max(ctinyint), max(cint), var_samp(cdouble), count(cint)
-                  Group By Vectorization:
-                      aggregators: VectorUDAFVarLong(col 0:tinyint) -> struct<count:bigint,sum:double,variance:double> aggregation: var_pop, VectorUDAFSumDouble(col 4:float) -> double, VectorUDAFMaxLong(col 0:tinyint) -> tinyint, VectorUDAFMaxLong(col 2:int) -> int, VectorUDAFVarDouble(col 5:double) -> struct<count:bigint,sum:double,variance:double> aggregation: var_samp, VectorUDAFCount(col 2:int) -> bigint
-                      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: 184 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: 184 Basic stats: COMPLETE Column stats: NONE
-                    value expressions: _col0 (type: struct<count:bigint,sum:double,variance:double>), _col1 (type: double), _col2 (type: tinyint), _col3 (type: int), _col4 (type: struct<count:bigint,sum:double,variance:double>), _col5 (type: bigint)
-      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, 2, 3, 4, 5, 10, 11]
-              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: var_pop(VALUE._col0), sum(VALUE._col1), max(VALUE._col2), max(VALUE._col3), var_samp(VALUE._col4), count(VALUE._col5)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-          Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
-          Select Operator
-            expressions: _col0 (type: double), (_col0 / -26.28) (type: double), _col1 (type: double), (-1.389 + _col1) (type: double), (_col1 * (-1.389 + _col1)) (type: double), _col2 (type: tinyint), (- (_col1 * (-1.389 + _col1))) (type: double), _col3 (type: int), (CAST( _col3 AS decimal(10,0)) * 79.553) (type: decimal(16,3)), _col4 (type: double), (10.175 % (- (_col1 * (-1.389 + _col1)))) (type: double), _col5 (type: bigint), (-563 % _col3) (type: int)
-            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
-            Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
-            File Output Operator
-              compressed: false
-              Statistics: Num rows: 1 Data size: 184 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 VAR_POP(ctinyint),
-       (VAR_POP(ctinyint) / -26.28),
-       SUM(cfloat),
-       (-1.389 + SUM(cfloat)),
-       (SUM(cfloat) * (-1.389 + SUM(cfloat))),
-       MAX(ctinyint),
-       (-((SUM(cfloat) * (-1.389 + SUM(cfloat))))),
-       MAX(cint),
-       (MAX(cint) * 79.553),
-       VAR_SAMP(cdouble),
-       (10.175 % (-((SUM(cfloat) * (-1.389 + SUM(cfloat)))))),
-       COUNT(cint),
-       (-563 % MAX(cint))
-FROM   alltypesparquet
-WHERE  (((cdouble > ctinyint)
-         AND (cboolean2 > 0))
-        OR ((cbigint < ctinyint)
-            OR ((cint > cbigint)
-                OR (cboolean1 < 0))))
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT VAR_POP(ctinyint),
-       (VAR_POP(ctinyint) / -26.28),
-       SUM(cfloat),
-       (-1.389 + SUM(cfloat)),
-       (SUM(cfloat) * (-1.389 + SUM(cfloat))),
-       MAX(ctinyint),
-       (-((SUM(cfloat) * (-1.389 + SUM(cfloat))))),
-       MAX(cint),
-       (MAX(cint) * 79.553),
-       VAR_SAMP(cdouble),
-       (10.175 % (-((SUM(cfloat) * (-1.389 + SUM(cfloat)))))),
-       COUNT(cint),
-       (-563 % MAX(cint))
-FROM   alltypesparquet
-WHERE  (((cdouble > ctinyint)
-         AND (cboolean2 > 0))
-        OR ((cbigint < ctinyint)
-            OR ((cint > cbigint)
-                OR (cboolean1 < 0))))
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
-1074.830257547229	-40.89917266161449	-21997.674998402596	-21999.063998402595	4.839282601059194E8	62	-4.839282601059194E8	1073680599	85414512692.247	7.569848642620903E10	10.175	3745	-563

http://git-wip-us.apache.org/repos/asf/hive/blob/a5d5473f/ql/src/test/results/clientpositive/parquet_vectorization_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_vectorization_10.q.out b/ql/src/test/results/clientpositive/parquet_vectorization_10.q.out
deleted file mode 100644
index 6e87257..0000000
--- a/ql/src/test/results/clientpositive/parquet_vectorization_10.q.out
+++ /dev/null
@@ -1,409 +0,0 @@
-PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT cdouble,
-       ctimestamp1,
-       ctinyint,
-       cboolean1,
-       cstring1,
-       (-(cdouble)),
-       (cdouble + csmallint),
-       ((cdouble + csmallint) % 33),
-       (-(cdouble)),
-       (ctinyint % cdouble),
-       (ctinyint % csmallint),
-       (-(cdouble)),
-       (cbigint * (ctinyint % csmallint)),
-       (9763215.5639 - (cdouble + csmallint)),
-       (-((-(cdouble))))
-FROM   alltypesparquet
-WHERE  (((cstring2 <= '10')
-         OR ((ctinyint > cdouble)
-             AND (-5638.15 >= ctinyint)))
-        OR ((cdouble > 6981)
-            AND ((csmallint = 9763215.5639)
-                 OR (cstring1 LIKE '%a'))))
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT cdouble,
-       ctimestamp1,
-       ctinyint,
-       cboolean1,
-       cstring1,
-       (-(cdouble)),
-       (cdouble + csmallint),
-       ((cdouble + csmallint) % 33),
-       (-(cdouble)),
-       (ctinyint % cdouble),
-       (ctinyint % csmallint),
-       (-(cdouble)),
-       (cbigint * (ctinyint % csmallint)),
-       (9763215.5639 - (cdouble + csmallint)),
-       (-((-(cdouble))))
-FROM   alltypesparquet
-WHERE  (((cstring2 <= '10')
-         OR ((ctinyint > cdouble)
-             AND (-5638.15 >= ctinyint)))
-        OR ((cdouble > 6981)
-            AND ((csmallint = 9763215.5639)
-                 OR (cstring1 LIKE '%a'))))
-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: FilterStringGroupColLessEqualStringScalar(col 7:string, val 10), FilterExprAndExpr(children: FilterDoubleColGreaterDoubleColumn(col 13:double, col 5:double)(children: CastLongToDouble(col 0:tinyint) -> 13:double), FilterDecimalScalarGreaterEqualDecimalColumn(val -5638.15, col 14:decimal(6,2))(children: CastLongToDecimal(col 0:tinyint) -> 14:decimal(6,2))), FilterExprAndExpr(children: FilterDoubleColGreaterDoubleScalar(col 5:double, val 6981.0), FilterExprOrExpr(children: FilterDecimalColEqualDecimalScalar(col 15:decimal(11,4), val 9763215.5639)(children: CastLongToDecimal(col 1:smallint) -> 15:decimal(11,4)), FilterStringColLikeStringScalar(col 6:string, pattern %a))))
-              predicate: (((UDFToDouble(ctinyint) > cdouble) and (-5638.15 >= CAST( ctinyint AS decimal(6,2)))) or ((cdouble > 6981.0) and ((CAST( csmallint AS decimal(11,4)) = 9763215.5639) or (cstring1 like '%a'))) or (cstring2 <= '10')) (type: boolean)
-              Statistics: Num rows: 9557 Data size: 114684 Basic stats: COMPLETE Column stats: NONE
-              Select Operator
-                expressions: cdouble (type: double), ctimestamp1 (type: timestamp), ctinyint (type: tinyint), cboolean1 (type: boolean), cstring1 (type: string), (- cdouble) (type: double), (cdouble + UDFToDouble(csmallint)) (type: double), ((cdouble + UDFToDouble(csmallint)) % 33.0) (type: double), (- cdouble) (type: double), (UDFToDouble(ctinyint) % cdouble) (type: double), (UDFToShort(ctinyint) % csmallint) (type: smallint), (- cdouble) (type: double), (cbigint * UDFToLong((UDFToShort(ctinyint) % csmallint))) (type: bigint), (9763215.5639 - (cdouble + UDFToDouble(csmallint))) (type: double), (- (- cdouble)) (type: double)
-                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14
-                Select Vectorization:
-                    className: VectorSelectOperator
-                    native: true
-                    projectedOutputColumnNums: [5, 8, 0, 10, 6, 13, 17, 16, 18, 20, 21, 19, 23, 24, 26]
-                    selectExpressions: DoubleColUnaryMinus(col 5:double) -> 13:double, DoubleColAddDoubleColumn(col 5:double, col 16:double)(children: CastLongToDouble(col 1:smallint) -> 16:double) -> 17:double, DoubleColModuloDoubleScalar(col 18:double, val 33.0)(children: DoubleColAddDoubleColumn(col 5:double, col 16:double)(children: CastLongToDouble(col 1:smallint) -> 16:double) -> 18:double) -> 16:double, DoubleColUnaryMinus(col 5:double) -> 18:double, DoubleColModuloDoubleColumn(col 19:double, col 5:double)(children: CastLongToDouble(col 0:tinyint) -> 19:double) -> 20:double, LongColModuloLongColumn(col 0:smallint, col 1:smallint)(children: col 0:tinyint) -> 21:smallint, DoubleColUnaryMinus(col 5:double) -> 19:double, LongColMultiplyLongColumn(col 3:bigint, col 22:bigint)(children: col 22:smallint) -> 23:bigint, DoubleScalarSubtractDoubleColumn(val 9763215.5639, col 25:double)(children: DoubleColAddDoubleColumn(col 5:double, col 24:double)(children: CastLongToDouble(col 1:smal
 lint) -> 24:double) -> 25:double) -> 24:double, DoubleColUnaryMinus(col 25:double)(children: DoubleColUnaryMinus(col 5:double) -> 25:double) -> 26:double
-                Statistics: Num rows: 9557 Data size: 114684 Basic stats: COMPLETE Column stats: NONE
-                File Output Operator
-                  compressed: false
-                  File Sink Vectorization:
-                      className: VectorFileSinkOperator
-                      native: false
-                  Statistics: Num rows: 9557 Data size: 114684 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
-      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, 3, 5, 6, 7, 8, 10]
-              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(6,2), decimal(11,4), double, double, double, double, double, bigint, bigint, bigint, double, double, double]
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: SELECT cdouble,
-       ctimestamp1,
-       ctinyint,
-       cboolean1,
-       cstring1,
-       (-(cdouble)),
-       (cdouble + csmallint),
-       ((cdouble + csmallint) % 33),
-       (-(cdouble)),
-       (ctinyint % cdouble),
-       (ctinyint % csmallint),
-       (-(cdouble)),
-       (cbigint * (ctinyint % csmallint)),
-       (9763215.5639 - (cdouble + csmallint)),
-       (-((-(cdouble))))
-FROM   alltypesparquet
-WHERE  (((cstring2 <= '10')
-         OR ((ctinyint > cdouble)
-             AND (-5638.15 >= ctinyint)))
-        OR ((cdouble > 6981)
-            AND ((csmallint = 9763215.5639)
-                 OR (cstring1 LIKE '%a'))))
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT cdouble,
-       ctimestamp1,
-       ctinyint,
-       cboolean1,
-       cstring1,
-       (-(cdouble)),
-       (cdouble + csmallint),
-       ((cdouble + csmallint) % 33),
-       (-(cdouble)),
-       (ctinyint % cdouble),
-       (ctinyint % csmallint),
-       (-(cdouble)),
-       (cbigint * (ctinyint % csmallint)),
-       (9763215.5639 - (cdouble + csmallint)),
-       (-((-(cdouble))))
-FROM   alltypesparquet
-WHERE  (((cstring2 <= '10')
-         OR ((ctinyint > cdouble)
-             AND (-5638.15 >= ctinyint)))
-        OR ((cdouble > 6981)
-            AND ((csmallint = 9763215.5639)
-                 OR (cstring1 LIKE '%a'))))
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
--200.0	1969-12-31 15:59:44.04	32	NULL	NULL	200.0	-400.0	-4.0	200.0	32.0	32	200.0	-8229422560	9763615.5639	-200.0
--200.0	1969-12-31 15:59:46.076	9	NULL	NULL	200.0	-400.0	-4.0	200.0	9.0	9	200.0	-14202953316	9763615.5639	-200.0
--200.0	1969-12-31 15:59:47.828	-10	NULL	NULL	200.0	-400.0	-4.0	200.0	-10.0	-10	200.0	7156607330	9763615.5639	-200.0
--200.0	1969-12-31 15:59:48.188	18	NULL	NULL	200.0	-400.0	-4.0	200.0	18.0	18	200.0	-15013264662	9763615.5639	-200.0
--200.0	1969-12-31 15:59:49.331	-46	NULL	NULL	200.0	-400.0	-4.0	200.0	-46.0	-46	200.0	93596894876	9763615.5639	-200.0
--200.0	1969-12-31 15:59:50.618	-60	NULL	NULL	200.0	-400.0	-4.0	200.0	-60.0	-60	200.0	-55670852400	9763615.5639	-200.0
--200.0	1969-12-31 15:59:51.063	58	NULL	NULL	200.0	-400.0	-4.0	200.0	58.0	58	200.0	-25062091276	9763615.5639	-200.0
--200.0	1969-12-31 15:59:51.342	60	NULL	NULL	200.0	-400.0	-4.0	200.0	60.0	60	200.0	118868432400	9763615.5639	-200.0
--200.0	1969-12-31 15:59:53.476	-22	NULL	NULL	200.0	-400.0	-4.0	200.0	-22.0	-22	200.0	-3315653088	9763615.5639	-200.0
--200.0	1969-12-31 15:59:53.743	25	NULL	NULL	200.0	-400.0	-4.0	200.0	25.0	25	200.0	46547828825	9763615.5639	-200.0
--200.0	1969-12-31 15:59:54.187	-45	NULL	NULL	200.0	-400.0	-4.0	200.0	-45.0	-45	200.0	-63963827865	9763615.5639	-200.0
--200.0	1969-12-31 15:59:54.866	-26	NULL	NULL	200.0	-400.0	-4.0	200.0	-26.0	-26	200.0	7325400810	9763615.5639	-200.0
--200.0	1969-12-31 15:59:55.829	0	NULL	NULL	200.0	-400.0	-4.0	200.0	0.0	0	200.0	0	9763615.5639	-200.0
--200.0	1969-12-31 15:59:57.349	-56	NULL	NULL	200.0	-400.0	-4.0	200.0	-56.0	-56	200.0	-34216461496	9763615.5639	-200.0
--200.0	1969-12-31 15:59:57.47	6	NULL	NULL	200.0	-400.0	-4.0	200.0	6.0	6	200.0	-7015614564	9763615.5639	-200.0
--200.0	1969-12-31 16:00:00.893	22	NULL	NULL	200.0	-400.0	-4.0	200.0	22.0	22	200.0	-39924557090	9763615.5639	-200.0
--200.0	1969-12-31 16:00:01.653	8	NULL	NULL	200.0	-400.0	-4.0	200.0	8.0	8	200.0	-15661041184	9763615.5639	-200.0
--200.0	1969-12-31 16:00:02.972	-58	NULL	NULL	200.0	-400.0	-4.0	200.0	-58.0	-58	200.0	60297449542	9763615.5639	-200.0
--200.0	1969-12-31 16:00:03.333	-44	NULL	NULL	200.0	-400.0	-4.0	200.0	-44.0	-44	200.0	79435713324	9763615.5639	-200.0
--200.0	1969-12-31 16:00:03.446	-19	NULL	NULL	200.0	-400.0	-4.0	200.0	-19.0	-19	200.0	10670477159	9763615.5639	-200.0
--200.0	1969-12-31 16:00:03.794	13	NULL	NULL	200.0	-400.0	-4.0	200.0	13.0	13	200.0	11630250073	9763615.5639	-200.0
--200.0	1969-12-31 16:00:04.967	62	NULL	NULL	200.0	-400.0	-4.0	200.0	62.0	62	200.0	61311056	9763615.5639	-200.0
--200.0	1969-12-31 16:00:05.377	-52	NULL	NULL	200.0	-400.0	-4.0	200.0	-52.0	-52	200.0	-97123836836	9763615.5639	-200.0
--200.0	1969-12-31 16:00:06.3	14	NULL	NULL	200.0	-400.0	-4.0	200.0	14.0	14	200.0	811814206	9763615.5639	-200.0
--200.0	1969-12-31 16:00:07.731	44	NULL	NULL	200.0	-400.0	-4.0	200.0	44.0	44	200.0	-59205151456	9763615.5639	-200.0
--200.0	1969-12-31 16:00:08.046	-33	NULL	NULL	200.0	-400.0	-4.0	200.0	-33.0	-33	200.0	-9274988019	9763615.5639	-200.0
--200.0	1969-12-31 16:00:09.111	-37	NULL	NULL	200.0	-400.0	-4.0	200.0	-37.0	-37	200.0	-9024569730	9763615.5639	-200.0
--200.0	1969-12-31 16:00:09.539	7	NULL	NULL	200.0	-400.0	-4.0	200.0	7.0	7	200.0	9345007252	9763615.5639	-200.0
--200.0	1969-12-31 16:00:09.883	46	NULL	NULL	200.0	-400.0	-4.0	200.0	46.0	46	200.0	-20096868102	9763615.5639	-200.0
--200.0	1969-12-31 16:00:10.601	55	NULL	NULL	200.0	-400.0	-4.0	200.0	55.0	55	200.0	110230625780	9763615.5639	-200.0
--200.0	1969-12-31 16:00:11.08	-9	NULL	NULL	200.0	-400.0	-4.0	200.0	-9.0	-9	200.0	-5470381665	9763615.5639	-200.0
--200.0	1969-12-31 16:00:11.15	-30	NULL	NULL	200.0	-400.0	-4.0	200.0	-30.0	-30	200.0	25029255630	9763615.5639	-200.0
--200.0	1969-12-31 16:00:15.091	-43	NULL	NULL	200.0	-400.0	-4.0	200.0	-43.0	-43	200.0	-46861099946	9763615.5639	-200.0
--200.0	1969-12-31 16:00:15.143	16	NULL	NULL	200.0	-400.0	-4.0	200.0	16.0	16	200.0	-33756365728	9763615.5639	-200.0
--200.0	1969-12-31 16:00:15.296	-59	NULL	NULL	200.0	-400.0	-4.0	200.0	-59.0	-59	200.0	-9757710398	9763615.5639	-200.0
--200.0	1969-12-31 16:00:15.969	8	NULL	NULL	200.0	-400.0	-4.0	200.0	8.0	8	200.0	-9832802032	9763615.5639	-200.0
--200.0	1969-12-31 16:00:16.178	-30	NULL	NULL	200.0	-400.0	-4.0	200.0	-30.0	-30	200.0	47698035420	9763615.5639	-200.0
--7196.0	1969-12-31 15:59:44.292	-23	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-23.0	-23	7196.0	46033183457	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:45.518	47	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	47.0	47	7196.0	81143089746	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:48.929	-12	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-12.0	-12	7196.0	14774939436	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:49.326	39	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	39.0	39	7196.0	-30362271264	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:50.265	3	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	3.0	3	7196.0	-5006530458	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:50.462	56	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	56.0	56	7196.0	-118616357552	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:51.009	-49	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-49.0	-49	7196.0	NULL	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:51.561	-35	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-35.0	-35	7196.0	-70617762705	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:52.969	-27	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-27.0	-27	7196.0	8967759183	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:53.145	-24	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-24.0	-24	7196.0	-19898664000	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:53.686	-39	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-39.0	-39	7196.0	45315380682	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:54.133	11	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	11.0	11	7196.0	13012660188	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:54.776	10	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	10.0	10	7196.0	-6713016290	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:55.492	14	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	14.0	14	7196.0	23828505764	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:55.667	56	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	56.0	56	7196.0	-120146991496	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:56.135	-17	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-17.0	-17	7196.0	8662474406	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:57.011	42	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	42.0	42	7196.0	-23099469372	9777607.5639	-7196.0
--7196.0	1969-12-31 15:59:57.86	-52	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-52.0	-52	7196.0	1368083028	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:00.381	-2	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-2.0	-2	7196.0	-1206817104	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:01.088	-16	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-16.0	-16	7196.0	-7507617424	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:01.22	-62	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-62.0	-62	7196.0	-103567870178	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:04.233	26	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	26.0	26	7196.0	-15783340898	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:06.848	-18	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-18.0	-18	7196.0	1982664288	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:08.373	60	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	60.0	60	7196.0	-119905930860	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:08.418	41	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	41.0	41	7196.0	32453141435	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:10.915	39	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	39.0	39	7196.0	-14094881658	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:11.36	-53	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-53.0	-53	7196.0	71962864647	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:11.703	-29	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-29.0	-29	7196.0	10213273940	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:13.231	53	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	53.0	53	7196.0	-36144071012	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:13.787	24	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	24.0	24	7196.0	38316668352	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:13.816	31	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	31.0	31	7196.0	-56470642871	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:15.188	-21	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	-21.0	-21	7196.0	38372734386	9777607.5639	-7196.0
--7196.0	1969-12-31 16:00:15.923	15	NULL	NULL	7196.0	-14392.0	-4.0	7196.0	15.0	15	7196.0	6481300020	9777607.5639	-7196.0
-11619.0	NULL	NULL	false	lJ63qx87BLmdMfa	-11619.0	23238.0	6.0	-11619.0	NULL	NULL	-11619.0	NULL	9739977.5639	11619.0
-12004.0	NULL	NULL	true	a	-12004.0	24008.0	17.0	-12004.0	NULL	NULL	-12004.0	NULL	9739207.5639	12004.0
-12520.0	NULL	NULL	false	S7UM6KgdxTofi6rwXBFa2a	-12520.0	25040.0	26.0	-12520.0	NULL	NULL	-12520.0	NULL	9738175.5639	12520.0
-13167.0	NULL	NULL	true	4gBPJa	-13167.0	26334.0	0.0	-13167.0	NULL	NULL	-13167.0	NULL	9736881.5639	13167.0
-14460.0	NULL	NULL	true	hQAra	-14460.0	28920.0	12.0	-14460.0	NULL	NULL	-14460.0	NULL	9734295.5639	14460.0
-14468.0	NULL	NULL	true	3B3ubgg3B6a	-14468.0	28936.0	28.0	-14468.0	NULL	NULL	-14468.0	NULL	9734279.5639	14468.0
-15601.0	1969-12-31 15:59:44.115	-20	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-20.0	-20	-15601.0	5179862200	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:45.655	-23	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-23.0	-23	-15601.0	-14931660214	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:46.258	-26	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-26.0	-26	-15601.0	-35132327672	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:46.33	24	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	24.0	24	-15601.0	-41767499616	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:46.443	-43	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-43.0	-43	-15601.0	9618553900	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:46.82	-46	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-46.0	-46	-15601.0	9610884144	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:47.436	-51	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-51.0	-51	-15601.0	-3541883598	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:48.552	62	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	62.0	62	-15601.0	-92267819432	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:48.71	-30	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-30.0	-30	-15601.0	-36655228350	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:48.932	16	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	16.0	16	-15601.0	NULL	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:50.575	29	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	29.0	29	-15601.0	-6410141150	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:51.153	-44	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-44.0	-44	-15601.0	17590906828	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:51.535	55	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	55.0	55	-15601.0	-57431846615	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:51.645	10	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	10.0	10	-15601.0	-10432519820	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:52.778	4	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	4.0	4	-15601.0	-3767539848	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:52.786	-1	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-1.0	-1	-15601.0	-672512361	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:53.279	-11	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-11.0	-11	-15601.0	-19558985941	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:53.715	-44	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-44.0	-44	-15601.0	3342918304	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:54.253	-44	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-44.0	-44	-15601.0	-11984211184	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:54.384	-59	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-59.0	-59	-15601.0	-109154505771	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:54.524	52	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	52.0	52	-15601.0	80665657592	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:56.481	10	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	10.0	10	-15601.0	-12301158220	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:57.729	30	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	30.0	30	-15601.0	-59602621200	9732013.5639	15601.0
-15601.0	1969-12-31 15:59:58.704	-55	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-55.0	-55	-15601.0	73626727075	9732013.5639	15601.0
-15601.0	1969-12-31 16:00:02.401	30	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	30.0	30	-15601.0	61004562030	9732013.5639	15601.0
-15601.0	1969-12-31 16:00:03.888	-23	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-23.0	-23	-15601.0	48400325149	9732013.5639	15601.0
-15601.0	1969-12-31 16:00:04.063	33	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	33.0	33	-15601.0	-47936367534	9732013.5639	15601.0
-15601.0	1969-12-31 16:00:05.007	35	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	35.0	35	-15601.0	74309762800	9732013.5639	15601.0
-15601.0	1969-12-31 16:00:05.334	22	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	22.0	22	-15601.0	-41268959688	9732013.5639	15601.0
-15601.0	1969-12-31 16:00:05.83	-49	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-49.0	-49	-15601.0	-11115220466	9732013.5639	15601.0
-15601.0	1969-12-31 16:00:09.123	-14	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-14.0	-14	-15601.0	-14100538704	9732013.5639	15601.0
-15601.0	1969-12-31 16:00:11.928	-32	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-32.0	-32	-15601.0	-54463594144	9732013.5639	15601.0
-15601.0	1969-12-31 16:00:14.175	-50	NULL	NULL	-15601.0	31202.0	17.0	-15601.0	-50.0	-50	-15601.0	-35817486300	9732013.5639	15601.0
-8801.0	NULL	NULL	false	5712We1FSa	-8801.0	17602.0	13.0	-8801.0	NULL	NULL	-8801.0	NULL	9745613.5639	8801.0
-NULL	1969-12-31 16:00:02.351	11	false	0rtl1C	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	1j3rth56N41X17c1S	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	6a421YV	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	Bgk2cxNJk7f4rMmW38Dl3S1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	G2s1ly	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	H5alUwndRKm	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	K11m3K43m5XFX40RJm1q	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	M7xB374ixGAp	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	SN5NB5L3gpe2RtR2w50sNAd	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	V2NEmm6d0kLFGa5s01k	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	eicMhR0nJt12OH7IO2651bO	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	g552y0x1B4n	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	gk0kJenBW237uQoxGBx36	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	l3r8T4QgT63	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	ve4Pgoehe6vhmYVLpP	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	w6173j	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	woeLEb	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	false	y605nF0K3mMoM75j	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	16L335OgyOKH4565	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	1V07gCB41Psbr5xtLiK4E	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	3Fhv1QY7Y776eQ38a	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	5NM44RohO4r6	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	6AmfdSoTPmVvXdgM8CP20sx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	6t557nSSrg1s0Q	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	70070HP7Kb8Lrj	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	8s0kR1e4QVV7QO	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	8tVuiCkFtGW5KX	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	Bsi3VIb	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	F8iVJQQdC6O4	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	II1600yobW7p	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	LP5AMypx5	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	N2Jfon7dyCN2Pmm1JA	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	Nmt6E360X6dpX58CR2	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	a3EhVU6Wuy7ycJ7wY7h2gv	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	cd6Xc861fDCGe	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	gjsL355dId0aH1mj0yGky1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	kfUgQ2uGN8a	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	qlspyY30jeWkAcB1ptQ4co0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	s456h8r2b0jAt4Ni3qopHCxS	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	ySAfuiG2vJNn5TR5	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:02.351	11	true	yc2pX4jTI0xKh5xTys	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	121307nh6r0H31Mg	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	12yT2agBjx3yQ	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	1M4eTm8OcOW2dAMV2V5slS1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	2M106hVFEhu	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	37p34Jc2nloL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	4l6OX60y	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	74nRe6WYOO7MD7632BOS	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	8AqHq	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	8Jvom23dkWvvqv81DY5Ub3	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	8l433e5J6I0fj0PM	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	EXWsAOlGYtb053ExF6u5FLyb	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	G2P1ogIIyMgo6j2a27egS	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	GlCK4Dw7uIb1bsY	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	J0VTT0R8t1JcxdoOO	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	J8p4pS3A8G75Ct2	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	JVCOfSTVb	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	QRq4fxOau2jef55O5X1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	QgA6r86x0JrfdHuM	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	T0Gq3D4N50YY48AG8OQBqTU	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	WUQQRWTJ1wK1H4	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	c23S6Ky4w7Ld21lAbB	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	d1N0u454kG87DN3o	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	d3yQbTLvpGyi0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	fkA37sOkxCp44hlIKV	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	rLL8VlwJ0P	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	s038hX0U8	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	sU1VhRD0P3w47WU66	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	tyt5Bwxxe	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	uUTO41xk6VyqYPh	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	vgd8P8Ff1n	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	vmD7YLtKX0c4y2uU	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	false	xgPW6tMwuNv67I0q2227	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	1Iry1n1c	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	3StDSaH7	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	3yeq763N	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	4k1RqRL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	7LdfF1415i51qpmHQI	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	7bD30suWFdI4o5Jp6m	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	Bb2AdwWmQOcwJhqF	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	Cw412mnXhN1F	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	M76D058tDDD25v3g	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	ON30Mh8A8	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	OqM62X0G3j7XpBOTt70	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	S0LP25K12US3	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	YX250	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	j83cOtj22H5Aje7H3	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	jd4MshHSjPOuq1b2T	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	nOF31ehjY7ULCHMf	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:08.451	-51	true	q2bIHkxaKKv7uD	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	0m8aHX5yF5muTQW	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	0siU5JLRoUBPi88Kenqg4	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	16qqkM5M66EMI3uWjWy	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	1AQR8H78mO7jyb2PBF	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	31rhe	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	4c2KT50dog5	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	8JNVrH3Lasa826	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	BwXBC7rU57	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	M3Vcm3o	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	W4TEt52sKL0ndx4jeCahICDW	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	Xi7kOTT	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	e13dNAo71UXm4Yt1u	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	eIyS41R32	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	fVgv88OvQR1BB7toX	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	iEb04t2x333EF5wHoKRs6oKB	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	iStQPx6j8SvMc	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	j2UTaANoWtpw2co6Nj3bR2UG	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	qI8k4Mf	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	s3WL6smnb7	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	false	uHkBp64	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	06Q47xVf1d5JSdb	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	07Hofhidd5ClnNx8jTl1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	1w7DPjq	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	41PLN7aXgP57M4Rr3	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	4A7p4HkPm01W0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	7GCfB5odqYDW1gq7iBWJ	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	7e6ntfBnB0m82i6k83	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	8Fx0J88	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	A30e7a8ia36g25YQc8xTXBgB	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	N334idEn4hyyO64	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	Pc18F2c6iW766Vd	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	Q0PCmMLk	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	b	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	bc014i7354F36p	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	i6G060	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	oibQ623k5v33kBUK8Q	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	p3DvmcsqP6xMf	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	poE6hx8xV36vG	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	pq2i0NL1cRlR3CpAj082	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	q6iS3txi22Rj22Ks4Dd	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	woiNv162mnSJ	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	1969-12-31 16:00:15.892	8	true	x6WK1U14M7IlWw	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL

http://git-wip-us.apache.org/repos/asf/hive/blob/a5d5473f/ql/src/test/results/clientpositive/parquet_vectorization_11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_vectorization_11.q.out b/ql/src/test/results/clientpositive/parquet_vectorization_11.q.out
deleted file mode 100644
index fb3707b..0000000
--- a/ql/src/test/results/clientpositive/parquet_vectorization_11.q.out
+++ /dev/null
@@ -1,173 +0,0 @@
-PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT cstring1,
-       cboolean1,
-       cdouble,
-       ctimestamp1,
-       (-3728 * csmallint),
-       (cdouble - 9763215.5639),
-       (-(cdouble)),
-       ((-(cdouble)) + 6981),
-       (cdouble * -5638.15)
-FROM   alltypesparquet
-WHERE  ((cstring2 = cstring1)
-        OR ((ctimestamp1 IS NULL)
-            AND (cstring1 LIKE '%a')))
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
-SELECT cstring1,
-       cboolean1,
-       cdouble,
-       ctimestamp1,
-       (-3728 * csmallint),
-       (cdouble - 9763215.5639),
-       (-(cdouble)),
-       ((-(cdouble)) + 6981),
-       (cdouble * -5638.15)
-FROM   alltypesparquet
-WHERE  ((cstring2 = cstring1)
-        OR ((ctimestamp1 IS NULL)
-            AND (cstring1 LIKE '%a')))
-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: FilterStringGroupColEqualStringGroupColumn(col 7:string, col 6:string), FilterExprAndExpr(children: SelectColumnIsNull(col 8:timestamp), FilterStringColLikeStringScalar(col 6:string, pattern %a)))
-              predicate: ((cstring2 = cstring1) or (ctimestamp1 is null and (cstring1 like '%a'))) (type: boolean)
-              Statistics: Num rows: 9216 Data size: 110592 Basic stats: COMPLETE Column stats: NONE
-              Select Operator
-                expressions: cstring1 (type: string), cboolean1 (type: boolean), cdouble (type: double), ctimestamp1 (type: timestamp), (-3728 * UDFToInteger(csmallint)) (type: int), (cdouble - 9763215.5639) (type: double), (- cdouble) (type: double), ((- cdouble) + 6981.0) (type: double), (cdouble * -5638.15) (type: double)
-                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
-                Select Vectorization:
-                    className: VectorSelectOperator
-                    native: true
-                    projectedOutputColumnNums: [6, 10, 5, 8, 13, 14, 15, 17, 16]
-                    selectExpressions: LongScalarMultiplyLongColumn(val -3728, col 1:int)(children: col 1:smallint) -> 13:int, DoubleColSubtractDoubleScalar(col 5:double, val 9763215.5639) -> 14:double, DoubleColUnaryMinus(col 5:double) -> 15:double, DoubleColAddDoubleScalar(col 16:double, val 6981.0)(children: DoubleColUnaryMinus(col 5:double) -> 16:double) -> 17:double, DoubleColMultiplyDoubleScalar(col 5:double, val -5638.15) -> 16:double
-                Statistics: Num rows: 9216 Data size: 110592 Basic stats: COMPLETE Column stats: NONE
-                File Output Operator
-                  compressed: false
-                  File Sink Vectorization:
-                      className: VectorFileSinkOperator
-                      native: false
-                  Statistics: Num rows: 9216 Data size: 110592 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
-      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: [1, 5, 6, 7, 8, 10]
-              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: [bigint, double, double, double, double]
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: SELECT cstring1,
-       cboolean1,
-       cdouble,
-       ctimestamp1,
-       (-3728 * csmallint),
-       (cdouble - 9763215.5639),
-       (-(cdouble)),
-       ((-(cdouble)) + 6981),
-       (cdouble * -5638.15)
-FROM   alltypesparquet
-WHERE  ((cstring2 = cstring1)
-        OR ((ctimestamp1 IS NULL)
-            AND (cstring1 LIKE '%a')))
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT cstring1,
-       cboolean1,
-       cdouble,
-       ctimestamp1,
-       (-3728 * csmallint),
-       (cdouble - 9763215.5639),
-       (-(cdouble)),
-       ((-(cdouble)) + 6981),
-       (cdouble * -5638.15)
-FROM   alltypesparquet
-WHERE  ((cstring2 = cstring1)
-        OR ((ctimestamp1 IS NULL)
-            AND (cstring1 LIKE '%a')))
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesparquet
-#### A masked pattern was here ####
-055VA1s2XC7q70aD8S0PLpa	true	-12485.0	NULL	46544080	-9775700.5639	12485.0	19466.0	7.039230275E7
-067wD7F8YQ8h32jPa	true	-16012.0	NULL	59692736	-9779227.5639	16012.0	22993.0	9.02780578E7
-0AP3HERf5Ra	true	5045.0	NULL	-18807760	-9758170.5639	-5045.0	1936.0	-2.844446675E7
-0MPx71oMa	false	6644.0	NULL	-24768832	-9756571.5639	-6644.0	337.0	-3.7459868599999994E7
-1MJ884f1w6B38WBeya	false	-2575.0	NULL	9599600	-9765790.5639	2575.0	9556.0	1.4518236249999998E7
-3B3ubgg3B6a	true	14468.0	NULL	-53936704	-9748747.5639	-14468.0	-7487.0	-8.157275419999999E7
-47x5248dXuiqta	true	-12888.0	NULL	48046464	-9776103.5639	12888.0	19869.0	7.266447719999999E7
-4gBPJa	true	13167.0	NULL	-49086576	-9750048.5639	-13167.0	-6186.0	-7.423752105E7
-5712We1FSa	false	8801.0	NULL	-32810128	-9754414.5639	-8801.0	-1820.0	-4.962135815E7
-5ctB5Don6vvjSc6a	false	-1786.0	NULL	6658208	-9765001.5639	1786.0	8767.0	1.0069735899999999E7
-5xaNVvLa	true	2315.0	NULL	-8630320	-9760900.5639	-2315.0	4666.0	-1.305231725E7
-60S63VPytWwf5Hu6j75cHa	false	-4739.0	NULL	17666992	-9767954.5639	4739.0	11720.0	2.6719192849999998E7
-7C1L24VM7Ya	true	4122.0	NULL	-15366816	-9759093.5639	-4122.0	2859.0	-2.3240454299999997E7
-DUSKf88a	false	6764.0	NULL	-25216192	-9756451.5639	-6764.0	217.0	-3.8136446599999994E7
-FWCW47mXs2a	true	-6839.0	NULL	25495792	-9770054.5639	6839.0	13820.0	3.8559307849999994E7
-G5n81R5jjsG5Gp58vqNa	false	-3597.0	NULL	13409616	-9766812.5639	3597.0	10578.0	2.0280425549999997E7
-G7Ve8Px6a7J0DafBodF8JMma	false	-1291.0	NULL	4812848	-9764506.5639	1291.0	8272.0	7278851.649999999
-JRN4nLo30dv0bRtsrJa	true	-4319.0	NULL	16101232	-9767534.5639	4319.0	11300.0	2.4351169849999998E7
-K7tGy146ydka	false	-1236.0	NULL	4607808	-9764451.5639	1236.0	8217.0	6968753.399999999
-L057p1HPpJsmA3a	true	-9542.0	NULL	35572576	-9772757.5639	9542.0	16523.0	5.37992273E7
-LAFo0rFpPj1aW8Js4Scpa	true	2719.0	NULL	-10136432	-9760496.5639	-2719.0	4262.0	-1.533012985E7
-OHG2wWD83Ba	false	6914.0	NULL	-25775392	-9756301.5639	-6914.0	67.0	-3.8982169099999994E7
-PMoJ1NvQoAm5a	true	539.0	NULL	-2009392	-9762676.5639	-539.0	6442.0	-3038962.8499999996
-QTTWGUR2P2b08Dn62ea	false	-16086.0	NULL	59968608	-9779301.5639	16086.0	23067.0	9.069528089999999E7
-S7UM6KgdxTofi6rwXBFa2a	false	12520.0	NULL	-46674560	-9750695.5639	-12520.0	-5539.0	-7.0589638E7
-Sd8C6q6L7l72qsa	false	5306.0	NULL	-19780768	-9757909.5639	-5306.0	1675.0	-2.99160239E7
-Tt484a	true	754.0	NULL	-2810912	-9762461.5639	-754.0	6227.0	-4251165.1
-Vb8ub0i0Maa	true	-9883.0	NULL	36843824	-9773098.5639	9883.0	16864.0	5.5721836449999996E7
-a	false	3350.0	NULL	-12488800	-9759865.5639	-3350.0	3631.0	-1.88878025E7
-a	true	-2944.0	NULL	10975232	-9766159.5639	2944.0	9925.0	1.65987136E7
-a	true	-5905.0	NULL	22013840	-9769120.5639	5905.0	12886.0	3.3293275749999996E7
-a	true	12004.0	NULL	-44750912	-9751211.5639	-12004.0	-5023.0	-6.76803526E7
-a	true	4991.0	NULL	-18606448	-9758224.5639	-4991.0	1990.0	-2.814000665E7
-bBAKio7bAmQq7vIlsc8H14a	true	1949.0	NULL	-7265872	-9761266.5639	-1949.0	5032.0	-1.098875435E7
-dun2EEixI701imr3d6a	true	-8352.0	NULL	31136256	-9771567.5639	8352.0	15333.0	4.70898288E7
-eNsh5tYa	false	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-f3oGa8ByjMs5eo7462S84Aa	false	4278.0	NULL	-15948384	-9758937.5639	-4278.0	2703.0	-2.41200057E7
-hQAra	true	14460.0	NULL	-53906880	-9748755.5639	-14460.0	-7479.0	-8.1527649E7
-hnq6hkAfna	true	5926.0	NULL	-22092128	-9757289.5639	-5926.0	1055.0	-3.34116769E7
-iS4P5128HY44wa	false	3890.0	NULL	-14501920	-9759325.5639	-3890.0	3091.0	-2.19324035E7
-kro4Xu41bB7hiFa	false	-3277.0	NULL	12216656	-9766492.5639	3277.0	10258.0	1.8476217549999997E7
-lJ63qx87BLmdMfa	false	11619.0	NULL	-43315632	-9751596.5639	-11619.0	-4638.0	-6.5509664849999994E7
-oTh026tl2Ena	false	-11198.0	NULL	41746144	-9774413.5639	11198.0	18179.0	6.3136003699999996E7
-w62rRn0DnCSWJ1ht6qWa	false	-5638.15	NULL	958096	-9768853.7139	5638.15	12619.15	3.1788735422499996E7


Mime
View raw message