Rui Li updated HIVE-14412:
    Attachment: HIVE-14412.6.patch

V6 patch makes TIME as reserved keyword, and ZONE and TIMESTAMPTZ as 
non-reserved keyword, which is inline with the SQL11 standard. It also updates 
some qtests to quote TIME when it's used as an identifier.
If users want to keep using TIME as identifier, they can either quote it or set 
hive.support.sql11.reserved.keywords=false, as mentioned in HIVE-6617.

> Add a timezone-aware timestamp
> ------------------------------
>                 Key: HIVE-14412
>                 URL: https://issues.apache.org/jira/browse/HIVE-14412
>             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
> 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

Reply via email to