[
https://issues.apache.org/jira/browse/ORC-189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16397199#comment-16397199
]
Ryan Blue edited comment on ORC-189 at 3/13/18 4:26 PM:
--------------------------------------------------------
The Hive issue says Druid needs timestamp or [timestamp with local time
zone|https://docs.oracle.com/database/121/SUTIL/GUID-CB5D2124-D9AE-4C71-A83D-DFE071FE3542.htm].
That includes a zone offset, which isn't required for timestamp with time
zone, which is simply converted to UTC and then stored. Is timestamp with local
time zone what was intended on that issue, and is that what will be added to
ORC? ORC could represent both with the same format, but it would make little
sense to store a zone offset for timestamp with time zone because it would
always be UTC.
was (Author: rdblue):
The Hive issue says Druid needs timestamp or [timestamp with local time
zone|[https://docs.oracle.com/database/121/SUTIL/GUID-CB5D2124-D9AE-4C71-A83D-DFE071FE3542.htm].]
That includes a zone offset, which isn't required for timestamp with time
zone, which is simply converted to UTC and then stored. Is timestamp with local
time zone what was intended on that issue, and is that what will be added to
ORC? ORC could represent both with the same format, but it would make little
sense to store a zone offset for timestamp with time zone because it would
always be UTC.
> Add timestamp with timezone
> ---------------------------
>
> Key: ORC-189
> URL: https://issues.apache.org/jira/browse/ORC-189
> Project: ORC
> Issue Type: New Feature
> Reporter: Owen O'Malley
> Priority: Major
>
> Hive is adding a timestamp with timezone. We need to figure out the
> corresponding changes to ORC.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
