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

to_utc_timestamp blank value

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Won't Fix
    • Impala 2.3.0, Impala 2.5.0, Impala 2.4.0
    • Not Applicable
    • Backend
    • None
    • Cloudera CDH 5.5.2

    Description

      When is called the function for convertion date from daylight saving time to legal time (i.e. CEST to CET) the function returns wrong (blank) value for '2015-10-25 01:00:01'.
      The correct vaule will be '2015-10-24 23:00:01'

      Code to reproduce:
      select
      to_utc_timestamp(cast('2015-10-25 00:00:01' as timestamp),'CET') ,
      to_utc_timestamp(cast('2015-10-25 01:00:01' as timestamp),'CET') ,
      to_utc_timestamp(cast('2015-10-25 02:00:01' as timestamp),'CET') ,
      to_utc_timestamp(cast('2015-10-25 03:00:01' as timestamp),'CET')

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              bagnil_impala_e4d7 Lorenzo Bagni
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: