ydb/yt/yql/tests/sql/suites/blocks/finalize_hashed_keys.sql

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;