yql/essentials/tests/sql/suites/sampling/bind_expr_udf.sql


1
2
3
4
5
6
7

/* syntax version 1 */
/* postgres can not */
USE plato;

$percent = Math::Ceil(0.2);

SELECT * FROM Input TABLESAMPLE BERNOULLI(Math::Ceil(100 * $percent)) ORDER BY key; -- 100% sample