| PREHOOK: query: -- SORT_QUERY_RESULTS |
| |
| -- Use ORDER BY clauses to generate 2 stages. |
| EXPLAIN |
| SELECT MIN(ctinyint) as c1, |
| MAX(ctinyint), |
| COUNT(ctinyint), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: -- SORT_QUERY_RESULTS |
| |
| -- Use ORDER BY clauses to generate 2 stages. |
| EXPLAIN |
| SELECT MIN(ctinyint) as c1, |
| MAX(ctinyint), |
| COUNT(ctinyint), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: ctinyint (type: tinyint) |
| outputColumnNames: ctinyint |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: min(ctinyint), max(ctinyint), count(ctinyint), count() |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| 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: tinyint), _col1 (type: tinyint), _col2 (type: bigint), _col3 (type: bigint) |
| Execution mode: vectorized |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: min(VALUE._col0), max(VALUE._col1), count(VALUE._col2), count(VALUE._col3) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| Statistics: Num rows: 1 Data size: 24 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: tinyint) |
| sort order: + |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col1 (type: tinyint), _col2 (type: bigint), _col3 (type: bigint) |
| Reduce Operator Tree: |
| Select Operator |
| expressions: KEY.reducesinkkey0 (type: tinyint), VALUE._col0 (type: tinyint), VALUE._col1 (type: bigint), VALUE._col2 (type: bigint) |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT MIN(ctinyint) as c1, |
| MAX(ctinyint), |
| COUNT(ctinyint), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT MIN(ctinyint) as c1, |
| MAX(ctinyint), |
| COUNT(ctinyint), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -64 62 9173 12288 |
| PREHOOK: query: EXPLAIN |
| SELECT SUM(ctinyint) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT SUM(ctinyint) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: ctinyint (type: tinyint) |
| outputColumnNames: ctinyint |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: sum(ctinyint) |
| 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: sum(VALUE._col0) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 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: bigint) |
| sort order: + |
| Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE |
| Reduce Operator Tree: |
| Select Operator |
| expressions: KEY.reducesinkkey0 (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.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT SUM(ctinyint) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT SUM(ctinyint) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -39856 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| avg(ctinyint) as c1, |
| variance(ctinyint), |
| var_pop(ctinyint), |
| var_samp(ctinyint), |
| std(ctinyint), |
| stddev(ctinyint), |
| stddev_pop(ctinyint), |
| stddev_samp(ctinyint) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| avg(ctinyint) as c1, |
| variance(ctinyint), |
| var_pop(ctinyint), |
| var_samp(ctinyint), |
| std(ctinyint), |
| stddev(ctinyint), |
| stddev_pop(ctinyint), |
| stddev_samp(ctinyint) |
| FROM alltypesorc |
| ORDER BY c1 |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: ctinyint (type: tinyint) |
| outputColumnNames: ctinyint |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: avg(ctinyint), variance(ctinyint), var_pop(ctinyint), var_samp(ctinyint), std(ctinyint), stddev(ctinyint), stddev_pop(ctinyint), stddev_samp(ctinyint) |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Statistics: Num rows: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| Reduce Output Operator |
| sort order: |
| Statistics: Num rows: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col0 (type: struct<count:bigint,sum:double,input:tinyint>), _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: struct<count:bigint,sum:double,variance:double>), _col4 (type: struct<count:bigint,sum:double,variance:double>), _col5 (type: struct<count:bigint,sum:double,variance:double>), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: struct<count:bigint,sum:double,variance:double>) |
| Execution mode: vectorized |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: avg(VALUE._col0), variance(VALUE._col1), var_pop(VALUE._col2), var_samp(VALUE._col3), std(VALUE._col4), stddev(VALUE._col5), stddev_pop(VALUE._col6), stddev_samp(VALUE._col7) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Statistics: Num rows: 1 Data size: 636 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: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col1 (type: double), _col2 (type: double), _col3 (type: double), _col4 (type: double), _col5 (type: double), _col6 (type: double), _col7 (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: double), VALUE._col4 (type: double), VALUE._col5 (type: double), VALUE._col6 (type: double) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Statistics: Num rows: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT |
| avg(ctinyint) as c1, |
| variance(ctinyint), |
| var_pop(ctinyint), |
| var_samp(ctinyint), |
| std(ctinyint), |
| stddev(ctinyint), |
| stddev_pop(ctinyint), |
| stddev_samp(ctinyint) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| avg(ctinyint) as c1, |
| variance(ctinyint), |
| var_pop(ctinyint), |
| var_samp(ctinyint), |
| std(ctinyint), |
| stddev(ctinyint), |
| stddev_pop(ctinyint), |
| stddev_samp(ctinyint) |
| FROM alltypesorc |
| ORDER BY c1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -4.344925324321378 1158.3003004768184 1158.3003004768184 1158.4265870337827 34.033811136527426 34.033811136527426 34.033811136527426 34.03566639620536 |
| PREHOOK: query: EXPLAIN |
| SELECT MIN(cbigint) as c1, |
| MAX(cbigint), |
| COUNT(cbigint), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT MIN(cbigint) as c1, |
| MAX(cbigint), |
| COUNT(cbigint), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: cbigint (type: bigint) |
| outputColumnNames: cbigint |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: min(cbigint), max(cbigint), count(cbigint), count() |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| Statistics: Num rows: 1 Data size: 32 Basic stats: COMPLETE Column stats: NONE |
| Reduce Output Operator |
| sort order: |
| Statistics: Num rows: 1 Data size: 32 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col0 (type: bigint), _col1 (type: bigint), _col2 (type: bigint), _col3 (type: bigint) |
| Execution mode: vectorized |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: min(VALUE._col0), max(VALUE._col1), count(VALUE._col2), count(VALUE._col3) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| Statistics: Num rows: 1 Data size: 32 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: bigint) |
| sort order: + |
| Statistics: Num rows: 1 Data size: 32 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col1 (type: bigint), _col2 (type: bigint), _col3 (type: bigint) |
| Reduce Operator Tree: |
| Select Operator |
| expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: bigint), VALUE._col1 (type: bigint), VALUE._col2 (type: bigint) |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| Statistics: Num rows: 1 Data size: 32 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 32 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT MIN(cbigint) as c1, |
| MAX(cbigint), |
| COUNT(cbigint), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT MIN(cbigint) as c1, |
| MAX(cbigint), |
| COUNT(cbigint), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -2147311592 2145498388 9173 12288 |
| PREHOOK: query: EXPLAIN |
| SELECT SUM(cbigint) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT SUM(cbigint) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: cbigint (type: bigint) |
| outputColumnNames: cbigint |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: sum(cbigint) |
| 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: sum(VALUE._col0) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 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: bigint) |
| sort order: + |
| Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE |
| Reduce Operator Tree: |
| Select Operator |
| expressions: KEY.reducesinkkey0 (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.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT SUM(cbigint) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT SUM(cbigint) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -1698460028409 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| avg(cbigint) as c1, |
| variance(cbigint), |
| var_pop(cbigint), |
| var_samp(cbigint), |
| std(cbigint), |
| stddev(cbigint), |
| stddev_pop(cbigint), |
| stddev_samp(cbigint) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| avg(cbigint) as c1, |
| variance(cbigint), |
| var_pop(cbigint), |
| var_samp(cbigint), |
| std(cbigint), |
| stddev(cbigint), |
| stddev_pop(cbigint), |
| stddev_samp(cbigint) |
| FROM alltypesorc |
| ORDER BY c1 |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: cbigint (type: bigint) |
| outputColumnNames: cbigint |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: avg(cbigint), variance(cbigint), var_pop(cbigint), var_samp(cbigint), std(cbigint), stddev(cbigint), stddev_pop(cbigint), stddev_samp(cbigint) |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE |
| Reduce Output Operator |
| sort order: |
| Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col0 (type: struct<count:bigint,sum:double,input:bigint>), _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: struct<count:bigint,sum:double,variance:double>), _col4 (type: struct<count:bigint,sum:double,variance:double>), _col5 (type: struct<count:bigint,sum:double,variance:double>), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: struct<count:bigint,sum:double,variance:double>) |
| Execution mode: vectorized |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: avg(VALUE._col0), variance(VALUE._col1), var_pop(VALUE._col2), var_samp(VALUE._col3), std(VALUE._col4), stddev(VALUE._col5), stddev_pop(VALUE._col6), stddev_samp(VALUE._col7) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Statistics: Num rows: 1 Data size: 640 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: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col1 (type: double), _col2 (type: double), _col3 (type: double), _col4 (type: double), _col5 (type: double), _col6 (type: double), _col7 (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: double), VALUE._col4 (type: double), VALUE._col5 (type: double), VALUE._col6 (type: double) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT |
| avg(cbigint) as c1, |
| variance(cbigint), |
| var_pop(cbigint), |
| var_samp(cbigint), |
| std(cbigint), |
| stddev(cbigint), |
| stddev_pop(cbigint), |
| stddev_samp(cbigint) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| avg(cbigint) as c1, |
| variance(cbigint), |
| var_pop(cbigint), |
| var_samp(cbigint), |
| std(cbigint), |
| stddev(cbigint), |
| stddev_pop(cbigint), |
| stddev_samp(cbigint) |
| FROM alltypesorc |
| ORDER BY c1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -1.8515862077935246E8 2.07689300543081907E18 2.07689300543081907E18 2.07711944383088768E18 1.441142951074188E9 1.441142951074188E9 1.441142951074188E9 1.4412215110214279E9 |
| PREHOOK: query: EXPLAIN |
| SELECT MIN(cfloat) as c1, |
| MAX(cfloat), |
| COUNT(cfloat), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT MIN(cfloat) as c1, |
| MAX(cfloat), |
| COUNT(cfloat), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: cfloat (type: float) |
| outputColumnNames: cfloat |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: min(cfloat), max(cfloat), count(cfloat), count() |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| 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: float), _col1 (type: float), _col2 (type: bigint), _col3 (type: bigint) |
| Execution mode: vectorized |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: min(VALUE._col0), max(VALUE._col1), count(VALUE._col2), count(VALUE._col3) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| Statistics: Num rows: 1 Data size: 24 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: float) |
| sort order: + |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col1 (type: float), _col2 (type: bigint), _col3 (type: bigint) |
| Reduce Operator Tree: |
| Select Operator |
| expressions: KEY.reducesinkkey0 (type: float), VALUE._col0 (type: float), VALUE._col1 (type: bigint), VALUE._col2 (type: bigint) |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT MIN(cfloat) as c1, |
| MAX(cfloat), |
| COUNT(cfloat), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT MIN(cfloat) as c1, |
| MAX(cfloat), |
| COUNT(cfloat), |
| COUNT(*) |
| FROM alltypesorc |
| ORDER BY c1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -64.0 79.553 9173 12288 |
| PREHOOK: query: EXPLAIN |
| SELECT SUM(cfloat) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT SUM(cfloat) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: cfloat (type: float) |
| outputColumnNames: cfloat |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: sum(cfloat) |
| 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: double) |
| Execution mode: vectorized |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: sum(VALUE._col0) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 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: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE |
| Reduce Operator Tree: |
| Select Operator |
| expressions: KEY.reducesinkkey0 (type: double) |
| 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.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT SUM(cfloat) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT SUM(cfloat) as c1 |
| FROM alltypesorc |
| ORDER BY c1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -39479.635992884636 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| avg(cfloat) as c1, |
| variance(cfloat), |
| var_pop(cfloat), |
| var_samp(cfloat), |
| std(cfloat), |
| stddev(cfloat), |
| stddev_pop(cfloat), |
| stddev_samp(cfloat) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| avg(cfloat) as c1, |
| variance(cfloat), |
| var_pop(cfloat), |
| var_samp(cfloat), |
| std(cfloat), |
| stddev(cfloat), |
| stddev_pop(cfloat), |
| stddev_samp(cfloat) |
| FROM alltypesorc |
| ORDER BY c1 |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: cfloat (type: float) |
| outputColumnNames: cfloat |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: avg(cfloat), variance(cfloat), var_pop(cfloat), var_samp(cfloat), std(cfloat), stddev(cfloat), stddev_pop(cfloat), stddev_samp(cfloat) |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Statistics: Num rows: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| Reduce Output Operator |
| sort order: |
| Statistics: Num rows: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col0 (type: struct<count:bigint,sum:double,input:float>), _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: struct<count:bigint,sum:double,variance:double>), _col4 (type: struct<count:bigint,sum:double,variance:double>), _col5 (type: struct<count:bigint,sum:double,variance:double>), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: struct<count:bigint,sum:double,variance:double>) |
| Execution mode: vectorized |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: avg(VALUE._col0), variance(VALUE._col1), var_pop(VALUE._col2), var_samp(VALUE._col3), std(VALUE._col4), stddev(VALUE._col5), stddev_pop(VALUE._col6), stddev_samp(VALUE._col7) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Statistics: Num rows: 1 Data size: 636 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: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col1 (type: double), _col2 (type: double), _col3 (type: double), _col4 (type: double), _col5 (type: double), _col6 (type: double), _col7 (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: double), VALUE._col4 (type: double), VALUE._col5 (type: double), VALUE._col6 (type: double) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Statistics: Num rows: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 636 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT |
| avg(cfloat) as c1, |
| variance(cfloat), |
| var_pop(cfloat), |
| var_samp(cfloat), |
| std(cfloat), |
| stddev(cfloat), |
| stddev_pop(cfloat), |
| stddev_samp(cfloat) |
| FROM alltypesorc |
| ORDER BY c1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| avg(cfloat) as c1, |
| variance(cfloat), |
| var_pop(cfloat), |
| var_samp(cfloat), |
| std(cfloat), |
| stddev(cfloat), |
| stddev_pop(cfloat), |
| stddev_samp(cfloat) |
| FROM alltypesorc |
| ORDER BY c1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -4.303895780321011 1163.8972588604984 1163.8972588604984 1164.0241556397025 34.115938487171924 34.115938487171924 34.115938487171924 34.11779822379666 |
| WARNING: Comparing a bigint and a double may result in a loss of precision. |
| PREHOOK: query: EXPLAIN |
| SELECT AVG(cbigint), |
| (-(AVG(cbigint))), |
| (-6432 + AVG(cbigint)), |
| STDDEV_POP(cbigint), |
| (-((-6432 + AVG(cbigint)))), |
| ((-((-6432 + AVG(cbigint)))) + (-6432 + AVG(cbigint))), |
| VAR_SAMP(cbigint), |
| (-((-6432 + AVG(cbigint)))), |
| (-6432 + (-((-6432 + AVG(cbigint))))), |
| (-((-6432 + AVG(cbigint)))), |
| ((-((-6432 + AVG(cbigint)))) / (-((-6432 + AVG(cbigint))))), |
| COUNT(*), |
| SUM(cfloat), |
| (VAR_SAMP(cbigint) % STDDEV_POP(cbigint)), |
| (-(VAR_SAMP(cbigint))), |
| ((-((-6432 + AVG(cbigint)))) * (-(AVG(cbigint)))), |
| MIN(ctinyint), |
| (-(MIN(ctinyint))) |
| FROM alltypesorc |
| WHERE (((cstring2 LIKE '%b%') |
| OR ((79.553 != cint) |
| OR (cbigint < cdouble))) |
| OR ((ctinyint >= csmallint) |
| AND ((cboolean2 = 1) |
| AND (3569 = ctinyint)))) |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT AVG(cbigint), |
| (-(AVG(cbigint))), |
| (-6432 + AVG(cbigint)), |
| STDDEV_POP(cbigint), |
| (-((-6432 + AVG(cbigint)))), |
| ((-((-6432 + AVG(cbigint)))) + (-6432 + AVG(cbigint))), |
| VAR_SAMP(cbigint), |
| (-((-6432 + AVG(cbigint)))), |
| (-6432 + (-((-6432 + AVG(cbigint))))), |
| (-((-6432 + AVG(cbigint)))), |
| ((-((-6432 + AVG(cbigint)))) / (-((-6432 + AVG(cbigint))))), |
| COUNT(*), |
| SUM(cfloat), |
| (VAR_SAMP(cbigint) % STDDEV_POP(cbigint)), |
| (-(VAR_SAMP(cbigint))), |
| ((-((-6432 + AVG(cbigint)))) * (-(AVG(cbigint)))), |
| MIN(ctinyint), |
| (-(MIN(ctinyint))) |
| FROM alltypesorc |
| WHERE (((cstring2 LIKE '%b%') |
| OR ((79.553 != cint) |
| OR (cbigint < cdouble))) |
| OR ((ctinyint >= csmallint) |
| AND ((cboolean2 = 1) |
| AND (3569 = ctinyint)))) |
| 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: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Filter Operator |
| predicate: ((cstring2 like '%b%') or (79.553 <> CAST( cint AS decimal(13,3))) or (UDFToDouble(cbigint) < cdouble) or ((UDFToShort(ctinyint) >= csmallint) and (cboolean2 = 1) and (3569 = UDFToInteger(ctinyint)))) (type: boolean) |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: cbigint (type: bigint), cfloat (type: float), ctinyint (type: tinyint) |
| outputColumnNames: cbigint, cfloat, ctinyint |
| Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE |
| Group By Operator |
| aggregations: avg(cbigint), stddev_pop(cbigint), var_samp(cbigint), count(), sum(cfloat), min(ctinyint) |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE |
| Reduce Output Operator |
| sort order: |
| Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE |
| value expressions: _col0 (type: struct<count:bigint,sum:double,input:bigint>), _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: bigint), _col4 (type: double), _col5 (type: tinyint) |
| Execution mode: vectorized |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: avg(VALUE._col0), stddev_pop(VALUE._col1), var_samp(VALUE._col2), count(VALUE._col3), sum(VALUE._col4), min(VALUE._col5) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: _col0 (type: double), (- _col0) (type: double), (-6432.0 + _col0) (type: double), _col1 (type: double), (- (-6432.0 + _col0)) (type: double), ((- (-6432.0 + _col0)) + (-6432.0 + _col0)) (type: double), _col2 (type: double), (- (-6432.0 + _col0)) (type: double), (-6432.0 + (- (-6432.0 + _col0))) (type: double), (- (-6432.0 + _col0)) (type: double), ((- (-6432.0 + _col0)) / (- (-6432.0 + _col0))) (type: double), _col3 (type: bigint), _col4 (type: double), (_col2 % _col1) (type: double), (- _col2) (type: double), ((- (-6432.0 + _col0)) * (- _col0)) (type: double), _col5 (type: tinyint), (- _col5) (type: tinyint) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17 |
| Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| WARNING: Comparing a bigint and a double may result in a loss of precision. |
| PREHOOK: query: SELECT AVG(cbigint), |
| (-(AVG(cbigint))), |
| (-6432 + AVG(cbigint)), |
| STDDEV_POP(cbigint), |
| (-((-6432 + AVG(cbigint)))), |
| ((-((-6432 + AVG(cbigint)))) + (-6432 + AVG(cbigint))), |
| VAR_SAMP(cbigint), |
| (-((-6432 + AVG(cbigint)))), |
| (-6432 + (-((-6432 + AVG(cbigint))))), |
| (-((-6432 + AVG(cbigint)))), |
| ((-((-6432 + AVG(cbigint)))) / (-((-6432 + AVG(cbigint))))), |
| COUNT(*), |
| SUM(cfloat), |
| (VAR_SAMP(cbigint) % STDDEV_POP(cbigint)), |
| (-(VAR_SAMP(cbigint))), |
| ((-((-6432 + AVG(cbigint)))) * (-(AVG(cbigint)))), |
| MIN(ctinyint), |
| (-(MIN(ctinyint))) |
| FROM alltypesorc |
| WHERE (((cstring2 LIKE '%b%') |
| OR ((79.553 != cint) |
| OR (cbigint < cdouble))) |
| OR ((ctinyint >= csmallint) |
| AND ((cboolean2 = 1) |
| AND (3569 = ctinyint)))) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT AVG(cbigint), |
| (-(AVG(cbigint))), |
| (-6432 + AVG(cbigint)), |
| STDDEV_POP(cbigint), |
| (-((-6432 + AVG(cbigint)))), |
| ((-((-6432 + AVG(cbigint)))) + (-6432 + AVG(cbigint))), |
| VAR_SAMP(cbigint), |
| (-((-6432 + AVG(cbigint)))), |
| (-6432 + (-((-6432 + AVG(cbigint))))), |
| (-((-6432 + AVG(cbigint)))), |
| ((-((-6432 + AVG(cbigint)))) / (-((-6432 + AVG(cbigint))))), |
| COUNT(*), |
| SUM(cfloat), |
| (VAR_SAMP(cbigint) % STDDEV_POP(cbigint)), |
| (-(VAR_SAMP(cbigint))), |
| ((-((-6432 + AVG(cbigint)))) * (-(AVG(cbigint)))), |
| MIN(ctinyint), |
| (-(MIN(ctinyint))) |
| FROM alltypesorc |
| WHERE (((cstring2 LIKE '%b%') |
| OR ((79.553 != cint) |
| OR (cbigint < cdouble))) |
| OR ((ctinyint >= csmallint) |
| AND ((cboolean2 = 1) |
| AND (3569 = ctinyint)))) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -3.875652215945533E8 3.875652215945533E8 -3.875716535945533E8 1.436387455459401E9 3.875716535945533E8 0.0 2.06347151720204902E18 3.875716535945533E8 3.875652215945533E8 3.875716535945533E8 1.0 10934 -37224.52399241924 1.0517370547117279E9 -2.06347151720204902E18 1.5020929380914048E17 -64 64 |