SQL statements like CREATE MATERIALIZED VIEW
, CREATE INDEX
, or CREATE SINK
might take a while to complete, because they may consume a lot of data. In RisingWave, you can view the progress of such a statement, and abort it if necessary.
CREATE MATERIALIZED VIEW
, CREATE INDEX
, or CREATE SINK
statement, run the following command:
progress
given here is just an estimate.
To abort a running CREATE MATERIALIZED VIEW
, CREATE INDEX
, or CREATE SINK
statement, press CTRL+C
(or Control+C
).
For example:
CANCEL JOBS
command will return IDs of the jobs that are canceled successfully.