Hi, have a look at http://wiki.apache.org/solr/TermsComponent.
Regards, Carlos. 2013/5/8 ld <luzange...@gmail.com> > Within MySQL it is possible to get the Top N results while summing a > particular column in the database. For example: > SELECT ip_address, SUM(ip_count) AS count FROM table GROUP BY ip_address > ORDER BY count DESC LIMIT 5 > > This will return the top 5 ip_address based on the sum of ip_count. > > Is there a way to have a Facet query within Solr do the same? In other > words, count an entry as if there were 'ip_count entries', not just one? > > I have used the Stats component and faceting but this gives me all the > records, there is no way to limit to the top 10 sums. My data set may have > millions of records with much variation on IP address so this wouldn’t > work. > > I have also considered adding ip_count number of entries when writing to > solr but this causes some issues with the unique ID shared with legacy code > that still uses MySQL. > > Any help is appreciated. > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Facet-which-takes-sum-of-a-field-into-account-for-result-values-tp4061588.html > Sent from the Solr - User mailing list archive at Nabble.com. >
