[ https://issues.apache.org/jira/browse/HIVE-814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach resolved HIVE-814. --------------------------------- Resolution: Won't Fix Fix Version/s: (was: 0.6.0) (was: 0.5.0) > exception alter a int typed column to date/datetime/timestamp > ------------------------------------------------------------- > > Key: HIVE-814 > URL: https://issues.apache.org/jira/browse/HIVE-814 > Project: Hadoop Hive > Issue Type: Bug > Reporter: Min Zhou > > 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 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.