Re: Data Vault:SyntaxException

Please read the error message. It says that your SQL environment in MAL has not been initialized, which requires a call to sql.start() first. On 8/6/13 11:12 AM, integrity wrote:

Hi, I have tried ", it doesnt work.

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 = !SQLException:mvc:SQL module not initialized mal>

------------------ Original ------------------ *From: * "357416268"<357416268@qq.com>; *Date: * Tue, Aug 6, 2013 05:01 PM *To: * "Communication channel for MonetDB users"; *Subject: * Re: Data Vault:SyntaxException

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