Hi,
As the subject states, can a transform function, ie a UDTF, issue its own query, or does it only work with the columns passed to it by the calling SELECT query.
I've looked through the transform examples and can't see anything which issues its own query, but the documentation seemed to imply that it can ... ie return a completely different table.
Thanks,
+1Hi,
User Defined Transform function is a concept that is developed by vertica ithat lets you to create your own library functions that are written in either c++, Java or R which are difficult to be performed using SQL.
It works only for the columns passed to it by calling SELECT query. Based on the type of UDTF you create, the output you see is completely a different table.
Please go through the example in the following URL, it will give you a better idea about UDTF
You can find the code related to the function mentioned in the above URL at the location
cd /opt/vertica/sdk/examples/
in your vertica cluster
-Regards,
Sruthi
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
