[ https://issues.apache.org/jira/browse/IMPALA-6763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong updated IMPALA-6763: ---------------------------------- Component/s: Backend > 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) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org