SQL commands
Overview of the SQL commands supported by RisingWave.
ALTER CONNECTION
Modify the properties of a connection.
ALTER DATABASE
Modify the properties of a database.
ALTER FUNCTION
Modify the properties of a function.
ALTER INDEX
Modify the properties of an index.
ALTER MATERIALIZED VIEW
Modify the properties of a materialized view.
ALTER SCHEMA
Modify the properties of a schema.
ALTER SINK
Modify the properties of a sink.
ALTER SOURCE
Modify the properties of a source.
ALTER SUBSCRIPTION
Modify the properties of a subscription.
ALTER SWAP
Modify the names between two database objects.
ALTER SYSTEM
Modify a server configuration parameter.
ALTER TABLE
Modify the properties of a table.
ALTER USER
Modify the properties of a user.
ALTER VIEW
Modify the properties of a view.
AS CHANGELOG
Convert stream into an append-only changelog.
BEGIN
Start a transaction.
CANCEL JOBS
Cancel specific streaming jobs.
COMMENT ON
Add comments on tables or columns.
COMMIT
Commit the current transaction.
CREATE AGGREGATE
Create a user-defined aggregate function.
CREATE CONNECTION
Create a connection between VPCs.
CREATE DATABASE
Create a new database.
CREATE FUNCTION
Create a user-defined function.
CREATE INDEX
Create an index on a column of a table or a materialized view to speed up data retrieval.
CREATE MATERIALIZED VIEW
Create a materialized view.
CREATE SCHEMA
Create a new schema.
CREATE SECRET
Create a secret to store credentials.
CREATE SINK INTO
Create a sink into RisingWave’s table.
CREATE SINK
Create a sink.
CREATE SOURCE
Supported data sources and how to connect RisingWave to the sources.
CREATE TABLE
Create a table.
CREATE USER
Create a new user account.
CREATE VIEW
Create a non-materialized view.
DELETE
Remove rows from a table.
DESCRIBE
Get information about the columns in a table, source, sink, view, or materialized view.
DISCARD
Discard session state.
DROP AGGREGATE
Drop a user-defined aggregate function.
DROP CONNECTION
Remove a connection.
DROP DATABASE
Remove a database.
DROP FUNCTION
Drop a user-defined function.
DROP INDEX
Remove an index.
DROP MATERIALIZED VIEW
Remove a materialized view.
DROP SCHEMA
Remove a schema.
DROP SECRET
Drop a secret.
DROP SINK
Remove a sink.
DROP SOURCE
Remove a source.
DROP TABLE
Remove a table.
DROP USER
Remove a user.
DROP VIEW
Drop a view.
EXPLAIN
Show the execution plan of a statement.
EXPLAIN ANALYZE
Analyze the actual runtime performance of a streaming job.
FLUSH
Commit pending data changes and persist updated data to storage.
GRANT
Grant a user privileges.
INSERT
Insert new rows of data into a table.
RECOVER
Trigger recovery manually.
REVOKE
Revoke privileges from a user.
SELECT
Retrieve data from a table or a materialized view.
SET BACKGROUND_DDL
Run Data Definition Language (DDL) operations in the background.
SET RW_IMPLICIT_FLUSH
Enable or disable implicit flushes after batch operations.
SET TIME ZONE
Set time zone.
SET
Change a run-time parameter.
SHOW CLUSTER
Show the details of your RisingWave cluster.
SHOW COLUMNS
Show columns in a table, source, sink, view or materialized view.
SHOW CONNECTIONS
Show existing connections.
SHOW CREATE INDEX
Show the query used to create the specified index.
SHOW CREATE MATERIALIZED VIEW
Show the query used to create the specified materialized view.
SHOW CREATE SINK
Show the query used to create the specified sink.
SHOW CREATE SOURCE
Show the query used to create the specified source.
SHOW CREATE TABLE
Show the query used to create the specified table.
SHOW CREATE VIEW
Show the query used to create the specified view.
SHOW CURSORS
Show all cursors in the current session.
SHOW DATABASES
Show existing databases.
SHOW FUNCTIONS
Show all user-defined functions.
SHOW INDEXES
Show existing indexes from a particular table.
SHOW INTERNAL TABLES
Show internal tables to learn about the existing internal states.
SHOW JOBS
Show all streaming jobs.
SHOW MATERIALIZED VIEWS
Show existing materialized views.
SHOW PARAMETERS
Show the details of the system parameters.
SHOW PROCESSLIST
Display system current workload.
SHOW SCHEMAS
Show existing schemas.
SHOW SINKS
Shows all sinks.
SHOW SOURCES
Show existing sources.
SHOW SUBSCRIPTION CURSORS
Show all subscription cursors in the current session.
SHOW TABLES
Show existing tables.
SHOW VIEWS
Show existing views.
START TRANSACTION
Start a transaction.
UPDATE
Modify existing rows in a table.
SQL commands
Overview of the SQL commands supported by RisingWave.
ALTER CONNECTION
Modify the properties of a connection.
ALTER DATABASE
Modify the properties of a database.
ALTER FUNCTION
Modify the properties of a function.
ALTER INDEX
Modify the properties of an index.
ALTER MATERIALIZED VIEW
Modify the properties of a materialized view.
ALTER SCHEMA
Modify the properties of a schema.
ALTER SINK
Modify the properties of a sink.
ALTER SOURCE
Modify the properties of a source.
ALTER SUBSCRIPTION
Modify the properties of a subscription.
ALTER SWAP
Modify the names between two database objects.
ALTER SYSTEM
Modify a server configuration parameter.
ALTER TABLE
Modify the properties of a table.
ALTER USER
Modify the properties of a user.
ALTER VIEW
Modify the properties of a view.
AS CHANGELOG
Convert stream into an append-only changelog.
BEGIN
Start a transaction.
CANCEL JOBS
Cancel specific streaming jobs.
COMMENT ON
Add comments on tables or columns.
COMMIT
Commit the current transaction.
CREATE AGGREGATE
Create a user-defined aggregate function.
CREATE CONNECTION
Create a connection between VPCs.
CREATE DATABASE
Create a new database.
CREATE FUNCTION
Create a user-defined function.
CREATE INDEX
Create an index on a column of a table or a materialized view to speed up data retrieval.
CREATE MATERIALIZED VIEW
Create a materialized view.
CREATE SCHEMA
Create a new schema.
CREATE SECRET
Create a secret to store credentials.
CREATE SINK INTO
Create a sink into RisingWave’s table.
CREATE SINK
Create a sink.
CREATE SOURCE
Supported data sources and how to connect RisingWave to the sources.
CREATE TABLE
Create a table.
CREATE USER
Create a new user account.
CREATE VIEW
Create a non-materialized view.
DELETE
Remove rows from a table.
DESCRIBE
Get information about the columns in a table, source, sink, view, or materialized view.
DISCARD
Discard session state.
DROP AGGREGATE
Drop a user-defined aggregate function.
DROP CONNECTION
Remove a connection.
DROP DATABASE
Remove a database.
DROP FUNCTION
Drop a user-defined function.
DROP INDEX
Remove an index.
DROP MATERIALIZED VIEW
Remove a materialized view.
DROP SCHEMA
Remove a schema.
DROP SECRET
Drop a secret.
DROP SINK
Remove a sink.
DROP SOURCE
Remove a source.
DROP TABLE
Remove a table.
DROP USER
Remove a user.
DROP VIEW
Drop a view.
EXPLAIN
Show the execution plan of a statement.
EXPLAIN ANALYZE
Analyze the actual runtime performance of a streaming job.
FLUSH
Commit pending data changes and persist updated data to storage.
GRANT
Grant a user privileges.
INSERT
Insert new rows of data into a table.
RECOVER
Trigger recovery manually.
REVOKE
Revoke privileges from a user.
SELECT
Retrieve data from a table or a materialized view.
SET BACKGROUND_DDL
Run Data Definition Language (DDL) operations in the background.
SET RW_IMPLICIT_FLUSH
Enable or disable implicit flushes after batch operations.
SET TIME ZONE
Set time zone.
SET
Change a run-time parameter.
SHOW CLUSTER
Show the details of your RisingWave cluster.
SHOW COLUMNS
Show columns in a table, source, sink, view or materialized view.
SHOW CONNECTIONS
Show existing connections.
SHOW CREATE INDEX
Show the query used to create the specified index.
SHOW CREATE MATERIALIZED VIEW
Show the query used to create the specified materialized view.
SHOW CREATE SINK
Show the query used to create the specified sink.
SHOW CREATE SOURCE
Show the query used to create the specified source.
SHOW CREATE TABLE
Show the query used to create the specified table.
SHOW CREATE VIEW
Show the query used to create the specified view.
SHOW CURSORS
Show all cursors in the current session.
SHOW DATABASES
Show existing databases.
SHOW FUNCTIONS
Show all user-defined functions.
SHOW INDEXES
Show existing indexes from a particular table.
SHOW INTERNAL TABLES
Show internal tables to learn about the existing internal states.
SHOW JOBS
Show all streaming jobs.
SHOW MATERIALIZED VIEWS
Show existing materialized views.
SHOW PARAMETERS
Show the details of the system parameters.
SHOW PROCESSLIST
Display system current workload.
SHOW SCHEMAS
Show existing schemas.
SHOW SINKS
Shows all sinks.
SHOW SOURCES
Show existing sources.
SHOW SUBSCRIPTION CURSORS
Show all subscription cursors in the current session.
SHOW TABLES
Show existing tables.
SHOW VIEWS
Show existing views.
START TRANSACTION
Start a transaction.
UPDATE
Modify existing rows in a table.