ydb/yt/yql/tests/sql/suites/hor_join/out_sampling.sql

/* postgres can not */
/* kikimr can not */
/* custom check: len(yt_res_yson[0][b'Write'][0][b'Data']) == 10 and len(yt_res_yson[1][b'Write'][0][b'Data']) < 10 and len(yt_res_yson[2][b'Write'][0][b'Data']) < 10 and len(yt_res_yson[3][b'Write'][0][b'Data']) == 10 */
USE plato;

SELECT key, some(value) FROM Input GROUP BY key;

SELECT key, sum(cast(subkey as Int32)) FROM Input SAMPLE 0.3 GROUP BY key;

SELECT key, some(subkey) FROM Input SAMPLE 0.3 GROUP BY key;

SELECT key, sum(length(value)) FROM Input GROUP BY key;