[jira] [Created] (MADLIB-952) Type error in elastic net

["Frank McQuillan (JIRA)" <ji...@apache.org>]

Frank McQuillan created MADLIB-952:
--------------------------------------

             Summary: Type error in elastic net
                 Key: MADLIB-952
                 URL: https://issues.apache.org/jira/browse/MADLIB-952
             Project: Apache MADlib
          Issue Type: Bug
          Components: Module: Regularized Regression
            Reporter: Frank McQuillan


First check the columns which are text or character using the following code: 

select 
   column_name, data_type
from 
   information_schema.columns
   where table_schema='analytics'
   and table_name='discharge_train' 
   and data_type in ('character varying','text')

It gave me the following result. 

"cohort_assignment";"text"
"providergender";"character varying"
"locationname";"character varying"
"patientkey";"character varying"

Then this is the code I used for elastic net. 

DROP TABLE IF EXISTS analytics.elastic_net_logistic;
SELECT madlib.elastic_net_train( 'analytics.discharge_train',
                                 'analytics.elastic_net_train_result',
                                 'readmission < 0',
                                 '*',
                                 'binomial',
                                 0.6,
                                 0.02,
                                 TRUE,
                                 NULL,
                                 'fista',
                                 '',
                                'totalemergencyvisits_in_current_visit  , totalgimvisits_in_current_visit  , 
                                  totalcardiologyvisits_in_current_visit  , total_time_in_medical_short_inpatient  , 
                                  totalacupulmonaryvisits_in_current_visit  , current_complain_  ,
                                  total_current_dea_ciii, curr_rx_gen_lactated_ringers  ,patientkey  , 
                                  totalobservationvisits_in_current_visit, total_unitsvisited_before_admission  , 
                                  totalpcuneurovisits_in_current_visit , totalicuvisits_in_current_visit  ,curr_rx_gen_oxycodone_w_  , 
                                  total_time_in_medical_short_in_er , totalmfmvisits_in_current_visit  , 
                                  totalmedsurgvisits_in_current_visit  , hospitalaccountrecord, inpatientadmitdatetime  ,totalongvisits_in_current_visit,
                                  no_null_days_btw_admissions,cohort_assignment,locationname,providergender,patientkey',
                                 10000,
                                 1e-6
                               );

If you check in exlcuded list of variables, at the very last I have excluded the character or text variables. 

It still gives me this error. 



                           Elastic Net error: All columns to be included in the

                           independent variables should be of the same numeric type.

Context: Traceback (most recent call last):

  PL/Python function "elastic_net_train", line 23, in <module>

    return elastic_net.elastic_net_train(**globals())

  PL/Python function "elastic_net_train", line 308, in elastic_net_train

  PL/Python function "elastic_net_train", line 427, in analyze_input_str

PL/Python function "elastic_net_train"


Please note I have also tried by dropping all the character or text variables and then passing it to elastic net code. And it still gives me the same error.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)