[MADLIB-1238] MLP fails for dt_golf dataset

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v1.15
• Component/s: Module: Neural Networks
• Assignee: Jingyi Mei
• Reporter: Frank McQuillan
• Created: 22/May/18 23:56
• Updated: 02/Jul/18 19:49
• Resolved: 02/Jul/18 19:49

Description

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

 

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"