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/ # MonetDB/JAQL module loaded # MonetDB/SQL module loaded
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/ # MonetDB/JAQL module loaded # MonetDB/SQL module loaded
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
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
On Tue, Sep 30, 2014 at 1:13 PM, Martin Kersten 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/%3E # MonetDB/JAQL module loaded # MonetDB/SQL module loaded
users-list mailing list 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
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 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/> # MonetDB/JAQL module loaded # MonetDB/SQL module loaded > _______________________________________________ users-list mailing list 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
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
# 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/ # MonetDB/JAQL module loaded # MonetDB/SQL module loaded
On Tue, Sep 30, 2014 at 1:21 PM, Niels Nes 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 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/> # MonetDB/JAQL module loaded # MonetDB/SQL module loaded > _______________________________________________ users-list mailing list 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
users-list mailing list 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 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
On Tue, Sep 30, 2014 at 01:25:31PM -0400, 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/ # MonetDB/JAQL module loaded # MonetDB/SQL module loaded
I added the missing interface to the Jan2014 branch.
Niels
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
awesome! when's the expected release? thank you!!
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? thesedon't
> work either.. > > sql>select * from test where sample 0.1; > syntax error, unexpected SAMPLE in: "select * from test wheresample"
> > 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>> > 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 mysyntax
> 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' undefinedin:
> _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' undefinedin:
> _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
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
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
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
participants (4)
-
Anthony Damico -
Martin Kersten -
Niels Nes -
Sjoerd Mullender