[
https://issues.apache.org/jira/browse/ORC-1053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Varun Raval updated ORC-1053:
-----------------------------
Description:
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
was:
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 is 0001-01-03 00:00:00
If converted using Java tool, value read is 0001-01-02 23:56:02.0
> 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
> Priority: Major
>
> 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)
