Comments in Queries - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.