lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tanguy Moal (JIRA)" <>
Subject [jira] Commented: (SOLR-2272) Join
Date Mon, 13 Dec 2010 17:28:03 GMT


Tanguy Moal commented on SOLR-2272:

Yonik, that feature is pretty interesting, but sounds more like a mapping or replacement than
a join to me...

I have a use case were my documents have some fields getting updated frequently, and others
don't. By the way those fields which aren't updated frequently, occur to be common from times
to times with other documents. When I saw that issue, I decided to give it a try. I decided
to split my old documents in new documents, using two documents to represent one old document,
plus a common "pivot" field.

At first a simple substitution occured, because of children not having the same "from" field
value, I worked around that easily. I now have twice more documents, as expected. Unfortunatelly,
I thought I'd be able to perform search restrictions on the union produced by the join, but
I wasn't able to do so... Did I miss something somewhere ?

Little example :

fields : 
* title : text
* price : sint
* id : string
* pivot : string 

I push : doc 1 : "id", "1", "price", "150", "pivot", "pivot1" and  doc 2 : "id", "2",  "title",
"great title", "pivot", "pivot1"

I search  :
* q={!join from=pivot to=pivot}title:great => got 2 docs, perfect
* q={!join from=pivot to=pivot}price:[* TO 200] => got 2 docs, so far so good
* q={!join from=pivot to=pivot}price:[* TO 200]+AND+title:great => no result found. Of
course that makes sense, no such a document match this conjunction, but I thought that by
"joining" I'd be able to do so...

What's your point of view ?

Thanks in advance

> Join
> ----
>                 Key: SOLR-2272
>                 URL:
>             Project: Solr
>          Issue Type: New Feature
>            Reporter: Yonik Seeley
>             Fix For: 4.0
>         Attachments: 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.
You can reply to this email to add a comment to the issue online.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message