Added ALTER TABLE PARTITION Support for MATERIALIZED VIEW

Why it matters

This feature allows users to modify partitions of materialized views directly using the ALTER TABLE ... PARTITION ... syntax. It addresses the limitation where such partition operations were previously unsupported on materialized views, improving management and flexibility of partitioned data in materialized views.

How to use it

Use the ALTER TABLE statement with the PARTITION clause on a materialized view just as you would on regular tables. For example:

ALTER TABLE <materialized_view_name> DROP PARTITION <partition_expr>;

This enables partition changes like dropping, attaching, or modifying partitions directly on materialized views.