Returning multiple values in UDF

Question

I have written an AggregateFactory Vertica UDF which returns a single value

getReturnTypes(si,columnTypes args,columnTypes returnTypes){

 returnTypes.addVarbinary(512);
 //I want to add second returnType
returnTypes.addFloat("");
} 

getProtoType(si,columnTypes args,columnTypes returnTypes){
returnTypes.addVarbinary(512);
 //I want to add second returnType
returnTypes.addFloat("");
}

this is not working, how can I return two values from an AggregateFactory UDF?

Answer 1

You cannot. User Defined Aggregate Functions (as explained in the fine manual) return ONE value per group. You might want to write a User Defined Transform Function (maybe a multi-phase Transform Function).