[jira] [Commented] (SOLR-6234) Scoring modes for query time join

["Parnit (JIRA)" <ji...@apache.org>]

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

Parnit commented on SOLR-6234:
------------------------------

Hi Mikhail,
I emailed a few mailing lists and you replied to help solve my scenario.
I am slightly confused by how this feature would help also would you be able to provide sample usage for my scenario?
Here it is in case you had forgotten.

I have my mainIndex which looks something like this.
 id     description           name  
  1   "description1 "    "name1"  
  2   "description2 "    "name2"  
I also have a subIndex which looks something like this
id   metric  
1      4  
2      5  
What I am trying to do is join the two index's on the id column and have my results sorted based on a column from the subIndex with a query like the following.

testServer/solr/MainIndex/select?defType=edismax&q=*&fq={!join from=id to=id fromIndex=subIndex}id:*&sort=metric desc  
desired result
 2   "description2 "    "name2"  
 1   "description1 "    "name1"  
I'm aware that you lose all information from the subIndex the moment the parser sees "&". What are my options should I want to join two indexes and sort on a column not present in the main index?

If you or someone else could show me some sample usage I would greatly appreciate it.

Thanks


> Scoring modes for query time join 
> ----------------------------------
>
>                 Key: SOLR-6234
>                 URL: https://issues.apache.org/jira/browse/SOLR-6234
>             Project: Solr
>          Issue Type: New Feature
>          Components: query parsers
>    Affects Versions: 4.10.3, Trunk
>            Reporter: Mikhail Khludnev
>              Labels: features, patch, test
>             Fix For: 5.0, Trunk
>
>         Attachments: SOLR-6234.patch, lucene-join-solr-query-parser-0.0.2.zip
>
>
> it adds {{scorejoin}} query parser which calls Lucene's JoinUtil underneath. It supports:
> - {{score=none|avg|max|total}} local param (passed as ScoreMode to JoinUtil), also 
> - supports {{b=100}} param to pass {{Query.setBoost()}}.
> So far
> - -it always passes {{multipleValuesPerDocument=true}}- {{multiVals=true|false}} is introduced 
> - -it doesn't cover cross core join case,- it covers cross-core join but rather opportunistically.I just can't find the multicore testcase in Solr test, I appreciate if you point me on one. 
> - -I attach standalone plugin project, let me know if somebody interested, I convert it into the proper Solr codebase patch. Also please mention the blockers!- done. thanks for your attitude!
> - so far it joins string and multivalue string fields (Sorted, SortedSet, Binary), but not Numerics DVs. follow-up LUCENE-5868  
> Note: the development of this patch was sponsored by an anonymous contributor and approved for release under Apache License.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org