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.
