name NUMBER NAME name partition NUMBER as NAME print [devices|free|list,all|NUMBER] display the partition table, available devices, free space, all found partitions, or a particular partition quit exit program rescue START END rescue a lost partition
diskPaths[,diskPaths...]].The disk paths can not access: serverIP:diskPaths [,diskPaths...] [; serverIP:diskPaths[,diskPaths...]].The disk paths must be directory: serverIP:diskPaths [,diskPaths...] [; serverIP:diskPaths[,diskPaths...]].The disk paths
支持创建分区表全局索引,目前仅支持btree索引类型 -- 建表 CREATE TABLE parent_range_tbl( c1 int not null, c2 int not null, c3 int not null ) PARTITION BY RANGE (c1); CREATE TABLE part_0_100 PARTITION OF parent_range_tbl FOR VALUES FROM (0) TO (100); CREATE TABLE part_100_200
当指定IDENTIFIED WITH sha256_password时,云数据库ClickHouse会为您对密码进行哈希处理。例如: CREATE USER name3 IDENTIFIED WITH sha256_password BY 'my_password' name3用户现在可以使用my_password登录,但密码以上述哈希值的形式存储。