Function Mapping for Native Functions - Teradata Database - Teradata Vantage NewSQL Engine

You can use a function mapping to specify a simple name for executing a table operator within a database or user, in addition to executing a table operator on an external server. The function mapping defines input tables, output tables, and other parameters to use during processing. Previously, users would have to specify the location of a table operator such as, kmeans@coprocessor. For example:

  SELECT * FROM kmeans@coprocessor (
    ON computers_train1 AS InputTable 
    ON kmeanssample_centroid AS CentroidsTable
       USING OutputTable(kmeanssample_output)
       ClusterAssignmentTable(kmeanssample_clusteredoutput)
    ) AS dt ORDER BY clusterid ; 

After using the CREATE FUNCTION MAPPING SQL statement to define the function mapping, user queries can simply specify a function mapping name such as, kmeans. For example:

   SELECT * FROM 
    KMeans(
           ON computers_train1 AS InputTable
           ON kmeanssample_centroid AS CentroidsTable
           OUT TABLE OutputTable(kmeanssample_output)
           OUT TABLE ClusterAssignmentTable(kmeanssample_clusteredoutput)
           ) AS dt ORDER BY clusterid ;