Do vertica support more than 65000 byte charactor ??

Just wanted to mention . The source field is from Salesforce .

Hi Soumya,

The  maximum length for any data-type( CHAR, VARCHAR, RAW) with Vertica is 65000 bytes. 
So you cannot exceed this limit for a single column.
I would suggest having an extra column besides this column and always concatenating both column in every query of yours. 

This way you can do the transformations on your complete text.

Hope this helps.

Thank you Navin. That's a good idea..

Hi all,

Navin, thanks for the reply!  That is the correct answer; also a good workaround.

Soumya, if this use case is important to you and if you are an Enterprise customer, I'd encourage you to get in touch with your sales rep and/or our customer support; they may have something for you.  (And if you're a CE user, keep an eye out here / watch future releases as they come out / etc.)  We're aware that this is an important use case.

Adam