[
https://issues.apache.org/jira/browse/HIVE-21094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karen Coppage updated HIVE-21094:
---------------------------------
Attachment: HIVE-21094.1.patch
Status: Patch Available (was: Open)
> 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
> Attachments: HIVE-21094.1.patch, HIVE-21094.1.patch,
> HIVE-21094.1.patch, HIVE-21094.1.patch
>
>
> 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 should not display the reader's time zone.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
