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 HPE Ezmeral Data Fabric Database JSON Client API library or HPE Ezmeral Data Fabric Database Shell commands.

HPE Ezmeral Data Fabric Database JSON Client API

The HPE Ezmeral Data Fabric Database JSON Client API is a Java library. There is not a Python implementation of the library, but you can create and drop HPE Ezmeral Data Fabric 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.

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