PMMLPredict Syntax Elements | Vantage BYOM - 2.0 - PMMLPredict Syntax Elements - 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)
schema
[Optional] Specify the schema in which PMMLPredict is installed.
Default: mldb
Accumulate
Specify one or more InputTable columns to copy to the output table. The asterisk specifies all InputTable columns.
An accumulate_column cannot have the reserved column name 'prediction' or 'json_report' or the data type BLOB or CLOB.
You cannot specify the same accumulate_column more than once.
ModelOutputFields
[Optional] Specify the scoring fields to output as individual columns (instead of outputting the JSON string that contains all the scoring output fields). For information about PMML output fields, see http://dmg.org/pmml/v4-2-1/Output.html.
To specify a model_output_field that is not in the JSON string is an error.
Default behavior: The function outputs the JSON string that contains all the output fields in the output table column json_report.
OverwriteCachedModel
[Optional] Specify either the identifier (model_id) of a cached model (to clear a model from the cache) or an asterisk (to clear the cache).
If a model loaded into the memory of the node fits in the cache, it stays in the cache until being evicted to make space for another model that needs to be loaded. Therefore, a model can remain in the cache after the query that loaded it completes. Other queries that use the same model can use it, saving the cost of reloading it into memory.
You want to overwrite a cached model only when it has been updated, to ensure that the PMMLPredict function uses the updated model instead of the cached model.
Default behavior: The function does not overwrite cached models.