aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/hor_join/out_sampling.sql
blob: 7619a391fc234026db99fa0f692028952b1876b2 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
/* postgres can not */
/* kikimr can not */
/* custom check: len(yt_res_yson[0]['Write'][0]['Data']) == 10 and len(yt_res_yson[1]['Write'][0]['Data']) < 10 and len(yt_res_yson[2]['Write'][0]['Data']) < 10 and len(yt_res_yson[3]['Write'][0]['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;