GLML1L2 Example 2: Factor Table as InputTable - Teradata Vantage

Input

The input table is admissions_factor_table, output by GLML1L2 Example 1: 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. Because Randomization was true in the SQL call that created admissions_factor_table, this call does not need it.

DROP TABLE admissions_model_2;

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

Output