[IMPALA-4209] Incorrect timezone conversion with 'from_utc_timestamp' function in Impala

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 1.3.1, Impala 1.4
• Fix Version/s: Impala 1.4
• Component/s: Backend
• Assignee: Unassigned
• Reporter: Lars Volker
• Created: 28/Sep/16 15:13
• Updated: 28/Sep/16 16:24
• Resolved: 28/Sep/16 15:14

Description

Europe/Moscow' timezone is GMT+4 (no daylight time saving since 20111),
so expect to see "2014-02-14 20:21:01" as the result of the second query.

select from_utc_timestamp(cast(1392394861 as timestamp), 'Europe/London');
Query: select from_utc_timestamp(cast(1392394861 as timestamp), 'Europe/London')
--------------------------------------------------------------------

from_utc_timestamp(cast(1392394861 as timestamp), 'europe/london')

--------------------------------------------------------------------

2014-02-14 16:21:01

--------------------------------------------------------------------
Returned 1 row(s) in 0.21s

select from_utc_timestamp(cast(1392394861 as timestamp), 'Europe/Moscow');
Query: select from_utc_timestamp(cast(1392394861 as timestamp), 'Europe/Moscow')
--------------------------------------------------------------------

from_utc_timestamp(cast(1392394861 as timestamp), 'europe/moscow')

--------------------------------------------------------------------

2014-02-14 19:21:01

--------------------------------------------------------------------
Returned 1 row(s) in 0.12s