Hi Jennie,
I search the thesis, it's indeed called fits_tables, fits_files,fits_columns, fits_table_properties,

but i cann't fiind them in sql when use "select * from sys._tables". while in mal, i can find 
mal>?fits.*()
pattern fits.attach(fname:str):void 
address FITSattach;
comment Open a FITS file and return catalog of the table HDUs

pattern fits.export(tablename:str):void 
address FITSexportTable;
comment Export a table to a FITS file

command fits.fitstest(filename:str):int 
address FITStest;
comment Returns the type of first extension in the FITS file filename

pattern fits.load(tablename:str):void 
address FITSloadTable;
comment Load a FITS table from an attached file

pattern fits.listdirpattern(dirname:str,pattern:str):void 
address FITSdirpat;
comment Attach all FITS file in the directory, giving a pattern

pattern fits.listdir(dirname:str):void 
address FITSdir;
comment Attach all FITS files in the directory


the MonetDB version i use is Feb2013 downloaded from Mercurial.

Thanks!
Meng


------------------ Original ------------------
From:  "Ying Zhang"<Y.Zhang@cwi.nl>;
Date:  Tue, Aug 6, 2013 09:04 PM
To:  "Communication channel for MonetDB users"<users-list@monetdb.org>;
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"<Y.Zhang@cwi.nl>;
> Date:  Tue, Aug 6, 2013 05:25 PM
> To:  "Communication channel for MonetDB users"<users-list@monetdb.org>;
> 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"<users-list@monetdb.org>;
> > >
> > > 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"<Stefan.Manegold@cwi.nl>;
> > > Date:  Tue, Aug 6, 2013 03:10 PM
> > > To:  "Communication channel for MonetDB users"<users-list@monetdb.org>;
> > >
> > > 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
.