[MADLIB-1209] Neural nets fails on Greenplum 4.3.x when verbose argument set to TRUE

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: v1.14
• Component/s: Module: Neural Networks
• Assignee: Unassigned
• Reporter: Frank McQuillan
• Created: 21/Feb/18 01:03
• Updated: 14/Mar/18 21:53
• Resolved: 22/Feb/18 03:16

Description

In

mlp_classification(
    source_table,
    output_table,
    independent_varname,
    dependent_varname,
    hidden_layer_sizes,
    optimizer_params,
    activation,
    weights,
    warm_start,
    verbose,
    grouping_col
    )

when the `verbose` argument is set to `TRUE` the following error results:

ERROR:  plpy.SPIError: function array_length(double precision[], integer) does not exist (plpython.c:4656)

LINE 4:                             _state_current[array_length(_sta...

                                                   ^

HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

QUERY: 

            SELECT

               

                            _state_current[array_length(_state_current,1)] AS loss

                          ,

                __madlib_temp_col_grp_key29688300_1519168141_31322353__

            FROM (

                SELECT grp_key AS __madlib_temp_col_grp_key29688300_1519168141_31322353__, state AS _state_current FROM madlib._gen_state($3, NULL, $4)

           ) subq1

           

CONTEXT:  Traceback (most recent call last):

  PL/Python function "mlp_classification", line 33, in <module>

    grouping_col

  PL/Python function "mlp_classification", line 290, in mlp

  PL/Python function "mlp_classification", line 455, in get_param_value_per_group

PL/Python function "mlp_classification"

because `array_length` does not exist in Greenplum 4.3.x .

It works OK in Greenplum 5.x and Postgres 9.x/10 however.

Issue Links

• links to: GitHub Pull Request #238