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.

NOTE
Consider the table configuration when you decide to merge regions because it is possible that HPE Ezmeral Data Fabric Database might immediately split the regions after they are merged. If autosplit is set to true, HPE Ezmeral Data Fabric Database 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, HPE Ezmeral Data Fabric Database splits a region that is larger than 6144 MB.

Permissions Required

To run this command, your user ID must have the following permissions:

NOTE
The mapr user is not treated as a superuser. HPE Ezmeral Data Fabric Database 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
curl -k -X POST 
  'http[s]://<host>:<port>/rest/table/region/merge?fid=<region FID>&path=<path>'
  -u <username>:<password>

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

Example

Merges the specified region:

CLI
maprcli table region merge -path /user/test5 -fid 2086.32.131296
REST
curl -X POST \
  'https://myhost:8443/rest/table/region/merge?path=%2Fuser%2Ftest5&fid=2086.32.131296' \
  -u <username>:<password>