All commands
本文罗列了所有 StarRocks 支持的 SQL 命令,并按照命令的功能进行了分类。
用户账户管理
管理用户、角色、和权限。
- ALTER USER
- CREATE ROLE
- CREATE USER
- DROP ROLE
- DROP USER
- EXECUTE AS
- GRANT
- REVOKE
- SET DEFAULT ROLE
- SET PASSWORD
- SET PROPERTY
- SET ROLE
- SHOW AUTHENTICATION
- SHOW GRANTS
- SHOW PROPERTY
- SHOW ROLES
- SHOW USERS
集群管理
管理集群,包括 FE、BE、Compute Node (CN) 节点、资源组 (Resource Group)、存储卷(Storage Volume)、表、Tablet、副本 (Replica)、文件、变量(Variable)、插件(Plugin)、SQL Blacklist 等。
节点和进程
- ALTER SYSTEM
- CANCEL DECOMMISSION
- KILL
- SHOW BACKENDS
- SHOW BROKER
- SHOW COMPUTE NODES
- SHOW FRONTENDS
- SHOW PROC
- SHOW PROCESSLIST
- SHOW RUNNING QUERIES
资源组
- ALTER RESOURCE GROUP
- CREATE RESOURCE GROUP
- DROP RESOURCE GROUP
- SHOW RESOURCE GROUP
- SHOW USAGE RESOURCE GROUPS
存储卷
- ALTER STORAGE VOLUME
- CREATE STORAGE VOLUME
- DESC STORAGE VOLUME
- DROP STORAGE VOLUME
- SET DEFAULT STORAGE VOLUME
- SHOW STORAGE VOLUMES
表,tablet,副本检查与修复
- ADMIN CANCEL REPAIR TABLE
- ADMIN CHECK TABLET
- ADMIN REPAIR TABLE
- ADMIN SET REPLICA STATUS
- ADMIN SET PARTITION VERSION
- ADMIN SHOW REPLICA DISTRIBUTION
- ADMIN SHOW REPLICA STATUS
- SHOW TABLE STATUS
系统配置、变量
文件
SQL 黑名单
插件
执行计划和 Profile
导入,导出
Routine load
- ALTER ROUTINE LOAD
- CREATE ROUTINE LOAD
- PAUSE ROUTINE LOAD
- RESUME ROUTINE LOAD
- SHOW ROUTINE LOAD
- SHOW ROUTINE LOAD TASK
- STOP ROUTINE LOAD