table create
Creates a HPE Ezmeral Data Fabric Database binary or JSON table.
Permissions Required
To run this command, your user ID must have the following permissions:
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 |
|
REST |
|
Parameters
Parameter |
Description |
---|---|
path |
The path to the new HPE Ezmeral Data Fabric Database table.
|
copymetafrom |
The path to a table that contains the metadata that should be used to create the table.
|
copymetatype |
The type of metadata to copy from the table identified in the
|
regionsizemb |
The average size of the regions into which HPE Ezmeral Data Fabric Database 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, HPE Ezmeral Data Fabric Database ignores the
regionsizemb parameter and splits regions at a lower threshold. |
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 |
bulkload |
A Boolean value that specifies whether to allow a full bulk
load of the table. The default is |
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. |
tabletype | Specifies whether the table will be a binary table or
a JSON table. The values are binary and json .
The default is binary . |
packperm | The Access Control Expression (ACE) that controls who can pack table regions. By default, permission is given to the user ID that is used to create the table. |
bulkloadperm | The ACE 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 is used to create the table. |
splitmergeperm |
The ACE that controls who can take the following actions:
By default, permission is given to the user ID that is used to create the table. |
createrenamefamilyperm | The ACE 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 is used to create the table. |
deletefamilyperm | The ACE 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 is used to create the table. |
adminaccessperm | The ACE that controls who can view and edit the permissions for this table. By default, permission is given to the user ID that is used to create the table. |
replperm | The ACE 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 |
indexperm | The secondary index Admin permissions setting that controls who can create an index associated with this table. By default, permission is given to the user ID that is used to create the table. |
defaultversionperm |
The default ACE 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 ACE 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 ACE 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 ACE 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.
See table cf create and table cf edit
|
defaultwriteperm | The default ACE 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.
See table cf create and table cf edit
|
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 Permission Types for Fields and Column Families in JSON Tables. |
defaultappendperm | Applies to binary tables only:
The default ACE 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. |
defaultunmaskedreadperm | The defaultunmaskedreadperm permission on table creation is
set to the table creator. This setting takes effect for all new column families (and
therefore also all columns/fields within all column families) unless otherwise
overridden by the maprcli table cf or the maprcli table cf
colperm command. This permission allows the user to read the data
unmasked. Users without this permission have the masked data returned. |
metricsinterval |
The metrics collection interval, in seconds, for the table. Possible values: 10, 60, 600 Default: 60 seconds When configured to 10 seconds, under normal workloads, the metrics are available in OpenTSDB in about 30 seconds. At an interval of 60 seconds, the metrics are available in about 90 seconds. NOTE You cannot disable metrics collection for a table by setting the interval to
0. |
securitypolicy | The
security policy or policies that apply to the table. If the parameter is not
specified during table creation, the default value is uninitialized
("[-]" ), and there is no security policy for the
table. |
Example
Creates a HPE Ezmeral Data Fabric Database
table named newtable
in volume1
:
CLI |
|
REST |
|