Print

Print


Bill wrote:
> mysql> SELECT count(*) AS n, AVG(ra_PS), AVG(decl_PS), chunkId
>     -> FROM Object
>     -> GROUP BY chunkId;
> +----------------+-------------------------------+-------------------------------+
> | SUM(QS1_COUNT) | (SUM(QS3_SUM)/SUM(QS2_COUNT)) | (SUM(QS5_SUM)/SUM(QS4_COUNT)) |
> +----------------+-------------------------------+-------------------------------+
> |        3738244 |              80.5458153658024 |              0.27024249373145 |
> +----------------+-------------------------------+-------------------------------+
> 1 row in set (27.30 sec)

	Hmm.  I guess we can't easily get transparency in the column
headers here.  But can we at least get the "n"?  And what happened to
the chunkId?

-- 
Kian-Tat Lim, LSST Data Management, [log in to unmask]

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