[
https://issues.apache.org/jira/browse/HIVE-23345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marta Kuczora updated HIVE-23345:
---------------------------------
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
> INT64 Parquet timestamps cannot be read into bigint Hive type
> -------------------------------------------------------------
>
> Key: HIVE-23345
> URL: https://issues.apache.org/jira/browse/HIVE-23345
> Project: Hive
> Issue Type: Bug
> Affects Versions: 4.0.0
> Reporter: Marta Kuczora
> Assignee: Marta Kuczora
> Priority: Major
>
> 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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
