blob: 215ba02fe4d4b84ba9ccb17836f1974989be1c7c (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
|
USE plato;
pragma yt.JoinMergeTablesLimit="100";
pragma yt.MapJoinLimit="10M";
pragma yt.MaxReplicationFactorToFuseOperations="1";
SELECT
a.key, a.subkey, c.value
FROM Input1 as a
JOIN /*+ merge() */ Input2 as b ON a.key = b.key AND a.subkey = b.subkey
JOIN Input3 as c ON b.key = c.key AND b.subkey = c.subkey
ORDER BY c.value;
|
