1.1 - 8.10 - SVMDensePredict Example: Sigmoid 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_sigmoid_model AS Model DIMENSION
  USING
  IdColumn ('id')
  TargetColumns ('[1:4]')
  Accumulate ('id','species')
  Responses ('virginica')
) AS dt ORDER BY 3 DESC;

Output

 id  prediction prob_virginica      species    
 --- ---------- ------------------- ---------- 
 110 virginica   0.8243513170061639 virginica 
 130 virginica   0.8196895545919612 virginica 
 145 virginica    0.819689554376522 virginica 
 125 virginica   0.8196895541344449 virginica 
 140 virginica   0.8196895537732645 virginica 
 105 virginica   0.7827050534303357 virginica 
  55 virginica   0.7493463554983981 versicolor
  75 virginica   0.7024598410529389 versicolor
 135 virginica    0.613145720806066 virginica 
 150 virginica   0.5827460668964375 virginica 
 115 versicolor 0.38810199423491243 virginica 
 120 versicolor  0.3082683626614083 virginica 
  15 versicolor   0.262430284210736 setosa    
 100 versicolor  0.2624297267110863 versicolor
  85 versicolor  0.2576096538956448 versicolor
  95 setosa     0.23194834526579422 versicolor
  65 setosa     0.21744242477000916 versicolor
  80 setosa     0.19113697852593411 versicolor
  70 setosa       0.177655546064284 versicolor
  90 setosa      0.1737892075977879 versicolor
  60 setosa      0.1261779290285922 versicolor
  45 setosa     0.12548856100182576 setosa    
  20 setosa     0.10808401281711943 setosa    
  50 setosa     0.09658624605309041 setosa    
  25 setosa     0.09646076478211794 setosa    
  10 setosa     0.09451432260095656 setosa    
  35 setosa     0.09451411796130273 setosa    
  40 setosa     0.09353276878398742 setosa    
   5 setosa     0.09353245790680728 setosa    
  30 setosa     0.09007237627853645 setosa

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