Results of applications that cast numerics to timestamps differ from Hive 2 to Hive 3. Apache Hive changed the behavior of CAST to comply with the SQL Standard, which does not associate a time zone with the TIMESTAMP type.
Before Upgrade to CDP
> SELECT CAST(1597217764557 AS TIMESTAMP); | 2020-08-12 00:36:04 |
After Upgrade to CDP
> SELECT CAST(1597217764557 AS TIMESTAMP); | 2020-08-12 07:36:04.557 |
Change applications. Do not cast from a numeral to obtain a local time zone.
to_utc_timestamp can be used to mimic behavior before the