Listing JSON Tables

This topic describes how to list the JSON tables by using either the HPE Data Fabric Database JSON Client API or HPE Data Fabric Database Shell.

Permission Required

The readAce permission on the volumes where the JSON tables are located. Setting Whole Volume ACEs

  • Java
  • dbshell

The table is listed by calling HPE Data Fabric Database JSON Client API Admin object's listTables() method and passing, as an argument, the path of the folder.

Use a conditional loop to iterate through the returned list and retrieve the names of the tables. 

public void listTables(String parentFolder) throws DBException {
    try (Admin admin = MapRDB.newAdmin()) {
        for(Path tablePath : admin.listTables(parentFolder)) {
            System.out.println(tablePath);
        }
    }
}
NOTE
The parameter parentFolder provides a path to a folder that is in the filesystem. See "Table Paths" in HPE Data Fabric Database JSON Tables for examples.
# mapr dbshell
maprdb root:> list /demo
/demo/user
/demo/checkin
/demo/review
/demo/business
/demo/tip
5 table(s) found.

See dbshell list for further details.