Table Operator Examples | SQL SELECT Statements | Teradata Vantage - Examples: Table Operator Function Mapping - Teradata Vantage - Analytics Database

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;