On 09/04/2013 09:03 PM, Kian-Tat Lim wrote:
> 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?
We can. We used to, but it was a big hassle, and I haven't
re-implemented in the new framework. I didn't it was worth working on
before getting the framework right (it is still incomplete). Especially
because we've noticed that there is a limit to column identifiers, so
we'll have to re-work the proxy protocol in order to get it right in the
general case. Using aliases like "AS n" is planned in the nearer term.
-Daniel
>
########################################################################
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
|