yql/essentials/tests/sql/suites/blocks/finalize_hashed_keys.sql


1
2
3
4
5
6
7
8
9

pragma yt.UsePartitionsByKeysForFinalAgg="false";

USE plato;

SELECT
    key, count(*), count(subkey), min(subkey), max(subkey), sum(subkey), avg(subkey)
FROM Input
GROUP by key
ORDER by key;