[ORC-1055] [C++] Timestamp values read in Hive are different when using ORC file created using CSV to ORC converter tools

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.7.3
• Fix Version/s: 1.7.3
• Component/s: C++
• Assignee: ZhangXin
• Reporter: Yiqun Zhang
• Created: 03/Dec/21 07:49
• Updated: 17/Mar/22 07:34
• Resolved: 17/Mar/22 07:33

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

Reported by vraval48

Issue Links

• is related to: ORC-1053 Timestamp values read in Hive are different when using ORC file created using CSV to ORC converter tools
• links to: GitHub Pull Request #975