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


1
2
3
4
5
6
7
8
9
10

use plato;

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

pragma DisableSimpleColumns;
pragma yt.MapJoinLimit="1m";

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