You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Karen Coppage (JIRA)" <ji...@apache.org> on 2019/01/07 13:30:00 UTC

[jira] [Assigned] (HIVE-21094) Store TIMESTAMP WITH LOCAL TIME ZONE in UTC instead of writer's time zone

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

Karen Coppage reassigned HIVE-21094:
------------------------------------


> Store TIMESTAMP WITH LOCAL TIME ZONE in UTC instead of writer's time zone
> -------------------------------------------------------------------------
>
>                 Key: HIVE-21094
>                 URL: https://issues.apache.org/jira/browse/HIVE-21094
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive
>            Reporter: Karen Coppage
>            Assignee: Karen Coppage
>            Priority: Major
>
> TIMESTAMP WITH LOCAL TIME ZONE (aka TIMESTAMPTZ) is stored in writer's local time, and the writer's zone is stored with it. When reading, the timestamp in reader local time + reader zone is displayed. This is misleading for the user, since it looks like all the data was written in the reader's time zone.
> TIMESTAMPTZ should be stored in UTC time and be displayed in reader local time (as it was before) but without the reader's time zone.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)