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)
