SHOW JOBS

In RisingWave, a streaming job refers to the creation of a materialized view, an index, a table, a sink or a source with connectors. If a streaming job takes too long, you can use the CANCEL JOBS to cancel it.

Syntax

SHOW JOBS [ LIKE_expression ];

Parameters

Parameter	Description
LIKE_expression	Filters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions.

Example

SHOW JOBS;
------RESULT
  Id  |                     Statement                     | Progress
------+---------------------------------------------------+----------
 1010 | CREATE MATERIALIZED VIEW mv3 AS SELECT *FROM mv1  | 2.21%
 1012 | CREATE MATERIALIZED VIEW mv2 AS SELECT* FROM mv1  | 0.86%

SQL reference

Python SDK

User-defined functions

Syntax

Parameters

Example

Monitor statement progress

CANCEL JOBS

​Syntax

​Parameters

​Example

​Related topics

Monitor statement progress

CANCEL JOBS

Syntax

Parameters

Example

Related topics