SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

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')
);