Hi Fabrice, can you send me the log file with full debug (--verbose-all -v -v options)? "--css-remove" is supposed to do the same thing as qserv-admin's "DROP TABLE". What do you see that tells you that it's not working? Cheers, Andy Fabrice Jammes wrote on 2014-12-18: > On 12/18/2014 06:38 PM, Fabrice Jammes wrote: >> My mistake, >> >> Indeed, these params are correct in css but not in cfg files, I have >> removed them for test purpose and to be compliant with original >> examples. >> >> Andy, it seems the loader doesn't remove css data before reloading >> although I provided "--css-remove" option, >> Shall I remove everything in the db/css using "DROP TABLE" in >> qserv-admin.py, before launching the data-loader? >> >> Thanks, >> >> Fabrice >> >> >> On 12/18/2014 06:26 PM, Fabrice Jammes wrote: >>> It seems it is: >>> >>> Database changed >>> mysql> show tables; >>> +----------------------------------+ >>> | Tables_in_qservTest_case01_qserv | >>> +----------------------------------+ >>> | Filter | >>> | LeapSeconds | >>> | Logs | >>> | Object | >>> | ObjectFullOverlap_6630 | >>> | ObjectFullOverlap_6631 | >>> | ObjectFullOverlap_6800 | >>> | ObjectFullOverlap_6801 | >>> | ObjectFullOverlap_6968 | >>> | ObjectFullOverlap_6970 | >>> | ObjectFullOverlap_6971 | >>> | ObjectFullOverlap_7138 | >>> | ObjectFullOverlap_7140 | >>> | ObjectFullOverlap_7308 | >>> | ObjectFullOverlap_7478 | >>> | ObjectFullOverlap_7648 | >>> | Object_1234567890 | >>> | Object_6630 | >>> | Object_6631 | >>> | Object_6800 | >>> | Object_6801 | >>> | Object_6968 | >>> | Object_6970 | >>> | Object_6971 | >>> | Object_7138 | >>> | Object_7140 | >>> | Object_7308 | >>> | Object_7310 | >>> | Object_7478 | >>> | Object_7648 | >>> | RefSrcMatch | >>> | Science_Ccd_Exposure | >>> | SimRefObject | >>> | Source | >>> | Source_1234567890 | >>> | Source_6630 | >>> | Source_6631 | >>> | Source_6800 | >>> | Source_6801 | >>> | Source_6968 | >>> | Source_6970 | >>> | Source_6971 | >>> | Source_7138 | >>> | Source_7140 | >>> | Source_7308 | >>> | Source_7310 | >>> | Source_7478 | >>> | Source_7648 | >>> | sdqa_Metric | >>> +----------------------------------+ >>> 49 rows in set (0,00 sec) >>> >>> >>> On 12/18/2014 06:20 PM, Serge Monkewitz wrote: >>>> On Dec 18, 2014, at 6:12 PM, Fabrice Jammes >>>> <[log in to unmask]> wrote: >>>> >>>>> DeepSource si a view, shouldn't it be RunDeepSource the director >>>>> table? >>>> In the Winter2013 release, yes it is. But RunDeepSource contains a >>>> bunch of extra columns and uses pipeline column naming conventions, >>>> so I just dumped from the view instead. Note I had to do other >>>> things to make it work in qserv (IIRC I changed the type of BIT >>>> columns to TINYINT). Unless the goal is to duplicate the plain mysql >>>> setup from stripe 82 data as closely as possible, let's not get hung >>>> up on these details. >>>> >>>>> Furthermore, it seems dirTable and dirColName are optional for now, >>>>> isn't it? Andy doesn't set it in test case01 and 02 and it works. >>>> If you don't specify them though, the query analysis code will not >>>> let you join between related partitioned tables. Is the data in test >>>> case01/02 being partitioned at all? >>>> >>>> Serge >>>> >>>> ###################################################################### >>>> ## >>>> >>>> Use REPLY-ALL to reply to list >>>> >>>> To unsubscribe from the QSERV-L list, click the following link: >>>> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1 >>> >> > > ######################################################################## > Use REPLY-ALL to reply to list > > To unsubscribe from the QSERV-L list, click the following link: > https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1 š ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1