group_by_rollup_udf.sql 220 B

123456
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. use plato;
  4. select key, subkey, Unicode::ToUpper(CAST(value AS Utf8)) as value, count(1) as cnt from Input GROUP BY ROLLUP(key,subkey, value) ORDER BY key,subkey,value,cnt;