17.05 - GLMPredict 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 new data.
Model Model output by ML Engine GLM function. For schema, see Teradata Vantage™ Machine Learning Engine Analytic Function Reference, B700-4003.

If the GLM call that created the model table specified the Step syntax element, include the optional ORDER BY clause in the GLMPredict call; otherwise, the GLMPredict result is nondeterministic.

Input Table Schema

Column Data Type Description
accumulate_column Any [Column appears once for each specified accumulate_column.] Column to copy to output table.
dependent_variable_column INTEGER, SMALLINT, BIGINT, NUMERIC, DOUBLE PRECISION, VARCHAR(n), CHAR(n) Dependent/response variables. Cannot be NULL.
predictor_variable_column INTEGER, SMALLINT, BIGINT, NUMERIC, DOUBLE PRECISION [Column appears one or more times.] Independent/predictor variable. Cannot be NULL.

Any numeric dependent_variable_column or predictor_variable_column that is expected to be categorical must be cast to VARCHAR.

Model Table Schema

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

Column Data Type Description
attribute INTEGER Numeric index of predictor.
predictor CHARACTER or VARCHAR Predictor name.
category CHARACTER or VARCHAR For categorical predictor, its level. For numeric predictor, NULL.
estimate DOUBLE PRECISION Estimated coefficient.
std_error DOUBLE PRECISION Standard error of coefficient.
t_score DOUBLE PRECISION

[Column appears only with Family ('GAUSSIAN').] The t_score follows a t(N-p-1) distribution.

z_score DOUBLE PRECISION

[Column appears only without Family ('GAUSSIAN').] The z-score follows the N(0,1) distribution.

p_value DOUBLE PRECISION p-value for z_score. (p-value represents significance of each coefficient.)
significance CHARACTER or VARCHAR Significance code for p_value.
family CHARACTER or VARCHAR Distribution exponential family, specified by Family syntax element.