Viewing Table Information

You can view table information including table properties, column families, regions, replicas, upstream source, and indexes. Use either the maprcli command or MCS to display all of the information that MapR Database stores about a particular table including:

  • The path to the table
  • Whether a table is a binary or JSON table
  • The number of rows in the table
  • The logical size (in bytes) of the table
  • The physical size (in bytes) of the table
  • The maximum size (in bytes) of regions of the table
  • Whether auditing is enabled or not
  • Whether autosplitting is on or off
  • Whether the bulkload flag is set or not
  • The interval for logging metrics
  • The permissions on the table
Note: The logical and physical sizes of the table are estimated values.

Displaying Table Information Using MCS

To view table information using MCS:
  1. Search and retrieve the table either by volume or by table path.
  2. Click the name of the table to see the table details.
    The page displays the following tabs:You can:
    The Summary tab displays:
    • The active and recent alarms in the Active Alarms pane.
    • The table settings and permissions in the Detail pane.

Displaying Table Information Using CLI

Run the command maprcli table info -path <path> -json .

  • For a path on the local cluster, start the path at the volume mount point. For example, for a table named test under a volume with 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
The json parameter displays the output as a JSON document.