kaknikhil commented on pull request #564:
URL: https://github.com/apache/madlib/pull/564#issuecomment-829713147
Calling non minibatched data with adam or rmsprop does not fail gracefully.
We should throw a helpful error message
```
SELECT madlib.mlp_classification( 'iris_data', 'mlp_model',
'attributes','class_text',ARRAY[5], 'learning_rate_init=1.5,
learning_rate_policy=constant, n_iterations=50, tolerance=0, rho=0.9,
solver=rmsprop','tanh', NULL, FALSE, TRUE);
ERROR: spiexceptions.UndefinedColumn: column "attributes" does not exist
LINE 8: (attributes)::DOUBLE PRECISION[]...
^
SELECT
array_to_string(ARRAY[Null], ',') AS
__madlib_temp_col_grp_key91737014_1619741694_53757093__,
NULL,
1 AS
__madlib_temp_col_grp_iteration76439383_1619741694_35069372__,
(
madlib.mlp_alr_step(
(attributes)::DOUBLE PRECISION[],
(ARRAY[(__madlib_temp_dep_var_norm96411952_1619741693_22150079__) =
'Iris-setosa', (__madlib_temp_dep_var_norm96411952_1619741693_22150079__) =
'Iris-versicolor', (__madlib_temp_dep_var_norm96411952_1619741693_22150079__) =
'Iris-virginica']::INTEGER[])::DOUBLE PRECISION[],
__madlib_temp_rel_state18952145_1619741694_43645987__.__madlib_temp_col_grp_state22584915_1619741694_5254854__,
ARRAY[ 4,40,3 ]::DOUBLE PRECISION[],
(1.5)::FLOAT8,
2,
1,
(1)::DOUBLE PRECISION,
(NULL::DOUBLE PRECISION[])::DOUBLE PRECISION[],
0,
1::integer,
1::integer,
1::integer,
0.9::FLOAT8,
0.9::FLOAT8,
0.999::FLOAT8,
1e-07::FLOAT8
)
) AS
__madlib_temp_col_grp_state22584915_1619741694_5254854__
FROM (
SELECT *,
array_to_string(ARRAY[Null], ',') AS
__madlib_temp_col_grp_key91737014_1619741694_53757093__
FROM
__madlib_temp_tbl_data_scaled39150522_1619741693_1119413__
) AS _src
JOIN ( SELECT grp_key AS
__madlib_temp_col_grp_key91737014_1619741694_53757093__,state AS
__madlib_temp_col_grp_state22584915_1619741694_5254854__ FROM
madlib._gen_state($1, NULL, $2) ) AS
__madlib_temp_rel_state18952145_1619741694_43645987__
ON TRUE
JOIN ( SELECT unnest($3) AS
__madlib_temp_col_grp_key91737014_1619741694_53757093__, unnest($4) AS
__madlib_temp_col_n_tuples6669658_1619741694_1063457__ ) AS _rel_n_tuples
ON TRUE
CONTEXT: Traceback (most recent call last):
PL/Python function "mlp_classification", line 33, in <module>
grouping_col)
PL/Python function "mlp_classification", line 42, in wrapper
PL/Python function "mlp_classification", line 381, in mlp
PL/Python function "mlp_classification", line 576, in update
PL/Python function "mlp_classification"
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
