By changing the outtype value to 'ANY' in the factory function you can make the UDF return any dataset, but you must configure an output function (denoted as outtypecallback in the factory) to tell vertica the metadata of the columns.
Let me give an example. I have a UDF which takes 1 column of data (integers)
Value
4
2
1
Sums the values and outputs a table with n columns filled with random numbers
n = 4+2+1 = 7
Col1 Col2 Col3 ... Col7
.. .. .. ..
How should I write the outtypecallback function?
I know the return function takes automatically as input the metadata data frame of the input data and the parameters list if any.
Any ideas?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.