Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5978

DST is handled incorrectly for EET

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Backend
    • Labels:
    • Epic Color:
      ghx-label-4

      Description

      DST happens at 04:00 for the EET timezone but Impala is applying the change from 00:00. This can be reproduced with the following query:

      select '2017-10-28 21:00:00' UTC_TIME, from_utc_timestamp('2017-10-28 21:00:00', 'EET') converted_EET, '2017-10-29 00:00:00' correct_EET
      union all
      select '2017-10-28 22:00:00', from_utc_timestamp('2017-10-28 22:00:00', 'EET'), '2017-10-29 01:00:00'
      union all
      select '2017-10-28 23:00:00', from_utc_timestamp('2017-10-28 23:00:00', 'EET'), '2017-10-29 02:00:00'
      union all
      select '2017-10-29 00:00:00', from_utc_timestamp('2017-10-29 00:00:00', 'EET'), '2017-10-29 03:00:00'
      union all
      select '2017-10-29 01:00:00', from_utc_timestamp('2017-10-29 01:00:00', 'EET'), '2017-10-29 03:00:00'
      union all
      select '2017-10-29 02:00:00', from_utc_timestamp('2017-10-29 02:00:00', 'EET'), '2017-10-29 04:00:00'
      union all
      select '2017-10-29 03:00:00', from_utc_timestamp('2017-10-29 03:00:00', 'EET'), '2017-10-29 05:00:00';

      Yielding:

      utc_time converted_eet correct_eet
      2017-10-28 21:00:00 2017-10-29 00:00:00 2017-10-29 00:00:00
      2017-10-28 22:00:00 2017-10-29 00:00:00 2017-10-29 01:00:00
      2017-10-28 23:00:00 2017-10-29 01:00:00 2017-10-29 02:00:00
      2017-10-29 00:00:00 2017-10-29 02:00:00 2017-10-29 03:00:00
      2017-10-29 01:00:00 2017-10-29 03:00:00 2017-10-29 03:00:00
      2017-10-29 02:00:00 2017-10-29 04:00:00 2017-10-29 04:00:00
      2017-10-29 03:00:00 2017-10-29 05:00:00 2017-10-29 05:00:00

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                attilaj Attila Jeges
                Reporter:
                tscott@cloudera.com Thomas Scott
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: