Input
- InputTable: svm_iris_input_train, created for SVMSparse Example
- Model: svm_iris_model, the output table from SVMSparse Example
SQL Call
SELECT DISTINCT * FROM SVMSparseSummary ( ON svm_iris_input_train AS InputTable PARTITION BY 1 ON svm_iris_model AS Model DIMENSION USING AttributeNameColumn ('attribute') OutputSummary ('false') ) AS dt ORDER BY classid, attributeid;
Output
classid classlabel attribute attributeid weight ------- ---------- ------------ ----------- ------------------- 0 setosa petal_length 0 -1.0528831617318961 0 setosa petal_width 1 -0.544169879273076 0 setosa sepal_length 2 0.2688866340136437 0 setosa sepal_width 3 0.5383285488937579 0 setosa <bias> 4 0.0 1 versicolor petal_length 0 0.8527275632914872 1 versicolor petal_width 1 -2.3445055331163274 1 versicolor sepal_length 2 0.6664257415238589 1 versicolor sepal_width 3 -1.5871010524677913 1 versicolor <bias> 4 0.0 2 virginica petal_length 0 1.9485044310859905 2 virginica petal_width 1 2.645577371588467 2 virginica sepal_length 2 -1.7185994975217473 2 virginica sepal_width 3 -1.3547097441817717 2 virginica <bias> 4 0.0
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.