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://jeremybranham.wordpress.com/ > > http://Zeroth.biz > > > >