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.

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

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.

When you log in to the MapR Control System and click Data > Table, the Tables page displays the following in the various panes:

Top Table Operations by Nodes — The nodes that had the most number of table operations (gets, puts, and scans)
Active Alarms — The active table (replication) alarms
Recently Viewed Tables — The tables that were most recently accessed from MCS
List of volumes that you have access to and a search field to retrieve a table by table path

Click Create Table button to create a new binary or JSON table. For a conceptual overview of:

Binary tables, see MapR-DB Binary Tables.
JSON tables, which contain JSON documents, see MapR-DB JSON Tables.