Re: [Monetdb-developers] MAL access to tables created with SQL

On Thu, Oct 11, 2007 at 06:29:33AM +0200, darabi@web.de wrote:

OK. Is there a way of seeing what MAL gets executed, when a statement is issued? By modifying the log level or sth. like that?

in m5/sql run your query with explain select * from tables or debug select * from tables this should give you some more insight. Niels

Thanks

Kambiz

----- Original Message ----- From: "Martin Kersten" To: darabi@web.de Cc: monetdb-developers@lists.sourceforge.net Sent: Mittwoch, 10. Oktober 2007 23.50 Uhr (GMT+0100) Europe/Berlin Subject: Re: [Monetdb-developers] MAL access to tables created with SQL

darabi@web.de wrote:

...

Hello,

how is it possible to access in a MAL client session (mclient -l mal) the BATs of tables which were created previously in sql?

You can't, because the mapping of SQL to BATs is maintained in the SQL private catalog. Also, each column in SQL has multiple bats.

------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl