[ 
https://issues.apache.org/jira/browse/SOLR-2272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12970906#action_12970906
 ] 

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: https://issues.apache.org/jira/browse/SOLR-2272
>             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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

Reply via email to