I don't think aggregations in the Solr group by are completed yet. There's a Lucene or Solr issue implementing group by count that could be adapted to implement average for example.
On Sat, Jul 7, 2012 at 4:37 PM, Jeremy Branham <jdbran...@hotmail.com>wrote: > Thanks for the replies. > I may be able to simplify my requirements. > > In my application, the number of documents per group indicate popularity. > If I could sort the groups descending by the document count, then using > the stats component + filter I could query each group to get avg value for > a field. > > Though I dont see how to sort the groups by document count. > I thought maybe a pseudo field with a functional query would return a > document element but my tests failed. > > Its a bit of a challenge to switch my thought process from SQL to Solr. > > > Jeremy Branham > Software Engineer > http://LinkedIn.com/in/**JeremyBranham<http://LinkedIn.com/in/JeremyBranham> > http://jeremybranham.**wordpress.com/<http://jeremybranham.wordpress.com/> > http://Zeroth.biz > > -----Original Message----- From: Jason Rutherglen > Sent: Saturday, July 07, 2012 2:45 PM > > To: solr-user@lucene.apache.org > Subject: Re: Grouping and Averages > > Average should be doable in Solr, maybe not today, not sure. Median is the > challenge :) Try Hive. > > On Sat, Jul 7, 2012 at 3:34 PM, Walter Underwood <wun...@wunderwood.org > >wrote: > > It sounds like you need a database for analytics, not a search engine. >> >> Solr cannot do aggregates like that. It can select and group, but to >> calculate averages you'll need to fetch all the results over the network >> and calculate them yourself. >> >> wunder >> >> On Jul 7, 2012, at 9:05 AM, Jeremy Branham wrote: >> >> > I’m sorry – I sent this email before I was confirmed in the group, so I >> don’t know if anyone sent a reply =\ >> > >> > ______________________________**____________ >> > >> > Hello - >> > I’m not sure If this is an appropriate use for Solr, but I want to stay >> away from a typical DB store for high availability reasons. >> > >> > I am storing documents that may have a common value for a field we’ll >> call “category”. >> > In another field there will be an integer field we’ll call “rating”. >> > >> > I would like to group the documents on the “category” field and display >> the average “rating” per group. >> > >> > The stats component lets me get the avg rating, but when I collapse the >> results into groups it gives me the average for the entire collection, >> rather than for the specific group. >> > >> > Am I going about this wrong? >> > Is it possible to get the desired outcome with a single query? >> > >> > I’d appreciate any insight! >> > Thank you, >> > >> > >> > >> > Jeremy Branham >> > Software Engineer >> > http://LinkedIn.com/in/**JeremyBranham<http://LinkedIn.com/in/JeremyBranham> >> > http://jeremybranham.**wordpress.com/<http://jeremybranham.wordpress.com/> >> > http://Zeroth.biz >> >> >> >> >> >
