[
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-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
