DROP MATERIALIZED VIEW

    1. IF EXISTS If the materialized view does not exist, doris will not throw an error. If this keyword is not declared, an error will be reported if the materialized view does not exist. Ranch

    2. mv_name The name of the materialized view to be deleted. Required.

    3. Table_name Name of the table to which the materialized view to be deleted belongs. Required.

    +————————+———-+—————+———+———-+————-+———-+ | IndexName | Field | Type | Null | Key | Default | Extra | +————————+———-+—————+———+———-+————-+———-+ | all_type_table | k1 | TINYINT | Yes | true | N/A | | | | k2 | SMALLINT | Yes | false | N/A | NONE | | | k3 | INT | Yes | false | N/A | NONE | | | k4 | BIGINT | Yes | false | N/A | NONE | | | k5 | LARGEINT | Yes | false | N/A | NONE | | | k6 | FLOAT | Yes | false | N/A | NONE | | | k7 | DOUBLE | Yes | false | N/A | NONE | +————————+———-+—————+———+———-+————-+———-+ ```

    ERROR 1064 (HY000): errCode = 2, detailMessage = Materialized view [k1_k2] does not exist in table [all_type_table] ```

    1. Delete the materialized view k1_k2 in the table all_type_table. Materialized view does not exist and no error is reported.

    Query OK, 0 rows affected (0.00 sec) ```