...
Timestamps are interpreted to be timezoneless and stored as an offset from the UNIX epoch. Convenience UDFs for conversion to and from timezones are provided (to_utc_timestamp, from_utc_timestamp).
All existing datetime UDFs (month, day, year, hour, etc.) work with the TIMESTAMP data type.
| Wiki Markup |
|---|
Timestamps in text files have to use the format {{ |
Timestamp in text format files have to comply with format yyyy-mm-dd hh:mm:ss\[.f...\]}}. If they are in another format declare them |
as an as the appropriate type (INT, FLOAT |
or STRING type if they are in the format conversion format listed above, and cast them, STRING, etc.) and use a UDF to convert them to timestamps. |
| Info |
|---|
|
Timestamps were introduced in Hive 0.8.0 (HIVE-2272). |
...