Jan, Thanks for the response,
I though of using it, but it will be suboptimal to do this in the scenario I have. I guess I have to explain the scenario better, let me try it again:- 1. I have importance based buckets in the system, this is implemented using a variable named bucket_count having integer values 0,1,2,3, and I have to show results in order of bucket_count i.e. results from 0th bucket at top, then results from 1st bucket and so on. That is done by doing a asc sort on this variable. 2. Now *within these buckets* I need to ensure that 1st listing of every advertiser comes at top, then 2nd listing from every advertiser and so on. Now if I go with the grouping on advertiserId and and use the group.offset, then probably I also need to do additive filtering on bucket_count. To explain it better pseudo algorithm will be like 1. query solr with group.offset 0 and bucket count 0 2. if results more than zero in step1 then increase group offset and follow step 1 again 3. else increase bucket count with group offset zero and start from step 1. With this logic in the worst case I need to query solr (number of importance buckets)*(max number of listings by an advertiser). Which could be very high number of solr queries for a single user query. Please suggest if I can do this with more optimal way. I am also open to do modifications in solr/lucene code if needed. Regards, BC Rathore On Fri, Apr 27, 2012 at 4:09 AM, Jan Høydahl <jan....@cominvent.com> wrote: > Hi, > > How about trying grouping with paging? > First you do > group=true&group.field=advertiserId&group.limit=1&group.offset=0&group.main=true&sort=something&group.sort=how-much-paid > desc > > That gives you one listing per advertiser, sorted the way you like. > Then to grab the next batch of ads, you go group.offset=1 etc etc. > > -- > Jan Høydahl, search solution architect > Cominvent AS - www.cominvent.com > Solr Training - www.solrtraining.com > > On 26. apr. 2012, at 08:10, solr user wrote: > > > Hi, > > > > We are planning to move the search of one of our listing based portal to > > solr/lucene search server from sphinx search server. But we are facing a > > challenge is porting customized sorting being used in our portal. We only > > have last 60 days of data live.The algorithm is as follows:- > > > > 1. Put all listings into 54 buckets – (Date bucket for 60 days) i.e. > > buckets of 7day, 1 day, 1 day…… > > 2. For each date bucket we make 2 buckets –(Paid / free bucket) > > 3. For each paid / free bucket cycle the advertisers on uniqueness > basis > > > > i.e. inside a bucket the ordering should be 1st listing > > of each advertiser, 2nd listing of each advertiser and so on > > in other words within a *sub-bucket* second listing of > an > > advertiser will be displayed only after first listing of all advertiser > has > > been displayed. > > > > For taking care of point 1 and 2 we have created a field named > bucket_index > > at the time of indexing the data and get the results sorted by this > index, > > but we are not able to find a way to create a sort field at index time or > > think of a sort function for the point no 3. Please suggest if there is > a > > way to do so in solr. > > > > Tia, > > > > BC Rathore > >
