blob: 1dd27bcc3a6aa5052bf17667421b99c30c197439 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
/* syntax version 1 */
/* postgres can not */
PRAGMA yt.JoinMergeTablesLimit="10";
PRAGMA yt.JoinAllowColumnRenames="true";
PRAGMA yt.JoinMergeUnsortedFactor="5.0";
USE plato;
$t = [<|"x":"bbb", "y":1, "z":Null|>, <|"x":"bbb", "y":2, "z":Null|>];
SELECT * FROM Input1 AS a LEFT JOIN AS_TABLE($t) AS b ON a.k1 = b.x ORDER BY k1, y;
|
