Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Multiple Parameters

I would like to send a list of parameters to a UDF in addition to the data table.

I am using Vertica 6.1 and the statement USING PARAMETERS is useful, but the documentation only shows how to send a single parameter.

How do I deal with more than 1?

Example
SELECT a,b,add2Constants(a,b USING PARAMETERS c1 = 1, c2 = 2)  OVER() FROM table;

a     b     sum
1     2     6
3     4     10
5     6     14



Current parametertypecallback is as follows (BTW you have an error in the documentation, you created PARAMS and used PARAM in the example.)
kmeansParameters <- function(){       param <- data.frame(datatype=rep(NA, 1), length=rep(NA,1), scale=rep(NA,1),name=rep(NA,1) )       param[1,1] = "int"       param[1,4] = "k"       param  }

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.