I don't know what that means. Is that a no? ________________________________________ From: Mikhail Khludnev [mkhlud...@griddynamics.com] Sent: Tuesday, June 24, 2014 2:18 PM To: solr-user Subject: Re: limit solr results before join
Hello Kevin, You can only apply some restriction clauses (with +) to the from side query. On Tue, Jun 24, 2014 at 8:09 PM, Kevin Stone <kevin.st...@jax.org> wrote: > Is there any way to limit the results of a query on the "from" index > before it gets joined? > > The SQL analogy might be... > SELECT * > from toIndex join > (select * from fromIndex > where "some query" > limit 1000 > ) fromIndex on fromIndex.from=toIndex.to > > > Example: > _query_:"{!join fromIndex=expressionData from=anatomyID to=anatomyID > v='(anatomy:\"brain\")'}" > > Say I have an index representing data for gene expression (we work with > genetics), and you query it by anatomy term. So the above would query for > all data that shows gene expression in "brain". > > Now I want to get a set of related data for each anatomy term via the > join. Is there any way to get the related data for only anatomy terms in > the first 1000 expression data documents (fromIndex)? The reason is because > there could be millions of data documents (fromIndex), and we process them > in batches to load a visualization of the query results. > > Doing the join on all the results for each batch I process is becoming a > bottleneck for large sets of data. > > Thanks, > -Kevin > > The information in this email, including attachments, may be confidential > and is intended solely for the addressee(s). If you believe you received > this email by mistake, please notify the sender by return email as soon as > possible. > -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com> The information in this email, including attachments, may be confidential and is intended solely for the addressee(s). If you believe you received this email by mistake, please notify the sender by return email as soon as possible.