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

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

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

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

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

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 .

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

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

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

Ok, it actually hangs. You can "attach" the mserver5 process to a GDB debugging session to see where it hangs...

I will follow you advice to find fits_table anyway:)

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 .

---

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

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

---

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