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