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


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

/* postgres can not */
/* kikimr can not */
/* hybridfile can not YQL-17284 */
/* custom check: len(yt_res_yson[0]['Write'][0]['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
;