Lists the regions that make up a specified table.

Syntax

CLI

maprcli table region list
    -path <path>
    [ -start offset ]
    [ -limit number ]

REST

http[s]://<host>:<port>/rest/table/region/list?path=<path>&<parameters>

Parameters

Parameter

Description

path

Path to the table.

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

start

The offset from the starting region. The default value is 0.

limit

The number of regions to return, counting from the starting region. The default value is 2147483647.

Output fields

Verbose Field Name

Terse Field Name

Field Value

numberofrowsnrNumber of rows in the region
fidfidThe region's FID.

primarynode

pn

Host name of the primary node for this region

secondarynodes

sn

Host names of the secondary nodes where this region is replicated

numberofrowswithdeletenrdNumber of rows in the region, counting deleted rows

startkey

sk

Value of the start key for this region

endkey

ek

Value of the end key for this region

lastheartbeat

lhb

Time since last heartbeat from the region's primary node

logicalsize

ls

Logical size of the region

physicalsize

ps

Physical size of the region

 

Examples

Lists the region information for a table

This example lists the region information for the table newtable.

CLI

maprcli table region list -path /my.cluster.com/volume1/newtable 

REST

https://r1n1.sj.us:8443/rest/table/region/list?path=%2Fmy.cluster.com%2Fvolume1%2Fnewtable

Example Output

[user@node]# maprcli table region list -path /mapr/default/user/user/newtable 
fid             sk         sn  nr  ls  ek        pn        nrd  ps  lhb
2119.32.131282  -INFINITY      0   0   INFINITY  myhost01  0    0   0