AMLGenerator Syntax - 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ā„¢

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.