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