lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Stone <Kevin.St...@jax.org>
Subject RE: limit solr results before join
Date Tue, 24 Jun 2014 18:24:18 GMT
I don't know what that means. Is that a no?

________________________________________
From: Mikhail Khludnev [mkhludnev@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.Stone@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>
 <mkhludnev@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.

Mime
View raw message