PMMLPredict Syntax | BYOM | Teradata Vantage - 3.0 - PMMLPredict Syntax - Teradata Vantage

Teradata Vantageā„¢ - Bring Your Own Model User Guide

Product
Teradata Vantage
Release Number
3.0
Release Date
May 2022
Content Type
User Guide
Publication ID
B700-1111-051K
Language
English (United States)

When ModelTable Contains Only One Model

SELECT * FROM [schema.]PMMLPredict (
  ON { table | view | (query) } [ AS InputTable ]
  .]PMMLPredict (
  ON { table | view | (query) } [ AS ModelTable ] DIMENSION
  USING
    Accumulate ({ accumulate_column [,...] | '*' })
    [ ModelOutputFields (model_output_field [,...])]
    [ OverwriteCachedModel(current_cached_model_name|'*'|'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0')]
) as alias ;

When ModelTable Contains Multiple Models

SELECT * FROM [schema.]PMMLPredict(
  ON { table | view | (query) } [ AS InputTable ]
  ON (SELECT * FROM { table | view | (query) } WHERE model_id = model_identifier) [ AS ModelTable ] DIMENSION
  USING
    Accumulate ({ accumulate_column [,...] | '*' })
    [ ModelOutputFields (model_output_field [,...])]
    [ OverwriteCachedModel(current_cached_model_name|'*'|'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0')]
) as alias ;