1.0 - 8.00 - XGBoostPredict Example 2: Multiple-Class Classification - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Input

SQL Call

CREATE MULTISET TABLE iris_predict AS (
  SELECT * FROM XGBoostPredict (
    ON iris_test AS "input" PARTITION BY ANY
    ON xgboost_model2 AS modeltable DIMENSION ORDER BY tree_id, iter, class_num
    USING
    IDColumn ('id')
    NumBoostedTrees (2)
    Accumulate ('species')
  ) AS dt
) WITH DATA;

Output

The table iris_predict is similar to the following table, but has 120 rows.

id species prediction confidence_lower confidence_upper
5 1 1 1 1
15 1 1 1 1
25 1 1 1 1
35 1 1 1 1
45 1 1 1 1
55 2 2 1 1
65 2 2 1 1
75 2 2 1 1
85 2 2 1 1
95 2   1 1
105 3 3 1 1
115 3 3 1 1
125 3 3 1 1
135 3 3 1 1
145 3 3 1 1
... ... ... ... ...