[
https://issues.apache.org/jira/browse/HIVE-2272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Franklin Hu updated HIVE-2272:
------------------------------
Attachment: hive-2272.7.patch
Decided to store timestamps as UTC on disk and add offsets (localize) if user
needs through UDF. This simplifies use cases (compared to MySQL) where users
from different time zones querying the same data would receive different
results.
Will file a follow up JIRA ticket to add table level timezone defaults. This
would allow a user to import existing data that is already offset from UTC and
write new data to the table with that offset.
Summary:
-Added config var for default timezone
-Added GenericUDF for converting from UTC to localized timezone (either
default, or supplied from list of Java timezones)
Ex: utc_to_localized_timestamp(<timestamp>) OR
utc_to_localized_timestamp(<timestamp>, "America/Chicago")
-Fixed DateDiff bug I introduced
> 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
> 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
>
>
> 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
