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) |