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


1
2
3
4
5
6
7
8
9
10

/* syntax version 1 */
/* postgres can not */
use plato;

--insert into Output
select val, count(*) as cnt, grouping(val) as grouping
from Input as t
group by rollup(t.`dict`["c"] as val)
order by val, cnt
;