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)
