| PREHOOK: query: DESCRIBE FUNCTION date_sub |
| PREHOOK: type: DESCFUNCTION |
| POSTHOOK: query: DESCRIBE FUNCTION date_sub |
| POSTHOOK: type: DESCFUNCTION |
| date_sub(start_date, num_days) - Returns the date that is num_days before start_date. |
| PREHOOK: query: DESCRIBE FUNCTION EXTENDED date_sub |
| PREHOOK: type: DESCFUNCTION |
| POSTHOOK: query: DESCRIBE FUNCTION EXTENDED date_sub |
| POSTHOOK: type: DESCFUNCTION |
| date_sub(start_date, num_days) - Returns the date that is num_days before start_date. |
| start_date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. num_days is a number. The time part of start_date is ignored. |
| Example: |
| > SELECT date_sub('2009-07-30', 1) FROM src LIMIT 1; |
| '2009-07-29' |
| Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFDateSub |
| Function type:BUILTIN |
| PREHOOK: query: SELECT date_sub('1900-01-01', cast(10 as tinyint)), |
| date_sub('1900-01-01', cast(10 as smallint)), |
| date_sub('1900-01-01', cast(10 as int)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT date_sub('1900-01-01', cast(10 as tinyint)), |
| date_sub('1900-01-01', cast(10 as smallint)), |
| date_sub('1900-01-01', cast(10 as int)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| 1899-12-22 1899-12-22 1899-12-22 |