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;
|