| PREHOOK: query: DESCRIBE FUNCTION trunc |
| PREHOOK: type: DESCFUNCTION |
| POSTHOOK: query: DESCRIBE FUNCTION trunc |
| POSTHOOK: type: DESCFUNCTION |
| trunc(date, fmt) / trunc(N,D) - Returns If input is date returns date with the time portion of the day truncated to the unit specified by the format model fmt. If you omit fmt, then date is truncated to the nearest day. It currently only supports 'MONTH'/'MON'/'MM', 'QUARTER'/'Q' and 'YEAR'/'YYYY'/'YY' as format.If input is a number group returns N truncated to D decimal places. If D is omitted, then N is truncated to 0 places.D can be negative to truncate (make zero) D digits left of the decimal point. |
| PREHOOK: query: DESCRIBE FUNCTION EXTENDED trunc |
| PREHOOK: type: DESCFUNCTION |
| POSTHOOK: query: DESCRIBE FUNCTION EXTENDED trunc |
| POSTHOOK: type: DESCFUNCTION |
| trunc(date, fmt) / trunc(N,D) - Returns If input is date returns date with the time portion of the day truncated to the unit specified by the format model fmt. If you omit fmt, then date is truncated to the nearest day. It currently only supports 'MONTH'/'MON'/'MM', 'QUARTER'/'Q' and 'YEAR'/'YYYY'/'YY' as format.If input is a number group returns N truncated to D decimal places. If D is omitted, then N is truncated to 0 places.D can be negative to truncate (make zero) D digits left of the decimal point. |
| date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. The time part of date is ignored. |
| Example: |
| > SELECT trunc('2009-02-12', 'MM'); |
| OK |
| '2009-02-01' |
| > SELECT trunc('2017-03-15', 'Q'); |
| OK |
| '2017-01-01' |
| > SELECT trunc('2015-10-27', 'YEAR'); |
| OK |
| '2015-01-01' > SELECT trunc(1234567891.1234567891,4); |
| OK |
| 1234567891.1234 |
| > SELECT trunc(1234567891.1234567891,-4); |
| OK |
| 1234560000 > SELECT trunc(1234567891.1234567891,0); |
| OK |
| 1234567891 |
| > SELECT trunc(1234567891.1234567891); |
| OK |
| 1234567891 |
| Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFTrunc |
| Function type:BUILTIN |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-01', 'MM'), |
| TRUNC('2014-01-14', 'MM'), |
| TRUNC('2014-01-31', 'MM'), |
| TRUNC('2014-02-02', 'MM'), |
| TRUNC('2014-02-28', 'MM'), |
| TRUNC('2016-02-03', 'MM'), |
| TRUNC('2016-02-28', 'MM'), |
| TRUNC('2016-02-29', 'MM'), |
| TRUNC('2014-01-01 10:30:45', 'MM'), |
| TRUNC('2014-01-14 10:30:45', 'MM'), |
| TRUNC('2014-01-31 10:30:45', 'MM'), |
| TRUNC('2014-02-02 10:30:45', 'MM'), |
| TRUNC('2014-02-28 10:30:45', 'MM'), |
| TRUNC('2016-02-03 10:30:45', 'MM'), |
| TRUNC('2016-02-28 10:30:45', 'MM'), |
| TRUNC('2016-02-29 10:30:45', 'MM') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-01', 'MM'), |
| TRUNC('2014-01-14', 'MM'), |
| TRUNC('2014-01-31', 'MM'), |
| TRUNC('2014-02-02', 'MM'), |
| TRUNC('2014-02-28', 'MM'), |
| TRUNC('2016-02-03', 'MM'), |
| TRUNC('2016-02-28', 'MM'), |
| TRUNC('2016-02-29', 'MM'), |
| TRUNC('2014-01-01 10:30:45', 'MM'), |
| TRUNC('2014-01-14 10:30:45', 'MM'), |
| TRUNC('2014-01-31 10:30:45', 'MM'), |
| TRUNC('2014-02-02 10:30:45', 'MM'), |
| TRUNC('2014-02-28 10:30:45', 'MM'), |
| TRUNC('2016-02-03 10:30:45', 'MM'), |
| TRUNC('2016-02-28 10:30:45', 'MM'), |
| TRUNC('2016-02-29 10:30:45', 'MM') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-02-01' (type: string), '2014-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-02-01' (type: string), '2014-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC('2014-01-01', 'MM'), |
| TRUNC('2014-01-14', 'MM'), |
| TRUNC('2014-01-31', 'MM'), |
| TRUNC('2014-02-02', 'MM'), |
| TRUNC('2014-02-28', 'MM'), |
| TRUNC('2016-02-03', 'MM'), |
| TRUNC('2016-02-28', 'MM'), |
| TRUNC('2016-02-29', 'MM'), |
| TRUNC('2014-01-01 10:30:45', 'MM'), |
| TRUNC('2014-01-14 10:30:45', 'MM'), |
| TRUNC('2014-01-31 10:30:45', 'MM'), |
| TRUNC('2014-02-02 10:30:45', 'MM'), |
| TRUNC('2014-02-28 10:30:45', 'MM'), |
| TRUNC('2016-02-03 10:30:45', 'MM'), |
| TRUNC('2016-02-28 10:30:45', 'MM'), |
| TRUNC('2016-02-29 10:30:45', 'MM') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC('2014-01-01', 'MM'), |
| TRUNC('2014-01-14', 'MM'), |
| TRUNC('2014-01-31', 'MM'), |
| TRUNC('2014-02-02', 'MM'), |
| TRUNC('2014-02-28', 'MM'), |
| TRUNC('2016-02-03', 'MM'), |
| TRUNC('2016-02-28', 'MM'), |
| TRUNC('2016-02-29', 'MM'), |
| TRUNC('2014-01-01 10:30:45', 'MM'), |
| TRUNC('2014-01-14 10:30:45', 'MM'), |
| TRUNC('2014-01-31 10:30:45', 'MM'), |
| TRUNC('2014-02-02 10:30:45', 'MM'), |
| TRUNC('2014-02-28 10:30:45', 'MM'), |
| TRUNC('2016-02-03 10:30:45', 'MM'), |
| TRUNC('2016-02-28 10:30:45', 'MM'), |
| TRUNC('2016-02-29 10:30:45', 'MM') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 2014-01-01 2014-01-01 2014-01-01 2014-02-01 2014-02-01 2016-02-01 2016-02-01 2016-02-01 2014-01-01 2014-01-01 2014-01-01 2014-02-01 2014-02-01 2016-02-01 2016-02-01 2016-02-01 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-01', 'Q'), |
| TRUNC('2014-01-14', 'Q'), |
| TRUNC('2014-01-31', 'Q'), |
| TRUNC('2014-02-02', 'Q'), |
| TRUNC('2014-02-28', 'Q'), |
| TRUNC('2016-02-03', 'Q'), |
| TRUNC('2016-02-28', 'Q'), |
| TRUNC('2016-02-29', 'Q'), |
| TRUNC('2016-05-11', 'Q'), |
| TRUNC('2016-07-01', 'Q'), |
| TRUNC('2016-12-31', 'Q'), |
| TRUNC('2014-01-01 10:30:45', 'Q'), |
| TRUNC('2014-01-14 10:30:45', 'Q'), |
| TRUNC('2014-01-31 10:30:45', 'Q'), |
| TRUNC('2014-02-02 10:30:45', 'Q'), |
| TRUNC('2014-02-28 10:30:45', 'Q'), |
| TRUNC('2016-02-03 10:30:45', 'Q'), |
| TRUNC('2016-02-28 10:30:45', 'Q'), |
| TRUNC('2016-02-29 10:30:45', 'Q'), |
| TRUNC('2016-05-11 10:30:45', 'Q'), |
| TRUNC('2016-07-01 10:30:45', 'Q'), |
| TRUNC('2016-12-31 10:30:45', 'Q') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-01', 'Q'), |
| TRUNC('2014-01-14', 'Q'), |
| TRUNC('2014-01-31', 'Q'), |
| TRUNC('2014-02-02', 'Q'), |
| TRUNC('2014-02-28', 'Q'), |
| TRUNC('2016-02-03', 'Q'), |
| TRUNC('2016-02-28', 'Q'), |
| TRUNC('2016-02-29', 'Q'), |
| TRUNC('2016-05-11', 'Q'), |
| TRUNC('2016-07-01', 'Q'), |
| TRUNC('2016-12-31', 'Q'), |
| TRUNC('2014-01-01 10:30:45', 'Q'), |
| TRUNC('2014-01-14 10:30:45', 'Q'), |
| TRUNC('2014-01-31 10:30:45', 'Q'), |
| TRUNC('2014-02-02 10:30:45', 'Q'), |
| TRUNC('2014-02-28 10:30:45', 'Q'), |
| TRUNC('2016-02-03 10:30:45', 'Q'), |
| TRUNC('2016-02-28 10:30:45', 'Q'), |
| TRUNC('2016-02-29 10:30:45', 'Q'), |
| TRUNC('2016-05-11 10:30:45', 'Q'), |
| TRUNC('2016-07-01 10:30:45', 'Q'), |
| TRUNC('2016-12-31 10:30:45', 'Q') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-04-01' (type: string), '2016-07-01' (type: string), '2016-10-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-04-01' (type: string), '2016-07-01' (type: string), '2016-10-01' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC('2014-01-01', 'Q'), |
| TRUNC('2014-01-14', 'Q'), |
| TRUNC('2014-01-31', 'Q'), |
| TRUNC('2014-02-02', 'Q'), |
| TRUNC('2014-02-28', 'Q'), |
| TRUNC('2016-02-03', 'Q'), |
| TRUNC('2016-02-28', 'Q'), |
| TRUNC('2016-02-29', 'Q'), |
| TRUNC('2016-05-11', 'Q'), |
| TRUNC('2016-07-01', 'Q'), |
| TRUNC('2016-12-31', 'Q'), |
| TRUNC('2014-01-01 10:30:45', 'Q'), |
| TRUNC('2014-01-14 10:30:45', 'Q'), |
| TRUNC('2014-01-31 10:30:45', 'Q'), |
| TRUNC('2014-02-02 10:30:45', 'Q'), |
| TRUNC('2014-02-28 10:30:45', 'Q'), |
| TRUNC('2016-02-03 10:30:45', 'Q'), |
| TRUNC('2016-02-28 10:30:45', 'Q'), |
| TRUNC('2016-02-29 10:30:45', 'Q'), |
| TRUNC('2016-05-11 10:30:45', 'Q'), |
| TRUNC('2016-07-01 10:30:45', 'Q'), |
| TRUNC('2016-12-31 10:30:45', 'Q') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC('2014-01-01', 'Q'), |
| TRUNC('2014-01-14', 'Q'), |
| TRUNC('2014-01-31', 'Q'), |
| TRUNC('2014-02-02', 'Q'), |
| TRUNC('2014-02-28', 'Q'), |
| TRUNC('2016-02-03', 'Q'), |
| TRUNC('2016-02-28', 'Q'), |
| TRUNC('2016-02-29', 'Q'), |
| TRUNC('2016-05-11', 'Q'), |
| TRUNC('2016-07-01', 'Q'), |
| TRUNC('2016-12-31', 'Q'), |
| TRUNC('2014-01-01 10:30:45', 'Q'), |
| TRUNC('2014-01-14 10:30:45', 'Q'), |
| TRUNC('2014-01-31 10:30:45', 'Q'), |
| TRUNC('2014-02-02 10:30:45', 'Q'), |
| TRUNC('2014-02-28 10:30:45', 'Q'), |
| TRUNC('2016-02-03 10:30:45', 'Q'), |
| TRUNC('2016-02-28 10:30:45', 'Q'), |
| TRUNC('2016-02-29 10:30:45', 'Q'), |
| TRUNC('2016-05-11 10:30:45', 'Q'), |
| TRUNC('2016-07-01 10:30:45', 'Q'), |
| TRUNC('2016-12-31 10:30:45', 'Q') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 2016-04-01 2016-07-01 2016-10-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 2016-04-01 2016-07-01 2016-10-01 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-01', 'YEAR'), |
| TRUNC('2014-01-14', 'YEAR'), |
| TRUNC('2014-01-31', 'YEAR'), |
| TRUNC('2014-02-02', 'YEAR'), |
| TRUNC('2014-02-28', 'YEAR'), |
| TRUNC('2016-02-03', 'YEAR'), |
| TRUNC('2016-02-28', 'YEAR'), |
| TRUNC('2016-02-29', 'YEAR'), |
| TRUNC('2014-01-01 10:30:45', 'YEAR'), |
| TRUNC('2014-01-14 10:30:45', 'YEAR'), |
| TRUNC('2014-01-31 10:30:45', 'YEAR'), |
| TRUNC('2014-02-02 10:30:45', 'YEAR'), |
| TRUNC('2014-02-28 10:30:45', 'YEAR'), |
| TRUNC('2016-02-03 10:30:45', 'YEAR'), |
| TRUNC('2016-02-28 10:30:45', 'YEAR'), |
| TRUNC('2016-02-29 10:30:45', 'YEAR') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-01', 'YEAR'), |
| TRUNC('2014-01-14', 'YEAR'), |
| TRUNC('2014-01-31', 'YEAR'), |
| TRUNC('2014-02-02', 'YEAR'), |
| TRUNC('2014-02-28', 'YEAR'), |
| TRUNC('2016-02-03', 'YEAR'), |
| TRUNC('2016-02-28', 'YEAR'), |
| TRUNC('2016-02-29', 'YEAR'), |
| TRUNC('2014-01-01 10:30:45', 'YEAR'), |
| TRUNC('2014-01-14 10:30:45', 'YEAR'), |
| TRUNC('2014-01-31 10:30:45', 'YEAR'), |
| TRUNC('2014-02-02 10:30:45', 'YEAR'), |
| TRUNC('2014-02-28 10:30:45', 'YEAR'), |
| TRUNC('2016-02-03 10:30:45', 'YEAR'), |
| TRUNC('2016-02-28 10:30:45', 'YEAR'), |
| TRUNC('2016-02-29 10:30:45', 'YEAR') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC('2014-01-01', 'YEAR'), |
| TRUNC('2014-01-14', 'YEAR'), |
| TRUNC('2014-01-31', 'YEAR'), |
| TRUNC('2014-02-02', 'YEAR'), |
| TRUNC('2014-02-28', 'YEAR'), |
| TRUNC('2016-02-03', 'YEAR'), |
| TRUNC('2016-02-28', 'YEAR'), |
| TRUNC('2016-02-29', 'YEAR'), |
| TRUNC('2014-01-01 10:30:45', 'YEAR'), |
| TRUNC('2014-01-14 10:30:45', 'YEAR'), |
| TRUNC('2014-01-31 10:30:45', 'YEAR'), |
| TRUNC('2014-02-02 10:30:45', 'YEAR'), |
| TRUNC('2014-02-28 10:30:45', 'YEAR'), |
| TRUNC('2016-02-03 10:30:45', 'YEAR'), |
| TRUNC('2016-02-28 10:30:45', 'YEAR'), |
| TRUNC('2016-02-29 10:30:45', 'YEAR') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC('2014-01-01', 'YEAR'), |
| TRUNC('2014-01-14', 'YEAR'), |
| TRUNC('2014-01-31', 'YEAR'), |
| TRUNC('2014-02-02', 'YEAR'), |
| TRUNC('2014-02-28', 'YEAR'), |
| TRUNC('2016-02-03', 'YEAR'), |
| TRUNC('2016-02-28', 'YEAR'), |
| TRUNC('2016-02-29', 'YEAR'), |
| TRUNC('2014-01-01 10:30:45', 'YEAR'), |
| TRUNC('2014-01-14 10:30:45', 'YEAR'), |
| TRUNC('2014-01-31 10:30:45', 'YEAR'), |
| TRUNC('2014-02-02 10:30:45', 'YEAR'), |
| TRUNC('2014-02-28 10:30:45', 'YEAR'), |
| TRUNC('2016-02-03 10:30:45', 'YEAR'), |
| TRUNC('2016-02-28 10:30:45', 'YEAR'), |
| TRUNC('2016-02-29 10:30:45', 'YEAR') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'MM') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'MM') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-02-01' (type: string), '2014-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-02-01' (type: string), '2014-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'MM') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'MM'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'MM') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 2014-01-01 2014-01-01 2014-01-01 2014-02-01 2014-02-01 2016-02-01 2016-02-01 2016-02-01 2014-01-01 2014-01-01 2014-01-01 2014-02-01 2014-02-01 2016-02-01 2016-02-01 2016-02-01 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-05-11 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-07-01 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-12-31 10:30:45' AS TIMESTAMP), 'Q') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-05-11 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-07-01 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-12-31 10:30:45' AS TIMESTAMP), 'Q') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-04-01' (type: string), '2016-07-01' (type: string), '2016-10-01' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-05-11 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-07-01 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-12-31 10:30:45' AS TIMESTAMP), 'Q') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-05-11 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-07-01 10:30:45' AS TIMESTAMP), 'Q'), |
| TRUNC(CAST('2016-12-31 10:30:45' AS TIMESTAMP), 'Q') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 2016-04-01 2016-07-01 2016-10-01 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'YEAR') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'YEAR') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'YEAR') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-14 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-31 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-02 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-28 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-03 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-28 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-29 00:00:00' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-01 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-14 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-01-31 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-02 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2014-02-28 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-03 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-28 10:30:45' AS TIMESTAMP), 'YEAR'), |
| TRUNC(CAST('2016-02-29 10:30:45' AS TIMESTAMP), 'YEAR') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'MM'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'MM'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'MM'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'MM'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'MM') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'MM'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'MM'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'MM'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'MM'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'MM') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-02-01' (type: string), '2014-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string), '2016-02-01' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'MM'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'MM'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'MM'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'MM'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'MM') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'MM'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'MM'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'MM'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'MM'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'MM'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'MM') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 2014-01-01 2014-01-01 2014-01-01 2014-02-01 2014-02-01 2016-02-01 2016-02-01 2016-02-01 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'Q'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'Q'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'Q'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'Q'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'Q'), |
| TRUNC(CAST('2016-05-11' AS DATE), 'Q'), |
| TRUNC(CAST('2016-07-01' AS DATE), 'Q'), |
| TRUNC(CAST('2016-12-31' AS DATE), 'Q') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'Q'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'Q'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'Q'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'Q'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'Q'), |
| TRUNC(CAST('2016-05-11' AS DATE), 'Q'), |
| TRUNC(CAST('2016-07-01' AS DATE), 'Q'), |
| TRUNC(CAST('2016-12-31' AS DATE), 'Q') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-04-01' (type: string), '2016-07-01' (type: string), '2016-10-01' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'Q'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'Q'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'Q'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'Q'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'Q'), |
| TRUNC(CAST('2016-05-11' AS DATE), 'Q'), |
| TRUNC(CAST('2016-07-01' AS DATE), 'Q'), |
| TRUNC(CAST('2016-12-31' AS DATE), 'Q') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'Q'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'Q'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'Q'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'Q'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'Q'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'Q'), |
| TRUNC(CAST('2016-05-11' AS DATE), 'Q'), |
| TRUNC(CAST('2016-07-01' AS DATE), 'Q'), |
| TRUNC(CAST('2016-12-31' AS DATE), 'Q') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 2016-04-01 2016-07-01 2016-10-01 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'YEAR') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'YEAR') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2014-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string), '2016-01-01' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'YEAR') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC(CAST('2014-01-01' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-01-14' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-01-31' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-02-02' AS DATE), 'YEAR'), |
| TRUNC(CAST('2014-02-28' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-03' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-28' AS DATE), 'YEAR'), |
| TRUNC(CAST('2016-02-29' AS DATE), 'YEAR') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2014-01-01 2016-01-01 2016-01-01 2016-01-01 |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-34', 'MM'), |
| TRUNC(CAST(null AS STRING), 'MM'), |
| TRUNC(CAST(null AS DATE), 'MM'), |
| TRUNC(CAST(null AS TIMESTAMP), 'MM'), |
| TRUNC('2014-01-01', 'M'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-34', 'MM'), |
| TRUNC(CAST(null AS STRING), 'MM'), |
| TRUNC(CAST(null AS DATE), 'MM'), |
| TRUNC(CAST(null AS TIMESTAMP), 'MM'), |
| TRUNC('2014-01-01', 'M'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: null (type: string), null (type: string), null (type: string), null (type: string), null (type: string), null (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC('2014-01-34', 'MM'), |
| TRUNC(CAST(null AS STRING), 'MM'), |
| TRUNC(CAST(null AS DATE), 'MM'), |
| TRUNC(CAST(null AS TIMESTAMP), 'MM'), |
| TRUNC('2014-01-01', 'M'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC('2014-01-34', 'MM'), |
| TRUNC(CAST(null AS STRING), 'MM'), |
| TRUNC(CAST(null AS DATE), 'MM'), |
| TRUNC(CAST(null AS TIMESTAMP), 'MM'), |
| TRUNC('2014-01-01', 'M'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| NULL NULL NULL NULL NULL NULL |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-34', 'Q'), |
| TRUNC(CAST(null AS STRING), 'Q'), |
| TRUNC(CAST(null AS DATE), 'Q'), |
| TRUNC(CAST(null AS TIMESTAMP), 'Q'), |
| TRUNC('2014-01-01', 'Q'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-34', 'Q'), |
| TRUNC(CAST(null AS STRING), 'Q'), |
| TRUNC(CAST(null AS DATE), 'Q'), |
| TRUNC(CAST(null AS TIMESTAMP), 'Q'), |
| TRUNC('2014-01-01', 'Q'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: null (type: string), null (type: string), null (type: string), null (type: string), '2014-01-01' (type: string), null (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC('2014-01-34', 'Q'), |
| TRUNC(CAST(null AS STRING), 'Q'), |
| TRUNC(CAST(null AS DATE), 'Q'), |
| TRUNC(CAST(null AS TIMESTAMP), 'Q'), |
| TRUNC('2014-01-01', 'Q'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC('2014-01-34', 'Q'), |
| TRUNC(CAST(null AS STRING), 'Q'), |
| TRUNC(CAST(null AS DATE), 'Q'), |
| TRUNC(CAST(null AS TIMESTAMP), 'Q'), |
| TRUNC('2014-01-01', 'Q'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| NULL NULL NULL NULL 2014-01-01 NULL |
| PREHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-34', 'YEAR'), |
| TRUNC(CAST(null AS STRING), 'YEAR'), |
| TRUNC(CAST(null AS DATE), 'YEAR'), |
| TRUNC(CAST(null AS TIMESTAMP), 'YEAR'), |
| TRUNC('2014-01-01', 'M'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT |
| TRUNC('2014-01-34', 'YEAR'), |
| TRUNC(CAST(null AS STRING), 'YEAR'), |
| TRUNC(CAST(null AS DATE), 'YEAR'), |
| TRUNC(CAST(null AS TIMESTAMP), 'YEAR'), |
| TRUNC('2014-01-01', 'M'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: null (type: string), null (type: string), null (type: string), null (type: string), null (type: string), null (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| ListSink |
| |
| PREHOOK: query: SELECT |
| TRUNC('2014-01-34', 'YEAR'), |
| TRUNC(CAST(null AS STRING), 'YEAR'), |
| TRUNC(CAST(null AS DATE), 'YEAR'), |
| TRUNC(CAST(null AS TIMESTAMP), 'YEAR'), |
| TRUNC('2014-01-01', 'M'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT |
| TRUNC('2014-01-34', 'YEAR'), |
| TRUNC(CAST(null AS STRING), 'YEAR'), |
| TRUNC(CAST(null AS DATE), 'YEAR'), |
| TRUNC(CAST(null AS TIMESTAMP), 'YEAR'), |
| TRUNC('2014-01-01', 'M'), |
| TRUNC('2014-01-01', CAST(null AS STRING)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| NULL NULL NULL NULL NULL NULL |
