[
https://issues.apache.org/jira/browse/IMPALA-6763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong resolved IMPALA-6763.
-----------------------------------
Resolution: Cannot Reproduce
IMPALA-3307 fixed a lot of issues with timezone database errors. Note that CDT
and PDT are not supported timezones now..
> to_utc_timestamp() doesn't consider daylight saving for all timezones
> ---------------------------------------------------------------------
>
> Key: IMPALA-6763
> URL: https://issues.apache.org/jira/browse/IMPALA-6763
> Project: IMPALA
> Issue Type: Improvement
> Components: Backend
> Affects Versions: Impala 2.9.0, Impala 2.10.0, Impala 2.11.0
> Reporter: Mala Chikka Kempanna
> Priority: Major
>
> to_utc_timestamp does not consider daylight savings for all timezones shown
> in below example.
> Query-
> {code}
> with t as (select current_timestamp() as rightnow),
> t1 as (select rightnow,
> to_utc_timestamp(rightnow, 'PDT') as utc_ts
> from t)
> select t1.rightnow, t1.utc_ts,
> from_utc_timestamp(utc_ts, 'PST') as pst_ts,
> from_utc_timestamp(utc_ts, 'PDT') as pdt_ts,
> from_utc_timestamp(utc_ts, 'MST') as mst_ts,
> from_utc_timestamp(utc_ts, 'MDT') as mdt_ts,
> from_utc_timestamp(utc_ts, 'CST') as cst_ts,
> from_utc_timestamp(utc_ts, 'CDT') as cdt_ts,
> from_utc_timestamp(utc_ts, 'EST') as est_ts,
> from_utc_timestamp(utc_ts, 'EDT') as edt_ts,
> from t1
> order by 1;
> {code}
>
>
> {code:java}
> impalad version 2.9.0-cdh5.12.1
> +-------------------------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+
> | rightnow | now_int | utc_ts | pst_ts | pdt_ts | mst_ts | mdt_ts | cst_ts |
> cdt_ts | est_ts | edt_ts | chicago_ts | az_ts | in_ts | in_knox_ts |
> +-------------------------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+
> | 2018-03-28 14:02:21.210465000 | 1522245741 | 2018-03-28 19:02:21.210465000
> | 2018-03-28 12:02:21.210465000 | 2018-03-28 12:02:21.210465000 | 2018-03-28
> 12:02:21.210465000 | 2018-03-28 13:02:21.210465000 | 2018-03-28
> 14:02:21.210465000 | 2018-03-28 13:02:21.210465000 | 2018-03-28
> 14:02:21.210465000 | 2018-03-28 15:02:21.210465000 | 2018-03-28
> 14:02:21.210465000 | 2018-03-28 12:02:21.210465000 | 2018-03-28
> 15:02:21.210465000 | 2018-03-28 14:02:21.210465000 |
> +-------------------------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+
> impalad version 2.10.0-cdh5.13.x
> +-------------------------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+
> | rightnow | now_int | utc_ts | pst_ts | pdt_ts | mst_ts | mdt_ts | cst_ts |
> cdt_ts | est_ts | edt_ts | chicago_ts | az_ts | in_ts | in_knox_ts |
> +-------------------------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+
> | 2018-03-28 14:19:38.978262000 | 1522246778 | 2018-03-28 19:19:38.978262000
> | 2018-03-28 12:19:38.978262000 | 2018-03-28 12:19:38.978262000 | 2018-03-28
> 12:19:38.978262000 | 2018-03-28 13:19:38.978262000 | 2018-03-28
> 14:19:38.978262000 | 2018-03-28 13:19:38.978262000 | 2018-03-28
> 14:19:38.978262000 | 2018-03-28 15:19:38.978262000 | 2018-03-28
> 14:19:38.978262000 | 2018-03-28 12:19:38.978262000 | 2018-03-28
> 15:19:38.978262000 | 2018-03-28 14:19:38.978262000 |
> +-------------------------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+
> impalad version 2.11.0-cdh5.14.x
> +-------------------------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+
> | rightnow | now_int | utc_ts | pst_ts | pdt_ts | mst_ts | mdt_ts | cst_ts |
> cdt_ts | est_ts | edt_ts | chicago_ts | az_ts | in_ts | in_knox_ts |
> +-------------------------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+
> | 2018-03-28 14:22:03.744552000 | 1522246923 | 2018-03-28 19:22:03.744552000
> | 2018-03-28 12:22:03.744552000 | 2018-03-28 12:22:03.744552000 | 2018-03-28
> 12:22:03.744552000 | 2018-03-28 13:22:03.744552000 | 2018-03-28
> 14:22:03.744552000 | 2018-03-28 13:22:03.744552000 | 2018-03-28
> 14:22:03.744552000 | 2018-03-28 15:22:03.744552000 | 2018-03-28
> 14:22:03.744552000 | 2018-03-28 12:22:03.744552000 | 2018-03-28
> 15:22:03.744552000 | 2018-03-28 14:22:03.744552000 |
> +-------------------------------+------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+
>
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
