blob: 0aeadca09a1e65d2553e080ba32d0a83db149ff8 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
/* postgres can not */
/* kikimr can not */
use plato;
PRAGMA DisableSimpleColumns;
pragma yt.LookupJoinLimit="64k";
pragma yt.LookupJoinMaxRows="100";
pragma yt.QueryCacheMode="normal";
pragma yt.QueryCacheUseForCalc="true";
insert into @tmp with truncate
select * from Input
where subkey == "bbb"
order by key;
commit;
select * from Input as a
inner join @tmp as b on a.key = b.key
order by a.key, a.subkey;
|
