TD_DecisionForestPredict Output - Analytics Database

Database Analytic Functions
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
qkf1628213546010.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.