PREHOOK: query: EXPLAIN
SELECT DATEDIFF('2008-12-31', '2009-01-01'), DATEDIFF('2008-03-01', '2008-02-28'),
       DATEDIFF('2007-03-01', '2007-01-28'), DATEDIFF('2008-03-01 23:59:59', '2008-03-02 00:00:00'),
       DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365),
       DATE_ADD('2008-02-28', 2), DATE_ADD('2009-02-28', 2),
       DATE_ADD('2007-02-28', 365), DATE_ADD('2007-02-28 23:59:59', 730),
       DATE_SUB('2009-01-01', 1), DATE_SUB('2009-01-01', 365),
       DATE_SUB('2008-02-28', 2), DATE_SUB('2009-02-28', 2),
       DATE_SUB('2007-02-28', 365), DATE_SUB('2007-02-28 01:12:34', 730)
       FROM src WHERE src.key = 86
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT DATEDIFF('2008-12-31', '2009-01-01'), DATEDIFF('2008-03-01', '2008-02-28'),
       DATEDIFF('2007-03-01', '2007-01-28'), DATEDIFF('2008-03-01 23:59:59', '2008-03-02 00:00:00'),
       DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365),
       DATE_ADD('2008-02-28', 2), DATE_ADD('2009-02-28', 2),
       DATE_ADD('2007-02-28', 365), DATE_ADD('2007-02-28 23:59:59', 730),
       DATE_SUB('2009-01-01', 1), DATE_SUB('2009-01-01', 365),
       DATE_SUB('2008-02-28', 2), DATE_SUB('2009-02-28', 2),
       DATE_SUB('2007-02-28', 365), DATE_SUB('2007-02-28 01:12:34', 730)
       FROM src WHERE src.key = 86
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: src
            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: (UDFToDouble(key) = 86.0) (type: boolean)
              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: -1 (type: int), 2 (type: int), 32 (type: int), -1 (type: int), '2009-01-01' (type: string), '2009-12-31' (type: string), '2008-03-01' (type: string), '2009-03-02' (type: string), '2008-02-28' (type: string), '2009-02-27' (type: string), '2008-12-31' (type: string), '2008-01-02' (type: string), '2008-02-26' (type: string), '2009-02-26' (type: string), '2006-02-28' (type: string), '2005-02-28' (type: string)
                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
                Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
                  Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                  table:
                      input format: org.apache.hadoop.mapred.TextInputFormat
                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        ListSink

PREHOOK: query: SELECT DATEDIFF('2008-12-31', '2009-01-01'), DATEDIFF('2008-03-01', '2008-02-28'),
       DATEDIFF('2007-03-01', '2007-01-28'), DATEDIFF('2008-03-01 23:59:59', '2008-03-02 00:00:00'),
       DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365),
       DATE_ADD('2008-02-28', 2), DATE_ADD('2009-02-28', 2),
       DATE_ADD('2007-02-28', 365), DATE_ADD('2007-02-28 23:59:59', 730),
       DATE_SUB('2009-01-01', 1), DATE_SUB('2009-01-01', 365),
       DATE_SUB('2008-03-01', 2), DATE_SUB('2009-03-01', 2),
       DATE_SUB('2007-02-28', 365), DATE_SUB('2007-02-28 01:12:34', 730)
       FROM src WHERE src.key = 86
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT DATEDIFF('2008-12-31', '2009-01-01'), DATEDIFF('2008-03-01', '2008-02-28'),
       DATEDIFF('2007-03-01', '2007-01-28'), DATEDIFF('2008-03-01 23:59:59', '2008-03-02 00:00:00'),
       DATE_ADD('2008-12-31', 1), DATE_ADD('2008-12-31', 365),
       DATE_ADD('2008-02-28', 2), DATE_ADD('2009-02-28', 2),
       DATE_ADD('2007-02-28', 365), DATE_ADD('2007-02-28 23:59:59', 730),
       DATE_SUB('2009-01-01', 1), DATE_SUB('2009-01-01', 365),
       DATE_SUB('2008-03-01', 2), DATE_SUB('2009-03-01', 2),
       DATE_SUB('2007-02-28', 365), DATE_SUB('2007-02-28 01:12:34', 730)
       FROM src WHERE src.key = 86
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-1	2	32	-1	2009-01-01	2009-12-31	2008-03-01	2009-03-02	2008-02-28	2009-02-27	2008-12-31	2008-01-02	2008-02-28	2009-02-27	2006-02-28	2005-02-28