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 volume
lookupdir on directories in the table path
indexperm 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 -k -X POST \
  'https://r1n1.sj.us:8443/rest/table/index/remove?path=%2Fmy.cluster.com%2Fvolume1%2Fnewtable&index=testIndex' \
  -u mapr:mapr