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.
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers