This command is used to view the execution of the Create Materialized View job submitted through the CREATE-MATERIALIZED-VIEW statement.

    • database: View jobs under the specified database. If not specified, the current database is used.
    • WHERE: You can filter the result column, currently only the following columns are supported:
      • TableName: Only equal value filtering is supported.
      • Createtime/FinishTime: Support =, >=, <=, >, <, !=
    • ORDER BY: The result set can be sorted by any column.
    • LIMIT: Use ORDER BY to perform page-turning query.

    Return result description:

    • JobId: Job unique ID.

    • TableName: base table name

    • CreateTime/FinishTime: Job creation time and end time.

    • RollupId: The unique ID of the materialized view.

    • State: job status.

      • PENDING: The job is in preparation.

      • WAITING_TXN:

        Before officially starting to generate materialized view data, it will wait for the current running import transaction on this table to complete. And the field is the current waiting transaction ID. When all previous imports for this ID are complete, the job will actually start.

      • FINISHED: The job ran successfully.

      • CANCELLED: The job failed to run.

    • Msg: error message

    • Progress: job progress. The progress here means completed tablets/total tablets. Materialized views are created at tablet granularity.

    1. View the materialized view jobs under the database example_db