Available in VPC
Overview
Test whether the Cloud DB for MySQL (VPC) database created in the user account can be integrated with the Cloud Hadoop Hive metastore.
For each cluster, you can only add one integrated account in the form of USER_ID + HOST(IP).
Integration is only possible with MySQL 8.0.x, and is only supported when the Cloud DB for MySQL (VPC) status is Running.
When the TEST CONNECTION feature is performed, a database in the form of hive_*_CHadoop is created.
Only the DDL permission is supported for the metastore linked accounts.
As a preliminary task, you must add the ACG used by Cloud Hadoop to Cloud DB for MySQL (VPC) and allow all communications for normal integration.
Request
Request parameters
| Parameter name | Required | Type | Restrictions | Description |
|---|---|---|---|---|
| regionCode | No | String | - Region code - Determine the Region to test whether Hive metastore can be integrated. - regionCode can be obtained through the getRegionList action. - Default: Select the first Region of the getRegionList search results. |
|
| cloudHadoopInstanceNo | Yes | String | - Cloud Hadoop instance number - You can obtain cloudHadoopInstanceNo through the getCloudHadoopInstanceList action. |
|
| cloudMysqlInstanceNo | Yes | String | - Number of Cloud DB for MySQL (VPC) instance to test whether Hive metastore can be integrated - cloudMysqlInstanceNo can be obtained through the getCloudHadoopMysqlInstanceList action. |
|
| cloudMysqlUserName | Yes | String | - Access username of Cloud DB for MySQL (VPC) to test whether Hive metastore can be integrated - You can obtain cloudMysqlUserName through the getCloudHadoopMysqlUserList action. |
|
| cloudMysqlUserPassword | Yes | String | It must have at least one English letter, one special character, and one number. ` & + \ " ' / and spaces can't be used in passwords. Min: 8 Max: 20 |
- Access user password of Cloud DB for MySQL (VPC) to test whether Hive metastore can be integrated |
| output | No | String | - Format type of the response result - Options: xml | json - Default: xml |
Examples
Call
ncloud vhadoop testConnectExternalHiveMetaStore --regionCode KR --cloudHadoopInstanceNo 821*** --cloudMysqlInstanceNo 823*** --cloudMysqlUserName test** --cloudMysqlUserPassword ******
Response
<testConnectExternalHiveMetaStoreResponse>
<requestId>65544ec3-8da6-4bf1-9b0c-5957d110bd42</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
</testConnectExternalHiveMetaStoreResponse>