yt/yql/tests/sql/suites/column_order/ordered_plus_native.yql


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

/* postgres can not */
/* syntax version 1 */
USE plato;

PRAGMA OrderedColumns;
PRAGMA yt.UseNativeYtTypes;


INSERT INTO Output WITH TRUNCATE
SELECT
    aggr_list(subkey) as subkey,
    key,
FROM Input AS a
GROUP BY a.key as key;