1.1 - 8.10 - GLML1L2 Example: Factor Table as InputTable - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Input

The input table is admissions_factor_table, output by GLML1L2 Example: Ridge Regression, Family ('BINOMIAL'). In admissions_factor_table, categorical predictors were converted to integers.

SQL Call

Because the admissions_factor_table has only integers, this call does not specify CategoricalColumns.

DROP TABLE admissions_model_2;

CREATE MULTISET TABLE admissions_model_2 AS (
  SELECT * FROM GLML1L2 (
    ON admissions_factor_table AS InputTable
    USING
    TargetColumns ('[0:5]')
    ResponseColumn ('admitted') 
    Family ('BINOMIAL') 
    Alpha (0)
    RegularizationLambda (0.02)   
  ) AS dt
) WITH DATA;

Output

SELECT * FROM admissions_model_2;
 attribute            estimate              information 
 -------------------- --------------------- ----------- 
 AIC                      15.21927981934978 NULL       
 Iterations #                          28.0 NULL       
 Features #                             6.0 NULL       
 Alpha                                  0.0 NULL       
 Lambda                                0.02 NULL       
 stats_novice         -0.026716553307241597 p          
 programming_novice     -0.0820786516340258 p          
 Regularization                        NULL Ridge      
 Family                                NULL Binomial   
 Converged                             NULL true       
 gpa                    0.38346423433872745 p          
 Rows #                                40.0 NULL       
 BIC                     27.041435998147332 NULL       
 (Intercept)             0.3838162407664626 p          
 programming_beginner   -1.0259430213730834 p          
 stats_beginner         0.08063465501463249 p          
 masters_yes            -1.2652530272653697 p

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.