saveExternalHiveMetaStore
- Print
- PDF
saveExternalHiveMetaStore
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Available in VPC
Connect the Cloud Hadoop Hive metastore to the Cloud DB for MySQL (VPC) database created in a user account.
Only 1 connected account per cluster can be added in the unit of USER_ID + HOST(IP).
Connection is available only in MySQL version 5.7.x and the feature is supported only when Cloud DB for MySQL (VPC) is in operation.
When performing the test connection feature, a database in the form of hive_*_CHadoop is created.
The metastore connected account supports only the DDL permission.
For preparations, ACGs used in Cloud Hadoop need to be added to Cloud DB for MySQL (VPC) ACG and all communications (1-65535) need to be allowed for valid connections.
Requests
Request Parameters
| Parameter name | Requirement status | Type | Restrictions | Description |
|---|---|---|---|---|
| regionCode | No | String | - Region code - Able to determine a region to be connected to the Hive metastore - The regionCode can be obtained by the getRegionList action. - Default: the first Region of the getRegionList search results is selected. | |
| cloudHadoopInstanceNo | Yes | String | - The instance number of Cloud Hadoop - The cloudHadoopInstanceNo can be obtained by the getCloudHadoopInstanceList action. | |
| cloudMysqlInstanceNo | Yes | String | - The instance number of Cloud DB for MySQL (VPC) to be connected to the Hive metastore - The cloudMysqlInstanceNo can be obtained by the getCloudHadoopMysqlInstanceList action. | |
| cloudMysqlUserName | Yes | String | - Access user name of Cloud DB for MySQL (VPC) to be connected to the Hive metastore - The cloudMysqlUserName can be obtained by the getCloudHadoopMysqlUserList action. | |
| cloudMysqlUserPassword | Yes | String | It must have at least 1 of each of English letter, special character, and number. The following characters cannot be used in the password: ` & + \ " ' / space Min: 8 Max: 20 | - Access user password of Cloud DB for MySQL (VPC) to be connected to the Hive metastore |
| responseFormatType | No | String | - Format type of the response result - Options: xml | json - Default: xml |
Request bodies
{
"regionCode": "string",
"cloudHadoopInstanceNo": "string",
"cloudMysqlInstanceNo": "string",
"cloudMysqlUserName": "string",
"cloudMysqlUserPassword": "string",
"responseFormatType": "string"
}
Responses
Response bodies
{
"saveExternalHiveMetaStoreResponse": {
"requestId": "string",
"returnCode": "string",
"returnMessage": "string"
}
}
Errors
See Cloud Hadoop(VPC) overview.
Examples
Request Examples
GET {API_URL}/saveExternalHiveMetaStore
?regionCode=KR
&cloudHadoopInstanceNo=821***
&cloudMysqlInstanceNo=823***
&cloudMysqlUserName=test**
&cloudMysqlUserPassword=******
Response examples
{
"saveExternalHiveMetaStoreResponse": {
"requestId": "7b3e5aee-6b86-4d47-a5c0-36c0f7a932bd",
"returnCode": "0",
"returnMessage": "success"
}
}
<saveExternalHiveMetaStoreResponse>
<requestId>65544ec3-8da6-4bf1-9b0c-5957d110bd42</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
</saveExternalHiveMetaStoreResponse>
Error examples
{
"responseError": {
"returnCode": "5001352",
"returnMessage": "The CloudHadoop cluster is already linked to CDB for MySQL products."
}
}
Was this article helpful?