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
|