 |
 |
Hi Jacek, The query you propose fails, I retried with smaller window: time mysql --host ccqserv100 --port 4040 --user qsmaster -e "SELECT deepSourceId, u_apFluxSigma FROM LSST.Object WHERE u_apFluxSigma between 0.01 and 0.011" but I still have an error, see the czar log extract below: 0507 18:44:50.574 [0x7f439ca25700] INFO root (build/ccontrol/MergingRequester.cc:230) - setError 0507 18:44:50.575 [0x7f439ca25700] INFO root (build/ccontrol/MergingRequester.cc:231) - setError -1 Request failed 0507 18:44:50.575 [0x7f439ca25700] ERROR root (build/ccontrol/MergingRequester.cc:168) - Error receiving result. 0507 18:44:50.575 [0x7f439ca25700] DEBUG root (build/qdisp/QueryRequest.cc:247) - Error finish Cheers, On 05/07/2015 05:35 PM, Jacek Becla wrote: > Nice! Can you try a full table scan, just to see the timing? > > Something like > > SELECT deepSourceId, u_apFluxSigma FROM LSST.Object > WHERE u_apFluxSigma between 0.01 and 0.02 > > would do it > > Jacek > > > > On 05/07/2015 05:27 AM, Fabrice Jammes wrote: >> fjammes@ccosvms0070:~/src/qserv (u/fjammes/DM-1962=)$ time mysql --host >> ccqserv100 --port 4040 --user qsmaster -e "SELECT deepSourceId, >> u_apFluxSigma FROM LSST.Object WHERE deepSourceId = 2381971682496089;" >> +------------------+----------------------+ >> | deepSourceId | u_apFluxSigma | >> +------------------+----------------------+ >> | 2381971682496089 | 2.31359138208982e-30 | >> +------------------+----------------------+ >> >> real 1m35.509s >> user 0m0.007s >> sys 0m0.015s >> fjammes@ccosvms0070:~/src/qserv (u/fjammes/DM-1962=)$ time mysql --host >> ccqserv100 --port 4040 --user qsmaster -e "SELECT deepSourceId, >> u_apFluxSigma FROM LSST.Object WHERE deepSourceId = 2381971682496090;" >> +------------------+----------------------+ >> | deepSourceId | u_apFluxSigma | >> +------------------+----------------------+ >> | 2381971682496090 | 2.35166823179121e-30 | >> +------------------+----------------------+ >> >> real 0m0.112s >> user 0m0.007s >> sys 0m0.015s >> fjammes@ccosvms0070:~/src/qserv (u/fjammes/DM-1962=)$ time mysql --host >> ccqserv100 --port 4040 --user qsmaster -e "SELECT deepSourceId, >> u_apFluxSigma FROM LSST.Object WHERE deepSourceId = 4210970620594023;" >> +------------------+----------------------+ >> | deepSourceId | u_apFluxSigma | >> +------------------+----------------------+ >> | 4210970620594023 | 3.36652987269481e-30 | >> +------------------+----------------------+ >> >> real 0m5.187s >> user 0m0.007s >> sys 0m0.017s >> >> ######################################################################## >> 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