Table Operator Examples | SQL SELECT Statements | Teradata Vantage - 17.05 - Examples: Table Operator Function Mapping - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

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

This SELECT statement includes a function mapping with an ON clause.

SELECT * FROM appl_view_db.CCMPrepare
   ( ON tab1 PARTITION BY id);

This SELECT statement includes a function mapping that specifies an input table, output table, and additional parameters.

SELECT * FROM appl_view_db.GLM ( 
   ON loan_info2 AS InputTable 
   OUTPUT TABLE OutputTable(loan_info2_out_t) 
   USING 
      ColumnNames ( 'DELINQUENT2PLUS', 'CREDIT_SCORE', 'FIRST_PAYMENT_DATE', 
                     'MORTGAGE_INSURANCE_PERCENTAGE', 'NUMBER_OF_UNITS', 
                     'CLTV, DTI_RATIO', 'ORIGINAL_UPB', 'ORIGINAL_LTV', 
                     'ORIGINAL_INTEREST_RATE', 'ORIGINAL_LOAN_TERM', 
                     'NUMBER_OF_BORROWERS' ) 
      Family ('logistic') Link ('LOGIT') 
      Weight (1) Threshold (0.01) MaxIterNum (25) 
      Step ('false') Intercept ('true') ) AS dt;