Perhaps you forgot the WHERE ?
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/Sampling

regards, Martin

On 30/09/14 19:09, Anthony Damico wrote:

sorry if this is a silly question..  i'm trying to sample a percentage of a table.  from https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/Sampling  it looks like these should work, but i must be making a mistake in my syntax somewhere?  thanks!!



create table test ( a int , b double precision );
insert into test values( 1 , 3.3 );
insert into test values( 13 , 2.3 );
insert into test values( 3 , 0.3 );


select * from test sample 0.1 ;

TypeException:user.s12_1[9]:'sample.subuniform' undefined in: _18:any := sample.
subuniform(_15:bat[:oid,:int], _16:dbl)
program contains errors

select * from test uniform sample 0.1 ;

TypeException:user.s13_1[9]:'sample.subuniform' undefined in: _18:any := sample.
subuniform(_15:bat[:oid,:int], _16:dbl)
program contains errors





# MonetDB 5 server v11.17.21 "Jan2014-SP3"
# Serving database 'demo', 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-2014 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:50000/ <http://127.0.0.1:50000/>
# MonetDB/JAQL module loaded
# MonetDB/SQL module loaded
 >


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

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