table cf column list

Lists column-level attributes including any dynamic data masking properties set for JSON table columns.

Syntax

CLI
maprcli table cf column list -path <table-path>
  -cfname <column family name>
  [ -name <column-name>  
REST
http[s]://<host>:<port>/rest/table/cf/column/list?<parameters> 

Parameters

Parameter

Description

path

The path to the HPE Ezmeral Data Fabric Database table.

  • 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 under volume1 in the sanfrancisco cluster, specify the following path:/mapr/sanfrancisco/volume1/customer
cfname The name of the column family of the JSON table field.
name The JSON column family feld to list attributes. If omitted, all columns for the specified column family that have associated column-level attributes are returned.

Example

In the following example, only user mapr can read column Creditcard from the default CF of table /table1 unmasked. User user1 can read the Creditcard column, but it will be masked:

CLI
maprcli table cf colperm set -path /table1--cfname default \ 
-name Creditcard –readperm "u:user1|u:mapr" -unmaskedreadperm "u:mapr" \ 
-writeperm "u:mapr" 

maprcli table cf column securitypolicy set -path /table1 -cfname default \ 
-name Creditcard -securitypolicy pci 

maprcli table cf column datamask set –path /table1 -cfname default \ 
-name Creditcard -datamask mrddm_last4 

maprcli table cf column list -path /table1 -cfname default -json 

{ 

  "timestamp":1612303576139, 

  "timeofday":"2021-02-02 02:06:16.139 GMT-0800 PM", 

  "status":"OK", 

  "total":1, 

  "data":[ 

    { 

      "name":"Creditcard", 

      "aces": { 

        "readperm":"u:user1|u:mapr", 

        "unmaskedreadperm":"u:mapr", 

        "writeperm":"u:mapr" 

      }, 

      "securitypolicy":"pci", 

      "datamask":"mrddm_last4" 

    } 

  ]