The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Long Varbinary more than 32,000,000 bytes needed for UDF

Hi All,

I am writing an aggregation UDF whose return type is Varbinary I get following error message

"User code caused Vertica to throw exception "Length for type Long Varbinary cannot exceed 32000000"

I checked docs and found that this is a system limit.

My requirement is to have almost four times this limit size, is there a way to solve this problem?

There is some external storage concept, how can I make my Aggregate UDF terminate method to write more than this limit?

Leave a Comment

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