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.
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. 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
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
-
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 -k -X POST \ 'https://myhost:8443/rest/table/region/merge?path=%2Fuser%2Ftest5&fid=2086.32.131296' \ -u mapr:mapr