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