summaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/materialize/aggregate_result.yql
blob: cc58dc7bed1c7a7108deffd7b7dba86404a281f8 (plain) (blame)
1
2
3
4
5
use plato;

$aggregated = SELECT key, COUNT(*) AS cnt FROM Input GROUP BY key;
MATERIALIZE $aggregated INTO $result;
SELECT * FROM $result ORDER BY key;