SQL Language Guide > SQL Language Guide > Elements of SQL Statements > Machine Learning Model (MLM) SQL Syntax > MLM Type Matching
Was this helpful?
MLM Type Matching
The input and output types of the model, which can be extracted using saved_model_cli, must exactly match the types in the CREATE MODEL specification, based on the mapping table.
Note:  When invoking the model, however, we transparently cast input columns to the required types, if possible.
MLM Type
SQL Type
DT_INT32
int4/integer
DT_INT64
int8/bigint
DT_FLOAT
float4
DT_DOUBLE
float8/float
DT_BOOL
boolean
DT_STRING
varchar(n)
Last modified date: 12/19/2024