重命名模型

ALTER MODEL 允许您重命名模型。例如：

1. 查找您要更改的模型。

   => SELECT * FROM V_CATALOG.MODELS WHERE model_name='mymodel';
   -[ RECORD 1 ]--+------------------------------------------
   model_id       | 45035996273816618
   model_name     | mymodel
   schema_id      | 45035996273704978
   schema_name    | public
   owner_id       | 45035996273704962
   owner_name     | dbadmin
   category       | VERTICA_MODELS
   model_type     | kmeans
   is_complete    | t
   create_time    | 2017-03-02 11:16:04.990626-05
   size           | 964
   

2. 重命名模型。

   => ALTER MODEL mymodel RENAME TO mykmeansmodel;
        ALTER MODEL
   

3. 查看 V_CATALOG.MODELS 以验证模型名称是否已更改。

   => SELECT * FROM V_CATALOG.MODELS WHERE model_name='mykmeansmodel';
   

   
   -[ RECORD 1 ]--+------------------------------------------
   model_id       | 45035996273816618
   model_name     | mykmeansmodel
   schema_id      | 45035996273704978
   schema_name    | public
   owner_id       | 45035996273704962
   owner_name     | dbadmin
   category       | VERTICA_MODELS
   model_type     | kmeans
   is_complete    | t
   create_time    | 2017-03-02 11:16:04.990626-05
   size           | 964