Removing Secondary Indexes on JSON Tables
Describes how to remove secondary indexes that are no longer needed.
About this task
You can remove 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 pathindexperm
permission on the table, if you did not create the table
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.Removing Indexes Using the Control System
Procedure
- Log in to the Control System and go to the Indexes tab in the table information page.
-
Select the indexes to remove and click Remove Index.
The Remove Index confirmation window displays.
- Review the index(es) to remove and click Remove Index.
Removing Indexes Using the CLI
About this task
The following is the basic command for removing a secondary index on a JSON table.
maprcli table index remove
-path <path>
-index <index name>
See
table index remove
for more information.