We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Anshuman — Vertica Forum
Default Avatar

Anshuman

Anshuman

I need to write a UDF in C++ for the vertica DB. The UDF is applied on every row. It takes an integral input and returns an array of indexes with the set bit. Ex: UDF's input and output Input --> Output 0 --> { } 7 --> { '0', '1', '2' } 1 --> { '0' } 5 --> { '0', '2' } 11 --> { '0', '2', '4' } I read about various types of UDFs in vertica. I think for my use case I need to use scalar functions. The output is an array of strings. But I am unable to figure out what vertica datatype should I return as output. The vertica document do not mention of any array data types. Please correct me if I am wrong.

Badges

Any minute now…

Activity

  • Not much happening here, yet.