 |
 |
I don't understand. Both ra,decl and x,y columns are present in DeepForcedSource table, and I am able to run a non-optimized version of the query, using scisql_s2PtInBox(ra, decl, lon1, lat1, lon2, lat2). Why I can not use the optimized version - qserv_areaSpec_box? Tatiana On Feb 10, 2015, at 11:40 PM, Kian-Tat Lim <[log in to unmask]> wrote: > Folks, > >> Here's what's happening: >> qserv_areaspec_box asks qserv to choose chunk/row coverage according >> to the director table. Generally, it detects the director table from >> the query, computes the region against the index, and then >> substitutes the right directive. But in this case, there is no >> director table, only a child table. Hence, even if we know what the >> director table is, its columns are not available to use in the >> query, unless we rewrite to add an equi-join with the director >> table. The best we can do in this case (without adding a join), is >> to use the parameters for determining chunk coverage, and then >> covering all rows in those chunks. The user could specify additional >> conditions to apply spatial filtering based on other >> (non-partitioning) columns. > > I agree; if qserv_areaspec_box is specified to work only against > Object (or other director table) ra/decl columns, then using it in a > query where those columns are unavailable should be rejected. I think > auto-including the director table with a join is more magic than is > needed. > > ForcedSources don't contain ra/decl (or even x,y), so specifying > a box for them is inappropriate. > > -- > 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 > > > -- > BEGIN-ANTISPAM-VOTING-LINKS > ------------------------------------------------------ > > Teach CanIt if this mail (ID 04NOTIDkW) is spam: > Spam: https://canit.ipac.caltech.edu/canit/b.php?i=04NOTIDkW&m=83fc2b258401&c=s > Not spam: https://canit.ipac.caltech.edu/canit/b.php?i=04NOTIDkW&m=83fc2b258401&c=n > Forget vote: https://canit.ipac.caltech.edu/canit/b.php?i=04NOTIDkW&m=83fc2b258401&c=f > ------------------------------------------------------ > END-ANTISPAM-VOTING-LINKS ######################################################################## 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