Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-14161

from_utc_timestamp()/to_utc_timestamp return incorrect results with EST

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UDF
    • Labels:
      None

      Description

      hive> SELECT to_utc_timestamp('2016-06-30 06:00:00', 'PST'); 
      OK
      2016-06-30 13:00:00  ==>Correct, UTC is 7 hours ahead of PST
      Time taken: 1.674 seconds, Fetched: 1 row(s)
      hive> SELECT to_utc_timestamp('2016-06-30 08:00:00', 'CST');
      OK
      2016-06-30 13:00:00  ==>Correct, UTC is 5 hours ahead of CST
      Time taken: 1.776 seconds, Fetched: 1 row(s)
      hive> SELECT to_utc_timestamp('2016-06-30 09:00:00', 'EST');
      OK
      2016-06-30 14:00:00  ==>Wrong, UTC should be 4 hours ahead of EST
      Time taken: 1.686 seconds, Fetched: 1 row(s)
      hive> select from_utc_timestamp('2016-06-30 14:00:00', 'EST');
      OK
      2016-06-30 09:00:00  ==>Wrong, UTC should be 4 hours ahead of EST
      

      It might be something related to daylight savings time.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ctang Chaoyu Tang
                Reporter:
                ctang Chaoyu Tang
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: