Re: why is my SAMPLE percentage limiter throwing an error?

30 Sep 2014


      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