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 > -5) 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 > -5) 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 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((762 = cbigint) or (((UDFToFloat(csmallint) < cfloat) and ((UDFToDouble(ctimestamp2) > -5.0) and (cdouble <> UDFToDouble(cint)))) or ((cstring1 = 'a') or ((UDFToDouble(cbigint) <= -1.389) and ((cstring2 <> 'a') and ((79.553 <> UDFToDouble(cint)) and (cboolean2 <> cboolean1))))))) (type: boolean) Statistics: Num rows: 12288 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: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: avg(_col0), sum(_col1), stddev_pop(_col0), stddev_samp(_col2), var_samp(_col0), avg(_col3), stddev_samp(_col0), min(_col4), count(_col2) 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), _col1 (type: double), _col2 (type: struct), _col3 (type: struct), _col4 (type: struct), _col5 (type: struct), _col6 (type: struct), _col7 (type: tinyint), _col8 (type: bigint) Execution mode: vectorized 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.0) (type: double), (- (_col0 + -3728.0)) (type: double), (- (- (_col0 + -3728.0))) (type: double), ((- (- (_col0 + -3728.0))) * (_col0 + -3728.0)) (type: double), _col1 (type: double), (- _col0) (type: double), _col2 (type: double), (((- (- (_col0 + -3728.0))) * (_col0 + -3728.0)) * (- (- (_col0 + -3728.0)))) (type: double), _col3 (type: double), (- _col2) (type: double), (_col2 - (- (- (_col0 + -3728.0)))) (type: double), ((_col2 - (- (- (_col0 + -3728.0)))) * _col2) (type: double), _col4 (type: double), _col5 (type: double), (10.175 - _col4) (type: double), (- (10.175 - _col4)) (type: double), ((- _col2) / -563.0) (type: double), _col6 (type: double), (- ((- _col2) / -563.0)) (type: double), (_col0 / _col1) (type: double), _col7 (type: tinyint), _col8 (type: bigint), (UDFToDouble(_col7) / ((- _col2) / -563.0)) (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 > -5) 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 > -5) 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.6000018929276082E8 1.5999646129276082E8 -1.5999646129276082E8 1.5999646129276082E8 2.5598867626205912E16 -8706342.964000002 -1.6000018929276082E8 5.481251832900256E8 4.095728233294762E24 8549.657499338187 -5.481251832900256E8 3.8812872199726474E8 2.12743126884874112E17 3.0054786945575034E17 -5.700752675298234 -3.0054786945575034E17 3.0054786945575034E17 973579.3664121237 5.48222463472403E8 -973579.3664121237 -18.377427808018613 -64 2044 -6.573680812059066E-5 18.377427808018613 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 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((cbigint <= 197) and (UDFToLong(cint) < cbigint)) or (((cdouble >= -26.28) and (UDFToDouble(csmallint) > cdouble)) or (((UDFToFloat(ctinyint) > cfloat) and (cstring1 rlike '.*ss.*')) or ((cfloat > 79.553) and (cstring2 like '10%'))))) (type: boolean) Statistics: Num rows: 6826 Data size: 209555 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: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 6826 Data size: 209555 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: max(_col0), var_pop(_col1), stddev_pop(_col2), max(_col3), avg(_col4), min(_col0), min(_col3), stddev_samp(_col2), var_samp(_col0) 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), _col2 (type: struct), _col3 (type: double), _col4 (type: struct), _col5 (type: int), _col6 (type: double), _col7 (type: struct), _col8 (type: struct) Execution mode: vectorized 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), (UDFToDouble(_col0) / -3728.0) (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), (UDFToDouble((_col0 * -3728)) % (_col2 - 10.175)) (type: double), (- _col3) (type: double), _col6 (type: double), (_col3 % -26.28) (type: double), _col7 (type: double), (- (UDFToDouble(_col0) / -3728.0)) (type: double), ((- (_col0 * -3728)) % (-563 % (_col0 * -3728))) (type: int), ((UDFToDouble(_col0) / -3728.0) - _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 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ctimestamp1 = ctimestamp2) or ((762.0 = cfloat) or ((cstring1 = 'ss') or (((UDFToLong(csmallint) <= cbigint) and (1 = cboolean2)) or (cboolean1 is not null and (ctimestamp2 is not null and (cstring2 > 'a'))))))) (type: boolean) Statistics: Num rows: 12288 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: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: var_pop(_col0), count(), max(_col1), stddev_pop(_col2), max(_col3), stddev_samp(_col4), count(_col1), avg(_col1) 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), _col1 (type: bigint), _col2 (type: tinyint), _col3 (type: struct), _col4 (type: int), _col5 (type: struct), _col6 (type: bigint), _col7 (type: struct) Execution mode: vectorized 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), (UDFToDouble(_col1) % 79.553) (type: double), _col2 (type: tinyint), (UDFToDouble(_col1) - (- _col0)) (type: double), (- (- _col0)) (type: double), (-1.0 % (- _col0)) (type: double), _col1 (type: bigint), (- _col1) (type: bigint), _col3 (type: double), (- (- (- _col0))) (type: double), (762 * (- _col1)) (type: bigint), _col4 (type: int), (UDFToLong(_col2) + (762 * (- _col1))) (type: bigint), ((- _col0) + UDFToDouble(_col4)) (type: double), _col5 (type: double), ((- _col1) % _col1) (type: bigint), _col6 (type: bigint), _col7 (type: double), (-3728 % (UDFToLong(_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 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((ctimestamp2 <= ctimestamp1) and ((UDFToDouble(cbigint) <> cdouble) and ('ss' <= cstring1))) or (((csmallint < UDFToShort(ctinyint)) and (UDFToDouble(ctimestamp1) >= 0.0)) or (cfloat = 17.0))) (type: boolean) Statistics: Num rows: 8874 Data size: 272428 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint), cbigint (type: bigint), cint (type: int), cfloat (type: float) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 8874 Data size: 272428 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: avg(_col0), max(_col1), stddev_samp(_col2), var_pop(_col2), var_pop(_col1), max(_col3) 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), _col1 (type: bigint), _col2 (type: struct), _col3 (type: struct), _col4 (type: struct), _col5 (type: float) Execution mode: vectorized 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.0) (type: double), ((_col0 + 6981.0) + _col0) (type: double), _col1 (type: bigint), (((_col0 + 6981.0) + _col0) / _col0) (type: double), (- (_col0 + 6981.0)) (type: double), _col2 (type: double), (_col0 % (- (_col0 + 6981.0))) (type: double), _col3 (type: double), _col4 (type: double), (- _col1) (type: bigint), (UDFToDouble((- _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))) ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint LIMIT 50 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))) ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint LIMIT 50 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((cstring1 rlike 'a.*') and (cstring2 like '%ss%')) or (((1 <> cboolean2) and ((UDFToDouble(csmallint) < 79.553) and (-257 <> UDFToInteger(ctinyint)))) or (((cdouble > UDFToDouble(ctinyint)) and (cfloat >= UDFToFloat(cint))) or ((UDFToLong(cint) < cbigint) and (UDFToLong(ctinyint) > cbigint))))) (type: boolean) Statistics: Num rows: 9898 Data size: 303864 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 - UDFToDouble(cint)) (type: double), (- csmallint) (type: smallint), (csmallint - (- csmallint)) (type: smallint), ((csmallint - (- csmallint)) + (- csmallint)) (type: smallint), (UDFToDouble(cint) / UDFToDouble(cint)) (type: double), ((-863.257 - UDFToDouble(cint)) - -26.28) (type: double), (- cfloat) (type: float), (cdouble * -89010.0) (type: double), (UDFToDouble(ctinyint) / 988888.0) (type: double), (- ctinyint) (type: tinyint), (79.553 / UDFToDouble(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: 9898 Data size: 303864 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int), _col1 (type: double), _col2 (type: timestamp), _col3 (type: string), _col4 (type: boolean), _col5 (type: tinyint), _col6 (type: float), _col7 (type: timestamp), _col8 (type: smallint), _col9 (type: bigint) sort order: ++++++++++ Statistics: Num rows: 9898 Data size: 303864 Basic stats: COMPLETE Column stats: NONE value expressions: _col10 (type: bigint), _col11 (type: int), _col12 (type: double), _col13 (type: smallint), _col14 (type: smallint), _col15 (type: smallint), _col16 (type: double), _col17 (type: double), _col18 (type: float), _col19 (type: double), _col20 (type: double), _col21 (type: tinyint), _col22 (type: double) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: boolean), KEY.reducesinkkey5 (type: tinyint), KEY.reducesinkkey6 (type: float), KEY.reducesinkkey7 (type: timestamp), KEY.reducesinkkey8 (type: smallint), KEY.reducesinkkey9 (type: bigint), VALUE._col0 (type: bigint), VALUE._col1 (type: int), VALUE._col2 (type: double), VALUE._col3 (type: smallint), VALUE._col4 (type: smallint), VALUE._col5 (type: smallint), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: float), VALUE._col9 (type: double), VALUE._col10 (type: double), VALUE._col11 (type: tinyint), VALUE._col12 (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: 9898 Data size: 303864 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 50 Statistics: Num rows: 50 Data size: 1500 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 50 Data size: 1500 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: 50 Processor Tree: 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))) ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint LIMIT 50 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))) ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint LIMIT 50 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### NULL -7196.0 1969-12-31 15:59:58.174 NULL false -64 -64.0 1969-12-31 15:59:56.048 -7196 406535485 -1515564288080 NULL NULL 7196 -14392 -7196 NULL NULL 64.0 6.4051596E8 -6.471915929812072E-5 64 -1.243015625 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -64 -64.0 1969-12-31 16:00:01.785 -7196 -1639157869 6110780535632 NULL NULL 7196 -14392 -7196 NULL NULL 64.0 6.4051596E8 -6.471915929812072E-5 64 -1.243015625 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -64 -64.0 1969-12-31 16:00:11.912 -7196 -1615920595 6024151978160 NULL NULL 7196 -14392 -7196 NULL NULL 64.0 6.4051596E8 -6.471915929812072E-5 64 -1.243015625 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -64 -64.0 1969-12-31 16:00:12.339 -7196 1805860756 -6732248898368 NULL NULL 7196 -14392 -7196 NULL NULL 64.0 6.4051596E8 -6.471915929812072E-5 64 -1.243015625 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -63 -63.0 1969-12-31 16:00:03.552 -7196 -1224023895 4563161080560 NULL NULL 7196 -14392 -7196 NULL NULL 63.0 6.4051596E8 -6.370792243408759E-5 63 -1.2627460317460317 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -63 -63.0 1969-12-31 16:00:07.375 -7196 -1711796768 6381578351104 NULL NULL 7196 -14392 -7196 NULL NULL 63.0 6.4051596E8 -6.370792243408759E-5 63 -1.2627460317460317 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -63 -63.0 1969-12-31 16:00:11.946 -7196 -994504916 3707514326848 NULL NULL 7196 -14392 -7196 NULL NULL 63.0 6.4051596E8 -6.370792243408759E-5 63 -1.2627460317460317 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 15:59:58.395 -7196 -1367753794 5098986144032 NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129032258064 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:01.22 -7196 1670449519 -6227435806832 NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129032258064 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:02.373 -7196 NULL NULL NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129032258064 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:03.85 -7196 -642836823 2396495676144 NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129032258064 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:09.025 -7196 -840223244 3132352253632 NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129032258064 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:12.388 -7196 NULL NULL NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129032258064 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 15:59:44.823 -7196 NULL NULL NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475409836065 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 15:59:48.035 -7196 1237548317 -4613580125776 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475409836065 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:03.049 -7196 -1513172815 5641108254320 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475409836065 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:06.848 -7196 1415466231 -5276858109168 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475409836065 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:11.842 -7196 NULL NULL NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475409836065 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:12.454 -7196 -2175533 8110387024 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475409836065 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:14.192 -7196 -2114172148 7881633767744 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475409836065 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -60 -60.0 1969-12-31 15:59:45.385 -7196 1775867066 -6620432422048 NULL NULL 7196 -14392 -7196 NULL NULL 60.0 6.4051596E8 -6.0674211841988174E-5 60 -1.3258833333333333 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -60 -60.0 1969-12-31 15:59:52.408 -7196 1516314750 -5652821388000 NULL NULL 7196 -14392 -7196 NULL NULL 60.0 6.4051596E8 -6.0674211841988174E-5 60 -1.3258833333333333 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -60 -60.0 1969-12-31 15:59:55.806 -7196 -1802243330 6718763134240 NULL NULL 7196 -14392 -7196 NULL NULL 60.0 6.4051596E8 -6.0674211841988174E-5 60 -1.3258833333333333 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -60 -60.0 1969-12-31 16:00:10.618 -7196 -68838726 256630770528 NULL NULL 7196 -14392 -7196 NULL NULL 60.0 6.4051596E8 -6.0674211841988174E-5 60 -1.3258833333333333 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -59 -59.0 1969-12-31 16:00:13.15 -7196 -1604890000 5983029920000 NULL NULL 7196 -14392 -7196 NULL NULL 59.0 6.4051596E8 -5.966297497795504E-5 59 -1.3483559322033898 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -58 -58.0 1969-12-31 15:59:47.859 -7196 -1770443874 6600214762272 NULL NULL 7196 -14392 -7196 NULL NULL 58.0 6.4051596E8 -5.86517381139219E-5 58 -1.3716034482758621 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -58 -58.0 1969-12-31 15:59:55.857 -7196 -825174557 3076250748496 NULL NULL 7196 -14392 -7196 NULL NULL 58.0 6.4051596E8 -5.86517381139219E-5 58 -1.3716034482758621 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -58 -58.0 1969-12-31 16:00:12.065 -7196 1257970504 -4689714038912 NULL NULL 7196 -14392 -7196 NULL NULL 58.0 6.4051596E8 -5.86517381139219E-5 58 -1.3716034482758621 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -57 -57.0 1969-12-31 15:59:44.539 -7196 1839592407 -6858000493296 NULL NULL 7196 -14392 -7196 NULL NULL 57.0 6.4051596E8 -5.764050124988876E-5 57 -1.3956666666666666 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -57 -57.0 1969-12-31 16:00:04.659 -7196 -1579093262 5886859680736 NULL NULL 7196 -14392 -7196 NULL NULL 57.0 6.4051596E8 -5.764050124988876E-5 57 -1.3956666666666666 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -57 -57.0 1969-12-31 16:00:05.5 -7196 2042351711 -7613887178608 NULL NULL 7196 -14392 -7196 NULL NULL 57.0 6.4051596E8 -5.764050124988876E-5 57 -1.3956666666666666 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -57 -57.0 1969-12-31 16:00:12.626 -7196 248308622 -925694542816 NULL NULL 7196 -14392 -7196 NULL NULL 57.0 6.4051596E8 -5.764050124988876E-5 57 -1.3956666666666666 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -56 -56.0 1969-12-31 16:00:02.298 -7196 -1509994296 5629258735488 NULL NULL 7196 -14392 -7196 NULL NULL 56.0 6.4051596E8 -5.6629264385855625E-5 56 -1.4205892857142857 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -55 -55.0 1969-12-31 15:59:43.932 -7196 1982381637 -7390318742736 NULL NULL 7196 -14392 -7196 NULL NULL 55.0 6.4051596E8 -5.561802752182249E-5 55 -1.4464181818181818 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -55 -55.0 1969-12-31 16:00:01.138 -7196 888532643 -3312449693104 NULL NULL 7196 -14392 -7196 NULL NULL 55.0 6.4051596E8 -5.561802752182249E-5 55 -1.4464181818181818 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -55 -55.0 1969-12-31 16:00:13.249 -7196 -685064281 2553919639568 NULL NULL 7196 -14392 -7196 NULL NULL 55.0 6.4051596E8 -5.561802752182249E-5 55 -1.4464181818181818 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -54 -54.0 1969-12-31 15:59:53.657 -7196 1476582815 -5504700734320 NULL NULL 7196 -14392 -7196 NULL NULL 54.0 6.4051596E8 -5.4606790657789354E-5 54 -1.4732037037037036 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -54 -54.0 1969-12-31 16:00:05.688 -7196 1614836149 -6020109163472 NULL NULL 7196 -14392 -7196 NULL NULL 54.0 6.4051596E8 -5.4606790657789354E-5 54 -1.4732037037037036 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -54 -54.0 1969-12-31 16:00:06.484 -7196 1605976008 -5987078557824 NULL NULL 7196 -14392 -7196 NULL NULL 54.0 6.4051596E8 -5.4606790657789354E-5 54 -1.4732037037037036 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -54 -54.0 1969-12-31 16:00:11.198 -7196 1650677402 -6153725354656 NULL NULL 7196 -14392 -7196 NULL NULL 54.0 6.4051596E8 -5.4606790657789354E-5 54 -1.4732037037037036 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -53 -53.0 1969-12-31 15:59:48.882 -7196 -1560660031 5818140595568 NULL NULL 7196 -14392 -7196 NULL NULL 53.0 6.4051596E8 -5.359555379375622E-5 53 -1.501 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -53 -53.0 1969-12-31 15:59:57.663 -7196 898472381 -3349505036368 NULL NULL 7196 -14392 -7196 NULL NULL 53.0 6.4051596E8 -5.359555379375622E-5 53 -1.501 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -53 -53.0 1969-12-31 16:00:11.36 -7196 -1357789899 5061840743472 NULL NULL 7196 -14392 -7196 NULL NULL 53.0 6.4051596E8 -5.359555379375622E-5 53 -1.501 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 15:59:45.978 -7196 -2128720310 7935869315680 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298653846153845 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 15:59:47.15 -7196 628698169 -2343786774032 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298653846153845 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 15:59:57.86 -7196 -26309289 98081029392 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298653846153845 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 15:59:58.479 -7196 -1379694191 5143499944048 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298653846153845 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 16:00:03.963 -7196 95444104 -355815619712 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298653846153845 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 16:00:04.518 -7196 -1658319459 6182214943152 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298653846153845 NULL -7196.0 1969-12-31 15:59:58.174 NULL false -51 -51.0 1969-12-31 15:59:43.64 -7196 -1339164819 4992406445232 NULL NULL 7196 -14392 -7196 NULL NULL 51.0 6.4051596E8 -5.157308006568995E-5 51 -1.5598627450980391 PREHOOK: query: -- TargetTypeClasses: Long, String, Double, Bool, Timestamp -- Functions: VarP, Var, StDev, StDevP, Max, Sum -- ArithmeticOps: Divide, Remainder, Subtract, Multiply -- FilterOps: Equal, LessThanOrEqual, LessThan, Like, GreaterThanOrEqual, NotEqual, GreaterThan -- GroupBy: NoGroupByProjectColumns EXPLAIN SELECT cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2, (cint / cbigint), (cbigint % 79.553), (-((cint / cbigint))), (10.175 % cfloat), (-(cfloat)), (cfloat - (-(cfloat))), ((cfloat - (-(cfloat))) % -6432), (cdouble * csmallint), (-(cdouble)), (-(cbigint)), (cfloat - (cint / cbigint)), (-(csmallint)), (3569 % cbigint), (359 - cdouble), (-(csmallint)) FROM alltypesorc WHERE (((197 > ctinyint) AND (cint = cbigint)) OR (cbigint = 359) OR (cboolean1 < 0) OR ((cstring1 LIKE '%ss') AND (cfloat <= ctinyint))) ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2 LIMIT 25 PREHOOK: type: QUERY POSTHOOK: query: -- TargetTypeClasses: Long, String, Double, Bool, Timestamp -- Functions: VarP, Var, StDev, StDevP, Max, Sum -- ArithmeticOps: Divide, Remainder, Subtract, Multiply -- FilterOps: Equal, LessThanOrEqual, LessThan, Like, GreaterThanOrEqual, NotEqual, GreaterThan -- GroupBy: NoGroupByProjectColumns EXPLAIN SELECT cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2, (cint / cbigint), (cbigint % 79.553), (-((cint / cbigint))), (10.175 % cfloat), (-(cfloat)), (cfloat - (-(cfloat))), ((cfloat - (-(cfloat))) % -6432), (cdouble * csmallint), (-(cdouble)), (-(cbigint)), (cfloat - (cint / cbigint)), (-(csmallint)), (3569 % cbigint), (359 - cdouble), (-(csmallint)) FROM alltypesorc WHERE (((197 > ctinyint) AND (cint = cbigint)) OR (cbigint = 359) OR (cboolean1 < 0) OR ((cstring1 LIKE '%ss') AND (cfloat <= ctinyint))) ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2 LIMIT 25 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((197.0 > UDFToDouble(ctinyint)) and (UDFToLong(cint) = cbigint)) or ((cbigint = 359) or ((cboolean1 < 0) or ((cstring1 like '%ss') and (cfloat <= UDFToFloat(ctinyint)))))) (type: boolean) Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int), cbigint (type: bigint), (UDFToDouble(cint) / UDFToDouble(cbigint)) (type: double), (UDFToDouble(cbigint) % 79.553) (type: double), (- (UDFToDouble(cint) / UDFToDouble(cbigint))) (type: double), (10.175 % UDFToDouble(cfloat)) (type: double), (- cfloat) (type: float), (cfloat - (- cfloat)) (type: float), ((cfloat - (- cfloat)) % -6432.0) (type: float), (cdouble * UDFToDouble(csmallint)) (type: double), (- cdouble) (type: double), (- cbigint) (type: bigint), cstring1 (type: string), (UDFToDouble(cfloat) - (UDFToDouble(cint) / UDFToDouble(cbigint))) (type: double), (- csmallint) (type: smallint), (3569 % cbigint) (type: bigint), (359.0 - cdouble) (type: double), cboolean1 (type: boolean), cfloat (type: float), cdouble (type: double), ctimestamp2 (type: timestamp), csmallint (type: smallint), cstring2 (type: string), cboolean2 (type: boolean) outputColumnNames: _col0, _col1, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col2, _col20, _col21, _col22, _col23, _col3, _col4, _col5, _col6, _col7, _col8, _col9 Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int), _col1 (type: bigint), _col2 (type: string), _col3 (type: boolean), _col4 (type: float), _col5 (type: double), _col6 (type: timestamp), _col7 (type: smallint), _col8 (type: string), _col9 (type: boolean) sort order: ++++++++++ Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE value expressions: _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type: float), _col15 (type: float), _col16 (type: float), _col17 (type: double), _col18 (type: double), _col19 (type: bigint), _col20 (type: double), _col21 (type: smallint), _col22 (type: bigint), _col23 (type: double) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: bigint), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: boolean), KEY.reducesinkkey4 (type: float), KEY.reducesinkkey5 (type: double), KEY.reducesinkkey6 (type: timestamp), KEY.reducesinkkey7 (type: smallint), KEY.reducesinkkey8 (type: string), KEY.reducesinkkey9 (type: boolean), VALUE._col0 (type: double), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: double), VALUE._col4 (type: float), VALUE._col5 (type: float), VALUE._col6 (type: float), VALUE._col7 (type: double), VALUE._col8 (type: double), VALUE._col9 (type: bigint), VALUE._col10 (type: double), VALUE._col11 (type: smallint), VALUE._col12 (type: bigint), VALUE._col13 (type: double), VALUE._col11 (type: smallint) 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: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 25 Statistics: Num rows: 25 Data size: 750 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 25 Data size: 750 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: 25 Processor Tree: ListSink PREHOOK: query: SELECT cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2, (cint / cbigint), (cbigint % 79.553), (-((cint / cbigint))), (10.175 % cfloat), (-(cfloat)), (cfloat - (-(cfloat))), ((cfloat - (-(cfloat))) % -6432), (cdouble * csmallint), (-(cdouble)), (-(cbigint)), (cfloat - (cint / cbigint)), (-(csmallint)), (3569 % cbigint), (359 - cdouble), (-(csmallint)) FROM alltypesorc WHERE (((197 > ctinyint) AND (cint = cbigint)) OR (cbigint = 359) OR (cboolean1 < 0) OR ((cstring1 LIKE '%ss') AND (cfloat <= ctinyint))) ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2 LIMIT 25 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc #### A masked pattern was here #### POSTHOOK: query: SELECT cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2, (cint / cbigint), (cbigint % 79.553), (-((cint / cbigint))), (10.175 % cfloat), (-(cfloat)), (cfloat - (-(cfloat))), ((cfloat - (-(cfloat))) % -6432), (cdouble * csmallint), (-(cdouble)), (-(cbigint)), (cfloat - (cint / cbigint)), (-(csmallint)), (3569 % cbigint), (359 - cdouble), (-(csmallint)) FROM alltypesorc WHERE (((197 > ctinyint) AND (cint = cbigint)) OR (cbigint = 359) OR (cboolean1 < 0) OR ((cstring1 LIKE '%ss') AND (cfloat <= ctinyint))) ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2 LIMIT 25 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -635141101 -89010 ss false -51.0 NULL NULL NULL rVWAj4N1MCg8Scyp7wj2C true 7135.6151106617235 -69.74600000000305 -7135.6151106617235 10.175 51.0 -102.0 -102.0 NULL NULL 89010 -7186.6151106617235 NULL 3569 NULL NULL -462839731 988888 ss false -51.0 NULL NULL NULL Lml5J2QBU77 false -468.04059812638036 44.210000000033915 468.04059812638036 10.175 51.0 -102.0 -102.0 NULL NULL -988888 417.04059812638036 NULL 3569 NULL NULL WARNING: Comparing a bigint and a double may result in a loss of precision. PREHOOK: query: -- TargetTypeClasses: String, Bool, Double, Long, Timestamp -- Functions: Sum, Max, Avg, Var, StDevP, VarP -- ArithmeticOps: Add, Subtract, Divide, Multiply, Remainder -- FilterOps: NotEqual, GreaterThanOrEqual, Like, LessThanOrEqual, Equal, GreaterThan -- GroupBy: NoGroupByProjectColumns EXPLAIN SELECT cint, cstring1, cboolean2, ctimestamp2, cdouble, cfloat, cbigint, csmallint, cboolean1, (cint + csmallint), (cbigint - ctinyint), (-(cbigint)), (-(cfloat)), ((cbigint - ctinyint) + cbigint), (cdouble / cdouble), (-(cdouble)), ((cint + csmallint) * (-(cbigint))), ((-(cdouble)) + cbigint), (-1.389 / ctinyint), (cbigint % cdouble), (-(csmallint)), (csmallint + (cint + csmallint)) FROM alltypesorc WHERE (((csmallint > -26.28) AND (cstring2 LIKE 'ss')) OR ((cdouble <= cbigint) AND ((cstring1 >= 'ss') AND (cint != cdouble))) OR (ctinyint = -89010) OR ((cbigint <= cfloat) AND (-26.28 <= csmallint))) ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble LIMIT 75 PREHOOK: type: QUERY POSTHOOK: query: -- TargetTypeClasses: String, Bool, Double, Long, Timestamp -- Functions: Sum, Max, Avg, Var, StDevP, VarP -- ArithmeticOps: Add, Subtract, Divide, Multiply, Remainder -- FilterOps: NotEqual, GreaterThanOrEqual, Like, LessThanOrEqual, Equal, GreaterThan -- GroupBy: NoGroupByProjectColumns EXPLAIN SELECT cint, cstring1, cboolean2, ctimestamp2, cdouble, cfloat, cbigint, csmallint, cboolean1, (cint + csmallint), (cbigint - ctinyint), (-(cbigint)), (-(cfloat)), ((cbigint - ctinyint) + cbigint), (cdouble / cdouble), (-(cdouble)), ((cint + csmallint) * (-(cbigint))), ((-(cdouble)) + cbigint), (-1.389 / ctinyint), (cbigint % cdouble), (-(csmallint)), (csmallint + (cint + csmallint)) FROM alltypesorc WHERE (((csmallint > -26.28) AND (cstring2 LIKE 'ss')) OR ((cdouble <= cbigint) AND ((cstring1 >= 'ss') AND (cint != cdouble))) OR (ctinyint = -89010) OR ((cbigint <= cfloat) AND (-26.28 <= csmallint))) ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble LIMIT 75 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((UDFToDouble(csmallint) > -26.28) and (cstring2 like 'ss')) or (((cdouble <= UDFToDouble(cbigint)) and ((cstring1 >= 'ss') and (UDFToDouble(cint) <> cdouble))) or ((UDFToInteger(ctinyint) = -89010) or ((UDFToFloat(cbigint) <= cfloat) and (-26.28 <= UDFToDouble(csmallint)))))) (type: boolean) Statistics: Num rows: 10922 Data size: 335301 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int), cstring1 (type: string), cboolean2 (type: boolean), ctimestamp2 (type: timestamp), cdouble (type: double), cfloat (type: float), cbigint (type: bigint), csmallint (type: smallint), cboolean1 (type: boolean), (cint + UDFToInteger(csmallint)) (type: int), (cbigint - UDFToLong(ctinyint)) (type: bigint), (- cbigint) (type: bigint), (- cfloat) (type: float), ((cbigint - UDFToLong(ctinyint)) + cbigint) (type: bigint), (cdouble / cdouble) (type: double), (- cdouble) (type: double), (UDFToLong((cint + UDFToInteger(csmallint))) * (- cbigint)) (type: bigint), ((- cdouble) + UDFToDouble(cbigint)) (type: double), (-1.389 / UDFToDouble(ctinyint)) (type: double), (UDFToDouble(cbigint) % cdouble) (type: double), (- csmallint) (type: smallint), (UDFToInteger(csmallint) + (cint + UDFToInteger(csmallint))) (type: int) 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: 10922 Data size: 335301 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col8 (type: boolean), _col1 (type: string), _col3 (type: timestamp), _col5 (type: float), _col6 (type: bigint), _col1 (type: string), _col4 (type: double), _col0 (type: int), _col7 (type: smallint), _col4 (type: double) sort order: ++++++++++ Statistics: Num rows: 10922 Data size: 335301 Basic stats: COMPLETE Column stats: NONE value expressions: _col2 (type: boolean), _col9 (type: int), _col10 (type: bigint), _col11 (type: bigint), _col12 (type: float), _col13 (type: bigint), _col14 (type: double), _col15 (type: double), _col16 (type: bigint), _col17 (type: double), _col18 (type: double), _col19 (type: double), _col20 (type: smallint), _col21 (type: int) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey7 (type: int), KEY.reducesinkkey1 (type: string), VALUE._col0 (type: boolean), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey6 (type: double), KEY.reducesinkkey3 (type: float), KEY.reducesinkkey4 (type: bigint), KEY.reducesinkkey8 (type: smallint), KEY.reducesinkkey0 (type: boolean), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: bigint), VALUE._col4 (type: float), VALUE._col5 (type: bigint), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: bigint), VALUE._col9 (type: double), VALUE._col10 (type: double), VALUE._col11 (type: double), VALUE._col12 (type: smallint), VALUE._col13 (type: int) 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: 10922 Data size: 335301 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 75 Statistics: Num rows: 75 Data size: 2250 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 75 Data size: 2250 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: 75 Processor Tree: ListSink WARNING: Comparing a bigint and a double may result in a loss of precision. PREHOOK: query: SELECT cint, cstring1, cboolean2, ctimestamp2, cdouble, cfloat, cbigint, csmallint, cboolean1, (cint + csmallint), (cbigint - ctinyint), (-(cbigint)), (-(cfloat)), ((cbigint - ctinyint) + cbigint), (cdouble / cdouble), (-(cdouble)), ((cint + csmallint) * (-(cbigint))), ((-(cdouble)) + cbigint), (-1.389 / ctinyint), (cbigint % cdouble), (-(csmallint)), (csmallint + (cint + csmallint)) FROM alltypesorc WHERE (((csmallint > -26.28) AND (cstring2 LIKE 'ss')) OR ((cdouble <= cbigint) AND ((cstring1 >= 'ss') AND (cint != cdouble))) OR (ctinyint = -89010) OR ((cbigint <= cfloat) AND (-26.28 <= csmallint))) ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble LIMIT 75 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc #### A masked pattern was here #### POSTHOOK: query: SELECT cint, cstring1, cboolean2, ctimestamp2, cdouble, cfloat, cbigint, csmallint, cboolean1, (cint + csmallint), (cbigint - ctinyint), (-(cbigint)), (-(cfloat)), ((cbigint - ctinyint) + cbigint), (cdouble / cdouble), (-(cdouble)), ((cint + csmallint) * (-(cbigint))), ((-(cdouble)) + cbigint), (-1.389 / ctinyint), (cbigint % cdouble), (-(csmallint)), (csmallint + (cint + csmallint)) FROM alltypesorc WHERE (((csmallint > -26.28) AND (cstring2 LIKE 'ss')) OR ((cdouble <= cbigint) AND ((cstring1 >= 'ss') AND (cint != cdouble))) OR (ctinyint = -89010) OR ((cbigint <= cfloat) AND (-26.28 <= csmallint))) ORDER BY cboolean1, cstring1, ctimestamp2, cfloat, cbigint, cstring1, cdouble, cint, csmallint, cdouble LIMIT 75 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### NULL NULL true 1969-12-31 15:59:58.456 15601.0 -64.0 -1809291815 15601 NULL NULL -1809291751 1809291815 64.0 -3618583566 1.0 -15601.0 NULL -1.809307416E9 0.021703125 -12643.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -63.0 -1996001975 15601 NULL NULL -1996001912 1996001975 63.0 -3992003887 1.0 -15601.0 NULL -1.996017576E9 0.02204761904761905 -10035.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -63.0 -1574729892 15601 NULL NULL -1574729829 1574729892 63.0 -3149459721 1.0 -15601.0 NULL -1.574745493E9 0.02204761904761905 -11755.0 -15601 NULL NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -63.0 -1167054574 15601 NULL NULL -1167054511 1167054574 63.0 -2334109085 1.0 -15601.0 NULL -1.167070175E9 0.02204761904761905 -6168.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -63.0 -721244708 15601 NULL NULL -721244645 721244708 63.0 -1442489353 1.0 -15601.0 NULL -7.21260309E8 0.02204761904761905 -10478.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -63.0 -200542601 15601 NULL NULL -200542538 200542601 63.0 -401085139 1.0 -15601.0 NULL -2.00558202E8 0.02204761904761905 -7347.0 -15601 NULL NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -62.0 -1726415169 15601 NULL NULL -1726415107 1726415169 62.0 -3452830276 1.0 -15601.0 NULL -1.72643077E9 0.022403225806451613 -8509.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -62.0 -1592016120 15601 NULL NULL -1592016058 1592016120 62.0 -3184032178 1.0 -15601.0 NULL -1.592031721E9 0.022403225806451613 -12075.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -62.0 667693308 15601 NULL NULL 667693370 -667693308 62.0 1335386678 1.0 -15601.0 NULL 6.67677707E8 0.022403225806451613 1710.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -61.0 -1022679553 15601 NULL NULL -1022679492 1022679553 61.0 -2045359045 1.0 -15601.0 NULL -1.022695154E9 0.02277049180327869 -2801.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -61.0 -982179838 15601 NULL NULL -982179777 982179838 61.0 -1964359615 1.0 -15601.0 NULL -9.82195439E8 0.02277049180327869 -3282.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -61.0 -854893578 15601 NULL NULL -854893517 854893578 61.0 -1709787095 1.0 -15601.0 NULL -8.54909179E8 0.02277049180327869 -5581.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -60.0 -2041965187 15601 NULL NULL -2041965127 2041965187 60.0 -4083930314 1.0 -15601.0 NULL -2.041980788E9 0.02315 -12701.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -60.0 -1743144280 15601 NULL NULL -1743144220 1743144280 60.0 -3486288500 1.0 -15601.0 NULL -1.743159881E9 0.02315 -13348.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -60.0 -1016256928 15601 NULL NULL -1016256868 1016256928 60.0 -2032513796 1.0 -15601.0 NULL -1.016272529E9 0.02315 -7788.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -60.0 -903925845 15601 NULL NULL -903925785 903925845 60.0 -1807851630 1.0 -15601.0 NULL -9.03941446E8 0.02315 -3905.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -60.0 -519753851 15601 NULL NULL -519753791 519753851 60.0 -1039507642 1.0 -15601.0 NULL -5.19769452E8 0.02315 -6536.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -60.0 -5953872 15601 NULL NULL -5953812 5953872 60.0 -11907684 1.0 -15601.0 NULL -5969473.0 0.02315 -9891.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -59.0 -2021724111 15601 NULL NULL -2021724052 2021724111 59.0 -4043448163 1.0 -15601.0 NULL -2.021739712E9 0.02354237288135593 -6122.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -59.0 -1315413812 15601 NULL NULL -1315413753 1315413812 59.0 -2630827565 1.0 -15601.0 NULL -1.315429413E9 0.02354237288135593 -15497.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -59.0 -133287350 15601 NULL NULL -133287291 133287350 59.0 -266574641 1.0 -15601.0 NULL -1.33302951E8 0.02354237288135593 -8007.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -58.0 -1560616588 15601 NULL NULL -1560616530 1560616588 58.0 -3121233118 1.0 -15601.0 NULL -1.560632189E9 0.023948275862068966 -1755.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -58.0 -1072335429 15601 NULL NULL -1072335371 1072335429 58.0 -2144670800 1.0 -15601.0 NULL -1.07235103E9 0.023948275862068966 -694.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -57.0 -2123576095 15601 NULL NULL -2123576038 2123576095 57.0 -4247152133 1.0 -15601.0 NULL -2.123591696E9 0.02436842105263158 -14778.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -57.0 -1698345590 15601 NULL NULL -1698345533 1698345590 57.0 -3396691123 1.0 -15601.0 NULL -1.698361191E9 0.02436842105263158 -5129.0 -15601 NULL NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -57.0 -1057361026 15601 NULL NULL -1057360969 1057361026 57.0 -2114721995 1.0 -15601.0 NULL -1.057376627E9 0.02436842105263158 -3251.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -57.0 -585350546 15601 NULL NULL -585350489 585350546 57.0 -1170701035 1.0 -15601.0 NULL -5.85366147E8 0.02436842105263158 -1026.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -57.0 -365505703 15601 NULL NULL -365505646 365505703 57.0 -731011349 1.0 -15601.0 NULL -3.65521304E8 0.02436842105263158 -5475.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -57.0 -304247740 15601 NULL NULL -304247683 304247740 57.0 -608495423 1.0 -15601.0 NULL -3.04263341E8 0.02436842105263158 -12639.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -56.0 -1683701844 15601 NULL NULL -1683701788 1683701844 56.0 -3367403632 1.0 -15601.0 NULL -1.683717445E9 0.02480357142857143 -10722.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -56.0 -1466363382 15601 NULL NULL -1466363326 1466363382 56.0 -2932726708 1.0 -15601.0 NULL -1.466378983E9 0.02480357142857143 -9791.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -56.0 -1105322173 15601 NULL NULL -1105322117 1105322173 56.0 -2210644290 1.0 -15601.0 NULL -1.105337774E9 0.02480357142857143 -6924.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -56.0 -971846497 15601 NULL NULL -971846441 971846497 56.0 -1943692938 1.0 -15601.0 NULL -9.71862098E8 0.02480357142857143 -13404.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -56.0 -865054294 15601 NULL NULL -865054238 865054294 56.0 -1730108532 1.0 -15601.0 NULL -8.65069895E8 0.02480357142857143 -10046.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -55.0 -1483320156 15601 NULL NULL -1483320101 1483320156 55.0 -2966640257 1.0 -15601.0 NULL -1.483335757E9 0.025254545454545453 -8278.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -55.0 -1338667765 15601 NULL NULL -1338667710 1338667765 55.0 -2677335475 1.0 -15601.0 NULL -1.338683366E9 0.025254545454545453 -8359.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -55.0 -1062767051 15601 NULL NULL -1062766996 1062767051 55.0 -2125534047 1.0 -15601.0 NULL -1.062782652E9 0.025254545454545453 -11330.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -54.0 -1984659810 15601 NULL NULL -1984659756 1984659810 54.0 -3969319566 1.0 -15601.0 NULL -1.984675411E9 0.025722222222222223 -9797.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -54.0 -1795674990 15601 NULL NULL -1795674936 1795674990 54.0 -3591349926 1.0 -15601.0 NULL -1.795690591E9 0.025722222222222223 -15491.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -54.0 -1754189160 15601 NULL NULL -1754189106 1754189160 54.0 -3508378266 1.0 -15601.0 NULL -1.754204761E9 0.025722222222222223 -12720.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -54.0 -1114169807 15601 NULL NULL -1114169753 1114169807 54.0 -2228339560 1.0 -15601.0 NULL -1.114185408E9 0.025722222222222223 -8791.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -54.0 -989710558 15601 NULL NULL -989710504 989710558 54.0 -1979421062 1.0 -15601.0 NULL -9.89726159E8 0.025722222222222223 -14320.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -54.0 -641670659 15601 NULL NULL -641670605 641670659 54.0 -1283341264 1.0 -15601.0 NULL -6.4168626E8 0.025722222222222223 -1529.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -52.0 -2097289702 15601 NULL NULL -2097289650 2097289702 52.0 -4194579352 1.0 -15601.0 NULL -2.097305303E9 0.02671153846153846 -469.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -52.0 -2074134645 15601 NULL NULL -2074134593 2074134645 52.0 -4148269238 1.0 -15601.0 NULL -2.074150246E9 0.02671153846153846 -12897.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -52.0 -886068046 15601 NULL NULL -886067994 886068046 52.0 -1772136040 1.0 -15601.0 NULL -8.86083647E8 0.02671153846153846 -9251.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -51.0 -546830045 15601 NULL NULL -546829994 546830045 51.0 -1093660039 1.0 -15601.0 NULL -5.46845646E8 0.02723529411764706 -14995.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -50.0 -596103241 15601 NULL NULL -596103191 596103241 50.0 -1192206432 1.0 -15601.0 NULL -5.96118842E8 0.02778 -4632.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -50.0 -458110015 15601 NULL NULL -458109965 458110015 50.0 -916219980 1.0 -15601.0 NULL -4.58125616E8 0.02778 -2251.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -49.0 -1841324115 15601 NULL NULL -1841324066 1841324115 49.0 -3682648181 1.0 -15601.0 NULL -1.841339716E9 0.028346938775510203 -489.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -990904667 15601 NULL NULL -990904618 990904667 49.0 -1981809285 1.0 -15601.0 NULL -9.90920268E8 0.028346938775510203 -7152.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -668597606 15601 NULL NULL -668597557 668597606 49.0 -1337195163 1.0 -15601.0 NULL -6.68613207E8 0.028346938775510203 -1150.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -49.0 -230127703 15601 NULL NULL -230127654 230127703 49.0 -460255357 1.0 -15601.0 NULL -2.30143304E8 0.028346938775510203 -12953.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -211726367 15601 NULL NULL -211726318 211726367 49.0 -423452685 1.0 -15601.0 NULL -2.11741968E8 0.028346938775510203 -5196.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -197652849 15601 NULL NULL -197652800 197652849 49.0 -395305649 1.0 -15601.0 NULL -1.9766845E8 0.028346938775510203 -3780.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -57200424 15601 NULL NULL -57200375 57200424 49.0 -114400799 1.0 -15601.0 NULL -5.7216025E7 0.028346938775510203 -7158.0 -15601 NULL NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -48.0 -1683400285 15601 NULL NULL -1683400237 1683400285 48.0 -3366800522 1.0 -15601.0 NULL -1.683415886E9 0.0289375 -5582.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -48.0 -1666377780 15601 NULL NULL -1666377732 1666377780 48.0 -3332755512 1.0 -15601.0 NULL -1.666393381E9 0.0289375 -3768.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -48.0 -1465907371 15601 NULL NULL -1465907323 1465907371 48.0 -2931814694 1.0 -15601.0 NULL -1.465922972E9 0.0289375 -6209.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -48.0 -1427685796 15601 NULL NULL -1427685748 1427685796 48.0 -2855371544 1.0 -15601.0 NULL -1.427701397E9 0.0289375 -7084.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -48.0 -1294837001 15601 NULL NULL -1294836953 1294837001 48.0 -2589673954 1.0 -15601.0 NULL -1.294852602E9 0.0289375 -804.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -48.0 -1228417392 15601 NULL NULL -1228417344 1228417392 48.0 -2456834736 1.0 -15601.0 NULL -1.228432993E9 0.0289375 -10253.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -48.0 -803222928 15601 NULL NULL -803222880 803222928 48.0 -1606445808 1.0 -15601.0 NULL -8.03238529E8 0.0289375 -5443.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -48.0 -652336471 15601 NULL NULL -652336423 652336471 48.0 -1304672894 1.0 -15601.0 NULL -6.52352072E8 0.0289375 -11858.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -47.0 -1828371599 15601 NULL NULL -1828371552 1828371599 47.0 -3656743151 1.0 -15601.0 NULL -1.8283872E9 0.029553191489361703 -12404.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -47.0 -493471535 15601 NULL NULL -493471488 493471535 47.0 -986943023 1.0 -15601.0 NULL -4.93487136E8 0.029553191489361703 -11905.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -47.0 -436916225 15601 NULL NULL -436916178 436916225 47.0 -873832403 1.0 -15601.0 NULL -4.36931826E8 0.029553191489361703 -10220.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -46.0 -468932050 15601 NULL NULL -468932004 468932050 46.0 -937864054 1.0 -15601.0 NULL -4.68947651E8 0.030195652173913044 -12793.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -46.0 -208932264 15601 NULL NULL -208932218 208932264 46.0 -417864482 1.0 -15601.0 NULL -2.08947865E8 0.030195652173913044 -3672.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -45.0 -1291025659 15601 NULL NULL -1291025614 1291025659 45.0 -2582051273 1.0 -15601.0 NULL -1.29104126E9 0.030866666666666667 -11707.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -45.0 -1022657523 15601 NULL NULL -1022657478 1022657523 45.0 -2045315001 1.0 -15601.0 NULL -1.022673124E9 0.030866666666666667 -11973.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -45.0 -831227593 15601 NULL NULL -831227548 831227593 45.0 -1662455141 1.0 -15601.0 NULL -8.31243194E8 0.030866666666666667 -6313.0 -15601 NULL NULL NULL false 1969-12-31 15:59:58.456 15601.0 -44.0 -1551649760 15601 NULL NULL -1551649716 1551649760 44.0 -3103299476 1.0 -15601.0 NULL -1.551665361E9 0.03156818181818182 -5502.0 -15601 NULL NULL NULL true 1969-12-31 15:59:58.456 15601.0 -44.0 -1447719201 15601 NULL NULL -1447719157 1447719201 44.0 -2895438358 1.0 -15601.0 NULL -1.447734802E9 0.03156818181818182 -8805.0 -15601 NULL NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -44.0 -1416000760 15601 NULL NULL -1416000716 1416000760 44.0 -2832001476 1.0 -15601.0 NULL -1.416016361E9 0.03156818181818182 -7197.0 -15601 NULL WARNING: Comparing a bigint and a double may result in a loss of precision. PREHOOK: query: -- TargetTypeClasses: Long, String, Double, Timestamp -- Functions: Avg, Min, StDevP, Sum, Var -- ArithmeticOps: Divide, Subtract, Multiply, Remainder -- FilterOps: GreaterThan, LessThan, LessThanOrEqual, GreaterThanOrEqual, Like -- GroupBy: NoGroupByProjectColumns EXPLAIN SELECT ctimestamp1, cstring2, cdouble, cfloat, cbigint, csmallint, (cbigint / 3569), (-257 - csmallint), (-6432 * cfloat), (-(cdouble)), (cdouble * 10.175), ((-6432 * cfloat) / cfloat), (-(cfloat)), (cint % csmallint), (-(cdouble)), (cdouble * (-(cdouble))) FROM alltypesorc WHERE (((-1.389 >= cint) AND ((csmallint < ctinyint) AND (-6432 > csmallint))) OR ((cdouble >= cfloat) AND (cstring2 <= 'a')) OR ((cstring1 LIKE 'ss%') AND (10.175 > cbigint))) ORDER BY csmallint, cstring2, cdouble LIMIT 45 PREHOOK: type: QUERY POSTHOOK: query: -- TargetTypeClasses: Long, String, Double, Timestamp -- Functions: Avg, Min, StDevP, Sum, Var -- ArithmeticOps: Divide, Subtract, Multiply, Remainder -- FilterOps: GreaterThan, LessThan, LessThanOrEqual, GreaterThanOrEqual, Like -- GroupBy: NoGroupByProjectColumns EXPLAIN SELECT ctimestamp1, cstring2, cdouble, cfloat, cbigint, csmallint, (cbigint / 3569), (-257 - csmallint), (-6432 * cfloat), (-(cdouble)), (cdouble * 10.175), ((-6432 * cfloat) / cfloat), (-(cfloat)), (cint % csmallint), (-(cdouble)), (cdouble * (-(cdouble))) FROM alltypesorc WHERE (((-1.389 >= cint) AND ((csmallint < ctinyint) AND (-6432 > csmallint))) OR ((cdouble >= cfloat) AND (cstring2 <= 'a')) OR ((cstring1 LIKE 'ss%') AND (10.175 > cbigint))) ORDER BY csmallint, cstring2, cdouble LIMIT 45 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((-1.389 >= UDFToDouble(cint)) and ((csmallint < UDFToShort(ctinyint)) and (-6432 > UDFToInteger(csmallint)))) or (((cdouble >= UDFToDouble(cfloat)) and (cstring2 <= 'a')) or ((cstring1 like 'ss%') and (10.175 > UDFToDouble(cbigint))))) (type: boolean) Statistics: Num rows: 3868 Data size: 118746 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctimestamp1 (type: timestamp), cstring2 (type: string), (cdouble * 10.175) (type: double), (UDFToDouble((-6432.0 * cfloat)) / UDFToDouble(cfloat)) (type: double), (- cfloat) (type: float), (cint % UDFToInteger(csmallint)) (type: int), (cdouble * (- cdouble)) (type: double), cdouble (type: double), cfloat (type: float), cbigint (type: bigint), csmallint (type: smallint), (UDFToDouble(cbigint) / 3569.0) (type: double), (-257 - UDFToInteger(csmallint)) (type: int), (-6432.0 * cfloat) (type: float), (- cdouble) (type: double) outputColumnNames: _col0, _col1, _col10, _col11, _col12, _col13, _col15, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9 Statistics: Num rows: 3868 Data size: 118746 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col5 (type: smallint), _col1 (type: string), _col2 (type: double) sort order: +++ Statistics: Num rows: 3868 Data size: 118746 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: timestamp), _col3 (type: float), _col4 (type: bigint), _col6 (type: double), _col7 (type: int), _col8 (type: float), _col9 (type: double), _col10 (type: double), _col11 (type: double), _col12 (type: float), _col13 (type: int), _col15 (type: double) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: VALUE._col0 (type: timestamp), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: double), VALUE._col1 (type: float), VALUE._col2 (type: bigint), KEY.reducesinkkey0 (type: smallint), VALUE._col3 (type: double), VALUE._col4 (type: int), VALUE._col5 (type: float), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: double), VALUE._col9 (type: float), VALUE._col10 (type: int), VALUE._col6 (type: double), VALUE._col11 (type: double) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15 Statistics: Num rows: 3868 Data size: 118746 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 45 Statistics: Num rows: 45 Data size: 1350 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 45 Data size: 1350 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: 45 Processor Tree: ListSink WARNING: Comparing a bigint and a double may result in a loss of precision. PREHOOK: query: SELECT ctimestamp1, cstring2, cdouble, cfloat, cbigint, csmallint, (cbigint / 3569), (-257 - csmallint), (-6432 * cfloat), (-(cdouble)), (cdouble * 10.175), ((-6432 * cfloat) / cfloat), (-(cfloat)), (cint % csmallint), (-(cdouble)), (cdouble * (-(cdouble))) FROM alltypesorc WHERE (((-1.389 >= cint) AND ((csmallint < ctinyint) AND (-6432 > csmallint))) OR ((cdouble >= cfloat) AND (cstring2 <= 'a')) OR ((cstring1 LIKE 'ss%') AND (10.175 > cbigint))) ORDER BY csmallint, cstring2, cdouble LIMIT 45 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc #### A masked pattern was here #### POSTHOOK: query: SELECT ctimestamp1, cstring2, cdouble, cfloat, cbigint, csmallint, (cbigint / 3569), (-257 - csmallint), (-6432 * cfloat), (-(cdouble)), (cdouble * 10.175), ((-6432 * cfloat) / cfloat), (-(cfloat)), (cint % csmallint), (-(cdouble)), (cdouble * (-(cdouble))) FROM alltypesorc WHERE (((-1.389 >= cint) AND ((csmallint < ctinyint) AND (-6432 > csmallint))) OR ((cdouble >= cfloat) AND (cstring2 <= 'a')) OR ((cstring1 LIKE 'ss%') AND (10.175 > cbigint))) ORDER BY csmallint, cstring2, cdouble LIMIT 45 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### 1969-12-31 16:00:08.451 rVWAj4N1MCg8Scyp7wj2C NULL -51.0 -89010 NULL -24.93975903614458 NULL 328032.0 NULL NULL -6432.0 51.0 NULL NULL NULL NULL 4hA4KQj2vD3fI6gX82220d 477.0 NULL -1887561756 477 -528876.9279910339 -734 NULL -477.0 4853.475 NULL NULL -326 -477.0 -227529.0 NULL xH7445Rals48VOulSyR5F 10221.0 NULL -1645852809 10221 -461152.37013168953 -10478 NULL -10221.0 103998.675 NULL NULL 5022 -10221.0 -1.04468841E8 NULL 4hA4KQj2vD3fI6gX82220d 12329.0 NULL -1887561756 12329 -528876.9279910339 -12586 NULL -12329.0 125447.57500000001 NULL NULL -3104 -12329.0 -1.52004241E8 1969-12-31 15:59:46.443 0034fkcXMQI3 15601.0 -43.0 -223687300 15601 -62675.06304286915 -15858 276576.0 -15601.0 158740.17500000002 -6432.0 43.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:52.778 00d5kr1wEB7evExG 15601.0 4.0 -941884962 15601 -263907.24628747546 -15858 -25728.0 -15601.0 158740.17500000002 -6432.0 -4.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:57.729 020gtq4CLjybO3F40kpyXi 15601.0 30.0 -1986754040 15601 -556669.6665732699 -15858 -192960.0 -15601.0 158740.17500000002 -6432.0 -30.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:58.704 041Ph15F 15601.0 -55.0 -1338667765 15601 -375082.02998038667 -15858 353760.0 -15601.0 158740.17500000002 -6432.0 55.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:54.253 047TAc3t6f6rU8M7Dk7Gh8 15601.0 -44.0 272368436 15601 76315.05631829644 -15858 283008.0 -15601.0 158740.17500000002 -6432.0 44.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:04.063 04XP4DrTCblC7885 15601.0 79.553 -1452617198 15601 -407009.58195572987 -15858 -511684.9 -15601.0 158740.17500000002 -6432.0 -79.553 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:09.123 064GHv0UW8 15601.0 -14.0 1007181336 15601 282202.67189688986 -15858 90048.0 -15601.0 158740.17500000002 -6432.0 14.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:05.83 06Tj8f5xNhpaiE71AWqJ7b5 15601.0 -49.0 226841234 15601 63558.76548052676 -15858 315168.0 -15601.0 158740.17500000002 -6432.0 49.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:47.436 08wTUR832pDS4Hd8O40 15601.0 -51.0 69448698 15601 19458.86746987952 -15858 328032.0 -15601.0 158740.17500000002 -6432.0 51.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:46.258 0E6V6dPe00Ort5Ia6Ha8 15601.0 -26.0 1351243372 15601 378605.5959652564 -15858 167232.0 -15601.0 158740.17500000002 -6432.0 26.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:48.552 0Ef374 15601.0 62.0 -1488190636 15601 -416976.9223872233 -15858 -398784.0 -15601.0 158740.17500000002 -6432.0 -62.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:56.481 0IJJNV0BH 15601.0 10.0 -1230115822 15601 -344666.80358643876 -15858 -64320.0 -15601.0 158740.17500000002 -6432.0 -10.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:51.535 0JA4aw00Rkv1mSy 15601.0 55.0 -1044215393 15601 -292579.26393947884 -15858 -353760.0 -15601.0 158740.17500000002 -6432.0 -55.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:03.888 0KoLN8L6Iih8ej2sW7JF 15601.0 -23.0 -2104361963 15601 -589622.2927991034 -15858 147936.0 -15601.0 158740.17500000002 -6432.0 23.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:51.645 0ORX152g18fL0nI10TVqI 15601.0 10.0 -1043251982 15601 -292309.3253012048 -15858 -64320.0 -15601.0 158740.17500000002 -6432.0 -10.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:14.175 0Q7LP3644p 15601.0 -50.0 716349726 15601 200714.40907817316 -15858 321600.0 -15601.0 158740.17500000002 -6432.0 50.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:45.655 0QVeMpE1JOCOS1427vP47tk0 15601.0 -23.0 649202618 15601 181900.4253292239 -15858 147936.0 -15601.0 158740.17500000002 -6432.0 23.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:11.928 0UugmY0R5hI 15601.0 -32.0 1701987317 15601 476880.7276548053 -15858 205824.0 -15601.0 158740.17500000002 -6432.0 32.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:51.153 0Yo1dcEr7D57no22Tiv2TXR 15601.0 -44.0 -399793337 15601 -112018.30680862987 -15858 283008.0 -15601.0 158740.17500000002 -6432.0 44.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:53.715 0aQBRP67JY0gpi 15601.0 -44.0 -75975416 15601 -21287.59204258896 -15858 283008.0 -15601.0 158740.17500000002 -6432.0 44.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:46.82 0bsH6qR 15601.0 -46.0 -208932264 15601 -58540.8416923508 -15858 295872.0 -15601.0 158740.17500000002 -6432.0 46.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:46.33 0e8O8CeLi 15601.0 24.0 -1740312484 15601 -487619.0764920146 -15858 -154368.0 -15601.0 158740.17500000002 -6432.0 -24.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:48.71 0h046K61PUKMqHs6v4 15601.0 -30.0 1221840945 15601 342348.26141776406 -15858 192960.0 -15601.0 158740.17500000002 -6432.0 30.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:54.524 0ltFl7 15601.0 52.0 1551262646 15601 434649.1022695433 -15858 -334464.0 -15601.0 158740.17500000002 -6432.0 -52.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:05.007 0nur4r8MV673GcJp3h765I 15601.0 35.0 2123136080 15601 594882.6225833567 -15858 -225120.0 -15601.0 158740.17500000002 -6432.0 -35.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:44.115 0p6665Ys81o1ITrC5DSoHV 15601.0 -20.0 -258993110 15601 -72567.41664331745 -15858 128640.0 -15601.0 158740.17500000002 -6432.0 20.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:50.575 0q1A0HR4Q8Cd6r 15601.0 29.0 -221039350 15601 -61933.132530120485 -15858 -186528.0 -15601.0 158740.17500000002 -6432.0 -29.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:02.401 0q4ykcW1A0SyL68L2FH45a 15601.0 30.0 2033485401 15601 569763.3513589241 -15858 -192960.0 -15601.0 158740.17500000002 -6432.0 -30.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:52.786 0to563s4g3qycP5T8 15601.0 -1.0 672512361 15601 188431.59456430373 -15858 6432.0 -15601.0 158740.17500000002 -6432.0 1.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:05.334 0u7Jba8i21vWm 15601.0 22.0 -1875861804 15601 -525598.7122443261 -15858 -141504.0 -15601.0 158740.17500000002 -6432.0 -22.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:54.384 0uO20 15601.0 -59.0 1850076369 15601 518373.87755673856 -15858 379488.0 -15601.0 158740.17500000002 -6432.0 59.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:53.279 0vC4nYJsnNgXvL5 15601.0 -11.0 1778089631 15601 498203.87531521433 -15858 70752.0 -15601.0 158740.17500000002 -6432.0 11.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:48.932 10 15601.0 16.0 NULL 15601 NULL -15858 -102912.0 -15601.0 158740.17500000002 -6432.0 -16.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:44.661 10mF5gYR5Fey1vTEHx 15601.0 25.0 -2030132877 15601 -568824.0058840011 -15858 -160800.0 -15601.0 158740.17500000002 -6432.0 -25.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:05.997 12AEw 15601.0 -64.0 1421812187 15601 398378.30961053516 -15858 411648.0 -15601.0 158740.17500000002 -6432.0 64.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:12.853 12gbSP4px465TdXmV5F2apmC 15601.0 28.0 -1556827241 15601 -436208.2490893808 -15858 -180096.0 -15601.0 158740.17500000002 -6432.0 -28.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:15.671 1434C61RVhlDmptMem1X 15601.0 -4.0 913861995 15601 256055.47632390025 -15858 25728.0 -15601.0 158740.17500000002 -6432.0 4.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:07.499 14MDiWrX 15601.0 -33.0 42147119 15601 11809.223592042588 -15858 212256.0 -15601.0 158740.17500000002 -6432.0 33.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:46.351 155506i0h358vma3m1tGku 15601.0 -57.0 1328883886 15601 372340.6797422247 -15858 366624.0 -15601.0 158740.17500000002 -6432.0 57.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:15.522 1618frAK6kL 15601.0 -44.0 1296727292 15601 363330.70664051553 -15858 283008.0 -15601.0 158740.17500000002 -6432.0 44.0 NULL -15601.0 -2.43391201E8 1969-12-31 15:59:52.617 16NIx33qB1Thp5q 15601.0 -9.0 1660201497 15601 465172.7366209022 -15858 57888.0 -15601.0 158740.17500000002 -6432.0 9.0 NULL -15601.0 -2.43391201E8 PREHOOK: query: -- TargetTypeClasses: Double, String, Long -- Functions: StDev, Sum, VarP, Count -- ArithmeticOps: Remainder, Divide, Subtract -- FilterOps: GreaterThanOrEqual, Equal, LessThanOrEqual -- GroupBy: GroupBy EXPLAIN SELECT csmallint, (csmallint % -75), STDDEV_SAMP(csmallint), (-1.389 / csmallint), SUM(cbigint), ((csmallint % -75) / SUM(cbigint)), (-((csmallint % -75))), VAR_POP(ctinyint), (-((-((csmallint % -75))))), COUNT(*), (COUNT(*) - -89010) FROM alltypesorc WHERE (((csmallint >= -257)) AND ((-6432 = csmallint) OR ((cint >= cdouble) AND (ctinyint <= cint)))) GROUP BY csmallint ORDER BY csmallint LIMIT 20 PREHOOK: type: QUERY POSTHOOK: query: -- TargetTypeClasses: Double, String, Long -- Functions: StDev, Sum, VarP, Count -- ArithmeticOps: Remainder, Divide, Subtract -- FilterOps: GreaterThanOrEqual, Equal, LessThanOrEqual -- GroupBy: GroupBy EXPLAIN SELECT csmallint, (csmallint % -75), STDDEV_SAMP(csmallint), (-1.389 / csmallint), SUM(cbigint), ((csmallint % -75) / SUM(cbigint)), (-((csmallint % -75))), VAR_POP(ctinyint), (-((-((csmallint % -75))))), COUNT(*), (COUNT(*) - -89010) FROM alltypesorc WHERE (((csmallint >= -257)) AND ((-6432 = csmallint) OR ((cint >= cdouble) AND (ctinyint <= cint)))) GROUP BY csmallint ORDER BY csmallint LIMIT 20 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 Stage-0 depends on stages: Stage-2 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToInteger(csmallint) >= -257) and ((-6432 = UDFToInteger(csmallint)) or ((UDFToDouble(cint) >= cdouble) and (UDFToInteger(ctinyint) <= cint)))) (type: boolean) Statistics: Num rows: 2503 Data size: 76841 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: csmallint (type: smallint), cbigint (type: bigint), ctinyint (type: tinyint) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 2503 Data size: 76841 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: stddev_samp(_col0), sum(_col1), var_pop(_col2), count() keys: _col0 (type: smallint) mode: hash outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 2503 Data size: 76841 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: smallint) sort order: + Map-reduce partition columns: _col0 (type: smallint) Statistics: Num rows: 2503 Data size: 76841 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: struct), _col2 (type: bigint), _col3 (type: struct), _col4 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: stddev_samp(VALUE._col0), sum(VALUE._col1), var_pop(VALUE._col2), count(VALUE._col3) keys: KEY._col0 (type: smallint) mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 1251 Data size: 38405 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: smallint), (UDFToInteger(_col0) % -75) (type: int), _col1 (type: double), (-1.389 / UDFToDouble(_col0)) (type: double), _col2 (type: bigint), (UDFToDouble((UDFToInteger(_col0) % -75)) / UDFToDouble(_col2)) (type: double), (- (UDFToInteger(_col0) % -75)) (type: int), _col3 (type: double), (- (- (UDFToInteger(_col0) % -75))) (type: int), _col4 (type: bigint), (_col4 - -89010) (type: bigint) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Statistics: Num rows: 1251 Data size: 38405 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe Stage: Stage-2 Map Reduce Map Operator Tree: TableScan Reduce Output Operator key expressions: _col0 (type: smallint) sort order: + Statistics: Num rows: 1251 Data size: 38405 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: int), _col2 (type: double), _col3 (type: double), _col4 (type: bigint), _col5 (type: double), _col6 (type: int), _col7 (type: double), _col8 (type: int), _col9 (type: bigint), _col10 (type: bigint) Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: smallint), VALUE._col0 (type: int), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: int), VALUE._col6 (type: double), VALUE._col7 (type: int), VALUE._col8 (type: bigint), VALUE._col9 (type: bigint) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Statistics: Num rows: 1251 Data size: 38405 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 20 Statistics: Num rows: 20 Data size: 600 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 20 Data size: 600 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: 20 Processor Tree: ListSink PREHOOK: query: SELECT csmallint, (csmallint % -75), STDDEV_SAMP(csmallint), (-1.389 / csmallint), SUM(cbigint), ((csmallint % -75) / SUM(cbigint)), (-((csmallint % -75))), VAR_POP(ctinyint), (-((-((csmallint % -75))))), COUNT(*), (COUNT(*) - -89010) FROM alltypesorc WHERE (((csmallint >= -257)) AND ((-6432 = csmallint) OR ((cint >= cdouble) AND (ctinyint <= cint)))) GROUP BY csmallint ORDER BY csmallint LIMIT 20 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc #### A masked pattern was here #### POSTHOOK: query: SELECT csmallint, (csmallint % -75), STDDEV_SAMP(csmallint), (-1.389 / csmallint), SUM(cbigint), ((csmallint % -75) / SUM(cbigint)), (-((csmallint % -75))), VAR_POP(ctinyint), (-((-((csmallint % -75))))), COUNT(*), (COUNT(*) - -89010) FROM alltypesorc WHERE (((csmallint >= -257)) AND ((-6432 = csmallint) OR ((cint >= cdouble) AND (ctinyint <= cint)))) GROUP BY csmallint ORDER BY csmallint LIMIT 20 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -257 -32 0.0 0.005404669260700389 NULL NULL 32 0.0 -32 2 89012 -220 -70 0.0 0.006313636363636363 NULL NULL 70 0.0 -70 1 89011 -217 -67 0.0 0.006400921658986175 NULL NULL 67 0.0 -67 1 89011 -203 -53 0.0 0.006842364532019704 NULL NULL 53 0.0 -53 1 89011 -180 -30 0.0 0.007716666666666667 NULL NULL 30 0.0 -30 1 89011 -171 -21 0.0 0.00812280701754386 NULL NULL 21 0.0 -21 1 89011 -168 -18 0.0 0.008267857142857143 NULL NULL 18 0.0 -18 1 89011 -165 -15 0.0 0.008418181818181818 NULL NULL 15 0.0 -15 1 89011 -118 -43 0.0 0.011771186440677966 NULL NULL 43 0.0 -43 1 89011 -113 -38 0.0 0.01229203539823009 NULL NULL 38 0.0 -38 1 89011 -100 -25 0.0 0.01389 NULL NULL 25 0.0 -25 1 89011 -95 -20 0.0 0.014621052631578948 NULL NULL 20 0.0 -20 1 89011 -89 -14 0.0 0.015606741573033708 NULL NULL 14 0.0 -14 1 89011 -84 -9 0.0 0.016535714285714286 NULL NULL 9 0.0 -9 1 89011 -77 -2 0.0 0.01803896103896104 NULL NULL 2 0.0 -2 1 89011 -75 0 0.0 0.018520000000000002 NULL NULL 0 107.55555555555556 0 3 89013 -62 -62 0.0 0.022403225806451613 NULL NULL 62 0.0 -62 1 89011 -49 -49 0.0 0.028346938775510203 NULL NULL 49 0.0 -49 1 89011 -42 -42 0.0 0.03307142857142857 NULL NULL 42 0.0 -42 1 89011 -29 -29 0.0 0.04789655172413793 NULL NULL 29 0.0 -29 1 89011 WARNING: Comparing a bigint and a double may result in a loss of precision. WARNING: Comparing a bigint and a double may result in a loss of precision. PREHOOK: query: -- TargetTypeClasses: Long, Double, Timestamp -- Functions: Var, Count, Sum, VarP, StDevP -- ArithmeticOps: Multiply, Add, Subtract, Remainder -- FilterOps: GreaterThan, LessThan, Equal, LessThanOrEqual, GreaterThanOrEqual -- GroupBy: GroupBy EXPLAIN SELECT cdouble, VAR_SAMP(cdouble), (2563.58 * VAR_SAMP(cdouble)), (-(VAR_SAMP(cdouble))), COUNT(cfloat), ((2563.58 * VAR_SAMP(cdouble)) + -5638.15), ((-(VAR_SAMP(cdouble))) * ((2563.58 * VAR_SAMP(cdouble)) + -5638.15)), SUM(cfloat), VAR_POP(cdouble), (cdouble - (-(VAR_SAMP(cdouble)))), STDDEV_POP(cdouble), (cdouble + VAR_SAMP(cdouble)), (cdouble * 762), SUM(cdouble), (-863.257 % (cdouble * 762)), SUM(cdouble) FROM alltypesorc WHERE (((cdouble > 2563.58)) AND (((cbigint >= cint) AND ((csmallint < cint) AND (cfloat < -5638.15))) OR (2563.58 = ctinyint) OR ((cdouble <= cbigint) AND (-5638.15 > cbigint)))) GROUP BY cdouble ORDER BY cdouble PREHOOK: type: QUERY POSTHOOK: query: -- TargetTypeClasses: Long, Double, Timestamp -- Functions: Var, Count, Sum, VarP, StDevP -- ArithmeticOps: Multiply, Add, Subtract, Remainder -- FilterOps: GreaterThan, LessThan, Equal, LessThanOrEqual, GreaterThanOrEqual -- GroupBy: GroupBy EXPLAIN SELECT cdouble, VAR_SAMP(cdouble), (2563.58 * VAR_SAMP(cdouble)), (-(VAR_SAMP(cdouble))), COUNT(cfloat), ((2563.58 * VAR_SAMP(cdouble)) + -5638.15), ((-(VAR_SAMP(cdouble))) * ((2563.58 * VAR_SAMP(cdouble)) + -5638.15)), SUM(cfloat), VAR_POP(cdouble), (cdouble - (-(VAR_SAMP(cdouble)))), STDDEV_POP(cdouble), (cdouble + VAR_SAMP(cdouble)), (cdouble * 762), SUM(cdouble), (-863.257 % (cdouble * 762)), SUM(cdouble) FROM alltypesorc WHERE (((cdouble > 2563.58)) AND (((cbigint >= cint) AND ((csmallint < cint) AND (cfloat < -5638.15))) OR (2563.58 = ctinyint) OR ((cdouble <= cbigint) AND (-5638.15 > cbigint)))) GROUP BY cdouble ORDER BY cdouble POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 Stage-0 depends on stages: Stage-2 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((cdouble > 2563.58) and (((cbigint >= UDFToLong(cint)) and ((UDFToInteger(csmallint) < cint) and (UDFToDouble(cfloat) < -5638.15))) or ((cdouble <= UDFToDouble(cbigint)) and (-5638.15 > UDFToDouble(cbigint))))) (type: boolean) Statistics: Num rows: 606 Data size: 18603 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cdouble (type: double), cfloat (type: float) outputColumnNames: _col0, _col1 Statistics: Num rows: 606 Data size: 18603 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: var_samp(_col0), count(_col1), sum(_col1), var_pop(_col0), stddev_pop(_col0), sum(_col0) keys: _col0 (type: double) mode: hash outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 606 Data size: 18603 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: double) sort order: + Map-reduce partition columns: _col0 (type: double) Statistics: Num rows: 606 Data size: 18603 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: struct), _col2 (type: bigint), _col3 (type: double), _col4 (type: struct), _col5 (type: struct), _col6 (type: double) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: var_samp(VALUE._col0), count(VALUE._col1), sum(VALUE._col2), var_pop(VALUE._col3), stddev_pop(VALUE._col4), sum(VALUE._col5) keys: KEY._col0 (type: double) mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 303 Data size: 9301 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: double), _col1 (type: double), _col5 (type: double), (_col0 + _col1) (type: double), (_col0 * 762.0) (type: double), _col6 (type: double), (-863.257 % (_col0 * 762.0)) (type: double), (2563.58 * _col1) (type: double), (- _col1) (type: double), _col2 (type: bigint), ((2563.58 * _col1) + -5638.15) (type: double), ((- _col1) * ((2563.58 * _col1) + -5638.15)) (type: double), _col3 (type: double), _col4 (type: double), (_col0 - (- _col1)) (type: double) outputColumnNames: _col0, _col1, _col10, _col11, _col12, _col13, _col14, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9 Statistics: Num rows: 303 Data size: 9301 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe Stage: Stage-2 Map Reduce Map Operator Tree: TableScan Reduce Output Operator key expressions: _col0 (type: double) sort order: + Statistics: Num rows: 303 Data size: 9301 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: double), _col2 (type: double), _col3 (type: double), _col4 (type: bigint), _col5 (type: double), _col6 (type: double), _col7 (type: double), _col8 (type: double), _col9 (type: double), _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type: double) Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: double), VALUE._col0 (type: double), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: double), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: double), VALUE._col9 (type: double), VALUE._col10 (type: double), VALUE._col11 (type: double), VALUE._col12 (type: double), VALUE._col13 (type: double), VALUE._col12 (type: double) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15 Statistics: Num rows: 303 Data size: 9301 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 303 Data size: 9301 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. WARNING: Comparing a bigint and a double may result in a loss of precision. PREHOOK: query: SELECT cdouble, VAR_SAMP(cdouble), (2563.58 * VAR_SAMP(cdouble)), (-(VAR_SAMP(cdouble))), COUNT(cfloat), ((2563.58 * VAR_SAMP(cdouble)) + -5638.15), ((-(VAR_SAMP(cdouble))) * ((2563.58 * VAR_SAMP(cdouble)) + -5638.15)), SUM(cfloat), VAR_POP(cdouble), (cdouble - (-(VAR_SAMP(cdouble)))), STDDEV_POP(cdouble), (cdouble + VAR_SAMP(cdouble)), (cdouble * 762), SUM(cdouble), (-863.257 % (cdouble * 762)), SUM(cdouble) FROM alltypesorc WHERE (((cdouble > 2563.58)) AND (((cbigint >= cint) AND ((csmallint < cint) AND (cfloat < -5638.15))) OR (2563.58 = ctinyint) OR ((cdouble <= cbigint) AND (-5638.15 > cbigint)))) GROUP BY cdouble ORDER BY cdouble PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc #### A masked pattern was here #### POSTHOOK: query: SELECT cdouble, VAR_SAMP(cdouble), (2563.58 * VAR_SAMP(cdouble)), (-(VAR_SAMP(cdouble))), COUNT(cfloat), ((2563.58 * VAR_SAMP(cdouble)) + -5638.15), ((-(VAR_SAMP(cdouble))) * ((2563.58 * VAR_SAMP(cdouble)) + -5638.15)), SUM(cfloat), VAR_POP(cdouble), (cdouble - (-(VAR_SAMP(cdouble)))), STDDEV_POP(cdouble), (cdouble + VAR_SAMP(cdouble)), (cdouble * 762), SUM(cdouble), (-863.257 % (cdouble * 762)), SUM(cdouble) FROM alltypesorc WHERE (((cdouble > 2563.58)) AND (((cbigint >= cint) AND ((csmallint < cint) AND (cfloat < -5638.15))) OR (2563.58 = ctinyint) OR ((cdouble <= cbigint) AND (-5638.15 > cbigint)))) GROUP BY cdouble ORDER BY cdouble POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### PREHOOK: query: -- TargetTypeClasses: Bool, Timestamp, String, Double, Long -- Functions: StDevP, Avg, Count, Min, Var, VarP, Sum -- ArithmeticOps: Multiply, Subtract, Add, Divide, Remainder -- FilterOps: NotEqual, LessThan, Like, Equal, RLike -- GroupBy: GroupBy EXPLAIN SELECT ctimestamp1, cstring1, STDDEV_POP(cint), (STDDEV_POP(cint) * 10.175), (-(STDDEV_POP(cint))), AVG(csmallint), (-(STDDEV_POP(cint))), (-26.28 - STDDEV_POP(cint)), COUNT(*), (-(COUNT(*))), ((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))), MIN(ctinyint), (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*)))), (-((STDDEV_POP(cint) * 10.175))), VAR_SAMP(csmallint), (VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))), (-((-(STDDEV_POP(cint))))), ((-(COUNT(*))) / STDDEV_POP(cint)), VAR_POP(cfloat), (10.175 / AVG(csmallint)), AVG(cint), VAR_SAMP(cfloat), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) - (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))), (-((-((STDDEV_POP(cint) * 10.175))))), AVG(cfloat), (((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) - (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) * 10.175), (10.175 % (10.175 / AVG(csmallint))), (-(MIN(ctinyint))), MIN(cdouble), VAR_POP(csmallint), (-(((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))))), ((-(STDDEV_POP(cint))) % AVG(cfloat)), (-26.28 / (-(MIN(ctinyint)))), STDDEV_POP(ctinyint), SUM(cint), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) / VAR_POP(cfloat)), (-((-(COUNT(*))))), COUNT(*), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) % -26.28) FROM alltypesorc WHERE (((ctimestamp1 != 0)) AND ((((-257 != ctinyint) AND (cboolean2 IS NOT NULL)) AND ((cstring1 RLIKE '.*ss') AND (-3 < ctimestamp1))) OR (ctimestamp2 = -5) OR ((ctimestamp1 < 0) AND (cstring2 LIKE '%b%')) OR (cdouble = cint) OR ((cboolean1 IS NULL) AND (cfloat < cint)))) GROUP BY ctimestamp1, cstring1 ORDER BY ctimestamp1, cstring1 LIMIT 50 PREHOOK: type: QUERY POSTHOOK: query: -- TargetTypeClasses: Bool, Timestamp, String, Double, Long -- Functions: StDevP, Avg, Count, Min, Var, VarP, Sum -- ArithmeticOps: Multiply, Subtract, Add, Divide, Remainder -- FilterOps: NotEqual, LessThan, Like, Equal, RLike -- GroupBy: GroupBy EXPLAIN SELECT ctimestamp1, cstring1, STDDEV_POP(cint), (STDDEV_POP(cint) * 10.175), (-(STDDEV_POP(cint))), AVG(csmallint), (-(STDDEV_POP(cint))), (-26.28 - STDDEV_POP(cint)), COUNT(*), (-(COUNT(*))), ((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))), MIN(ctinyint), (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*)))), (-((STDDEV_POP(cint) * 10.175))), VAR_SAMP(csmallint), (VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))), (-((-(STDDEV_POP(cint))))), ((-(COUNT(*))) / STDDEV_POP(cint)), VAR_POP(cfloat), (10.175 / AVG(csmallint)), AVG(cint), VAR_SAMP(cfloat), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) - (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))), (-((-((STDDEV_POP(cint) * 10.175))))), AVG(cfloat), (((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) - (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) * 10.175), (10.175 % (10.175 / AVG(csmallint))), (-(MIN(ctinyint))), MIN(cdouble), VAR_POP(csmallint), (-(((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))))), ((-(STDDEV_POP(cint))) % AVG(cfloat)), (-26.28 / (-(MIN(ctinyint)))), STDDEV_POP(ctinyint), SUM(cint), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) / VAR_POP(cfloat)), (-((-(COUNT(*))))), COUNT(*), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) % -26.28) FROM alltypesorc WHERE (((ctimestamp1 != 0)) AND ((((-257 != ctinyint) AND (cboolean2 IS NOT NULL)) AND ((cstring1 RLIKE '.*ss') AND (-3 < ctimestamp1))) OR (ctimestamp2 = -5) OR ((ctimestamp1 < 0) AND (cstring2 LIKE '%b%')) OR (cdouble = cint) OR ((cboolean1 IS NULL) AND (cfloat < cint)))) GROUP BY ctimestamp1, cstring1 ORDER BY ctimestamp1, cstring1 LIMIT 50 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 Stage-0 depends on stages: Stage-2 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((UDFToDouble(ctimestamp1) <> 0.0) and (((-257 <> UDFToInteger(ctinyint)) and (cboolean2 is not null and ((cstring1 rlike '.*ss') and (-3.0 < UDFToDouble(ctimestamp1))))) or ((UDFToDouble(ctimestamp2) = -5.0) or (((UDFToDouble(ctimestamp1) < 0.0) and (cstring2 like '%b%')) or ((cdouble = UDFToDouble(cint)) or (cboolean1 is null and (cfloat < UDFToFloat(cint)))))))) (type: boolean) Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctimestamp1 (type: timestamp), cstring1 (type: string), cint (type: int), csmallint (type: smallint), ctinyint (type: tinyint), cfloat (type: float), cdouble (type: double) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: stddev_pop(_col2), avg(_col3), count(), min(_col4), var_samp(_col3), var_pop(_col5), avg(_col2), var_samp(_col5), avg(_col5), min(_col6), var_pop(_col3), stddev_pop(_col4), sum(_col2) keys: _col0 (type: timestamp), _col1 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14 Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: timestamp), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: timestamp), _col1 (type: string) Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE value expressions: _col2 (type: struct), _col3 (type: struct), _col4 (type: bigint), _col5 (type: tinyint), _col6 (type: struct), _col7 (type: struct), _col8 (type: struct), _col9 (type: struct), _col10 (type: struct), _col11 (type: double), _col12 (type: struct), _col13 (type: struct), _col14 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: stddev_pop(VALUE._col0), avg(VALUE._col1), count(VALUE._col2), min(VALUE._col3), var_samp(VALUE._col4), var_pop(VALUE._col5), avg(VALUE._col6), var_samp(VALUE._col7), avg(VALUE._col8), min(VALUE._col9), var_pop(VALUE._col10), stddev_pop(VALUE._col11), sum(VALUE._col12) keys: KEY._col0 (type: timestamp), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14 Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: timestamp), _col1 (type: string), ((-26.28 - _col2) * (- _col2)) (type: double), _col5 (type: tinyint), (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4))) (type: double), (- (_col2 * 10.175)) (type: double), _col6 (type: double), (_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) (type: double), (- (- _col2)) (type: double), (UDFToDouble((- _col4)) / _col2) (type: double), _col7 (type: double), (10.175 / _col3) (type: double), _col2 (type: double), _col8 (type: double), _col9 (type: double), ((_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) - (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) (type: double), (- (- (_col2 * 10.175))) (type: double), _col10 (type: double), (((_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) - (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) * 10.175) (type: double), (10.175 % (10.175 / _col3)) (type: double), (- _col5) (type: tinyint), _col11 (type: double), _col12 (type: double), (_col2 * 10.175) (type: double), (- ((-26.28 - _col2) * (- _col2))) (type: double), ((- _col2) % _col10) (type: double), (-26.28 / UDFToDouble((- _col5))) (type: double), _col13 (type: double), _col14 (type: bigint), ((_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) / _col7) (type: double), (- (- _col4)) (type: bigint), ((_col6 + (((-26.28 - _col2) * (- _col2)) * UDFToDouble((- _col4)))) % -26.28) (type: double), (- _col2) (type: double), _col3 (type: double), (-26.28 - _col2) (type: double), _col4 (type: bigint), (- _col4) (type: bigint) outputColumnNames: _col0, _col1, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col2, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col3, _col30, _col31, _col32, _col33, _col34, _col35, _col36, _col38, _col4, _col5, _col7, _col8, _col9 Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe Stage: Stage-2 Map Reduce Map Operator Tree: TableScan Reduce Output Operator key expressions: _col0 (type: timestamp), _col1 (type: string) sort order: ++ Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE value expressions: _col2 (type: double), _col3 (type: double), _col4 (type: double), _col5 (type: double), _col7 (type: double), _col8 (type: bigint), _col9 (type: bigint), _col10 (type: double), _col11 (type: tinyint), _col12 (type: double), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col19 (type: double), _col20 (type: double), _col21 (type: double), _col22 (type: double), _col23 (type: double), _col24 (type: double), _col25 (type: double), _col26 (type: double), _col27 (type: tinyint), _col28 (type: double), _col29 (type: double), _col30 (type: double), _col31 (type: double), _col32 (type: double), _col33 (type: double), _col34 (type: bigint), _col35 (type: double), _col36 (type: bigint), _col38 (type: double) Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: timestamp), KEY.reducesinkkey1 (type: string), VALUE._col0 (type: double), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: double), VALUE._col2 (type: double), VALUE._col4 (type: double), VALUE._col5 (type: bigint), VALUE._col6 (type: bigint), VALUE._col7 (type: double), VALUE._col8 (type: tinyint), VALUE._col9 (type: double), VALUE._col10 (type: double), VALUE._col11 (type: double), VALUE._col12 (type: double), VALUE._col13 (type: double), VALUE._col14 (type: double), VALUE._col15 (type: double), VALUE._col16 (type: double), VALUE._col17 (type: double), VALUE._col18 (type: double), VALUE._col19 (type: double), VALUE._col20 (type: double), VALUE._col21 (type: double), VALUE._col22 (type: double), VALUE._col23 (type: double), VALUE._col24 (type: tinyint), VALUE._col25 (type: double), VALUE._col26 (type: double), VALUE._col27 (type: double), VALUE._col28 (type: double), VALUE._col29 (type: double), VALUE._col30 (type: double), VALUE._col31 (type: bigint), VALUE._col32 (type: double), VALUE._col33 (type: bigint), VALUE._col5 (type: bigint), VALUE._col34 (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, _col25, _col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33, _col34, _col35, _col36, _col37, _col38 Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 50 Statistics: Num rows: 50 Data size: 1500 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 50 Data size: 1500 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: 50 Processor Tree: ListSink PREHOOK: query: SELECT ctimestamp1, cstring1, STDDEV_POP(cint), (STDDEV_POP(cint) * 10.175), (-(STDDEV_POP(cint))), AVG(csmallint), (-(STDDEV_POP(cint))), (-26.28 - STDDEV_POP(cint)), COUNT(*), (-(COUNT(*))), ((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))), MIN(ctinyint), (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*)))), (-((STDDEV_POP(cint) * 10.175))), VAR_SAMP(csmallint), (VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))), (-((-(STDDEV_POP(cint))))), ((-(COUNT(*))) / STDDEV_POP(cint)), VAR_POP(cfloat), (10.175 / AVG(csmallint)), AVG(cint), VAR_SAMP(cfloat), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) - (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))), (-((-((STDDEV_POP(cint) * 10.175))))), AVG(cfloat), (((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) - (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) * 10.175), (10.175 % (10.175 / AVG(csmallint))), (-(MIN(ctinyint))), MIN(cdouble), VAR_POP(csmallint), (-(((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))))), ((-(STDDEV_POP(cint))) % AVG(cfloat)), (-26.28 / (-(MIN(ctinyint)))), STDDEV_POP(ctinyint), SUM(cint), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) / VAR_POP(cfloat)), (-((-(COUNT(*))))), COUNT(*), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) % -26.28) FROM alltypesorc WHERE (((ctimestamp1 != 0)) AND ((((-257 != ctinyint) AND (cboolean2 IS NOT NULL)) AND ((cstring1 RLIKE '.*ss') AND (-3 < ctimestamp1))) OR (ctimestamp2 = -5) OR ((ctimestamp1 < 0) AND (cstring2 LIKE '%b%')) OR (cdouble = cint) OR ((cboolean1 IS NULL) AND (cfloat < cint)))) GROUP BY ctimestamp1, cstring1 ORDER BY ctimestamp1, cstring1 LIMIT 50 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc #### A masked pattern was here #### POSTHOOK: query: SELECT ctimestamp1, cstring1, STDDEV_POP(cint), (STDDEV_POP(cint) * 10.175), (-(STDDEV_POP(cint))), AVG(csmallint), (-(STDDEV_POP(cint))), (-26.28 - STDDEV_POP(cint)), COUNT(*), (-(COUNT(*))), ((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))), MIN(ctinyint), (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*)))), (-((STDDEV_POP(cint) * 10.175))), VAR_SAMP(csmallint), (VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))), (-((-(STDDEV_POP(cint))))), ((-(COUNT(*))) / STDDEV_POP(cint)), VAR_POP(cfloat), (10.175 / AVG(csmallint)), AVG(cint), VAR_SAMP(cfloat), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) - (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))), (-((-((STDDEV_POP(cint) * 10.175))))), AVG(cfloat), (((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) - (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) * 10.175), (10.175 % (10.175 / AVG(csmallint))), (-(MIN(ctinyint))), MIN(cdouble), VAR_POP(csmallint), (-(((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))))), ((-(STDDEV_POP(cint))) % AVG(cfloat)), (-26.28 / (-(MIN(ctinyint)))), STDDEV_POP(ctinyint), SUM(cint), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) / VAR_POP(cfloat)), (-((-(COUNT(*))))), COUNT(*), ((VAR_SAMP(csmallint) + (((-26.28 - STDDEV_POP(cint)) * (-(STDDEV_POP(cint)))) * (-(COUNT(*))))) % -26.28) FROM alltypesorc WHERE (((ctimestamp1 != 0)) AND ((((-257 != ctinyint) AND (cboolean2 IS NOT NULL)) AND ((cstring1 RLIKE '.*ss') AND (-3 < ctimestamp1))) OR (ctimestamp2 = -5) OR ((ctimestamp1 < 0) AND (cstring2 LIKE '%b%')) OR (cdouble = cint) OR ((cboolean1 IS NULL) AND (cfloat < cint)))) GROUP BY ctimestamp1, cstring1 ORDER BY ctimestamp1, cstring1 LIMIT 50 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### 1969-12-31 15:59:43.773 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -24 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -24.0 NULL 0.0 24 -200.0 0.0 NULL NULL -1.095 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:43.783 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -11 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -11.0 NULL 0.0 11 -200.0 0.0 NULL NULL -2.389090909090909 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:43.874 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL -8 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL -8.0 NULL 0.001413979988882123 8 -7196.0 0.0 NULL NULL -3.285 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:43.904 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 7 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 7.0 NULL 0.0 -7 -200.0 0.0 NULL NULL 3.7542857142857144 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:43.919 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL -21 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL -21.0 NULL 6.522017819364598E-4 21 15601.0 0.0 NULL NULL -1.2514285714285716 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:43.995 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 31 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 31.0 NULL 0.001413979988882123 -31 -7196.0 0.0 NULL NULL 0.847741935483871 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.07 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL -9 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL -9.0 NULL 6.522017819364598E-4 9 15601.0 0.0 NULL NULL -2.92 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.081 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 61 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 61.0 NULL 0.001413979988882123 -61 -7196.0 0.0 NULL NULL 0.4308196721311476 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.179 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL 34 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL 34.0 NULL 6.522017819364598E-4 -34 15601.0 0.0 NULL NULL 0.7729411764705882 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.286 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 16 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 16.0 NULL 0.001413979988882123 -16 -7196.0 0.0 NULL NULL 1.6425 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.291 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -32 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -32.0 NULL 0.0 32 -200.0 0.0 NULL NULL -0.82125 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.394 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL 31 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL 31.0 NULL 6.522017819364598E-4 -31 15601.0 0.0 NULL NULL 0.847741935483871 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.448 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 22 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 22.0 NULL 0.0 -22 -200.0 0.0 NULL NULL 1.1945454545454546 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.455 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL -25 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL -25.0 NULL 0.001413979988882123 25 -7196.0 0.0 NULL NULL -1.0512000000000001 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.477 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL -42 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL -42.0 NULL 6.522017819364598E-4 42 15601.0 0.0 NULL NULL -0.6257142857142858 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.549 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 59 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 59.0 NULL 0.0 -59 -200.0 0.0 NULL NULL 0.44542372881355935 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.55 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 24 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 24.0 NULL 0.0 -24 -200.0 0.0 NULL NULL 1.095 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.559 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -34 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -34.0 NULL 0.0 34 -200.0 0.0 NULL NULL -0.7729411764705882 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.568 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL 22 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL 22.0 NULL 6.522017819364598E-4 -22 15601.0 0.0 NULL NULL 1.1945454545454546 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.571 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL -42 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL -42.0 NULL 6.522017819364598E-4 42 15601.0 0.0 NULL NULL -0.6257142857142858 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.646 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 54 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 54.0 NULL 0.001413979988882123 -54 -7196.0 0.0 NULL NULL 0.4866666666666667 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.708 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL -22 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL -22.0 NULL 6.522017819364598E-4 22 15601.0 0.0 NULL NULL -1.1945454545454546 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.782 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL 7 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL 7.0 NULL 6.522017819364598E-4 -7 15601.0 0.0 NULL NULL 3.7542857142857144 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:44.904 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 0 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 0.0 NULL 0.0 0 -200.0 0.0 NULL NULL NULL 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.137 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -32 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -32.0 NULL 0.0 32 -200.0 0.0 NULL NULL -0.82125 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.153 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 42 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 42.0 NULL 0.0 -42 -200.0 0.0 NULL NULL 0.6257142857142858 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.169 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -60 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -60.0 NULL 0.0 60 -200.0 0.0 NULL NULL -0.438 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.198 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 47 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 47.0 NULL 0.0 -47 -200.0 0.0 NULL NULL 0.5591489361702128 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.314 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 56 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 56.0 NULL 0.0 -56 -200.0 0.0 NULL NULL 0.4692857142857143 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.322 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -15 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -15.0 NULL 0.0 15 -200.0 0.0 NULL NULL -1.752 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.39 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -16 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -16.0 NULL 0.0 16 -200.0 0.0 NULL NULL -1.6425 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.427 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -7 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -7.0 NULL 0.0 7 -200.0 0.0 NULL NULL -3.7542857142857144 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.572 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 32 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 32.0 NULL 0.001413979988882123 -32 -7196.0 0.0 NULL NULL 0.82125 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.644 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -52 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -52.0 NULL 0.0 52 -200.0 0.0 NULL NULL -0.5053846153846154 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.764 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 54 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 54.0 NULL 0.001413979988882123 -54 -7196.0 0.0 NULL NULL 0.4866666666666667 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.816 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL 7 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL 7.0 NULL 6.522017819364598E-4 -7 15601.0 0.0 NULL NULL 3.7542857142857144 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.932 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL -51 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL -51.0 NULL 0.001413979988882123 51 -7196.0 0.0 NULL NULL -0.5152941176470588 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.947 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL -59 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL -59.0 NULL 0.001413979988882123 59 -7196.0 0.0 NULL NULL -0.44542372881355935 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:45.978 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL -52 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL -52.0 NULL 0.001413979988882123 52 -7196.0 0.0 NULL NULL -0.5053846153846154 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.015 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 25 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 25.0 NULL 0.001413979988882123 -25 -7196.0 0.0 NULL NULL 1.0512000000000001 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.022 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 19 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 19.0 NULL 0.0 -19 -200.0 0.0 NULL NULL 1.3831578947368421 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.114 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL -3 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL -3.0 NULL 6.522017819364598E-4 3 15601.0 0.0 NULL NULL -8.76 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.38 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 28 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 28.0 NULL 0.0 -28 -200.0 0.0 NULL NULL 0.9385714285714286 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.387 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 3 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 3.0 NULL 0.001413979988882123 -3 -7196.0 0.0 NULL NULL 8.76 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.52 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 8 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 8.0 NULL 0.0 -8 -200.0 0.0 NULL NULL 3.285 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.762 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 12 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 12.0 NULL 0.0 -12 -200.0 0.0 NULL NULL 2.19 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.775 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 4 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 4.0 NULL 0.001413979988882123 -4 -7196.0 0.0 NULL NULL 6.57 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.82 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL -46 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL -46.0 NULL 6.522017819364598E-4 46 15601.0 0.0 NULL NULL -0.571304347826087 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.847 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL -26 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL -26.0 NULL 0.001413979988882123 26 -7196.0 0.0 NULL NULL -1.0107692307692309 0.0 NULL NULL 1 1 NULL 1969-12-31 15:59:46.915 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -25 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -25.0 NULL 0.0 25 -200.0 0.0 NULL NULL -1.0512000000000001 0.0 NULL NULL 1 1 NULL WARNING: Comparing a bigint and a double may result in a loss of precision. PREHOOK: query: -- TargetTypeClasses: Double, Long, String, Timestamp, Bool -- Functions: Max, Sum, Var, Avg, Min, VarP, StDev, StDevP -- ArithmeticOps: Divide, Subtract, Remainder, Add, Multiply -- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like, RLike -- GroupBy: GroupBy EXPLAIN SELECT cboolean1, MAX(cfloat), (-(MAX(cfloat))), (-26.28 / MAX(cfloat)), SUM(cbigint), (SUM(cbigint) - 10.175), VAR_SAMP(cint), (VAR_SAMP(cint) % MAX(cfloat)), (10.175 + (-(MAX(cfloat)))), AVG(cdouble), ((SUM(cbigint) - 10.175) + VAR_SAMP(cint)), MIN(cbigint), VAR_POP(cbigint), (-((10.175 + (-(MAX(cfloat)))))), (79.553 / VAR_POP(cbigint)), (VAR_SAMP(cint) % (79.553 / VAR_POP(cbigint))), (-((10.175 + (-(MAX(cfloat)))))), SUM(cint), STDDEV_SAMP(ctinyint), (-1.389 * MIN(cbigint)), (SUM(cint) - (-1.389 * MIN(cbigint))), STDDEV_POP(csmallint), (-((SUM(cint) - (-1.389 * MIN(cbigint))))), AVG(cint), (-(AVG(cint))), (AVG(cint) * SUM(cint)) FROM alltypesorc WHERE (((cboolean1 IS NOT NULL)) AND (((cdouble < csmallint) AND ((cboolean2 = cboolean1) AND (cbigint <= -863.257))) OR ((cint >= -257) AND ((cstring1 IS NOT NULL) AND (cboolean1 >= 1))) OR (cstring2 RLIKE 'b') OR ((csmallint >= ctinyint) AND (ctimestamp2 IS NULL)))) GROUP BY cboolean1 ORDER BY cboolean1 PREHOOK: type: QUERY POSTHOOK: query: -- TargetTypeClasses: Double, Long, String, Timestamp, Bool -- Functions: Max, Sum, Var, Avg, Min, VarP, StDev, StDevP -- ArithmeticOps: Divide, Subtract, Remainder, Add, Multiply -- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like, RLike -- GroupBy: GroupBy EXPLAIN SELECT cboolean1, MAX(cfloat), (-(MAX(cfloat))), (-26.28 / MAX(cfloat)), SUM(cbigint), (SUM(cbigint) - 10.175), VAR_SAMP(cint), (VAR_SAMP(cint) % MAX(cfloat)), (10.175 + (-(MAX(cfloat)))), AVG(cdouble), ((SUM(cbigint) - 10.175) + VAR_SAMP(cint)), MIN(cbigint), VAR_POP(cbigint), (-((10.175 + (-(MAX(cfloat)))))), (79.553 / VAR_POP(cbigint)), (VAR_SAMP(cint) % (79.553 / VAR_POP(cbigint))), (-((10.175 + (-(MAX(cfloat)))))), SUM(cint), STDDEV_SAMP(ctinyint), (-1.389 * MIN(cbigint)), (SUM(cint) - (-1.389 * MIN(cbigint))), STDDEV_POP(csmallint), (-((SUM(cint) - (-1.389 * MIN(cbigint))))), AVG(cint), (-(AVG(cint))), (AVG(cint) * SUM(cint)) FROM alltypesorc WHERE (((cboolean1 IS NOT NULL)) AND (((cdouble < csmallint) AND ((cboolean2 = cboolean1) AND (cbigint <= -863.257))) OR ((cint >= -257) AND ((cstring1 IS NOT NULL) AND (cboolean1 >= 1))) OR (cstring2 RLIKE 'b') OR ((csmallint >= ctinyint) AND (ctimestamp2 IS NULL)))) GROUP BY cboolean1 ORDER BY cboolean1 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 Stage-0 depends on stages: Stage-2 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cboolean1 is not null and (((cdouble < UDFToDouble(csmallint)) and ((cboolean2 = cboolean1) and (UDFToDouble(cbigint) <= -863.257))) or (((cint >= -257) and (cstring1 is not null and (cboolean1 >= 1))) or ((cstring2 rlike 'b') or ((csmallint >= UDFToShort(ctinyint)) and ctimestamp2 is null))))) (type: boolean) Statistics: Num rows: 4778 Data size: 146682 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cboolean1 (type: boolean), cfloat (type: float), cbigint (type: bigint), cint (type: int), cdouble (type: double), ctinyint (type: tinyint), csmallint (type: smallint) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 4778 Data size: 146682 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: max(_col1), sum(_col2), var_samp(_col3), avg(_col4), min(_col2), var_pop(_col2), sum(_col3), stddev_samp(_col5), stddev_pop(_col6), avg(_col3) keys: _col0 (type: boolean) mode: hash outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Statistics: Num rows: 4778 Data size: 146682 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: boolean) sort order: + Map-reduce partition columns: _col0 (type: boolean) Statistics: Num rows: 4778 Data size: 146682 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: float), _col2 (type: bigint), _col3 (type: struct), _col4 (type: struct), _col5 (type: bigint), _col6 (type: struct), _col7 (type: bigint), _col8 (type: struct), _col9 (type: struct), _col10 (type: struct) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: max(VALUE._col0), sum(VALUE._col1), var_samp(VALUE._col2), avg(VALUE._col3), min(VALUE._col4), var_pop(VALUE._col5), sum(VALUE._col6), stddev_samp(VALUE._col7), stddev_pop(VALUE._col8), avg(VALUE._col9) keys: KEY._col0 (type: boolean) mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Statistics: Num rows: 2389 Data size: 73341 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: boolean), _col1 (type: float), ((UDFToDouble(_col2) - 10.175) + _col3) (type: double), _col5 (type: bigint), _col6 (type: double), (- (10.175 + UDFToDouble((- _col1)))) (type: double), (79.553 / _col6) (type: double), (_col3 % (79.553 / _col6)) (type: double), _col7 (type: bigint), _col8 (type: double), (-1.389 * UDFToDouble(_col5)) (type: double), (- _col1) (type: float), (UDFToDouble(_col7) - (-1.389 * UDFToDouble(_col5))) (type: double), _col9 (type: double), (- (UDFToDouble(_col7) - (-1.389 * UDFToDouble(_col5)))) (type: double), _col10 (type: double), (- _col10) (type: double), (_col10 * UDFToDouble(_col7)) (type: double), (-26.28 / UDFToDouble(_col1)) (type: double), _col2 (type: bigint), (UDFToDouble(_col2) - 10.175) (type: double), _col3 (type: double), (_col3 % UDFToDouble(_col1)) (type: double), (10.175 + UDFToDouble((- _col1))) (type: double), _col4 (type: double) outputColumnNames: _col0, _col1, _col10, _col11, _col12, _col13, _col14, _col15, _col17, _col18, _col19, _col2, _col20, _col21, _col22, _col23, _col24, _col25, _col3, _col4, _col5, _col6, _col7, _col8, _col9 Statistics: Num rows: 2389 Data size: 73341 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe Stage: Stage-2 Map Reduce Map Operator Tree: TableScan Reduce Output Operator key expressions: _col0 (type: boolean) sort order: + Statistics: Num rows: 2389 Data size: 73341 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: float), _col2 (type: float), _col3 (type: double), _col4 (type: bigint), _col5 (type: double), _col6 (type: double), _col7 (type: double), _col8 (type: double), _col9 (type: double), _col10 (type: double), _col11 (type: bigint), _col12 (type: double), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col17 (type: bigint), _col18 (type: double), _col19 (type: double), _col20 (type: double), _col21 (type: double), _col22 (type: double), _col23 (type: double), _col24 (type: double), _col25 (type: double) Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: boolean), VALUE._col0 (type: float), VALUE._col1 (type: float), VALUE._col2 (type: double), VALUE._col3 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: double), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: double), VALUE._col9 (type: double), VALUE._col10 (type: bigint), VALUE._col11 (type: double), VALUE._col12 (type: double), VALUE._col13 (type: double), VALUE._col14 (type: double), VALUE._col12 (type: double), VALUE._col15 (type: bigint), VALUE._col16 (type: double), VALUE._col17 (type: double), VALUE._col18 (type: double), VALUE._col19 (type: double), VALUE._col20 (type: double), VALUE._col21 (type: double), VALUE._col22 (type: double), VALUE._col23 (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, _col25 Statistics: Num rows: 2389 Data size: 73341 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 2389 Data size: 73341 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 cboolean1, MAX(cfloat), (-(MAX(cfloat))), (-26.28 / MAX(cfloat)), SUM(cbigint), (SUM(cbigint) - 10.175), VAR_SAMP(cint), (VAR_SAMP(cint) % MAX(cfloat)), (10.175 + (-(MAX(cfloat)))), AVG(cdouble), ((SUM(cbigint) - 10.175) + VAR_SAMP(cint)), MIN(cbigint), VAR_POP(cbigint), (-((10.175 + (-(MAX(cfloat)))))), (79.553 / VAR_POP(cbigint)), (VAR_SAMP(cint) % (79.553 / VAR_POP(cbigint))), (-((10.175 + (-(MAX(cfloat)))))), SUM(cint), STDDEV_SAMP(ctinyint), (-1.389 * MIN(cbigint)), (SUM(cint) - (-1.389 * MIN(cbigint))), STDDEV_POP(csmallint), (-((SUM(cint) - (-1.389 * MIN(cbigint))))), AVG(cint), (-(AVG(cint))), (AVG(cint) * SUM(cint)) FROM alltypesorc WHERE (((cboolean1 IS NOT NULL)) AND (((cdouble < csmallint) AND ((cboolean2 = cboolean1) AND (cbigint <= -863.257))) OR ((cint >= -257) AND ((cstring1 IS NOT NULL) AND (cboolean1 >= 1))) OR (cstring2 RLIKE 'b') OR ((csmallint >= ctinyint) AND (ctimestamp2 IS NULL)))) GROUP BY cboolean1 ORDER BY cboolean1 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc #### A masked pattern was here #### POSTHOOK: query: SELECT cboolean1, MAX(cfloat), (-(MAX(cfloat))), (-26.28 / MAX(cfloat)), SUM(cbigint), (SUM(cbigint) - 10.175), VAR_SAMP(cint), (VAR_SAMP(cint) % MAX(cfloat)), (10.175 + (-(MAX(cfloat)))), AVG(cdouble), ((SUM(cbigint) - 10.175) + VAR_SAMP(cint)), MIN(cbigint), VAR_POP(cbigint), (-((10.175 + (-(MAX(cfloat)))))), (79.553 / VAR_POP(cbigint)), (VAR_SAMP(cint) % (79.553 / VAR_POP(cbigint))), (-((10.175 + (-(MAX(cfloat)))))), SUM(cint), STDDEV_SAMP(ctinyint), (-1.389 * MIN(cbigint)), (SUM(cint) - (-1.389 * MIN(cbigint))), STDDEV_POP(csmallint), (-((SUM(cint) - (-1.389 * MIN(cbigint))))), AVG(cint), (-(AVG(cint))), (AVG(cint) * SUM(cint)) FROM alltypesorc WHERE (((cboolean1 IS NOT NULL)) AND (((cdouble < csmallint) AND ((cboolean2 = cboolean1) AND (cbigint <= -863.257))) OR ((cint >= -257) AND ((cstring1 IS NOT NULL) AND (cboolean1 >= 1))) OR (cstring2 RLIKE 'b') OR ((csmallint >= ctinyint) AND (ctimestamp2 IS NULL)))) GROUP BY cboolean1 ORDER BY cboolean1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### false 11.0 -11.0 -2.389090909090909 -17881597706 -1.7881597716175E10 3.8953387713327066E17 6.0 -0.8249999999999993 -2454.8879999999995 3.8953385925167296E17 -2145884705 1.66288903197104486E18 0.8249999999999993 4.7840233756130287E-17 4.098424268084119E-17 0.8249999999999993 -1051696618 28.692556844886422 2.980633855245E9 -4.032330473245E9 85.79562278396777 4.032330473245E9 -3983699.3106060605 3983699.3106060605 4.1896430920933255E15 true 79.553 -79.553 -0.33034580136836733 -401322621137 -4.01322621147175E11 7.9255373737244976E16 34.727455139160156 -69.3780014038086 4856.6352637899645 7.9254972414623824E16 -2130544867 2.30133924842409523E18 69.3780014038086 3.456813247089758E-17 2.0387240975807185E-18 69.3780014038086 2182477964777 34.654968050508266 2.959326820263E9 2.179518637956737E12 9461.197516216069 -2.179518637956737E12 4.592756659884259E8 -4.592756659884259E8 1.002359020778021E21 PREHOOK: query: -- These tests verify COUNT on empty or null colulmns work correctly. create table test_count(i int) stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@test_count POSTHOOK: query: -- These tests verify COUNT on empty or null colulmns work correctly. create table test_count(i int) stored as orc POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@test_count PREHOOK: query: explain select count(*) from test_count PREHOOK: type: QUERY POSTHOOK: query: explain select count(*) from test_count POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: test_count Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE Select Operator Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE Group By Operator aggregations: count() mode: hash outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col0 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: _col0 (type: bigint) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE 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 count(*) from test_count PREHOOK: type: QUERY PREHOOK: Input: default@test_count #### A masked pattern was here #### POSTHOOK: query: select count(*) from test_count POSTHOOK: type: QUERY POSTHOOK: Input: default@test_count #### A masked pattern was here #### 0 PREHOOK: query: explain select count(i) from test_count PREHOOK: type: QUERY POSTHOOK: query: explain select count(i) from test_count POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: test_count Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: i (type: int) outputColumnNames: _col0 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Group By Operator aggregations: count(_col0) mode: hash outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: bigint) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 8 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 count(i) from test_count PREHOOK: type: QUERY PREHOOK: Input: default@test_count #### A masked pattern was here #### POSTHOOK: query: select count(i) from test_count POSTHOOK: type: QUERY POSTHOOK: Input: default@test_count #### A masked pattern was here #### 0 PREHOOK: query: create table alltypesnull like alltypesorc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@alltypesnull POSTHOOK: query: create table alltypesnull like alltypesorc POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@alltypesnull PREHOOK: query: alter table alltypesnull set fileformat textfile PREHOOK: type: ALTERTABLE_FILEFORMAT PREHOOK: Input: default@alltypesnull PREHOOK: Output: default@alltypesnull POSTHOOK: query: alter table alltypesnull set fileformat textfile POSTHOOK: type: ALTERTABLE_FILEFORMAT POSTHOOK: Input: default@alltypesnull POSTHOOK: Output: default@alltypesnull PREHOOK: query: insert into table alltypesnull select null, null, null, null, null, null, null, null, null, null, null, null from alltypesorc PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@alltypesnull POSTHOOK: query: insert into table alltypesnull select null, null, null, null, null, null, null, null, null, null, null, null from alltypesorc POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@alltypesnull POSTHOOK: Lineage: alltypesnull.cbigint EXPRESSION [] POSTHOOK: Lineage: alltypesnull.cboolean1 EXPRESSION [] POSTHOOK: Lineage: alltypesnull.cboolean2 EXPRESSION [] POSTHOOK: Lineage: alltypesnull.cdouble EXPRESSION [] POSTHOOK: Lineage: alltypesnull.cfloat EXPRESSION [] POSTHOOK: Lineage: alltypesnull.cint EXPRESSION [] POSTHOOK: Lineage: alltypesnull.csmallint EXPRESSION [] POSTHOOK: Lineage: alltypesnull.cstring1 SIMPLE [] POSTHOOK: Lineage: alltypesnull.cstring2 SIMPLE [] POSTHOOK: Lineage: alltypesnull.ctimestamp1 EXPRESSION [] POSTHOOK: Lineage: alltypesnull.ctimestamp2 EXPRESSION [] POSTHOOK: Lineage: alltypesnull.ctinyint EXPRESSION [] PREHOOK: query: create table alltypesnullorc stored as orc as select * from alltypesnull PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@alltypesnull PREHOOK: Output: database:default PREHOOK: Output: default@alltypesnullorc POSTHOOK: query: create table alltypesnullorc stored as orc as select * from alltypesnull POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@alltypesnull POSTHOOK: Output: database:default POSTHOOK: Output: default@alltypesnullorc PREHOOK: query: explain select count(*) from alltypesnullorc PREHOOK: type: QUERY POSTHOOK: query: explain select count(*) from alltypesnullorc POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesnullorc Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: COMPLETE Select Operator Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count() mode: hash outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col0 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: _col0 (type: bigint) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE 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 count(*) from alltypesnullorc PREHOOK: type: QUERY PREHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### POSTHOOK: query: select count(*) from alltypesnullorc POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### 12288 PREHOOK: query: explain select count(ctinyint) from alltypesnullorc PREHOOK: type: QUERY POSTHOOK: query: explain select count(ctinyint) from alltypesnullorc POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesnullorc Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(_col0) mode: hash outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: bigint) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 8 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 count(ctinyint) from alltypesnullorc PREHOOK: type: QUERY PREHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### POSTHOOK: query: select count(ctinyint) from alltypesnullorc POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### 0 PREHOOK: query: explain select count(cint) from alltypesnullorc PREHOOK: type: QUERY POSTHOOK: query: explain select count(cint) from alltypesnullorc POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesnullorc Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int) outputColumnNames: _col0 Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(_col0) mode: hash outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: bigint) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 8 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 count(cint) from alltypesnullorc PREHOOK: type: QUERY PREHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### POSTHOOK: query: select count(cint) from alltypesnullorc POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### 0 PREHOOK: query: explain select count(cfloat) from alltypesnullorc PREHOOK: type: QUERY POSTHOOK: query: explain select count(cfloat) from alltypesnullorc POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesnullorc Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cfloat (type: float) outputColumnNames: _col0 Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(_col0) mode: hash outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: bigint) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 8 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 count(cfloat) from alltypesnullorc PREHOOK: type: QUERY PREHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### POSTHOOK: query: select count(cfloat) from alltypesnullorc POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### 0 PREHOOK: query: explain select count(cstring1) from alltypesnullorc PREHOOK: type: QUERY POSTHOOK: query: explain select count(cstring1) from alltypesnullorc POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesnullorc Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cstring1 (type: string) outputColumnNames: _col0 Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(_col0) mode: hash outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: bigint) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 8 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 count(cstring1) from alltypesnullorc PREHOOK: type: QUERY PREHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### POSTHOOK: query: select count(cstring1) from alltypesnullorc POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### 0 PREHOOK: query: explain select count(cboolean1) from alltypesnullorc PREHOOK: type: QUERY POSTHOOK: query: explain select count(cboolean1) from alltypesnullorc POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesnullorc Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cboolean1 (type: boolean) outputColumnNames: _col0 Statistics: Num rows: 12288 Data size: 168 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(_col0) mode: hash outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: bigint) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: bigint) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 8 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 count(cboolean1) from alltypesnullorc PREHOOK: type: QUERY PREHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### POSTHOOK: query: select count(cboolean1) from alltypesnullorc POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesnullorc #### A masked pattern was here #### 0