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.
Handling Large Objects, Data Greater than 32 MB
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Handling Large Objects, Data Greater than 32 MB
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?
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](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
![Image](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.