Re: Data Vault:SyntaxException

On Tue, Aug 06, 2013 at 09:34:19PM +0800, integrity wrote:

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

I won't be surprised if the thesis doesn't match the code. you can have a look at the output of "select * from sys.schemas;" to see if any new schema (i.e., other than 'sys' and 'tmp') has been added for the FITS extension. Then you can check in the sys._tables table which tables listed their belongs to this new schema. you can also check the FITS C-code to see how e.g., the FITS catalog, is actually implemented. Jennie

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

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