http://git-wip-us.apache.org/repos/asf/hive/blob/9a59592e/ql/src/test/results/clientpositive/spark/parquet_vectorization_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/parquet_vectorization_1.q.out b/ql/src/test/results/clientpositive/spark/parquet_vectorization_1.q.out new file mode 100644 index 0000000..59a58e7 --- /dev/null +++ b/ql/src/test/results/clientpositive/spark/parquet_vectorization_1.q.out @@ -0,0 +1,217 @@ +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 + 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: 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: 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: 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] + 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:double, VALUE._col2:tinyint, VALUE._col3:int, VALUE._col4:struct<count:bigint,sum:double,variance:double>, VALUE._col5:bigint + partitionColumnCount: 0 + scratchColumnTypeNames: [] + 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) + Group By Vectorization: + aggregators: VectorUDAFVarFinal(col 0:struct<count:bigint,sum:double,variance:double>) -> double aggregation: var_pop, VectorUDAFSumDouble(col 1:double) -> double, VectorUDAFMaxLong(col 2:tinyint) -> tinyint, VectorUDAFMaxLong(col 3:int) -> int, VectorUDAFVarFinal(col 4:struct<count:bigint,sum:double,variance:double>) -> double aggregation: var_samp, VectorUDAFCountMerge(col 5:bigint) -> bigint + 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: 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 + Select Vectorization: + className: VectorSelectOperator + native: true + projectedOutputColumnNums: [0, 6, 1, 7, 9, 2, 8, 3, 12, 4, 13, 5, 14] + selectExpressions: DoubleColDivideDoubleScalar(col 0:double, val -26.28) -> 6:double, DoubleScalarAddDoubleColumn(val -1.389, col 1:double) -> 7:double, DoubleColMultiplyDoubleColumn(col 1:double, col 8:double)(children: DoubleScalarAddDoubleColumn(val -1.389, col 1:double) -> 8:double) -> 9:double, DoubleColUnaryMinus(col 10:double)(children: DoubleColMultiplyDoubleColumn(col 1:double, col 8:double)(children: DoubleScalarAddDoubleColumn(val -1.389, col 1:double) -> 8:double) -> 10:double) -> 8:double, DecimalColMultiplyDecimalScalar(col 11:decimal(10,0), val 79.553)(children: CastLongToDecimal(col 3:int) -> 11:decimal(10,0)) -> 12:decimal(16,3), DoubleScalarModuloDoubleColumn(val 10.175, col 10:double)(children: DoubleColUnaryMinus(col 13:double)(children: DoubleColMultiplyDoubleColumn(col 1:double, col 10:double)(children: DoubleScalarAddDoubleColumn(val -1.389, col 1:double) -> 10:double) -> 13:double) -> 10:double) -> 13:double, LongScalarModuloLongColumn(v al -563, col 3:int) -> 14:int + Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + File Sink Vectorization: + className: VectorFileSinkOperator + native: 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/9a59592e/ql/src/test/results/clientpositive/spark/parquet_vectorization_10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/parquet_vectorization_10.q.out b/ql/src/test/results/clientpositive/spark/parquet_vectorization_10.q.out new file mode 100644 index 0000000..25ff960 --- /dev/null +++ b/ql/src/test/results/clientpositive/spark/parquet_vectorization_10.q.out @@ -0,0 +1,412 @@ +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 + Spark +#### 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: 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:smallint) -> 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/9a59592e/ql/src/test/results/clientpositive/spark/parquet_vectorization_11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/parquet_vectorization_11.q.out b/ql/src/test/results/clientpositive/spark/parquet_vectorization_11.q.out new file mode 100644 index 0000000..e2d8465 --- /dev/null +++ b/ql/src/test/results/clientpositive/spark/parquet_vectorization_11.q.out @@ -0,0 +1,176 @@ +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 + Spark +#### 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: 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
