We're not sure yet. There are still a number of issues that I want to see fixed. Among others there is still some work to be done on the R integration code. I'm not completely happy yet, so I need to push Hannes to make some time for this. I don't expect him to have time this week. On 30/09/14 19:44, Anthony Damico wrote:
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 <mailto: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> > <mailto: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/> > > <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>> > > <mailto: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>> > <mailto: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/> > > <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>> <mailto: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>> > <mailto: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>> > <mailto: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> <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>> > <mailto:sip%3A4098@sip.cwi.nl <mailto:sip%253A4098@sip.cwi.nl> <mailto:sip%253A4098@sip.cwi.nl <mailto:sip%25253A4098@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>> > > <mailto: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>> > <mailto: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 > > > > -- > Sjoerd Mullender > > > _______________________________________________ > 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