SUMMARIZE_MODEL
Returns the summary information of a model.
Note: If you are using Vertica 8.1.0, you must include the owner parameter. For Vertica 8.1.1 and later, the owner parameter has been deprecated.
Important: Before using a machine learning function, be aware that all the ongoing transactions might be committed.
Syntax
SUMMARIZE_MODEL ( 'model_name' [, 'owner'] )
Parameters
model_name |
The name of the model you want to summarize. Model names are case insensitive. |
owner |
(Optional) The name of the user who created the model. |
Privileges
Any user can see summary information about any model in the database.
Examples
This example shows how you can view the summary of a linear regression model.
=> SELECT SUMMARIZE_MODEL('linear_reg_faithful'); -[ RECORD 1 ]---+----------------------------------------------------------------------------------------------------------------------- SUMMARIZE_MODEL | coeff names : {Intercept, waiting} coeffecients: {-2.067947819, 0.07875927383} std_err: {0.21063, 0.0029203} t_value: {-9.8178, 26.969} p_value: {4.2157e-18, 2.1094e-61} Number of iterations: 6, Number of skipped samples: 0, Number of processed samples: 162 Call: linearReg(model_name=linear_reg_faithful, input_table=faithful_training, response_column=eruptions, predictor_columns=waiting, exclude_columns=, optimizer=bfgs, epsilon=0.0001, max_iterations=50)