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

Martin Kersten Martin.Kersten at cwi.nl
Wed Oct 10 23:50:27 CEST 2007

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.
> I have tried different versions of bat.new, and bbp.bind. I tried
> different naming schemes (e.g. "tablename_columnname" which was
> mentioned somewhere in the docs), but I always get 
> Referenced BAT not found
> And when I try to use sql.bind, I get
> SQLException:mvc:MAL_SCENARIO_PARSER not initialized
> Another question: is there a way of seeing the MAL translation of sql
> queries? EXPLAIN works great for SELECT statements, but it doesn't
> translate DDL expressions like CREATE TABLE.
No, we are in the process to also open up this facility for some 
optimization steps.
> Many thanks
> Kambiz
> -------------------------------------------------------------------------
> 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

More information about the developers-list mailing list