[jira] [Resolved] (ORC-1053) Timestamp values read in Hive are different when using ORC file created using CSV to ORC converter tools

["Dongjoon Hyun (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ORC-1053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dongjoon Hyun resolved ORC-1053.
--------------------------------
    Fix Version/s: 1.7.2
         Assignee: Yiqun Zhang
       Resolution: Fixed

This is resolved via https://github.com/apache/orc/pull/967

[~vraval48], could you test `main` or `branch-1.7` in your environment?

> Timestamp values read in Hive are different when using ORC file created using CSV to ORC converter tools
> --------------------------------------------------------------------------------------------------------
>
>                 Key: ORC-1053
>                 URL: https://issues.apache.org/jira/browse/ORC-1053
>             Project: ORC
>          Issue Type: Bug
>          Components: C++, Java
>            Reporter: Varun Raval
>            Assignee: Yiqun Zhang
>            Priority: Major
>             Fix For: 1.7.2
>
>         Attachments: converted_by_cpp.orc, converted_by_hive.orc, converted_by_java.orc, hive_table_desc.jpg, timestamp.csv
>
>
> I have a CSV file that has a column having timestamp values as 0001-01-01 00:00:00.0. Then I convert CSV file to ORC file using CSV to ORC converter and place the ORC file in a hive table backed by ORC files. On querying the data using Hive beeline and Spark SQL, different results are obtained
> If converted using CPP tool, value read using Hive beeline and Spark SQL queries is 0001-01-03 00:00:00
> If converted using Java tool, value read using Hive beeline and Spark SQL queries is 0001-01-02 23:56:02.0



--
This message was sent by Atlassian Jira
(v8.20.1#820001)