CURRENT_TIMESTAMP timezone in hive 3.1

andrey_zinovyev — Thu, 13 Dec 2018 12:51:20 GMT

Hi,

We're upgrading from hdp-2.6 to hdp-3.0.1 (from hive 1.2 to 3.1) and it seems like new hive returns CURRENT_TIMESTAMP in UTC timezone. But before it was in local (system's default) timezone.

According to HIVE-5472 current_timestamp should use user's local timezone. This behaviour was changed in HIVE-12192 (if I got it right). GenericUDFCurrentTimestamp now explicitly uses UTC as timezone to initialise org.apache.hadoop.hive.common.type.Timestamp

Is it some intentional change or some misconfiguration from on our side?

For example

Old hive:

hive> select current_timestamp;

OK 2018-12-12 22:43:39.024

New hive:

> select current_timestamp;

+--------------------------+ | _c0 | +--------------------------+

| 2018-12-12 19:43:57.024 |

+--------------------------+

Re: CURRENT_TIMESTAMP timezone in hive 3.1

andrey_zinovyev — Fri, 14 Dec 2018 07:12:45 GMT

It was confirmed as a bug - https://issues.apache.org/jira/browse/HIVE-21039

question Re: CURRENT_TIMESTAMP timezone in hive 3.1 in Archives of Support Questions (Read Only)

CURRENT_TIMESTAMP timezone in hive 3.1

Re: CURRENT_TIMESTAMP timezone in hive 3.1