Jesus Camacho Rodriguez created HIVE-24074:
----------------------------------------------
Summary: Incorrect handling of timestamp in Parquet/Avro when
written in certain time zones in versions before Hive 3.x
Key: HIVE-24074
URL: https://issues.apache.org/jira/browse/HIVE-24074
Project: Hive
Issue Type: Bug
Components: Avro, Parquet
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
The timezone conversion for Parquet and Avro uses new {{java.time.*}} classes,
which can lead to incorrect values returned for certain dates in certain
timezones if timestamp was computed and converted based on {{java.sql.*}}
classes. For instance, the offset used for Singapore timezone in
1900-01-01T00:00:00.000 is UTC+8, while the correct offset for that date should
be UTC+6:55:25. Some additional information can be found here:
https://stackoverflow.com/a/52152315
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
