- developers-list - monetdb.org

[Monetdb-developers] about Using Mal
by kun ren 18 Aug '10

18 Aug '10

Dear all, Recently,I am using MAL,using mclient -l mal command, If I use sql, I write a SQL: select * from t1; while t1 has two column c1 and c2,type is int. I want to ask what the corresponding MAL of this sql, if I us mclient -l mal ,what mal will I will use to implement the select * from t1 Best regards!

3 8

[Monetdb-developers] about implement some application interface
by kun ren 16 Aug '10

16 Aug '10

Dear all, My test application want to implement two application interface over MonetDB , one is loading *.csv file to MonetDB, to implement this interface ,I use MonetDB's JDBC and "copy from" command to implement it. and another interface is select from one bat using select conditions, such as this C function: bat *selectfrombat(char * batname,char * select condition), how do I implement it?do MonetDB has something like "copy from " command,and so I will use jdbc and the command to implement it? or other method to implement it? I know one MAL instruction is algebra.uselect, and corresponding C function, do I just use the C function or alter the C fuction? Best regards,

1 0

[Monetdb-developers] Merge Tables MAL optimizer
by kun ren 13 Aug '10

13 Aug '10

dear all， Recently when I am reading MAL optimizer manual of MonetDB.and don't know the Merge Table optimizer,A merge association table (MAT). (1)How it perform optimize the MAL? (2) for this example, before optimize, m0:= bat.new(:oid,:int); m1:= bat.new(:oid,:int); m2:= bat.new(:oid,:int); b := mat.new(m0,m1,m2); s := algebra.select(b,1,3); i := aggr.count(s); io.print(s); io.print(i); c0 := bat.new(:int,:int); c1 := bat.new(:int,:int); c := mat.new(c0,c1); j := algebra.join(b,c); io.print(j); The selection and aggregate operations can simply be rewritten using a MAT: _33 := algebra.select(m0,1,3); _34 := algebra.select(m1,1,3); _35 := algebra.select(m2,1,3); s := mat.new(_33,_34,_35); i := 0:int; _36 := aggr.count(_33); i := calc.+(i,_36); Chapter 5: The MAL Optimizer 90 _37 := aggr.count(_34); i := calc.+(i,_37); _38 := aggr.count(_35); i := calc.+(i,_38); io.print(i); It seems that mat is very same with the bat.kunion, but what different between them, and how it optimizer the MAL? Best regards!

1 0

[Monetdb-developers] about MAL optimize
by kun ren 11 Aug '10

11 Aug '10

Dear everyone, Recently,I am intersting in MAL optimize，and have read the manual of the MAL optimize, but it is so long, Possible if we want to use mal optimize ,we must degignation the optimize consideration, such as alias removal, constant expression,join path optimizer;And then I dedug the MonetDB,but default it don't use any optimize.so what do you think about the mal optimize? Best regards.

3 9

[Monetdb-developers] About monetdb's thread
by kun ren 30 Jul '10

30 Jul '10

Dear all, hello,all, I download the windows installer of monetdb,and install,and then start MonetDB server, my computer has 4 cpus.and with 32bit windows xp ,but the MonetDB server only start one thread.when I run MonetDB in Linux with 2 cpus, it start 2 threads. so why? why I am in Windows xp with 4 cpus, it only create 1 thread ?

3 3

[Monetdb-developers] need help for extracting BAT
by Gaetano Fabiano 29 Jul '10

29 Jul '10

Hi all, i'm a new user of MonetDB. I worked on MonetDB/SQL and I can use well it. Now I need to use MonetDB directly with MAL. But i'm not so able to do that. I run the client with this command on linux: mclient -lmal -d database So I can write MAL istruction. But I don't need to create a procedure in MAL that doesn't access to my data. What I need to do is that: I need to give the BAT data of my DataBase and put all data on my application: example C++ ora Java array, after that I need to manipulate this BAT with my application and update the original BAT. How can I do that? summarizing i need: - Access to the BAT of the table of my Database. - Print it on monitor - Put it in array, file, stack, or any DataStruct with any programming language. - Set my manipulated BAT again in MonetDB. All of this is possible? Someone can help me? I'm sorry if I don't know the netiquette of your mailing list but I need to do that and I don't know where I could be helped. Thanks. Gaetano.

2 1

Re: [Monetdb-developers] MonetDB: Jun2010 - It seems the err output for the test was not ...
by Stefan Manegold 22 Jul '10

22 Jul '10

On Thu, Jul 22, 2010 at 11:53:22AM +0200, Romulo Goncalves wrote: > Changeset: 7a88e64c34b1 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7a88e64c34b1 > Modified Files: > sql/src/test/BugTracker-2010/Tests/connectto.Bug-2548.stable.err > sql/src/test/BugTracker-2010/Tests/connectto.Bug-2548.stable.out > Branch: Jun2010 > Log Message: > > It seems the err output for the test was not complete. > In the approval of the test two sql statements were missing, therefore, the err output was created without the errors related to that two statements. Thanks for taking care of this. My reason for not approving the error messages in the first place was that I was not sure about the intention of the test, and hence, whether and which error messages are to be expected. I now understand from your approval that the error messages indeed match the intention of the test. I wonder, though, whether the error message is indeed what it should be. Saying "failed: Success" (see below) seems at least "odd" to me ... Stefan > > diffs (32 lines): > > diff -r 6908fb1d95e4 -r 7a88e64c34b1 sql/src/test/BugTracker-2010/Tests/connectto.Bug-2548.stable.err > --- a/sql/src/test/BugTracker-2010/Tests/connectto.Bug-2548.stable.err Thu Jul 22 11:02:07 2010 +0200 > +++ b/sql/src/test/BugTracker-2010/Tests/connectto.Bug-2548.stable.err Thu Jul 22 11:53:14 2010 +0200 > @@ -71,9 +71,15 @@ > # 13:12:55 > mclient -lsql -ftest -i -e --host=rig --port=39884 > # 13:12:55 > > > -MAPI = monetdb@rig:39884 > +MAPI = monetdb@alviss:36310 > QUERY = connect to default; > ERROR = !CONNECT TO: DEFAULT is not supported! > +MAPI = monetdb@alviss:36310 > +QUERY = connect to 'whatever' port 50001 database 'nonexisting' USER 'monetdb' PASSWORD 'monetdb' LANGUAGE 'mal'; > +ERROR = !IOException:mapi.connect:Could not connect: gethostbyname failed: Success ^^^^^^ ^^^^^^^ !!!!!! ??????? > +MAPI = monetdb@alviss:36310 > +QUERY = disconnect 'whatever'; > +ERROR = !DISCONNECT CATALOG: no such db_alias 'whatever' > > # 13:12:55 > > # 13:12:55 > Done. > diff -r 6908fb1d95e4 -r 7a88e64c34b1 sql/src/test/BugTracker-2010/Tests/connectto.Bug-2548.stable.out > --- a/sql/src/test/BugTracker-2010/Tests/connectto.Bug-2548.stable.out Thu Jul 22 11:02:07 2010 +0200 > +++ b/sql/src/test/BugTracker-2010/Tests/connectto.Bug-2548.stable.out Thu Jul 22 11:53:14 2010 +0200 > @@ -23,8 +23,6 @@ > # 13:12:55 > mclient -lsql -ftest -i -e --host=rig --port=39884 > # 13:12:55 > > > -! to be provided / approved ! > - > # 13:12:55 > > # 13:12:55 > Done. > # 13:12:55 > > _______________________________________________ > Checkin-list mailing list > Checkin-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/checkin-list > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |

1 0

[Monetdb-developers] about debug monetdb on windows
by kun ren 20 Jul '10

20 Jul '10

Dear everyone, Some days ago,I debug monetdb on linux ,use eclipse + gdb, but now I want to debug and compile the monetdb on windows, please tell me how would i will do to compile and debug the monetdb. Best regards!

2 1

[Monetdb-developers] about copy command of Monetdb
by kun ren 20 Jul '10

20 Jul '10

Dear all, Recently,I use TPC-H test the Monetdb, On windows ,so I use "copy ,, records,,,into,,from" to load data to Monetdb,when the size of the file is about 700M,It is OK.But when the size is 1.4G,the Monetdb server is auto stop when loading. But when I am in Linux, it is no problem. So I want to ask why it is wrong on windows when the file is so large? Best regards,

1 0

[Monetdb-developers] Announcement: New Jun2010-SP1 bugfix release of MonetDB suite
by Sjoerd Mullender 17 Jul '10

17 Jul '10

The MonetDB team at CWI/MonetDB BV is pleased to announce the Jun2010-SP1 bug fix release of the MonetDB suite of programs. Lots of problems have been fixed, the most important one being the fix in the handling of database upgrades of databases created with the Feb2010 release to the current version. More information (including release notes) on this release is available at <http://monetdb.cwi.nl/Development/Releases/Jun2010/>. The download location has changed to <http://dev.monetdb.org/downloads/>. Please fix any bookmarks you may have. -- Sjoerd Mullender

2 1