Aggregations
This page describes how to aggregate Kafka data in Lenses SQL Studio.
Last updated
This page describes how to aggregate Kafka data in Lenses SQL Studio.
Last updated
2024 © Lenses.io Ltd. Apache, Apache Kafka, Kafka and associated open source project names are trademarks of the Apache Software Foundation.
For a full list of aggregation functions see the .
Using the COUNT
aggregate function you can count the records in a table. Run the following SQL to see how many records we have on the customers_partitioned
:
Using the SUM
function you can sum records in a table.
To group data use the GROUP BY
clause:
Let’s see how many customers there are from each country. Here is the code which computes that: