You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@orc.apache.org by "Varun Raval (Jira)" <ji...@apache.org> on 2021/11/29 20:54:00 UTC

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

Varun Raval created ORC-1053:
--------------------------------

             Summary: 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


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

Using CPP tool, value read is 0001-01-03 00:00:00

Using Java tool, value read is 0001-01-02 23:56:02.0



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