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 2013/09/25 00:27:20 UTC
svn commit: r1526034 [2/2] - in /hive/branches/vectorization: ./ data/files/
ql/src/test/org/apache/hadoop/hive/ql/ ql/src/test/queries/clientpositive/
ql/src/test/results/clientpositive/
Added: hive/branches/vectorization/ql/src/test/results/clientpositive/vectorization_short_regress.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/vectorization_short_regress.q.out?rev=1526034&view=auto
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/vectorization_short_regress.q.out (added)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/vectorization_short_regress.q.out Tue Sep 24 22:27:19 2013
@@ -0,0 +1,9345 @@
+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
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (- (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (- (- (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728))))) (TOK_SELEXPR (* (- (- (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728)))) (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (- (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (* (* (- (- (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728)))) (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728))) (- (- (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728)))))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL csma
llint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) (- (- (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728)))))) (TOK_SELEXPR (* (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) (- (- (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (- 3728))))) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (- 10.175 (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (- (- 10.175 (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint))))) (TOK_SELEXPR (/ (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- 563))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (/ (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- 563)))) (TOK_SELEXPR (/ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cdouble
)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (TOK_FUNCTION COUNT (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (/ (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint)) (/ (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- 563)))) (TOK_SELEXPR (- (/ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cdouble)))))) (TOK_WHERE (OR (OR (OR (= 762 (TOK_TABLE_OR_COL cbigint)) (AND (< (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL cfloat)) (AND (> (TOK_TABLE_OR_COL ctimestamp2) (- 10669)) (!= (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL cint))))) (= (TOK_TABLE_OR_COL cstring1) 'a')) (AND (<= (TOK_TABLE_OR_COL cbigint) (- 1.389)) (AND (!= (TOK_TABLE_OR_COL cstring2) 'a') (AND (!= 79.553 (TOK_TABLE_OR_COL cint)) (!= (TOK_TABLE_OR_COL cboolean2) (TOK_TABLE_OR_COL cboolean1)))))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Filter Operator
+ predicate:
+ expr: ((((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
+ Vectorized execution: true
+ Select Operator
+ expressions:
+ expr: cint
+ type: int
+ expr: cdouble
+ type: double
+ expr: csmallint
+ type: smallint
+ expr: cfloat
+ type: float
+ expr: ctinyint
+ type: tinyint
+ outputColumnNames: cint, cdouble, csmallint, cfloat, ctinyint
+ Vectorized execution: true
+ Group By Operator
+ aggregations:
+ expr: avg(cint)
+ expr: sum(cdouble)
+ expr: stddev_pop(cint)
+ expr: stddev_samp(csmallint)
+ expr: var_samp(cint)
+ expr: avg(cfloat)
+ expr: stddev_samp(cint)
+ expr: min(ctinyint)
+ expr: count(csmallint)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Vectorized execution: true
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: struct<count:bigint,sum:double>
+ expr: _col1
+ type: double
+ expr: _col2
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col3
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col4
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col5
+ type: struct<count:bigint,sum:double>
+ expr: _col6
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col7
+ type: tinyint
+ expr: _col8
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: avg(VALUE._col0)
+ expr: sum(VALUE._col1)
+ expr: stddev_pop(VALUE._col2)
+ expr: stddev_samp(VALUE._col3)
+ expr: var_samp(VALUE._col4)
+ expr: avg(VALUE._col5)
+ expr: stddev_samp(VALUE._col6)
+ expr: min(VALUE._col7)
+ expr: count(VALUE._col8)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Select Operator
+ expressions:
+ expr: _col0
+ type: double
+ expr: (_col0 + (- 3728))
+ type: double
+ expr: (- (_col0 + (- 3728)))
+ type: double
+ expr: (- (- (_col0 + (- 3728))))
+ type: double
+ expr: ((- (- (_col0 + (- 3728)))) * (_col0 + (- 3728)))
+ type: double
+ expr: _col1
+ type: double
+ expr: (- _col0)
+ type: double
+ expr: _col2
+ type: double
+ expr: (((- (- (_col0 + (- 3728)))) * (_col0 + (- 3728))) * (- (- (_col0 + (- 3728)))))
+ type: double
+ expr: _col3
+ type: double
+ expr: (- _col2)
+ type: double
+ expr: (_col2 - (- (- (_col0 + (- 3728)))))
+ type: double
+ expr: ((_col2 - (- (- (_col0 + (- 3728))))) * _col2)
+ type: double
+ expr: _col4
+ type: double
+ expr: _col5
+ type: double
+ expr: (10.175 - _col4)
+ type: double
+ expr: (- (10.175 - _col4))
+ type: double
+ expr: ((- _col2) / (- 563))
+ type: double
+ expr: _col6
+ type: double
+ expr: (- ((- _col2) / (- 563)))
+ type: double
+ expr: (_col0 / _col1)
+ type: double
+ expr: _col7
+ type: tinyint
+ expr: _col8
+ type: bigint
+ expr: (_col7 / ((- _col2) / (- 563)))
+ type: double
+ expr: (- (_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
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+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
+-- 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 LIKE '%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
+-- 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 LIKE '%ss%'))
+ OR ((cfloat > 79.553)
+ AND (cstring2 LIKE '10%')))
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (/ (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmalli
nt)) 10.175)) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)) 10.175))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (% (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)) (- 26.28))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (% (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_WHERE (OR (OR (OR (AND (<= (TOK_TAB
LE_OR_COL cbigint) 197) (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint))) (AND (>= (TOK_TABLE_OR_COL cdouble) (- 26.28)) (> (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL cdouble)))) (AND (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cfloat)) (LIKE (TOK_TABLE_OR_COL cstring1) '%ss%'))) (AND (> (TOK_TABLE_OR_COL cfloat) 79.553) (LIKE (TOK_TABLE_OR_COL cstring2) '10%'))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Filter Operator
+ predicate:
+ expr: (((((cbigint <= 197) and (cint < cbigint)) or ((cdouble >= (- 26.28)) and (csmallint > cdouble))) or ((ctinyint > cfloat) and (cstring1 like '%ss%'))) or ((cfloat > 79.553) and (cstring2 like '10%')))
+ type: boolean
+ Vectorized execution: true
+ Select Operator
+ expressions:
+ expr: cint
+ type: int
+ expr: cbigint
+ type: bigint
+ expr: csmallint
+ type: smallint
+ expr: cdouble
+ type: double
+ expr: ctinyint
+ type: tinyint
+ outputColumnNames: cint, cbigint, csmallint, cdouble, ctinyint
+ Vectorized execution: true
+ Group By Operator
+ aggregations:
+ expr: max(cint)
+ expr: var_pop(cbigint)
+ expr: stddev_pop(csmallint)
+ expr: max(cdouble)
+ expr: avg(ctinyint)
+ expr: min(cint)
+ expr: min(cdouble)
+ expr: stddev_samp(csmallint)
+ expr: var_samp(cint)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Vectorized execution: true
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col2
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col3
+ type: double
+ expr: _col4
+ type: struct<count:bigint,sum:double>
+ expr: _col5
+ type: int
+ expr: _col6
+ type: double
+ expr: _col7
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col8
+ type: struct<count:bigint,sum:double,variance:double>
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: max(VALUE._col0)
+ expr: var_pop(VALUE._col1)
+ expr: stddev_pop(VALUE._col2)
+ expr: max(VALUE._col3)
+ expr: avg(VALUE._col4)
+ expr: min(VALUE._col5)
+ expr: min(VALUE._col6)
+ expr: stddev_samp(VALUE._col7)
+ expr: var_samp(VALUE._col8)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ expr: (_col0 / (- 3728))
+ type: double
+ expr: (_col0 * (- 3728))
+ type: int
+ expr: _col1
+ type: double
+ expr: (- (_col0 * (- 3728)))
+ type: int
+ expr: _col2
+ type: double
+ expr: ((- 563) % (_col0 * (- 3728)))
+ type: int
+ expr: (_col1 / _col2)
+ type: double
+ expr: (- _col2)
+ type: double
+ expr: _col3
+ type: double
+ expr: _col4
+ type: double
+ expr: (_col2 - 10.175)
+ type: double
+ expr: _col5
+ type: int
+ expr: ((_col0 * (- 3728)) % (_col2 - 10.175))
+ type: double
+ expr: (- _col3)
+ type: double
+ expr: _col6
+ type: double
+ expr: (_col3 % (- 26.28))
+ type: double
+ expr: _col7
+ type: double
+ expr: (- (_col0 / (- 3728)))
+ type: double
+ expr: ((- (_col0 * (- 3728))) % ((- 563) % (_col0 * (- 3728))))
+ type: int
+ expr: ((_col0 / (- 3728)) - _col4)
+ type: double
+ expr: (- (_col0 * (- 3728)))
+ type: int
+ expr: _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
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+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 LIKE '%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 LIKE '%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
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (- (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)) (- (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (% (TOK_FUNCTIONSTAR COUNT) 79.553)) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (- (TOK_FUNCTIONSTAR COUNT) (- (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (- (- (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (% (- 1) (- (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (- (TOK_FUNCTIONSTAR COUNT))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (- (- (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigi
nt)))))) (TOK_SELEXPR (* 762 (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (+ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL ctinyint)) (* 762 (- (TOK_FUNCTIONSTAR COUNT))))) (TOK_SELEXPR (+ (- (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (% (- (TOK_FUNCTIONSTAR COUNT)) (TOK_FUNCTIONSTAR COUNT))) (TOK_SELEXPR (TOK_FUNCTION COUNT (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (% (- 3728) (+ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL ctinyint)) (* 762 (- (TOK_FUNCTIONSTAR COUNT))))))) (TOK_WHERE (OR (OR (OR (OR (= (TOK_TABLE_OR_COL ctimestamp1) (TOK_TABLE_OR_COL ctimestamp2)) (= 762 (TOK_TABLE_OR_COL cfloat))) (= (TOK_TABLE_OR_COL cstring1) 'ss')) (AND (<= (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL cbigint)) (= 1 (TOK_TABLE_OR_COL cboolean2)))) (AND (TOK_FUNC
TION TOK_ISNOTNULL (TOK_TABLE_OR_COL cboolean1)) (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL ctimestamp2)) (> (TOK_TABLE_OR_COL cstring2) 'a')))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Filter Operator
+ predicate:
+ expr: (((((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
+ Vectorized execution: true
+ Select Operator
+ expressions:
+ expr: cbigint
+ type: bigint
+ expr: ctinyint
+ type: tinyint
+ expr: csmallint
+ type: smallint
+ expr: cint
+ type: int
+ expr: cdouble
+ type: double
+ outputColumnNames: cbigint, ctinyint, csmallint, cint, cdouble
+ Vectorized execution: true
+ Group By Operator
+ aggregations:
+ expr: var_pop(cbigint)
+ expr: count()
+ expr: max(ctinyint)
+ expr: stddev_pop(csmallint)
+ expr: max(cint)
+ expr: stddev_samp(cdouble)
+ expr: count(ctinyint)
+ expr: avg(ctinyint)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ Vectorized execution: true
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col1
+ type: bigint
+ expr: _col2
+ type: tinyint
+ expr: _col3
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col4
+ type: int
+ expr: _col5
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col6
+ type: bigint
+ expr: _col7
+ type: struct<count:bigint,sum:double>
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: var_pop(VALUE._col0)
+ expr: count(VALUE._col1)
+ expr: max(VALUE._col2)
+ expr: stddev_pop(VALUE._col3)
+ expr: max(VALUE._col4)
+ expr: stddev_samp(VALUE._col5)
+ expr: count(VALUE._col6)
+ expr: avg(VALUE._col7)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ Select Operator
+ expressions:
+ expr: _col0
+ type: double
+ expr: (- _col0)
+ type: double
+ expr: (_col0 - (- _col0))
+ type: double
+ expr: _col1
+ type: bigint
+ expr: (_col1 % 79.553)
+ type: double
+ expr: _col2
+ type: tinyint
+ expr: (_col1 - (- _col0))
+ type: double
+ expr: (- (- _col0))
+ type: double
+ expr: ((- 1) % (- _col0))
+ type: double
+ expr: _col1
+ type: bigint
+ expr: (- _col1)
+ type: bigint
+ expr: _col3
+ type: double
+ expr: (- (- (- _col0)))
+ type: double
+ expr: (762 * (- _col1))
+ type: bigint
+ expr: _col4
+ type: int
+ expr: (_col2 + (762 * (- _col1)))
+ type: bigint
+ expr: ((- _col0) + _col4)
+ type: double
+ expr: _col5
+ type: double
+ expr: ((- _col1) % _col1)
+ type: bigint
+ expr: _col6
+ type: bigint
+ expr: _col7
+ type: double
+ expr: ((- 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
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+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
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)) 6981)) (TOK_SELEXPR (+ (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)) 6981) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (/ (+ (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)) 6981) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint))) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (- (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)) 6981))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)) (- (+ (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)) 6981)))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint
))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (/ (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cbigint))) (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)) (- 26.28)))) (TOK_WHERE (OR (OR (AND (<= (TOK_TABLE_OR_COL ctimestamp2) (TOK_TABLE_OR_COL ctimestamp1)) (AND (!= (TOK_TABLE_OR_COL cbigint) (TOK_TABLE_OR_COL cdouble)) (<= 'ss' (TOK_TABLE_OR_COL cstring1)))) (AND (< (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL ctinyint)) (>= (TOK_TABLE_OR_COL ctimestamp1) 0))) (= (TOK_TABLE_OR_COL cfloat) 17)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Filter Operator
+ predicate:
+ expr: ((((ctimestamp2 <= ctimestamp1) and ((cbigint <> cdouble) and ('ss' <= cstring1))) or ((csmallint < ctinyint) and (ctimestamp1 >= 0))) or (cfloat = 17.0))
+ type: boolean
+ Vectorized execution: true
+ Select Operator
+ expressions:
+ expr: ctinyint
+ type: tinyint
+ expr: cbigint
+ type: bigint
+ expr: cint
+ type: int
+ expr: cfloat
+ type: float
+ outputColumnNames: ctinyint, cbigint, cint, cfloat
+ Vectorized execution: true
+ Group By Operator
+ aggregations:
+ expr: avg(ctinyint)
+ expr: max(cbigint)
+ expr: stddev_samp(cint)
+ expr: var_pop(cint)
+ expr: var_pop(cbigint)
+ expr: max(cfloat)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Vectorized execution: true
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: struct<count:bigint,sum:double>
+ expr: _col1
+ type: bigint
+ expr: _col2
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col3
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col4
+ type: struct<count:bigint,sum:double,variance:double>
+ expr: _col5
+ type: float
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: avg(VALUE._col0)
+ expr: max(VALUE._col1)
+ expr: stddev_samp(VALUE._col2)
+ expr: var_pop(VALUE._col3)
+ expr: var_pop(VALUE._col4)
+ expr: max(VALUE._col5)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Select Operator
+ expressions:
+ expr: _col0
+ type: double
+ expr: (_col0 + 6981)
+ type: double
+ expr: ((_col0 + 6981) + _col0)
+ type: double
+ expr: _col1
+ type: bigint
+ expr: (((_col0 + 6981) + _col0) / _col0)
+ type: double
+ expr: (- (_col0 + 6981))
+ type: double
+ expr: _col2
+ type: double
+ expr: (_col0 % (- (_col0 + 6981)))
+ type: double
+ expr: _col3
+ type: double
+ expr: _col4
+ type: double
+ expr: (- _col1)
+ type: bigint
+ expr: ((- _col1) / _col2)
+ type: double
+ expr: _col5
+ type: float
+ expr: (_col4 * (- 26.28))
+ type: double
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+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
+-- 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 LIKE '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
+-- 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 LIKE '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
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cdouble)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp2)) (TOK_SELEXPR (TOK_TABLE_OR_COL cstring1)) (TOK_SELEXPR (TOK_TABLE_OR_COL cboolean2)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cfloat)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp1)) (TOK_SELEXPR (TOK_TABLE_OR_COL csmallint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cbigint)) (TOK_SELEXPR (* (- 3728) (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (- 863.257) (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (+ (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint))) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_C
OL cint))) (TOK_SELEXPR (- (- (- 863.257) (TOK_TABLE_OR_COL cint)) (- 26.28))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (TOK_TABLE_OR_COL cdouble) (- 89010))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL ctinyint) 988888)) (TOK_SELEXPR (- (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (/ 79.553 (TOK_TABLE_OR_COL ctinyint)))) (TOK_WHERE (OR (OR (OR (AND (LIKE (TOK_TABLE_OR_COL cstring1) 'a%') (LIKE (TOK_TABLE_OR_COL cstring2) '%ss%')) (AND (!= 1 (TOK_TABLE_OR_COL cboolean2)) (AND (< (TOK_TABLE_OR_COL csmallint) 79.553) (!= (- 257) (TOK_TABLE_OR_COL ctinyint))))) (AND (> (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL ctinyint)) (>= (TOK_TABLE_OR_COL cfloat) (TOK_TABLE_OR_COL cint)))) (AND (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint)) (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cbigint)))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Filter Operator
+ predicate:
+ expr: (((((cstring1 like '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
+ Vectorized execution: true
+ Select Operator
+ expressions:
+ expr: cint
+ type: int
+ expr: cdouble
+ type: double
+ expr: ctimestamp2
+ type: timestamp
+ expr: cstring1
+ type: string
+ expr: cboolean2
+ type: boolean
+ expr: ctinyint
+ type: tinyint
+ expr: cfloat
+ type: float
+ expr: ctimestamp1
+ type: timestamp
+ expr: csmallint
+ type: smallint
+ expr: cbigint
+ type: bigint
+ expr: ((- 3728) * cbigint)
+ type: bigint
+ expr: (- cint)
+ type: int
+ expr: ((- 863.257) - cint)
+ type: double
+ expr: (- csmallint)
+ type: smallint
+ expr: (csmallint - (- csmallint))
+ type: smallint
+ expr: ((csmallint - (- csmallint)) + (- csmallint))
+ type: smallint
+ expr: (cint / cint)
+ type: double
+ expr: (((- 863.257) - cint) - (- 26.28))
+ type: double
+ expr: (- cfloat)
+ type: float
+ expr: (cdouble * (- 89010))
+ type: double
+ expr: (ctinyint / 988888)
+ type: double
+ expr: (- ctinyint)
+ type: tinyint
+ expr: (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
+ Vectorized execution: true
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Vectorized execution: true
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+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 LIKE '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 LIKE '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
[... 7841 lines stripped ...]