Skip to main content

Found ERROR 5599 On Vertica 7.1

  • November 12, 2014
  • 5 replies
  • 18 views
Said_Montiel
Forum|alt.badge.img+1
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?

    5 replies

    marcothesane
    Forum|alt.badge.img+1
    • marcothesane
    • Participating Frequently
    • November 12, 2014

    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
    Forum|alt.badge.img+1
    • Said_Montiel
    • Author
    • Participating Frequently
    • November 12, 2014
    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
    Forum|alt.badge.img
    • R_McKeon
    • Participating Frequently
    • November 12, 2014
    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
    Forum|alt.badge.img+1
    • Said_Montiel
    • Author
    • Participating Frequently
    • November 12, 2014
    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
    Forum|alt.badge.img
    • R_McKeon
    • Participating Frequently
    • November 12, 2014
    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
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement