You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@madlib.apache.org by "Frank McQuillan (JIRA)" <ji...@apache.org> on 2018/05/22 23:57:00 UTC
[jira] [Updated] (MADLIB-1238) MLP fails for dt_golf dataset
[ https://issues.apache.org/jira/browse/MADLIB-1238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Frank McQuillan updated MADLIB-1238:
------------------------------------
Summary: MLP fails for dt_golf dataset (was: MLP rails for dt_golf dataset)
> MLP fails 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
> Priority: Major
> Fix For: v1.15
>
>
> 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)