yql/essentials/tests/sql/suites/union_all/union_all_subexpr.sql


1
2
3
4
5
6
7

SELECT *
FROM (
    SELECT key, CAST(subkey AS int) as subkey, NULL as value FROM plato.Input
    UNION ALL
    SELECT key, NULL as subkey, value from plato.Input
) as x
ORDER BY key, subkey, value;