You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@madlib.apache.org by "Rahul Iyer (JIRA)" <ji...@apache.org> on 2019/02/21 00:30:00 UTC
[jira] [Resolved] (MADLIB-1302) MLP with minibatching fails on
postgres
[ https://issues.apache.org/jira/browse/MADLIB-1302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Iyer resolved MADLIB-1302.
--------------------------------
Resolution: Fixed
Fixed in [d199c4 | https://github.com/apache/madlib/commit/d199c4c0a415d9e5994ca774cdf0b41f19e45cdd]
> 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)