yql/essentials/tests/sql/suites/join/yql-14847.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

USE plato;

pragma yt.MapJoinLimit="1M";

$t = (
SELECT 
    l.key as key,
    r.subkey as subkey,
    l.value || r.value as value
FROM 
    Input1 as l
CROSS JOIN 
    Input2 as r
);

SELECT
    l.*,
    r.value as rvalue
FROM 
    $t as l 
LEFT JOIN 
    Input3 as r 
ON l.key = coalesce("" || r.key, "")