CLOB and BLOB support
Moderator: NorbertKrupa
-
- Newbie
- Posts: 21
- Joined: Mon Feb 13, 2012 9:44 pm
CLOB and BLOB support
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.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: CLOB and BLOB support
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?
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: CLOB and BLOB support
FYI... Vertica 7 introduces the LONG VARCHAR and LONG VARBINARY data types!
See: viewtopic.php?f=63&t=1610
See: viewtopic.php?f=63&t=1610
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.