table info

Displays information about a MapR-DB binary or JSON table.

Permissions Required

To run this command, your user ID must have the following permissions:
  • readAce on the volume
  • lookupdir on directories in the path
  • adminaccessperm on the table
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 info
    -path <path>
REST
http[s]://<host>:<port>/rest/table/info?path=<path>
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.

Parameters

Parameter Description
path

The path to the table.

  • For a path on the local cluster, start the path at the volume mount point. For example, 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, for a table named customer under volume1 in the sanfrancisco cluster, specify the following path:/mapr/sanfrancisco/volume1/customer
json This command returns multiple levels of data. You must specify to display the output either in JSON or the "long" format to see the full set of information.
long

Examples

Lists the information for a table named mytable in the "long" format:
CLI

maprcli table info -path /mapr/my.cluster.com/volume1/mytable -long

REST

https://r1n1.sj.us:8443/rest/table/info?path=%2Fmapr%2Fmy.cluster.com%2Fvolume1%2Fmytable&long

Output Sample

# maprcli table info -path /mydirectory/mytable -json
{
	"timestamp":1444671479053,
	"timeofday":"2015-10-12 10:37:59.053 GMT-0700",
	"status":"OK",
	"total":1,
	"data":[
		{
		"path":"/mydirectory/mytable",
		"numregions":1,
		"totallogicalsize":0,
		"totalphysicalsize":0,
		"totalcopypendingsize":0,
		"totalrows":0,
		"totalnumberofspills":0,
		"totalnumberofsegments":0,
		"autosplit":true,
		"bulkload":false,
		"insertionorder":true,
		"tabletype":"json",
		"regionsizemb":4096,
		"audit":false,
		"maxvalueszinmemindex":100,
		"adminaccessperm":"u:root",
		"createrenamefamilyperm":"u:root",
		"bulkloadperm":"u:root",
		"packperm":"u:root",
		"deletefamilyperm":"u:root",
		"replperm":"u:root",
		"splitmergeperm":"u:root",
		"defaultappendperm":"u:root",
		"defaultcompressionperm":"u:root",
		"defaultmemoryperm":"u:root",
		"defaultreadperm":"u:root",
		"defaulttraverseperm":"u:root",
		"defaultversionperm":"u:root",
		"defaultwriteperm":"u:root",
             "uuid":"3b4ef43c-83d4-06eb-99ba-08c8ef1b5600"
		}
	]
}