1.1 - 8.10 - Comments in Queries - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Comments in nPath@coprocessor and NTree@coprocessor Queries

Comments in nPath@coprocessor and NTree@coprocessor queries must have the syntax /* comment */. For example:

SELECT * FROM nPath@coprocessor (
  ON aggregate_clicks PARTITION BY sessionid ORDER BY clicktime
  USING
  Mode (nonoverlapping) /* here is a comment */
  Pattern ('A*')
  Symbols (TRUE AS A)
  Result (FIRST (sessionid OF A) AS sessionid, Accumulate (pagetype OF A) AS path)
) AS dt;

Comments in All Other Queries

Comments in all other queries can have either the preceding syntax or the syntax -- comment. For example:

SELECT * FROM GLMPredict_MLE (
  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;
In the syntax /* comment */, do not include "--" inside the comment delimiters.