17.05 - DecisionForestPredict Input - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K
Table Description
Input Contains test data.
Model Has same schema as OutputTable of ML Engine DecisionForest function.

Input Table Schema

Column Data Type Description
id_column Any Unique test point identifier. Cannot be NULL.
numeric_column NUMERIC, INTEGER, BIGINT, or DOUBLE PRECISION [Column appears once for each specified numeric_input_column.] Numeric predictor variable. Cannot be NULL.
category_column INTEGER, BIGINT, or VARCHAR [Column appears once for each specified categorical_input_column.] Categorical predictor variable. Cannot be NULL.
accumulate_column Any [Column appears once for each specified accumulate_column.] Column to copy to output table.

Model Schema

For CHARACTER and VARCHAR columns, CHARACTER SET must be either UNICODE or LATIN.

Column Data Type Description
worker_ip VARCHAR IP address of worker that produced decision tree.
task_index INTEGER, BIGINT, or SMALLINT Identifier of worker that produced decision tree.
tree_num INTEGER, BIGINT, or SMALLINT Decision tree identifier.
tree VARCHAR, CLOB, or JSON

JSON representation of decision tree.