Fabrice
Thanks for coming up with this query, you uncovered an interesting
issue. Your query was trying to select all 2 billion rows. There is
nothing wrong with that :). Anyway, you probably saw that we
looked into that:
https://jira.lsstcorp.org/browse/DM-3488
and we have a brand new epic to address it:
https://jira.lsstcorp.org/browse/DM-3495
Jacek
On 07/26/2015 07:23 AM, Fabrice Jammes wrote:
> fjammes@ccosvms0070:~$ time mysql --host ccqserv100 --port 4040 --user
> qsmaster -e "SELECT deepSourceId, u_apFluxSigma FROM LSST.Object WHERE
> u_apFluxSigma between 0 and 0.02" > res.txt
>
> real 16m22.576s
> user 0m51.947s
> sys 0m17.252s
> fjammes@ccosvms0070:~$ wc -l res.txt
> 26125760 res.txt
>
> But some services, including cazr, are down at the end of the query
>
> ########################################################################
> 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
|