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


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

USE plato;

SELECT * FROM (
    SELECT 1 as key, subkey, '' as value from plato.Input1
    UNION ALL
    SELECT 2 as key, '' as subkey, value from plato.Input2
    UNION ALL
    SELECT 3 as key, subkey, '' as value from plato.Input3
    UNION ALL
    SELECT 4 as key, '' as subkey, value from plato.Input4
) AS x
ORDER BY key, subkey, value
;