Retrieves a paginated list of databases in a data lake. You can match databases by name.
Try it now
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
dlf:ListDatabases |
list |
*All Resource
|
None | None |
Request syntax
GET /api/metastore/catalogs/databases/list HTTP/1.1
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| CatalogId |
string |
No |
The namespace for database categorization. By default, this is the UID of the Alibaba Cloud account. |
1344371 |
| NamePattern |
string |
No |
A regular expression that matches database names. To match all databases, enter .*. |
.* |
| NextPageToken |
string |
No |
The token to retrieve the next page of results. This is returned in the response. For the first page, pass an empty string (""). |
2cb472ec1bf84f8d92f9c4baa0d21c19aa! |
| PageSize |
integer |
No |
The number of entries to return on each page. |
10 |
NamePattern: The name pattern of the databases to query. Wildcard matching is supported. A period (.) matches a single character, and an asterisk (*) matches any number of characters.
NextPageToken: The token used for pagination. Leave this parameter empty for the first request. For subsequent requests, set this parameter to the NextPageToken value from the previous response. An empty string returned for this parameter indicates that all results have been retrieved.
PageSize: The number of entries to return in a single response.
Response elements
|
Element |
Type |
Description |
Example |
|
object |
The response body. |
||
| Code |
string |
The status of the request. |
OK |
| Databases |
array |
The list of metadatabases. |
[{"name":"test"}] |
| Database |
The query result for the metadatabase. |
||
| Message |
string |
The error message. |
. |
| NextPageToken |
string |
The token for the next page of results. |
2cb472ec1bf84f8d92f9c4baa0d21c19aa |
| RequestId |
string |
The request ID. |
558D764F-8C55-49CA-BF38-80EA532FC08F |
| Success |
boolean |
Indicates whether the request was successful. |
true |
Description of error codes for the Code parameter
InternalError: An internal error occurred. For more information, see the Message parameter.
Examples
Success response
JSON format
{
"Code": "OK",
"Databases": [
{
"CreateTime": 1608707407,
"Description": "this is a hive database",
"LocationUri": "/hdfs/hivedb/data",
"Name": "database_test",
"OwnerName": "zhangsan",
"OwnerType": "USER",
"Parameters": {
"key": "key"
},
"Privileges": {
"GroupPrivileges": {
"key": [
{
"CreateTime": 1606226844,
"GrantOption": true,
"Grantor": "Grantor",
"GrantorType": "GrantorType",
"Privilege": "Privilege"
}
]
},
"RolePrivileges": {
"key": [
{
"CreateTime": 1606226844,
"GrantOption": true,
"Grantor": "Grantor",
"GrantorType": "GrantorType",
"Privilege": "Privilege"
}
]
},
"UserPrivileges": {
"key": [
{
"CreateTime": 1606226844,
"GrantOption": true,
"Grantor": "Grantor",
"GrantorType": "GrantorType",
"Privilege": "Privilege"
}
]
}
},
"UpdateTime": 1608707407,
"CreatedBy": "root"
}
],
"Message": ".",
"NextPageToken": "2cb472ec1bf84f8d92f9c4baa0d21c19aa",
"RequestId": "558D764F-8C55-49CA-BF38-80EA532FC08F",
"Success": true
}
Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.