aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/sampling/subquery_mapjoin.sql
blob: bd7c425a8ec894bef132f7890db1e3929ff33f7b (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
/* syntax version 1 */
/* postgres can not */
/* hybridfile can not YQL-17764 */
/* custom check: len(yt_res_yson[0]['Write'][0]['Data']) < 10 */
use plato;

pragma DisableSimpleColumns;
pragma yt.MapJoinLimit="1m";

select * from(
select * from plato.Input as a
inner join plato.Input as b
on a.key = b.key
) tablesample bernoulli(30);