[
https://issues.apache.org/jira/browse/HIVE-2272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Franklin Hu updated HIVE-2272:
------------------------------
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
> add TIMESTAMP data type
> -----------------------
>
> Key: HIVE-2272
> URL: https://issues.apache.org/jira/browse/HIVE-2272
> Project: Hive
> Issue Type: New Feature
> Reporter: Franklin Hu
> Assignee: Franklin Hu
> Fix For: 0.8.0
>
> Attachments: hive-2272.1.patch, hive-2272.2.patch, hive-2272.3.patch,
> hive-2272.4.patch, hive-2272.5.patch, hive-2272.6.patch, hive-2272.7.patch,
> hive-2272.8.patch, hive-2272.9.patch
>
>
> 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.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
