Clickhouse apply函数

dblab-VirtualBox :) CREATE TABLE columns_transformers (i Int64, j Int16, k Int64) ENGINE = MergeTree ORDER by (i);

CREATE TABLE columns_transformers
(
    `i` Int64,
    `j` Int16,
    `k` Int64
)
ENGINE = MergeTree
ORDER BY i

Query id: 05c008a6-ab92-43ae-90d5-5311d4b5e993

Ok.

0 rows in set. Elapsed: 0.004 sec. 

dblab-VirtualBox :) INSERT INTO columns_transformers VALUES (100, 10, 324), (120, 8, 23);

INSERT INTO columns_transformers VALUES

Query id: 5b5624a3-3001-42ef-917e-6f56f74926e0

Ok.

2 rows in set. Elapsed: 0.007 sec. 

dblab-VirtualBox :) show tables;

SHOW TABLES

Query id: 7536b671-a7ca-4def-96af-598c269c35a8

┌─name─────────────────┐
│ columns_transformers │
│ tb_summ_merge_tree   │
└──────────────────────┘

2 rows in set. Elapsed: 0.006 sec. 

dblab-VirtualBox :) select * from columns_transformers;

SELECT *
FROM columns_transformers

Query id: 7a598b5b-45c2-4758-a147-0a79841961e9

┌───i─┬──j─┬───k─┐
│ 100 │ 10 │ 324 │
│ 120 │  8 │  23 │
└─────┴────┴─────┘

2 rows in set. Elapsed: 0.006 sec. 

dblab-VirtualBox :) SELECT * APPLY(sum) FROM columns_transformers;

SELECT * APPLY sum
FROM columns_transformers

Query id: 77f853af-78d8-420b-a7be-3a1cef2a762b

┌─sum(i)─┬─sum(j)─┬─sum(k)─┐
│    220 │     18 │    347 │
└────────┴────────┴────────┘

1 rows in set. Elapsed: 0.006 sec.