[
https://issues.apache.org/jira/browse/MADLIB-1302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Frank McQuillan closed MADLIB-1302.
-----------------------------------
> MLP with minibatching fails on postgres
> ---------------------------------------
>
> Key: MADLIB-1302
> URL: https://issues.apache.org/jira/browse/MADLIB-1302
> Project: Apache MADlib
> Issue Type: Bug
> Components: Deep Learning
> Reporter: Frank McQuillan
> Assignee: Rahul Iyer
> Priority: Major
> Fix For: v1.16
>
>
> If I run the MLP notebook
> https://github.com/apache/madlib-site/blob/asf-site/community-artifacts/MLP-mnist-v3.ipynb
> with MADlib 1.15.1 it fails on Postgres in "Section 2 : Train MLP model with
> mini-batch"
> {code}
> MADlib version: 1.15.1, git revision: rc/1.15.1-rc1, cmake configuration
> time: Wed Oct 10 04:29:25 UTC 2018, build type: Release, build system:
> Darwin-17.7.0, C compiler: Clang, C++ compiler: Clang
> {code}
> {code}
> PostgreSQL 9.6.7 on x86_64-apple-darwin16.7.0, compiled by Apple LLVM version
> 9.0.0 (clang-900.0.39.2), 64-bit
> {code}
> {code}
> InternalError: (psycopg2.InternalError) TypeError: must be string, not int
> 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 147, in mlp
> PL/Python function "mlp_classification", line 74, in quote_literal
> PL/Python function "mlp_classification"
> [SQL: "SELECT madlib.mlp_classification(\n 'mnist_train_packed',
> -- Packed table from preprocessor\n 'mnist_result', --
> Destination table\n 'independent_varname', -- Independent\n
> 'dependent_varname', -- Dependent\n ARRAY[100],
> -- Hidden layer sizes\n 'learning_rate_init=0.1,\n n_iterations=1,\n
> learning_rate_policy=const,\n lambda=0.0001, --
> Regularization\n tolerance=0',\n 'tanh', --
> Activation function\n '', -- No weights\n
> FALSE, -- No warmstart\n FALSE);
> -- Verbose"]
> {code}
> When I ran on Greenplum it did not fail on this query
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
