[
https://issues.apache.org/jira/browse/SOLR-15821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gleb Arkhipov updated SOLR-15821:
---------------------------------
Environment: Do not believe this is environment-specific.
> Add an ability to do "join" so values of "from" field are managed as phrases
> for "to" field
> -------------------------------------------------------------------------------------------
>
> Key: SOLR-15821
> URL: https://issues.apache.org/jira/browse/SOLR-15821
> Project: Solr
> Issue Type: Improvement
> Security Level: Public(Default Security Level. Issues are Public)
> Components: query, query parsers
> Affects Versions: 8.10
> Environment: Do not believe this is environment-specific.
> Reporter: Gleb Arkhipov
> Priority: Major
>
> I have 2 cores: *core_a* and *core_b*
> *document_a_1* and *document_a_2* are indexed in *core_a*
> {code:java}
> [
> {
> "id":1,
> "name": "document_a_1",
> "field_a": "Strange name for human being"
> },
> {
> "id":2,
> "name": "document_a_2",
> "field_a": "Strange name for human"
> }
> ] {code}
> *document_b* is indexed in *core_b*
> {code:java}
> {
> "id": 1,
> "name": "document_b",
> "field_b": "human being"
> } {code}
> I would like to find in *core_a* all documents that *field_a* contains
> *field_b* values of documents that *name* equals *document_b*
> So with SQL it would like this:
> {code:java}
> SELECT *
> FROM core_a
> JOIN core_b
> ON name = "document_b" AND "field_a" like "%" + field_b + "%" {code}
> I suggest that the following *join* query should help me:
> {code:java}
> POST http://localhost:8983/solr/core_a/select
> {
> "query": {
> "join": {
> "from": "field_b",
> "to": "field_a",
> "fromIndex": "core_b",
> "query": "name:document_b"
> },
> },
> "fields": "name"
> }{code}
> So I expect that only *document_a_1* will be returned
> If *StandardTokenizerFactory* is used for both *field_a* and {*}field_b{*},
> then response contains *document_a_1* and *document_a_2*
> If *StandardTokenizerFactory* is used for *field_a* and
> *KeywordTokenizerFactory* is used for {*}field_b{*}, then the response
> contains no documents
> How could I get the expected result by using join?
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org
