SHOW ALTER TABLE MATERIALIZED VIEW

Description

Check the status of the synchronized materialized view build task.

Since creating a synchronized materialized view is an asynchronous operation, after submitting the materialized view creation task, users need to asynchronously check the status of the synchronized materialized view build through a command.

Syntax

SHOW ALTER TABLE MATERIALIZED VIEW FROM <database>

Required Parameters

1. <database>

The database to which the base table of the synchronized materialized view belongs.

Permissions

The user executing this SQL command must have at least the following permissions:

Privilege	Object	Notes
ALTER_PRIV	Table	Requires ALTER_PRIV permission on the table to which the current materialized view belongs

Example

SHOW ALTER TABLE MATERIALIZED VIEW FROM doc_db;