[jira] [Closed] (MADLIB-1111) MADlib Random Forest EOFException when calling from JDBC

["Frank McQuillan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/MADLIB-1111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Frank McQuillan closed MADLIB-1111.
-----------------------------------

Closing since working OK for Paul now.

> MADlib Random Forest EOFException when calling from JDBC
> --------------------------------------------------------
>
>                 Key: MADLIB-1111
>                 URL: https://issues.apache.org/jira/browse/MADLIB-1111
>             Project: Apache MADlib
>          Issue Type: Bug
>            Reporter: Paul Chang
>
> We are calling forest_train from Java via JDBC and we are receiving the following error:
> [08006] An I/O error occurred while sending to the backend.
> java.io.EOFException
> We see this only with MADlib 1.9.1 and 1.10.0, but not 1.9.0.
> Here's a script that reproduces the problem:
> DROP TABLE IF EXISTS credit_test1;
> CREATE TABLE credit_test1 (
>   id INTEGER NOT NULL,
>   times90dayslate INTEGER,
>   revolving_util NUMERIC(19, 10),
>   debt_ratio NUMERIC(19, 10),
>   credit_lines BIGINT,
>   monthly_income DOUBLE PRECISION,
>   times30dayslate_2years INTEGER,
>   srsdlqncy INTEGER
> );
> INSERT INTO credit_test1 (id, times90dayslate, revolving_util, debt_ratio, credit_lines, monthly_income, times30dayslate_2years, srsdlqncy)
> VALUES
>   (1, 0, 0.26, 0.324, 4, 1956.59, 0, 0),
>   (1, 0, 0.46, 0.372, 7, 3595.37, 0, 0),
>   (1, 0, 0.14, 0.690, 7, 2507.17, 0, 0),
>   (1, 0, 0.32, 0.188, 7, 5158.11, 0, 0),
>   (1, 0, 0.17, 0.343, 4, 1108.77, 0, 0),
>   (1, 0, 0.37, 0.385, 5, 3893.31, 0, 0),
>   (1, 0, 0.34, 0.452, 3, 2848.79, 0, 0),
>   (1, 1, 0.47, 0.509, 7, 2158.23, 1, 1),
>   (1, 0, 0.35, 0.104, 6, 4285.52, 0, 0),
>   (1, 0, 0.30, 0.043, 4, 1334.18, 0, 0);
> DROP TABLE IF EXISTS credit_aftest, credit_aftest_group, credit_aftest_summary;
> SELECT "madlib"."forest_train"(
>   /* training table */   'credit_test1',
>   /* output table */     'credit_aftest',
>   /* id col */           'id',
>   /* dependent col */    'credit_lines',
>   /* feature cols */     'revolving_util, debt_ratio, monthly_income',
>   /* exclude cols */     CAST(NULL AS text),
>   /* grouping cols */    CAST(NULL AS text),
>   /* num trees */        10,
>   /* num rand feat */    CAST(NULL AS integer),
>   /* var importance */   FALSE,
>   /* num permutations */ 1,
>   /* max depth */        10,
>   /* min split */        20,
>   /* min bucket */       CAST(NULL AS integer),
>   /* num splits */       10,
>   /* surrogate param */  CAST(NULL AS text),
>   /* verbose? */         FALSE,
>   /* sample ratio */     1.0);



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)