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


1
2
3
4
5

pragma config.flags("PeepholeFlags","UseAggPhases");

$data = [<|x:1,y:0|>,<|x:1,y:0|>,<|x:2,y:1|>];

select y,sum(distinct x) from as_table($data) group by y order by y;