[IMPALA-3169] to_utc_timestamp blank value

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: Impala 2.3.0, Impala 2.5.0, Impala 2.4.0
• Fix Version/s: Not Applicable
• Component/s: Backend
• Environment: Cloudera CDH 5.5.2
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Lorenzo Bagni
• Created: 10/Mar/16 15:44
• Updated: 06/Apr/22 09:12
• Resolved: 06/Apr/22 09:12

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')

Issue Links

• depends upon: IMPALA-3307 add support for IANA time zone database
• is related to: IMPALA-5563 Timezone lookup may be ambiguous
• relates to: IMPALA-2546 Invalid time zones are ignored but should be rejected
• relates to: IMPALA-3307 add support for IANA time zone database