• PDF


    • PDF

    Article Summary

    Available in VPC

    Search user list of Cloud DB for MySQL (VPC), which will be connected to Cloud Hadoop Hive metastore.


    Request Parameters

    Parameter NameRequirement StatusTypeRestrictionsDescription
    regionCodeNoString- 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.
    cloudMysqlInstanceNoYesString- 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.
    responseFormatTypeNoString- 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"


    Response bodies

      "requestId": "string",
      "returnCode": "string",
      "returnMessage": "string",
      "totalRows": 0,
      "cloudMysqlUserListForHiveMetaStore": {
        "CloudMysqlUserListForHiveMetaStore": [
            "userName": "string",
            "hostIp": "string",
            "authority": "string"


    See Cloud Hadoop(VPC) overview


    Request Examples

    GET {API_URL}/getCloudHadoopMysqlUserList

    Response examples

      "CloudMysqlUserListForHiveMetaStoreResponse": {
        "totalRows": 1,
        "cloudMysqlUserListForHiveMetaStore": [
            "userName": "test",
            "hostIp": "%",
            "authority": "DDL"
        "requestId": "678dc377-a8f1-4848-a96e-492dbf9529fc",
        "returnCode": "0"

    Was this article helpful?

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.