blob: bcdb5aa48592039e7da92b9ee0874222dc274df0 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
/* kikimr can not */
use plato;
PRAGMA DisableSimpleColumns;
PRAGMA yt.JoinCollectColumnarStatistics="async";
PRAGMA yt.MinTempAvgChunkSize="0";
PRAGMA yt.MapJoinLimit="1";
SELECT *
FROM (select distinct key,subkey from Input where cast(key as Int32) > 100 order by key limit 100) as a
RIGHT JOIN (select key,value from Input where cast(key as Int32) < 500) as b
USING(key)
ORDER BY a.key,a.subkey,b.value;
|
