1.1 - 8.10 - SVMDensePredict Example: Radial Basis Model (RBF) 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_rbf_model AS Model DIMENSION
  USING
  IdColumn ('id')
  TargetColumns ('[1:4]')
  Accumulate ('id','species')
  Responses ('setosa','virginica','versicolor')
) AS dt ORDER BY id;

Output

 id  prediction prob_setosa         prob_virginica       prob_versicolor      species    
 --- ---------- ------------------- -------------------- -------------------- ---------- 
   5 setosa      0.8535998517120608  0.08192632845385378   0.0644738198340855 setosa    
  10 setosa      0.8450368070379933  0.06954853895557617  0.08541465400643053 setosa    
  15 setosa      0.8043943007031017    0.101492108681114  0.09411359061578431 setosa    
  20 setosa       0.836422462843551   0.0786221472394507  0.08495538991699832 setosa    
  25 setosa      0.7904597955361632  0.09085355762899508  0.11868664683484167 setosa    
  30 setosa      0.8371361589863434   0.0791434347492386  0.08372040626441819 setosa    
  35 setosa      0.8437044721183843  0.06844796440334666  0.08784756347826908 setosa    
  40 setosa      0.8554672235117932  0.07243087785945916  0.07210189862874762 setosa    
  45 setosa       0.805066483009688  0.08911194217783937   0.1058215748124727 setosa    
  50 setosa      0.8637172407788963    0.070525577703088  0.06575718151801577 setosa    
  55 versicolor   0.081612627552008   0.0753181372853678   0.8430692351626242 versicolor
  60 versicolor 0.10962006187355693  0.12749172023146615    0.762888217894977 versicolor
  65 versicolor 0.10323962536963839  0.05652660678895776   0.8402337678414038 versicolor
  70 versicolor 0.07145359073974589 0.045002867404656983   0.8835435418555971 versicolor
  75 versicolor 0.06098500928582926 0.033192999588370735   0.9058219911258001 versicolor
  80 versicolor 0.07530339476371994  0.03842459386578468   0.8862720113704954 versicolor
  85 versicolor 0.12451186734094914  0.19999852181337543   0.6754896108456754 versicolor
  90 versicolor 0.07592320286094201  0.07266545012288168   0.8514113470161764 versicolor
  95 versicolor 0.08211728275996348  0.07161458732673981   0.8462681299132967 versicolor
 100 versicolor 0.07576422112566572 0.055382590051668755   0.8688531888226656 versicolor
 105 virginica  0.07188699594768999   0.8741244551987504  0.05398854885355957 virginica 
 110 virginica  0.07650971366342536   0.8704391579961449 0.053051128340429805 virginica 
 115 virginica    0.089920061619273   0.8240773521261162  0.08600258625461076 virginica 
 120 versicolor 0.12777471830876824  0.39089127348462216   0.4813340082066097 virginica 
 125 virginica  0.09258034691477306   0.8276689523811386  0.07975070070408823 virginica 
 130 virginica  0.12840302532707762   0.7136971268473123  0.15789984782561012 virginica 
 135 virginica  0.13632074889344598   0.6291976197467514  0.23448163135980268 virginica 
 140 virginica  0.10839834365193424     0.75833511513066  0.13326654121740567 virginica 
 145 virginica  0.07888633946180423   0.8622056822882582 0.058907978249937556 virginica 
 150 virginica    0.127665133845201   0.6123429460194407   0.2599919201353583 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.