Can I get some traction on to this?? --Yaswanth
On Wed, Jun 24, 2020 at 2:18 PM yaswanth kumar <yaswanth...@gmail.com> wrote: > Thanks Erick, > > I have now added &debug=query and found a diff between old solr and new > solr > > new solr (8.2) which is not giving results is as follows > > "debug":{ > "rawquerystring":"*:*", > "querystring":"*:*", > "parsedquery":"MatchAllDocsQuery(*:*)", > "parsedquery_toString":"*:*", > "explain":{}, > "QParser":"LuceneQParser", > "filter_queries":["auto_nsallschools:*bostonschool*"], > "parsed_filter_queries":["auto_nsallschools:_star_bostonschool_star_"], > > Where as solr 5.5 which is getting me the results is as follows > > "debug":{ > "rawquerystring":"*:*", > "querystring":"*:*", > "parsedquery":"MatchAllDocsQuery(*:*)", > "parsedquery_toString":"*:*", > "explain":{}, > "QParser":"LuceneQParser", > "filter_queries":["auto_nsallschools:*bostonschool*"], > "parsed_filter_queries":["auto_nsallschools:*bostonschool*"], > > I know in schema there are analyzer against this field but not getting on > why its making differences here. > > Thanks, > > On Wed, Jun 24, 2020 at 9:24 AM Erick Erickson <erickerick...@gmail.com> > wrote: > >> You need to do several things to track down why. >> >> First, use something (admin UI, terms query, etc) to see >> exactly what’s in your index. The admin/analysis screen is useful here. >> >> Second, aldd &debug=query to the query on both machines and >> see what the actual parsed query looks like. >> >> Comparing those should give you a clue. >> >> Best, >> Erick >> >> > On Jun 24, 2020, at 9:20 AM, yaswanth kumar <yaswanth...@gmail.com> >> wrote: >> > >> > "nsallschools":["BostonSchool"] >> > >> > That's how the data is stored against the field. >> > >> > We have a functionality where we can do "Starts with, Contains, Ends >> with"; >> > Also if you look at the above schema we are using >> > >> > <filter class="solr.SynonymFilterFactory" >> > synonyms="punctuation-whitelist.txt" ignoreCase="true" expand="false"/> >> > <tokenizer class="solr.KeywordTokenizerFactory"/> >> > <filter class="solr.LowerCaseFilterFactory"/> >> > <filter class="solr.ASCIIFoldingFilterFactory"/> >> > >> > Also the strange part is that its working fine in Solr 5.5 but not in >> Solr >> > 8.2 any thoughts?? >> > >> > Thanks, >> > >> > On Wed, Jun 24, 2020 at 3:15 AM Jörn Franke <jornfra...@gmail.com> >> wrote: >> > >> >> I don’t know your data, but could it be that you tokenize differently ? >> >> >> >> Why do you do the wildcard search at all? Maybe a different tokenizing >> >> strategy can bring you more effieciently results? Depends on what you >> need >> >> to achieve of course ... >> >> >> >>> Am 24.06.2020 um 05:37 schrieb yaswanth kumar <yaswanth...@gmail.com >> >: >> >>> >> >>> I am using solr 8.2 >> >>> >> >>> And when trying to do fq=auto_nsallschools:*bostonschool*, the data is >> >> not >> >>> being returned. But if I do the same in solr 5.5 (which I already have >> >> and >> >>> we are in process of migrating to 8.2 ) its returning results. >> >>> >> >>> if I do fq=auto_nsallschools:bostonschool >> >>> or >> >>> fq=auto_nsallschools:bostonschool* its returning results but when I >> try >> >>> with contains like described above or >> fq=auto_nsallschools:*bostonschool >> >>> (ends with) it's not returning any results. >> >>> >> >>> The field which we are already using is a copy field and multi valued, >> >> am I >> >>> doing something wrong? or does 8.2 need some adjustment in the >> configs? >> >>> >> >>> Here is the schema >> >>> >> >>> <field name="nsallschools" type="txtStandard" indexed="true" >> >> stored="true" >> >>> multiValued="true"/> >> >>> <field name="auto_nsallschools" type="nstxtLowerCaseMatch" >> indexed="true" >> >>> stored="false" multiValued="true"/> >> >>> <copyField source="nsallschools" dest="auto_nsallschools" /> >> >>> >> >>> >> >>> <fieldType name="txtStandard" class="solr.TextField" >> >>> positionIncrementGap="100"> >> >>> <analyzer> >> >>> <tokenizer class="solr.StandardTokenizerFactory"/> >> >>> <filter class="solr.LowerCaseFilterFactory"/> >> >>> <filter class="solr.ASCIIFoldingFilterFactory"/> >> >>> </analyzer> >> >>> </fieldType> >> >>> >> >>> >> >>> <fieldType name="nstxtLowerCaseMatch" class="solr.TextField" >> >>> positionIncrementGap="100"> >> >>> <analyzer> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\&)" replacement="_and_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\$)" replacement="_dollar_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\*)" replacement="_star_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\+)" replacement="_plus_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\-)" replacement="_minus_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\#)" replacement="_sharp_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\%)" replacement="_percent_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\=)" replacement="_equal_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\<)" replacement="_lessthan_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\>)" replacement="_greaterthan_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\€)" replacement="_euro_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\¢)" replacement="_cent_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\£)" replacement="_pound_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\¥)" replacement="_yuan_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\©)" replacement="_copyright_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\®)" replacement="_registered_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\|)" replacement="_pipe_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\^)" replacement="_caret_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\~)" replacement="_tilt_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\™)" replacement="_treadmark_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\@)" replacement="_at_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\")" replacement=" _doublequote_ " /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\()" replacement=" _leftparentheses_ " /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\))" replacement=" _rightparentheses_ " /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\{)" replacement="_leftcurlybracket_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\})" replacement="_rightcurlybracket_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\[)" replacement="_leftsquarebracket_" /> >> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >> >>> pattern="(\])" replacement="_rightsquarebracket_" /> >> >>> <filter class="solr.SynonymFilterFactory" >> >>> synonyms="punctuation-whitelist.txt" ignoreCase="true" >> expand="false"/> >> >>> <tokenizer class="solr.KeywordTokenizerFactory"/> >> >>> <filter class="solr.LowerCaseFilterFactory"/> >> >>> <filter class="solr.ASCIIFoldingFilterFactory"/> >> >>> </analyzer> >> >>> </fieldType> >> >>> >> >>> Thanks, >> >>> >> >>> -- >> >>> Thanks & Regards, >> >>> Yaswanth Kumar Konathala. >> >>> yaswanth...@gmail.com >> >> >> > >> > >> > -- >> > Thanks & Regards, >> > Yaswanth Kumar Konathala. >> > yaswanth...@gmail.com >> >> > > -- > Thanks & Regards, > Yaswanth Kumar Konathala. > yaswanth...@gmail.com > -- Thanks & Regards, Yaswanth Kumar Konathala. yaswanth...@gmail.com