aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/lookupjoin_take_skip.sql
blob: de1195209c6fe96bd4e5c2319c7170591d2a4142 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
USE plato;
PRAGMA yt.LookupJoinMaxRows="3";
pragma yt.LookupJoinLimit = '10M';

insert into @big
select * from (select ListMap(ListFromRange(1, 100), ($x)->(Unwrap(CAST($x as String)))) as key) flatten list by key order by key;
commit;

$small = select substring(key, 0, 2) as key, subkey || '000' as subkey  from Input order by key limit 5 offset 8;

select * from @big as a join $small as b using(key) order by key;