/* 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 
        left_arg.key as key,
        left_arg.value as value,
        left_arg.key_before,
        right_arg.value
    from $input_stream as left_arg
    inner join $input_stream as right_arg
    on left_arg.key = right_arg.key;

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