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 ?


  • Options
    Just wanted to mention . The source field is from Salesforce . 
  • Options
    Navin_CNavin_C Vertica Customer
    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.
  • Options
    Thank you Navin. That's a good idea..
  • Options
    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.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file