[
https://issues.apache.org/jira/browse/IMPALA-5978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong reassigned IMPALA-5978:
-------------------------------------
Assignee: Attila Jeges
> 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
> Assignee: Attila Jeges
> 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: [email protected]
For additional commands, e-mail: [email protected]
