search

StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
https://starrocks.io
Apache License 2.0
9.06k stars 1.82k forks source link

[Feature] support drop materialized view force #52472

Open wangsimo0 opened 3 weeks ago

wangsimo0 commented 3 weeks ago

There is a FORCE mode in drop table. https://docs.starrocks.io/docs/sql-reference/sql-statements/table_bucket_part_index/DROP_TABLE/, which drop the table directly and cannot be recovered. However, this is not supported in materialized view.

Grammar

DROP MATERIALIZED VIEW [IF EXISTS] [database.]mv_name [FORCE]

Drops the materialized view directly and cannot be recovered.

crossoverJie commented 3 weeks ago

I am interested in this feature, please assign it to me @wangsimo0 @LiShuMing