Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Duplicate
-
None
-
None
-
ghx-label-4
Description
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
Attachments
Issue Links
- duplicates
-
IMPALA-3307 add support for IANA time zone database
- Resolved
- relates to
-
IMPALA-3307 add support for IANA time zone database
- Resolved