/* postgres can not */ /* kikimr can not */ /* hybridfile can not YQL-17284 */ /* custom check: len(yt_res_yson[0][b'Write'][0][b'Data']) < 16 */ USE plato; SELECT * FROM ( SELECT CAST(key AS int) as key, '' as subkey, '' as value FROM plato.Input1 SAMPLE 0.1 UNION ALL SELECT CAST(key AS int) as key, subkey, '' as value FROM plato.Input2 SAMPLE 0.1 UNION ALL SELECT 1 as key, subkey, '' as value from plato.Input3 UNION ALL SELECT 1 as key, '' as subkey, value from plato.Input4 ) AS x ORDER BY key, subkey, value ;