Viewing Table Settings

Describes how to view table settings using the Control System, the CLI or the Rest API.

Viewing Table Settings Using the Control System

Procedure

Log in to the Control System and go to the Summary tab in the table information page to view the following settings.
NOTE
Some properties are only applicable to binary tables.
Throughput - By Op Type
This pane displays a graph for the operations on the table in the last hour. For more information, see Monitoring Tables.
Region Data Distribution by Node
This pane shows the distribution of the table or secondary index regions across the nodes in the cluster. For more information, see Monitoring Tables.
Properties
This pane shows the current value for the following table properties:
Table Path The path to the table on the file system.
Table Type The type of table. Value can be one of the following:
  • JSON
  • Binary
Total Rows The total number of rows in the table.
Region Size 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.
Total Logical Size The estimated size (in bytes) of uncompressed data stored in table (excluding replication).
Total Physical Size The estimated size (in bytes) of actual data stored in table (excluding replication). This includes internal metadata and reflects compressed data size when compression is enabled.
Auditing The setting to enable or disable auditing of operations on the table.
Auto Split The setting to automatically split the table into regions as the table grows.
Bulkload Type The setting to allow a full bulk load of the table.
Metrics Interval The table metrics collection interval, in seconds.
Security
This pane shows the following security settings on the table:
Security Policy The security policies associated with this table including:
  • Name of the security policy
  • Status of the security policy. Lists the path of the table location, name of table column families, and name of associated fields, if any. Click a listed security policy or + (plus sign) to add an additional security policy, or drill down through the listing under Name column, where the Add Field is displayed and add another data field to the table. Remove a security policy by clicking the security policy name to be deleted and then click - (minus sign) from the subsequent screen.
    NOTE
    No warning confirmation screen is displayed whenever you opt to delete a security policy from the Security pane of the table information page.
  • Access control expression in the security policy
Audit Whether or not auditing is enabled for table operations.
Table Admin Control
This pane shows the entities (users, groups, and/or roles) that have and/or do not have one or more of the following types of permissions to administer the table:
Admin (Access Control) 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.
Index Can create index for this table. This permission is for JSON tables only.
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.

Viewing Table Settings Using the CLI and REST API

About this task

The basic command to retrieve table information is the following: 
/opt/mapr/bin/maprcli table info -path <tablePath> -json
Send a request of type GET to retrieve table details. For example: 
curl -X GET 'https://<hostname>:8443/rest/table/info?path=<tablePath>' --user <username>:<pwd>
For more information on the settings, see the table info command.