Managing JSON Tables

This section describes how to create, list, and delete JSON tables, alter JSON table attributes, set permissions, and manage column families. You can perform these operations using either the MapR-DB JSON Client API library or MapR-DB Shell commands.

MapR-DB JSON Client API

Admin API

Use the methods in this interface to perform these tasks:

  • Create JSON tables
  • Alter JSON tables
  • Delete JSON tables
  • List JSON tables in a folder
  • See if a JSON table exists

For a full list of methods, see the MapR Admin interface

TableDescriptor API

Use the methods in this interface to perform these tasks:

  • Create tables with non-default values for one or more of their parameters
  • Alter tables

For a full list of interfaces and methods, see the MapR TableDescriptor interface.

MapR-DB Shell

The mapr dbshell is a tool for the creation and lightweight manipulation of JSON tables and documents. To run dbshell, enter mapr dbshell on the command line after logging into a node in a MapR cluster. See MapR-DB Shell (JSON Tables) for more information.