Re: Data Vault:SyntaxException

Hi, String literals in MAL are differently quoted than SQL. Use " instead of ' regards, Martin On 08/06/2013 11:01 AM, integrity wrote:

Hi Stefan, there is still some thing wrong with the query simply using fits.attatch....

*mal>fits.attach('/home/data1/20130111_177d550752_60d851283-530.fit');* MAPI = (monetdb) /tmp/.s.monetdb.50000 QUERY = fits.attach('/home/data1/20130111_177d550752_60d851283-530.fit'); ERROR = !SyntaxException:parseError:fits.attach('/home/data1/20130111_177d550752_60d851283-530.fit'); !SyntaxException:parseError: ^',' expected mal> mal>

------------------ Original ------------------ *From: * "Stefan Manegold"; *Date: * Tue, Aug 6, 2013 03:10 PM *To: * "Communication channel for MonetDB users"; *Subject: * Re: Data Vault:SyntaxException

Hi,

there is no "call" in MAL, hence, it's simply: fits.attach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

please refer to the MAL documentation at http://www.monetdb.org/Documentation/Manuals/MonetDB/MALreference and further.

Stefan

----- Original Message -----

...

hi all,

What's the correct way to use FIT DATA VAULT in mal?

I got the following errors and still havent try out the right syntax ......

[svomhpc@localhost /home/data2]$>/home/data1/opt/MonetDB.fits/bin/mclient -lmal -dmydb Welcome to mclient, the MonetDB interactive terminal (unreleased) Type \q to quit, \? for a list of available commands mal>?fits.attach() pattern fits.attach(fname:str):void address FITSattach; comment Open a FITS file and return catalog of the table HDUs

mal>call

fits.attach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

...

MAPI = (monetdb) /tmp/.s.monetdb.50000 QUERY = call

fits.attach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

...

ERROR = !SyntaxException:parseError:call

fits.attach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

...

!SyntaxException:parseError: ^';' expected mal> mal> mal>call

fitsattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

...

MAPI = (monetdb) /tmp/.s.monetdb.50000 QUERY = call

fitsattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

...

ERROR = !SyntaxException:parseError:call

fitsattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

...

!SyntaxException:parseError: ^';' expected mal> mal>call

FITSattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

...

MAPI = (monetdb) /tmp/.s.monetdb.50000 QUERY = call

FITSattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

...

ERROR = !SyntaxException:parseError:call

FITSattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

...

!SyntaxException:parseError: ^';' expected

Thanks! Meng _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list .

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list