Unfortunately, hive does not yet support those data types. I'll update the wiki. Could you use a string instead?
If you're using trunk, you should have seen a different error message... see https://issues.apache.org/jira/browse/HIVE-1059 -----Original Message----- From: Edward Capriolo [mailto:[email protected]] Sent: Wednesday, January 27, 2010 11:50 AM To: [email protected] Subject: question about DATE datatype So I have a bug (im using trunk so hard to say if its a regression or if its fixed yet) hive> create table a_test(id date); FAILED: Error in metadata: java.lang.IllegalArgumentException: Error: type expected at the position 0 of 'date' but 'date' is found. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Is the comment here correct? http://issues.apache.org/jira/browse/HIVE-814 because according to the language manual (http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL) date should be acceptable as a column type not just a partition type. Edward
