table info

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

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

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