madlib-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From LUYAO CHEN <luyao_c...@hotmail.com>
Subject A problem of madlib.cross_validation_general
Date Thu, 26 Jul 2018 18:47:38 GMT
Dear user community,


I found a problem that could be a bug.  Could you explore?


It happened when the explore value is varchar, in the below case, I want to check the performance
of different optimizer, which in characters.


DROP TABLE IF EXISTS patients;
CREATE TABLE patients( id INTEGER NOT NULL,
                       second_attack boolean, -- second_attack integer,
                       treatment INTEGER,
                       trait_anxiety INTEGER);
INSERT INTO patients VALUES
(1,  True, 1, 70),
(2,  True, 1, 80),
(3,  True, 1, 50),
(4,  True, 0, 60),
(5,  True, 0, 40),
(6,  True, 0, 65),
(7,  True, 0, 75),
(8,  True, 0, 80),
(9,  True, 0, 70),
(10, True, 0, 60),
(11, FALSE, 1, 65),
(12, FALSE, 1, 50),
(13, FALSE, 1, 45),
(14, FALSE, 1, 35),
(15, FALSE, 1, 40),
(16, FALSE, 1, 50),
(17, FALSE, 0, 55),
(18, FALSE, 0, 45),
(19, FALSE, 0, 50),
(20, FALSE, 0, 60);


drop table  if exists  cv_result cascade;
SELECT madlib.cross_validation_general
    ( 'madlib.logregr_train',        -- modelling_func
        '{%data%, %model%, second_attack, "ARRAY[1, treatment, trait_anxiety]", null, 10,Optimizer,0.001,TRUE
 }'::varchar[],   -- modelling_params
        '{varchar, varchar, varchar, varchar, varchar,integer,varchar,double precision,boolean}'::varchar[],
                      --modelling_params_type
        'Optimizer',                                      --param_explored
        '{irls,cg,igd}'::varchar[],                                  --explore_values
        'madlib.cv_logregr_predict',                                             --predict_func
        '{%model%, %data%,"ARRAY[1, treatment, trait_anxiety]",%id%, %prediction%}'::varchar[],
                      --predict_params
        '{text, text, text,text, text}'::varchar[],                                  --predict_params_type
        'madlib.cv_logregr_accuracy',                                                    
  --metric_func
        '{%prediction%, %data%, %id%, second_attack, %error%}'::varchar[],               
--metric_params
        '{varchar, varchar, varchar,varchar, varchar}'::varchar[],                 --metric_params_type
        'patients',                                                          --data_tbl
        'id',                                        --data_id
         TRUE,                                                  --id_is_random
         'cv_result',                                         --validation_result
         '{id,second_attack, treatment, trait_anxiety}'::varchar[],                      
       --data_cols
         10                                                      --fold_num
);

ERROR:  spiexceptions.UndefinedColumn: column "irls" does not exist
LINE 5:                     (irls)::varchar as Optimizer,
                             ^
QUERY:
            DROP TABLE IF EXISTS __madlib_temp_accum_error84716681_1532630557_66836697__;
            CREATE TEMP TABLE __madlib_temp_accum_error84716681_1532630557_66836697__ as
                SELECT
                    (irls)::varchar as Optimizer,
                    pg_temp.__madlib_temp_output_error1973940_1532630557_11061763__.*
                FROM pg_temp.__madlib_temp_output_error1973940_1532630557_11061763__


CONTEXT:  Traceback (most recent call last):
  PL/Python function "cross_validation_general", line 23, in <module>
    return cross_validation.cross_validation_general(**globals())
  PL/Python function "cross_validation_general", line 366, in cross_validation_general
  PL/Python function "cross_validation_general", line 283, in _one_step_cv
PL/Python function "cross_validation_general"



Mime
View raw message