[ 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)