TD_GLM Examples | GLM | Teradata Vantage - Examples: How to Use TD_GLM - Teradata Vantage

Input Table

Example: TD_GLM Using Credit Data Set

The following credit data set is used in this example:

TD_GLM Call for Credit Data

CREATE VOLATILE TABLE td_glm_output_credit_ex AS (
    SELECT * FROM td_glm (
        ON credit_ex_merged
        USING
        InputColumns('a1', 'a2', 'a7', 'a10', 'a13', 'a14', 'a0_b', 'a0_a', 'a3_y', 'a3_u', 'a4_p', 'a4_g', 'a5_k', 'a5_cc', 'a5_d', 'a5_c', 'a5_aa', 'a5_m', 'a5_q', 'a5_w', 'a5_e', 'a5_ff', 'a5_j', 'a5_x', 'a5_i', 'a6_v', 'a6_h', 'a6_bb', 'a6_z', 'a6_ff', 'a6_j', 'a8_t', 'a8_f', 'a9_t', 'a9_f', 'a11_t', 'a11_f', 'a12_g', 'a12_s')
        ResponseColumn('Outcome')
        Family('Binomial')
        BatchSize(10)
        MaxIterNum(300)
        RegularizationLambda(0.02)
        Alpha(0.15)
        IterNumNoChange(50)
        Tolerance(0.001)
        Intercept('true')
        LearningRate('optimal')
        InitialEta(0.001)
        Momentum(0.0)
        LocalSGDIterations(0)
    ) AS dt
) WITH DATA
ON COMMIT PRESERVE ROWS
;

TD_GLM Output for Credit Data

Example: TD_GLM Using Housing Data

Raw Housing Data

TD_ScaleFit Call for Housing Data

SELECT * FROM TD_ScaleFit(
    ON cal_housing_ex_raw AS InputTable
    OUT VOLATILE TABLE OutputTable(scaleFitOut_cal_ex)
    USING
    TargetColumns('medinc', 'houseage', 'averooms', 'avebedrms', 'population', 'aveoccup', 'latitude', 'longitude')
    ScaleMethod('STD')
) AS dt2;

TD_ScaleFit Output for Housing Data

TD_ScaleTransform Call for Housing Data

CREATE MULTISET TABLE cal_housing_ex_scaled AS (
    SELECT * FROM TD_ScaleTransform(
        ON cal_housing_ex_raw AS InputTable
        ON scaleFitOut_cal_ex AS FitTable DIMENSION
        USING
        accumulate('id', 'MedHouseVal')
    ) AS dt1
) WITH data;

TD_ScaleTransform Output for Housing Data

TD_GLM Call for Housing Data

CREATE VOLATILE TABLE td_glm_cal_ex AS (
    SELECT * from TD_GLM (
        ON cal_housing_ex_scaled
        USING
        InputColumns('medinc', 'houseage', 'averooms', 'avebedrms', 'population', 'aveoccup', 'latitude', 'longitude')
        ResponseColumn('MedHouseVal')
        Family('Gaussian')
        BatchSize(10)
        MaxIterNum(300)
        RegularizationLambda(0.02)
        Alpha(0.15)
        IterNumNoChange(50)
        Intercept('true')
        LearningRate('invtime')
        InitialEta(0.05)
        Momentum(0)
        Nesterov('false')
        LocalSGDIterations(0)
    ) AS dt
) WITH DATA
ON COMMIT PRESERVE ROWS;

TD_GLM Output for Housing Data