yt/yql/tests/sql/suites/ytflow/join_wrong_sides.yql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

/* sort outputs */

use plato;

pragma Engine = "ytflow";

pragma Ytflow.Cluster = "plato";
pragma Ytflow.PipelinePath = "pipelines/test";

$input_stream = 
    select 
        key || "_before" as key_before,
        key,
        value
    from Input
    where value > 2;

$joined_stream =
    select 
        right_arg.key as key,
        right_arg.value as value,
        right_arg.key_before,
        left_arg.kv_value
    from InputKeyValueTable as left_arg
    left join $input_stream as right_arg
    on left_arg.key = right_arg.key;

insert into Output
select 
    key,
    value,
    `right_arg.key_before` as key_before,
    key || "_after" as key_after,
    `left_arg.kv_value` as kv_value
from $joined_stream
where value * 2 <= `left_arg.kv_value` or value < 5;