why is my SAMPLE percentage limiter throwing an error?

Anthony Damico

30 Sep 2014 30 Sep '14

5:09 p.m.

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

...

Attachments:

attachment.html (text/html — 1.6 KB)

Show replies by date

Martin Kersten

30 Sep 30 Sep

5:13 p.m.

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

Anthony Damico

5:17 p.m.

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 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

Niels Nes

5:21 p.m.

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 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

Anthony Damico

5:25 p.m.

# 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 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 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

Niels Nes

5:31 p.m.

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

Sjoerd Mullender

5:32 p.m.

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 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 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

Anthony Damico

5:37 p.m.

awesome! when's the expected release? thank you!! On Tue, Sep 30, 2014 at 1:32 PM, Sjoerd Mullender 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 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 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

Sjoerd Mullender

5:41 p.m.

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 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 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 > 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> > > 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> > > 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> > > 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%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> > > _______________________________________________ > users-list mailing list > 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

Anthony Damico

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 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 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
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 > 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> > > 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> > > 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> > > 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%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> > > _______________________________________________ > users-list mailing list > 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

Sjoerd Mullender

5:59 p.m.

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 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 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 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 > > 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>> > > > 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>> > > > 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>> > > > 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%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>> > > > > _______________________________________________ > > 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>> > > 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> > > 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> > 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

3813

Age (days ago)

3813

Last active (days ago)

List overview

Download

10 comments

4 participants

participants (4)

Anthony Damico
Martin Kersten
Niels Nes
Sjoerd Mullender

why is my SAMPLE percentage limiter throwing an error?

tags

participants (4)