cube – Tarik Billa

When to use GROUPING SETS, CUBE and ROLLUP

September 10, 2023 by Tarik

Firstly, for those who haven’t already read up on the subject: Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS That being said, don’t think about these grouping options as ways to get a result set. These are performance tools. Let’s take ROLLUP as a simple example. I can use the following query to get … Read more

What is the difference between cube, rollup and groupBy operators?

April 16, 2023 by Tarik

These are not intended to work in the same way. groupBy is simply an equivalent of the GROUP BY clause in standard SQL. In other words table.groupBy($”foo”, $”bar”) is equivalent to: SELECT foo, bar, [agg-expressions] FROM table GROUP BY foo, bar cube is equivalent to CUBE extension to GROUP BY. It takes a list of … Read more