This topic describes how to manage the models that you create in or import to Lindorm AI.
View all models
After you successfully execute the CREATE MODEL statement, run the following SQL statement to view information about all models.
Syntax
SHOW MODELS;Example
SHOW MODELS;The following result is returned:
+------------------------------+--------+--------------+-------------------------------+-------------------------------+
| name | status | sql_function | created_time | update_time |
+------------------------------+--------+--------------+-------------------------------+-------------------------------+
| sr_model_para | READY | ai_infer | 2024-01-18T15:56:14.289+08:00 | 2024-01-18T15:59:47.956+08:00 |
| bge_model | READY | ai_infer | 2024-01-30T18:49:05.941+08:00 | 2024-01-30T18:49:28.053+08:00 |
| Qwen-14B | READY | ai_infer | 2024-01-31T20:43:36.081+08:00 | 2024-01-31T20:45:08.790+08:00 |
| hr_model | READY | ai_infer | 2024-01-19T11:38:53.970+08:00 | 2024-01-19T11:41:17.195+08:00 |
+------------------------------+--------+--------------+-------------------------------+-------------------------------+The following table describes the return values.
Return value | Description |
name | The model name. |
status | The model status. Valid values: INIT (initialization), PREPARE (preparing), TRAINING (training), READY (ready for model inference), and FAILED (failed). |
sql_function | The function used for inference. The value depends on the TASK parameter that you set when you create the model. |
created_time | The time when the model was created. |
update_time | The time when the model was last updated. |
View a specific model
After you successfully execute the CREATE MODEL statement, run the following SQL statement to view information about a specific model.
Syntax
SHOW MODEL model_name;Example
SHOW MODEL bge_model;The following result is returned:
+-----------+--------+--------------+--------------------+--------------+-------+---------------+----------------------------------------------------+---------+-------+----------+-------------------------------+-------------------------------+
| name | status | sql_function | task_type | algorithm | query | preprocessors | settings | metrics | error | progress | created_time | update_time |
+-----------+--------+--------------+--------------------+--------------+-------+---------------+----------------------------------------------------+---------+-------+----------+-------------------------------+-------------------------------+
| bge_model | READY | ai_infer | FEATURE_EXTRACTION | BGE_LARGE_ZH | | [] | {repo_name=huggingface, | {} | null | null | 2024-01-30T18:49:05.941+08:00 | 2024-01-30T18:49:28.053+08:00 |
| | | | | | | | infer_engine_model_name=BAAI_bge-large-zh-v1.5_py} | | | | | |
+-----------+--------+--------------+--------------------+--------------+-------+---------------+----------------------------------------------------+---------+-------+----------+-------------------------------+-------------------------------+The following table describes the return values.
Return value | Description |
task_type | The task type. |
algorithm | The algorithm name. |
query | The search statement used for model training. |
preprocessors | The pre-processing syntax. |
settings | The parameter settings. |
metrics | The model metrics. |
error | The error message. If no error occurs, null is returned. |
progress | The model creation progress. If the creation process is complete, null is returned. |
Delete the specified model
Run the following SQL statement to delete a specific model.
Syntax
DROP MODEL model_name;Example
DROP MODEL bge_model;