Viewing Table Information

About this task

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-DB 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 permissions on the table
NOTE: The logical and physical sizes of the table are estimated values.

Displaying Table Information Using MCS

About this task

To view table information using MCS:

Procedure

  1. Search and retrieve the table either by volume or by table path.
    For information on retrieving, see:
  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

About this task

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
    NOTE: You cannot use the following characters in the table name: 
     < > ? % \
    To use the following characters in the table name, enclose them either in single or double quotes: 
    ; | ( ) /
    For example: 
    maprcli table create -path "/設備^=#;{}&()/"  (or)
maprcli table create -path '/設備^=#;{}&()/'
    To use either the ' or the " character in the table name, enclose:
    • the ' character within double quotes (")
    • the " character within single quote (')
    For example:
    maprcli table create -path "/'設備^=#;{}&()/"  (or)
maprcli table create -path '/"設備^=#;{}&()/'
The json parameter displays the output as a JSON document.