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
    • FE, BE, CN, Broker, process
    • Resource group
    • Table, tablet, replica
    • File, index, variable
    • SQL Blacklist
    • Plugin
  • Loading, unloading
    • Routine load
    • Other load
    • Unloading
    • ETL task
  • Catalog, database, resource
    • Catalog
    • Database
    • Resource
  • Create table, partition
  • View, materialized view
    • View
    • Materialized view
  • Function, SELECT
  • 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 PASSWORD
• SET PROPERTY
• SHOW AUTHENTICATION
• SHOW GRANTS
• SHOW PROPERTY
• SHOW ROLES

Cluster management

Manages clusters, including FEs, BEs, compute nodes, brokers, resource groups, storage volumes, tables, tablets, replicas, files, indexes, variables, and plugins.

FE, BE, CN, Broker, process

• ADMIN SET CONFIG
• ADMIN SHOW CONFIG
• ALTER SYSTEM
• CANCEL DECOMMISSION
• KILL
• SHOW BACKENDS
• SHOW BROKER
• SHOW COMPUTE NODES
• SHOW FRONTENDS
• SHOW PROC
• SHOW PROCESSLIST

Resource group

• CREATE RESOURCE GROUP
• ALTER RESOURCE GROUP
• DROP RESOURCE GROUP
• SHOW RESOURCE GROUP

Table, tablet, replica

• ADMIN CANCEL REPAIR TABLE
• ADMIN CHECK TABLET
• ADMIN REPAIR TABLE
• ADMIN SET REPLICA STATUS
• ADMIN SHOW REPLICA DISTRIBUTION
• ADMIN SHOW REPLICA STATUS
• RECOVER
• SHOW TABLE STATUS

File, index, variable

• CREATE FILE
• CREATE INDEX
• DROP FILE
• DROP INDEX
• SET (variable)
• SHOW FILE
• SHOW FULL COLUMNS
• SHOW INDEX
• SHOW VARIABLES

SQL Blacklist

• ADD SQLBLACKLIST
• SHOW SQLBLACKLIST
• DELETE SQLBLACKLIST

Plugin

• INSTALL PLUGIN
• SHOW PLUGINS
• UNINSTALL PLUGIN

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

Unloading

• EXPORT
• CANCEL EXPORT
• SHOW EXPORT

ETL task

• SUBMIT TASK
• DROP TASK

Catalog, database, resource

Catalog

• CREATE EXTERNAL CATALOG
• DROP 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

Create table, partition

• ALTER TABLE
• CANCEL ALTER TABLE
• CREATE TABLE
• CREATE TABLE AS SELECT
• CREATE TABLE LIKE
• DROP TABLE
• REFRESH EXTERNAL TABLE
• TRUNCATE TABLE
• DELETE
• SHOW ALTER TABLE
• SHOW CREATE TABLE
• SHOW DELETE
• SHOW DYNAMIC PARTITION TABLES
• SHOW PARTITIONS
• SHOW TABLES
• SHOW TABLET
• UPDATE

View, materialized view

View

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

Materialized view

• ALTER MATERIALIZED VIEW
• CREATE MATERIALIZED VIEW
• DROP MATERIALIZED VIEW
• CANCEL REFRESH MATERIALIZED VIEW
• REFRESH MATERIALIZED VIEW
• SHOW ALTER MATERIALIZED VIEW
• SHOW CREATE MATERIALIZED VIEW
• SHOW MATERIALIZED VIEWS

Function, SELECT

• CREATE FUNCTION
• DROP FUNCTION
• SHOW FUNCTION
• SELECT

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
• EXPLAIN
• USE