Vertica ML GET_MODEL_SUMMARY got error

davdsdavds Vertica Customer

I am new to Vertica ML model, I have try LOGISTIC_REG model, i can create the model. but when I do
select GET_MODEL_SUMMARY(USING PARAMETERS model_name='iot_test');
got the error said:
ODBC Database Error: ERROR 3457: Function GET_MODEL_SUMMARY() does not exist, or permission is denied for GET_MODEL_SUMMARY()

Best Answers

  • Vertica_CurtisVertica_Curtis Employee
    Answer ✓

    Great! Don't hesitate to reach out again if you run into questions. Glad to help.

Answers

  • SruthiASruthiA Vertica Employee Administrator

    what is your vertica version?

  • davdsdavds Vertica Customer

    V8

  • davdsdavds Vertica Customer

    v8.1.1. thanks for quick response

  • SruthiASruthiA Vertica Employee Administrator

    GET_MODEL_SUMMARY was introduced in 9.0. Hence what you are seeing is expected as vertica 8.x doesn't contain that function.

  • davdsdavds Vertica Customer

    thanks!

  • davdsdavds Vertica Customer

    SELECT apn,is_iot, predict_logistic_reg(bytesup,bytesdown
    USING PARAMETERS model_name='iot_test_ds'
    )
    AS Prediction
    FROM tmp_iot_train;
    got the error:
    ERROR 3457: Function predict_logistic_reg( int, int) does not exist, or permission is denied for predict_logistic_reg(int, int)

    any thought on this?

  • SruthiASruthiA Vertica Employee Administrator

    Are apn, is_iot columns from tmp_iot_train table? Can you share me the output of following

    SELECT SUMMARIZE_MODEL('iot_test_ds');

  • davdsdavds Vertica Customer

    Hi, Sruthia: I sent the result to you via email last Friday, if you did not receive it please let me know

    thanks

  • davdsdavds Vertica Customer

    I found the issue: need to put "public" before procedure. it works now.. thanks all your great support!

  • davdsdavds Vertica Customer

    Hi,

    now I tried to first balance data then normalize data, all these steps work fine.
    but when I tried to create the model and I got error: "Unsupported column type [Numeric(2,2)] for column [bytesup_home]"
    what is data type need for this model?
    Thanks


    SELECT BALANCE('balance_iot_balance_data', 'tmp_iot_wa_cls_train_data', 'is_iot', 'under_sampling'
    USING PARAMETERS sampling_ratio = 0.05);
    SELECT NORMALIZE('normalized_iot_balance_data', 'balance_iot_balance_data', 'bytesup_home,bytesup_work,bytesdown_home,bytesdown_work,dur_home,dur_work', 'minmax');
    -----------format column
    create or replace view normalized_iot_balance_data_v as
    select imei,firstcgi,apn,cfrc
    ,bytesup_home::NUMERIC(2, 2) bytesup_home
    ,bytesup_work::NUMERIC(2, 2) bytesup_work
    ,bytesdown_home::NUMERIC(2, 2) bytesdown_home
    ,bytesdown_work::NUMERIC(2, 2) bytesdown_work
    ,dur_home::NUMERIC(2, 2) dur_home
    ,dur_work::NUMERIC(2, 2) dur_work
    ,record_cnt
    ,cft
    ,bearer_type
    ,is_iot
    ,part
    from normalized_iot_balance_data;


    SELECT public.RF_CLASSIFIER(
    'iot_rf_test_ds',
    'sandbox.normalized_iot_balance_data_v',
    'is_iot',
    'cfrc,bytesup_home,bytesup_work,bytesdown_home,bytesdown_work,dur_home,dur_work,record_cnt,cft,bearer_type'
    USING PARAMETERS ntree=50, sampling_size=0.2
    );
    DBC Database Error: ERROR 8135: Problem in rf_classifier.
    Detail: Cannot compute input column list.
    Detail: Unsupported column type [Numeric(2,2)] for column [bytesup_home]

  • SruthiASruthiA Vertica Employee Administrator

    What you are seeing is expect. We don't support NUMERIC type for RF_CLASSIFER in 8.1.1. We support it in 9.2. please check predictor_columns Argument Description in the below links

    https://www.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/MachineLearning/RANDOM_FOREST_CLASSIFIER.htm

    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/MachineLearning/RF_CLASSIFIER.htm

  • davdsdavds Vertica Customer

    great, Sruthia.. thanks for your lighting response....

  • davdsdavds Vertica Customer

    Thanks!

  • davdsdavds Vertica Customer

    In V8, any function can be used for evaluating feature importance? like RF_PREDICTOR_IMPORTANCE in v9

  • davdsdavds Vertica Customer

    In V9, has any function to identify similar variables and Removing redundant features so we can increase accuracy?

  • davdsdavds Vertica Customer

    totally agree with you! thanks... based on my current study, RF already gave me pretty accurate predication and I just want to explore more possible feature in V8. we will upgrade to V9 soon, we will test all these new features.

    thanks again, all your feedback were very helpful!!

  • davdsdavds Vertica Customer

    actually this is a first time I used Vertica support forum, you guys did awesome job! was much and much better than oracle support, lol
    thanks again and have a good weekend....

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file