1.1 - 8.10 - XGBoost Input - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

If the input data set is in dense format, the XGBoost function requires only InputTable. If the input data set is in sparse format, the function requires both InputTable and AttributeTable.

InputTable Schema for Dense Input

Column Data Type Description
id_column With NumBoostedTrees: INTEGER, BIGINT, SMALLINT, or BYTEINT

Otherwise: Any (function ignores it)

[Optional] Unique identifier for data point in training data set. Cannot be NULL.
response_column Any Response variable for data point in training data set.
numeric_input_column Numeric Numeric predictor variable for data point in training data set.
categorical_input_column Any Categorical predictor variable for data point in training data set.

InputTable Schema for Sparse Input

Column Data Type Description
id_column Any Unique identifier for data point in training data set. Cannot be NULL.
response_column Any Response variable for data point in training data set. If this value is NULL, the function ignores this observation.
attribute_name_column VARCHAR Attribute name.
attribute_value_column Any Attribute value.

AttributeTable Schema (Only for Sparse Input)

Column Data Type Description
attributename VARCHAR First column in table. Name of attribute for creating model.
attributetype INTEGER Second column in table. Attribute data type—1 (numeric) or 0 (categorical).