1.1 - 8.10 - SVMDenseSummary 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)

Set the ShowSummary syntax element to false to output the model parameters (weights, attributes, and so on).

Input

SQL Call

SELECT * FROM SVMDenseSummary (
  ON (SELECT TOP 1 * FROM svm_iris_train) AS InputTable PARTITION BY 1
  ON densesvm_iris_rbf_model AS Model DIMENSION
  USING
  TargetColumns ('[1:4]')
  OutputSummary ('false')
)AS dt;

Output

 classid classlabel attribute      attributeid weight               
 ------- ---------- -------------- ----------- -------------------- 
       0 setosa     "sepal_width"            1  0.17668614274598424
       1 versicolor "sepal_width"            1  -0.2581050936190464
       2 virginica  "sepal_width"            1 -0.05148409297039791
       0 setosa     "sepal_length"           0   0.2124457045066159
       1 versicolor "sepal_length"           0 -0.18895676841065615
       2 virginica  "sepal_length"           0 -0.14795974623093944
       0 setosa     "petal_width"            3   0.1495107028305408
       1 versicolor "petal_width"            3 -0.32278838874104604
       2 virginica  "petal_width"            3  0.05151405569228511
       0 setosa     "petal_length"           2  0.18552583229853534
       1 versicolor "petal_length"           2  -0.4127026264766183
       2 virginica  "petal_length"           2  0.08001136090545642

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.