Re: Data Vault:SyntaxException

Hi Jennie, it doesnt return means mal>fits.attach("/home/data1/20130111_177d550752_60d851283-530.fit"); cannot return back to mal> after a long time wait... I will follow you advice to find fits_table anyway:) Thanks! Meng ------------------ Original ------------------ From: "Ying Zhang"; Date: Tue, Aug 6, 2013 09:04 PM To: "Communication channel for MonetDB users"; Subject: Re: Data Vault:SyntaxException On Aug 06, 2013, at 11:40, integrity wrote:

Hi Jennie, I use sql.start, then fits.attach, now there is no error,but it doesnt return .

mal>sql.start(); mal>fits.attach("/home/data1/20130111_177d550752_60d851283-530.fit");

fits.attach doesn't return anything. it just add some metadata to the (fits/sql) catalog. so you can check the catalog to see if fits.attach() has properly done its job. I don't know which catalog table is used by the FITS impl. I took a quick look in Joao's thesis. there "fits_tables" is mentioned, but I don't know if this matches the implementation. With "select * from sys._tables;" you can get a complete list of _all_ tables in the system, including additional catalog tables added by the FITS extension, if any. Jennie

Regards, Meng

------------------ Original ------------------ From: "Ying Zhang"; Date: Tue, Aug 6, 2013 05:25 PM To: "Communication channel for MonetDB users"; Subject: Re: Data Vault:SyntaxException

On Tue, Aug 06, 2013 at 11:17:28AM +0200, Stefan Manegold wrote:

...

As said earlier,

this still appears to be very experimental code which is unfortunately far from user-ready. Sorry.

I would take me / us quite some time to find out and explain all the details how to use this code, i'm afraid ...

... unless someone else unexpectedly happens to know more ... ?

Beside Joao, Milena might be the only one knowing the details. I intended to talk with haar about this, but I learnt yesterday that she's on holiday until aug. 14th.

Jennie

...

Stefan

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

...

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

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