[jira] [Created] (MADLIB-1238) MLP rails for dt_golf dataset

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

Frank McQuillan created MADLIB-1238:
---------------------------------------

             Summary: MLP rails for dt_golf dataset
                 Key: MADLIB-1238
                 URL: https://issues.apache.org/jira/browse/MADLIB-1238
             Project: Apache MADlib
          Issue Type: Bug
          Components: Module: Neural Networks
            Reporter: Frank McQuillan


For the dt_golf data set from 
http://madlib.apache.org/docs/latest/group__grp__decision__tree.html#examples
MLP fails

 {code}
SELECT madlib.mlp_classification( 'dt_golf', 'mlp_model_2', '"Temp_Humidity"', 'class', ARRAY[5], 'learning_rate_init=0.1, n_iterations=10, tolerance=0', 'relu', NULL, FALSE, TRUE );
ERROR: spiexceptions.SyntaxError: syntax error at or near "t"
LINE 9: ...p_dep_var_norm72383676_1526602175_13763735__='Don't Play',__...
 ^
QUERY:
 SELECT
 array_to_string(ARRAY[Null], ',') AS __madlib_temp_col_grp_key66624757_1526602175_949550__,
 NULL,
 1 AS __madlib_temp_col_grp_iteration58741248_1526602175_20584655__,
 (
 madlib.mlp_igd_step(
 (__madlib_temp_ind_var_norm46776457_1526602175_44392250__)::DOUBLE PRECISION[],
 (ARRAY[__madlib_temp_dep_var_norm72383676_1526602175_13763735__='Don't Play',__madlib_temp_dep_var_norm72383676_1526602175_13763735__='Play']::integer[])::DOUBLE PRECISION[],
 __madlib_temp_rel_state87474628_1526602175_41807780__.__madlib_temp_col_grp_state62184949_1526602175_41368190__,
 ARRAY[ 2,5,2 ]::DOUBLE PRECISION[],
 (0.1)::FLOAT8,
 0,
 1,
 (1)::DOUBLE PRECISION,
 (NULL::DOUBLE PRECISION[])::DOUBLE PRECISION[],
 0,
 0.9::FLOAT8,
 True::boolean
 )
 ) AS __madlib_temp_col_grp_state62184949_1526602175_41368190__
 FROM (
 SELECT *,
 array_to_string(ARRAY[Null], ',') AS __madlib_temp_col_grp_key66624757_1526602175_949550__
 FROM __madlib_temp_tbl_data_scaled90737274_1526602175_8324315__
 ) AS _src
 JOIN ( SELECT grp_key AS __madlib_temp_col_grp_key66624757_1526602175_949550__,state AS __madlib_temp_col_grp_state62184949_1526602175_41368190__ FROM madlib._gen_state($1, NULL, $2) ) AS __madlib_temp_rel_state87474628_1526602175_41807780__
 ON TRUE
 JOIN ( SELECT unnest($3) AS __madlib_temp_col_grp_key66624757_1526602175_949550__, unnest($4) AS __madlib_temp_col_n_tuples86886826_1526602175_68539375__ ) AS _rel_n_tuples
 ON TRUE


CONTEXT: Traceback (most recent call last):
 PL/Python function "mlp_classification", line 36, in <module>
 grouping_col
 PL/Python function "mlp_classification", line 45, in wrapper
 PL/Python function "mlp_classification", line 334, in mlp
 PL/Python function "mlp_classification", line 576, in update
PL/Python function "mlp_classification"
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)