[最佳实践] - Doris实用SQL总结

ALTER DATABASE 数据库名字 SET DATA QUOTA 3t;

SELECT PASSWORD('密码明文');

CREATE USER some_user_rw@'%' IDENTIFIED BY PASSWORD '*加密的密码文本';

GRANT Select_priv ON 数据库名字.表名字 TO some_user_rw@'%';

 GRANT Select_priv,Load_priv,Alter_priv,Create_priv,Drop_priv ON 数据库名字.表名字 TO some_user_rw@'%'

GRANT Select_priv,Load_priv,Alter_priv,Create_priv,Drop_priv ON 数据库名字 TO some_user_rw@'%‘

REVOKE Select_priv ON 数据库 FROM some_user_rw@'%';

REVOKE Select_priv ON 数据库名字.表名字 FROM some_user_rw@'%';

ALTER SYSTEM ADD BACKEND "be ip:heartbeat port";

ALTER SYSTEM DECOMMISSION BACKEND "be ip:heartbeat port";

ALTER SYSTEM dropp BACKEND "be ip:heartbeat port";

ALTER SYSTEM ADD FOLLOWER或者OBSERVER "fe ip:edit_log_port";

./bin/start_fe.sh --helper master fe ip:edit_log_port --daemon

ALTER SYSTEM DROP FOLLOWER或者OBSERVER "fe_host:edit_log_port";

ALTER SYSTEM ADD BROKER 自定义的broker名字 "broker ip:port"

sh bin/start_broker.sh --daemon

alter table 数据库名.表名 set ("colocate_with" = "自定义名字");

CREATE INDEX 自定义索引名 ON 数据库名.表名 (字段名) USING BITMAP COMMENT '索引备注';

SHOW INDEX FROM 数据库名.表名;

DROP INDEX 索引名 ON 数据库名.表名;

SHOW ALTER TABLE COLUMN;