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 Database JSON Client API library or MapR Database Shell commands.

MapR Database JSON Client API

The MapR Database JSON Client API is a Java library. There is not a Python implementation of the library, but you can create and drop MapR Database JSON tables in the Python OJAI client.

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 Database 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 Database Shell (JSON Tables) for more information.