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

from_utc_timestamp()/to_utc_timestamp return incorrect results with EST

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Not A Problem
    • None
    • None
    • UDF
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: