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


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

/* postgres can not */
/* kikimr can not */

SELECT * FROM (
    SELECT key, value || "a" as value FROM plato.Input
    union all
    SELECT key, "1" as value from plato.Input
    union all
    SELECT key, "1" as value from plato.Input
    union all
    SELECT key, "3" as value from plato.Input
) AS x
ORDER BY key, value
;