[Monetdb-developers] about Using Mal

kun ren

18 Aug 2010 18 Aug '10

7:05 a.m.

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!

Attachments:

attachment.html (text/html — 348 bytes)

Show replies by date

Niels Nes

18 Aug 18 Aug

7:10 a.m.

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.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

kun ren

7:21 a.m.

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

...

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.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

Fabian Groffen

7:48 a.m.

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.

kun ren

7:53 a.m.

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

...

...
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

On 18-08-2010 15:21:30 +0800, kun ren wrote: *

...
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

Niels Nes

7:58 a.m.

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

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

kun ren

8:04 a.m.

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

...

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

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

Niels Nes

8:08 a.m.

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

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 > > 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

Fabian Groffen

7:59 a.m.

On 18-08-2010 15:53:49 +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?

what client do you use?

5194

Age (days ago)

5194

Last active (days ago)

List overview

Download

8 comments

3 participants

participants (3)

Fabian Groffen
kun ren
Niels Nes