1.1 - 8.10 - ConfusionMatrix Output - 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)

Output Message Schema

Column Data Type Description
message VARCHAR Reports whether function succeeded and output result to output tables.

CountTable Schema

This table is a confusion matrix (also called a contingency table).

Column Data Type Description
observation VARCHAR Unique value of observed_column in input table.
predicted_class VARCHAR [Column appears once for each specified class.] Number of times that items in observed_column were classified as predicted_class.

StatTable Schema

This table has overall statistics.

Column Data Type Description
key VARCHAR Statistic name from this list:
  • Accuracy
  • 95% CI
  • Null Error Rate
  • P-Value [Acc > NIR]
  • Kappa
  • McNemar Test P-Value

For formulas function uses for Kappa and Null Error Rate, see ConfusionMatrix Output.

value VARCHAR Statistic value.

AccuracyTable Schema

Column Data Type Description
measure VARCHAR Each row contains one of these statistic names:
  • Sensitivity
  • Specificity
  • Pos Pred Value
  • Neg Pred Value
  • Prevalence
  • Detection Rate
  • Detection Prevalence
  • Balanced Accuracy

For formulas function uses for these statistics, see ConfusionMatrix Output.

predicted_class VARCHAR Values of statistics for class.

With Classes syntax element, column appears once for each specified class. Without Classes syntax element, column appears once for each unique observed_column value.