Re: QUANTILE( colname , 0 ) and QUANTILE( colname , 1 ) problem

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Note that the quantile *does* work if you specify the extremes as 0.0 and 1.0. And I seriously doubt (looking at the MAL plan) that implementing quantile 0 with min and quantile 1 with max will solve the problem when you specify the extremes as 0 or 1 (it may improve speed, and therefore it is still not a bad idea, but that is another issue). On 21/07/15 07:08, Stefan Manegold wrote:

Guess the shirt answer is: no-one thought of / implemented it so far. We'll see what we can do when.

Stefan

On July 21, 2015 2:56:03 AM CEST, Anthony Damico wrote:

hi team, any chance you could give this a look before the next release candidate? i'm confused why QUANTILEs of 0 and 1 don't go straight to MIN and MAX.. thanks!

On Mon, Jul 13, 2015 at 8:24 PM, Anthony Damico mailto:ajdamico@gmail.com> wrote:

hi monetdb team, i am getting errors below on data i can't share. before i spend a bunch of time trying to create a reproducible example for this:

i've confirmed that MIN and MAX both do work on this column, and also that QUANTILE works with 0.01 thru 0.99 on this column. is there a reason QUANTILEs of 0 and 1 don't simply call MIN and MAX? thanks!

Error in .local(conn, statement, ...) : Unable to execute statement 'SELECT QUANTILE( tot_pay , 0 ) FROM acons WHERE yr = 2013 AND ( dattyp1 = 1 OR dattyp2 = 1 OR dattyp...'. Server says 'overflow in conversion of 43553.818965373482 to bte.' [#22003].

...

unwtd_pct <- dbGetQuery( db , paste( "SELECT QUANTILE( tot_pay

, 1 ) FROM acons" , where_clause ) ) Error in .local(conn, statement, ...) : Unable to execute statement 'SELECT QUANTILE( tot_pay , 1 ) FROM acons WHERE yr = 2013 AND ( dattyp1 = 1 OR dattyp2 = 1 OR dattyp...'. Server says 'overflow in conversion of 43553.818965373482 to bte.' [#22003].

...

----------------------------------------------------------------------

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold http://www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJVrfyVAAoJEISMxT6LrWYgM5cIAMBzgT3VnMtopunFDpXFIEvg pe+wQevN9xhMulDxRa5VqfGl8YpJTbpgKbFzifnwV9DPH4orVaks8clK2OPGrWA8 gWSoCJeoxD6fAKGuHc0g1yn7ch2RaQJcoPs5bpVIhrURSwfoJh672NJDmvbNogvV p3s9U9ydcbSiH/xnoirkjeLrp4d6+yf9aj0nHXnd0HT90irB0WTWR9JWw1XkzFhN mn26CRER+xNrVTNWFLXVUdEUI8Xm01TMMBv8dk3E5Q+FO3U1z+tsQTCQ32bwUCS8 xXjb63Vb1V0/9sRjx9i9uNAdHTmC1J6YGG46zWg/kO3mxG+LxD1pOLNqLrHLuKg= =haOU -----END PGP SIGNATURE-----