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


1
2
3
4
5
6
7
8
9
10

pragma yt.UsePartitionsByKeysForFinalAgg="false";

USE plato;

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