aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/mapjoin_sharded.sql
blob: e5af0c450921cd996f7af5e07bd26c4f0ed89927 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
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;