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


1
2
3
4
5
6
7

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

$withStruct = select subkey, value, AsStruct(key as key) as s from Input3;

select count(distinct s.key) as cnt from $withStruct;