yt/yql/tests/sql/suites/join/map_join_on_dynamic_tables.sql


1
2
3
4
5
6
7
8
9

USE plato;

PRAGMA yt.MapJoinLimit='1M';
PRAGMA yt.ConvertDynamicTablesToStatic='join';

SELECT a.*,
FROM Input1 as a
LEFT JOIN Input2 as b
ON a.key == b.subkey;