saveExternalHiveMetaStore

Prev Next

Available in VPC

Integrate a Cloud Hadoop Hive metastore with Cloud DB for MySQL.

Note

When calling the saveExternalHiveMetaStore API, please note the following:

  • Only one account can be integrated per cluster in the form of a USER_ID + HOST (IP).
  • The cluster and MySQL must be in the same VPC, and only MySQL 8.0.x versions are supported.
  • DDL permission is required for the account integrated with the metastore.
  • Preparations of adding an Cloud Hadoop ACG to the Cloud DB for MySQL ACG is required.
  • Need to check whether the Hive metastore can be integrated.

Request

This section describes the request format. The method and URI are as follows:

Method URI
GET | POST /vhadoop/v2/saveExternalHiveMetaStore
Note

This guide is based on the GET method. POST method call tests can be performed through Swagger in the API Gateway service of the NAVER Cloud Platform console.

Request headers

For information about the headers common to all Cloud Hadoop APIs, see Cloud Hadoop request headers.

Request query parameters

You can use the following query parameters with your request:

Field Type Required Description
regionCode String Optional Region code
cloudHadoopInstanceNo String Required Cluster instance number
cloudMysqlInstanceNo String Required Cloud DB for MySQL instance number
cloudMysqlUserName String Required Database user ID
cloudMysqlUserPassword String Required Database user account password
  • Enter 8 to 20 characters using a combination of English letters, numbers, and special characters.
  • Unusable special characters: ', ", `, &, +, /, , space
responseFormatType String Optional Format of the response data
  • xml (default) | json

Request example

The request example is as follows:

curl --location --request GET 'https://ncloud.apigw.ntruss.com/vhadoop/v2/saveExternalHiveMetaStore?regionCode=KR&cloudHadoopInstanceNo=2707****&cloudMysqlInstanceNo=18*****&cloudMysqlUserName=test&cloudMysqlUserPassword=***********&responseFormatType=json' \
--header 'x-ncp-apigw-timestamp: {Timestamp}' \
--header 'x-ncp-iam-access-key: {Access Key}' \
--header 'x-ncp-apigw-signature-v2: {API Gateway Signature}'

Response

This section describes the response format.

Response body

The response body includes the following data:

Field Type Required Description
saveExternalHiveMetaStoreResponse Object - Response result
saveExternalHiveMetaStoreResponse.requestId String - ID for the request
  • UUID format
saveExternalHiveMetaStoreResponse.returnCode String - Response code
saveExternalHiveMetaStoreResponse.returnMessage String - Response message

Response status codes

For information about the HTTP status codes common to all Cloud Hadoop APIs, see Cloud Hadoop response status codes.

Response example

The response example is as follows:

{
  "saveExternalHiveMetaStoreResponse": {
    "requestId": "7b3e5aee-****-****-****-36c0f7a932bd",
    "returnCode": "0",
    "returnMessage": "success"
  }
}