v.22.12New Feature
Add GROUP BY ALL Syntax Support
Why it matters
TheGROUP BY ALL feature allows users to perform grouping without filtering out any rows, including those with NULL values. This solves the problem of missing groups in aggregation results when using standard GROUP BY, providing more comprehensive and accurate aggregation outputs.How to use it
Use the new syntax by addingGROUP BY ALL in your SQL query. For example:SELECT column1, count(*)
FROM table
GROUP BY ALL column1;