yql/essentials/tests/sql/suites/aggregate/group_by_rollup_grouping.sql


1
2
3
4
5
6

/* syntax version 1 */
/* postgres can not */
select sum(length(value)) as s, m0, m1, m2, grouping(m0, m1, m2) as ggg
from plato.Input
group by rollup(cast(key as uint32) as m0, cast(key as uint32) % 10u as m1, cast(key as uint32) % 100u as m2)
order by s, m0, m1, m2;