[HIVE-814] exception alter a int typed column to date/datetime/timestamp

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Release Note: Addressed by HIVE-1059
• Assignee: Unassigned
• Reporter: Min Zhou
• Created: 04/Sep/09 02:04
• Updated: 18/Oct/10 03:18
• Resolved: 18/Oct/10 03:18

Description

As fas as i know, time types can only be used in partitions, normal columns is not allowed to be set as those types . But it's found can alter a no time types column to date/datetime/timestamp,but exceptions will be throwed when describing.

hive> create table pokes(foo int, bar string);
OK
Time taken: 0.894 seconds
hive> alter table pokes replace columns(foo date, bar string);
OK
Time taken: 0.266 seconds

hive> describe pokes;
FAILED: Error in metadata: MetaException(message:java.lang.IllegalArgumentException Error: type expected at the position 0 of 'date:string' but 'date' is found.)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Issue Links

• relates to: HIVE-1269 Support Date/Datetime/Time/Timestamp Primitive Types