Page 1 of 1

Handling Large Objects, Data Greater than 32 MB

Posted: Wed Mar 21, 2018 11:48 am
by benbenten
Hi Everyone,

Vertica tables have a column size limit of 32MB. Even the Flex Table has this limitation. What would be the approach for handling data >32MB? Does Vertica provide a way to handle this without resulting to separating the data into multiple columns?

Thank you.

Re: Handling Large Objects, Data Greater than 32 MB

Posted: Mon Mar 26, 2018 3:24 pm
by JimKnicely
Hi,

There is a maximum row size of 32,768,000 bytes... so if using all 32,000,000 bytes in a single LONG VARCHAR, that doesn't leave much room for a second LONG VARCHAR in the same table. You'd have to use separate tables.

Question: What do you plan on doing with storing data of this size in Vertica?