Listing Column Families
Explains how to view the column families for a table using either the Control System or the CLI.
Viewing Table Column Families Using the Control System
About this task
Procedure
- Go to the table information page.
-
Click the Column Families tab.
The page displays the default permissions for the column families in the Default Column Family Authorization pane, and for each column family, the All pane displays:
Selecting the checkbox associated with the column family makes the Remove Column Family button available. You can:Column Name Column Description Column Family Name The name of the column family. JSON Path The JSON path for the column in the JSON file in dotted notation. Compression The compression scheme used for the column family. Time-to-Live The amount of time to keep the data in the column family. In Memory Whether or not this column value resides in memory.
Viewing Table Column Families Using the CLI or REST API
About this task
The command to list the column families that are in a table
is:
maprcli table cf list -path <path> -cfname <name_of_column_family>
The format of the value of the -path
parameter depends on
whether you are viewing a table on a local cluster or a remote cluster:
- 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
To use the following characters in the table name, enclose them either in single or double quotes:NOTEYou cannot use the following characters in the table name:< > ? % \
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 '/"設備^=#;{}&()/'
To run this command, your user ID must have the following permissions:
readAce
on the volumelookupdir
on directories in the pathsadminaccessperm
on the table
For complete reference, see the table cf list
command.