[jira] [Updated] (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
]
Stamatis Zampetakis updated HIVE-24074:
---
Labels: compatibility pull-request-available timestamp (was:
pull-request-available)
> 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
> Labels: compatibility, pull-request-available, timestamp
> Fix For: 4.0.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
[jira] [Updated] (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 updated HIVE-24074:
---
Fix Version/s: 4.0.0
Resolution: Fixed
Status: Resolved (was: Patch Available)
Pushed to master.
> 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
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
[jira] [Updated] (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
]
ASF GitHub Bot updated HIVE-24074:
--
Labels: pull-request-available (was: )
> 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
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
[jira] [Updated] (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 updated HIVE-24074:
---
Status: Patch Available (was: Open)
> 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)
[jira] [Updated] (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 updated HIVE-24074:
---
Description: 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 (was: 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)
> 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)
