Do vertica support more than 65000 byte charactor ??
We have a field which contain more than 65000 byte character ? Can some body help how do we accomplish to capture all the data without truncation ?
0
Comments
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.
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