[
https://issues.apache.org/jira/browse/IMPALA-6699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabor Kaszab resolved IMPALA-6699.
----------------------------------
Resolution: Fixed
Fix Version/s: Impala 2.13.0
https://gerrit.cloudera.org/#/c/9724/
> Impala doesn't handle Australian Daylight saving time properly
> --------------------------------------------------------------
>
> Key: IMPALA-6699
> URL: https://issues.apache.org/jira/browse/IMPALA-6699
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 2.10.0, Impala 2.11.0
> Reporter: Gabor Kaszab
> Assignee: Gabor Kaszab
> Priority: Major
> Fix For: Impala 2.13.0
>
>
> In Australian, Daylight Saving Time begins at 2am on the first Sunday in
> October, when clocks are put forward one hour. It ends at 2am (which is 3am
> Daylight Saving Time) on the first Sunday in April, when clocks are put back
> one hour. [1]
> In Impala timezone database, be/src/exprs/timezone_db.cc, the DST end time of
> AEDT is defined to +2:00:00. In fact it should be +3:00:00. So the query
> "select to_utc_timestamp('2014-04-06 01:59:59','Australia/Melbourne')"
> returns NULL although we expect Impala return NULL when converting time
> between '2014-04-06 02:59:59' and '2014-04-06 02:59:59'.
> [1]
> [https://www.australia.gov.au/about-australia/facts-and-figures/time-zones-and-daylight-saving]
> Can we update Impala timezone database and replace "+2:00:00" with "+3:00:00"
> for DST end time of AEDT?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
