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


1
2
3
4
5
6
7
8
9
10

use plato;
pragma yt.MapJoinLimit="1M";

$i = select TableRecordIndex() as ind, t.* from Input as t;
$filter = select min(ind) as ind from $i group by subkey;

select
    *
from Input
where TableRecordIndex() in $filter;