You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Bill Bell (JIRA)" <ji...@apache.org> on 2016/06/16 06:23:05 UTC
[jira] [Created] (SOLR-9213) Join does not work on multiValued
fields / single field
Bill Bell created SOLR-9213:
-------------------------------
Summary: Join does not work on multiValued fields / single field
Key: SOLR-9213
URL: https://issues.apache.org/jira/browse/SOLR-9213
Project: Solr
Issue Type: Bug
Affects Versions: 5.4.1
Reporter: Bill Bell
> I have having issues with {!join}. If the core have multiValued field and
> the inner join does not have a multiValued field it does not find the
> ones...
>
> Solr 5.3.1... <luceneMatchVersion>5.3.1</luceneMatchVersion>
>
> Example.
>
> PS1226 is in practicing_specialties_codes in providersearch core. This
> field is multiValued.
>
> in the autosuggest core there is NOT a field for PS1226 in there. This
> field is called prac_spec_code and is single values.
>
>
>
> http://localhost:8983/solr/providersearch/select?q=*%3A*&wt=json&indent=true&fq=practicing_specialties_codes:PS1226&fl=practicing_specialties_codes
>
> I get:
>
>
> - docs:
> [
> -
> {
> - practicing_specialties_codes:
> [
> - "PS1010",
> - "PS282",
> - "PS1226"
> ]
> }
> ]
>
>
>
> In autosuggest there is nothing:
>
>
> http://localhost:8983/solr/autosuggest/select?q=*%3A*&wt=json&indent=true&fq=prac_spec_code:PS1226&fl=prac_spec_code
>
> Nothing.
>
> Then a join should find what is in providersearch but missing in
> autosuggest.
>
>
> http://localhost:8983/solr/providersearch/select?debugQuery=true&wt=json&q=*:*&rows=10&fq=practicing_specialties_codes:PS1226&fl=practicing_specialties_codes&fq=NOT%20{!join%20from=prac_spec_code%20to=practicing_specialties_codes%20fromIndex=autosuggest}auto_type:PRACSPEC
> <http://localhost:8983/solr/providersearch/select?debugQuery=true&wt=json&q=*:*&rows=10&fq=practicing_specialties_codes:PS1226&fl=practicing_specialties_codes&fq=NOT%20%7B!join%20from=prac_spec_code%20to=practicing_specialties_codes%20fromIndex=autosuggest%7Dauto_type:PRACSPEC>
>
> or
>
>
> http://hgsolr2sl1:8983/solr/providersearch/select?debugQuery=true&wt=json&q=*:*&rows=10&fl=practicing_specialties_codes&fq=NOT%20{!join%20from=prac_spec_code%20to=practicing_specialties_codes%20fromIndex=autosuggest}auto_type:PRACSPEC
> <http://hgsolr2sl1:8983/solr/providersearch/select?debugQuery=true&wt=json&q=*:*&rows=10&fl=practicing_specialties_codes&fq=NOT%20%7B!join%20from=prac_spec_code%20to=practicing_specialties_codes%20fromIndex=autosuggest%7Dauto_type:PRACSPEC>
>
> or
>
>
> http://hgsolr2sl1:8983/solr/providersearch/select?debugQuery=true&wt=json&q=*:*&rows=10&fl=practicing_specialties_codes&fq=NOT%20{!join%20from=prac_spec_code%20to=practicing_specialties_codes%20fromIndex=autosuggest}*:*
> <http://hgsolr2sl1:8983/solr/providersearch/select?debugQuery=true&wt=json&q=*:*&rows=10&fl=practicing_specialties_codes&fq=NOT%20%7B!join%20from=prac_spec_code%20to=practicing_specialties_codes%20fromIndex=autosuggest%7D*:*>
>
> I also tried *:* AND NOT {!join}
>
> I get 0 results. This seems to be a bug.
>
> {
>
> - responseHeader:
> {
> - status: 0,
> - QTime: 178,
> - params:
> {
> - q: "*:*",
> - fl: "practicing_specialties_codes",
> - fq: "NOT {!join from=prac_spec_code
> to=practicing_specialties_codes fromIndex=autosuggest}*:*",
> - rows: "10",
> - wt: "json",
> - debugQuery: "true"
> }
> },
> - response:
> {
> - numFound: 0,
> - start: 0,
> - docs: [ ]
> },
> - debug:
> {
> - rawquerystring: "*:*",
> - querystring: "*:*",
> - parsedquery: "MatchAllDocsQuery(*:*)",
> - parsedquery_toString: "*:*",
> - explain: { },
> - QParser: "LuceneQParser",
> - filter_queries:
> [
> - "NOT {!join from=prac_spec_code
> to=practicing_specialties_codes fromIndex=autosuggest}*:*"
> ],
> - parsed_filter_queries:
> [
> - "-JoinQuery({!join from=prac_spec_code
> to=practicing_specialties_codes fromIndex=autosuggest}*:*)"
> ],
> - timing:
> {
> - time: 177,
> - prepare:
> {
> - time: 0,
> - query:
> {
> - time: 0
> },
> - facet:
> {
> - time: 0
> },
> - facet_module:
> {
> - time: 0
> },
> - mlt:
> {
> - time: 0
> },
> - highlight:
> {
> - time: 0
> },
> - stats:
> {
> - time: 0
> },
> - expand:
> {
> - time: 0
> },
> - debug:
> {
> - time: 0
> }
> },
> - process:
> {
> - time: 177,
> - query:
> {
> - time: 177
> },
> - facet:
> {
> - time: 0
> },
> - facet_module:
> {
> - time: 0
> },
> - mlt:
> {
> - time: 0
> },
> - highlight:
> {
> - time: 0
> },
> - stats:
> {
> - time: 0
> },
> - expand:
> {
> - time: 0
> },
> - debug:
> {
> - time: 0
> }
> }
> }
> }
>
> }
--
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