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

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

Machine Learning Engine User Guide

Product

Teradata Vantage

Release Number

9.02

9.2.4

9.2.3

2.3.2

1.3

Published

May 2022

Language

English (United States)

Last Update

2022-05-04

dita:mapPath

kaz1597341649653.ditamap

dita:ditavalPath

ehs1594682156756.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')
);