hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <>
Subject [jira] [Commented] (HIVE-14412) Add a timezone-aware timestamp
Date Thu, 29 Sep 2016 17:40:20 GMT


Alan Gates commented on HIVE-14412:

Agree the TZ <-> non TZ conversions look like they match up with the spec.

Using the GMT+/-HH:MM format for timezone matches the spec, but it does create a weird situation
for many users where 1/2 the year their times will be off by an hour.  I think the big question
is can the underlying infrastructure handle it, as we don't want Hive in the business of understanding
when DST starts and stops all over the world.

> Add a timezone-aware timestamp
> ------------------------------
>                 Key: HIVE-14412
>                 URL:
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Hive
>            Reporter: Rui Li
>            Assignee: Rui Li
>         Attachments: HIVE-14412.1.patch, HIVE-14412.2.patch, HIVE-14412.3.patch, HIVE-14412.4.patch,
HIVE-14412.5.patch, HIVE-14412.6.patch, HIVE-14412.7.patch, HIVE-14412.8.patch
> Java's Timestamp stores the time elapsed since the epoch. While it's by itself unambiguous,
ambiguity comes when we parse a string into timestamp, or convert a timestamp to string, causing
problems like HIVE-14305.
> To solve the issue, I think we should make timestamp aware of timezone.

This message was sent by Atlassian JIRA

View raw message