table edit
Edits the attributes of a MapR-DB binary or JSON table.
- CLI
-
maprcli table edit -path path [ -audit true|false ] [ -autosplit Auto Split table ] [ -regionsizemb Region Size in MB ] [ -bulkload Bulk load ] [ -deletettl delete TTL in secs ] [ -packperm Pack Permission settings ] [ -bulkloadperm Bulk load Permission settings ] [ -splitmergeperm Split and Merge Permission settings] [ -createrenamefamilyperm Add/Rename Family Permission settings ] [ -deletefamilyperm Delete Family Permission settings ] [ -adminaccessperm Ace Admin Permission settings ] [ -replperm Replication Admin Permission settings ] [ -defaultversionperm CF Versions Default Permission ] [ -defaultcompressionperm CF Compression Default Permission ] [ -defaultmemoryperm CF Memory Default Permission ] [ -defaultreadperm CF Read Default Permission ] [ -defaultwriteperm CF Write Default Permission ] [ -defaulttraverseperm CF Traverse Default Permission ] [ -defaultappendperm CF Append Default Permission ]
- REST
-
http[s]://<host>:<port>/rest/table/edit?path=<path>
mapr
user is not treated as a superuser.
MapR-DB does not allow the mapr
user to run this command unless that user
is given the relevant permission or permissions with access-control expressions.
Parameter |
Description |
---|---|
path |
The path to the table.
|
audit | Specifies whether to turn auditing on for the table. If auditing is also
enabled at the cluster level with the maprcli audit data
command and enabled for the current volume, setting this value to true
causes auditing to start for the table. |
autosplit |
A Boolean value that specifies whether to split the table into regions
automatically as the table grows. The average size of each region is
determined by the The default value is |
regionsizemb |
The average size of the regions into which MapR-DB tries to split the
table as the table grows. The default is 4096 MB. This value is ignored
if If Although splits are automatic, merges are not. For example, if the value
of NOTE: When a table has less than 4 regions, MapR-DB ignores the
regionsizemb parameter and splits regions at a lower
threshold. |
bulkload |
A Boolean value that specifies whether to allow a full bulk
load of the table. The default is |
deletettl | The number of seconds to wait before purging the delete operations. The time-to-live for deletes should be greater than the amount of time that it takes replicated operations to reach replicas. By default, the value is 24 hours for tables configured for replication. If the table is not configured for replication, the default is 0 hours. |
packperm | The Access Control Expression that controls who can pack table regions. By default, permission is given to the user ID that was used to create the table. |
bulkloadperm | The Access Control Expression that controls who can load this table with bulk loads if the table was created with bulk load support. By default, permission is given to the user ID that was used to create the table. |
splitmergeperm |
The Access Control Expression that controls who can take the following actions:
By default, permission is given to the user ID that was used to create the table. |
createrenamefamilyperm | The Access Control Expression that controls who can create column families for this table or rename existing column families. By default, permission is given to the user ID that was used to create the table. |
deletefamilyperm | The Access Control Expression that defines access to delete column families for this table. Delimit the expression with single-quotation marks. By default, permission is given to the user ID that was used to create the table. |
adminaccessperm | The Access Control Expression that controls who can view and edit the permissions for this table. By default, permission is given to the user ID that was used to create the table. |
replperm | The Access Control Expression that controls who can set up replication either to or from a table. By default, permission is given to the user ID that is used to create the table. |
defaultversionperm |
The default Access Control Expression for the version permission on new
column families that are created in this table. If no value is specified,
the default is u:<username of the table creator> .
This value of the parameter versionperm in the
table cf create and table cf edit
commands overrides this value.NOTE: This permission is not applicable to JSON tables. Versioning is not supported for JSON
documents. |
defaultcompressionperm | Applies to binary tables only:
The default Access Control Expression for the compression permission on
new column families that are created in this table. If no value is
specified, the default is u:<username of the table
creator> . This value of the parameter
compressionperm in the table cf create
and table cf edit commands overrides this value. |
defaultmemoryperm |
The default Access Control Expression for the memory permission on new
column families that are created in this table. If no value is specified,
the default is |
defaultreadperm | The default Access Control Expression for the read permission on new
column families that are created in this table. If no value is specified,
the default is u:<username of the table creator> .
This value of the parameter readperm in the table
cf create and table cf edit commands overrides
this value.For more information about this permission as it applies to JSON tables, see Granting or Denying Access to Fields with Access-Control Expressions. |
defaultwriteperm | The default Access Control Expression for the write permission on new
column families that are created in this table. If no value is specified,
the default is u:<username of the table creator> .
This value of the parameter writeperm in the table
cf create and table cf edit commands overrides
this value.For more information about this permission as it applies to JSON tables, see Granting or Denying Access to Fields with Access-Control Expressions. |
defaulttraverseperm | Applies to JSON tables only: The default Access Control Expression for the traverse permission on new column families. For more information about this permission, see Granting or Denying Access to Fields with Access-Control Expressions. |
defaultappendperm | Applies to binary tables only:
The default Access Control Expression for the append permission on new
column families that are created in this table. If no value is specified,
the default is u:<username of the table creator> .
This value of the parameter appendperm in the table
cf create and table cf edit commands overrides
this value. |
regionsizemb
for the
mytable
table: - CLI
-
maprcli table edit -path /volume1/mytable -regionsizemb 8192
- REST
-
https://r1n1.sj.us:8443/rest/table/edit?path=%2Fvolume1%2Fmytable®ionsizemb=8192