H2OPredict Syntax Elements | Vantage BYOM - ONNXPredict Syntax Elements - Teradata Vantage

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Vantage
Release Number
5.0
Published
October 2023
Language
English (United States)
Last Update
2023-12-19
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
fee1607120608274
Accumulate
Specify one or more column names to add to the output table in a comma-separated list. Use an asterisk (*) to specify all columns.
ModelInputFieldsMap
[Optional] Specify one or more associations of input table columns to ONNX model inputs in a comma-separated list.
Multiple columns can map to a single ONNX model input tensor.
Table columns can be specified using column names or numerical positional indexes corresponding to columns.
ShowModelInputFieldsMap
[Optional] When set to true, the parameter does not run scoring, but shows the currently defined fields fully expanded. If ModelInputFieldsMap is not specified, the expected default mapping based on the ONNX inputs defined in the model is shown.
Example: If ModelinputFieldsMap is x=[1:4] and ShowModelInputFieldsMap is set to true, the output is returned as a varchar column:

ModelInputFieldsMap('x=sepal_len,sepal_wid,petal_len,petal_wid')

One row is produced for each AMP, but you can use TOP 1 in your SELECT statement to receive only one row back.The columns that are normally returned when scoring are still returned in the call, but are nulled out.
ModelOutputFields
[Optional] Specify the output fields to add as individual columns instead of the entire JSON output.
OverwriteCachedModel
[Optional] Valid values are: 'current_cached_model', '*', 'true', 't', 'yes', '1', 'false', 'f', 'no', 'n', or '0'. All of these values are equivalent as this argument applies only to the model specified in the model ON clause, which is assumed to be in the cache.
Important: Do not use the OverwriteCachedModel argument except when you are trying to replace a previously cached model. This applies to all models supported by BYOM. Using the argument in other cases, including in concurrent queries or multiple times within a short period of time, may lead to an OOM error from garbage collection not being fast enough.
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 or after 7 days if not used. 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 make sure that the Predict function uses the updated model instead of the cached model.
Default behavior: The function does not overwrite cached models.
IsDebug
[Optional] When true, debug statements are added to a trace table that must be created beforehand. See Error Logs.

Only available with BYOM version 3.00.00.02 and later.

Default: False