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:
readAce
andwriteAce
on the volumelookupdir
on directories in the pathsplitmergeperm
permission on the table
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
|
path |
The path to the table whose regions are being merged.
|
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>