Invoking UDFs - Teradata Vantage - 1.0

Teradata® Vantage User Guide

prodname
Teradata Vantage
vrm_release
1.0
category
User Guide
featnum
B700-4002-098K
You must install your UDF before you can invoke it.
  • Invoke your UDF as a function reference in a SQL query:
    SELECT * FROM { udf@coprocessor | udf_alias } (
      ON (SELECT * FROM MLE_function AS input_table_alias)
      USING MLE_function_arguments
    );
    For example:
    SELECT * FROM new_kmeans@coprocessor (
      ON (SELECT * FROM KmeansSample as InputTable)
      USING
      OutputTable ('kmeanssample_centroid')
      NumberK ('3')
      Threshold ('0.01')
      MxIterNum ('10')
    );