blob: b0dd13c10dcc18d5dd540a2b0bec6d41d5f77f9a (
plain) (
blame)
1
2
3
4
5
6
7
8
|
use plato;
PRAGMA DisableSimpleColumns;
pragma yt.JoinMergeTablesLimit="100";
select * from
(select * from Input where key < "020") as a
left only join (select subkey from Input where key < "010") as b on a.subkey = b.subkey
join /*+ merge() */ (select key, value from Input) as c on a.key = c.key
|