table index remove
This topic describe how to remove secondary indexes that are no longer needed.
Permissions Required
To run
this command, your user ID must have 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 run this command
unless that user is given the relevant permission or permissions with access-control expressions.Syntax
- CLI
-
maprcli table index remove -path <path> -index <index name>
- REST
-
curl -k -X POST \ 'http[s]://<host>:<port>/rest/table/index/remove?path=<path>&index=<index name>' -u <username>:<password>
Parameters
Parameter |
Description |
---|---|
path |
(Required) Path to where the parent JSON table resides |
index |
(Required) Name of the index |
Example
- CLI
-
maprcli table index remove -path /my.cluster.com/volume1/newtable -index testIndex
- REST
-
curl -X POST \ 'https://r1n1.sj.us:8443/rest/table/index/remove?path=%2Fmy.cluster.com%2Fvolume1%2Fnewtable&index=testIndex' \ -u <username>:<password>