summaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/sampling/bind_multiple_sample.yql
blob: 7c7628d0c46c6978444c5fce0fba0cc24b42fc23 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
/* syntax version 1 */
/* postgres can not */
/* custom check: len(yt_res_yson[0][b'Write'][0][b'Data']) < 20 */
USE plato;

$var = SELECT * FROM Input;

INSERT INTO @tmp
SELECT * FROM $var TABLESAMPLE BERNOULLI(100);

INSERT INTO @tmp
SELECT * FROM $var TABLESAMPLE BERNOULLI(50);

COMMIT;

SELECT * FROM @tmp;