Daniel -
Ok, so - more testing on the 300 node cluster for you to look at.
Ok, this was a bit ago, but I fixed the column names on the qservMeta
database table, and the objectId selects seem to work now:
mysql> select * from Object where objectId = 154062577146538502;
<snip>
1 row in set (1.15 sec)
And then looking at the source table, I can select record based
on the objectId value:
mysql> SELECT sourceId, ra, decl FROM Source WHERE Source.objectId =
154062577146538502;
<snip>
56 rows in set (8.21 sec)
But I can't seem to join with the Object table yet, we knew this
I guess already:
mysql> SELECT s.ra, s.decl FROM Source s, Object o WHERE
s.objectId=o.objectId and o.objectId = 154062577146538502;
Empty set (2 min 17.98 sec)
But also now, looking at some near-neighbor selects. Looking at
a small part of the sky, I can count objects there:
mysql> SELECT COUNT(*) FROM Object
-> WHERE qserv_areaspec_box(1,2,3,4);
+----------------+
| SUM(QS1_COUNT) |
+----------------+
| 297934 |
+----------------+
1 row in set (1.27 sec)
But when I try a near-neighbor count in that small section I get:
mysql> SELECT COUNT(*) FROM Object o1, Object o2
-> WHERE qserv_areaspec_box(1,2,3,4)
-> AND qserv_angSep(o1.ra_PS, o1.decl_PS,o2.ra_PS, o2.decl_PS) < 0.1;
ERROR 4120 (Proxy): Error during execution: 'read failed for chunk(s):
14880 14641 14640 14881'
So, not sure what is happening there?
Douglas
########################################################################
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
|