30 Sep
2014
30 Sep
'14
5:44 p.m.
haha obviously, but could you be more specific? i want to run a bunch of tests on the new MonetDB.R and it'd be nice to use the newest build.. no big deal if you're not sure :) thank you!
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 onthe
Oct2014 branch since it is unlikely that we will create anotherbugfix
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 dynamicallylinked
> # 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>>> 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 testwhere sample"
> > > > sql>select * from test where uniform sample 0.1; > > SELECT: identifier 'uniform' unknown > > Indeed sample is supposed to work (without where). Its sort ofsimilar
> 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> > 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 furtherinformation
> > # Listening for connection requests onmapi: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