Developing Applications for JSON Tables

As part of its support for JSON tables, MapR-DB implements the OJAI API. The OJAI API provides methods for creating, reading, updating, and deleting JSON documents in MapR-DB JSON tables. It is available in Java. MapR-DB also provides a MapR-DB JSON Client API for managing JSON tables and a MapR-DB JSON REST API for performing basic operations using HTTP calls.

The following shows the general flow for developing an OJAI client application that accesses MapR-DB JSON tables:

  1. Make a connection to MapR-DB using the OJAI Connection and Driver interfaces
  2. Request a MapR-DB JSON table using the JSON DocumentStore
  3. Specify the table, document, or column family operation
  4. Perform the operation on the table
  5. Return the results

For additional information about OJAI, refer to the following:

The MapR-DB JSON Client API, implemented in Java, enables you to create, drop, and alter MapR-DB JSON tables and column families.

You can also use HTTP calls to create, delete, and query MapR-DB JSON tables Using the MapR-DB JSON REST API.

API Documentation

The following are links to the detailed API pages:

  • Java OJAI Client API
  • MapR-DB JSON Client API
    NOTE: Beginning with MapR version 6.0, the MapR-DB Table interface in the MapR-DB JSON Client API is deprecated and replaced by the DocumentStore interface in the OJAI API.