This is a fundamental limitation of the datastore.. and is what allows it to scale out.
Imagine if facebook tried to do a Sum() for a column over a table made out of 100 shards that existed on 50 different federated database machines... they can.. but not with some fancy built in db function. They give up that ability so they can scale out.. So.. if you want to process your data like you would on your own personal database.. then you need to do a dump of your datastore data.. and process it offline in your own personal database. On Mon, Feb 22, 2010 at 4:03 PM, g...@intotheether <[email protected]>wrote: > I would like to thank Google for providing the appengine. > I have been able to create my application(s), upload, create servlets > and work with the datastore. > > When I went to create summary (report) data I was disappointed to > find' > > Group by doesnt work > Count(*, field) others also does not seem to work in GQL. > > Is this going to be a forever sort of thing? > > Is this common with Object Databases? > > Please don't flame me, it just seems very limiting and I am curious if > it will change? > (One of the purposes of collecting data is to be able to analyze it > and make decisions) > > Thanks again. > > Gary > > ----- (Ok for moderators to answer and kill) --- > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
