You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (Jira)" <ji...@apache.org> on 2020/08/26 04:22:00 UTC
[jira] [Assigned] (HIVE-24074) Incorrect handling of timestamp in
Parquet/Avro when written in certain time zones in versions before Hive 3.x
[ 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)