MENU
      getCloudHadoopMysqlUserList

        getCloudHadoopMysqlUserList


        Article summary

        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 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"
        }
        JSON

        Responses

        Response bodies

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

        Errors

        See Cloud Hadoop(VPC) overview

        Examples

        Request Examples

        GET {API_URL}/getCloudHadoopMysqlUserList
        ?regionCode=KR
        &cloudMysqlInstanceNo=823***
        HTTP

        Response examples

        {
          "CloudMysqlUserListForHiveMetaStoreResponse": {
            "totalRows": 1,
            "cloudMysqlUserListForHiveMetaStore": [
              {
                "userName": "test",
                "hostIp": "%",
                "authority": "DDL"
              }
            ],
            "requestId": "678dc377-a8f1-4848-a96e-492dbf9529fc",
            "returnCode": "0"
          }
        }
        JSON
        <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>
        XML

        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.