Hi,
I'm trying to execute following script, but DB answers about syntax error near "(", I just can't find mistake
, it don't even say which string is bad.
CREATE TABLE "AUTOTEST"."D2V_RT_ALL_TYPES_2"
("S_SMALLINT" INTEGER(8),
"S_INTEGER" INTEGER(8) NOT NULL,
"S_BIGINT" INTEGER,
"S_DECIMAL" NUMERIC(10, 2),
"S_REAL" FLOAT,
"S_DOUBLE" FLOAT,
"S_CHAR" CHAR(100),
"S_VARCHAR" VARCHAR(2000),
"S_CLOB" VARCHAR(65000),
"S_GRAPHIC" CHAR(400),
"S_VARGRAPHIC" VARCHAR(2000),
"S_DBCLOB" VARCHAR(65000),
"S_BLOB" VARBINARY(65000),
"S_DATE" DATE,
"S_TIME" TIME,
"S_TIMESTAMP" TIMESTAMP,
"S_LONG_VARCHAR" VARCHAR(65000),
"S_LONG_VARGRAPHIC" VARCHAR(32700),
PRIMARY KEY ("S_INTEGER")
)segmented BY hash ("S_INTEGER") all nodes
DBCException: SQL Error [4856] [42601]: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "("
SQLException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "("
com.vertica.util.ServerException: ServerException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "("