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

Niels Nes Niels.Nes at cwi.nl
Thu Oct 11 09:39:08 CEST 2007


On Thu, Oct 11, 2007 at 06:29:33AM +0200, darabi at 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" <Martin.Kersten at cwi.nl>
> To: darabi at web.de
> Cc: monetdb-developers at 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 at 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 at 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 at cwi.nl




More information about the developers-list mailing list