Input
- InputTable: svm_iris_test (see SVMDense Examples Input)
- Model: densesvm_iris_polynomial_model (see SVMDense Example: Polynomial Model)
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.