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 ?

Comments

  • Just wanted to mention . The source field is from Salesforce . 
  • 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.
  • 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

Leave a Comment

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