[EMAIL PROTECTED] 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-developers >
------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
