All statements

This topic lists all the SQL statements supported by StarRocks and categorizes these statements by their functions.

• All statements
  • User account management
  • Cluster management
    • Nodes and processes
    • Resource group
    • Storage volume
    • Check and repair table, tablet, and replica
    • Configurations and variables
    • Files
    • SQL Blacklist
    • Plugin
    • Execution plan and query profile
  • Loading, unloading
    • Routine load
    • Other load
    • Pipe
    • Unloading
    • ETL task
  • Catalog, database, resource
    • Catalog
    • Database
    • Resource
  • Table, partition, bucket, index
  • View, materialized view
    • View
    • Materialized view
  • Function
  • CBO statistics
  • Backup and restore
  • Utility commands

User account management

Manages users, roles, and privileges.

• 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

Cluster management

Manages clusters, including FEs, BEs, compute nodes (CN), brokers, resource groups, storage volumes, tables, tablets, replicas, files, variables, plugins, and SQL blacklist.

Nodes and processes

• ALTER SYSTEM
• CANCEL DECOMMISSION
• KILL
• SHOW BACKENDS
• SHOW BROKER
• SHOW COMPUTE NODES
• SHOW FRONTENDS
• SHOW PROC
• SHOW PROCESSLIST
• SHOW RUNNING QUERIES

Resource group

• ALTER RESOURCE GROUP
• CREATE RESOURCE GROUP
• DROP RESOURCE GROUP
• SHOW RESOURCE GROUP
• SHOW USAGE RESOURCE GROUPS

Storage volume

• ALTER STORAGE VOLUME
• CREATE STORAGE VOLUME
• DESC STORAGE VOLUME
• DROP STORAGE VOLUME
• SET DEFAULT STORAGE VOLUME
• SHOW STORAGE VOLUMES

Check and repair table, tablet, and replica

• 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

Configurations and variables

• ADMIN SET CONFIG
• ADMIN SHOW CONFIG
• SET (variable)
• SHOW VARIABLES

Files

• CREATE FILE
• DROP FILE
• SHOW FILE

SQL Blacklist

• ADD SQLBLACKLIST
• SHOW SQLBLACKLIST
• DELETE SQLBLACKLIST

Plugin

• INSTALL PLUGIN
• SHOW PLUGINS
• UNINSTALL PLUGIN

Execution plan and query profile

• ANALYZE PROFILE
• EXPLAIN
• EXPLAIN ANALYZE
• SHOW PROFILELIST

Loading, unloading

Routine load

• ALTER ROUTINE LOAD
• CREATE ROUTINE LOAD
• PAUSE ROUTINE LOAD
• RESUME ROUTINE LOAD
• SHOW ROUTINE LOAD
• SHOW ROUTINE LOAD TASK
• STOP ROUTINE LOAD

Other load

• ALTER LOAD
• BROKER LOAD
• CANCEL LOAD
• INSERT
• SHOW LOAD
• SHOW TRANSACTION
• SPARK LOAD
• STREAM LOAD

Pipe

• ALTER PIPE
• CREATE PIPE
• DROP PIPE
• RETRY FILE
• SHOW PIPES
• SUSPEND or RESUME PIPE

Unloading

• CANCEL EXPORT
• EXPORT
• SHOW EXPORT

ETL task

• DROP TASK
• SUBMIT TASK

Catalog, database, resource

Catalog

• CREATE EXTERNAL CATALOG
• DROP CATALOG
• SET CATALOG
• SHOW CATALOGS
• SHOW CREATE CATALOG

Database

• ALTER DATABASE
• CREATE DATABASE
• DROP DATABASE
• SHOW CREATE DATABASE
• SHOW DATA
• SHOW DATABASES

Resource

• ALTER RESOURCE
• CREATE RESOURCE
• DROP RESOURCE
• SHOW RESOURCES

Table, partition, bucket, index

• 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 FULL COLUMNS
• SHOW INDEX
• SHOW PARTITIONS
• SHOW TABLES
• SHOW TABLET
• TRUNCATE TABLE
• UPDATE

View, materialized view

View

• ALTER VIEW
• CREATE VIEW
• DROP VIEW
• SHOW CREATE VIEW

Materialized view

• 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

Function

• CREATE FUNCTION
• DROP FUNCTION
• SHOW FUNCTIONS

CBO statistics

• ANALYZE TABLE
• CREATE ANALYZE
• DROP ANALYZE
• DROP STATS
• KILL ANALYZE
• SHOW ANALYZE JOB
• SHOW ANALYZE STATUS
• SHOW META

Backup and restore

• BACKUP
• CANCEL BACKUP
• CANCEL RESTORE
• CREATE REPOSITORY
• DROP REPOSITORY
• RECOVER
• RESTORE
• SHOW BACKUP
• SHOW REPOSITORIES
• SHOW RESTORE
• SHOW SNAPSHOT

Utility commands

• DESC
• USE