 |
 |
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