Can a committer take a look at this please?
On Wed, Dec 30, 2015 at 4:35 PM, William Bell <billnb...@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 <
> mkhlud...@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 <billnb...@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
>> > billnb...@gmail.com
>> > cell 720-256-8076
>> >
>>
>>
>>
>> --
>> Sincerely yours
>> Mikhail Khludnev
>> Principal Engineer,
>> Grid Dynamics
>>
>> <http://www.griddynamics.com>
>> <mkhlud...@griddynamics.com>
>>
>
>
>
> --
> Bill Bell
> billnb...@gmail.com
> cell 720-256-8076
>
--
Bill Bell
billnb...@gmail.com
cell 720-256-8076
