Hacker News new | ask | show | jobs
by proamdev123 925 days ago
Can you expand on this? What is the difference between `GROUP BY` and `SUMMARIZE`?

I’m familiar with SQL, but not the artificial limitations that you’re referring to, and I’d like to better understand.

1 comments

I'm guessing they're referring to the fact that typically when you use `GROUP BY` in SQL (aside from aggregate functions such as `ARRAY_AGG`), you're typically not returning a "group" of results, but a summary of the results in the group.
Exactly.