[Monetdb-developers] about Using Mal
Dear all, Recently,I am using MAL,using mclient -l mal command, If I use sql, I write a SQL: select * from t1; while t1 has two column c1 and c2,type is int. I want to ask what the corresponding MAL of this sql, if I us mclient -l mal ,what mal will I will use to implement the select * from t1 Best regards!
On Wed, Aug 18, 2010 at 03:05:11PM +0800, kun ren wrote:
Dear all, Recently,I am using MAL,using mclient -l mal command, If I use sql, I write a SQL: select * from t1; while t1 has two column c1 and c2,type is int. I want to ask what the corresponding MAL of this sql, if I us mclient -l mal ,what mal will I will use to implement the select * from t1
run
explain select * from t1;
that will show you the mal code.
Niels
Best regards!
This SF.net email is sponsored by
Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
Yes,I know expain. I mean I use MAL interface, write MAL instrction to implement it. I write the mal instrctions generated by the expain select * from t1,but it has errors.so I ask what mal when I use MAL interface ,not sql interface.
2010/8/18 Niels Nes Niels.Nes@cwi.nl
On Wed, Aug 18, 2010 at 03:05:11PM +0800, kun ren wrote:
Dear all, Recently,I am using MAL,using mclient -l mal command, If I use sql, I write a SQL: select * from t1; while t1 has two column c1 and c2,type is int. I want to ask what the corresponding MAL of this sql, if I us mclient -l mal ,what mal will I will use to implement the select * from t1
run
explain select * from t1;
that will show you the mal code.
Niels
Best regards!
This SF.net email is sponsored by
Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nlsip%3A4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
On 18-08-2010 15:21:30 +0800, kun ren wrote:
Yes,I know expain. I mean I use MAL interface, write MAL instrction to implement it. I write the mal instrctions generated by the expain select * from t1,but it has errors.so I ask what mal when I use MAL interface ,not sql interface.
use mclient -lmsql, that should do the trick.
Thanks ! But when I use mclient -lmsql, but it has a error, the error is :language option needs to be one of sql, mil, mal, or xquery?
Best regards!
2010/8/18 Fabian Groffen Fabian.Groffen@cwi.nl
On 18-08-2010 15:21:30 +0800, kun ren wrote:
Yes,I know expain. I mean I use MAL interface, write MAL instrction to implement it. I write the mal instrctions generated by the expain select
from t1,but it has errors.so I ask what mal when I use MAL interface ,not sql interface.
use mclient -lmsql, that should do the trick.
This SF.net email is sponsored by
Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
On Wed, Aug 18, 2010 at 03:53:49PM +0800, kun ren wrote:
Thanks ! But when I use mclient -lmsql, but it has a error, the error is :language option needs to be one of sql, mil, mal, or xquery?
sql (and msql) start the interpreter with a 'sql' context. You can create this by running sql.init();
After that the mal code should run.
Niels
Best regards!
2010/8/18 Fabian Groffen Fabian.Groffen@cwi.nl
On 18-08-2010 15:21:30 +0800, kun ren wrote: > Yes,I know expain. I mean I use MAL interface, write MAL instrction to > implement it. I write the mal instrctions generated by the expain select * > from t1,but it has errors.so I ask what mal when I use MAL interface ,not > sql interface. use mclient -lmsql, that should do the trick. ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
This SF.net email is sponsored by
Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
Yes, when I run successfully! But why I must running sql.init() and then can run mal code? Best regards!
2010/8/18 Niels Nes Niels.Nes@cwi.nl
On Wed, Aug 18, 2010 at 03:53:49PM +0800, kun ren wrote:
Thanks ! But when I use mclient -lmsql, but it has a error, the error is :language option needs to be one of sql, mil, mal, or xquery?
sql (and msql) start the interpreter with a 'sql' context. You can create this by running sql.init();
After that the mal code should run.
Niels
Best regards!
2010/8/18 Fabian Groffen Fabian.Groffen@cwi.nl
On 18-08-2010 15:21:30 +0800, kun ren wrote: > Yes,I know expain. I mean I use MAL interface, write MAL instrction to > implement it. I write the mal instrctions generated by the expain select * > from t1,but it has errors.so I ask what mal when I use MAL interface ,not > sql interface. use mclient -lmsql, that should do the trick.
This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
This SF.net email is sponsored by
Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nlsip%3A4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
On Wed, Aug 18, 2010 at 04:04:37PM +0800, kun ren wrote:
Yes, when I run successfully! But why I must running sql.init() and then can run mal code? Best regards!
The sql.init() initializes the sql catalog. The code coming from explain assumes these are there.
Niels
2010/8/18 Niels Nes Niels.Nes@cwi.nl
On Wed, Aug 18, 2010 at 03:53:49PM +0800, kun ren wrote: > Thanks ! > But when I use mclient -lmsql, but it has a error, the error is > :language option needs to be one of sql, mil, mal, or xquery? sql (and msql) start the interpreter with a 'sql' context. You can create this by running sql.init(); After that the mal code should run. Niels > > Best regards! > > 2010/8/18 Fabian Groffen <Fabian.Groffen@cwi.nl> > > On 18-08-2010 15:21:30 +0800, kun ren wrote: > > Yes,I know expain. I mean I use MAL interface, write MAL > instrction to > > implement it. I write the mal instrctions generated by the expain > select * > > from t1,but it has errors.so I ask what mal when I use MAL > interface ,not > > sql interface. > > use mclient -lmsql, that should do the trick. > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by > > Make an app they can't live without > Enter the BlackBerry Developer Challenge > http://p.sf.net/sfu/RIM-dev2dev > _______________________________________________ > Monetdb-developers mailing list > Monetdb-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ monetdb-developers > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by > > Make an app they can't live without > Enter the BlackBerry Developer Challenge > http://p.sf.net/sfu/RIM-dev2dev > _______________________________________________ > Monetdb-developers mailing list > Monetdb-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers -- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
This SF.net email is sponsored by
Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (3)
-
Fabian Groffen -
kun ren -
Niels Nes