Found ERROR 5599 On Vertica 7.1

Said_Montiel

I have a pseudosuperuser rank in the Vertica DB I am using. I want to create some tables to experiment with the LONG VARCHAR type capabilities and constraints.

However, when I ran the following query

CREATE TABLE IF NOT EXISTS dataset (col0 FLOAT, col1 VARCHAR(255), col2 TIMESTAMP, col3 LONG VARCHAR);

I got back this error

[Vertica][VJDBC](5599) ERROR: Invalid or unavailable type 'LONG VARCHAR' [SQL State=22023, DB Errorcode=5599] 



Even setting a specific LONG VARCHAR size the same error occurs. How can I solve this? Any ideas?

marcothesane

Hi Said -

I don't exactly know where your problem is - in Vertica 7.1, I ran this statement - and you can see the result just below:

SQL>create table foo (
id int not null, longvarchar long varchar(128000), primary key(id)
);
table created
SQL>

Said_Montiel

Sorry that was a mistake on my part, the version installed is 6.1 not 7.1... let me find the edit button

DISCLAIMER:
Installed version is Vertica 6.1, NOT 7.1

UPDATE:
There is no EDIT button for the main topic.

R_McKeon

Hello Said,

What value are you giving col3 LONG VARCHAR when you attempt to create the table? Can you give us the exact command you're running?

Thanks,
Rory

Said_Montiel

Hi Rory,

I am using the following statements with the same output ERROR.

CREATE TABLE dataset (id VARCHAR(255), value LONG VARCHAR);

CREATE TABLE dataset (id VARCHAR(255), value LONG VARCHAR (1000000));

Thanks for your help,




UPDATE:

I found this link

http://my.vertica.com/docs/6.1.x/HTML/index.htm#1231.htm 
Which doesn't include LONG type variables. I guess that means that LONG VARCHAR (and LONG Varbinary) are available only in 7.x.x
Sorry for the inconvenience.

R_McKeon

Hello Said,

Thanks for the update. Yes, I found the same information. LONG VARCHAR was introduced in 7.x. You can use VARCHAR up to 65000 with your Vertica 6.1 version.

Thanks,
Rory