| PREHOOK: query: EXPLAIN SELECT cdouble, cint, cboolean1, ctimestamp1, CAST(cdouble AS DECIMAL(20,10)), CAST(cint AS DECIMAL(23,14)), CAST(cboolean1 AS DECIMAL(5,2)), CAST(ctimestamp1 AS DECIMAL(15,0)) FROM alltypesorc WHERE cdouble IS NOT NULL AND cint IS NOT NULL AND cboolean1 IS NOT NULL AND ctimestamp1 IS NOT NULL LIMIT 10 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN SELECT cdouble, cint, cboolean1, ctimestamp1, CAST(cdouble AS DECIMAL(20,10)), CAST(cint AS DECIMAL(23,14)), CAST(cboolean1 AS DECIMAL(5,2)), CAST(ctimestamp1 AS DECIMAL(15,0)) FROM alltypesorc WHERE cdouble IS NOT NULL AND cint IS NOT NULL AND cboolean1 IS NOT NULL AND ctimestamp1 IS NOT NULL LIMIT 10 |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: 10 |
| Processor Tree: |
| TableScan |
| alias: alltypesorc |
| Filter Operator |
| predicate: (((cdouble is not null and cint is not null) and cboolean1 is not null) and ctimestamp1 is not null) (type: boolean) |
| Select Operator |
| expressions: cdouble (type: double), cint (type: int), cboolean1 (type: boolean), ctimestamp1 (type: timestamp), CAST( cdouble AS decimal(20,10)) (type: decimal(20,10)), CAST( cint AS decimal(23,14)) (type: decimal(23,14)), CAST( cboolean1 AS decimal(5,2)) (type: decimal(5,2)), CAST( ctimestamp1 AS decimal(15,0)) (type: decimal(15,0)) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| Limit |
| Number of rows: 10 |
| ListSink |
| |
| PREHOOK: query: SELECT cdouble, cint, cboolean1, ctimestamp1, CAST(cdouble AS DECIMAL(20,10)), CAST(cint AS DECIMAL(23,14)), CAST(cboolean1 AS DECIMAL(5,2)), CAST(ctimestamp1 AS DECIMAL(15,0)) FROM alltypesorc WHERE cdouble IS NOT NULL AND cint IS NOT NULL AND cboolean1 IS NOT NULL AND ctimestamp1 IS NOT NULL LIMIT 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT cdouble, cint, cboolean1, ctimestamp1, CAST(cdouble AS DECIMAL(20,10)), CAST(cint AS DECIMAL(23,14)), CAST(cboolean1 AS DECIMAL(5,2)), CAST(ctimestamp1 AS DECIMAL(15,0)) FROM alltypesorc WHERE cdouble IS NOT NULL AND cint IS NOT NULL AND cboolean1 IS NOT NULL AND ctimestamp1 IS NOT NULL LIMIT 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| -13326.0 528534767 true 1969-12-31 15:59:46.674 -13326 528534767 1 -13 |
| -15813.0 528534767 true 1969-12-31 15:59:55.787 -15813 528534767 1 -4 |
| -9566.0 528534767 true 1969-12-31 15:59:44.187 -9566 528534767 1 -16 |
| 15007.0 528534767 true 1969-12-31 15:59:50.434 15007 528534767 1 -10 |
| 7021.0 528534767 true 1969-12-31 16:00:15.007 7021 528534767 1 15 |
| 4963.0 528534767 true 1969-12-31 16:00:07.021 4963 528534767 1 7 |
| -7824.0 528534767 true 1969-12-31 16:00:04.963 -7824 528534767 1 5 |
| -15431.0 528534767 true 1969-12-31 15:59:52.176 -15431 528534767 1 -8 |
| -15549.0 528534767 true 1969-12-31 15:59:44.569 -15549 528534767 1 -15 |
| 5780.0 528534767 true 1969-12-31 15:59:44.451 5780 528534767 1 -16 |