Single_Tree_Predict Example 1 - Teradata Vantage

Input

SQL Call

CREATE MULTISET TABLE singletree_predict AS (
  SELECT * FROM Single_Tree_Predict@coprocessor (
    ON iris_attribute_test AS attribute_table PARTITION BY pid
      ORDER BY attribute
    ON iris_attribute_output as model_table DIMENSION
    USING
    AttrTable_GroupbyColumns ('attribute')
    AttrTable_pidColumns ('pid')
    AttrTable_valColumn ('attrvalue')
  ) AS dt
) WITH DATA;

Output

This query returns the following table:

SELECT * FROM singletree_predict ORDER BY 1;

Prediction Accuracy

The following SQL code calculates and displays the prediction accuracy.

DROP TABLE st_predict_accuracy;

CREATE MULTISET TABLE st_predict_accuracy AS (
  SELECT pid, CAST(pred_label AS INTEGER) AS pred_label, species
  FROM singletree_predict, iris_test WHERE id = pid
) WITH DATA;

SELECT (
  SELECT COUNT(pid) FROM st_predict_accuracy
  WHERE pred_label = species)/(SELECT COUNT(pid)
  FROM st_predict_accuracy
) WITH DATA AS prediction_accuracy;