我试图在InfiniDB中创建此表:
CREATE TABLE dimension.date (
date_id int(8), -- 20120512
`date` date, -- 2012-05-12
day tinyint, -- 12
day_of_week tinyint, -- 6 (sunday being 0)
weekday varchar(10), -- Saturday
week tinyint,
month tinyint,
month_name varchar(20),
quarter tinyint,
year smallint
) ENGINE=infinidb;
它给我提供了这个错误:
Error Code: 138. The syntax or the data type(s) is not supported by
InfiniDB. Please check the InfiniDB syntax guide for supported syntax
or data types.
然而,可以毫无问题地创建此表:
CREATE TABLE dimension.time (
time_id smallint(4),
time_12 char(4), -- e.g. 12:15
time_24 char(4), -- e.g. 00:15
hour tinyint,
minute tinyint,
period char(2) -- AM or PM
) ENGINE=infinidb;
我甚至试过创建它,但它产生了与上面相同的错误:
CREATE TABLE dimension.date (date_id int(8)) ENGINE=infinidb;
有任何想法吗?