ydb/yt/yql/tests/sql/suites/join/premap_merge_with_remap.sql

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

INSERT INTO @inp2
SELECT * FROM Input2
ORDER BY BaseNo DESC;

COMMIT;

SELECT pd.BaseNo, m2.PhraseID, m2.Extra
    FROM Input1 as pd
    LEFT JOIN (select BaseNo, PhraseID, 1 as Extra from @inp2) as m2
    USING (BaseNo, PhraseID)
ORDER BY pd.BaseNo, m2.PhraseID, m2.Extra;