CLOB and BLOB support
Posted: 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.
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?