Re: stddev function disappeared?

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2013-03-14 10:24, Anthony Damico wrote:

Thanks Sjoerd!

For some reason, I believe these commands break when there's a GROUP BY included in the query. I've pasted the error below. Should I run using -X and submit a formal bug report?

Yes, please, submit a bug report. Looks like an omission.

Both of these work fine:

sql>select stddev_pop(pppymt_ip) from b09;

sql>select stddev_samp(pppymt_ip) from b09;

But then include any GROUP BY and they break--

sql>select stddev_pop(pppymt_ip) from b09 group by metro; TypeException:user.s5_1[9]:'aggr.substdevp' undefined in: _17:bat[:any,:dbl] := aggr.substdevp(_3:bat[:oid,:dbl], _14:bat[:oid,:oid], r1_14:bat[:oid,:oid], _1:b it) program contains errors

sql>select stddev_samp(pppymt_ip) from b09 group by metro; TypeException:user.s6_1[9]:'aggr.substdev' undefined in: _17:bat[:any,:dbl] := a ggr.substdev(_3:bat[:oid,:dbl], _14:bat[:oid,:oid], r1_14:bat[:oid,:oid], _1:bit ) program contains errors

# MonetDB 5 server v11.15.1 "Feb2013" # Serving database 'bsapuf', using 8 threads # Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked # Found 7.860 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50003/ http://127.0.0.1:50003/ # MonetDB/JAQL module loaded # MonetDB/SQL module loaded

...

On Wed, Mar 13, 2013 at 9:40 AM, Sjoerd Mullender mailto:sjoerd@acm.org> wrote:

Use either stddev_samp or stddev_pop depending on whether it's a standard deviation over a sample or over the population.

On 2013-03-13 13:28, Anthony Damico wrote:

...

Hello, I'm trying to run some old code with a recent upgrade of MonetDB and the standard deviation function appears to have disappeared. I'm running MonetDB on Windows.

...

This issue was previously discussed and resolved in this thread:

http://old.nabble.com/users-list-Digest%2C-Vol-3%2C-Issue-8-tt34660082.html#...

...

I could re-open this bug report if appropriate? http://bugs.monetdb.org/show_bug.cgi?id=2454#c18

...

My server specs are below, and the actual commands below that.

...

Thank you!!!

...

# MonetDB 5 server v11.15.1 "Feb2013" # Serving database 'bsapuf', using 8 threads # Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked # Found 7.860 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50003/ http://127.0.0.1:50003/ http://127.0.0.1:50003/ # MonetDB/JAQL module loaded # MonetDB/SQL module loaded

...

...

c:\Program Files\MonetDB\MonetDB5>mclient -p 50003 "bsapuf" user(win32):monetdb password: Welcome to mclient, the MonetDB/SQL interactive terminal (Feb2013) Database: MonetDB v11.15.1 (Feb2013), 'bsapuf' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select sum( hha_pmt_amt ) from hha08; +-----------+ | L1 | +===========+ | 675676300 | +-----------+ 1 tuple (2.311ms) sql>select sum( hha_pmt_amt ), avg( hha_pmt_amt ) from hha08; +-----------+--------------------------+ | L1 | L2 | +===========+==========================+ | 675676300 | 5412.8151310993435 | +-----------+--------------------------+ 1 tuple (63.559ms) sql>select sum( hha_pmt_amt ), median( hha_pmt_amt ) from hha08; +-----------+------+ | L1 | L2 | +===========+======+ | 675676300 | 3500 | +-----------+------+ 1 tuple (9.601ms) sql>select sum( hha_pmt_amt ), stddev( hha_pmt_amt ) from hha08; SELECT: no such unary operator 'stddev(int)' sql>select sum( hha_pmt_amt ), sd( hha_pmt_amt ) from hha08; SELECT: no such unary operator 'sd(int)' sql>select sum( hha_pmt_amt ), sddev( hha_pmt_amt ) from hha08; SELECT: no such unary operator 'sddev(int)' sql>select sum( hha_pmt_amt ), var( hha_pmt_amt ) from hha08; SELECT: no such unary operator 'var(int)' sql>select sum( hha_pmt_amt ), variance( hha_pmt_amt ) from hha08; SELECT: no such unary operator 'variance(int)' sql>select sum( hha_pmt_amt ), stdevp( hha_pmt_amt ) from hha08; SELECT: no such unary operator 'stdevp(int)' sql>

...

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.13 (GNU/Linux) Comment: Using GnuPG with undefined - http://www.enigmail.net/ iQCVAwUBUUGoVT7g04AjvIQpAQJ2bwQAvHtFaG5FYD9ymJTpyMK55k0OfphkAJ7v k0NgWyhWBXLNSyL0sWu4EHL5X33P5S/07dEceV+h2s1mp5k/iW8ehGDbEJx7NrEY C5lkkZhuUtHgHfQ75CUcu84ftC92LLed9cNzky4sOisMdlRo4GwZDl6eUnjWslOq okf49pSonEo= =4y3M -----END PGP SIGNATURE-----