yql/essentials/tests/sql/suites/join/mapjoin_left_null_column.sql


1
2
3
4
5
6
7
8
9
10
11

/* syntax version 1 */
/* postgres can not */

PRAGMA yt.MapJoinLimit="1m";

USE plato;

$t = [<|"x":"150", "y":1, "z":Null|>, <|"x":"150", "y":2, "z":Null|>];

SELECT * FROM Input1 AS a LEFT JOIN AS_TABLE($t) AS b ON a.key = b.x ORDER BY key, y;