The mapr dbshell is a tool that enables you to create and perform basic manipulation of JSON tables and documents. You
run dbshell by typing mapr dbshell on the command line after logging into a node in a MapR cluster.

Before you start developing applications on MapR’s Converged Data Platform, consider how you will get the data onto the
platform, the format it will be stored in, the type of processing or modeling that is required, and how the data will
be accessed.

The mapr dbshell is a tool that enables you to create and perform basic manipulation of JSON tables and documents. You
run dbshell by typing mapr dbshell on the command line after logging into a node in a MapR cluster.

To query JSON documents in MapR Database shell, use either the find or findbyid command. The find command enables you to scan complete tables and retrieve rows that satisfy projection and/or condition clauses. The
findbyid command enables you to retrieve a single document with a given ID.

MapR supports public APIs for MapR Filesystem, MapR Database, and MapR Event Store For Apache Kafka. These APIs are available for application development purposes.

dbshell create

Describes how to use MapR Database shell to create a JSON table.

Description

To create JSON tables, run the create <table
path> command.

When you create a JSON table using mapr
dbshell, the default column family is created automatically. There are no commands
for creating additional column families. To create column families, exit the shell and use the
maprcli table cf create command.

Note: If you are using a 5.2.x dbshell client to connect to a 6.0 (or later) server, you
must set the insertionorder table option to false before creating your
table. The insertionorder option is not support as of 6.0. See the
following example:

tableoptions --insertionorder false

Run
tableoptions in dbshell to see the current setting of
insertionorder.

Parameters

create Options

Description

--t, --table<table path>

Table path

Although the --t and --table
qualifiers are optional, you must specify a <table
path>.

Syntax

create <table path>

Example

In the following example, data is the volume name and movies is the new
table name.