Karen Coppage created HIVE-21094:
------------------------------------
Summary: 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
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)
