You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/10/23 21:36:00 UTC
[jira] [Resolved] (IMPALA-5978) DST is handled incorrectly for EET
[ https://issues.apache.org/jira/browse/IMPALA-5978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-5978.
-----------------------------------
Resolution: Duplicate
Fixed by using the standard IANA DB
> DST is handled incorrectly for EET
> ----------------------------------
>
> Key: IMPALA-5978
> URL: https://issues.apache.org/jira/browse/IMPALA-5978
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Reporter: Thomas Scott
> Priority: Critical
> Labels: correctness
>
> DST happens at 04:00 for the EET timezone but Impala is applying the change from 00:00. This can be reproduced with the following query:
> select '2017-10-28 21:00:00' UTC_TIME, from_utc_timestamp('2017-10-28 21:00:00', 'EET') converted_EET, '2017-10-29 00:00:00' correct_EET
> union all
> select '2017-10-28 22:00:00', from_utc_timestamp('2017-10-28 22:00:00', 'EET'), '2017-10-29 01:00:00'
> union all
> select '2017-10-28 23:00:00', from_utc_timestamp('2017-10-28 23:00:00', 'EET'), '2017-10-29 02:00:00'
> union all
> select '2017-10-29 00:00:00', from_utc_timestamp('2017-10-29 00:00:00', 'EET'), '2017-10-29 03:00:00'
> union all
> select '2017-10-29 01:00:00', from_utc_timestamp('2017-10-29 01:00:00', 'EET'), '2017-10-29 03:00:00'
> union all
> select '2017-10-29 02:00:00', from_utc_timestamp('2017-10-29 02:00:00', 'EET'), '2017-10-29 04:00:00'
> union all
> select '2017-10-29 03:00:00', from_utc_timestamp('2017-10-29 03:00:00', 'EET'), '2017-10-29 05:00:00';
> Yielding:
> utc_time converted_eet correct_eet
> 2017-10-28 21:00:00 2017-10-29 00:00:00 2017-10-29 00:00:00
> 2017-10-28 22:00:00 2017-10-29 00:00:00 2017-10-29 01:00:00
> 2017-10-28 23:00:00 2017-10-29 01:00:00 2017-10-29 02:00:00
> 2017-10-29 00:00:00 2017-10-29 02:00:00 2017-10-29 03:00:00
> 2017-10-29 01:00:00 2017-10-29 03:00:00 2017-10-29 03:00:00
> 2017-10-29 02:00:00 2017-10-29 04:00:00 2017-10-29 04:00:00
> 2017-10-29 03:00:00 2017-10-29 05:00:00 2017-10-29 05:00:00
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org