First Group By is only allowed on partition keys and clustering columns, not on arbitrary column. The internal implementation of group by tries to fetch data on clustering order to avoid having to "re-sort" them in memory which would be very expensive
Second, group by works best when restricted to a single partition other wise it will force Cassandra to do a range scan so poor performance For all of those reasons I don't expect an "order by" on aggregated values to be available any soon Furthermore, Cassandra is optimised for real-time transactional scenarios, the group by/order by/limit is typically a classical analytics scenario, I would recommend to use the appropriate tool like Spark for that Le 6 juin 2017 04:00, "Roger Fischer (CW)" <rfis...@brocade.com> a écrit : Hello, is there any intent to support “order by” and “limit” on aggregated values? For time series data, top n queries are quite common. Group-by was the first step towards supporting such queries, but ordering by value and limiting the results are also required. Thanks… Roger
