DecisionForestPredict Input - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™
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 Numeric predictor variable. Cannot be NULL.
category_column INTEGER, BIGINT, or VARCHAR Categorical predictor variable. Cannot be NULL.
accumulate_column Any 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.