MENU
      getCloudHadoopMysqlInstanceList

        getCloudHadoopMysqlInstanceList


        Article summary

        Available in VPC

        Search Instance 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.
        cloudHadoopInstanceNoYesString- The Cloud Hadoop instance number connectable to the Cloud DB for MySQL (VPC) to connect the Hive metastore
        - The cloudHadoopInstanceNo can be obtained by the getCloudHadoopInstanceList action.
        responseFormatTypeNoString- Format type of the response result
        - Options: xml | json
        - Default: xml

        Request headers

        See Cloud Hadoop(VPC) overview.

        Request bodies

        {
          "regionCode": "string",
          "cloudHadoopInstanceNo": "string",
          "responseFormatType": "string"
        }
        JSON

        Responses

        Response bodies

        {
          "requestId": "string",
          "returnCode": "string",
          "returnMessage": "string",
          "totalRows": 0,
          "cloudMysqlInstanceListForHiveMetaStore": {
            "CloudMysqlInstanceListForHiveMetaStore": [
              {
                "cloudMysqlInstanceNo": "string",
                "cloudMysqlInstanceName": "string",
                "vpcName": "string"
              }
            ]
          }
        }
        JSON

        Errors

        See Cloud Hadoop(VPC) overview.

        Examples

        Request Examples

        GET {API_URL}/getCloudHadoopMysqlInstanceList
        ?regionCode=KR
        &cloudHadoopInstanceNo=823***
        HTTP

        Response examples

        {
          "CloudMysqlInstanceListForHiveMetaStoreResponse": {
            "totalRows": 1,
            "cloudMysqlInstanceListForHiveMetaStore": [
              {
                "cloudMysqlInstanceNo": "18**283",
                "cloudMysqlInstanceName": "test",
                "vpcName": "vpc4hadoop"
              }
            ],
            "requestId": "e149ea85-1da3-****-8578-7e606f2058ef",
            "returnCode": "0",
            "returnMessage": "success"
          }
        }
        JSON
        <CloudMysqlInstanceListForHiveMetaStoreResponse>
            <requestId>f2386914-c6b3-432f-83d4-2884e9039cdb</requestId>
            <returnCode>0</returnCode>
            <returnMessage>success</returnMessage>
            <totalRows>2</totalRows>
            <cloudMysqlInstanceListForHiveMetaStore>
                <cloudMysqlInstanceForHiveMetaStore>
                    <cloudMysqlInstanceNo>****855</cloudMysqlInstanceNo>
                    <cloudMysqlInstanceName>****sc</cloudMysqlInstanceName>
                    <vpcName>****-vpc-exercise</vpcName>
                </cloudMysqlInstanceForHiveMetaStore>
                <cloudMysqlInstanceForHiveMetaStore>
                    <cloudMysqlInstanceNo>****222</cloudMysqlInstanceNo>
                    <cloudMysqlInstanceName>****sds</cloudMysqlInstanceName>
                    <vpcName>****-vpc-exercise</vpcName>
                </cloudMysqlInstanceForHiveMetaStore>
            </cloudMysqlInstanceListForHiveMetaStore>
        </CloudMysqlInstanceListForHiveMetaStoreResponse>
        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.