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/> # 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
-- 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
# 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 -- 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
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
-- Sjoerd Mullender
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? 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
-- 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
-- Sjoerd Mullender
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 ;-) ).
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
On 30/09/14 19:37, Anthony Damico wrote: 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
> > 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
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
participants (4)
-
Anthony Damico -
Martin Kersten -
Niels Nes -
Sjoerd Mullender