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
其他导入
Pipe
导出
ETL 任务
数据目录 (Catalog),数据库,资源
Catalog
数据库
资源
表,分区,分桶,索引
- ALTER TABLE
- CANCEL ALTER TABLE
- CREATE INDEX
- CREATE TABLE
- CREATE TABLE AS SELECT
- CREATE TABLE LIKE
- DELETE
- DROP INDEX
- DROP TABLE
- REFRESH EXTERNAL TABLE
- SELECT
- SHOW ALTER TABLE
- SHOW CREATE TABLE
- SHOW DELETE
- SHOW DYNAMIC PARTITION TABLES
- SHOW PARTITIONS
- SHOW FULL COLUMNS
- SHOW INDEX
- SHOW TABLES
- SHOW TABLET
- TRUNCATE TABLE
- UPDATE
视图,物化视图
视图
物化视图
- ALTER MATERIALIZED VIEW
- CANCEL REFRESH MATERIALIZED VIEW
- CREATE MATERIALIZED VIEW
- DROP MATERIALIZED VIEW
- REFRESH MATERIALIZED VIEW
- SHOW ALTER MATERIALIZED VIEW
- SHOW CREATE MATERIALIZED VIEW
- SHOW MATERIALIZED VIEWS
函数,SELECT
CBO 统计信息
- ANALYZE TABLE
- CREATE ANALYZE
- DROP ANALYZE
- DROP STATS
- KILL ANALYZE
- SHOW ANALYZE JOB
- SHOW ANALYZE STATUS
- SHOW META
备份与恢复
- BACKUP
- CANCEL BACKUP
- CANCEL RESTORE
- CREATE REPOSITORY
- DROP REPOSITORY
- RECOVER
- RESTORE
- SHOW BACKUP
- SHOW REPOSITORIES
- SHOW RESTORE
- SHOW SNAPSHOT