Machine Learning Engine Comments in Queries | Teradata Vantage - Comments in Queries - Teradata Vantage

Queries with "@coprocessor"

Comments in queries with "@coprocessor" must have the syntax /* comment */. For example:

SELECT * FROM GLMPredict@coprocessor (
  ON admissions_test PARTITION BY ANY
  ON glm_admissions_model AS model DIMENSION
  USING
  Accumulate ('id', 'masters', 'gpa', 'stats', 'programming', 'admitted')
  Family ('LOGISTIC')     /* Same as BINOMIAL */
  LinkFunction ('LOGIT')  /* Default */
) AS dt;

Queries without "@coprocessor"

SELECT * FROM GLMPredict (
  ON admissions_test PARTITION BY ANY
  ON glm_admissions_model AS model DIMENSION
  USING
  Accumulate ('id', 'masters', 'gpa', 'stats', 'programming', 'admitted')
  Family ('LOGISTIC')     /* Same as BINOMIAL */
  LinkFunction ('LOGIT')  -- Default
) AS dt;