question about DATE datatype

[Edward Capriolo <ed...@gmail.com>]

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

RE: question about DATE datatype

[Paul Yang <py...@facebook.com>]

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:edlinuxguru@gmail.com] 
Sent: Wednesday, January 27, 2010 11:50 AM
To: hive-dev@hadoop.apache.org
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