Afra | 27 Jun 03:25 2015

[MADlib-user] Chi-Squared Independence Result Discrepancy

Hello all,

I am having different results returned from the madlib.chi2_gof_test function. Per the documentation at:

(under “Chi-squared independence test”), I receive the following results using the same arrays:

  ─[ RECORD 1 ]────────────────
statistic                  │ 320.125868955635
p_value                 │ 1.39464882809491e-63
df                          │ 9
phi                        │ 4.4730154045931
contingency_coef │ 0.975909209031126

(138.289841626008 is the expected value per the docs). 

I also noticed the SQL had some syntax issues, namely:

   sum(observed) OVER (PARTITION BY id_y) AS expected

(there doesn’t seem to be a column separating the two). 

Thank you very much for any guidance. 

MADlib user discussion mailing list
User <at>
(Continue reading)

John Langton | 16 May 19:59 2015

[MADlib-user] multinom function not found

Hello, I was just tryign to run the multinomial function and got an error
that the function does not exist. I checked the madlib schema and sure
enough I'm not finding it in there.

I installed maybe a few months ago. Is there an easy way to check madlib
version? Is this a new function? Any idea why it would be missing?




John T. Langton, Ph.D.
VisiTrend, Inc.
John Langton | 1 Apr 17:58 2015

[MADlib-user] what values are allowed for ARIMA non-seasonal orders

The input parameter is specified as an int[3]

Just wondering what values can be passed into that, 0, 1, 2 or any int?

BTW: I keep getting this message using the mail app on a mac, even when
specifying a plain text format: "The message's content type was not
explicitly allowed"
Rahul Iyer | 28 Mar 16:59 2015

Re: [MADlib-user] Random Forest classification

You could write the SQL for such a random classifier.
For eg. using the dt_golf dataset from decision tree example page
<>, we
can produce random classes as:

SELECT class, classes[trunc(random()*2 + 1)] as random_class
FROM dt_golf,

(SELECT ARRAY['Play', 'Don''t Play'] as classes) q1;

In the query, the expression trunc(random()*2 + 1 computes a random integer
between 1 and 2. You would need to replace '2' with the number of classes
in your data.

- Rahul

On Fri, Mar 27, 2015 at 8:56 PM, <dpopova@...> wrote:

> Rahul,
> Sorry to bug you on the weekend. But does MADlib have a random classifier?
> Something that puts random values into the class variable, to establish a
> baseline for a particular dataset?
> For example, WEKA has ZeroR classifier.
> Thank you,
> Diana
> > Yes. That's the goal of tree_predict (signature below):
(Continue reading)

dpopova | 26 Mar 02:42 2015

[MADlib-user] Random Forest classification

Dear all,

I am trying to run forest_train function on a dataset. I have already
successfully trained this data using tree_train. But the forest_train
gives the following error message:
dianapopova=# \c maddb
You are now connected to database "maddb" as user "dianapopova".
maddb=# SELECT madlib.forest_train('madlib.pull_request_class_merged',
maddb(# 'forest_output',
maddb(# 'pull_req_id',
maddb(# 'merged',
maddb(# '*',
maddb(# NULL
maddb(# );
ERROR:  AttributeError: 'NoneType' object has no attribute 'strip'
CONTEXT:  Traceback (most recent call last):
  PL/Python function "forest_train", line 41, in <module>
  PL/Python function "forest_train", line 279, in forest_train
  PL/Python function "forest_train", line 1486, in _forest_validate_args
PL/Python function "forest_train"
Could you please advise?

Thank you,

AJ Welch | 3 Jan 08:31 2015

[MADlib-user] Distribute on pgxn?

Looks like madlib was distributed on pgxn at one point:

Why was 1.3 the last distribution? Not enough support to make it a priority?

Bryan Bickford | 11 Dec 20:01 2014

[MADlib-user] Concurrency Support

I was wondering what level of concurrency is supported in MADlib 1.6.

I have a multi user/multi database system. Since madpack installs on
seperate databases, I assume that there is concurrency support built in
across databases?

Can the same be said for multiple users simultaneously accessing the same
database with the same or different madlib function calls?

Gareth James | 9 Dec 21:46 2014

[MADlib-user] Redshift

Is the postgres version used at Amazon Redshift supported by madlib?
Ioannis Atsonios | 9 Sep 11:12 2014

Re: [MADlib-user] Welcome to the "User" mailing list


On Tue, Sep 9, 2014 at 12:20 PM, <user-request@...> wrote:

> Welcome to the User@... mailing list!
> To post to this list, send your email to:
>   user@...
> General information about the mailing list is at:
> If you ever want to unsubscribe or change your options (eg, switch to
> or from digest mode, change your password, etc.), visit your
> subscription page at:
> You can also make such adjustments via email by sending a message to:
>   User-request@...
> with the word `help' in the subject or body (don't include the
> quotes), and you will get back a message with instructions.
> You must know your password to change your options (including changing
> the password, itself) or to unsubscribe.  It is:
(Continue reading)

afancy | 7 Sep 19:29 2014

[MADlib-user] compile error on MADlib 1.6 + PostgreSQL9.3


I compile Madlib1.6 againt postgresql 9.3 on Ubuntu 12.04. But there is an
It would be apprecaiated if anybody could help . Thanks


root <at> xiliu-ubuntu:/tmp/madlib-1.6.0# make
make -C build all
make[1]: Entering directory `/tmp/madlib-1.6.0/build'
make[2]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  1%] Built target EP_eigen
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  2%] Built target EP_pyxb
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  2%] Built target pythonFiles
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  2%] Built target sqlFiles
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  2%] Built target madlibPatches
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
(Continue reading)

Nitin Borwankar | 7 Aug 20:47 2014

[MADlib-user] compiling madlib on other platforms

Hello all,

This may sound extremely "out there" but I am curious if it is possible to
build madlib on a Raspberry Pi and bind it into Postgres.

I have run Postgres 9.1 which is installable via apt-get and am looking for
how to install 9.2 or 9.3 which may involve building on the Pi which is
rumored to take all night.
All this is on Raspbian which is a Debian Wheezy port.

Once I have the requisite Postgres can madlib be installed on it using the
usual install from source or is the ARM platform a non-starter?


Nitin Borwankar