TD_GLMPredict Examples | GLMPredict | Teradata Vantage - Examples: How to Use TD_GLMPredict - Analytics Database

Example: TD_GLMPredict Using Credit Data

This example takes credit data and uses TD_GLM function to get a model. You can view the input and output in the TD_GLM example.

TD_GLMPredict Call for Credit Data

CREATE VOLATILE TABLE vt_glm_predict_credit_ex AS (
    SELECT * from TD_GLMPredict (
      ON credit_ex_merged AS INPUTTABLE
      ON td_glm_output_credit_ex AS Model DIMENSION
      USING
      IDColumn ('ID')
      Accumulate('Outcome')
    ) AS dt
) WITH DATA
ON COMMIT PRESERVE ROWS;

TD_GLMPredict Output for Credit Data

Example: TD_GLMPredict Using Housing Data

You can view the input and output of steps 1 through 3 in the TD_GLM example.

TD_GLMPredict Call for Housing Data

CREATE VOLATILE TABLE vt_predict_cal_ex AS (
    SELECT * from TD_GLMPredict (
      ON cal_housing_ex_scaled AS INPUTTABLE
      ON td_glm_cal_ex AS Model DIMENSION
      USING
      IDColumn ('ID')
      Accumulate('MedHouseVal')
    ) AS dt
) WITH DATA
ON COMMIT PRESERVE ROWS;

TD_GLMPredict Output for Housing Data