Bigtable now supports SQL GROUP BY with aggregation functions SUM, AVG, COUNT, MIN, MAX, HLL_COUNT.MERGE... and Continuous Materialized Views to calculate aggregations incrementally into materialized views.