Dear Wiki user, You have subscribed to a wiki page or wiki category on "Solr Wiki" for change notification.
The "Join" page has been changed by GrantIngersoll. http://wiki.apache.org/solr/Join?action=diff&rev1=2&rev2=3 -------------------------------------------------- = Introduction = - In many cases, documents have relationships between them and it is too expensive to denormalize them. Thus, a join operation is needed. Preserving the document relationship allows documents to be updated independently without having to reindex large numbers of denormalized documents. + In many cases, documents have relationships between them and it is too expensive to denormalize them. Thus, a join operation is needed. Preserving the document relationship allows documents to be updated independently without having to reindex large numbers of denormalized documents. = Quick Start = * Follow the Tutorial at http://lucene.apache.org/solr/tutorial.html to get setup - * Point your browser at http://localhost:8983/solr/browse + * Point your browser at http://localhost:8983/solr/browse?&queryOpts=join + * Fill in your query and the names of two fields to join on, for example From: manu_id and To: id (join between the manu_id on the products and the id on the manufacturers) + * Submit -- Notice the results are of the manufacturers who make those items and not of the products themselves even though the match is on the products = Input Parameters = + Joins are process using Solr's LocalParams syntax. The query typically looks like: + {{{q={!join+from=manu_id_s to=id}ipod}}} + + Thus, you need the join !QueryParser(Plugin) which is specified by the {!join} syntax. Then, you need specify the foreign key relationship by giving the from and to fields to join on. + = Examples = + = Background = + + * See https://issues.apache.org/jira/browse/SOLR-2272 for the original patch +
