FROM_UNIXTIME and UNIX_TIMESTAMP time zone
The FROM_UNIXTIME and UNIX_TIMESTAMP functions have undergone more than one time zone change.
Before Upgrade to CDP
The functions supported the system time zone.
After Upgrade to CDP
The functions now support the user session time zone (HIVE-22170).