Open Samyak2 opened 1 year ago
This is a tracking issue for adding support for the GROUP BY clause of a SELECT statement. This allows aggregations over unique values of a column.
GROUP BY
SELECT
GroupBy
expr
Project
Filter
input
output
HAVING
Overview
This is a tracking issue for adding support for the
GROUP BY
clause of aSELECT
statement. This allows aggregations over unique values of a column.Tasks
GROUP BY
and aggregationsGroupBy
instructionexpr
forProject
orFilter
just like normal non-grouped aggregationsGROUP BY
codegen to the generic dialectGroupBy
instructions and aggregationsGroupBy
should probably haveinput
andoutput
registers likeProject
HAVING
clause can re-use aggregations that are already computed and it might be difficult to perform common sub-expression elimination here