You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Thomas Scott (JIRA)" <ji...@apache.org> on 2017/09/25 13:46:00 UTC
[jira] [Created] (IMPALA-5978) DST is handlied incorrectly for EET
Thomas Scott created IMPALA-5978:
------------------------------------
Summary: DST is handlied 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: Minor
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
(v6.4.14#64029)