MODELS

Lists details about the machine-learning models in the database.

Column Name	Data Type	Description
`MODEL_ID`	INTEGER	The model's internal ID.
`MODEL_NAME`	VARCHAR(128)	The name of the model.
`SCHEMA_ID`	INTEGER	The schema's internal ID.
`SCHEMA_NAME`	VARCHAR(128)	The name of the schema.
`OWNER_ID`	INTEGER	The model owner's ID.
`OWNER_NAME`	VARCHAR(128)	The user who created the model.
`CATEGORY`	VARCHAR(128)	The type of model. By default, models created in Vertica are assigned to the Vertica_Models category.
`MODEL_TYPE`	VARCHAR(128)	The type of algorithm used to create the model.
`IS_COMPLETE`	VARCHAR(128)	Denotes whether the model is complete and ready for use in machine learning functions. This field is usually false when the model is being trained. Once the training is complete, the field is set to true.
`CREATE_TIME`	TIMESTAMPTZ	The time the model was created.
`SIZE`	INTEGER	The size of the model in bytes.

Examples

=> SELECT * FROM models;
-[ RECORD 1 ]------------------------------
model_id    | 45035996273714020
model_name  | myLinearRegModel
schema_id   | 45035996273704980
schema_name | public
owner_id    | 45035996273704962
owner_name  | dbadmin
category    | VERTICA_MODELS
model_type  | LINEAR_REGRESSION
is_complete | t
create_time | 2018-01-22 11:13:35.018412-05
size        | 1671