16.20 - DecisionForestPredict Input - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)
Table Description
Input Contains test data.
Model [Optional] 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.