删除模型
DROP MODEL
从数据库中移除一个或多个模型。例如:
-
查找您要删除的模型。
=> SELECT * FROM V_CATALOG.MODELS WHERE model_name='mySvmClassModel'; -[ RECORD 1 ]--+-------------------------------- model_id | 45035996273765414 model_name | mySvmClassModel schema_id | 45035996273704978 schema_name | public owner_id | 45035996273704962 owner_name | dbadmin category | VERTICA_MODELS model_type | SVM_CLASSIFIER is_complete | t create_time | 2017-02-14 10:30:44.903946-05 size | 525
-
删除模型。
=> DROP MODEL mySvmClassModel; DROP MODEL
-
查看
V_CATALOG.MODELS
以验证模型是否已删除。=> SELECT * FROM V_CATALOG.MODELS WHERE model_name='mySvmClassModel'; (0 rows)