TD_DecisionForestPredict Output - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

Output Table Schema

The table has a set of predictions for each test point.

Name Data Type Description
id_column Same as input table Column copied from input table. It is the unique row identifier.
prediction
  • Integer for classification model
  • FLOAT for regression model
Predicted test point value or predicted class, determined by model.
confidence_lower FLOAT [Appears with OutputProb is false.] Lower bound of confidence interval.

For classification trees, confidence_lower and confidence_upper have the same value, which is the probability of the predicted class.

confidence_upper FLOAT [Appears with OutputProb is false.] Upper bound of confidence interval.

For classification trees, confidence_lower and confidence_upper have the same value, which is the probability of the predicted class.

prob FLOAT [Column appears only when OutputProb is true, and no Responses syntax element.] Probability that observation belongs to class prediction.
prob_response FLOAT [Column appears only when OutputProb is true and the Responses syntax element.] Probability that observation belongs to category response. Appears once for each specified response.
tree_num VARCHAR(30) [This column appears only when Detailed is true.] One of the following:
  • Concatenation of task_index and tree_num from the model table showing which tree created the prediction.
  • Final to show the overall prediction.
accumulate_column Same as input table Column copied from input table.