DORIS 运维维护命令

FE/BE启动#

bin/start_fe.sh --daemon

bin/start_be.sh --daemon

添加FE#

ALTER SYSTEM ADD FOLLOWER "follower_host:edit_log_port";

ALTER SYSTEM ADD OBSERVER "observer_host:edit_log_port";

删除FE#

ALTER SYSTEM DROP FOLLOWER[OBSERVER] "==fe==_host:edit_log_port";

添加BE#

ALTER SYSTEM ADD BACKEND "be_host:heartbeat-service_port";

删除BE#

不推荐！！（这样会直接删除 BE，并且其上的数据将不能再恢复）
ALTER SYSTEM DROP BACKEND "be_host:be_heartbeat_service_port";

推荐：
ALTER SYSTEM DECOMMISSION BACKEND "be_host:be_heartbeat_service_port";

撤销一个节点下线操作
CANCEL DECOMMISSION BACKEND "host:heartbeat_port"[,"host:heartbeat_port"...];

查看FE/BE状态#

SHOW BACKENDS;

SHOW FRONTENDS;

查看启用了动态分区的表#

SHOW DYNAMIC PARTITION TABLES

查看某张表的分区#

SHOW PARTITIONS FROM TABLE_NAME

查看某张表的表结构#

DESC table_name ALL

查看某张表的建表语句#

SHOW CREATE TABLE table_name

查看表或某个分区的数据倾斜情况#

SHOW DATA SKEW FROM table_name PARTITION(partition_name)

当前db下所有的动态分区表状态#

SHOW DYNAMIC PARTITION TABLES FROM db_name

列出指定table的所有tablets#

SHOW TABLETS FROM table_name

查看某张表的大小#

SHOW DATA FROM table_name

查看表的索引大小#

SHOW INDEX FROM table_name

查看执行中的语句#

SHOW PROCESSLIST

查看StreamLoad状态#

SHOW STREAM LOAD

查看配置#

ADMIN SHOW FRONTEND CONFIG

修改配置#

ADMIN SET FRONTEND CONFIG ("max_stream_load_record_size" = "10000")

查看profile的执行图#

SHOW QUERY PROFILE "/{QueryId}/{FragmentId}/{InstanceId}"

修改表结构#

修改列#

ALTER TABLE table_name MODIFY COLUMN age INT(11) KEY NULL;

添加列#

ALTER TABLE table_name ADD COLUMN age KEY INT(11) NULL AFTER post_time;

删除列#

ALTER TABLE table_name DROP COLUMN age;

修改表属性#

ALTER TABLE table_name SET ("bloom_filter_columns" = "age");

清理BE垃圾#

ADMIN CLEAN TRASH ON ("192.168.0.1:9050","192.168.0.2:9050");

或

ADMIN CLEAN TRASH;