You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by William Bell <bi...@gmail.com> on 2015/12/29 05:02:26 UTC
Issue with Join
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
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
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}*:*
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
}
}
}
}
}
--
Bill Bell
billnbell@gmail.com
cell 720-256-8076
Re: Issue with Join
Posted by William Bell <bi...@gmail.com>.
Thoughts?
I can duplicate it at will...
On Mon, Dec 28, 2015 at 9:02 PM, William Bell <bi...@gmail.com> wrote:
> 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
> }
> }
> }
> }
>
> }
>
>
>
>
> --
> Bill Bell
> billnbell@gmail.com
> cell 720-256-8076
>
--
Bill Bell
billnbell@gmail.com
cell 720-256-8076
Re: Issue with Join
Posted by William Bell <bi...@gmail.com>.
Can a committer take a look at this please?
On Wed, Dec 30, 2015 at 4:35 PM, William Bell <bi...@gmail.com> wrote:
> Yeah I ran it. It appears to only have an issue if the field for the core
> on the outside is MultiValue, and the inside field is single value, and the
> order of the field has the code not as the first entry. Like:
>
> practicing_specialties_codes:
> > [
> > - "PS1010",
> > - "PS282",
> > - "*PS1226*"
> > ]
> > }
>
> Here is the output of the debug:
>
>
> - join:
> {
> - {!join from=prac_spec_code to=practicing_specialties_codes
> fromIndex=autosuggest}*:*:
> {
> - time: 24,
> - fromSetSize: 170179,
> - toSetSize: 3194542,
> - fromTermCount: 1091,
> - fromTermTotalDf: 1091,
> - fromTermDirectCount: 1091,
> - fromTermHits: 1091,
> - fromTermHitsTotalDf: 1091,
> - toTermHits: 1069,
> - toTermHitsTotalDf: 4002538,
> - toTermDirectCount: 697,
> - smallSetsDeferred: 1,
> - toSetDocsAdded: 4002538
> }
> },
>
>
> On Wed, Dec 30, 2015 at 2:02 AM, Mikhail Khludnev <
> mkhludnev@griddynamics.com> wrote:
>
>> Hello,
>>
>> Have you considered to pass NOT {!join from=prac_spec_code
>> to=practicing_specialties_codes
>> fromIndex=autosuggest}*:* as a q and look at debug output.
>> Also there was a trick for dealing with pure negative queries q=*:*
>> -foo:bar though it might be obsolete.
>>
>> On Tue, Dec 29, 2015 at 7:02 AM, William Bell <bi...@gmail.com>
>> wrote:
>>
>> > 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
>> > }
>> > }
>> > }
>> > }
>> >
>> > }
>> >
>> >
>> >
>> >
>> > --
>> > Bill Bell
>> > billnbell@gmail.com
>> > cell 720-256-8076
>> >
>>
>>
>>
>> --
>> Sincerely yours
>> Mikhail Khludnev
>> Principal Engineer,
>> Grid Dynamics
>>
>> <http://www.griddynamics.com>
>> <mk...@griddynamics.com>
>>
>
>
>
> --
> Bill Bell
> billnbell@gmail.com
> cell 720-256-8076
>
--
Bill Bell
billnbell@gmail.com
cell 720-256-8076
Re: Issue with Join
Posted by William Bell <bi...@gmail.com>.
Yeah I ran it. It appears to only have an issue if the field for the core
on the outside is MultiValue, and the inside field is single value, and the
order of the field has the code not as the first entry. Like:
practicing_specialties_codes:
> [
> - "PS1010",
> - "PS282",
> - "*PS1226*"
> ]
> }
Here is the output of the debug:
- join:
{
- {!join from=prac_spec_code to=practicing_specialties_codes
fromIndex=autosuggest}*:*:
{
- time: 24,
- fromSetSize: 170179,
- toSetSize: 3194542,
- fromTermCount: 1091,
- fromTermTotalDf: 1091,
- fromTermDirectCount: 1091,
- fromTermHits: 1091,
- fromTermHitsTotalDf: 1091,
- toTermHits: 1069,
- toTermHitsTotalDf: 4002538,
- toTermDirectCount: 697,
- smallSetsDeferred: 1,
- toSetDocsAdded: 4002538
}
},
On Wed, Dec 30, 2015 at 2:02 AM, Mikhail Khludnev <
mkhludnev@griddynamics.com> wrote:
> Hello,
>
> Have you considered to pass NOT {!join from=prac_spec_code
> to=practicing_specialties_codes
> fromIndex=autosuggest}*:* as a q and look at debug output.
> Also there was a trick for dealing with pure negative queries q=*:*
> -foo:bar though it might be obsolete.
>
> On Tue, Dec 29, 2015 at 7:02 AM, William Bell <bi...@gmail.com> wrote:
>
> > 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
> >
> > 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
> >
> > 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}*:*
> >
> > 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
> > }
> > }
> > }
> > }
> >
> > }
> >
> >
> >
> >
> > --
> > Bill Bell
> > billnbell@gmail.com
> > cell 720-256-8076
> >
>
>
>
> --
> Sincerely yours
> Mikhail Khludnev
> Principal Engineer,
> Grid Dynamics
>
> <http://www.griddynamics.com>
> <mk...@griddynamics.com>
>
--
Bill Bell
billnbell@gmail.com
cell 720-256-8076
Re: Issue with Join
Posted by Mikhail Khludnev <mk...@griddynamics.com>.
Hello,
Have you considered to pass NOT {!join from=prac_spec_code
to=practicing_specialties_codes
fromIndex=autosuggest}*:* as a q and look at debug output.
Also there was a trick for dealing with pure negative queries q=*:*
-foo:bar though it might be obsolete.
On Tue, Dec 29, 2015 at 7:02 AM, William Bell <bi...@gmail.com> wrote:
> 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
>
> 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
>
> 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}*:*
>
> 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
> }
> }
> }
> }
>
> }
>
>
>
>
> --
> Bill Bell
> billnbell@gmail.com
> cell 720-256-8076
>
--
Sincerely yours
Mikhail Khludnev
Principal Engineer,
Grid Dynamics
<http://www.griddynamics.com>
<mk...@griddynamics.com>