Storing images/CLOB objects in vertica?

[chethanm@hp.com]

Hi,
Any one can explain us how we can store image objects in vertica.

Thanks in advance for your help.

[JimKnicely]

Hello,

Vertica is an analytic database... In my opinion it doesn't make much sense to store image data in it. Preferably, you can store meta data about the image like type, size, files pointer, etc.

However, if you must, you can always store image data in a varchar column if your image is < the maximum size of a varchar which is 65,000 bytes. If your image is bigger than 65,000 bytes then you have to break the data into chunks that can fit into multiple varchar columns... You'll have to re-assemble the chunks when you query the data.

Keep in mind that if you are backing up tables containing a bunch of 65,000 byte columns your probably going to run into performance issues.

Hope this helps!