Editing Tables
Explains how to edit binary and JSON tables using either the Control System, the CLI, or the REST API.
You can use the Control System, the CLI, or the REST API to edit the attributes of a HPE Ezmeral Data Fabric Database binary or JSON table. You can also use the HBase shell to edit a binary table. To edit a table, you must have the following permissions:
readAce
andwriteAce
on the volumelookupdir
on directories in the pathadminaccessperm
on the table
Editing Tables Using the Control System
- Go to the table information page.
- Click Edit Table to display the Edit Table page.
-
Make changes to the following Properties, where
necessary:
Metrics Interval The interval of time for logging metrics. Auto Split Enable (Yes) or disable (No) auto-splitting of table. If enabled, the table will be split automatically into regions as the table grows. If disabled, the table can be split manually into regions. By default, this is enabled. Bulkload Enable (Yes) or disable (No) full bulk load of the table. -
Make changes to the following Security settings,
where necessary:
-
Make changes as needed to Table Administration
Control settings.
Modify the list of users, groups, and/or roles that have and/or do not have the following types of administration permissions on the table:To:
Admin Can view and edit the permissions for the table. Index Can create an index for the table. Force Pack Can pack table regions. Split Merge Can take the following actions: - Split the table into regions or merge regions of the table together.
- Change the size of the region.
Bulkload Can load this table with bulk loads if the table was created with bulk load support. Replication Access Can set up replication either to or from a table. Create/Rename Column Family Can create column families for this table or rename existing column families. Delete Column Family Can delete column families associated with the table. Admin Can view and edit the permissions for the table. Force Pack Can pack table regions. Split Merge Can take the following actions: - Split the table into regions or merge regions of the table together.
- Change the size of the region.
Bulkload Can load this table with bulk loads if the table was created with bulk load support. Replication Access Can set up replication either to or from a table. Create/Rename Column Family Can create column families for this table or rename existing column families. Delete Column Family Can delete column families associated with the table. - Grant access to a new user, group, or role, click Add Another, select entity Type, enter entity Name, and select the permissions to grant the entity.
- Create a copy of an existing entity settings, which you can then
modify, click
.
- Delete permissions for an entity, click
.
- Click Save Changes for the changes to take effect.
Editing Tables Using the CLI or the REST API
maprcli table edit -path <path>
curl -k -X POST 'https://<hostname>:8443/rest/table/edit?path=<path>' --user <username>:<pwd>
- For a path on the local cluster, start the path at the volume mount point. For
example, for a table named
test
under a volume with a mount point at /volume1, specify the following path:/volume1/test
- For a path on a remote cluster, you must also specify the cluster name in the
path. For example, for a table named
customer
undervolume1
in thesanfrancisco
cluster, specify the following path:/mapr/sanfrancisco/volume1/customer
Note: You cannot use the following characters in the table name:To use the following characters in the table name, enclose them either in single or double quotes:< > ? % \
For example:; | ( ) /
maprcli table create -path "/設備^=#;{}&()/" (or) maprcli table create -path '/設備^=#;{}&()/'
To use either the ' or the " character in the table name, enclose:For example:- the ' character within double quotes (")
- the " character within single quote (')
maprcli table create -path "/'設備^=#;{}&()/" (or) maprcli table create -path '/"設備^=#;{}&()/'
When you edit a table, you can change a number of properties including:
- Enable or disable auditing, autosplitting, and bulkloading
- Set permissions on table
- Set permissions for default column families
For full reference for this command, see table edit
.
Editing Binary Tables Using HBase Shell
After starting the HBase shell, run the alter
command. Type
help
to see a list of commands and their syntax.