getCloudHadoopMysqlUserList

Article summary

Did you find this summary helpful?

Thank you for your feedback

The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.

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	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?

What's Next

getCloudHadoopObjectList

Table of contents

Requests
Responses
Errors
Examples