[ https://issues.apache.org/jira/browse/SOLR-2272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12999072#comment-12999072 ]
Jonathan Rochkind commented on SOLR-2272: ----------------------------------------- Even if the core's aren't in the same JVM, one could imagine a weird cross-host join where Solr actually connected to the external Solr, issued a query (perhaps using Solr binary format for efficiency, SolrJ style), got the list of values returned for a particular stored field, and used that as a filter on the current query. This is in fact similar to something that's come up (not sure if it's in a different ticket or just on listserv) about doing a similar thing with an external SQL query, where the result of some single-column SQL against an external database is used as a filter in the current query. Really the exact same problem, just a question of whether the external query is to SQL via JDBC or what have you, or instead to another core via SolrJ style connection. Either way do an external query, end up with a list of values, and want to use that as efficiently as possible (ie, NOT using lucene 'or' with hundreds or thousands of clauses!) as a filter on a particular solr indexed field for the current query. But clearly that enhancement would be a different ticket/patch -- if the 'join' patch as currently spec'd were to make it into Solr as is (same core join only) I'd be overjoyed, it would be awfully useful just as it is, so do not suggest that it's scope be increased thus raising the bar for the feature as is. > Join > ---- > > Key: SOLR-2272 > URL: https://issues.apache.org/jira/browse/SOLR-2272 > Project: Solr > Issue Type: New Feature > Components: search > Reporter: Yonik Seeley > Fix For: 4.0 > > Attachments: SOLR-2272.patch, SOLR-2272.patch > > > Limited join functionality for Solr, mapping one set of IDs matching a query > to another set of IDs, based on the indexed tokens of the fields. > Example: > fq={!join from=parent_ptr to:parent_id}child_doc:query -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org