[
https://issues.apache.org/jira/browse/HIVE-21067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrey Zinovyev updated HIVE-21067:
-----------------------------------
Description:
In previous versions (at least in 1.2) we had
{{> SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");}}
{{ 1545692453}}
Now it is
{{ > SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");}}
{{1545703253 }}
We're in +3 timezone (Europe/Moscow)
This changes was made in HIVE-12192. I don't know if it was intentional, but
according to
[wiki|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions]
unix_timestamp should use default timezone
was:
In previous versions (at least in 1.2) we had
hive> SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");
OK
1545692453
Now it is
> SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");
...
INFO : OK
+-------------+
| _c0 |
+-------------+
| 1545703253 |
+-------------+
We're in +3 timezone (Europe/Moscow)
This changes was made in HIVE-12192. I don't know if it was intentional, but
according to
[wiki|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions]
unix_timestamp should use default timezone
> TO_UNIX_TIMESTAMP (or UNIX_TIMESTAMP) treats argument timestamp as UTC
> ----------------------------------------------------------------------
>
> Key: HIVE-21067
> URL: https://issues.apache.org/jira/browse/HIVE-21067
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.1.0
> Reporter: Andrey Zinovyev
> Priority: Minor
>
> In previous versions (at least in 1.2) we had
> {{> SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");}}
> {{ 1545692453}}
> Now it is
> {{ > SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");}}
> {{1545703253 }}
> We're in +3 timezone (Europe/Moscow)
> This changes was made in HIVE-12192. I don't know if it was intentional, but
> according to
> [wiki|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions]
> unix_timestamp should use default timezone
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
