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.