Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Hive Alter column type

hello,

I am using hive 1.2.1.

I executed the following command to change the type of a column from timestamp to date

ALTER TABLE table_name CHANGE column_name column_name date CASCADE;

the command was executed successfully.

when i want to retrieve the data from the table using: select * from table_name

I got the following error:

Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.io.TimestampWritable cannot be cast to org.apache.hadoop.hive.serde2.io.DateWritable

thanks for help.

1 ACCEPTED SOLUTION

@Ahmed Missaoui

It has to do with the dataset in the table. Check if date has proper fields.

Good reference

View solution in original post

2 REPLIES 2

@Ahmed Missaoui

It has to do with the dataset in the table. Check if date has proper fields.

Good reference

Thanks a lot for your help.

Effectively, if the data was stored already with timetamp type and the we change the type, the select will not work and we will have the ClassCastException.

If no data was alreday stored with the timestamp type (all values are null) and then we change the type , the select works fine.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.