[HIVE-2272] add TIMESTAMP data type

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0

Release Note

TIMESTAMP data type
New primitive data type that supports traditional UNIX timestamp with optional nanosecond precision.

Supported conversions:
Integer numeric types: Interpreted as UNIX timestamp in seconds
Floating point numeric types: Intepreted as UNIX timestamp in seconds with decimal precision
Strings: JDBC compliant java.sql.Timestamp format "YYYY-MM-DD HH:MM:SS.fffffffff" (9 decimal place precision)

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.) will work with the TIMESTAMP data type.

Supported SerDes:
ColumnarSerDe
LazyBinaryColumnarSerDe
LazySimpleSerDe
LazyBinarySerDe
BinarySortableSerDe

• Assignee: Franklin Hu
• Reporter: Franklin Hu
• Created: 07/Jul/11 18:30
• Updated: 16/Dec/11 23:56
• Resolved: 12/Aug/11 19:57

Description

Add TIMESTAMP type to serde2 that supports unix timestamp (1970-01-01 00:00:01 UTC to 2038-01-19 03:14:07 UTC) with optional nanosecond precision using both LazyBinary and LazySimple SerDes.
For LazySimpleSerDe, the data is stored in jdbc compliant java.sql.Timestamp parsable strings.

Issue Links

• is part of: HIVE-1269 Support Date/Datetime/Time/Timestamp Primitive Types