| PREHOOK: query: DESCRIBE FUNCTION hour |
| PREHOOK: type: DESCFUNCTION |
| POSTHOOK: query: DESCRIBE FUNCTION hour |
| POSTHOOK: type: DESCFUNCTION |
| hour(param) - Returns the hour componemnt of the string/timestamp/interval |
| PREHOOK: query: DESCRIBE FUNCTION EXTENDED hour |
| PREHOOK: type: DESCFUNCTION |
| POSTHOOK: query: DESCRIBE FUNCTION EXTENDED hour |
| POSTHOOK: type: DESCFUNCTION |
| hour(param) - Returns the hour componemnt of the string/timestamp/interval |
| param can be one of: |
| 1. A string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'. |
| 2. A timestamp value |
| 3. A day-time interval valueExample: |
| > SELECT hour('2009-07-30 12:58:59') FROM src LIMIT 1; |
| 12 |
| > SELECT hour('12:58:59') FROM src LIMIT 1; |
| 12 |
| Function class:org.apache.hadoop.hive.ql.udf.UDFHour |
| Function type:BUILTIN |
| PREHOOK: query: EXPLAIN |
| SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07') |
| FROM src WHERE key = 86 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07') |
| FROM src WHERE key = 86 |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE |
| Filter Operator |
| predicate: (UDFToDouble(key) = 86.0D) (type: boolean) |
| Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: 13 (type: int), null (type: int), 0 (type: int) |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE |
| ListSink |
| |
| PREHOOK: query: SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07') |
| FROM src WHERE key = 86 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07') |
| FROM src WHERE key = 86 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| 13 NULL 0 |
| PREHOOK: query: SELECT hour(cast('2009-08-07 13:14:15' as timestamp)) |
| FROM src WHERE key=86 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT hour(cast('2009-08-07 13:14:15' as timestamp)) |
| FROM src WHERE key=86 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| 13 |