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

We hope to release in October (hence the name ;-) ).

On 30/09/14 19:37, Anthony Damico wrote:
> awesome! when's the expected release? thank you!!
>
> On Tue, Sep 30, 2014 at 1:32 PM, Sjoerd Mullender <sjoerd@monetdb.org
> <mailto: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/>
> > <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>
> > <mailto: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>
> <mailto: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/>
> > <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> <mailto: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>
> <mailto: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>
> <mailto: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> <tel:%2B%2B31%2020%20592-4098>
> > sip:4098@sip.cwi.nl <mailto:sip%3A4098@sip.cwi.nl>
> <mailto:sip%3A4098@sip.cwi.nl <mailto:sip%253A4098@sip.cwi.nl>>
> > url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
> <mailto:Niels.Nes@cwi.nl>
> > <mailto:Niels.Nes@cwi.nl <mailto:Niels.Nes@cwi.nl>>
> >
> > _______________________________________________
> > users-list mailing list
> > users-list@monetdb.org <mailto:users-list@monetdb.org>
> <mailto: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
> >
>
> --

> Sjoerd Mullender
>
>
> _______________________________________________
> 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