testConnectExternalHiveMetaStore
  • PDF

testConnectExternalHiveMetaStore

  • PDF

Can be used in a VPC environment.

Overview

It tests whether linkage between the Cloud Hadoop Hive metastore and the Cloud DB for MySQL (VPC) database created in the user account is possible.

You can link and use metastores with Cloud DB for MySQL (VPC).
Link the Cloud Hadoop Hive metastore
to the Cloud DB for MySQL (VPC) database created in the user account.
For each cluster, you can only add one linkage account in the form of USER_ID + HOST (IP).

Linkage is only possible in the MySQL 5.7.x version, and this feature is only supported when the Cloud DB for MySQL (VPC) status is Running.
When running the TEST CONNECTION feature, a database in the hive_*_CHadoop format is created.
Only the DDL permission is supported for the metastore linkage accounts.

As a preliminary task, add the ACG used in Cloud Hadoop to the Cloud DB for MySQL (VPC) ACG and allow all communication for normal interworking.

Request

Request parameter

Parameter name Requirement status Type Restrictions Description
regionCode No String - Region code
- You can decide the region to test whether Hive metastore linkage is possible.
- You can obtain the regionCode through the getRegionList action.
- Default: Selects the first region of the getRegionList search results.
cloudHadoopInstanceNo Yes String - Cloud Hadoop instance number
- You can obtain the cloudHadoopInstanceNo through the getCloudHadoopInstanceList action.
cloudMysqlInstanceNo Yes String - Instance number of the Cloud DB for MySQL (VPC) to be tested for linkage with the Hive metastore
- You can obtain the cloudMysqlInstanceNo through the getCloudHadoopMysqlInstanceList action.
cloudMysqlUserName Yes String - Name of the user accessing the Cloud DB for MySQL (VPC) to be tested for linkage with the Hive metastore
- You can obtain the cloudMysqlUserName through the getCloudHadoopMysqlUserList action.
cloudMysqlUserPassword Yes String - Password of the user accessing the Cloud DB for MySQL (VPC) to be tested for linkage with the Hive metastore
- You can obtain the cloudMysqlUserPassword through the getCloudHadoopMysqlUserList action.
output No String - Format type for the response result
- Options: xml | json
- Default: xml

Examples

Request example

ncloud vhadoop testConnectExternalHiveMetaStore --regionCode KR --cloudHadoopInstanceNo 821***  --cloudMysqlInstanceNo 823*** --cloudMysqlUserName test** --cloudMysqlUserPassword ******

Response example

<testConnectExternalHiveMetaStoreResponse>
    <requestId>65544ec3-8da6-4bf1-9b0c-5957d110bd42</requestId>
    <returnCode>0</returnCode>
    <returnMessage>success</returnMessage>
</testConnectExternalHiveMetaStoreResponse>

Was this article helpful?