ClickHouse使用之六 ——指定排序id
CREATE TABLE web3.tx_hashes
(
`id` UInt64,
`created_at` Nullable(DateTime),
`updated_at` Nullable(DateTime),
`deleted_at` Nullable(DateTime),
`game_name` Nullable(String),
`chain_id` Nullable(Int16),
`tx_hash` Nullable(String),
`block_number` Nullable(Int64),
`sender` Nullable(String),
`Address` Nullable(String),
`tx_type` Nullable(String)
)
ENGINE = MergeTree
ORDER BY id
SETTINGS index_granularity = 8192;
order by id指定通过id排序来创建表格