1.1 - 8.10 - SVMSparseSummary Example: OutputSummary ('false') - 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 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.