Created on 06-27-2021 07:10 AM - edited on 07-05-2021 02:06 AM by subratadas
As per HIVE-12192, by default, Hive displays timestamp in UTC. This article lists the Hive query commands that can be used to change the timestamp.
To display the current timestamp in Asia/Kolkata:
SELECT from_utc_timestamp(cast(from_unixtime(cast(current_timestamp() AS bigint)) as TIMESTAMP),"Asia/Kolkata")
To display a UNIX epoch number in Asia/Kolkata:
SELECT from_utc_timestamp(cast(from_unixtime(cast(1623943533 AS bigint)) as TIMESTAMP),"Asia/Kolkata") ;