7.00.02 - SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

The default option is to include the intercept with the step argument set to false. The response variable (admitted, in this example) must be specified as the first variable listed in the InputColumns argument, followed by the other predictors.

DROP TABLE IF EXISTS glm_admissions_model;

SELECT * FROM GLM (
  ON (SELECT 1)
  PARTITION BY 1
  InputTable ('admissions_train')
  OutputTable ('glm_admissions_model')
  InputColumns ('admitted','masters', 'gpa', 'stats', 'programming')
  CategoricalColumns ('masters', 'stats', 'programming')
  Family ('LOGISTIC')
  Link ('LOGIT')
  Weight ('1')
  Threshold ('0.01')
  MaxIterNum ('25')
  Step ('false')
  Intercept ('true')
);