yt/yql/tests/sql/suites/sampling/yql-14664_deps.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

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

INSERT INTO @a
SELECT
    *
FROM Input
WHERE key > "020";

COMMIT;

SELECT 
    *
FROM (
    SELECT
        *
    FROM  @a
    TABLESAMPLE BERNOULLI(50.0) REPEATABLE(1)
) LIMIT 10