[
https://issues.apache.org/jira/browse/HIVE-18974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16405762#comment-16405762
]
Rui Li commented on HIVE-18974:
-------------------------------
Could be the same issue as HIVE-14305. Does the machine's system timezone use
DST?
> Wrong UTC time while converting from CST by to_utc_timestamp UDFs
> ------------------------------------------------------------------
>
> Key: HIVE-18974
> URL: https://issues.apache.org/jira/browse/HIVE-18974
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 1.2.1
> Reporter: swayam
> Assignee: Hive QA
> Priority: Critical
>
> {color:#FF0000}Error on Daylight Saving 2017{color}
>
> select to_utc_timestamp("2017-03-11 19:00:00",'CST');
> OK
> 2017-03-12 01:00:00 --> expected 6 hr difference
> Time taken: 0.08 seconds, Fetched: 1 row(s)
> hive> select to_utc_timestamp("2017-03-11 20:00:00",'CST');
> OK
> 2017-03-12 03:00:00 --> wrong 7 hr difference
> Time taken: 0.088 seconds, Fetched: 1 row(s)
> hive> select to_utc_timestamp("2017-03-11 21:00:00",'CST');
> OK
> 2017-03-12 04:00:00--> wrong 7 hr difference
> Time taken: 2.884 seconds, Fetched: 1 row(s)
> hive> select to_utc_timestamp("2017-03-11 22:00:00",'CST');
> OK
> 2017-03-12 05:00:00--> wrong 7 hr difference
> Time taken: 0.075 seconds, Fetched: 1 row(s)
> hive> select to_utc_timestamp("2017-03-11 23:00:00",'CST');
> OK
> 2017-03-12 06:00:00 --> wrong 7 hr difference
> Time taken: 0.068 seconds, Fetched: 1 row(s)
> hive> select to_utc_timestamp("2017-03-12 00:00:00",'CST');
> OK
> 2017-03-12 07:00:00 --> wrong 7 hr difference
> Time taken: 4.769 seconds, Fetched: 1 row(s)
> hive> select to_utc_timestamp("2017-03-12 01:00:00",'CST');
> OK
> 2017-03-12 08:00:00 --> wrong 7 hr difference
> Time taken: 0.066 seconds, Fetched: 1 row(s)
> hive> select to_utc_timestamp("2017-03-12 02:00:00",'CST');
> OK
> 2017-03-12 08:00:00 --> wrong 7 hr difference
> Time taken: 0.066 seconds, Fetched: 1 row(s)
> hive> select to_utc_timestamp("2017-03-12 03:00:00",'CST');
> OK
> 2017-03-12 08:00:00 --> expected 5 hr
> Time taken: 0.061 seconds, Fetched: 1 row(s)
> hive> select to_utc_timestamp("2017-03-12 04:00:00",'CST');
> OK
> 2017-03-12 09:00:00--> expected 5 hr
> Time taken: 0.065 seconds, Fetched: 1 row(s)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
