CLOB and BLOB support

Moderator: NorbertKrupa

Post Reply
JeffSatler
Newbie
Newbie
Posts: 21
Joined: Mon Feb 13, 2012 9:44 pm

CLOB and BLOB support

Post by JeffSatler » Mon Feb 13, 2012 9:47 pm

Does Vertica support the CLOB and BLOB data types like in Oracle? I have several tables in an Oracle database with these data types and I'd like to copy them into Vertica.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: CLOB and BLOB support

Post by JimKnicely » Tue Feb 14, 2012 3:41 am

Vertica does not support the CLOB or BLOB data types.

It does support the data types CHARACTER (CHAR) and CHARACTER VARYING (VARCHAR). Each of these data types has a maximum length of 65000 bytes which is unfortunately a tad bit smaller than the 4 GB you can store in a CLOB in Oracle.

Maybe you can break up the data into chunks of text and store them as multiple rows in a blob-like table with ids linking the related chunks? Or dump the CLOB data into a text file and store the location and name in a table?
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: CLOB and BLOB support

Post by JimKnicely » Tue Jan 14, 2014 6:15 pm

FYI... Vertica 7 introduces the LONG VARCHAR and LONG VARBINARY data types!

See: viewtopic.php?f=63&t=1610
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica”