You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@madlib.apache.org by "Nikhil (JIRA)" <ji...@apache.org> on 2017/12/11 17:16:00 UTC
[jira] [Updated] (MADLIB-1185) Postgres 10 support for MADlib with
large tables
[ https://issues.apache.org/jira/browse/MADLIB-1185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nikhil updated MADLIB-1185:
---------------------------
Description:
Running MADlib on postgres10 with a large dataset ( 98000 rows with a double array column) causes the database to crash.
Repro Steps
{code}
1. create table foo (id integer, x double precision[], y integer);
2. Insert at least 1 million rows like these
id | x | y
-------+-------------------------+---
97440 | {1,0.2,0,1,0,1,0,0,0,0} | 1
3. Now running any C madlib UDF followed by a count(*) of foo will cause the database to crash
select madlib.poisson_random(1); select count(*) from foo;
or
select madlib.svec_plus('{1}:{5}', '{1}:{4}'); select count(*) from foo;
{code}
was:
Running MADlib on postgres10 with a large dataset ( 98000 rows with a double array column) causes the database to crash.
Repro Steps
{code}
1. create table foo (id integer, x double precision[], y integer);
2. Insert 98000 rows like these
id | x | y
-------+-------------------------+---
97440 | {1,0.2,0,1,0,1,0,0,0,0} | 1
3. Now running any C madlib UDF followed by a count(*) of foo will cause the database to crash
select madlib.poisson_random(1); select count(*) from foo;
or
select madlib.svec_plus('{1}:{5}', '{1}:{4}'); select count(*) from foo;
{code}
> Postgres 10 support for MADlib with large tables
> ------------------------------------------------
>
> Key: MADLIB-1185
> URL: https://issues.apache.org/jira/browse/MADLIB-1185
> Project: Apache MADlib
> Issue Type: Bug
> Components: DB Abstraction Layer
> Reporter: Nikhil
> Fix For: v1.13
>
>
> Running MADlib on postgres10 with a large dataset ( 98000 rows with a double array column) causes the database to crash.
> Repro Steps
> {code}
> 1. create table foo (id integer, x double precision[], y integer);
> 2. Insert at least 1 million rows like these
> id | x | y
> -------+-------------------------+---
> 97440 | {1,0.2,0,1,0,1,0,0,0,0} | 1
> 3. Now running any C madlib UDF followed by a count(*) of foo will cause the database to crash
> select madlib.poisson_random(1); select count(*) from foo;
> or
> select madlib.svec_plus('{1}:{5}', '{1}:{4}'); select count(*) from foo;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)