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

Incorrect output timestamp from from_utc_timestamp()/to_utc_timestamp when local timezone has DST

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.0.0
    • None
    • UDF

    Description

      HIVE-12706 is resolved but there is still a bug in this - from_utc_timestamp() is interpreting a GMT timestamp with DST.
      HS2 on PST timezone:
      GMT timestamp PST timestamp PST 2GMT
      2012-03-11 01:30:15.332 2012-03-10 17:30:15.332 2012-03-11 01:30:15.332
      2012-03-11 02:30:15.332 2012-03-10 19:30:15.332 2012-03-11 03:30:15.332 (<--- We got 1 hour more on GMT)
      PSTtimestap is generated using from_utc_timestamp('2012-03-11 02:30:15.332', 'PST')
      PST2GMT timestamp is generated using to_utc_timestamp(from_utc_timestamp('2012-03-11 02:30:15.332', 'PST'), 'PST')

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              leelakrishna.k@gmail.com Leela Krishna
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: