QUANTILE( colname , 0 ) and QUANTILE( colname , 1 ) problem
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].
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 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].
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 ajdamico@gmail.com 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 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/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
-----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 ajdamico@gmail.com 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 <ajdamico@gmail.com 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
participants (3)
-
Anthony Damico
-
Sjoerd Mullender
-
Stefan Manegold