yql/essentials/tests/sql/suites/hor_join/group_ranges.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

/* postgres can not */
/* kikimr can not */
USE plato;

$i = (SELECT * FROM plato.range(``, Input1, Input4));

SELECT * FROM (
    SELECT 1 as key, subkey, value FROM $i
    UNION ALL
    SELECT 2 as key, subkey, value FROM $i
) AS x
ORDER BY key, subkey, value
;