You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/08/06 01:05:48 UTC
svn commit: r1616043 [6/7] - in /hive/trunk: itests/qtest/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/exec/tez/
ql/src/java/org/apache/hadoop/hive/ql/exec/vector/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ph...
Added: hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out?rev=1616043&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out Tue Aug 5 23:05:47 2014
@@ -0,0 +1,6626 @@
+WARNING: Comparing a bigint and a double may result in a loss of precision.
+PREHOOK: query: -- If you look at ql/src/test/org/apache/hadoop/hive/ql/exec/vector/util/OrcFileGenerator.java
+-- which is the data generation class you'll see that those values are specified in the
+-- initializeFixedPointValues for each data type. When I created the queries I usedthose values
+-- where I needed scalar values to ensure that when the queries executed their predicates would be
+-- filtering on values that are guaranteed to exist.
+
+-- Beyond those values, all the other data in the alltypesorc file is random, but there is a
+-- specific pattern to the data that is important for coverage. In orc and subsequently
+-- vectorization there are a number of optimizations for certain data patterns: AllValues, NoNulls,
+-- RepeatingValue, RepeatingNull. The data in alltypesorc is generated such that each column has
+-- exactly 3 batches of each data pattern. This gives us coverage for the vector expression
+-- optimizations and ensure the metadata in appropriately set on the row batch object which are
+-- reused across batches.
+
+-- For the queries themselves in order to efficiently cover as much of the new vectorization
+-- functionality as I could I used a number of different techniques to create the
+-- vectorization_short_regress.q test suite, primarily equivalence classes, and pairwise
+-- combinations.
+
+-- First I divided the search space into a number of dimensions such as type, aggregate function,
+-- filter operation, arithmetic operation, etc. The types were explored as equivalence classes of
+-- long, double, time, string, and bool. Also, rather than creating a very large number of small
+-- queries the resulting vectors were grouped by compatible dimensions to reduce the number of
+-- queries.
+
+-- TargetTypeClasses: Long, Timestamp, Double, String, Bool
+-- Functions: Avg, Sum, StDevP, StDev, Var, Min, Count
+-- ArithmeticOps: Add, Multiply, Subtract, Divide
+-- FilterOps: Equal, NotEqual, GreaterThan, LessThan, LessThanOrEqual
+-- GroupBy: NoGroupByProjectAggs
+EXPLAIN SELECT AVG(cint),
+ (AVG(cint) + -3728),
+ (-((AVG(cint) + -3728))),
+ (-((-((AVG(cint) + -3728))))),
+ ((-((-((AVG(cint) + -3728))))) * (AVG(cint) + -3728)),
+ SUM(cdouble),
+ (-(AVG(cint))),
+ STDDEV_POP(cint),
+ (((-((-((AVG(cint) + -3728))))) * (AVG(cint) + -3728)) * (-((-((AVG(cint) + -3728)))))),
+ STDDEV_SAMP(csmallint),
+ (-(STDDEV_POP(cint))),
+ (STDDEV_POP(cint) - (-((-((AVG(cint) + -3728)))))),
+ ((STDDEV_POP(cint) - (-((-((AVG(cint) + -3728)))))) * STDDEV_POP(cint)),
+ VAR_SAMP(cint),
+ AVG(cfloat),
+ (10.175 - VAR_SAMP(cint)),
+ (-((10.175 - VAR_SAMP(cint)))),
+ ((-(STDDEV_POP(cint))) / -563),
+ STDDEV_SAMP(cint),
+ (-(((-(STDDEV_POP(cint))) / -563))),
+ (AVG(cint) / SUM(cdouble)),
+ MIN(ctinyint),
+ COUNT(csmallint),
+ (MIN(ctinyint) / ((-(STDDEV_POP(cint))) / -563)),
+ (-((AVG(cint) / SUM(cdouble))))
+FROM alltypesorc
+WHERE ((762 = cbigint)
+ OR ((csmallint < cfloat)
+ AND ((ctimestamp2 > -10669)
+ AND (cdouble != cint)))
+ OR (cstring1 = 'a')
+ OR ((cbigint <= -1.389)
+ AND ((cstring2 != 'a')
+ AND ((79.553 != cint)
+ AND (cboolean2 != cboolean1)))))
+PREHOOK: type: QUERY
+POSTHOOK: query: -- If you look at ql/src/test/org/apache/hadoop/hive/ql/exec/vector/util/OrcFileGenerator.java
+-- which is the data generation class you'll see that those values are specified in the
+-- initializeFixedPointValues for each data type. When I created the queries I usedthose values
+-- where I needed scalar values to ensure that when the queries executed their predicates would be
+-- filtering on values that are guaranteed to exist.
+
+-- Beyond those values, all the other data in the alltypesorc file is random, but there is a
+-- specific pattern to the data that is important for coverage. In orc and subsequently
+-- vectorization there are a number of optimizations for certain data patterns: AllValues, NoNulls,
+-- RepeatingValue, RepeatingNull. The data in alltypesorc is generated such that each column has
+-- exactly 3 batches of each data pattern. This gives us coverage for the vector expression
+-- optimizations and ensure the metadata in appropriately set on the row batch object which are
+-- reused across batches.
+
+-- For the queries themselves in order to efficiently cover as much of the new vectorization
+-- functionality as I could I used a number of different techniques to create the
+-- vectorization_short_regress.q test suite, primarily equivalence classes, and pairwise
+-- combinations.
+
+-- First I divided the search space into a number of dimensions such as type, aggregate function,
+-- filter operation, arithmetic operation, etc. The types were explored as equivalence classes of
+-- long, double, time, string, and bool. Also, rather than creating a very large number of small
+-- queries the resulting vectors were grouped by compatible dimensions to reduce the number of
+-- queries.
+
+-- TargetTypeClasses: Long, Timestamp, Double, String, Bool
+-- Functions: Avg, Sum, StDevP, StDev, Var, Min, Count
+-- ArithmeticOps: Add, Multiply, Subtract, Divide
+-- FilterOps: Equal, NotEqual, GreaterThan, LessThan, LessThanOrEqual
+-- GroupBy: NoGroupByProjectAggs
+EXPLAIN SELECT AVG(cint),
+ (AVG(cint) + -3728),
+ (-((AVG(cint) + -3728))),
+ (-((-((AVG(cint) + -3728))))),
+ ((-((-((AVG(cint) + -3728))))) * (AVG(cint) + -3728)),
+ SUM(cdouble),
+ (-(AVG(cint))),
+ STDDEV_POP(cint),
+ (((-((-((AVG(cint) + -3728))))) * (AVG(cint) + -3728)) * (-((-((AVG(cint) + -3728)))))),
+ STDDEV_SAMP(csmallint),
+ (-(STDDEV_POP(cint))),
+ (STDDEV_POP(cint) - (-((-((AVG(cint) + -3728)))))),
+ ((STDDEV_POP(cint) - (-((-((AVG(cint) + -3728)))))) * STDDEV_POP(cint)),
+ VAR_SAMP(cint),
+ AVG(cfloat),
+ (10.175 - VAR_SAMP(cint)),
+ (-((10.175 - VAR_SAMP(cint)))),
+ ((-(STDDEV_POP(cint))) / -563),
+ STDDEV_SAMP(cint),
+ (-(((-(STDDEV_POP(cint))) / -563))),
+ (AVG(cint) / SUM(cdouble)),
+ MIN(ctinyint),
+ COUNT(csmallint),
+ (MIN(ctinyint) / ((-(STDDEV_POP(cint))) / -563)),
+ (-((AVG(cint) / SUM(cdouble))))
+FROM alltypesorc
+WHERE ((762 = cbigint)
+ OR ((csmallint < cfloat)
+ AND ((ctimestamp2 > -10669)
+ AND (cdouble != cint)))
+ OR (cstring1 = 'a')
+ OR ((cbigint <= -1.389)
+ AND ((cstring2 != 'a')
+ AND ((79.553 != cint)
+ AND (cboolean2 != cboolean1)))))
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: alltypesorc
+ Statistics: Num rows: 1347 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((((762 = cbigint) or ((csmallint < cfloat) and ((ctimestamp2 > (- 10669)) and (cdouble <> cint)))) or (cstring1 = 'a')) or ((cbigint <= (- 1.389)) and ((cstring2 <> 'a') and ((79.553 <> cint) and (cboolean2 <> cboolean1))))) (type: boolean)
+ Statistics: Num rows: 1347 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: cint (type: int), cdouble (type: double), csmallint (type: smallint), cfloat (type: float), ctinyint (type: tinyint)
+ outputColumnNames: cint, cdouble, csmallint, cfloat, ctinyint
+ Statistics: Num rows: 1347 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: avg(cint), sum(cdouble), stddev_pop(cint), stddev_samp(csmallint), var_samp(cint), avg(cfloat), stddev_samp(cint), min(ctinyint), count(csmallint)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
+ Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: struct<count:bigint,sum:double,input:int>), _col1 (type: double), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: struct<count:bigint,sum:double,variance:double>), _col4 (type: struct<count:bigint,sum:double,variance:double>), _col5 (type: struct<count:bigint,sum:double,input:float>), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: tinyint), _col8 (type: bigint)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: avg(VALUE._col0), sum(VALUE._col1), stddev_pop(VALUE._col2), stddev_samp(VALUE._col3), var_samp(VALUE._col4), avg(VALUE._col5), stddev_samp(VALUE._col6), min(VALUE._col7), count(VALUE._col8)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 1 Data size: 68 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: double), (_col0 + (- 3728)) (type: double), (- (_col0 + (- 3728))) (type: double), (- (- (_col0 + (- 3728)))) (type: double), ((- (- (_col0 + (- 3728)))) * (_col0 + (- 3728))) (type: double), _col1 (type: double), (- _col0) (type: double), _col2 (type: double), (((- (- (_col0 + (- 3728)))) * (_col0 + (- 3728))) * (- (- (_col0 + (- 3728))))) (type: double), _col3 (type: double), (- _col2) (type: double), (_col2 - (- (- (_col0 + (- 3728))))) (type: double), ((_col2 - (- (- (_col0 + (- 3728))))) * _col2) (type: double), _col4 (type: double), _col5 (type: double), (10.175 - _col4) (type: double), (- (10.175 - _col4)) (type: double), ((- _col2) / (- 563)) (type: double), _col6 (type: double), (- ((- _col2) / (- 563))) (type: double), (_col0 / _col1) (type: double), _col7 (type: tinyint), _col8 (type: bigint), (_col7 / ((- _col2) / (- 563))) (type: double), (- (_col0 / _col1)) (type: double)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24
+ Statistics: Num rows: 1 Data size: 68 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 68 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+WARNING: Comparing a bigint and a double may result in a loss of precision.
+PREHOOK: query: SELECT AVG(cint),
+ (AVG(cint) + -3728),
+ (-((AVG(cint) + -3728))),
+ (-((-((AVG(cint) + -3728))))),
+ ((-((-((AVG(cint) + -3728))))) * (AVG(cint) + -3728)),
+ SUM(cdouble),
+ (-(AVG(cint))),
+ STDDEV_POP(cint),
+ (((-((-((AVG(cint) + -3728))))) * (AVG(cint) + -3728)) * (-((-((AVG(cint) + -3728)))))),
+ STDDEV_SAMP(csmallint),
+ (-(STDDEV_POP(cint))),
+ (STDDEV_POP(cint) - (-((-((AVG(cint) + -3728)))))),
+ ((STDDEV_POP(cint) - (-((-((AVG(cint) + -3728)))))) * STDDEV_POP(cint)),
+ VAR_SAMP(cint),
+ AVG(cfloat),
+ (10.175 - VAR_SAMP(cint)),
+ (-((10.175 - VAR_SAMP(cint)))),
+ ((-(STDDEV_POP(cint))) / -563),
+ STDDEV_SAMP(cint),
+ (-(((-(STDDEV_POP(cint))) / -563))),
+ (AVG(cint) / SUM(cdouble)),
+ MIN(ctinyint),
+ COUNT(csmallint),
+ (MIN(ctinyint) / ((-(STDDEV_POP(cint))) / -563)),
+ (-((AVG(cint) / SUM(cdouble))))
+FROM alltypesorc
+WHERE ((762 = cbigint)
+ OR ((csmallint < cfloat)
+ AND ((ctimestamp2 > -10669)
+ AND (cdouble != cint)))
+ OR (cstring1 = 'a')
+ OR ((cbigint <= -1.389)
+ AND ((cstring2 != 'a')
+ AND ((79.553 != cint)
+ AND (cboolean2 != cboolean1)))))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT AVG(cint),
+ (AVG(cint) + -3728),
+ (-((AVG(cint) + -3728))),
+ (-((-((AVG(cint) + -3728))))),
+ ((-((-((AVG(cint) + -3728))))) * (AVG(cint) + -3728)),
+ SUM(cdouble),
+ (-(AVG(cint))),
+ STDDEV_POP(cint),
+ (((-((-((AVG(cint) + -3728))))) * (AVG(cint) + -3728)) * (-((-((AVG(cint) + -3728)))))),
+ STDDEV_SAMP(csmallint),
+ (-(STDDEV_POP(cint))),
+ (STDDEV_POP(cint) - (-((-((AVG(cint) + -3728)))))),
+ ((STDDEV_POP(cint) - (-((-((AVG(cint) + -3728)))))) * STDDEV_POP(cint)),
+ VAR_SAMP(cint),
+ AVG(cfloat),
+ (10.175 - VAR_SAMP(cint)),
+ (-((10.175 - VAR_SAMP(cint)))),
+ ((-(STDDEV_POP(cint))) / -563),
+ STDDEV_SAMP(cint),
+ (-(((-(STDDEV_POP(cint))) / -563))),
+ (AVG(cint) / SUM(cdouble)),
+ MIN(ctinyint),
+ COUNT(csmallint),
+ (MIN(ctinyint) / ((-(STDDEV_POP(cint))) / -563)),
+ (-((AVG(cint) / SUM(cdouble))))
+FROM alltypesorc
+WHERE ((762 = cbigint)
+ OR ((csmallint < cfloat)
+ AND ((ctimestamp2 > -10669)
+ AND (cdouble != cint)))
+ OR (cstring1 = 'a')
+ OR ((cbigint <= -1.389)
+ AND ((cstring2 != 'a')
+ AND ((79.553 != cint)
+ AND (cboolean2 != cboolean1)))))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+1.3811354728837386E8 1.3810981928837386E8 -1.3810981928837386E8 1.3810981928837386E8 1.9074322183867284E16 -7194110.964000001 -1.3811354728837386E8 5.591531911809615E8 2.6343511898621314E24 8744.962036962406 -5.591531911809615E8 4.2104337189258766E8 2.35427745019332736E17 3.1277112522199501E17 -6.505246065861778 -3.1277112522199501E17 3.1277112522199501E17 993167.3022752424 5.592594435697935E8 -993167.3022752424 -19.198139697803782 -64 1858 -6.444030109869978E-5 19.198139697803782
+PREHOOK: query: -- TargetTypeClasses: Long, Bool, Double, String, Timestamp
+-- Functions: Max, VarP, StDevP, Avg, Min, StDev, Var
+-- ArithmeticOps: Divide, Multiply, Remainder, Subtract
+-- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like, RLike
+-- GroupBy: NoGroupByProjectAggs
+EXPLAIN SELECT MAX(cint),
+ (MAX(cint) / -3728),
+ (MAX(cint) * -3728),
+ VAR_POP(cbigint),
+ (-((MAX(cint) * -3728))),
+ STDDEV_POP(csmallint),
+ (-563 % (MAX(cint) * -3728)),
+ (VAR_POP(cbigint) / STDDEV_POP(csmallint)),
+ (-(STDDEV_POP(csmallint))),
+ MAX(cdouble),
+ AVG(ctinyint),
+ (STDDEV_POP(csmallint) - 10.175),
+ MIN(cint),
+ ((MAX(cint) * -3728) % (STDDEV_POP(csmallint) - 10.175)),
+ (-(MAX(cdouble))),
+ MIN(cdouble),
+ (MAX(cdouble) % -26.28),
+ STDDEV_SAMP(csmallint),
+ (-((MAX(cint) / -3728))),
+ ((-((MAX(cint) * -3728))) % (-563 % (MAX(cint) * -3728))),
+ ((MAX(cint) / -3728) - AVG(ctinyint)),
+ (-((MAX(cint) * -3728))),
+ VAR_SAMP(cint)
+FROM alltypesorc
+WHERE (((cbigint <= 197)
+ AND (cint < cbigint))
+ OR ((cdouble >= -26.28)
+ AND (csmallint > cdouble))
+ OR ((ctinyint > cfloat)
+ AND (cstring1 RLIKE '.*ss.*'))
+ OR ((cfloat > 79.553)
+ AND (cstring2 LIKE '10%')))
+PREHOOK: type: QUERY
+POSTHOOK: query: -- TargetTypeClasses: Long, Bool, Double, String, Timestamp
+-- Functions: Max, VarP, StDevP, Avg, Min, StDev, Var
+-- ArithmeticOps: Divide, Multiply, Remainder, Subtract
+-- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like, RLike
+-- GroupBy: NoGroupByProjectAggs
+EXPLAIN SELECT MAX(cint),
+ (MAX(cint) / -3728),
+ (MAX(cint) * -3728),
+ VAR_POP(cbigint),
+ (-((MAX(cint) * -3728))),
+ STDDEV_POP(csmallint),
+ (-563 % (MAX(cint) * -3728)),
+ (VAR_POP(cbigint) / STDDEV_POP(csmallint)),
+ (-(STDDEV_POP(csmallint))),
+ MAX(cdouble),
+ AVG(ctinyint),
+ (STDDEV_POP(csmallint) - 10.175),
+ MIN(cint),
+ ((MAX(cint) * -3728) % (STDDEV_POP(csmallint) - 10.175)),
+ (-(MAX(cdouble))),
+ MIN(cdouble),
+ (MAX(cdouble) % -26.28),
+ STDDEV_SAMP(csmallint),
+ (-((MAX(cint) / -3728))),
+ ((-((MAX(cint) * -3728))) % (-563 % (MAX(cint) * -3728))),
+ ((MAX(cint) / -3728) - AVG(ctinyint)),
+ (-((MAX(cint) * -3728))),
+ VAR_SAMP(cint)
+FROM alltypesorc
+WHERE (((cbigint <= 197)
+ AND (cint < cbigint))
+ OR ((cdouble >= -26.28)
+ AND (csmallint > cdouble))
+ OR ((ctinyint > cfloat)
+ AND (cstring1 RLIKE '.*ss.*'))
+ OR ((cfloat > 79.553)
+ AND (cstring2 LIKE '10%')))
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: alltypesorc
+ Statistics: Num rows: 1626 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (((((cbigint <= 197) and (cint < cbigint)) or ((cdouble >= (- 26.28)) and (csmallint > cdouble))) or ((ctinyint > cfloat) and (cstring1 rlike '.*ss.*'))) or ((cfloat > 79.553) and (cstring2 like '10%'))) (type: boolean)
+ Statistics: Num rows: 902 Data size: 209266 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: cint (type: int), cbigint (type: bigint), csmallint (type: smallint), cdouble (type: double), ctinyint (type: tinyint)
+ outputColumnNames: cint, cbigint, csmallint, cdouble, ctinyint
+ Statistics: Num rows: 902 Data size: 209266 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: max(cint), var_pop(cbigint), stddev_pop(csmallint), max(cdouble), avg(ctinyint), min(cint), min(cdouble), stddev_samp(csmallint), var_samp(cint)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
+ Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: int), _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: double), _col4 (type: struct<count:bigint,sum:double,input:tinyint>), _col5 (type: int), _col6 (type: double), _col7 (type: struct<count:bigint,sum:double,variance:double>), _col8 (type: struct<count:bigint,sum:double,variance:double>)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: max(VALUE._col0), var_pop(VALUE._col1), stddev_pop(VALUE._col2), max(VALUE._col3), avg(VALUE._col4), min(VALUE._col5), min(VALUE._col6), stddev_samp(VALUE._col7), var_samp(VALUE._col8)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: int), (_col0 / (- 3728)) (type: double), (_col0 * (- 3728)) (type: int), _col1 (type: double), (- (_col0 * (- 3728))) (type: int), _col2 (type: double), ((- 563) % (_col0 * (- 3728))) (type: int), (_col1 / _col2) (type: double), (- _col2) (type: double), _col3 (type: double), _col4 (type: double), (_col2 - 10.175) (type: double), _col5 (type: int), ((_col0 * (- 3728)) % (_col2 - 10.175)) (type: double), (- _col3) (type: double), _col6 (type: double), (_col3 % (- 26.28)) (type: double), _col7 (type: double), (- (_col0 / (- 3728))) (type: double), ((- (_col0 * (- 3728))) % ((- 563) % (_col0 * (- 3728)))) (type: int), ((_col0 / (- 3728)) - _col4) (type: double), (- (_col0 * (- 3728))) (type: int), _col8 (type: double)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22
+ Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: SELECT MAX(cint),
+ (MAX(cint) / -3728),
+ (MAX(cint) * -3728),
+ VAR_POP(cbigint),
+ (-((MAX(cint) * -3728))),
+ STDDEV_POP(csmallint),
+ (-563 % (MAX(cint) * -3728)),
+ (VAR_POP(cbigint) / STDDEV_POP(csmallint)),
+ (-(STDDEV_POP(csmallint))),
+ MAX(cdouble),
+ AVG(ctinyint),
+ (STDDEV_POP(csmallint) - 10.175),
+ MIN(cint),
+ ((MAX(cint) * -3728) % (STDDEV_POP(csmallint) - 10.175)),
+ (-(MAX(cdouble))),
+ MIN(cdouble),
+ (MAX(cdouble) % -26.28),
+ STDDEV_SAMP(csmallint),
+ (-((MAX(cint) / -3728))),
+ ((-((MAX(cint) * -3728))) % (-563 % (MAX(cint) * -3728))),
+ ((MAX(cint) / -3728) - AVG(ctinyint)),
+ (-((MAX(cint) * -3728))),
+ VAR_SAMP(cint)
+FROM alltypesorc
+WHERE (((cbigint <= 197)
+ AND (cint < cbigint))
+ OR ((cdouble >= -26.28)
+ AND (csmallint > cdouble))
+ OR ((ctinyint > cfloat)
+ AND (cstring1 RLIKE '.*ss.*'))
+ OR ((cfloat > 79.553)
+ AND (cstring2 LIKE '10%')))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT MAX(cint),
+ (MAX(cint) / -3728),
+ (MAX(cint) * -3728),
+ VAR_POP(cbigint),
+ (-((MAX(cint) * -3728))),
+ STDDEV_POP(csmallint),
+ (-563 % (MAX(cint) * -3728)),
+ (VAR_POP(cbigint) / STDDEV_POP(csmallint)),
+ (-(STDDEV_POP(csmallint))),
+ MAX(cdouble),
+ AVG(ctinyint),
+ (STDDEV_POP(csmallint) - 10.175),
+ MIN(cint),
+ ((MAX(cint) * -3728) % (STDDEV_POP(csmallint) - 10.175)),
+ (-(MAX(cdouble))),
+ MIN(cdouble),
+ (MAX(cdouble) % -26.28),
+ STDDEV_SAMP(csmallint),
+ (-((MAX(cint) / -3728))),
+ ((-((MAX(cint) * -3728))) % (-563 % (MAX(cint) * -3728))),
+ ((MAX(cint) / -3728) - AVG(ctinyint)),
+ (-((MAX(cint) * -3728))),
+ VAR_SAMP(cint)
+FROM alltypesorc
+WHERE (((cbigint <= 197)
+ AND (cint < cbigint))
+ OR ((cdouble >= -26.28)
+ AND (csmallint > cdouble))
+ OR ((ctinyint > cfloat)
+ AND (cstring1 RLIKE '.*ss.*'))
+ OR ((cfloat > 79.553)
+ AND (cstring2 LIKE '10%')))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+-20301111 5445.576984978541 -1626869520 7.9684972882908944E16 1626869520 NULL -563 NULL NULL NULL -8.935323383084578 NULL -1069736047 NULL NULL NULL NULL NULL -5445.576984978541 511 5454.512308361625 1626869520 7.2647256545687792E16
+PREHOOK: query: -- TargetTypeClasses: String, Long, Bool, Double, Timestamp
+-- Functions: VarP, Count, Max, StDevP, StDev, Avg
+-- ArithmeticOps: Subtract, Remainder, Multiply, Add
+-- FilterOps: Equal, LessThanOrEqual, GreaterThan, Like, LessThan
+-- GroupBy: NoGroupByProjectAggs
+EXPLAIN SELECT VAR_POP(cbigint),
+ (-(VAR_POP(cbigint))),
+ (VAR_POP(cbigint) - (-(VAR_POP(cbigint)))),
+ COUNT(*),
+ (COUNT(*) % 79.553),
+ MAX(ctinyint),
+ (COUNT(*) - (-(VAR_POP(cbigint)))),
+ (-((-(VAR_POP(cbigint))))),
+ (-1 % (-(VAR_POP(cbigint)))),
+ COUNT(*),
+ (-(COUNT(*))),
+ STDDEV_POP(csmallint),
+ (-((-((-(VAR_POP(cbigint))))))),
+ (762 * (-(COUNT(*)))),
+ MAX(cint),
+ (MAX(ctinyint) + (762 * (-(COUNT(*))))),
+ ((-(VAR_POP(cbigint))) + MAX(cint)),
+ STDDEV_SAMP(cdouble),
+ ((-(COUNT(*))) % COUNT(*)),
+ COUNT(ctinyint),
+ AVG(ctinyint),
+ (-3728 % (MAX(ctinyint) + (762 * (-(COUNT(*))))))
+FROM alltypesorc
+WHERE ((ctimestamp1 = ctimestamp2)
+ OR (762 = cfloat)
+ OR (cstring1 = 'ss')
+ OR ((csmallint <= cbigint)
+ AND (1 = cboolean2))
+ OR ((cboolean1 IS NOT NULL)
+ AND ((ctimestamp2 IS NOT NULL)
+ AND (cstring2 > 'a'))))
+PREHOOK: type: QUERY
+POSTHOOK: query: -- TargetTypeClasses: String, Long, Bool, Double, Timestamp
+-- Functions: VarP, Count, Max, StDevP, StDev, Avg
+-- ArithmeticOps: Subtract, Remainder, Multiply, Add
+-- FilterOps: Equal, LessThanOrEqual, GreaterThan, Like, LessThan
+-- GroupBy: NoGroupByProjectAggs
+EXPLAIN SELECT VAR_POP(cbigint),
+ (-(VAR_POP(cbigint))),
+ (VAR_POP(cbigint) - (-(VAR_POP(cbigint)))),
+ COUNT(*),
+ (COUNT(*) % 79.553),
+ MAX(ctinyint),
+ (COUNT(*) - (-(VAR_POP(cbigint)))),
+ (-((-(VAR_POP(cbigint))))),
+ (-1 % (-(VAR_POP(cbigint)))),
+ COUNT(*),
+ (-(COUNT(*))),
+ STDDEV_POP(csmallint),
+ (-((-((-(VAR_POP(cbigint))))))),
+ (762 * (-(COUNT(*)))),
+ MAX(cint),
+ (MAX(ctinyint) + (762 * (-(COUNT(*))))),
+ ((-(VAR_POP(cbigint))) + MAX(cint)),
+ STDDEV_SAMP(cdouble),
+ ((-(COUNT(*))) % COUNT(*)),
+ COUNT(ctinyint),
+ AVG(ctinyint),
+ (-3728 % (MAX(ctinyint) + (762 * (-(COUNT(*))))))
+FROM alltypesorc
+WHERE ((ctimestamp1 = ctimestamp2)
+ OR (762 = cfloat)
+ OR (cstring1 = 'ss')
+ OR ((csmallint <= cbigint)
+ AND (1 = cboolean2))
+ OR ((cboolean1 IS NOT NULL)
+ AND ((ctimestamp2 IS NOT NULL)
+ AND (cstring2 > 'a'))))
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: alltypesorc
+ Statistics: Num rows: 1178 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (((((ctimestamp1 = ctimestamp2) or (762.0 = cfloat)) or (cstring1 = 'ss')) or ((csmallint <= cbigint) and (1 = cboolean2))) or (cboolean1 is not null and (ctimestamp2 is not null and (cstring2 > 'a')))) (type: boolean)
+ Statistics: Num rows: 1178 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: cbigint (type: bigint), ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cdouble (type: double)
+ outputColumnNames: cbigint, ctinyint, csmallint, cint, cdouble
+ Statistics: Num rows: 1178 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: var_pop(cbigint), count(), max(ctinyint), stddev_pop(csmallint), max(cint), stddev_samp(cdouble), count(ctinyint), avg(ctinyint)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
+ Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: struct<count:bigint,sum:double,variance:double>), _col1 (type: bigint), _col2 (type: tinyint), _col3 (type: struct<count:bigint,sum:double,variance:double>), _col4 (type: int), _col5 (type: struct<count:bigint,sum:double,variance:double>), _col6 (type: bigint), _col7 (type: struct<count:bigint,sum:double,input:tinyint>)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: var_pop(VALUE._col0), count(VALUE._col1), max(VALUE._col2), stddev_pop(VALUE._col3), max(VALUE._col4), stddev_samp(VALUE._col5), count(VALUE._col6), avg(VALUE._col7)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ Statistics: Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: double), (- _col0) (type: double), (_col0 - (- _col0)) (type: double), _col1 (type: bigint), (_col1 % 79.553) (type: double), _col2 (type: tinyint), (_col1 - (- _col0)) (type: double), (- (- _col0)) (type: double), ((- 1) % (- _col0)) (type: double), _col1 (type: bigint), (- _col1) (type: bigint), _col3 (type: double), (- (- (- _col0))) (type: double), (762 * (- _col1)) (type: bigint), _col4 (type: int), (_col2 + (762 * (- _col1))) (type: bigint), ((- _col0) + _col4) (type: double), _col5 (type: double), ((- _col1) % _col1) (type: bigint), _col6 (type: bigint), _col7 (type: double), ((- 3728) % (_col2 + (762 * (- _col1)))) (type: bigint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21
+ Statistics: Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: SELECT VAR_POP(cbigint),
+ (-(VAR_POP(cbigint))),
+ (VAR_POP(cbigint) - (-(VAR_POP(cbigint)))),
+ COUNT(*),
+ (COUNT(*) % 79.553),
+ MAX(ctinyint),
+ (COUNT(*) - (-(VAR_POP(cbigint)))),
+ (-((-(VAR_POP(cbigint))))),
+ (-1 % (-(VAR_POP(cbigint)))),
+ COUNT(*),
+ (-(COUNT(*))),
+ STDDEV_POP(csmallint),
+ (-((-((-(VAR_POP(cbigint))))))),
+ (762 * (-(COUNT(*)))),
+ MAX(cint),
+ (MAX(ctinyint) + (762 * (-(COUNT(*))))),
+ ((-(VAR_POP(cbigint))) + MAX(cint)),
+ STDDEV_SAMP(cdouble),
+ ((-(COUNT(*))) % COUNT(*)),
+ COUNT(ctinyint),
+ AVG(ctinyint),
+ (-3728 % (MAX(ctinyint) + (762 * (-(COUNT(*))))))
+FROM alltypesorc
+WHERE ((ctimestamp1 = ctimestamp2)
+ OR (762 = cfloat)
+ OR (cstring1 = 'ss')
+ OR ((csmallint <= cbigint)
+ AND (1 = cboolean2))
+ OR ((cboolean1 IS NOT NULL)
+ AND ((ctimestamp2 IS NOT NULL)
+ AND (cstring2 > 'a'))))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT VAR_POP(cbigint),
+ (-(VAR_POP(cbigint))),
+ (VAR_POP(cbigint) - (-(VAR_POP(cbigint)))),
+ COUNT(*),
+ (COUNT(*) % 79.553),
+ MAX(ctinyint),
+ (COUNT(*) - (-(VAR_POP(cbigint)))),
+ (-((-(VAR_POP(cbigint))))),
+ (-1 % (-(VAR_POP(cbigint)))),
+ COUNT(*),
+ (-(COUNT(*))),
+ STDDEV_POP(csmallint),
+ (-((-((-(VAR_POP(cbigint))))))),
+ (762 * (-(COUNT(*)))),
+ MAX(cint),
+ (MAX(ctinyint) + (762 * (-(COUNT(*))))),
+ ((-(VAR_POP(cbigint))) + MAX(cint)),
+ STDDEV_SAMP(cdouble),
+ ((-(COUNT(*))) % COUNT(*)),
+ COUNT(ctinyint),
+ AVG(ctinyint),
+ (-3728 % (MAX(ctinyint) + (762 * (-(COUNT(*))))))
+FROM alltypesorc
+WHERE ((ctimestamp1 = ctimestamp2)
+ OR (762 = cfloat)
+ OR (cstring1 = 'ss')
+ OR ((csmallint <= cbigint)
+ AND (1 = cboolean2))
+ OR ((cboolean1 IS NOT NULL)
+ AND ((ctimestamp2 IS NOT NULL)
+ AND (cstring2 > 'a'))))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+2.5109214708345636E18 -2.5109214708345636E18 5.0218429416691272E18 2780 75.19800000000009 62 2.5109214708345661E18 2.5109214708345636E18 -1.0 2780 -2780 9460.675803068349 -2.5109214708345636E18 -2118360 1072872630 -2118298 -2.5109214697616911E18 185935.34910862707 0 758 -1.733509234828496 -3728
+WARNING: Comparing a bigint and a double may result in a loss of precision.
+PREHOOK: query: -- TargetTypeClasses: String, Bool, Timestamp, Long, Double
+-- Functions: Avg, Max, StDev, VarP
+-- ArithmeticOps: Add, Divide, Remainder, Multiply
+-- FilterOps: LessThanOrEqual, NotEqual, GreaterThanOrEqual, LessThan, Equal
+-- GroupBy: NoGroupByProjectAggs
+EXPLAIN SELECT AVG(ctinyint),
+ (AVG(ctinyint) + 6981),
+ ((AVG(ctinyint) + 6981) + AVG(ctinyint)),
+ MAX(cbigint),
+ (((AVG(ctinyint) + 6981) + AVG(ctinyint)) / AVG(ctinyint)),
+ (-((AVG(ctinyint) + 6981))),
+ STDDEV_SAMP(cint),
+ (AVG(ctinyint) % (-((AVG(ctinyint) + 6981)))),
+ VAR_POP(cint),
+ VAR_POP(cbigint),
+ (-(MAX(cbigint))),
+ ((-(MAX(cbigint))) / STDDEV_SAMP(cint)),
+ MAX(cfloat),
+ (VAR_POP(cbigint) * -26.28)
+FROM alltypesorc
+WHERE (((ctimestamp2 <= ctimestamp1)
+ AND ((cbigint != cdouble)
+ AND ('ss' <= cstring1)))
+ OR ((csmallint < ctinyint)
+ AND (ctimestamp1 >= 0))
+ OR (cfloat = 17))
+PREHOOK: type: QUERY
+POSTHOOK: query: -- TargetTypeClasses: String, Bool, Timestamp, Long, Double
+-- Functions: Avg, Max, StDev, VarP
+-- ArithmeticOps: Add, Divide, Remainder, Multiply
+-- FilterOps: LessThanOrEqual, NotEqual, GreaterThanOrEqual, LessThan, Equal
+-- GroupBy: NoGroupByProjectAggs
+EXPLAIN SELECT AVG(ctinyint),
+ (AVG(ctinyint) + 6981),
+ ((AVG(ctinyint) + 6981) + AVG(ctinyint)),
+ MAX(cbigint),
+ (((AVG(ctinyint) + 6981) + AVG(ctinyint)) / AVG(ctinyint)),
+ (-((AVG(ctinyint) + 6981))),
+ STDDEV_SAMP(cint),
+ (AVG(ctinyint) % (-((AVG(ctinyint) + 6981)))),
+ VAR_POP(cint),
+ VAR_POP(cbigint),
+ (-(MAX(cbigint))),
+ ((-(MAX(cbigint))) / STDDEV_SAMP(cint)),
+ MAX(cfloat),
+ (VAR_POP(cbigint) * -26.28)
+FROM alltypesorc
+WHERE (((ctimestamp2 <= ctimestamp1)
+ AND ((cbigint != cdouble)
+ AND ('ss' <= cstring1)))
+ OR ((csmallint < ctinyint)
+ AND (ctimestamp1 >= 0))
+ OR (cfloat = 17))
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: alltypesorc
+ Statistics: Num rows: 1779 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((((ctimestamp2 <= ctimestamp1) and ((cbigint <> cdouble) and ('ss' <= cstring1))) or ((csmallint < ctinyint) and (ctimestamp1 >= 0))) or (cfloat = 17.0)) (type: boolean)
+ Statistics: Num rows: 1283 Data size: 272060 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: ctinyint (type: tinyint), cbigint (type: bigint), cint (type: int), cfloat (type: float)
+ outputColumnNames: ctinyint, cbigint, cint, cfloat
+ Statistics: Num rows: 1283 Data size: 272060 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: avg(ctinyint), max(cbigint), stddev_samp(cint), var_pop(cint), var_pop(cbigint), max(cfloat)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
+ Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: struct<count:bigint,sum:double,input:tinyint>), _col1 (type: bigint), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: struct<count:bigint,sum:double,variance:double>), _col4 (type: struct<count:bigint,sum:double,variance:double>), _col5 (type: float)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: avg(VALUE._col0), max(VALUE._col1), stddev_samp(VALUE._col2), var_pop(VALUE._col3), var_pop(VALUE._col4), max(VALUE._col5)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 1 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: double), (_col0 + 6981) (type: double), ((_col0 + 6981) + _col0) (type: double), _col1 (type: bigint), (((_col0 + 6981) + _col0) / _col0) (type: double), (- (_col0 + 6981)) (type: double), _col2 (type: double), (_col0 % (- (_col0 + 6981))) (type: double), _col3 (type: double), _col4 (type: double), (- _col1) (type: bigint), ((- _col1) / _col2) (type: double), _col5 (type: float), (_col4 * (- 26.28)) (type: double)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
+ Statistics: Num rows: 1 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+WARNING: Comparing a bigint and a double may result in a loss of precision.
+PREHOOK: query: SELECT AVG(ctinyint),
+ (AVG(ctinyint) + 6981),
+ ((AVG(ctinyint) + 6981) + AVG(ctinyint)),
+ MAX(cbigint),
+ (((AVG(ctinyint) + 6981) + AVG(ctinyint)) / AVG(ctinyint)),
+ (-((AVG(ctinyint) + 6981))),
+ STDDEV_SAMP(cint),
+ (AVG(ctinyint) % (-((AVG(ctinyint) + 6981)))),
+ VAR_POP(cint),
+ VAR_POP(cbigint),
+ (-(MAX(cbigint))),
+ ((-(MAX(cbigint))) / STDDEV_SAMP(cint)),
+ MAX(cfloat),
+ (VAR_POP(cbigint) * -26.28)
+FROM alltypesorc
+WHERE (((ctimestamp2 <= ctimestamp1)
+ AND ((cbigint != cdouble)
+ AND ('ss' <= cstring1)))
+ OR ((csmallint < ctinyint)
+ AND (ctimestamp1 >= 0))
+ OR (cfloat = 17))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT AVG(ctinyint),
+ (AVG(ctinyint) + 6981),
+ ((AVG(ctinyint) + 6981) + AVG(ctinyint)),
+ MAX(cbigint),
+ (((AVG(ctinyint) + 6981) + AVG(ctinyint)) / AVG(ctinyint)),
+ (-((AVG(ctinyint) + 6981))),
+ STDDEV_SAMP(cint),
+ (AVG(ctinyint) % (-((AVG(ctinyint) + 6981)))),
+ VAR_POP(cint),
+ VAR_POP(cbigint),
+ (-(MAX(cbigint))),
+ ((-(MAX(cbigint))) / STDDEV_SAMP(cint)),
+ MAX(cfloat),
+ (VAR_POP(cbigint) * -26.28)
+FROM alltypesorc
+WHERE (((ctimestamp2 <= ctimestamp1)
+ AND ((cbigint != cdouble)
+ AND ('ss' <= cstring1)))
+ OR ((csmallint < ctinyint)
+ AND (ctimestamp1 >= 0))
+ OR (cfloat = 17))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+-0.5934409161894847 6980.406559083811 6979.813118167622 2141851355 -11761.597368421053 -6980.406559083811 1.5852855222071937E8 -0.5934409161894847 2.5099887741860852E16 1.52140608502098816E18 -2141851355 -13.510823917813237 79.553 -3.998255191435157E19
+PREHOOK: query: -- TargetTypeClasses: Timestamp, String, Long, Double, Bool
+-- Functions: Max, Avg, Min, Var, StDev, Count, StDevP, Sum
+-- ArithmeticOps: Multiply, Subtract, Add, Divide
+-- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan, RLike
+-- GroupBy: NoGroupByProjectColumns
+EXPLAIN SELECT cint,
+ cdouble,
+ ctimestamp2,
+ cstring1,
+ cboolean2,
+ ctinyint,
+ cfloat,
+ ctimestamp1,
+ csmallint,
+ cbigint,
+ (-3728 * cbigint),
+ (-(cint)),
+ (-863.257 - cint),
+ (-(csmallint)),
+ (csmallint - (-(csmallint))),
+ ((csmallint - (-(csmallint))) + (-(csmallint))),
+ (cint / cint),
+ ((-863.257 - cint) - -26.28),
+ (-(cfloat)),
+ (cdouble * -89010),
+ (ctinyint / 988888),
+ (-(ctinyint)),
+ (79.553 / ctinyint)
+FROM alltypesorc
+WHERE (((cstring1 RLIKE 'a.*')
+ AND (cstring2 LIKE '%ss%'))
+ OR ((1 != cboolean2)
+ AND ((csmallint < 79.553)
+ AND (-257 != ctinyint)))
+ OR ((cdouble > ctinyint)
+ AND (cfloat >= cint))
+ OR ((cint < cbigint)
+ AND (ctinyint > cbigint)))
+PREHOOK: type: QUERY
+POSTHOOK: query: -- TargetTypeClasses: Timestamp, String, Long, Double, Bool
+-- Functions: Max, Avg, Min, Var, StDev, Count, StDevP, Sum
+-- ArithmeticOps: Multiply, Subtract, Add, Divide
+-- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan, RLike
+-- GroupBy: NoGroupByProjectColumns
+EXPLAIN SELECT cint,
+ cdouble,
+ ctimestamp2,
+ cstring1,
+ cboolean2,
+ ctinyint,
+ cfloat,
+ ctimestamp1,
+ csmallint,
+ cbigint,
+ (-3728 * cbigint),
+ (-(cint)),
+ (-863.257 - cint),
+ (-(csmallint)),
+ (csmallint - (-(csmallint))),
+ ((csmallint - (-(csmallint))) + (-(csmallint))),
+ (cint / cint),
+ ((-863.257 - cint) - -26.28),
+ (-(cfloat)),
+ (cdouble * -89010),
+ (ctinyint / 988888),
+ (-(ctinyint)),
+ (79.553 / ctinyint)
+FROM alltypesorc
+WHERE (((cstring1 RLIKE 'a.*')
+ AND (cstring2 LIKE '%ss%'))
+ OR ((1 != cboolean2)
+ AND ((csmallint < 79.553)
+ AND (-257 != ctinyint)))
+ OR ((cdouble > ctinyint)
+ AND (cfloat >= cint))
+ OR ((cint < cbigint)
+ AND (ctinyint > cbigint)))
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: alltypesorc
+ Statistics: Num rows: 1193 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (((((cstring1 rlike 'a.*') and (cstring2 like '%ss%')) or ((1 <> cboolean2) and ((csmallint < 79.553) and ((- 257) <> ctinyint)))) or ((cdouble > ctinyint) and (cfloat >= cint))) or ((cint < cbigint) and (ctinyint > cbigint))) (type: boolean)
+ Statistics: Num rows: 959 Data size: 303244 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: cint (type: int), cdouble (type: double), ctimestamp2 (type: timestamp), cstring1 (type: string), cboolean2 (type: boolean), ctinyint (type: tinyint), cfloat (type: float), ctimestamp1 (type: timestamp), csmallint (type: smallint), cbigint (type: bigint), ((- 3728) * cbigint) (type: bigint), (- cint) (type: int), ((- 863.257) - cint) (type: double), (- csmallint) (type: smallint), (csmallint - (- csmallint)) (type: smallint), ((csmallint - (- csmallint)) + (- csmallint)) (type: smallint), (cint / cint) (type: double), (((- 863.257) - cint) - (- 26.28)) (type: double), (- cfloat) (type: float), (cdouble * (- 89010)) (type: double), (ctinyint / 988888) (type: double), (- ctinyint) (type: tinyint), (79.553 / ctinyint) (type: double)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22
+ Statistics: Num rows: 959 Data size: 303244 Basic stats: COMPLETE Column stats: NONE
+ ListSink
+
+PREHOOK: query: SELECT cint,
+ cdouble,
+ ctimestamp2,
+ cstring1,
+ cboolean2,
+ ctinyint,
+ cfloat,
+ ctimestamp1,
+ csmallint,
+ cbigint,
+ (-3728 * cbigint),
+ (-(cint)),
+ (-863.257 - cint),
+ (-(csmallint)),
+ (csmallint - (-(csmallint))),
+ ((csmallint - (-(csmallint))) + (-(csmallint))),
+ (cint / cint),
+ ((-863.257 - cint) - -26.28),
+ (-(cfloat)),
+ (cdouble * -89010),
+ (ctinyint / 988888),
+ (-(ctinyint)),
+ (79.553 / ctinyint)
+FROM alltypesorc
+WHERE (((cstring1 RLIKE 'a.*')
+ AND (cstring2 LIKE '%ss%'))
+ OR ((1 != cboolean2)
+ AND ((csmallint < 79.553)
+ AND (-257 != ctinyint)))
+ OR ((cdouble > ctinyint)
+ AND (cfloat >= cint))
+ OR ((cint < cbigint)
+ AND (ctinyint > cbigint)))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT cint,
+ cdouble,
+ ctimestamp2,
+ cstring1,
+ cboolean2,
+ ctinyint,
+ cfloat,
+ ctimestamp1,
+ csmallint,
+ cbigint,
+ (-3728 * cbigint),
+ (-(cint)),
+ (-863.257 - cint),
+ (-(csmallint)),
+ (csmallint - (-(csmallint))),
+ ((csmallint - (-(csmallint))) + (-(csmallint))),
+ (cint / cint),
+ ((-863.257 - cint) - -26.28),
+ (-(cfloat)),
+ (cdouble * -89010),
+ (ctinyint / 988888),
+ (-(ctinyint)),
+ (79.553 / ctinyint)
+FROM alltypesorc
+WHERE (((cstring1 RLIKE 'a.*')
+ AND (cstring2 LIKE '%ss%'))
+ OR ((1 != cboolean2)
+ AND ((csmallint < 79.553)
+ AND (-257 != ctinyint)))
+ OR ((cdouble > ctinyint)
+ AND (cfloat >= cint))
+ OR ((cint < cbigint)
+ AND (ctinyint > cbigint)))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 38 38.0 1969-12-31 16:00:05.478 -200 -1090414113 4065063813264 NULL NULL 200 -400 -200 NULL NULL -38.0 1.7802E7 3.842700083325918E-5 -38 2.0935
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 8 8.0 1969-12-31 15:59:46.007 -200 -1236645308 4610213708224 NULL NULL 200 -400 -200 NULL NULL -8.0 1.7802E7 8.08989491226509E-6 -8 9.944125
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -30 -30.0 1969-12-31 15:59:44.842 -200 -815881183 3041605050224 NULL NULL 200 -400 -200 NULL NULL 30.0 1.7802E7 -3.0337105920994087E-5 30 -2.6517666666666666
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 24 24.0 1969-12-31 15:59:44.55 -200 -499521357 1862215618896 NULL NULL 200 -400 -200 NULL NULL -24.0 1.7802E7 2.426968473679527E-5 -24 3.3147083333333334
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -1 -1.0 1969-12-31 16:00:14.985 -200 384222326 -1432380831328 NULL NULL 200 -400 -200 NULL NULL 1.0 1.7802E7 -1.0112368640331362E-6 1 -79.553
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -39 -39.0 1969-12-31 16:00:13.092 -200 -1111142796 4142340343488 NULL NULL 200 -400 -200 NULL NULL 39.0 1.7802E7 -3.9438237697292314E-5 39 -2.039820512820513
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 22 22.0 1969-12-31 16:00:10.436 -200 -998574307 3722685016496 NULL NULL 200 -400 -200 NULL NULL -22.0 1.7802E7 2.2247211008728996E-5 -22 3.6160454545454543
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 16 16.0 1969-12-31 16:00:02.208 -200 1043214022 -3889101874016 NULL NULL 200 -400 -200 NULL NULL -16.0 1.7802E7 1.617978982453018E-5 -16 4.9720625
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -12 -12.0 1969-12-31 15:59:58.305 -200 -997940806 3720323324768 NULL NULL 200 -400 -200 NULL NULL 12.0 1.7802E7 -1.2134842368397635E-5 12 -6.629416666666667
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 46 46.0 1969-12-31 15:59:54.016 -200 -517349302 1928678197856 NULL NULL 200 -400 -200 NULL NULL -46.0 1.7802E7 4.651689574552426E-5 -46 1.7294130434782609
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 50 50.0 1969-12-31 15:59:57.847 -200 1819421386 -6782802927008 NULL NULL 200 -400 -200 NULL NULL -50.0 1.7802E7 5.056184320165681E-5 -50 1.59106
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -20 -20.0 1969-12-31 15:59:49.764 -200 1115401141 -4158215453648 NULL NULL 200 -400 -200 NULL NULL 20.0 1.7802E7 -2.0224737280662725E-5 20 -3.9776499999999997
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -17 -17.0 1969-12-31 15:59:51.417 -200 1806593648 -6734981119744 NULL NULL 200 -400 -200 NULL NULL 17.0 1.7802E7 -1.7191026688563315E-5 17 -4.679588235294117
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 60 60.0 1969-12-31 15:59:51.342 -200 1981140540 -7385691933120 NULL NULL 200 -400 -200 NULL NULL -60.0 1.7802E7 6.0674211841988174E-5 -60 1.3258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -55 -55.0 1969-12-31 16:00:08.896 -200 862778898 -3216439731744 NULL NULL 200 -400 -200 NULL NULL 55.0 1.7802E7 -5.561802752182249E-5 55 -1.4464181818181818
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 17 17.0 1969-12-31 15:59:47.263 -200 -1100744431 4103575238768 NULL NULL 200 -400 -200 NULL NULL -17.0 1.7802E7 1.7191026688563315E-5 -17 4.679588235294117
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -6 -6.0 1969-12-31 16:00:11.883 -200 -1874590290 6988472601120 NULL NULL 200 -400 -200 NULL NULL 6.0 1.7802E7 -6.067421184198818E-6 6 -13.258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -43 -43.0 1969-12-31 16:00:01.901 -200 1026696124 -3827523150272 NULL NULL 200 -400 -200 NULL NULL 43.0 1.7802E7 -4.3483185153424856E-5 43 -1.8500697674418605
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -22 -22.0 1969-12-31 15:59:53.476 -200 150711504 -561852486912 NULL NULL 200 -400 -200 NULL NULL 22.0 1.7802E7 -2.2247211008728996E-5 22 -3.6160454545454543
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -59 -59.0 1969-12-31 16:00:15.861 -200 254419828 -948477118784 NULL NULL 200 -400 -200 NULL NULL 59.0 1.7802E7 -5.966297497795504E-5 59 -1.3483559322033898
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 17 17.0 1969-12-31 16:00:05.562 -200 -859908363 3205738377264 NULL NULL 200 -400 -200 NULL NULL -17.0 1.7802E7 1.7191026688563315E-5 -17 4.679588235294117
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 6 6.0 1969-12-31 16:00:07.713 -200 -605449705 2257116500240 NULL NULL 200 -400 -200 NULL NULL -6.0 1.7802E7 6.067421184198818E-6 -6 13.258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 49 49.0 1969-12-31 15:59:44.289 -200 1713733703 -6388799244784 NULL NULL 200 -400 -200 NULL NULL -49.0 1.7802E7 4.9550606337623676E-5 -49 1.6235306122448978
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 50 50.0 1969-12-31 15:59:56.217 -200 -1595717723 5948835671344 NULL NULL 200 -400 -200 NULL NULL -50.0 1.7802E7 5.056184320165681E-5 -50 1.59106
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -13 -13.0 1969-12-31 15:59:50.858 -200 -519278910 1935871776480 NULL NULL 200 -400 -200 NULL NULL 13.0 1.7802E7 -1.314607923243077E-5 13 -6.119461538461538
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 33 33.0 1969-12-31 16:00:01.27 -200 -1116511205 4162353772240 NULL NULL 200 -400 -200 NULL NULL -33.0 1.7802E7 3.3370816513093494E-5 -33 2.4106969696969696
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -47 -47.0 1969-12-31 16:00:08.091 -200 1769663274 -6597304685472 NULL NULL 200 -400 -200 NULL NULL 47.0 1.7802E7 -4.7528132609557405E-5 47 -1.6926170212765956
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 19 19.0 1969-12-31 15:59:56.099 -200 1490159561 -5555314843408 NULL NULL 200 -400 -200 NULL NULL -19.0 1.7802E7 1.921350041662959E-5 -19 4.187
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 16 16.0 1969-12-31 15:59:52.751 -200 1918188607 -7151007126896 NULL NULL 200 -400 -200 NULL NULL -16.0 1.7802E7 1.617978982453018E-5 -16 4.9720625
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 25 25.0 1969-12-31 15:59:53.743 -200 1861913153 -6941212234384 NULL NULL 200 -400 -200 NULL NULL -25.0 1.7802E7 2.5280921600828406E-5 -25 3.18212
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 18 18.0 1969-12-31 16:00:15.89 -200 1994361829 -7434980898512 NULL NULL 200 -400 -200 NULL NULL -18.0 1.7802E7 1.820226355259645E-5 -18 4.419611111111111
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -29 -29.0 1969-12-31 15:59:57.882 -200 1896458939 -7069998924592 NULL NULL 200 -400 -200 NULL NULL 29.0 1.7802E7 -2.932586905696095E-5 29 -2.7432068965517242
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -22 -22.0 1969-12-31 16:00:05.218 -200 929143703 -3463847724784 NULL NULL 200 -400 -200 NULL NULL 22.0 1.7802E7 -2.2247211008728996E-5 22 -3.6160454545454543
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 52 52.0 1969-12-31 16:00:04.024 -200 741404204 -2763954872512 NULL NULL 200 -400 -200 NULL NULL -52.0 1.7802E7 5.258431692972308E-5 -52 1.5298653846153845
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -16 -16.0 1969-12-31 15:59:44.453 -200 -1624098865 6054640568720 NULL NULL 200 -400 -200 NULL NULL 16.0 1.7802E7 -1.617978982453018E-5 16 -4.9720625
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -55 -55.0 1969-12-31 16:00:08.229 -200 -1238304032 4616397431296 NULL NULL 200 -400 -200 NULL NULL 55.0 1.7802E7 -5.561802752182249E-5 55 -1.4464181818181818
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -16 -16.0 1969-12-31 16:00:12.574 -200 593383941 -2212135332048 NULL NULL 200 -400 -200 NULL NULL 16.0 1.7802E7 -1.617978982453018E-5 16 -4.9720625
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -14 -14.0 1969-12-31 15:59:58.148 -200 -1449446580 5403536850240 NULL NULL 200 -400 -200 NULL NULL 14.0 1.7802E7 -1.4157316096463906E-5 14 -5.682357142857143
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -29 -29.0 1969-12-31 15:59:46.536 -200 1674924283 -6244117727024 NULL NULL 200 -400 -200 NULL NULL 29.0 1.7802E7 -2.932586905696095E-5 29 -2.7432068965517242
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -60 -60.0 1969-12-31 16:00:10.953 -200 -483910982 1804020140896 NULL NULL 200 -400 -200 NULL NULL 60.0 1.7802E7 -6.0674211841988174E-5 60 -1.3258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 46 46.0 1969-12-31 16:00:09.883 -200 -436888437 1628720093136 NULL NULL 200 -400 -200 NULL NULL -46.0 1.7802E7 4.651689574552426E-5 -46 1.7294130434782609
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -43 -43.0 1969-12-31 15:59:51.43 -200 818800198 -3052487138144 NULL NULL 200 -400 -200 NULL NULL 43.0 1.7802E7 -4.3483185153424856E-5 43 -1.8500697674418605
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -33 -33.0 1969-12-31 15:59:55.755 -200 -567292357 2114865906896 NULL NULL 200 -400 -200 NULL NULL 33.0 1.7802E7 -3.3370816513093494E-5 33 -2.4106969696969696
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -38 -38.0 1969-12-31 15:59:56.769 -200 450485340 -1679409347520 NULL NULL 200 -400 -200 NULL NULL 38.0 1.7802E7 -3.842700083325918E-5 38 -2.0935
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -4 -4.0 1969-12-31 15:59:46.449 -200 -689001045 2568595895760 NULL NULL 200 -400 -200 NULL NULL 4.0 1.7802E7 -4.044947456132545E-6 4 -19.88825
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -50 -50.0 1969-12-31 16:00:13.253 -200 594977020 -2218074330560 NULL NULL 200 -400 -200 NULL NULL 50.0 1.7802E7 -5.056184320165681E-5 50 -1.59106
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 39 39.0 1969-12-31 15:59:46.368 -200 112950540 -421079613120 NULL NULL 200 -400 -200 NULL NULL -39.0 1.7802E7 3.9438237697292314E-5 -39 2.039820512820513
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 38 38.0 1969-12-31 15:59:53.592 -200 1922447714 -7166885077792 NULL NULL 200 -400 -200 NULL NULL -38.0 1.7802E7 3.842700083325918E-5 -38 2.0935
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 17 17.0 1969-12-31 16:00:13.411 -200 -915644003 3413520843184 NULL NULL 200 -400 -200 NULL NULL -17.0 1.7802E7 1.7191026688563315E-5 -17 4.679588235294117
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 16 16.0 1969-12-31 16:00:15.143 -200 -2109772858 7865233214624 NULL NULL 200 -400 -200 NULL NULL -16.0 1.7802E7 1.617978982453018E-5 -16 4.9720625
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 12 12.0 1969-12-31 16:00:08.34 -200 -860934589 3209564147792 NULL NULL 200 -400 -200 NULL NULL -12.0 1.7802E7 1.2134842368397635E-5 -12 6.629416666666667
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 24 24.0 1969-12-31 15:59:58.788 -200 805287817 -3002112981776 NULL NULL 200 -400 -200 NULL NULL -24.0 1.7802E7 2.426968473679527E-5 -24 3.3147083333333334
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -30 -30.0 1969-12-31 16:00:08.346 -200 -1635566862 6097393261536 NULL NULL 200 -400 -200 NULL NULL 30.0 1.7802E7 -3.0337105920994087E-5 30 -2.6517666666666666
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -1 -1.0 1969-12-31 15:59:57.901 -200 -250915199 935411861872 NULL NULL 200 -400 -200 NULL NULL 1.0 1.7802E7 -1.0112368640331362E-6 1 -79.553
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -38 -38.0 1969-12-31 16:00:14.118 -200 1741347818 -6491744665504 NULL NULL 200 -400 -200 NULL NULL 38.0 1.7802E7 -3.842700083325918E-5 38 -2.0935
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -46 -46.0 1969-12-31 15:59:57.646 -200 -624367772 2327643054016 NULL NULL 200 -400 -200 NULL NULL 46.0 1.7802E7 -4.651689574552426E-5 46 -1.7294130434782609
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -59 -59.0 1969-12-31 16:00:06.777 -200 -836004666 3116625394848 NULL NULL 200 -400 -200 NULL NULL 59.0 1.7802E7 -5.966297497795504E-5 59 -1.3483559322033898
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 22 22.0 1969-12-31 16:00:12.112 -200 1395869317 -5203800813776 NULL NULL 200 -400 -200 NULL NULL -22.0 1.7802E7 2.2247211008728996E-5 -22 3.6160454545454543
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 16 16.0 1969-12-31 15:59:45.722 -200 -2069085175 7713549532400 NULL NULL 200 -400 -200 NULL NULL -16.0 1.7802E7 1.617978982453018E-5 -16 4.9720625
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 46 46.0 1969-12-31 15:59:56.163 -200 -1275647301 4755613138128 NULL NULL 200 -400 -200 NULL NULL -46.0 1.7802E7 4.651689574552426E-5 -46 1.7294130434782609
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -30 -30.0 1969-12-31 16:00:11.15 -200 -834308521 3110302166288 NULL NULL 200 -400 -200 NULL NULL 30.0 1.7802E7 -3.0337105920994087E-5 30 -2.6517666666666666
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 34 34.0 1969-12-31 15:59:53.06 -200 -1958596195 7301646614960 NULL NULL 200 -400 -200 NULL NULL -34.0 1.7802E7 3.438205337712663E-5 -34 2.3397941176470587
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -45 -45.0 1969-12-31 16:00:00.287 -200 -1919463631 7155760416368 NULL NULL 200 -400 -200 NULL NULL 45.0 1.7802E7 -4.550565888149113E-5 45 -1.7678444444444443
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 37 37.0 1969-12-31 15:59:58.129 -200 1838442362 -6853713125536 NULL NULL 200 -400 -200 NULL NULL -37.0 1.7802E7 3.741576396922604E-5 -37 2.150081081081081
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -41 -41.0 1969-12-31 15:59:44.38 -200 -688353943 2566183499504 NULL NULL 200 -400 -200 NULL NULL 41.0 1.7802E7 -4.1460711425358585E-5 41 -1.9403170731707315
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -44 -44.0 1969-12-31 16:00:00.835 -200 1814766708 -6765450287424 NULL NULL 200 -400 -200 NULL NULL 44.0 1.7802E7 -4.449442201745799E-5 44 -1.8080227272727272
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 32 32.0 1969-12-31 16:00:03.571 -200 953305450 -3553922717600 NULL NULL 200 -400 -200 NULL NULL -32.0 1.7802E7 3.235957964906036E-5 -32 2.48603125
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 13 13.0 1969-12-31 16:00:03.794 -200 894634621 -3335197867088 NULL NULL 200 -400 -200 NULL NULL -13.0 1.7802E7 1.314607923243077E-5 -13 6.119461538461538
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 19 19.0 1969-12-31 16:00:10.723 -200 1604152041 -5980278808848 NULL NULL 200 -400 -200 NULL NULL -19.0 1.7802E7 1.921350041662959E-5 -19 4.187
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 62 62.0 1969-12-31 15:59:46.137 -200 -1332297900 4966806571200 NULL NULL 200 -400 -200 NULL NULL -62.0 1.7802E7 6.269668557005445E-5 -62 1.2831129032258064
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -46 -46.0 1969-12-31 15:59:49.331 -200 -2034715106 7585417915168 NULL NULL 200 -400 -200 NULL NULL 46.0 1.7802E7 -4.651689574552426E-5 46 -1.7294130434782609
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -25 -25.0 1969-12-31 15:59:48.372 -200 1516831554 -5654748033312 NULL NULL 200 -400 -200 NULL NULL 25.0 1.7802E7 -2.5280921600828406E-5 25 -3.18212
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 39 39.0 1969-12-31 16:00:00.395 -200 -899658844 3353928170432 NULL NULL 200 -400 -200 NULL NULL -39.0 1.7802E7 3.9438237697292314E-5 -39 2.039820512820513
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 43 43.0 1969-12-31 16:00:01.097 -200 -781919048 2914994210944 NULL NULL 200 -400 -200 NULL NULL -43.0 1.7802E7 4.3483185153424856E-5 -43 1.8500697674418605
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -42 -42.0 1969-12-31 15:59:54.349 -200 -390050457 1454108103696 NULL NULL 200 -400 -200 NULL NULL 42.0 1.7802E7 -4.247194828939172E-5 42 -1.8941190476190475
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -4 -4.0 1969-12-31 15:59:47.952 -200 -449401470 1675368680160 NULL NULL 200 -400 -200 NULL NULL 4.0 1.7802E7 -4.044947456132545E-6 4 -19.88825
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 10 10.0 1969-12-31 16:00:07.365 -200 120165080 -447975418240 NULL NULL 200 -400 -200 NULL NULL -10.0 1.7802E7 1.0112368640331362E-5 -10 7.955299999999999
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -10 -10.0 1969-12-31 15:59:47.828 -200 -715660733 2667983212624 NULL NULL 200 -400 -200 NULL NULL 10.0 1.7802E7 -1.0112368640331362E-5 10 -7.955299999999999
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 15 15.0 1969-12-31 16:00:00.951 -200 454239730 -1693405713440 NULL NULL 200 -400 -200 NULL NULL -15.0 1.7802E7 1.5168552960497044E-5 -15 5.303533333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 49 49.0 1969-12-31 15:59:48.367 -200 1709812289 -6374180213392 NULL NULL 200 -400 -200 NULL NULL -49.0 1.7802E7 4.9550606337623676E-5 -49 1.6235306122448978
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -57 -57.0 1969-12-31 16:00:02.707 -200 1382057278 -5152309532384 NULL NULL 200 -400 -200 NULL NULL 57.0 1.7802E7 -5.764050124988876E-5 57 -1.3956666666666666
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -25 -25.0 1969-12-31 15:59:49.293 -200 -776497113 2894781237264 NULL NULL 200 -400 -200 NULL NULL 25.0 1.7802E7 -2.5280921600828406E-5 25 -3.18212
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 34 34.0 1969-12-31 16:00:15.609 -200 -1775354211 6618520498608 NULL NULL 200 -400 -200 NULL NULL -34.0 1.7802E7 3.438205337712663E-5 -34 2.3397941176470587
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -51 -51.0 1969-12-31 16:00:12.494 -200 -413063757 1539901686096 NULL NULL 200 -400 -200 NULL NULL 51.0 1.7802E7 -5.157308006568995E-5 51 -1.5598627450980391
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -23 -23.0 1969-12-31 16:00:14.071 -200 -378947821 1412717476688 NULL NULL 200 -400 -200 NULL NULL 23.0 1.7802E7 -2.325844787276213E-5 23 -3.4588260869565217
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 41 41.0 1969-12-31 16:00:08.408 -200 696650264 -2597112184192 NULL NULL 200 -400 -200 NULL NULL -41.0 1.7802E7 4.1460711425358585E-5 -41 1.9403170731707315
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 39 39.0 1969-12-31 16:00:07.541 -200 260798405 -972256453840 NULL NULL 200 -400 -200 NULL NULL -39.0 1.7802E7 3.9438237697292314E-5 -39 2.039820512820513
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -30 -30.0 1969-12-31 16:00:10.211 -200 -885770465 3302152293520 NULL NULL 200 -400 -200 NULL NULL 30.0 1.7802E7 -3.0337105920994087E-5 30 -2.6517666666666666
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -24 -24.0 1969-12-31 15:59:54.075 -200 191358485 -713384432080 NULL NULL 200 -400 -200 NULL NULL 24.0 1.7802E7 -2.426968473679527E-5 24 -3.3147083333333334
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 56 56.0 1969-12-31 15:59:57.56 -200 951463637 -3547056438736 NULL NULL 200 -400 -200 NULL NULL -56.0 1.7802E7 5.6629264385855625E-5 -56 1.4205892857142857
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -21 -21.0 1969-12-31 16:00:09.182 -200 1367877440 -5099447096320 NULL NULL 200 -400 -200 NULL NULL 21.0 1.7802E7 -2.123597414469586E-5 21 -3.788238095238095
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 58 58.0 1969-12-31 15:59:45.489 -200 1300104054 -4846787913312 NULL NULL 200 -400 -200 NULL NULL -58.0 1.7802E7 5.86517381139219E-5 -58 1.3716034482758621
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 41 41.0 1969-12-31 16:00:07.175 -200 1542568556 -5750695576768 NULL NULL 200 -400 -200 NULL NULL -41.0 1.7802E7 4.1460711425358585E-5 -41 1.9403170731707315
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -1 -1.0 1969-12-31 16:00:04.836 -200 480523197 -1791390478416 NULL NULL 200 -400 -200 NULL NULL 1.0 1.7802E7 -1.0112368640331362E-6 1 -79.553
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 21 21.0 1969-12-31 16:00:08.048 -200 261543399 -975033791472 NULL NULL 200 -400 -200 NULL NULL -21.0 1.7802E7 2.123597414469586E-5 -21 3.788238095238095
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -61 -61.0 1969-12-31 16:00:04.165 -200 -1313743110 4897634314080 NULL NULL 200 -400 -200 NULL NULL 61.0 1.7802E7 -6.16854487060213E-5 61 -1.3041475409836065
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 35 35.0 1969-12-31 16:00:09.892 -200 -197916286 737831914208 NULL NULL 200 -400 -200 NULL NULL -35.0 1.7802E7 3.5393290241159765E-5 -35 2.272942857142857
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -48 -48.0 1969-12-31 15:59:55.023 -200 17520444 -65316215232 NULL NULL 200 -400 -200 NULL NULL 48.0 1.7802E7 -4.853936947359054E-5 48 -1.6573541666666667
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -14 -14.0 1969-12-31 15:59:44.457 -200 1678325085 -6256795916880 NULL NULL 200 -400 -200 NULL NULL 14.0 1.7802E7 -1.4157316096463906E-5 14 -5.682357142857143
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 54 54.0 1969-12-31 16:00:10.187 -200 829351969 -3091824140432 NULL NULL 200 -400 -200 NULL NULL -54.0 1.7802E7 5.4606790657789354E-5 -54 1.4732037037037036
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 16 16.0 1969-12-31 15:59:57.245 -200 1713760992 -6388900978176 NULL NULL 200 -400 -200 NULL NULL -16.0 1.7802E7 1.617978982453018E-5 -16 4.9720625
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 53 53.0 1969-12-31 16:00:15.401 -200 -549903001 2050038387728 NULL NULL 200 -400 -200 NULL NULL -53.0 1.7802E7 5.359555379375622E-5 -53 1.501
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -58 -58.0 1969-12-31 15:59:54.484 -200 1126209929 -4198510615312 NULL NULL 200 -400 -200 NULL NULL 58.0 1.7802E7 -5.86517381139219E-5 58 -1.3716034482758621
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 4 4.0 1969-12-31 15:59:53.898 -200 -1597851253 5956789471184 NULL NULL 200 -400 -200 NULL NULL -4.0 1.7802E7 4.044947456132545E-6 -4 19.88825
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 47 47.0 1969-12-31 16:00:02 -200 678949554 -2531123937312 NULL NULL 200 -400 -200 NULL NULL -47.0 1.7802E7 4.7528132609557405E-5 -47 1.6926170212765956
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -26 -26.0 1969-12-31 16:00:14.191 -200 1050415040 -3915947269120 NULL NULL 200 -400 -200 NULL NULL 26.0 1.7802E7 -2.629215846486154E-5 26 -3.059730769230769
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -5 -5.0 1969-12-31 15:59:57.794 -200 205645723 -766647255344 NULL NULL 200 -400 -200 NULL NULL 5.0 1.7802E7 -5.056184320165681E-6 5 -15.910599999999999
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 50 50.0 1969-12-31 16:00:09.364 -200 -291569870 1086972475360 NULL NULL 200 -400 -200 NULL NULL -50.0 1.7802E7 5.056184320165681E-5 -50 1.59106
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 32 32.0 1969-12-31 15:59:57.543 -200 1053538728 -3927592377984 NULL NULL 200 -400 -200 NULL NULL -32.0 1.7802E7 3.235957964906036E-5 -32 2.48603125
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 20 20.0 1969-12-31 15:59:55.056 -200 -1403730664 5233107915392 NULL NULL 200 -400 -200 NULL NULL -20.0 1.7802E7 2.0224737280662725E-5 -20 3.9776499999999997
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 26 26.0 1969-12-31 16:00:00.923 -200 -1387364200 5172093737600 NULL NULL 200 -400 -200 NULL NULL -26.0 1.7802E7 2.629215846486154E-5 -26 3.059730769230769
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -49 -49.0 1969-12-31 16:00:01.458 -200 -658701811 2455640351408 NULL NULL 200 -400 -200 NULL NULL 49.0 1.7802E7 -4.9550606337623676E-5 49 -1.6235306122448978
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 14 14.0 1969-12-31 15:59:44.297 -200 2120344258 -7904643393824 NULL NULL 200 -400 -200 NULL NULL -14.0 1.7802E7 1.4157316096463906E-5 -14 5.682357142857143
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -58 -58.0 1969-12-31 15:59:47.24 -200 1257221099 -4686920257072 NULL NULL 200 -400 -200 NULL NULL 58.0 1.7802E7 -5.86517381139219E-5 58 -1.3716034482758621
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -14 -14.0 1969-12-31 16:00:08.704 -200 1471532162 -5485871899936 NULL NULL 200 -400 -200 NULL NULL 14.0 1.7802E7 -1.4157316096463906E-5 14 -5.682357142857143
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 45 45.0 1969-12-31 16:00:04.572 -200 612900585 -2284893380880 NULL NULL 200 -400 -200 NULL NULL -45.0 1.7802E7 4.550565888149113E-5 -45 1.7678444444444443
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -63 -63.0 1969-12-31 16:00:01.843 -200 -1999307539 7453418505392 NULL NULL 200 -400 -200 NULL NULL 63.0 1.7802E7 -6.370792243408759E-5 63 -1.2627460317460317
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -23 -23.0 1969-12-31 16:00:01.764 -200 -2020595716 7532780829248 NULL NULL 200 -400 -200 NULL NULL 23.0 1.7802E7 -2.325844787276213E-5 23 -3.4588260869565217
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -26 -26.0 1969-12-31 15:59:50.573 -200 -1087207614 4053109984992 NULL NULL 200 -400 -200 NULL NULL 26.0 1.7802E7 -2.629215846486154E-5 26 -3.059730769230769
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 14 14.0 1969-12-31 16:00:06.3 -200 57986729 -216174525712 NULL NULL 200 -400 -200 NULL NULL -14.0 1.7802E7 1.4157316096463906E-5 -14 5.682357142857143
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 46 46.0 1969-12-31 15:59:46.028 -200 14115102 -52621100256 NULL NULL 200 -400 -200 NULL NULL -46.0 1.7802E7 4.651689574552426E-5 -46 1.7294130434782609
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 15 15.0 1969-12-31 15:59:57.953 -200 -30844955 114989992240 NULL NULL 200 -400 -200 NULL NULL -15.0 1.7802E7 1.5168552960497044E-5 -15 5.303533333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 6 6.0 1969-12-31 16:00:13.132 -200 883917228 -3295243425984 NULL NULL 200 -400 -200 NULL NULL -6.0 1.7802E7 6.067421184198818E-6 -6 13.258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 2 2.0 1969-12-31 15:59:46.893 -200 1767035977 -6587510122256 NULL NULL 200 -400 -200 NULL NULL -2.0 1.7802E7 2.0224737280662724E-6 -2 39.7765
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 17 17.0 1969-12-31 16:00:10.701 -200 142612225 -531658374800 NULL NULL 200 -400 -200 NULL NULL -17.0 1.7802E7 1.7191026688563315E-5 -17 4.679588235294117
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 52 52.0 1969-12-31 15:59:47.921 -200 505653702 -1885077001056 NULL NULL 200 -400 -200 NULL NULL -52.0 1.7802E7 5.258431692972308E-5 -52 1.5298653846153845
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 17 17.0 1969-12-31 15:59:48.452 -200 -899919510 3354899933280 NULL NULL 200 -400 -200 NULL NULL -17.0 1.7802E7 1.7191026688563315E-5 -17 4.679588235294117
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 41 41.0 1969-12-31 16:00:09.951 -200 -1973152486 7355912467808 NULL NULL 200 -400 -200 NULL NULL -41.0 1.7802E7 4.1460711425358585E-5 -41 1.9403170731707315
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 2 2.0 1969-12-31 16:00:02.752 -200 1107543828 -4128923390784 NULL NULL 200 -400 -200 NULL NULL -2.0 1.7802E7 2.0224737280662724E-6 -2 39.7765
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 6 6.0 1969-12-31 15:59:57.568 -200 559133030 -2084447935840 NULL NULL 200 -400 -200 NULL NULL -6.0 1.7802E7 6.067421184198818E-6 -6 13.258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 39 39.0 1969-12-31 16:00:12.557 -200 -1811991294 6755103544032 NULL NULL 200 -400 -200 NULL NULL -39.0 1.7802E7 3.9438237697292314E-5 -39 2.039820512820513
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -33 -33.0 1969-12-31 16:00:08.046 -200 281060243 -1047792585904 NULL NULL 200 -400 -200 NULL NULL 33.0 1.7802E7 -3.3370816513093494E-5 33 -2.4106969696969696
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 40 40.0 1969-12-31 15:59:55.197 -200 1958187727 -7300123846256 NULL NULL 200 -400 -200 NULL NULL -40.0 1.7802E7 4.044947456132545E-5 -40 1.9888249999999998
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -60 -60.0 1969-12-31 15:59:57.528 -200 1172431520 -4370824706560 NULL NULL 200 -400 -200 NULL NULL 60.0 1.7802E7 -6.0674211841988174E-5 60 -1.3258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -61 -61.0 1969-12-31 15:59:52.066 -200 623787602 -2325480180256 NULL NULL 200 -400 -200 NULL NULL 61.0 1.7802E7 -6.16854487060213E-5 61 -1.3041475409836065
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 45 45.0 1969-12-31 15:59:56.055 -200 -1251321575 4664926831600 NULL NULL 200 -400 -200 NULL NULL -45.0 1.7802E7 4.550565888149113E-5 -45 1.7678444444444443
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -23 -23.0 1969-12-31 16:00:16.07 -200 1778714378 -6631047201184 NULL NULL 200 -400 -200 NULL NULL 23.0 1.7802E7 -2.325844787276213E-5 23 -3.4588260869565217
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 58 58.0 1969-12-31 16:00:11.449 -200 -2045923021 7627201022288 NULL NULL 200 -400 -200 NULL NULL -58.0 1.7802E7 5.86517381139219E-5 -58 1.3716034482758621
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 22 22.0 1969-12-31 16:00:00.621 -200 930659178 -3469497415584 NULL NULL 200 -400 -200 NULL NULL -22.0 1.7802E7 2.2247211008728996E-5 -22 3.6160454545454543
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -52 -52.0 1969-12-31 16:00:01.289 -200 -1407220579 5246118318512 NULL NULL 200 -400 -200 NULL NULL 52.0 1.7802E7 -5.258431692972308E-5 52 -1.5298653846153845
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 47 47.0 1969-12-31 15:59:51.788 -200 1394914812 -5200242419136 NULL NULL 200 -400 -200 NULL NULL -47.0 1.7802E7 4.7528132609557405E-5 -47 1.6926170212765956
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 56 56.0 1969-12-31 16:00:16.056 -200 -72311778 269578308384 NULL NULL 200 -400 -200 NULL NULL -56.0 1.7802E7 5.6629264385855625E-5 -56 1.4205892857142857
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -22 -22.0 1969-12-31 16:00:12.901 -200 486263371 -1812789847088 NULL NULL 200 -400 -200 NULL NULL 22.0 1.7802E7 -2.2247211008728996E-5 22 -3.6160454545454543
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 24 24.0 1969-12-31 16:00:01.369 -200 -1719521942 6410377799776 NULL NULL 200 -400 -200 NULL NULL -24.0 1.7802E7 2.426968473679527E-5 -24 3.3147083333333334
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 53 53.0 1969-12-31 15:59:45.074 -200 -1405259747 5238808336816 NULL NULL 200 -400 -200 NULL NULL -53.0 1.7802E7 5.359555379375622E-5 -53 1.501
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -44 -44.0 1969-12-31 16:00:03.357 -200 1980863657 -7384659713296 NULL NULL 200 -400 -200 NULL NULL 44.0 1.7802E7 -4.449442201745799E-5 44 -1.8080227272727272
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -16 -16.0 1969-12-31 15:59:55.043 -200 82971673 -309318396944 NULL NULL 200 -400 -200 NULL NULL 16.0 1.7802E7 -1.617978982453018E-5 16 -4.9720625
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 4 4.0 1969-12-31 16:00:00.019 -200 1070083402 -3989270922656 NULL NULL 200 -400 -200 NULL NULL -4.0 1.7802E7 4.044947456132545E-6 -4 19.88825
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -33 -33.0 1969-12-31 15:59:45.1 -200 -375567961 1400117358608 NULL NULL 200 -400 -200 NULL NULL 33.0 1.7802E7 -3.3370816513093494E-5 33 -2.4106969696969696
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -42 -42.0 1969-12-31 16:00:09.72 -200 -75032821 279722356688 NULL NULL 200 -400 -200 NULL NULL 42.0 1.7802E7 -4.247194828939172E-5 42 -1.8941190476190475
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 21 21.0 1969-12-31 16:00:12.52 -200 -1063757589 3965688291792 NULL NULL 200 -400 -200 NULL NULL -21.0 1.7802E7 2.123597414469586E-5 -21 3.788238095238095
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 34 34.0 1969-12-31 16:00:08.234 -200 -1455850339 5427410063792 NULL NULL 200 -400 -200 NULL NULL -34.0 1.7802E7 3.438205337712663E-5 -34 2.3397941176470587
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 47 47.0 1969-12-31 16:00:04.997 -200 -1166027011 4346948697008 NULL NULL 200 -400 -200 NULL NULL -47.0 1.7802E7 4.7528132609557405E-5 -47 1.6926170212765956
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 4 4.0 1969-12-31 16:00:00.563 -200 2051685271 -7648682690288 NULL NULL 200 -400 -200 NULL NULL -4.0 1.7802E7 4.044947456132545E-6 -4 19.88825
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -27 -27.0 1969-12-31 15:59:53.546 -200 -499602601 1862518496528 NULL NULL 200 -400 -200 NULL NULL 27.0 1.7802E7 -2.7303395328894677E-5 27 -2.946407407407407
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 22 22.0 1969-12-31 16:00:09.842 -200 615107644 -2293121296832 NULL NULL 200 -400 -200 NULL NULL -22.0 1.7802E7 2.2247211008728996E-5 -22 3.6160454545454543
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -6 -6.0 1969-12-31 16:00:05.495 -200 377656757 -1407904390096 NULL NULL 200 -400 -200 NULL NULL 6.0 1.7802E7 -6.067421184198818E-6 6 -13.258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -15 -15.0 1969-12-31 16:00:13.438 -200 1702277036 -6346088790208 NULL NULL 200 -400 -200 NULL NULL 15.0 1.7802E7 -1.5168552960497044E-5 15 -5.303533333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 52 52.0 1969-12-31 16:00:00.158 -200 -1439705824 5367223311872 NULL NULL 200 -400 -200 NULL NULL -52.0 1.7802E7 5.258431692972308E-5 -52 1.5298653846153845
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -45 -45.0 1969-12-31 16:00:02.814 -200 771908206 -2877673791968 NULL NULL 200 -400 -200 NULL NULL 45.0 1.7802E7 -4.550565888149113E-5 45 -1.7678444444444443
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 55 55.0 1969-12-31 16:00:14.709 -200 529159242 -1972705654176 NULL NULL 200 -400 -200 NULL NULL -55.0 1.7802E7 5.561802752182249E-5 -55 1.4464181818181818
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 6 6.0 1969-12-31 15:59:57.47 -200 -1169269094 4359035182432 NULL NULL 200 -400 -200 NULL NULL -6.0 1.7802E7 6.067421184198818E-6 -6 13.258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -55 -55.0 1969-12-31 16:00:03.737 -200 -955056279 3560449808112 NULL NULL 200 -400 -200 NULL NULL 55.0 1.7802E7 -5.561802752182249E-5 55 -1.4464181818181818
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 60 60.0 1969-12-31 15:59:47.019 -200 -2132232110 7948961306080 NULL NULL 200 -400 -200 NULL NULL -60.0 1.7802E7 6.0674211841988174E-5 -60 1.3258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -28 -28.0 1969-12-31 15:59:44.922 -200 -596995850 2225600528800 NULL NULL 200 -400 -200 NULL NULL 28.0 1.7802E7 -2.8314632192927813E-5 28 -2.8411785714285713
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -7 -7.0 1969-12-31 16:00:15.593 -200 -337718648 1259015119744 NULL NULL 200 -400 -200 NULL NULL 7.0 1.7802E7 -7.078658048231953E-6 7 -11.364714285714285
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 45 45.0 1969-12-31 16:00:11.443 -200 -122450 456493600 NULL NULL 200 -400 -200 NULL NULL -45.0 1.7802E7 4.550565888149113E-5 -45 1.7678444444444443
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 51 51.0 1969-12-31 16:00:00.147 -200 908074420 -3385301437760 NULL NULL 200 -400 -200 NULL NULL -51.0 1.7802E7 5.157308006568995E-5 -51 1.5598627450980391
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 32 32.0 1969-12-31 16:00:07.675 -200 99645480 -371478349440 NULL NULL 200 -400 -200 NULL NULL -32.0 1.7802E7 3.235957964906036E-5 -32 2.48603125
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -6 -6.0 1969-12-31 15:59:47.066 -200 1361253497 -5074753036816 NULL NULL 200 -400 -200 NULL NULL 6.0 1.7802E7 -6.067421184198818E-6 6 -13.258833333333333
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 1 1.0 1969-12-31 15:59:46.29 -200 1968356628 -7338033509184 NULL NULL 200 -400 -200 NULL NULL -1.0 1.7802E7 1.0112368640331362E-6 -1 79.553
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 42 42.0 1969-12-31 16:00:00.11 -200 1303413031 -4859123779568 NULL NULL 200 -400 -200 NULL NULL -42.0 1.7802E7 4.247194828939172E-5 -42 1.8941190476190475
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -23 -23.0 1969-12-31 15:59:54.522 -200 -1369228515 5104483903920 NULL NULL 200 -400 -200 NULL NULL 23.0 1.7802E7 -2.325844787276213E-5 23 -3.4588260869565217
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -61 -61.0 1969-12-31 15:59:47.034 -200 1399483216 -5217273429248 NULL NULL 200 -400 -200 NULL NULL 61.0 1.7802E7 -6.16854487060213E-5 61 -1.3041475409836065
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 11 11.0 1969-12-31 16:00:14.569 -200 -62618517 233441831376 NULL NULL 200 -400 -200 NULL NULL -11.0 1.7802E7 1.1123605504364498E-5 -11 7.232090909090909
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -23 -23.0 1969-12-31 16:00:13.835 -200 -139835037 521305017936 NULL NULL 200 -400 -200 NULL NULL 23.0 1.7802E7 -2.325844787276213E-5 23 -3.4588260869565217
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 21 21.0 1969-12-31 16:00:13.153 -200 1469053701 -5476632197328 NULL NULL 200 -400 -200 NULL NULL -21.0 1.7802E7 2.123597414469586E-5 -21 3.788238095238095
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 49 49.0 1969-12-31 15:59:43.952 -200 -753159604 2807779003712 NULL NULL 200 -400 -200 NULL NULL -49.0 1.7802E7 4.9550606337623676E-5 -49 1.6235306122448978
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -10 -10.0 1969-12-31 16:00:08.882 -200 -1036428824 3863806655872 NULL NULL 200 -400 -200 NULL NULL 10.0 1.7802E7 -1.0112368640331362E-5 10 -7.955299999999999
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 17 17.0 1969-12-31 16:00:13.008 -200 -1570844365 5856107792720 NULL NULL 200 -400 -200 NULL NULL -17.0 1.7802E7 1.7191026688563315E-5 -17 4.679588235294117
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -32 -32.0 1969-12-31 15:59:47.69 -200 -679776976 2534208566528 NULL NULL 200 -400 -200 NULL NULL 32.0 1.7802E7 -3.235957964906036E-5 32 -2.48603125
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 35 35.0 1969-12-31 16:00:08.37 -200 -258891336 965146900608 NULL NULL 200 -400 -200 NULL NULL -35.0 1.7802E7 3.5393290241159765E-5 -35 2.272942857142857
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -26 -26.0 1969-12-31 15:59:54.866 -200 -281746185 1050349777680 NULL NULL 200 -400 -200 NULL NULL 26.0 1.7802E7 -2.629215846486154E-5 26 -3.059730769230769
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -50 -50.0 1969-12-31 16:00:04.696 -200 -144798360 539808286080 NULL NULL 200 -400 -200 NULL NULL 50.0 1.7802E7 -5.056184320165681E-5 50 -1.59106
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -36 -36.0 1969-12-31 16:00:15.111 -200 -817680514 3048312956192 NULL NULL 200 -400 -200 NULL NULL 36.0 1.7802E7 -3.64045271051929E-5 36 -2.2098055555555556
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 32 32.0 1969-12-31 15:59:58.298 -200 927442664 -3457506251392 NULL NULL 200 -400 -200 NULL NULL -32.0 1.7802E7 3.235957964906036E-5 -32 2.48603125
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -4 -4.0 1969-12-31 15:59:44.052 -200 -74396507 277350178096 NULL NULL 200 -400 -200 NULL NULL 4.0 1.7802E7 -4.044947456132545E-6 4 -19.88825
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -1 -1.0 1969-12-31 15:59:58.26 -200 -830447528 3095908384384 NULL NULL 200 -400 -200 NULL NULL 1.0 1.7802E7 -1.0112368640331362E-6 1 -79.553
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -30 -30.0 1969-12-31 16:00:02.234 -200 1539182778 -5738073396384 NULL NULL 200 -400 -200 NULL NULL 30.0 1.7802E7 -3.0337105920994087E-5 30 -2.6517666666666666
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 24 24.0 1969-12-31 15:59:53.052 -200 821428066 -3062283830048 NULL NULL 200 -400 -200 NULL NULL -24.0 1.7802E7 2.426968473679527E-5 -24 3.3147083333333334
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 49 49.0 1969-12-31 16:00:05.369 -200 1700360415 -6338943627120 NULL NULL 200 -400 -200 NULL NULL -49.0 1.7802E7 4.9550606337623676E-5 -49 1.6235306122448978
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 47 47.0 1969-12-31 16:00:06.256 -200 -1558297670 5809333713760 NULL NULL 200 -400 -200 NULL NULL -47.0 1.7802E7 4.7528132609557405E-5 -47 1.6926170212765956
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 50 50.0 1969-12-31 16:00:04.228 -200 977627069 -3644593713232 NULL NULL 200 -400 -200 NULL NULL -50.0 1.7802E7 5.056184320165681E-5 -50 1.59106
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -59 -59.0 1969-12-31 16:00:15.296 -200 165384922 -616554989216 NULL NULL 200 -400 -200 NULL NULL 59.0 1.7802E7 -5.966297497795504E-5 59 -1.3483559322033898
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -12 -12.0 1969-12-31 16:00:15.749 -200 -1476740834 5505289829152 NULL NULL 200 -400 -200 NULL NULL 12.0 1.7802E7 -1.2134842368397635E-5 12 -6.629416666666667
+NULL -200.0 1969-12-31 15:59:55.451 NULL false -16 -16.0 1969-12-31 15:59:44.289 -200 -1197793261 4465373277008 NULL NULL 200 -400 -200 NULL NULL 16.0 1.7802E7 -1.617978982453018E-5 16 -4.9720625
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 37 37.0 1969-12-31 15:59:51.566 -200 1829107401 -6818912390928 NULL NULL 200 -400 -200 NULL NULL -37.0 1.7802E7 3.741576396922604E-5 -37 2.150081081081081
+NULL -200.0 1969-12-31 15:59:55.451 NULL false 15 15.0 1969-12-31 15:59:45.107 -200 1565121976 -5834774726528 NULL NULL 200 -400 -200 NULL NULL -15.0 1.7802E7 1.5168552960497044E-5 -15 5.303533333333333
[... 5421 lines stripped ...]