H2OPredict Syntax | Vantage BYOM - 2.0 - H2OPredict Syntax - Teradata Vantage

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

Product
Teradata Vantage
Release Number
2.0
Release Date
October 2021
Content Type
User Guide
Publication ID
B700-1111-051K
Language
English (United States)

When ModelTable Contains Only One Model

SELECT * FROM [<schema>.]H2OPredict(
ON { table | view | (query) } [as InputTable]
ON { table | view | (query) }[as ModelTable] DIMENSION
USING
Accumulate(column|columns|'*')
[ ModelOutputFields(modelOutputField|modelOutputFields)  ]
[ OverwriteCachedModel(cached_model_name|'*')]
[ ModelType('DAI'|'OpenSource')]
[ EnableOptions('contributions','stageProbabilities','leafNodeAssignments')]
) as alias ;

When ModelTable Contains Multiple Models

SELECT * FROM [schema 
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(modelOutputField|modelOutputFields)  ]
[ OverwriteCachedModel(cached_model_name|'*')]
[ ModelType('DAI'|'OpenSource')]
[ EnableOptions('contributions','stageProbabilities','leafNodeAssignments')]
) as alias ;