Sky Server dB query [distinct] merge outputs selec七 u. objid from u join <temp> M where uobjid a <temp>.neighborobjid and lu color -<temp> colorl dD D M M 4n S S 4n Y Y H n n X X n U N U N U U • Took SQL plan • Manually coded in Dryad • Manually partitioned data SkyServer DB query u: objid, color n: objid, neighborobjid [partition by objid] select u.color,n.neighborobjid from u join n where u.objid = n.objid (u.color,n.neighborobjid) [re-partition by n.neighborobjid] [order by n.neighborobjid] [distinct] [merge outputs] select u.objid from u join <temp> where u.objid = <temp>.neighborobjid and |u.color - <temp>.color| < d