SVMSparseSummary Example: OutputSummary ('false') - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.