summaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/join/prune_keys.yql
blob: bce76fcb3b4164a8c3f3e007acd2eeed550fe05f (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
/* postgres can not */
use plato;

pragma yt.JoinMergeTablesLimit = "10";
pragma config.flags('OptimizerFlags', 'EmitPruneKeys');

-- PruneKeys
select *
from a_sorted
where v1 in (select v2 from b_sorted);

-- PruneAdjacentKeys
select *
from a_sorted
where k1 in (select k2 from b_sorted);