[jira] [Created] (HIVE-8746) ORC timestamp columns are sensitive to daylight savings time

["Owen O'Malley (JIRA)" <ji...@apache.org>]

Owen O'Malley created HIVE-8746:
-----------------------------------

             Summary: ORC timestamp columns are sensitive to daylight savings time
                 Key: HIVE-8746
                 URL: https://issues.apache.org/jira/browse/HIVE-8746
             Project: Hive
          Issue Type: Bug
            Reporter: Owen O'Malley
            Assignee: Owen O'Malley


Hive uses Java's Timestamp class to manipulate timestamp columns. Unfortunately the textual parsing in Timestamp is done in local time and the internal storage is in UTC.

ORC mostly side steps this issue by storing the difference between the time and a base time also in local and storing that difference in the file. Reading the file between timezones will mostly work correctly "2014-01-01 12:34:56" will read correctly in every timezone.

However, when moving between timezones with different daylight saving it creates trouble. In particular, moving from a computer in PST to UTC will read "2014-06-06 12:34:56" as "2014-06-06 11:34:56".



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)