[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