Input
- InputTable: svm_iris_test (see SVMDense Examples Input)
- Model: densesvm_iris_rbf_model (see SVMDense Example: Radial Basis Model (RBF) Model)
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.