yql/essentials/tests/sql/suites/window/yql-14479.sql


1
2
3
4
5
6
7
8

/* custom check: len(yt_res_yson[0]['Write'][0]['Data']) < 4 */
/* ignore plan diff */
USE plato;

SELECT a.*, row_number() OVER (PARTITION BY key, subkey) as rn, TableName() as tn
FROM Input as a
TABLESAMPLE BERNOULLI(10.0) REPEATABLE(1)
;