如何在sphinx组搜索中对属性求和？
I need sphinx to sort the results by the sum of an attribute. I need to:
- Group the results by their IDs (done)
- Sort the results by the SUM of one attribute
I can't find a way to sum this attribute. How could I do this?
(Im using sphinx PHP API)
我需要sphinx按属性的总和对结果进行排序。 我需要： p>
- 按结果对结果进行分组（完成） li>
- 按一个属性的SUM对结果进行排序 li >
ul>
我找不到对这个属性求和的方法。 我该怎么做？ p>
（我正在使用sphinx PHP API ） p> div>
Sphinx supports aggregate functions (sum, avg, min, max) since 0.9.9-rc2 version. Check the documentation from www.sphinxsearch.com/docs/current.html
As far as I can tell, this is not possible in the current Sphinx version. The group by functions are designed to return the group by attribute (that is, the distinct attribute to the group of items), the count within that group, and the 'top' item from the group.
Your best bet is to do your summing outside of Sphinx. You could perform a Sphinx search sorting by your group by attribute, and then loop over those items in PHP, summing as you go. This approach may not be terribly efficient, so it might be something that you want to cache periodically to reduce server load.
Echoing the previous answer, it's just not possible to do within a Sphinx query. While the expression syntax allows for some level of calculations in sorting, it doesn't have any aggregation functions. Unless you store that summed value as an attribute (which could be an option - calculate it during indexing), it's going to have to be a separate SQL query per record.