Summarizing Models

  1. Find the model you want to summarize.
  2. => SELECT * FROM v_catalog.models WHERE model_name='mySvmClassModel';
    -[ RECORD 1 ]--+------------------------------------------
    model_id       | 45035996273765414
    model_name     | mySvmClassModel
    schema_id      | 45035996273704978
    schema_name    | public
    owner_id       | 45035996273704962
    owner_name     | dbadmin
    category       | VERTICA_MODELS
    model_type     | SVM_CLASSIFIER
    is_complete    | t
    create_time    | 2017-02-14 10:30:44.903946-05
    size           | 525
  3. View the model summary.
  4. => SELECT SUMMARIZE_MODEL('mySvmClassModel');
    -[ RECORD 1 ]---+---------------------------------------------------------------------------------
    SUMMARIZE_MODEL 
    
     ===========================
    Predictors and Coefficients
    ===========================
        |Coefficients
    ----+------------
    mpg |  0.01116
    cyl |  0.00078
    disp|  -0.00074
    hp  |  0.01128
    drat|  0.00165
    wt  |  0.00037
    qsec|  0.00626
    vs  |  0.00042
    am  |  0.00047
    carb|  0.00047
        |  0.00033
    =====
    Notes
    =====
    Call string:
    SELECT svm_classifier('mySvmClassModel', 'mtcars', '"gear"', 'mpg,cyl,disp,hp,drat,wt,qsec,vs,am,carb'
    USING PARAMETERS optimizer='TRON', regularization='L2', cost='L2-SVM', C=1, max_iterations=100, epsilon=0.001);
    Number of rows accepted: 32
    Number of rows rejected: 0
    (1 row)

See Also