TD_GLM Input - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢
Column Data Type Description
partition_by_column CHARACTER, VARCHAR, INTEGER, BIGINT, SMALLINT, BYTEINT Unique model identifier.
id_column CHARACTER, VARCHAR, INTEGER, BIGINT, SMALLINT, BYTEINT Unique identifier for each row.
input_column INTEGER, BIGINT, SMALLINT, BYTEINT, FLOAT, DECIMAL, NUMBER The input table columns used to train the GLM model.
response_column INTEGER, BIGINT, SMALLINT, BYTEINT, FLOAT, DECIMAL, NUMBER The column that contains the response value for an observation.
AttributeTable Schema
Column Data Type Description
partition_by_column CHARACTER, VARCHAR, INTEGER, BIGINT, SMALLINT, BYTEINT Unique model identifier.
attribute_column VARCHAR Names of the target columns in the input table.
If the column contains duplicate values, then the function displays an error message. The column name must be attribute_column.
ParameterTable Schema
Column Data Type Description
partition_by_column CHARACTER, VARCHAR, INTEGER, BIGINT, SMALLINT, BYTEINT Unique model identifier.
parameter_column VARCHAR One of the following syntax elements:
  • Family
  • BatchSize
  • MaxIterNum
  • RegularizationLambda
  • Alpha
  • IterNumNoChange
  • Tolerance
  • Intercept
  • ClassWeights
  • LearningRate
  • InitialEta
  • DecayRate
  • DecaySteps
  • Momentum
  • Nesterov

The column name must be parameter_column.

value_column VARCHAR Value to use for syntax elements listed in parameter_column.