On Tue, Sep 30, 2014 at 1:32 PM, Sjoerd Mullender <sjoerd@monetdb.org> wrote:

There is indeed an interface missing.
See changeset 6e3e5f0fc1b2 that I just pushed. This is now fixed on the
Oct2014 branch since it is unlikely that we will create another bugfix
release on the Jan2014 branch.

On 30/09/14 19:25, Anthony Damico wrote:
>
>
> # 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
>>
>
> On Tue, Sep 30, 2014 at 1:21 PM, Niels Nes <Niels.Nes@cwi.nl
> <mailto:Niels.Nes@cwi.nl>> wrote:
>
> 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
> <Martin.Kersten@cwi.nl <mailto:Martin.Kersten@cwi.nl>>

> > 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/>
> <http://127.0.0.1:50000/>
> > # MonetDB/JAQL module loaded
> > # MonetDB/SQL module loaded
> > >
> >
> >
> > _______________________________________________
> > users-list mailing list

> > users-list@monetdb.org <mailto:users-list@monetdb.org>
> > https://www.monetdb.org/mailman/listinfo/users-list
> >
> >
> >
> > _______________________________________________
> > users-list mailing list
> > users-list@monetdb.org <mailto:users-list@monetdb.org>
> > https://www.monetdb.org/mailman/listinfo/users-list
> >
> >
>
> > _______________________________________________
> > users-list mailing list
> > users-list@monetdb.org <mailto: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 <tel:%2B%2B31%2020%20592-4098>
> sip:4098@sip.cwi.nl <mailto:sip%3A4098@sip.cwi.nl>
> url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
> <mailto:Niels.Nes@cwi.nl>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org <mailto: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
>

--

Sjoerd Mullender

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