yql/essentials/tests/sql/suites/aggregate/agg_phases_table3.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

/* syntax version 1 */
/* postgres can not */
use plato;
pragma EmitAggApply;

pragma yt.UseAggPhases = "1";

SELECT
    key,
    count(value),
    count(distinct value)
FROM Input
GROUP BY key
ORDER BY key