You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Mala Chikka Kempanna (JIRA)" <ji...@apache.org> on 2018/03/28 22:43:00 UTC
[jira] [Created] (IMPALA-6763) to_utc_timestamp() doesn't consider
daylight saving for all timezone
Mala Chikka Kempanna created IMPALA-6763:
--------------------------------------------
Summary: to_utc_timestamp() doesn't consider daylight saving for all timezone
Key: IMPALA-6763
URL: https://issues.apache.org/jira/browse/IMPALA-6763
Project: IMPALA
Issue Type: Improvement
Reporter: Mala Chikka Kempanna
to_utc_timestamp does not consider daylight savings for all timezones shown in below example.
{code}
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
(v7.6.3#76005)