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>
