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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

PRAGMA DisableSimpleColumns;
/* postgres can not */
/* kikimr can not */
/* ignore runonopt plan diff */
USE plato;
pragma yt.MapJoinLimit="1m";

-- YQL-5582
$join = (select
    a.key as key,
    a.subkey as subkey,
    a.value as value
from (select * from Input where value > "bbb") as a
left join Input as b
on a.key = b.key);


select count(*) from $join;