UPGRADE_MODEL
Upgrades a model from a previous Vertica version. Vertica automatically runs this function during a database upgrade and if you run the IMPORT_MODELS function. Manually call this function to upgrade models after a backup or restore.
If UPGRADE_MODEL fails to upgrade the model and the model is of category VERTICA_MODELS, it cannot be used for in-database scoring and cannot be exported as a PMML model.
Syntax
UPGRADE_MODEL ( [ USING PARAMETERS [model_name = 'model‑name'] ] )
Parameters
model_name
|
Name of the model to upgrade. If you omit this parameter, Vertica upgrades all models on which you have privileges. |
Privileges
Non-superuser: Upgrades only models that the user owns.
Examples
Upgrade model myLogisticRegModel
:
=> SELECT UPGRADE_MODEL( USING PARAMETERS model_name = 'myLogisticRegModel'); UPGRADE_MODEL ---------------------------- 1 model(s) upgrade (1 row)
Upgrade all models that the user owns:
=> SELECT UPGRADE_MODEL(); UPGRADE_MODEL ---------------------------- 20 model(s) upgrade (1 row)