.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"
  }
}```