.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