Yes, that's what I meant. Anyway, I'll take a look when I get account access again. I'm the mean time,I can just dump my own schema file. Regardless of whether it keeps changing, the example file should be workable in a way, and the current one is not.
No problem, not urgent. Have a great weekend,
-Daniel
-------- Original message -------- From: "Smith, Douglas A." <[log in to unmask]> Date: 08/31/2013 5:00 PM (GMT-08:00) To: "Wang, Daniel Liwei" <[log in to unmask]> Cc: qserv-l <[log in to unmask]> Subject: Re: meta/examples/tbSchema_Source.sql
Not sure how I missed this message, but, I assume you mean the source meta data in the 300 node cluster at IN2P3?
But the script I used to setup the meta data there is here:
/sps/lsst/Qserv/src/scripts/qms_setup_pt12.sh
I'm not sure about putting an example sql table schema in the qserv respository? I mean the table schema keep changing for each data set that is handed to us.
Douglas
On 08/30/2013 04:16 PM, Wang, Daniel Liwei wrote: > Douglas, > > Would you update meta/examples/tbSchema_Source.sql and tb_Source.params > to reflect what you used to load the Source table? > > The .sql is blindingly wrong as it is now, so it's not even a usable > example: > ---- > create table Source ( > sourceId bigint, > ra float, > decl float > ); > ---- > > If you didn't use a .params file and specified things on the > command-line, please send me the command-line, and I will update the > .params file as needed. > > Thanks, > -Daniel >