.alter materialized view merge policy
Change a materialized view's merge policy. The merge policy defines if and how Extents (Data Shards) in the cluster should get merged.
Syntax
.alter materialized-view MaterializedViewName policy merge PolicyObject
Arguments
MaterializedViewName - Specify the name of the materialized view. PolicyObject - Define a policy object. For more information, see merge policy.
Example
.alter materialized-view [materialized_view_name] policy merge ```
{
"RowCountUpperBoundForMerge": 16000000,
"OriginalSizeMBUpperBoundForMerge": 0,
"MaxExtentsToMerge": 100,
"LoopPeriod": "01:00:00",
"MaxRangeInHours": 24,
"AllowRebuild": true,
"AllowMerge": true,
"Lookback": {
"Kind": "Default"
}
}```