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