Listing Secondary Indexes
Describes how to list information about the secondary indexes created on MapR-DB JSON tables.
About this task
You can view secondary indexes using the MapR Control System (MCS) or the maprcli
table index
commands. You need the following permissions.
readAce
on the volumelookupdir
on directories in the table path
Listing Indexes in the MapR Control System
Procedure
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
maprcli table index list
-path <path>
-refreshnow < true | false >
See table index list
for more
information.