Handling Large Objects, Data Greater than 32 MB

Moderator: NorbertKrupa

Post Reply
benbenten
Newbie
Newbie
Posts: 2
Joined: Mon Mar 19, 2018 2:47 pm

Handling Large Objects, Data Greater than 32 MB

Post by benbenten » Wed Mar 21, 2018 11:48 am

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.

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

Re: Handling Large Objects, Data Greater than 32 MB

Post by JimKnicely » Mon Mar 26, 2018 3:24 pm

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?
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 “General”