.alter table merge policy

Change a table's merge policy. The merge policy defines if and how Extents (Data Shards) in the cluster should get merged.

Syntax

.alter table TableName policy merge PolicyObject

Arguments

  • TableName - Specify the name of the table.
  • PolicyObject - Define a policy object, see also merge policy.

Example

.alter table [table_name] policy merge ```
{
  "RowCountUpperBoundForMerge": 16000000,
  "OriginalSizeMBUpperBoundForMerge": 0,
  "MaxExtentsToMerge": 100,
  "LoopPeriod": "01:00:00",
  "MaxRangeInHours": 24,
  "AllowRebuild": true,
  "AllowMerge": true,
  "Lookback": {
    "Kind": "Default"
  }
}```