getCloudHadoopMysqlUserList
- Print
- PDF
getCloudHadoopMysqlUserList
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Available in VPC
Search user list of Cloud DB for MySQL (VPC), which will be connected to Cloud Hadoop Hive metastore.
Requests
Request Parameters
| Parameter Name | Requirement Status | Type | Restrictions | Description |
|---|---|---|---|---|
| regionCode | No | String | - Region code - Able to determine a region to test whether the Hive metastore can be connected - The regionCode can be obtained by the getRegionList action. Default: the first Region of the getRegionList search results is selected. | |
| cloudMysqlInstanceNo | Yes | String | - The instance number of Cloud DB for MySQL (VPC) to be connected to the Hive metastore - Only the Cloud DB for MySQL (VPC) user information with only the DDL permissions can be searched. - The cloudMysqlInstanceNo can be obtained by the getCloudHadoopMysqlInstanceList action. | |
| responseFormatType | No | String | - Format type of the response result - Options: xml | json - Default: xml |
Request headers
See Cloud Hadoop(VPC) overview.
Request bodies
{
"regionCode": "string",
"cloudMysqlInstanceNo": "string",
"responseFormatType": "string"
}
Responses
Response bodies
{
"requestId": "string",
"returnCode": "string",
"returnMessage": "string",
"totalRows": 0,
"cloudMysqlUserListForHiveMetaStore": {
"CloudMysqlUserListForHiveMetaStore": [
{
"userName": "string",
"hostIp": "string",
"authority": "string"
}
]
}
}
Errors
See Cloud Hadoop(VPC) overview
Examples
Request Examples
GET {API_URL}/getCloudHadoopMysqlUserList
?regionCode=KR
&cloudMysqlInstanceNo=823***
Response examples
{
"CloudMysqlUserListForHiveMetaStoreResponse": {
"totalRows": 1,
"cloudMysqlUserListForHiveMetaStore": [
{
"userName": "test",
"hostIp": "%",
"authority": "DDL"
}
],
"requestId": "678dc377-a8f1-4848-a96e-492dbf9529fc",
"returnCode": "0"
}
}
<CloudMysqlUserListForHiveMetaStoreResponse>
<requestId>305113ee-d4b7-4709-805b-0a59aba07bc4</requestId>
<returnCode>0</returnCode>
<totalRows>1</totalRows>
<cloudMysqlUserListForHiveMetaStore>
<cloudMysqlUserForHiveMetaStore>
<userName>****</userName>
<hostIp>%</hostIp>
<authority>DDL</authority>
</cloudMysqlUserForHiveMetaStore>
</cloudMysqlUserListForHiveMetaStore>
</CloudMysqlUserListForHiveMetaStoreResponse>
Was this article helpful?