SQL-MapReduce Call - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
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')
);