Re: why is my SAMPLE percentage limiter throwing an error?

30 Sep 2014


      On Tue, Sep 30, 2014 at 01:17:07PM -0400, Anthony Damico wrote:
...
even with a where statement, what would the structure be?  these don't
work either..
sql>select * from test where sample 0.1;
syntax error, unexpected SAMPLE in: "select * from test where sample"
sql>select * from test where uniform sample 0.1;
SELECT: identifier 'uniform' unknown
Indeed sample is supposed to work (without where). Its sort of similar
to limit. It seems the (mal) interface for the 'percentage' case is
missing or broken. On which version are you testing this?

Niels
...
On Tue, Sep 30, 2014 at 1:13 PM, Martin Kersten 
wrote:
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

...
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
-- 
Niels Nes, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14,  phone ++31 20 592-4098 	sip:4098@sip.cwi.nl
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes@cwi.nl