Listing Secondary Indexes
Describes how to list information about the secondary indexes created on HPE Ezmeral Data Fabric Database JSON tables.
About this task
You can view secondary indexes using the Control System or the maprcli table
index
commands. You need the following permissions.
readAce
on the volumelookupdir
on 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 Control System
Procedure
Log in to the Control System 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 |
What to do next
Listing Indexes Using the CLI
About this task
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.