HashAggregate — GROUP BY via an in-memory hash table

← all topics
SELECT country, count(*), sum(total) FROM orders GROUP BY country;
Input stream
Hash table (key = country)
Final output