table info

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

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"
		}
	]
}