With Jul2015-SP2 release as well as the latest version of the Jul2015 branch (changeset e2aafc304c04),
these indeed appear to work fine:

sql>create table my_table (my_id clob, my_double double);
operation successful (9.317ms)
sql>SELECT COUNT( DISTINCT my_id ) AS unique_enrollees , QUANTILE( my_double , 0.25 ) AS some_quantile FROM my_table;
+------------------+--------------------------+
| unique_enrollees | some_quantile            |
+==================+==========================+
|                0 |                     null |
+------------------+--------------------------+
1 tuple (3.639ms)



However, with te latest version of the default branch (changeset c6a29bdbc3d5),
they fail with the following error (no crash, though):

sql>create table my_table (my_id clob, my_double double);
operation successful (1.789ms)
sql>SELECT COUNT( DISTINCT my_id ) AS unique_enrollees , QUANTILE( my_double , 0.25 ) AS some_quantile FROM my_table;
TypeException:user.s3_1[21]:'aggr.quantile' undefined in:     aggr.quantile(X_35:bat[:dbl]);
program contains errors



Please file a bug report.

Thanks!


Stefan

----- On Feb 23, 2016, at 12:20 AM, Anthony Damico ajdamico@gmail.com wrote:

> they do work in the latest release but they crash monetdblite, making me wonder
> about the root culprit.. thanks all
>
>
> create table my_table (my_id clob, my_double double);
> SELECT COUNT( DISTINCT my_id ) AS unique_enrollees , QUANTILE( my_double , 0.25
> ) AS some_quantile FROM my_table;
>
>

> _______________________________________________
> 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) |
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list