summaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/sampling/bind_join_left.yql
blob: 2d1fdf3e103d4bf867ae2d2795f7553c3c68a21a (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
/* syntax version 1 */
/* postgres can not */
/* hybridfile can not YQL-17764 */
/* custom check: len(yt_res_yson[0][b'Write'][0][b'Data']) < 3 */

use plato;
pragma DisableSimpleColumns;

$a = select * from Input where key > "199" and value != "bbb";

select * from (select a.value, b.value from $a as a inner join Input as b using(subkey)) tablesample bernoulli(25);