Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12191 Hive timestamp problems
  3. HIVE-12194

Daylight savings zones are not recognized (PDT, MDT)

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.1.1
    • Fix Version/s: None
    • Component/s: Hive
    • Labels:

      Description

      When I call the from_utc_timestamp function (or to_utc_timestamp) using my current time zone, the result is incorrect:

      // CURRENT SERVER TIME ZONE IS PDT
      hive> select to_utc_timestamp('2015-10-13 09:15:34.101', 'PDT');
      2015-10-13 09:15:34.101 // NOT CHANGED!
      hive> select to_utc_timestamp('2015-10-13 09:15:34.101', 'PST');
      2015-10-13 16:15:34.101 // CORRECT VALUE FOR PST
      

      UPDATE: It appears that happens because the daylight savings zones are not recognized.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                rdblue Ryan Blue
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: