TD_SVM Examples | SVM | Teradata Vantage - Examples: How to Use TD_SVM - Analytics Database

Example: Cal Housing Data Set

Starting Data (cal_housing_ex_raw)

Standardize Data Using TD_ScaleFit with 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;

Output from TD_ScaleFit

Standardize Data Using TD_ScaleTransform with 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;

Output Using TD_ScaleTransform

Example: Using TD_SVM SQL Using Regression Model

CREATE VOLATILE TABLE svm_model_cal_housing AS (
 SELECT * FROM TD_SVM (
 ON cal_housing_ex_scaled
 USING
 InputColumns('medinc', 'houseage', 'averooms', 'avebedrms', 'population', 'aveoccup', 'latitude', 'longitude')
 ResponseColumn('MedHouseVal')
 ModelType('Regression')
 BatchSize(10)
 MaxIterNum(300)
 ) AS dt
) WITH DATA
ON COMMIT PRESERVE ROWS;

Output from TD_SVM

Example: TD_SVM Classification iris Data Set

TD_SVM Call Using Classification Model

CREATE VOLATILE TABLE svm_model_iris_data AS (
SELECT * FROM TD_SVM (
 ON iris_data
 USING
 InputColumns('[1:4]')
 ResponseColumn('label')
 ModelType('Classification')
 BatchSize(10)
 MaxIterNum(300)
 ) AS dt
 ) WITH DATA
ON COMMIT PRESERVE ROWS;

Output from TD_SVM