9951 explained code solutions for 126 technologies


clickhouseCreate table example


CREATE TABLE tbl (date Date, col String) ENGINE = MergeTree ORDER BY date;ctrl + c
CREATE TABLE

creates specified table

tbl

name of the table

date Date, col String

columns declaration

ENGINE = MergeTree

use MergeTree (most powerful Clickhouse engine)

ORDER BY date

this is something similar to default index of the table (data will be stored in a specified sort order)