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.

Reply via email to