.show materialized view partitioning policy

Displays a materialized view partitioning policy. The partitioning policy defines if and how extents (data shards) should be partitioned for a specific table or a materialized view.

Syntax

.show materialized-view MaterializedViewName policy partitioning

Arguments

MaterializedViewName - Specify the name of the materialized view.

Returns

Returns a JSON representation of the policy.

Example

Delete the policy at the materialized view level:

.show materialized-view MyMaterializeView policy partitioning