The App Engine data warehouse could not be queried for the aggregate result.
Example: I have an object called Mail with the following fields:
Key id, String nickname, String postText, int score
I have many different aliases and many messages for each alias in my data warehouse.
If I need a leaderboard of the top ten nicknames, I would usually have sql as follows:
select nickname, sum(score) as sumscore
from Post
group by nickname
order by sumscore
limit 10
This type of request is not possible in the google app engine datastore java api (jdo or jpa).
What are the alternative strategies that I could use to achieve a similar result?
, Post . .
?