Home
6.0 Administration
This section describes how to manage the nodes and services that make up a cluster.
Administering Tables
Administration of the MapR-DB is done primarily via the command line (maprcli) or with the MapR Control System (MCS). Regardless of whether the MapR-DB table is used for binary files or JSON documents, the same types of commands are used with slightly different parameter options. MapR-DB administration is associated with tables, columns and column families, and table regions.
Managing Tables
MapR-DB supports two types of table: binary tables and JSON tables. This section covers how to create, edit, and delete tables, as well as how to set parameter values, display parameter values, grant permissions and access, replicate tables, and more using the MapR Control System and the CLI.
Viewing the List of Tables

MapR 6.0 Documentation

6.0 Administration
This section describes how to manage the nodes and services that make up a cluster.
- Administering Users and Clusters
- Administering Nodes
- Administering Volumes
  This section provide information about how to organize and manage data using volumes, a unique feature of MapR clusters.
- Administering Files and Directories
- Administering Tables
  Administration of the MapR-DB is done primarily via the command line (maprcli) or with the MapR Control System (MCS). Regardless of whether the MapR-DB table is used for binary files or JSON documents, the same types of commands are used with slightly different parameter options. MapR-DB administration is associated with tables, columns and column families, and table regions.
  - Managing Tables
    MapR-DB supports two types of table: binary tables and JSON tables. This section covers how to create, edit, and delete tables, as well as how to set parameter values, display parameter values, grant permissions and access, replicate tables, and more using the MapR Control System and the CLI.
    - Creating a New Table
    - Configuring Maximum Row Sizes Using the CLI
      The default maximum row size at installation is 32MB. You can configure this maximum by changing the value of the mfs.db.max.rowsize.kb parameter with the maprcli config save command.
    - Editing Tables
    - Removing a Table
    - Defining ACEs
    - Permission Types for Fields and Column Families in JSON Tables
      By using access-control expressions (ACEs), you can grant or deny access to fields and column families that are in JSON tables.
    - Viewing the List of Tables
    - Viewing Table Information
    - Viewing Table Regions
    - Loading Documents into JSON Tables
      There are three command-line utilities for loading documents into JSON tables: mapr copytable, mapr importtable (which works in conjunction with the mapr exporttable utility), and mapr importJSON
    - Accessing MapR-DB Binary Tables Using HBase APIs
      This section discusses how to access MapR-DB binary tables via HBase APIs, HBase Shell, and MapReduce applications.
    - Loading Data into Binary Tables
      Bulkload operations can be performed as a full bulkload or as an incremental bulkload.
    - Performing Filesystem Operations on MapR-DB Tables
  - Managing Column Families and Columns
    This section covers overviews of column families in binary tables and JSON tables, how to create column families, alter them, delete them, set permissions on them, and set and display parameter values.
  - Managing Table Replication
    This section contains topics about setting up table replication and administering existing replicas.
  - Managing Secondary Indexes
    Describes how to manage secondary indexes, including adding, deleting, and listing indexes, setting up your cluster for querying, and troubleshooting index usage.
  - Administering Change Data Capture
    This topic covers the MCS and maprcli tools for managing the Change Data Capture (CDC) feature.
  - Indexing MapR-DB Binary Tables with Elasticsearch
    As of with MapR 6.0, MapR-DB Elastic Search integration capability is deprecated and no longer available in the MapR-DB product.
- Administering Streams
- Administering MapR Gateways
  A MapR gateway mediates one-way communication between a source MapR cluster and a destination cluster. You can replicate MapR-DB tables (binary and JSON) and MapR-ES streams. MapR gateways also apply updates from JSON tables to their secondary indexes and propagate Change Data Capture (CDC) logs.
- Administering Services
- Monitoring the Cluster
  This section describes how to monitor the health and performance of a MapR cluster.
- Configuring Security
  Describes how to configure MapR security and manage secure clusters.
- Managing Secure Clusters
  Provides procedures that will enable you to use MapR clusters securely.
- Administering the MapR Data Access Gateway
  The MapR Data Access Gateway is a service that acts as a proxy and gateway for translating requests between lightweight client applications and the MapR cluster. This section describes considerations when upgrading the service, how to modify configuration settings, and how to administer and manage the service.
- Planning for High Availability
- Administrator's Reference
  This section contains in-depth reference information for the administrator.
- Troubleshooting Cluster Administration
- Best Practices for Backing Up MapR Information

Viewing the List of Tables

About this task

You can retrieve and view the list of tables using MCS and the CLI.

Viewing the Tables in a Volume Using the MapR Control System

Procedure

Log in to MCS and click Data > Tables to view all the volumes that you have access to.

For each volume, the pane displays the following:

Column Name	Column Description
Name	The name of the volume.
Type	The type. Value can be: — Volume — Directory — Table
Owner	The name of the owner.
Last Modified	The last modification date and timestamp.

Click on the name of the volume (to browse to the path to the table) or enter the name of the volume in the text field.
The tables in the selected volume display. If necessary, click the name of the directory to browse further or to return to All volumes view.

Viewing a Table by Table Path Using the MapR Control System

Procedure

Log in to MCS and click Data > Tables.
Enter the path to the table and click GO.
The tables information page for the specified table displays.

Listing the Tables in a Directory From the Command-line

Method for Binary Tables Only (HBase Shell)

About this task

After starting the HBase shell, run the list command. Include the directory path in the command if you want to list tables that are not in your home directory. Type help to see a list of commands and their syntax.

Method for JSON Tables Only (`mapr dbshell`)

About this task

After starting the shell, run the list command. Include the directory path in the command if you want to list tables that are not in your home directory. See MapR-DB Shell (JSON Tables).

Retrieving a Table by Table Path Using the CLI or the REST API

About this task

To retrieve table details for a table by specifying the table path from the CLI, run the following command:

maprcli table info -path <table-path>

For information on this command, see table info.