Invoke UDFs on Machine Learning Engine | Teradata Vantage - Invoking UDFs

Invoke UDFs on Machine Learning Engine | Teradata Vantage - Invoking UDFs - Teradata Vantage

Machine Learning User Guide

Product

Teradata Vantage

Release Number

9.01

1.3

Published

August 2020

Language

English (United States)

Last Update

2020-10-02

dita:mapPath

dci1595445931473.ditamap

dita:ditavalPath

dqp1599597541027.ditaval

dita:id

B700-4004

lifecycle

Product Category

Teradata Vantage™

PrerequisiteYou 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')
);