getSchemasByCluster

getSchemasByCluster(clusterName, catalogName)

clusterName is a STRING scalar indicating the name of the cluster.

catalogName is a STRING scalar indicating the name of the catalog.

Return all schemas under the specified catalog in the cluster. This function can only be executed by an administrator on the MoM (Master of Masters) cluster.

Return value: A table with the following columns:

• schema: A string indicating the name of the schema.
• dbUrl: A string indicating the path of the database.

Examples

// MoMSender cluster: 
database(directory="dfs://db1", partitionType=RANGE, partitionScheme=0 5 10)
database(directory="dfs://db2", partitionType=RANGE, partitionScheme=0 5 10)
createSchema("catalog1", "dfs://db1", "schema1")
createSchema("catalog1", "dfs://db2", "schema2")

// MOM cluster: 
getSchemasByCluster("MoMSender", "catalog1")