[
https://issues.apache.org/jira/browse/HIVE-24074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez reassigned HIVE-24074:
----------------------------------------------
> 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
> Priority: Major
>
> 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)
