table region merge

Merges regions of a table together to reduce the number of regions that a table occupies.

This command merges the region that you specify with the region that contains the row keys that immediately follow the row keys of the specified region.

Users must have the splitmergeperm permission on this table to merge table regions.

NOTE: Consider the table configuration when you decided to merge regions because it is possible that MapR-DB might immediately split the regions after they are merged. If autosplit is set to true, MapR-DB splits a region when the size of the region exceeds 150% of the average value (regionsizemb). For example, if the average value is 4096 MB, MapR-DB splits a region that is larger than 6144 MB.
NOTE: The mapr user is not treated as a superuser. MapR-DB does not allow the mapr user to run this command unless that user is given the relevant permission or permissions with access-control expressions.

Syntax

CLI 
maprcli table region merge
    -fid <regionFID>    -path <table path>
REST 
http[s]://<host>:<port>/rest/table/region/merge?fid=<region FID>&path=<path>

Parameters

Parameter

Description

fid

The FID for the table region that you want to merge. The output of maprcli table region list lists the FIDs for the table.
path

The path to the table whose regions are being merged.

  • For a path on the local cluster, start the path at the volume mount point. For example, if you want to merge regions for table named test under volume1 which has a mount point at /volume1, specify the following path: /volume1/test
  • For a path on a remote, you must also specify the cluster name in the path. For example, if you want to merge regions for table named test under volume1 in the sanfrancisco cluster, specify the following path:/mapr/sanfrancisco/volume1/customer