Hello Hannes, The MIL language is deprecated and only used still in the XQuery front-end. The SQL compiles into MAL and server version >=5. See the documentation about SQL. regards, Martin Hannes Rauhe wrote:

Hello together,

I installed MonetDB with the help of the latest monetdb-install.sh and played around with MIL. Now I'm stuck with translating a simple SQL-Query containing a GROUPBY.

After starting the server with # Mserver --dbname test --dbinit 'module(mapi); mil_start();' and the client with # ./mclient -lmil -utest -dname=test

I tried the following:

var a:= bat(oid,int); a.insert(1@0, 1995); a.insert(2@0, 1992); a.insert(3@0, 1993); a.insert(4@0, 1994); a.insert(5@0, 1995); a.insert(6@0, 1996); CTgroup(a).print();

the answer is:

ERROR: const operation on a BAT ERROR: CMDconstCopy: operation failed. ERROR: interpret_params: print(param 1): evaluation error.

Another try after loading the xtables-Module:

mil>module("xtables"); mil>CTgroup(a).print(); +-------------------------------------------------------+ | � | +-------------------------------------------------------+ 1 tuple

I used a few papers and http://monetdb.cwi.nl/MonetDB/Version4/Documentation/mil/index.html (Chapter 3.7 is what I'm looking for) as tutorial but didn't find anything helpful.

Where's my mistake?

Best Regards, Hannes

------------------------------------------------------------------------

------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo

------------------------------------------------------------------------

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users