blob: 96cb5ca79a8a70ec9fca7a86de7c5b240e81f888 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
|
PRAGMA DisableSimpleColumns;
use plato;
pragma yt.LookupJoinLimit="64k";
pragma yt.LookupJoinMaxRows="100";
-- prefix of sort keys
select * from Input1 as a
left semi join (select * from Input2 where k2 != "ccc") as b on a.k1 = b.k2
order by a.k1;
|
