Aggregating results

Starting with DataStax Enterprise 5.0, the standard aggregate functions of min, max, avg, sum, and count are built-in functions.

  • A table cyclist_points records the race points for cyclists.

     CREATE TABLE cycling.cyclist_points (id UUID, firstname text, lastname text, race_title text, race_points int, PRIMARY KEY (id, race_points );
    useQueryStdAggregate1
  • Calculate the standard aggregation function sum to find the sum of race points for a particular cyclist. The value of the aggregate will be returned.

     SELECT sum(race_points) FROM cycling.cyclist_points WHERE id=e3b19ec4-774a-4d1c-9e5a-decec1e30aac;
    useQueryStdAggregate2
  • Another standard aggregate function is count. A table country_flag records the country of each cyclist.

    CREATE TABLE cycling.country_flag (country text, cyclist_name text, flag int STATIC, PRIMARY KEY (country, cyclist_name));
    useQueryStdAggregate3
  • Calculate the standard aggregation function count to find the number of cyclists from Belgium. The value of the aggregate will be returned.

     SELECT count(cyclist_name) FROM cycling.country_flag WHERE country='Belgium';
    useQueryStdAggregate4

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com