testConnectExternalHiveMetaStore
- Print
- PDF
testConnectExternalHiveMetaStore
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Available in VPC
Overview
Test whether the Cloud Hadoop Hive metastore can be connected 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) and all communications 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 test connection availability to the Hive metastore - A regionCode can be obtained by the getRegionList action. - Select the first region from the Default: getRegionList query result | |
| 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 test connection availability 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 test connection availability to the Hive metastore. - The cloudMysqlUserName can be obtained by the getCloudHadoopMysqlUserList action. | |
| cloudMysqlUserPassword | Yes | String | - Access user password of Cloud DB for MySQL (VPC) to test connectivity to the Hive metastore. - The cloudMysqlUserPassword can be obtained by the getCloudHadoopMysqlUserList action. | |
| output | No | String | - Format type of response result - Options: xml | json - Default: xml |
Examples
Call
ncloud vhadoop testConnectExternalHiveMetaStore --regionCode KR --cloudHadoopInstanceNo 821*** --cloudMysqlInstanceNo 823*** --cloudMysqlUserName test** --cloudMysqlUserPassword ******
Responses
<testConnectExternalHiveMetaStoreResponse>
<requestId>65544ec3-8da6-4bf1-9b0c-5957d110bd42</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
</testConnectExternalHiveMetaStoreResponse>
Was this article helpful?