Listing Secondary Indexes
Describes how to list information about the secondary indexes created on HPE Ezmeral Data Fabric Database JSON tables.
You can view secondary indexes using the MapR Control System (MCS) or the maprcli
table index commands. You need the following permissions.
readAceon the volumelookupdiron directories in the table path
Note: The mapr user is not treated as a superuser. HPE Ezmeral Data Fabric Database does not allow the mapr user to
perform this operation unless that user is given the relevant permission or permissions with
access-control expressions.
Listing Indexes in the MapR Control System
Log in to MCS and go to the Indexes tab in the table information
page.
The list of indexes displays in the All indexes pane and for
each index, the page displays the following:
| Column Name | Column Description |
|---|---|
| Index Name | The name of the index |
| Fields Indexed | The number of fields on the JSON table that are indexed and used for ordering |
| Fields Covered | The number of fields on the JSON table that are indexed, but not used for ordering |
| State | The replication state of the index |
| Up to Date | Whether the index is up to date |
| Hashed | Whether the index is hashed |
| Size | The size of the index |
Listing Indexes Using the CLI
The following is basic command for listing secondary indexes.
maprcli table index list
-path <path>
-refreshnow < true | false > See table index list for more
information.