_query_:"{!join fromIndex=expressionData from=anatomyID to=anatomyID
v='(anatomy:\"brain\") +id:[1 TO 10000]'}"
On Tue, Jun 24, 2014 at 10:24 PM, Kevin Stone <kevin.st...@jax.org> wrote:
> 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.
>
--
Sincerely yours
Mikhail Khludnev
Principal Engineer,
Grid Dynamics
<http://www.griddynamics.com>
<mkhlud...@griddynamics.com>
