Finding Table Type

This section shows how to find out whether a table is a binary or JSON table via maprcli or MCS.Use a maprcli command or MCS to find out whether a table is a binary or JSON table.

maprcli command

Run the command maprcli table info -path <path> -json .

  • For a path on the local cluster, start the path at the volume mount point. For example, for a table named test under a volume with a mount point at /volume1, specify the following path: /volume1/test
  • For a path on a remote cluster, you must also specify the cluster name in the path. For example, for a table named customer under volume1 in the sanfrancisco cluster, specify the following path:/mapr/sanfrancisco/volume1/customer
The json parameter displays the output as a JSON document.

In the output, look for the line "tabletype":value . Possible values are binary and json.

MCS

  1. Open the table.
  2. Select View Table Properties.

    Figure: Where to find out whether a table is a binary or JSON table