1.1 - 8.10 - SVMDensePredict Example: Polynomial Model - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Input

SQL Call

SELECT * FROM SVMDensePredict (
  ON svm_iris_test AS InputTable PARTITION BY ANY
  ON densesvm_iris_polynomial_model AS Model DIMENSION
  USING
  IdColumn ('id')
  TargetColumns ('[1:4]')
  Accumulate ('id','species')
) AS dt ORDER BY id;

Output

 id  predict_value predict_confidence species    
 --- ------------- ------------------ ---------- 
   5 setosa                       1.0 setosa    
  10 setosa                       1.0 setosa    
  15 setosa                       1.0 setosa    
  20 setosa                       1.0 setosa    
  25 setosa                       1.0 setosa    
  30 setosa                       1.0 setosa    
  35 setosa                       1.0 setosa    
  40 setosa                       1.0 setosa    
  45 setosa                       1.0 setosa    
  50 setosa                       1.0 setosa    
  55 versicolor                   1.0 versicolor
  60 versicolor                   1.0 versicolor
  65 versicolor                   1.0 versicolor
  70 versicolor                   1.0 versicolor
  75 versicolor                   1.0 versicolor
  80 versicolor                   1.0 versicolor
  85 versicolor                   1.0 versicolor
  90 versicolor                   1.0 versicolor
  95 versicolor                   1.0 versicolor
 100 versicolor                   1.0 versicolor
 105 virginica                    1.0 virginica 
 110 virginica                    1.0 virginica 
 115 virginica                    1.0 virginica 
 120 virginica                    1.0 virginica 
 125 virginica                    1.0 virginica 
 130 setosa        0.9999969640485622 virginica 
 135 virginica                    1.0 virginica 
 140 virginica                    1.0 virginica 
 145 virginica                    1.0 virginica 
 150 virginica                    1.0 virginica

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.