Data Definition Language (DDL) commands, such as creating materialized views, will first backfill historical data from the referenced relations, and completion time varies based on the volume of data to be backfilled.
SET BACKGROUND_DDL
command to run DDL commands in the background.
BACKGROUND_DDL
is set as false
to disable it, meaning that DDL operations will execute in the foreground. The DDL commands will be blocking and only return until the backfill process is completed.BACKGROUND_DDL
is set to true
, any subsequent DDL operations will be executed in the background, allowing you to proceed with other tasks.background_ddl
mode, RisingWave treats them as created
because their downstreams immediately start receiving the backfill data. Therefore, SHOW JOBS
does not track their backfill progress.sink jobs
. These are immediately marked as completed, since their output will be immediately visible.
sink
and materialized views
. You can just call DROP SINK
or DROP MATERIALIZED VIEW
on the corresponding relation to cancel it.
ALTER SYSTEM SET max_concurrent_creating_streaming_jobs
command.
For example, you can set the maximum concurrent creating streaming jobs to 4: