hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rui Li (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-14412) Add a timezone-aware timestamp
Date Wed, 21 Sep 2016 14:02:21 GMT

     [ https://issues.apache.org/jira/browse/HIVE-14412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

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
(v6.3.4#6332)

Mime
View raw message