1.1 - 8.10 - ROC Output with OutputTable - 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)

If you specify OutputTable, the function outputs a message and creates OutputTable. The OutputTable schema depends on the ROCValues syntax element.

Output Message Schema

Column Data Type Description
info VARCHAR Reports whether function completed.

OutputTable Schema, ROCValues ('true') (Default)

The table has one row for each threshold for each model, and contains only ROC values.

Column Data Type Description
model Same as model_id_column in input table [Column appears only with ModelIDColumn syntax element.] Model identifier or partition for ROC curve associated with observation, taken from model_id_column.
threshold DOUBLE PRECISION Threshold at which function classifies an observation as positive.
tpr DOUBLE PRECISION True positive rate for threshold (number of observations correctly predicted as positive based on threshold, divided by number of observations known to be positive).
fpr DOUBLE PRECISION False positive rate for threshold (number of observations incorrectly predicted as positive based on threshold, divided by number of observations known to be negative).

OutputTable Schema, ROCValues ('false')

This is the default output table if you specify AUC only, Gini only, or AUC and Gini only.

The table has the following:
  • One row for each model
  • No ROC values
  • AUC values, Gini values, or both (depending on AUC and Gini syntax elements)
Column Data Type Description
model Same as model_id_column in input table [Column appears only with ModelIDColumn syntax element.] Model identifier or partition for ROC curve associated with observation, taken from model_id_column.
AUC DOUBLE PRECISION Area under ROC curve for data in partition. With AUC ( 'false'), this value is NULL.
Gini DOUBLE PRECISION Gini coefficient for ROC curve for data in partition. With Gini ('false'), this value is NULL.