It appears that the problem is in sql/scripts/39_analytics.sql. It's missing bindings for stdev and stdevp.
For stdev, at least, it seems that one can mimic median with something like the following:
create aggregate stdev(val TINYINT) returns TINYINT
external name "aggr"."stddev";
create aggregate stdev(val SMALLINT) returns SMALLINT
external name "aggr"."stddev";
create aggregate stdev(val INTEGER) returns INTEGER
external name "aggr"."stddev";
create aggregate stdev(val BIGINT) returns BIGINT
external name "aggr"."stddev";
create aggregate stdev(val REAL) returns REAL
external name "aggr"."stddev";
create aggregate stdev(val DOUBLE) returns DOUBLE
external name "aggr"."stddev";
create aggregate stdev(val DATE) returns DATE
external name "aggr"."stddev";
create aggregate stdev(val TIME) returns TIME
external name "aggr"."stddev";
create aggregate stdev(val TIMESTAMP) returns TIMESTAMP
external name "aggr"."stddev";
This can of course be run through the mclient, so anyone needing to patch their environment prior to this bug being fixed might be able to just run these manually.
I've included this info in the bug.
Cheers,
Percy
On Mon, Nov 5, 2012 at 1:42 AM, Fabian Groffen
<Fabian.Groffen@cwi.nl> wrote:
On 04-11-2012 08:10:51 -0500, Anthony Damico wrote:
> a 2010 post offering to add these functions to the main release code.
>
> [2]http://mail.monetdb.org/pipermail/users-list/2010-January/003836.html
>
> What would be the easiest way to get MonetDB to produce standard deviations,
> variances, and quantiles (let's say the 25th percentile)?
>
> From the discussion list, it looks like people have succeeded in doing it,
> but they're probably much more advanced users than I am. ;)
http://bugs.monetdb.org/show_bug.cgi?id=2454#c18 suggests stddev and
median have been added (niels), so if they aren't there, file a new bug,
or reopen the old one.
Fabian
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
--
Percy Wegmann
+1 512 637 8500 ext 148