1.1 - 8.10 - AMLGenerator Syntax - 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)

Version 1.9

SELECT * from AMLGenerator (
  [ ON (SELECT 1) AS InputTable PARTITION BY 1 ]
  ON { table | view | (query) } AS Model
  [ ON { table | view | (query) } AS Model2 ]
  USING
  ModelType ('function_name')
  [ ModelTag ('model_tag') ]
  [ Model2Tag ('model2_tag') ]
  [ InstalledFile ('installed_file') ]
  [ InstalledFile2 ('installed_file_2') ]
  [ InstalledFileTag ('installed_file_tag') ]
  [ InstalledFile2Tag ('installed_file_2_tag') ]
  RequestColNames ('column_name' [,...]) ]
  RequestColTypes ('column_type' [,...])
  [ AMLPrefix ('aml_model_file') ]
  [ OverwriteOutput ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'})]
  [ RequestArgName1 ('arg_name') ]
  [ RequestArgVal1 ('arg_value') ]
  ...
  [ RequestArgNamen ('arg_name') ]
  [ RequestArgValn ('arg_value') ]
) AS alias;

If you omit ON { table | view | (query) } AS Model, you must include ON (SELECT 1) AS InputTable PARTITION BY 1.