[HIVE-23345] INT64 Parquet timestamps cannot be read into bigint Hive type

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Panagiotis Garefalakis
• Reporter: Marta Kuczora
• Created: 30/Apr/20 14:25
• Updated: 17/Nov/22 08:50
• Resolved: 03/May/20 04:08

Description

How to reproduce:

• create external table ts_pq (ts timestamp) stored as parquet;
• insert into ts_pq values ('1998-10-03 09:58:31.231');
• create external table ts_pq_2 (ts bigint) stored as parquet location '<location of ts_pq>';
• select * from ts_pq_2;
  The following exception occurs during the select:
  Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.io.TimestampWritableV2 cannot be cast to org.apache.hadoop.io.LongWritable

Issue Links

• requires: HIVE-26612 INT64 Parquet timestamps cannot be read into BIGINT Hive type
• links to: GitHub Pull Request #1001