SVMDense Example: Polynomial Model | Teradata Vantage - SVMDense Example: Polynomial Model - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

SQL Call

DROP IF TABLE EXISTS densesvm_iris_polynomial_model;

SELECT * FROM SVMDense (
  ON svm_iris_train AS InputTable
  OUT TABLE ModelTable (densesvm_iris_polynomial_model)
  USING
  IDColumn ('id')
  TargetColumns ('[1:4]')
  ResponseColumn ('species')
  RegularizationLambda (1)
  Bias (0)
  KernelFunction ('polynomial')
  SubspaceDimension (120)
  MaxIterNum (10000)
  Seed (9230842)
  Gamma ('0.1')
  HashBits ('512')
  Degree ('2')
  StopThreshold (0.001)
) AS dt;

Output

 message                                                                                                                                       
---------------------------------------------------------------------------------
 Model table is created successfully      
 The model is trained with 120 samples and 512 unique attributes with hash projection
 There are 3 different classes in the training set
 The model is not converged after 10000 steps with epsilon 0.001, the average value of the loss function for the training set is 0.09703774032390766
 The corresponding training parameters are cost:1.0 bias:0.0

Download a zip file of all examples and a SQL script file that creates their input tables.