ydb/yt/yql/tests/sql/suites/join/mapjoin_sharded.sql

use plato;

/* postgres can not */
/* kikimr can not */

pragma DisableSimpleColumns;
/* yt_local_var: MAP_JOIN_LIMIT = 30 */
/* yqlrun_var: MAP_JOIN_LIMIT = 1000 */
pragma yt.MapJoinLimit="MAP_JOIN_LIMIT";
pragma yt.MapJoinShardCount = "10";

select *
from Input1 as a join Input2 as b on a.key = b.key and a.subkey = b.key;