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

to_utc_timestamp blank value

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Impala 2.3.0, Impala 2.5.0, Impala 2.4.0
    • Fix Version/s: None
    • Component/s: Backend
    • Labels:
      None
    • Environment:
      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

              • Assignee:
                Unassigned
                Reporter:
                bagnil_impala_e4d7 Lorenzo Bagni
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: