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


1
2
3
4
5
6
7
8
9
10

pragma yt.UsePartitionsByKeysForFinalAgg="false";

USE plato;

SELECT
    key,count(*),max(subkey),sum(distinct subkey),avg(subkey),count(distinct subkey/2u),avg(distinct subkey/2u)
FROM Input
GROUP BY key
ORDER BY key