17.05 - Example: Function Mapping Definition with IN TABLE Options - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

Below is the function mapping definition GLMPredict for the glmpredict function on the server coprocessor.

During function processing, the following can be specified in the table operator ON clause:
  • A single input table without a correlation name.
  • The input table MODEL as a correlation name.
CREATE FUNCTION MAPPING appl_view_db.GLMPredict
   FOR glmpredict SERVER coprocessor 
   MAP JSON ( '{ "function_version": "1.0" }') 
   USING 
      ANY IN TABLE,  
      MODEL IN TABLE;