Aggregate Functions #

Amelie executes aggregate functions individually per backend in parallel. After the successful execution, each computation’s results (partial aggregates) are merged, processed, and returned.

Following aggregate functions are supported:

• count(distinct any)
• count(any)
• sum(int)
• sum(double)
• avg(int)
• avg(double)
• min(int)
• min(double)
• max(int)
• max(double)

All functions ignore NULL values.

There are also Lambda Aggregates, a unique aggregate type to Amelie.

create table example (id int primary key);
insert into example values (1), (2), (3);
select count(*), min(id), max(id), sum(id), avg(id) from example;
[[3, 1, 3, 6, 2]]