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


1
2
3
4
5
6
7
8
9
10
11

PRAGMA DisableSimpleColumns;
use plato;
pragma yt.JoinMergeTablesLimit="10";
pragma yt.JoinMergeUnsortedFactor="3.0";

SELECT *
    FROM CONCAT("Left1", "Left2") as a
    INNER JOIN CONCAT("Right1", "Right2") as b
    USING(key)
ORDER BY a.value,b.value;