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)