[HIVE-21039] CURRENT_TIMESTAMP returns value in UTC time zone

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.1
• Fix Version/s: 3.1.2, 3.2.0, 4.0.0-alpha-1
• Target Version/s: 3.1.2, 3.2.0, 4.0.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Andrey Zinovyev
• Created: 13/Dec/18 19:00
• Updated: 27/Feb/24 22:24
• Resolved: 21/Dec/18 19:43

Description

We're upgrading 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 .

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  |
+--------------------------+

Issue Links

• is related to: HIVE-25930 hive-3.1.1-current_timestamp时区差8小时修复代码