lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepak Udapudi" <DUdap...@delta.org>
Subject RE: problem with Solr Sorting by score and distance together
Date Fri, 05 Jan 2018 00:26:16 GMT
Hi Shawn,

Thanks for the response.

In the problem example in the below email I had used a hypothetical example for my query.

Actually, we are trying to search for the name and specialty combination(for ex:- paul orthodontist)
of the dentist sorted by the highest score and distance (in case of same dentists matching
the free text criteria).

Below are the Solr logs.

2018-01-05 00:13:05.835 INFO  (qtp1348949648-14) [   x:provider_collection] o.a.s.c.S.Request
[provider_collection]  webapp=/solr path=/select params={q=distance:{!geofilt+sfield%3Dlocation+pt%3D37.564143,-122.004179+d%3D60.0}&fl=*,distance:mul(geodist(location,37.5641425,-122.004179),0.621371)&start=0&fq=facilityName:"orthodontist"+OR+facilityName:*orthodontist*+OR+facilityName:"paul"+OR+facilityName:*paul*+OR+facilityName:*paul+orthodontist*+OR+facilityName:"paul+orthodontist"+OR+firstName:"orthodontist"+OR+firstName:*orthodontist*+OR+firstName:"paul"+OR+firstName:*paul*+OR+firstName:*paul+orthodontist*+OR+firstName:"paul+orthodontist"+OR+fullName:"orthodontist"+OR+fullName:*orthodontist*+OR+fullName:"paul"+OR+fullName:*paul*+OR+fullName:*paul+orthodontist*+OR+fullName:"paul+orthodontist"+OR+groupPracticeNpi:"orthodontist"+OR+groupPracticeNpi:*orthodontist*+OR+groupPracticeNpi:"paul"+OR+groupPracticeNpi:*paul*+OR+groupPracticeNpi:*paul+orthodontist*+OR+groupPracticeNpi:"paul+orthodontist"+OR+keywords:"orthodontist"+OR+keywords:*orthodontist*+OR+keywords:"paul"+OR+keywords:*paul*+OR+keywords:*paul+orthodontist*+OR+keywords:"paul+orthodontist"+OR+lastName:"orthodontist"+OR+lastName:*orthodontist*+OR+lastName:"paul"+OR+lastName:*paul*+OR+lastName:*paul+orthodontist*+OR+lastName:"paul+orthodontist"+OR+licenseNumber:"orthodontist"+OR+licenseNumber:*orthodontist*+OR+licenseNumber:"paul"+OR+licenseNumber:*paul*+OR+licenseNumber:*paul+orthodontist*+OR+licenseNumber:"paul+orthodontist"+OR+npi:"orthodontist"+OR+npi:*orthodontist*+OR+npi:"paul"+OR+npi:*paul*+OR+npi:*paul+orthodontist*+OR+npi:"paul+orthodontist"+OR+officeName:"orthodontist"+OR+officeName:*orthodontist*+OR+officeName:"paul"+OR+officeName:*paul*+OR+officeName:*paul+orthodontist*+OR+officeName:"paul+orthodontist"+OR+practiceLocationLanguages:"orthodontist"+OR+practiceLocationLanguages:*orthodontist*+OR+practiceLocationLanguages:"paul"+OR+practiceLocationLanguages:*paul*+OR+practiceLocationLanguages:*paul+orthodontist*+OR+practiceLocationLanguages:"paul+orthodontist"+OR+practiceLocationNpi:"orthodontist"+OR+practiceLocationNpi:*orthodontist*+OR+practiceLocationNpi:"paul"+OR+practiceLocationNpi:*paul*+OR+practiceLocationNpi:*paul+orthodontist*+OR+practiceLocationNpi:"paul+orthodontist"+OR+providerLanguages:"orthodontist"+OR+providerLanguages:*orthodontist*+OR+providerLanguages:"paul"+OR+providerLanguages:*paul*+OR+providerLanguages:*paul+orthodontist*+OR+providerLanguages:"paul+orthodontist"+OR+specialty:"orthodontist"+OR+specialty:*orthodontist*+OR+specialty:"paul"+OR+specialty:*paul*+OR+specialty:*paul+orthodontist*+OR+specialty:"paul+orthodontist"&sort=geodist(location,37.564143,-122.004179)+asc,score+desc&rows=10&wt=javabin&version=2}
hits=577 status=0 QTime=284

2018-01-05 00:13:06.886 INFO  (qtp1348949648-17) [   x:provider_collection] o.a.s.c.S.Request
[provider_collection]  webapp=/solr path=/admin/ping params={wt=javabin&version=2} hits=304592
status=0 QTime=0
2018-01-05 00:13:06.886 INFO  (qtp1348949648-17) [   x:provider_collection] o.a.s.c.S.Request
[provider_collection]  webapp=/solr path=/admin/ping params={wt=javabin&version=2} status=0
QTime=0
2018-01-05 00:13:06.888 INFO  (qtp1348949648-16) [   x:provider_collection] o.a.s.c.S.Request
[provider_collection]  webapp=/solr path=/admin/ping params={wt=javabin&version=2} hits=304592
status=0 QTime=0
2018-01-05 00:13:06.888 INFO  (qtp1348949648-16) [   x:provider_collection] o.a.s.c.S.Request
[provider_collection]  webapp=/solr path=/admin/ping params={wt=javabin&version=2} status=0
QTime=0
2018-01-05 00:13:06.891 INFO  (qtp1348949648-19) [   x:yelp_collection] o.a.s.c.S.Request
[yelp_collection]  webapp=/solr path=/admin/ping params={wt=javabin&version=2} hits=13
status=0 QTime=0
2018-01-05 00:13:06.891 INFO  (qtp1348949648-19) [   x:yelp_collection] o.a.s.c.S.Request
[yelp_collection]  webapp=/solr path=/admin/ping params={wt=javabin&version=2} status=0
QTime=0

Request you to go through the above logs and provide us the recommendation to go forward.

Regards,
Deepak

-----Original Message-----
From: Shawn Heisey [mailto:apache@elyograg.org] 
Sent: Thursday, January 04, 2018 5:17 AM
To: solr-user@lucene.apache.org
Subject: Re: problem with Solr Sorting by score and distance together

On 1/3/2018 6:16 PM, Deepak Udapudi wrote:
> Assume that,  I am searching for car care centers. Solr collection has the data for all
the major car care centers. As an example I search for Firestone car care centers in a 5 miles
radius. In the search results I am supposed to receive the firestone car care centers list
within 5 miles from the specified location and the centers should be sorted in distance order.
> 
> In the solr query handler I have specified the following.
> 
> i)                    I have specified the query condition (q) to be based on distance
parameter (basically search for records within a certain distance in miles).
> 
> ii)                   I have specified the filter query  conditions (fq) where fields
accepting general text are matching free text input (for ex :- Firestone Carcare)

These should probably be the other way around -- so the q parameter contains the user provided
query and the distance is a filter.  It's more in line with the way I expect things to be
done, and it would probably result in more efficient performance of the filterCache.  Also,
filter queries do not affect the score -- at all.  So you're not getting any relevance information
from the query that your user is typing.

I don't know very much about spatial, but there is a lot of documentation I can read.

> iii)                 I have specified the sort condition(sort ) to be based on score(calculated
based on the filter query (fq) conditions applied in the 2nd item in the list) and distance.
If there are duplicate records matching by score, then distance should be used to order the
duplicate records.

Can you provide the entry from solr.log that shows the full query 
request?   Below is the kind of log entry I am talking about.  This was 
obtained by going to the admin UI query tab, typing in "example query", and then executing
that query.

2018-01-04 13:10:03.042 INFO  (qtp1394336709-1102402) [   x:ncmain] 
o.a.s.c.S.Request [ncmain]  webapp=/solr path=/select params={q=example+query&indent=on&wt=json&_=1515071388516}
hits=2163
status=0 QTime=4473

Thanks,
Shawn


The information contained in this email message and any attachments is confidential and intended
only for the addressee(s). If you are not an addressee, you may not copy or disclose the information,
or act upon it, and you should delete it entirely from your email system. Please notify the
sender that you received this email in error.
Mime
View raw message