Member since
12-12-2018
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
13260 | 12-13-2018 11:12 PM |
12-13-2018
11:12 PM
It was confirmed as a bug - https://issues.apache.org/jira/browse/HIVE-21039
... View more
12-13-2018
04:51 AM
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 | +--------------------------+
... View more
Labels: