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.